public List <CandidateClearanceVm> GetList(CandidateClearanceVm p, ref string msg)
{
List <CandidateClearanceVm> items = new List <CandidateClearanceVm>();
DataTable dt = db.GetList(p, ref msg);
if (msg != "")
{
return(new List <CandidateClearanceVm>());
}
try
{
foreach (DataRow row in dt.Rows)
{
CandidateClearanceVm item = new CandidateClearanceVm();
item.Id = row["candidateClearanceId"].GetString();
item.PositionId = row["positionId"].GetString();
item.Position = row["positionName"].GetString();
item.GradeId = row["gradeId"].GetString();
item.Grade = row["gradeName"].GetString();
item.Active = row["active"].GetBool();
items.Add(item);
}
return(items);
}
catch (Exception ex)
{
msg = ef.GetExceptionMessage(ex, msg);
return(new List <CandidateClearanceVm>());
}
}
//todo
public bool DeleteOne(CandidateClearanceVm viewModel, ref string msg)
{
if (!EntryChecker.IsNotZeroOrNull(viewModel.PositionId.GetInt(), ref msg))
{
return(false);
}
return(db.DeleteOne(MapProperties(viewModel), ref msg));
}
private CandidateClearance MapProperties(CandidateClearanceVm p)
{
CandidateClearance baseObj = new CandidateClearance();
baseObj.Id = p.Id.GetInt();
baseObj.PositionId = p.PositionId.GetInt();
baseObj.GradeId = p.GradeId.GetInt();
baseObj.Active = p.Active.GetBool();
return(baseObj);
}
public CandidateClearanceVm GetOne(CandidateClearanceVm p, ref string msg)
{
try
{
return(GetList(p, ref msg).Single());
}
catch (Exception ex)
{
msg = ef.GetExceptionMessage(ex, msg);
return(new CandidateClearanceVm());
}
}
private void SaveCands()
{
string newMsg = "";
cbl.ResetVmList();
List <GradeComboVm> checkCands = CandidateClearanceCheckListBoxCon.CheckedItems.Cast <GradeComboVm>().ToList();
foreach (GradeComboVm grade in gbl1.ComboItems)
{
CandidateClearanceVm newItem = new CandidateClearanceVm();
newItem.PositionId = newId.GetString();
newItem.GradeId = grade.Id;
newItem.Active = checkCands.Exists(i => i.Id == grade.Id).GetBool();
if (cbl.AddOne(newItem, ref newMsg))
{
continue;
}
MessageBox.Show(newMsg, "Candidate Clearance Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
}
}
public void ResetVmParams()
{
VmParams = new CandidateClearanceVm();
}
public void ResetVmItem()
{
VmItem = new CandidateClearanceVm();
}
private void LoadCombo()
{
string msgs = "";
gbl1.ComboItems = gbl1.GetCombo(ref msgs);
//attempt to add all
//will fail if dupplicate
foreach (var item in gbl1.ComboItems)
{
CandidateClearanceVm obj = new CandidateClearanceVm();
obj.GradeId = item.Id;
obj.PositionId = id;
cbl.AddOne(obj, ref msgs);
}
//retieve the candidate clearances
msgs = "";
cbl.VmParams.PositionId = id;
cbl.ListVm = cbl.GetList(cbl.VmParams, ref msgs);
//make the candidate clearances as the datasource
CandidateClearanceCheckListBoxCon.DataSource = cbl.ListVm;
CandidateClearanceCheckListBoxCon.DisplayMember = "Grade";
CandidateClearanceCheckListBoxCon.ValueMember = "Id";
//set each items checked if active
for (int i = 0; i < cbl.ListVm.Count; i++)
{
CandidateClearanceCheckListBoxCon.SetItemChecked(i, cbl.ListVm[i].Active);
}
gbl2.ComboItems = gbl2.GetCombo(ref msgs);
//attempt to add all
//will fail if dupplicate
foreach (var item in gbl2.ComboItems)
{
VoterClearanceVm obj = new VoterClearanceVm();
obj.GradeId = item.Id;
obj.PositionId = id;
vbl.AddOne(obj, ref msgs);
}
//retieve the voter clearances
msgs = "";
vbl.VmParams.PositionId = id;
vbl.ListVm = vbl.GetList(vbl.VmParams, ref msgs);
//make the voter clearances as the datasource
VoterClearanceCheckedListBoxCon.DataSource = vbl.ListVm;
VoterClearanceCheckedListBoxCon.DisplayMember = "Grade";
VoterClearanceCheckedListBoxCon.ValueMember = "Id";
//set each items checked if active
for (int i = 0; i < vbl.ListVm.Count; i++)
{
VoterClearanceCheckedListBoxCon.SetItemChecked(i, vbl.ListVm[i].Active);
}
}