public static System.Collections.Generic.List <KursusPolicy> GetKursusPolicyList(int CompanyID)
{
System.Collections.Generic.List <KursusPolicy> result = new System.Collections.Generic.List <KursusPolicy>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
SqlDataReader dr = default(SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectIDByCompanyID));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
result.Add(KursusPolicy.GetKursusPolicy(ID));
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
public static System.Collections.Generic.List <KursusPolicy> Search_KursusPolicyList(string search, KursusStatusEnum status, int CompanyID)
{
System.Collections.Generic.List <KursusPolicy> result = new System.Collections.Generic.List <KursusPolicy>();
int ID = -1;
DBAccess db = new DBAccess();
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
bool flag = false;
db.AddInt("CompanyID", CompanyID);
string[] arr = search.Split(' ');
foreach (string s in arr)
{
db.AddNVarChar("Search", s, 250);
db.AddInt("Status", System.Convert.ToInt32(status));
db.AddInt("CompanyID", CompanyID);
dsTemp = db.ExecuteDataSet(_SQLSelectIDBySearch);
db.Parameters.Clear();
//If dsTemp.Tables.Count > 0 Then
ds.Merge(dsTemp);
if (flag == false)
{
DataColumn[] pk = new DataColumn[2];
pk[0] = ds.Tables[0].Columns["ID"];
ds.Tables[0].PrimaryKey = pk;
flag = true;
}
//End If
}
foreach (DataRow row in ds.Tables[0].Rows)
{
ID = System.Convert.ToInt32(row["ID"]);
result.Add(KursusPolicy.GetKursusPolicy(ID));
}
return(result);
}