protected void btnSave_Click1(object sender, EventArgs e) { ECCMS _objDB = new ECCMS(); try { saveComplain(); if (strstatus == "Add") { setRedirectURL(true); } else if (strstatus == "Update") { setRedirectURL(false); } else { lblMsg.Text = ECCCommon.objCached.ErrorOccured_ActionCancelled; } } finally { _objDB.Dispose(); } }
private void showEditData() { ECCMS _objDetail = new ECCMS(); try { tblComplainRow _objRow = new tblComplainRow(); lkpProvinceRow _objProvRow = new lkpProvinceRow(); lkpDistrictRow _objDistRow = new lkpDistrictRow(); lkpPollingCenterRow _objPCRow = new lkpPollingCenterRow(); lkpCandidateRow _objCandRow = new lkpCandidateRow(); _objRow = _objDetail.tblComplainCollection.GetRow("CaseID= " + CaseID + ""); txtCaseNo.Text = _objRow.CaseNo.ToString(); txtSubDate.Text = _objRow.Sub_Date.ToShortDateString(); txtTriDate.Text = _objRow.Tri_Date.ToShortDateString(); txtPS.Text = _objRow.PS.ToString(); drpKuchi.SelectedValue = _objRow.Kuchi.ToString(); txtSummary.Text = _objRow.AllegationSummary.ToString().Trim(); txtDecision.Text = _objRow.Decision.ToString().Trim(); txtECCDecision.Text = _objRow.Ecc_HQ_Decision.ToString().Trim(); _objCandRow = _objDetail.lkpCandidateCollection.GetRow("Cand_ID=" + _objRow.Comp_Cand_ID); //_objProvRow = _objDetail.lkpProvinceCollection.GetRow("ProvID=" + _objCandRow.Prov_ID); _objPCRow = _objDetail.lkpPollingCenterCollection.GetRow("PolCen_ID=" + _objRow.PolCen_ID); _objDistRow = _objDetail.lkpDistrictCollection.GetRow("District_Code=" + _objPCRow.District_Code); drpDistrict.SelectedValue = _objPCRow.District_Code; //_objProvRow = _objDetail.lkpProvinceCollection.GetRow("ProvId=" + _objDistRow.Province_Id + ""); drpProvince.SelectedValue = _objRow.ProvID.ToString(); fillProvRelated(); fillDistrictRelated(); drpCasePro.SelectedValue = _objRow.CaseProID.ToString(); drpPC.SelectedValue = _objRow.PolCen_ID.ToString(); drpGender1.SelectedValue = _objRow.Comp_GenderID.ToString(); drpGender2.SelectedValue = _objRow.Resp_GenderID.ToString(); drpCandidate.SelectedValue = _objRow.Comp_Cand_ID.ToString(); drpComplaintType.SelectedValue = _objRow.Comp_TypeID.ToString(); drpRespondantType.SelectedValue = _objRow.Resp_TypeID.ToString(); drpAllegationType.SelectedValue = _objRow.AllagType_ID.ToString(); drpResponOffice.SelectedValue = _objRow.Resp_OfficeID.ToString(); drpStatus.SelectedValue = _objRow.StatusID.ToString(); drpSanctTypr.SelectedValue = _objRow.SanctionID.ToString(); drpAppeal.SelectedValue = _objRow.Appeal.ToString(); } finally { _objDetail.Dispose(); } }
private void fillDistrictRelated() { ECCMS _objdb = new ECCMS(); try { DataTable dtPC = _objdb.lkpPollingCenterCollection.GetAsDataTable("District_Code=" + drpDistrict.SelectedValue + " or District_Code=3700", "PolCen_Code"); ECCCommon.FillCombo(ref drpPC, dtPC, "PolCen_Code", "PolCen_Id", true); } finally { _objdb.Dispose(); } }
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(); } }
protected void imgDelete_Command(object sender, CommandEventArgs e) { ECCMS _objDb = new ECCMS(); try { Complain _objRow = new Complain(); _objRow._Complain_DeleteLogically(e.CommandArgument.ToString()); showData(); } finally { _objDb.Dispose(); } }
private DataTable GetGridData() { ECCMS _objDb = new ECCMS(); DataTable dt = new DataTable(); try { dt = _objDb.lkpCasepriorityCollection.GetAllAsDataTable(); _gvList.DataSource = dt; _gvList.DataBind(); } finally { _objDb.Dispose(); } return(dt); }
private void fillProvRelated() { ECCMS _objdb = new ECCMS(); try { DataTable dtDistrict = _objdb.lkpDistrictCollection.GetAsDataTable("Province_ID=" + drpProvince.SelectedValue + " or Province_ID=37", "District_Code"); ECCCommon.FillCombo(ref drpDistrict, dtDistrict, "District_Name", "District_Code", true); DataTable dtCandidate = _objdb.lkpCandidateCollection.GetAsDataTable("Prov_ID=" + drpProvince.SelectedValue + " or Prov_ID = 37", "Cand_ID"); ECCCommon.FillCombo(ref drpCandidate, dtCandidate, "Cand_No", "Cand_ID", true); } finally { _objdb.Dispose(); } }
protected void imgEdit_Command(object sender, CommandEventArgs e) { ECCMS _objDb = new ECCMS(); try { lkpCasepriorityRow _objRow = new lkpCasepriorityRow(); _objRow = _objDb.lkpCasepriorityCollection.GetRow("CaseProID=" + Convert.ToInt32(e.CommandArgument) + ""); txtCaseProID.Text = _objRow.CaseProID.ToString(); txtCaseProName.Text = _objRow.CaseProName.ToString(); mpePerson.Show(); } finally { _objDb.Dispose(); } }
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(); } }
private string GetCaseNo(int provID) { ECCMS _objDB = new ECCMS(); Complain _objComplain = new Complain(); try { if (drpKuchi.SelectedValue == "1") { _CaseNO = "K-10-" + string.Format("{0:00}", provID) + "-" + string.Format("{0:0000}", _objComplain.getMaxCaseNo(provID)); } else { _CaseNO = "A-10-" + string.Format("{0:00}", provID) + "-" + string.Format("{0:0000}", _objComplain.getMaxCaseNo(provID)); } return(_CaseNO); } finally { _objDB.Dispose(); } }
private DataTable GetGridData() { DataTable dt = new DataTable(); ECCMS _objDB = new ECCMS(); try { Complain _objList = new Complain(); string userRight; string caseNo, BitName, caseProName, ProvNameEng, Resp_OfficeName, Resp_TypeName, SanctionName, StatusName, Comp_Name; userRight = Session["Role"].ToString(); if (txtCaseNo.Text.Length == 7) { txtCaseNo.Text = "A-10-" + txtCaseNo.Text.ToString().Trim(); } if (txtCaseNo.Text.Trim() != "") { caseNo = txtCaseNo.Text.Trim(); } else { caseNo = DBNull.Value.ToString(); } if (drpCasePro.SelectedValue.ToString() != "0") { caseProName = drpCasePro.SelectedItem.Text.Trim(); } else { caseProName = DBNull.Value.ToString(); } if (drpComplaintType.SelectedValue.ToString() != "0") { Comp_Name = drpComplaintType.SelectedItem.Text; } else { Comp_Name = DBNull.Value.ToString(); } if (drpKuchi.SelectedValue.ToString() != "0") { BitName = drpKuchi.SelectedItem.Text; } else { BitName = DBNull.Value.ToString(); } if (drpProvince.SelectedValue.ToString() != "0") { ProvNameEng = drpProvince.SelectedItem.Text; } else { ProvNameEng = DBNull.Value.ToString(); } if (drpRespondantType.SelectedValue.ToString() != "0") { Resp_TypeName = drpRespondantType.SelectedItem.Text; } else { Resp_TypeName = DBNull.Value.ToString(); } if (drpResponOffice.SelectedValue.ToString() != "0") { Resp_OfficeName = drpResponOffice.SelectedItem.Text; } else { Resp_OfficeName = DBNull.Value.ToString(); } if (drpSanctTypr.SelectedValue.ToString() != "0") { SanctionName = drpSanctTypr.SelectedItem.Text; } else { SanctionName = DBNull.Value.ToString(); } if (drpStatus.SelectedValue.ToString() != "0") { StatusName = drpStatus.SelectedItem.Text; } else { StatusName = DBNull.Value.ToString(); } if (userRight == "Administrator") { dt = _objList.getAdmin_Search(caseNo, BitName, caseProName, ProvNameEng, Resp_OfficeName, Resp_TypeName, SanctionName, StatusName, Comp_Name); } else { dt = _objList.getUser_Search(caseNo, BitName, caseProName, ProvNameEng, Resp_OfficeName, Resp_TypeName, SanctionName, StatusName, Comp_Name, UserId); } if (dt.Rows.Count == 0) { lblNoDataMsg.Text = ECCCommon.objCached.NoRecordExists; } else { lblNoDataMsg.Text = ""; } _gvList.DataSource = dt; _gvList.DataBind(); } finally { _objDB.Dispose(); } return(dt); }
private void _SaveExcelCase() { ECCMS _dbobj = new ECCMS(); _iAlreadyinserted = 0; _inserted = 0; try { tblComplainRow _objComplain = new tblComplainRow(); for (int i = 0; i <= _gvList.Rows.Count - 1; i++) { GridViewRow _grRow = this._gvList.Rows[i]; _CaseLen = _grRow.Cells[0].Text.Length.ToString(); if (_CaseLen == "4" && _grRow.Cells[2].Text == "2") { _CaseNumber = "A-10-" + string.Format("{0:00}", Convert.ToInt32(_grRow.Cells[20].Text)) + "-" + _grRow.Cells[0].Text; } else if (_CaseLen == "4" && _grRow.Cells[2].Text == "1") { _CaseNumber = "K-10-" + string.Format("{0:00}", Convert.ToInt32(_grRow.Cells[20].Text)) + "-" + _grRow.Cells[0].Text; } else if (_CaseLen == "7" && _grRow.Cells[2].Text == "2") { _CaseNumber = "A-10-" + _grRow.Cells[0].Text; } else if (_CaseLen == "7" && _grRow.Cells[2].Text == "1") { _CaseNumber = "K-10-" + _grRow.Cells[0].Text; } else { _CaseNumber = _grRow.Cells[0].Text; } _objComplain = _dbobj.tblComplainCollection.GetRow("CaseNo=N'" + _CaseNumber + "' and ProvID= " + Convert.ToInt32(_grRow.Cells[20].Text) + " and isDeleted = 0"); if (_objComplain == null) { _inserted++; _objComplain = new tblComplainRow(); _CaseNotInserted = _grRow.Cells[0].Text; _objComplain.CaseNo = _CaseNumber; _objComplain.Sub_Date = Convert.ToDateTime(_grRow.Cells[1].Text); _objComplain.Kuchi = Convert.ToInt32(_grRow.Cells[2].Text); _objComplain.CaseProID = Convert.ToInt32(_grRow.Cells[3].Text); _objComplain.Tri_Date = Convert.ToDateTime(_grRow.Cells[4].Text); _objComplain.ProvID = Convert.ToInt32(_grRow.Cells[20].Text); _objComplain.PolCen_ID = Convert.ToInt32(_grRow.Cells[5].Text); _objComplain.PS = _grRow.Cells[6].Text; _objComplain.Comp_GenderID = Convert.ToInt32(_grRow.Cells[7].Text); _objComplain.Comp_Cand_ID = Convert.ToInt32(_grRow.Cells[8].Text); _objComplain.Comp_TypeID = Convert.ToInt32(_grRow.Cells[9].Text); _objComplain.Resp_GenderID = Convert.ToInt32(_grRow.Cells[10].Text); _objComplain.Resp_TypeID = Convert.ToInt32(_grRow.Cells[11].Text); _objComplain.AllagType_ID = Convert.ToInt32(_grRow.Cells[12].Text); _objComplain.AllegationSummary = _grRow.Cells[13].Text; _objComplain.Resp_OfficeID = Convert.ToInt32(_grRow.Cells[14].Text); _objComplain.StatusID = Convert.ToInt32(_grRow.Cells[15].Text); _objComplain.Decision = _grRow.Cells[16].Text; _objComplain.SanctionID = Convert.ToInt32(_grRow.Cells[17].Text); _objComplain.Appeal = Convert.ToInt32(_grRow.Cells[18].Text); _objComplain.Ecc_HQ_Decision = _grRow.Cells[19].Text; _objComplain.IsDeleted = false; _objComplain.CreatedBy = UserId; _objComplain.CreatedTime = DateTime.Now; _objComplain.UpdatedBy = UserId; _objComplain.UpdatedTime = DateTime.Now; _dbobj.tblComplainCollection.Insert(_objComplain); lbl_Inserted.Text = _inserted.ToString(); } else { _iAlreadyinserted++; //lblMsg.Text = "Already Inserted" + lblMsg.Text + "//" + _objComplain.CaseNo.ToString(); _objComplain = _dbobj.tblComplainCollection.GetRow("CaseNo=N'" + _CaseNumber + "' and ProvID= " + Convert.ToInt32(_grRow.Cells[20].Text) + " and isDeleted = 0"); _objComplain.CaseNo = _CaseNumber; _CaseNotInserted = _grRow.Cells[0].Text; _objComplain.Sub_Date = Convert.ToDateTime(_grRow.Cells[1].Text); _objComplain.Kuchi = Convert.ToInt32(_grRow.Cells[2].Text); _objComplain.CaseProID = Convert.ToInt32(_grRow.Cells[3].Text); _objComplain.Tri_Date = Convert.ToDateTime(_grRow.Cells[4].Text); _objComplain.ProvID = Convert.ToInt32(_grRow.Cells[20].Text); _objComplain.PolCen_ID = Convert.ToInt32(_grRow.Cells[5].Text); _objComplain.PS = _grRow.Cells[6].Text; _objComplain.Comp_GenderID = Convert.ToInt32(_grRow.Cells[7].Text); _objComplain.Comp_Cand_ID = Convert.ToInt32(_grRow.Cells[8].Text); _objComplain.Comp_TypeID = Convert.ToInt32(_grRow.Cells[9].Text); _objComplain.Resp_GenderID = Convert.ToInt32(_grRow.Cells[10].Text); _objComplain.Resp_TypeID = Convert.ToInt32(_grRow.Cells[11].Text); _objComplain.AllagType_ID = Convert.ToInt32(_grRow.Cells[12].Text); _objComplain.AllegationSummary = _grRow.Cells[13].Text; _objComplain.Resp_OfficeID = Convert.ToInt32(_grRow.Cells[14].Text); _objComplain.StatusID = Convert.ToInt32(_grRow.Cells[15].Text); _objComplain.Decision = _grRow.Cells[16].Text; _objComplain.SanctionID = Convert.ToInt32(_grRow.Cells[17].Text); _objComplain.Appeal = Convert.ToInt32(_grRow.Cells[18].Text); _objComplain.Ecc_HQ_Decision = _grRow.Cells[19].Text; _objComplain.IsDeleted = false; _objComplain.UpdatedBy = UserId; _objComplain.UpdatedTime = DateTime.Now; _dbobj.tblComplainCollection.Update(_objComplain); lblPresent.Text = _iAlreadyinserted.ToString(); lblUpdated.Text = lblUpdated.Text + "-(" + _grRow.Cells[0].Text + ")"; } // } } catch (Exception ex) { lblMsg.Text = _CaseNotInserted.ToString(); lblStoped.Text = _CaseNotInserted.ToString(); System.IO.File.Delete(Server.MapPath(".\\uploadfile\\" + Session["UserName"].ToString() + "DataEntry.xls")); } finally { _dbobj.Dispose(); } }
private void saveComplain() { ECCMS _objDb = new ECCMS(); try { tblComplainRow _objComplain = new tblComplainRow(); if (CaseID == "") { _objComplain.CaseNo = GetCaseNo(Convert.ToInt32(drpProvince.SelectedValue)); txtCaseNo.Text = _objComplain.CaseNo.ToString(); _objComplain.Sub_Date = Convert.ToDateTime(txtSubDate.Text.Trim()); _objComplain.Kuchi = Convert.ToInt32(drpKuchi.SelectedValue); _objComplain.CaseProID = Convert.ToInt32(drpCasePro.SelectedValue); _objComplain.Tri_Date = Convert.ToDateTime(txtTriDate.Text.Trim()); _objComplain.ProvID = Convert.ToInt32(drpProvince.SelectedValue); _objComplain.PolCen_ID = Convert.ToInt32(drpPC.SelectedValue); _objComplain.PS = txtPS.Text.Trim(); _objComplain.Comp_GenderID = Convert.ToInt32(drpGender1.SelectedValue); _objComplain.Comp_Cand_ID = Convert.ToInt32(drpCandidate.SelectedValue); _objComplain.Comp_TypeID = Convert.ToInt32(drpComplaintType.SelectedValue); _objComplain.Resp_GenderID = Convert.ToInt32(drpGender2.SelectedValue); _objComplain.Resp_TypeID = Convert.ToInt32(drpRespondantType.SelectedValue); _objComplain.AllagType_ID = Convert.ToInt32(drpAllegationType.SelectedValue); _objComplain.AllegationSummary = txtSummary.Text.Trim(); _objComplain.Resp_OfficeID = Convert.ToInt32(drpResponOffice.SelectedValue); _objComplain.StatusID = Convert.ToInt32(drpStatus.SelectedValue); _objComplain.Decision = txtDecision.Text.Trim(); _objComplain.SanctionID = Convert.ToInt32(drpSanctTypr.SelectedValue); _objComplain.Appeal = Convert.ToInt32(drpAppeal.SelectedValue); _objComplain.Ecc_HQ_Decision = txtECCDecision.Text.Trim(); _objComplain.IsDeleted = false; _objComplain.CreatedBy = UserId; _objComplain.CreatedTime = DateTime.Now; _objComplain.UpdatedBy = UserId; _objComplain.UpdatedTime = DateTime.Now; _objDb.tblComplainCollection.Insert(_objComplain); _Case_ID = _objComplain.CaseID.ToString(); strstatus = "Add"; } else if (CaseID != "") { _objComplain = _objDb.tblComplainCollection.GetRow("CaseID=" + Convert.ToInt32(CaseID) + ""); _objComplain.Sub_Date = Convert.ToDateTime(txtSubDate.Text.Trim()); _objComplain.Kuchi = Convert.ToInt32(drpKuchi.SelectedValue); _objComplain.CaseProID = Convert.ToInt32(drpCasePro.SelectedValue); _objComplain.Tri_Date = Convert.ToDateTime(txtTriDate.Text.Trim()); _objComplain.ProvID = Convert.ToInt32(drpProvince.SelectedValue); _objComplain.PolCen_ID = Convert.ToInt32(drpPC.SelectedValue); _objComplain.PS = txtPS.Text.Trim(); _objComplain.Comp_GenderID = Convert.ToInt32(drpGender1.SelectedValue); _objComplain.Comp_Cand_ID = Convert.ToInt32(drpCandidate.SelectedValue); _objComplain.Comp_TypeID = Convert.ToInt32(drpComplaintType.SelectedValue); _objComplain.Resp_GenderID = Convert.ToInt32(drpGender2.SelectedValue); _objComplain.Resp_TypeID = Convert.ToInt32(drpRespondantType.SelectedValue); _objComplain.AllagType_ID = Convert.ToInt32(drpAllegationType.SelectedValue); _objComplain.AllegationSummary = txtSummary.Text.Trim(); _objComplain.Resp_OfficeID = Convert.ToInt32(drpResponOffice.SelectedValue); _objComplain.StatusID = Convert.ToInt32(drpStatus.SelectedValue); _objComplain.Decision = txtDecision.Text.Trim(); _objComplain.SanctionID = Convert.ToInt32(drpSanctTypr.SelectedValue); _objComplain.Appeal = Convert.ToInt32(drpAppeal.SelectedValue); _objComplain.Ecc_HQ_Decision = txtECCDecision.Text.Trim(); //_objComplain.IsDeleted = false; _objComplain.CreatedBy = UserId; _objComplain.CreatedTime = DateTime.Now; _objComplain.UpdatedBy = UserId; _objComplain.UpdatedTime = DateTime.Now; _objDb.tblComplainCollection.Update(_objComplain); strstatus = "Update"; _Case_ID = CaseID.ToString(); } //Response.Redirect("ComplainDetail.aspx?CaseNo=" + ECCCommon.EncryptQueryString(_objComplain.CaseNo.ToString()) + ""); } finally { _objDb.Dispose(); } }
private void showData() { ECCMS _objDetail = new ECCMS(); try { tblComplainRow _objRow = new tblComplainRow(); lkpProvinceRow _objProvRow = new lkpProvinceRow(); lkpDistrictRow _objDistRow = new lkpDistrictRow(); lkpPollingCenterRow _objPCRow = new lkpPollingCenterRow(); lkpBitRow _objBitRow = new lkpBitRow(); lkpCasepriorityRow _objCasePro = new lkpCasepriorityRow(); lkpGendersRow _objGenderRow = new lkpGendersRow(); lkpCandidateRow _objCandRow = new lkpCandidateRow(); lkpComplainanttypeRow _objComp_Type = new lkpComplainanttypeRow(); lkpRespondanttypeRow _objResp_Type = new lkpRespondanttypeRow(); lkpAllegationtypeRow _objAllega_Type = new lkpAllegationtypeRow(); lkpResponsibleOfficeRow _objResp_Office = new lkpResponsibleOfficeRow(); lkpSanctionRow _objSanc = new lkpSanctionRow(); lkpStatusRow _objStatusRow = new lkpStatusRow(); _objRow = _objDetail.tblComplainCollection.GetRow("CaseID=" + CaseID + ""); txtCaseNo.Text = _objRow.CaseNo.ToString(); txtSubDate.Text = _objRow.Sub_Date.ToShortDateString(); txtTriDate.Text = _objRow.Tri_Date.ToShortDateString(); txtPS.Text = _objRow.PS.ToString(); txtSummary.Text = _objRow.AllegationSummary.ToString().Trim(); txtDecision.Text = _objRow.Decision.ToString().Trim(); txtEccHQDecision.Text = _objRow.Ecc_HQ_Decision.ToString().Trim(); _objBitRow = _objDetail.lkpBitCollection.GetRow("BitID=" + _objRow.Kuchi); txtKuchi.Text = _objBitRow.BitName.ToString().Trim(); _objBitRow = _objDetail.lkpBitCollection.GetRow("BitID=" + _objRow.Appeal); txtAppeal.Text = _objBitRow.BitName.ToString().Trim(); _objCasePro = _objDetail.lkpCasepriorityCollection.GetRow("CaseProID=" + _objRow.CaseProID); txtCasePro.Text = _objCasePro.CaseProName.ToString().Trim(); _objCandRow = _objDetail.lkpCandidateCollection.GetRow("Cand_ID=" + _objRow.Comp_Cand_ID); txtCandidateNo.Text = _objCandRow.Cand_No.ToString().Trim(); // _objProvRow = _objDetail.lkpProvinceCollection.GetRow("ProvID=" + _objCandRow.Prov_ID); _objPCRow = _objDetail.lkpPollingCenterCollection.GetRow("PolCen_ID=" + _objRow.PolCen_ID); txtPC.Text = _objPCRow.PolCen_Code; _objDistRow = _objDetail.lkpDistrictCollection.GetRow("District_Code=" + _objPCRow.District_Code); txtDistrict.Text = _objDistRow.District_Name.ToString().Trim(); // _objProvRow = _objDetail.lkpProvinceCollection.GetRow("Provid=" + _objDistRow.Province_Id + ""); // txtProvince.Text = _objProvRow.ProvNameEng.ToString().Trim(); _objProvRow = _objDetail.lkpProvinceCollection.GetRow("ProvID=" + _objRow.ProvID + ""); txtProvince.Text = _objProvRow.ProvNameEng.ToString(); _objGenderRow = _objDetail.lkpGendersCollection.GetRow("GenderID=" + _objRow.Comp_GenderID); txtGender1.Text = _objGenderRow.GenderName.ToString().Trim(); _objGenderRow = _objDetail.lkpGendersCollection.GetRow("GenderID=" + _objRow.Resp_GenderID); txtGender2.Text = _objGenderRow.GenderName.ToString().Trim(); _objComp_Type = _objDetail.lkpComplainanttypeCollection.GetRow("Comp_typeID=" + _objRow.Comp_TypeID); txtComp_Type.Text = _objComp_Type.Comp_Name.ToString().Trim(); _objResp_Type = _objDetail.lkpRespondanttypeCollection.GetRow("RespType_ID=" + _objRow.Resp_TypeID); txtResp_Type.Text = _objResp_Type.RespType_Name.ToString().Trim(); _objAllega_Type = _objDetail.lkpAllegationtypeCollection.GetRow("AllagType_ID=" + _objRow.AllagType_ID); txtAllage_Type.Text = _objAllega_Type.AllagType_Name.ToString().Trim(); _objResp_Office = _objDetail.lkpResponsibleOfficeCollection.GetRow("Resp_OfficeID=" + _objRow.Resp_OfficeID); txtResp_Office.Text = _objResp_Office.Resp_OfficeName.ToString().Trim(); _objStatusRow = _objDetail.lkpStatusCollection.GetRow("StatusID=" + _objRow.StatusID); txtStatus.Text = _objStatusRow.StatusName.ToString().Trim(); _objSanc = _objDetail.lkpSanctionCollection.GetRow("SacntionID=" + _objRow.SanctionID); txtSanction.Text = _objSanc.SacntionName.ToString().Trim(); } finally { _objDetail.Dispose(); } }