using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace SaSMS
{
class dataInterface
{
#region Internal variables...
/// <summary>
/// Hostname of my database
/// </summary>
private string _db = string.Empty;
/// <summary>
/// Username of my databaseUser
/// </summary>
private string _dbUser = string.Empty;
/// <summary>
/// Password of my databaseUser
/// </summary>
private string _dbPass = string.Empty;
/// <summary>
/// True if connected by trusted connection
/// </summary>
private Boolean _dbTrusted = false;
/// <summary>
/// Oledb link to our database
/// </summary>
private SqlConnection _dbCon;
public SaSMS.SaSMS_User User = new SaSMS.SaSMS_User(this);
#endregion
#region constructors
/// <summary>
/// Constructor for trusted connection
/// </summary>
/// <param name="db"></param>
/// <param name="dbName"></param>
public dataInterface(string db,string dbName)
{
string strconString = "Server=" + db + ";Database=" + dbName + ";Trusted_Connection=True;";
try
{
_dbCon = new SqlConnection(strconString);
_dbCon.Open();
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
}
finally
{
this._dbTrusted = true;
}
}
/// <summary>
/// Constructor that connnect's to SaSMS database with mixed sercurity
/// </summary>
/// <param name="db">Hostname of the SQLDatabase</param>
/// <param name="dbUser">Username of the databaseUser</param>
/// <param name="dbPass">Password of the DatabaseUser</param>
/// <param name="dbName">The name of the database</param>
/// <returns>True on sucess</returns>
public dataInterface(string db, string dbUser, string dbPass, string dbName)
{
//ConnectionString
string strconString = "Data Source=" + db + ";Initial Catalog=" + dbName +
";User Id=" + dbUser + ";Password=" + dbPass + ";";
try
{
_dbCon = new SqlConnection(strconString);
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
}
finally
{
this._dbTrusted = false;
}
}
#endregion
#region User methods...
/// <summary>
/// Return a list of users in SaSMS Database...
/// </summary>
/// <returns>ArrayList of users in SaSMS</returns>
public System.Collections.ArrayList getUserlist()
{
System.Collections.ArrayList alTmp = new System.Collections.ArrayList();
foreach (System.Data.DataRow test2 in this.dbQuery("Select [Navn] from Kode_bruger order by Navn").Tables[0].Rows)
{
alTmp.Add(test2.ItemArray[0]);
}
return alTmp; //this.dbQuery("Select [Navn] from Kode_bruger").Tables[0].Rows[0].ItemArray;
}
#endregion
#region Raw database methods...
/// <summary>
/// Preform a Query in the SaSMS database
/// </summary>
/// <param name="sqlQuery">SQL Query</param>
/// <returns>Dataset with data</returns>
public System.Data.DataSet dbQuery(string sqlQuery)
{
//His der ikke er forbindelse til database så forbind...
if (_dbCon.State != ConnectionState.Open)
_dbCon.Open();
SqlDataAdapter _sqlA = new SqlDataAdapter(sqlQuery, _dbCon);
DataSet _tmpreturn = new DataSet();
try{
_sqlA.Fill(_tmpreturn,"0");
if (_tmpreturn.Tables[0].Rows.Count == 0)
return null;
return _tmpreturn;
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
}
return null;
}
#endregion
}
}
