public static DataSet Search_KursusPolicy(string Search, KursusStatusEnum Status, int CompanyID)
{
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
bool flag = false;
DBAccess db = new DBAccess();
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(_SQLSelectBySearch);
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
}
return(ds);
}
public static int Insert(int CompanyID, KursusStatusEnum Status, string FirstAidTitle, int FirstAidAftale, int FirstAidLeverandor, int FirstAidKursusType, int FirstAidAdminAftale, int FirstAidRepetition, int FirstAidMedarbInfo)
{
KursusPolicy c = new KursusPolicy();
c.CompanyID = CompanyID;
c.Status = Status;
c.FirstAidTitle = FirstAidTitle;
c.FirstAidAftale = FirstAidAftale;
c.FirstAidLeverandor = FirstAidLeverandor;
c.FirstAidKursusType = FirstAidKursusType;
c.FirstAidAdminAftale = FirstAidAdminAftale;
c.FirstAidRepetition = FirstAidRepetition;
c.FirstAidMedarbInfo = System.Convert.ToString(FirstAidMedarbInfo);
return(Insert(c));
}
public static int Update(int ID, int CompanyID, KursusStatusEnum Status, string FirstAidTitle, int FirstAidAftale, int FirstAidLeverandor, int FirstAidKursusType, int FirstAidAdminAftale, int FirstAidRepetition, int FirstAidMedarbInfo)
{
KursusPolicy c = new KursusPolicy(ID);
c.CompanyID = CompanyID;
if (Status == KursusStatusEnum.Initialize)
{
Status = KursusStatusEnum.Aktiv;
}
c.Status = Status;
c.FirstAidTitle = FirstAidTitle;
c.FirstAidAftale = FirstAidAftale;
c.FirstAidLeverandor = FirstAidLeverandor;
c.FirstAidKursusType = FirstAidKursusType;
c.FirstAidAdminAftale = FirstAidAdminAftale;
c.FirstAidRepetition = FirstAidRepetition;
c.FirstAidMedarbInfo = System.Convert.ToString(FirstAidMedarbInfo);
return(Update(c));
}
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);
}
public static DataSet Search_KursusPolicy(string Search, KursusStatusEnum Status)
{
return(Search_KursusPolicy(Search, Status, System.Convert.ToInt32(KursusStatusEnum.Alle)));
}
public static int Update(int ID, int KursusPolicyID, DateTime KursusDato, bool Repetionskursus, KursusStatusEnum Status)
{
KursusDag c = new KursusDag(ID);
c.KursusPolicyID = KursusPolicyID;
c.KursusDato = KursusDato;
c.Repetionskursus = Repetionskursus;
c.Status = Status;
return(Update(c));
}
