public bool UpdateMasterCheckList(MasterCheckListObj CurCheckList)
{
bool flag = false;
if (this.TryConnection())
{
DatabaseParameters values = new DatabaseParameters();
DatabaseParameters keys = new DatabaseParameters();
keys.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCheckList.InternalID.ActualFieldName, CurCheckList.InternalID));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCheckList.CheckListActive.ActualFieldName, CurCheckList.Active ? "1" : "0"));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCheckList.ChecklistQuestion.ActualFieldName, CurCheckList.Question.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCheckList.CheckListSeq.ActualFieldName, CurCheckList.Seq.ToString()));
values.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCheckList.CheckListType.ActualFieldName, CurCheckList.Type.ToString()));
base.CurSQLFactory.UpdateCommand(keys, values, this.DataStructrure.Tables.MasterCheckList.ActualTableName);
if (!(flag = base.CurDBEngine.ExecuteQuery(base.CurSQLFactory.SQL)))
{
base.error_occured = true;
string errMsg = base.ErrMsg;
base.ErrMsg = errMsg + "[MasterCheckListManager] : UpdateMasterCheckList : " + base.CurSQLFactory.SQL + " : " + base.CurDBEngine.ErrorMessage;
}
return(flag);
}
base.error_occured = true;
base.ErrMsg = base.ErrMsg + "[MasterCheckListManager] : UpdateMasterCheckList : " + base.ErrMsg;
return(flag);
}
public MasterCheckListCollection GetMasterCheckListByType(string CheckListType)
{
MasterCheckListCollection lists = null;
if (this.TryConnection())
{
DatabaseParameters parameters = new DatabaseParameters();
parameters.Add(new DatabaseParameter(this.DataStructrure.Tables.MasterCheckList.CheckListType.ActualFieldName, CheckListType));
base.CurSQLFactory.SelectCommand(parameters, this.DataStructrure.Tables.MasterCheckList.ActualTableName);
base.CurSQLFactory.SQL = base.CurSQLFactory.SQL + " Order By checklist_seq";
DataTable table = base.CurDBEngine.SelectQuery(base.CurSQLFactory.SQL);
if (table != null)
{
lists = new MasterCheckListCollection();
foreach (DataRow row in table.Rows)
{
MasterCheckListObj obj2 = new MasterCheckListObj(row[this.DataStructrure.Tables.MasterCheckList.InternalID.ActualFieldName].ToString())
{
Question = row[this.DataStructrure.Tables.MasterCheckList.ChecklistQuestion.ActualFieldName].ToString(),
Type = row[this.DataStructrure.Tables.MasterCheckList.CheckListType.ActualFieldName].ToString(),
Active = row[this.DataStructrure.Tables.MasterCheckList.CheckListActive.ActualFieldName].ToString().CompareTo("0") == 0,
Seq = Convert.ToInt32(row[this.DataStructrure.Tables.MasterCheckList.CheckListSeq.ActualFieldName].ToString())
};
lists.Add(obj2);
}
return(lists);
}
base.error_occured = true;
base.ErrMsg = "[MasterCheckListManager] : GetMasterCheckListByType : " + base.CurDBEngine.ErrorMessage;
return(lists);
}
base.error_occured = true;
base.ErrMsg = "[MasterCheckListManager] : GetMasterCheckListByType : " + base.ErrMsg;
return(lists);
}
