private void _FillCombo()
{
ECCMS db = new ECCMS();
try
{
DataTable dtProvince = db.lkpProvinceCollection.GetAllAsDataTable();
ECCCommon.FillCombo(ref drpProvince, dtProvince, "ProvNameEng", "ProvId", true);
}
finally
{
db.Dispose();
db.Close();
}
}
private void _FillCombo()
{
ECCMS db = new ECCMS();
try
{
DataTable dtProvince = db.lkpProvinceCollection.GetAllAsDataTable();
ECCCommon.FillCombo(ref drpProvince, dtProvince, "ProvNameEng", "ProvId", true);
DataTable dtAllagType = db.lkpAllegationtypeCollection.GetAllAsDataTable();
ECCCommon.FillCombo(ref drpAllegationType, dtAllagType, "AllagType_Name", "AllagType_ID", true);
DataTable dtBit = db.lkpBitCollection.GetAllAsDataTable();
ECCCommon.FillCombo(ref drpKuchi, dtBit, "BitName", "BitID", true);
ECCCommon.FillCombo(ref drpAppeal, dtBit, "BitName", "BitID", true);
DataTable dtGender = db.lkpGendersCollection.GetAllAsDataTable();
ECCCommon.FillCombo(ref drpGender1, dtGender, "GenderName", "GenderID", true);
ECCCommon.FillCombo(ref drpGender2, dtGender, "GenderName", "GenderID", true);
DataTable dtCompType = db.lkpComplainanttypeCollection.GetAllAsDataTable();
ECCCommon.FillCombo(ref drpComplaintType, dtCompType, "Comp_Name", "Comp_TypeID", true);
DataTable dtRespType = db.lkpRespondanttypeCollection.GetAllAsDataTable();
ECCCommon.FillCombo(ref drpRespondantType, dtRespType, "RespType_Name", "RespType_ID", true);
DataTable dtRespOffice = db.lkpResponsibleOfficeCollection.GetAllAsDataTable();
ECCCommon.FillCombo(ref drpResponOffice, dtRespOffice, "Resp_OfficeName", "Resp_OfficeID", true);
DataTable dtSanc = db.lkpSanctionCollection.GetAllAsDataTable();
ECCCommon.FillCombo(ref drpSanctTypr, dtSanc, "SacntionName", "SacntionID", true);
DataTable dtPro = db.lkpCasepriorityCollection.GetAllAsDataTable();
ECCCommon.FillCombo(ref drpCasePro, dtPro, "caseProName", "caseProID", true);
DataTable dtStatus = db.lklStatusCollection.GetAsDataTable("Active=1", "StatusID");
ECCCommon.FillCombo(ref drpStatus, dtStatus, "StatusName", "StatusID", true);
}
finally
{
db.Dispose();
db.Close();
}
}