private void LoadTameliList() { try { ATTTameliSearch obj = new ATTTameliSearch(); obj.OrgID = courtID; //if (txtAppelantName.Text.Trim() != "") obj.Appelant = txtAppelantName.Text; //if (txtRespondantName.Text.Trim() != "") obj.Respondant = txtRespondantName.Text; obj.TameliYesNo = "null"; obj.TameliDate = "null"; obj.SecClrkRcvdDate = "null"; obj.VerifiedYesNo = "null"; List <ATTTameliSearch> lst = BLLTameliSearch.GetTameliForFeedBack(obj); TameliSend = lst; grdTameli.DataSource = lst; grdTameli.DataBind(); grdTameli.SelectedIndex = -1; } catch (Exception ex) { lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); } }
protected void btnSearch_Click(object sender, EventArgs e) { if ((this.ddlCaseType.SelectedIndex < 1) && (this.txtCaseNo.Text == "___-__-____") && (this.txtRegNo.Text == "__-___-_____") && (this.txtRegDate.Text == "____/__/__") && (this.txtVerifiedDate.Text.Trim() == "") && (this.txtRespondantName.Text.Trim() == "")) { this.lblStatusMessage.Text = "Please Enter (Or) Select Atleast One Field."; this.programmaticModalPopup.Show(); return; } try { ATTTameliSearch obj = new ATTTameliSearch(); obj.OrgID = orgID; if (ddlCaseType.SelectedIndex > 0) { obj.CaseTypeID = int.Parse(ddlCaseType.SelectedValue); } if (txtRegNo.Text.Trim() != "" && txtRegNo.Text.Trim() != "__-___-_____") { obj.RegNo = txtRegNo.Text; } if (txtCaseNo.Text.Trim() != "" && txtCaseNo.Text.Trim() != "___-__-____") { obj.CaseNo = txtCaseNo.Text; } if (txtRegDate.Text.Trim() != "" && txtRegDate.Text.Trim() != "____/__/__") { obj.CaseRegDate = txtRegDate.Text; } //if (txtAppelantName.Text.Trim() != "") obj.Appelant = txtAppelantName.Text; //if (txtRespondantName.Text.Trim() != "") obj.Respondant = txtRespondantName.Text; obj.TameliYesNo = "Y"; obj.VerifiedYesNo = "null"; obj.TameliDate = "notnull"; obj.SecClrkRcvdDate = "notnull"; List <ATTTameliSearch> lst = BLLTameliSearch.GetTameliSearch(obj); TameliProcesss = lst; grdTameli.DataSource = lst; grdTameli.DataBind(); grdTameli.SelectedIndex = -1; } catch (Exception ex) { lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (grdTameli.SelectedIndex < 0) { lblStatusMessage.Text = "Select Tameli To Be Processed"; this.programmaticModalPopup.Show(); return; } if (txtVerifiedDate.Text == "____/__/__" || txtVerifiedDate.Text.Trim() == "") { lblStatusMessage.Text = "Verified Date Missing"; this.programmaticModalPopup.Show(); return; } if (rdblstVerify.SelectedIndex < 0) { lblStatusMessage.Text = "Select Verify Yes/No"; this.programmaticModalPopup.Show(); return; } ATTTameli tamProcess = new ATTTameli(); ATTTameliSearch tamSearch = TameliProcesss[grdTameli.SelectedIndex]; tamProcess.CaseID = tamSearch.CaseID; tamProcess.LitigantID = tamSearch.LitigantID; tamProcess.IssuedDate = tamSearch.IssuedDate; tamProcess.SeqNo = tamSearch.SeqNo; tamProcess.VerifiedDate = txtVerifiedDate.Text.Trim(); tamProcess.VerifiedBy = userID; tamProcess.VerifiedYesNo = (rdblstVerify.SelectedIndex == 0) ? "Y" : "N"; tamProcess.VerifiedRemarks = txtRemarks.Text.ToString(); if (BLLTameli.ProcessTameli(tamProcess)) { lblStatusMessage.Text = "Tameli Processed Successfully"; this.programmaticModalPopup.Show(); } else { lblStatusMessage.Text = "Problem Occured"; this.programmaticModalPopup.Show(); } ClearControls(true, true); } catch (Exception ex) { lblStatusMessage.Text = "Select Tameli To Be Processed " + ex.Message.ToString(); this.programmaticModalPopup.Show(); } }
private void LoadDataForTamildaarAssignment() { ATTTameliSearch obj = new ATTTameliSearch(); List <ATTTameliSearch> lst = BLLTameliSearch.GetTameliForAssigningTamildaar(courtID); TameliAssignTamildaar = lst; grdAssignTamildaar.DataSource = lst; grdAssignTamildaar.DataBind(); grdAssignTamildaar.SelectedIndex = -1; }
private void LoadDeleteData() { ATTTameliSearch obj = new ATTTameliSearch(); obj.OrgID = orgID;//new obj.TameliYesNo = "Y"; //obj.TameliYesNo = "notnull"; obj.VerifiedYesNo = "null"; obj.TameliDate = "notnull"; obj.SecClrkRcvdDate = "notnull"; List <ATTTameliSearch> lst = BLLTameliSearch.GetTameliSearch(obj); TameliProcesss = lst; grdTam.DataSource = lst; grdTam.DataBind(); grdTam.SelectedIndex = -1; }
public static List <ATTTameliSearch> GetTameliForAssigningTamildaar(int OrgID) { try { List <ATTTameliSearch> tameliInfoList = new List <ATTTameliSearch>(); foreach (DataRow drow in DLLTameliSearch.GetTameliForAssigningTamildaar(OrgID).Rows) { ATTTameliSearch tameliInfo = new ATTTameliSearch(); if (drow["COURT_ID"] != null) { if (drow["COURT_ID"].ToString() != "") { tameliInfo.OrgID = int.Parse(drow["COURT_ID"].ToString()); } } if (drow["CASE_ID"] != null) { if (drow["CASE_ID"].ToString() != "") { tameliInfo.CaseID = int.Parse(drow["CASE_ID"].ToString()); } } if (drow["CASE_TYPE_ID"] != null) { if (drow["CASE_TYPE_ID"].ToString() != "") { tameliInfo.CaseTypeID = int.Parse(drow["CASE_TYPE_ID"].ToString()); } } tameliInfo.CaseTypeName = drow["CASE_TYPE_NAME"].ToString(); if (drow["REG_TYPE_ID"] != null) { if (drow["REG_TYPE_ID"].ToString() != "") { tameliInfo.RegTypeID = int.Parse(drow["REG_TYPE_ID"].ToString()); } } tameliInfo.RegTypeName = drow["REG_TYPE_NAME"].ToString(); if (drow["REG_DIARY_ID"] != null) { if (drow["REG_DIARY_ID"].ToString() != "") { tameliInfo.RegDiaryID = int.Parse(drow["REG_DIARY_ID"].ToString()); } } if (drow["REG_SUBJECT_ID"] != null) { if (drow["REG_SUBJECT_ID"].ToString() != "") { tameliInfo.RegSubjectID = int.Parse(drow["REG_SUBJECT_ID"].ToString()); } } tameliInfo.SubjectName = drow["SUBJECT_NAME"].ToString(); if (drow["REG_DIARY_NAME_ID"] != null) { if (drow["REG_DIARY_NAME_ID"].ToString() != "") { tameliInfo.RegDiaryNameID = int.Parse(drow["REG_DIARY_NAME_ID"].ToString()); } } tameliInfo.RegDiarySubName = drow["REG_DIARY_SUB_NAME"].ToString(); tameliInfo.CaseRegDate = drow["CASE_REG_DATE"].ToString(); tameliInfo.RegNo = drow["REG_NO"].ToString(); tameliInfo.CaseNo = drow["CASE_NO"].ToString(); if (drow["LITIGANT_ID"] != null) { if (drow["LITIGANT_ID"].ToString() != "") { tameliInfo.LitigantID = int.Parse(drow["LITIGANT_ID"].ToString()); } } tameliInfo.LitigantName = drow["LITIGANTNAME"].ToString(); tameliInfo.IssuedDate = drow["ISSUED_DATE"].ToString(); if (drow["SEQ_NO"] != null) { if (drow["SEQ_NO"].ToString() != "") { tameliInfo.SeqNo = int.Parse(drow["SEQ_NO"].ToString()); } } if (drow["ATTORNEY_ID"] != null) { if (drow["ATTORNEY_ID"].ToString() != "") { tameliInfo.AttorneyID = int.Parse(drow["ATTORNEY_ID"].ToString()); } } tameliInfo.AttorneyFullName = drow["ATTORNEYFLLNAME"].ToString(); if (drow["ISSUED_BY"] != null) { if (drow["ISSUED_BY"].ToString() != "") { tameliInfo.IssuedBy = int.Parse(drow["ISSUED_BY"].ToString()); } } tameliInfo.IssuedPerson = drow["ISSUEDPERSON"].ToString(); tameliInfo.ReceivedDate = drow["RECEIVED_DATE"].ToString(); if (drow["RECEIVED_BY"] != null) { if (drow["RECEIVED_BY"].ToString() != "") { tameliInfo.ReceivedBy = int.Parse(drow["RECEIVED_BY"].ToString()); } } tameliInfo.TamildaarName = drow["TAMILDAARNAME"].ToString(); tameliInfo.TameliDate = drow["TAMELI_DATE"].ToString(); tameliInfo.TameliYesNo = drow["TAMELI_YES_NO"].ToString(); tameliInfo.SecClrkRcvdDate = drow["SEC_CLRK_RCVD_DATE"].ToString(); tameliInfo.TamilDaarRemrks = drow["TAMILDAAR_REMARKS"].ToString(); tameliInfo.VerifiedDate = drow["VERIFIED_DATE"].ToString(); if (drow["VERIFIED_BY"] != null) { if (drow["VERIFIED_BY"].ToString() != "") { tameliInfo.VerifiedBy = int.Parse(drow["VERIFIED_BY"].ToString()); } } tameliInfo.SectionClerkName = drow["SECTIONCLERKNAME"].ToString(); tameliInfo.VerifiedRemarks = drow["VERIFIED_REMARKS"].ToString(); if (drow["MYAAD_TYPE_ID"] != null) { if (drow["MYAAD_TYPE_ID"].ToString() != "") { tameliInfo.MyaadTypeID = int.Parse(drow["MYAAD_TYPE_ID"].ToString()); } } tameliInfo.MyaadTypeName = drow["MYAAD_TYPE_NAME"].ToString(); if (drow["TAMELI_TYPE_ID"] != null) { if (drow["TAMELI_TYPE_ID"].ToString() != "") { tameliInfo.TameliTypeID = int.Parse(drow["TAMELI_TYPE_ID"].ToString()); } } tameliInfo.TameliTypeName = drow["TAMELI_TYPE_NAME"].ToString(); if (drow["TAMELI_STATUS_ID"] != null) { if (drow["TAMELI_STATUS_ID"].ToString() != "") { tameliInfo.TameliStatusID = int.Parse(drow["TAMELI_STATUS_ID"].ToString()); } } tameliInfo.TameliStatusName = drow["TAMELI_STATUS_NAME"].ToString(); if (drow["TAMELI_ORG"] != null) { if (drow["TAMELI_ORG"].ToString() != "") { tameliInfo.TameliOrg = int.Parse(drow["TAMELI_ORG"].ToString()); } } tameliInfo.OrgName = drow["ORG_NAME"].ToString(); if (drow["WITNESS_ID"] != null) { if (drow["WITNESS_ID"].ToString() != "") { tameliInfo.WitnessID = int.Parse(drow["WITNESS_ID"].ToString()); } } tameliInfo.WitnessFullName = drow["WITNESSFULLNAME"].ToString(); //tameliInfo.WitnessDOB = drow["WIT_DOB"].ToString(); //tameliInfo.WitnessGender = drow["WIT_GENDER"].ToString(); tameliInfo.VerifiedYesNo = drow["VERIFIED_YES_NO"].ToString(); if (drow["ATTEND_DAYS"] != null) { if (drow["ATTEND_DAYS"].ToString() != "") { tameliInfo.AttendDays = int.Parse(drow["ATTEND_DAYS"].ToString()); } } if (drow["MYAAD_TYPE_ID"] != null) { if (drow["MYAAD_TYPE_ID"].ToString() != "") { tameliInfo.MyaadTypeID = int.Parse(drow["MYAAD_TYPE_ID"].ToString()); } } if (drow["TAMELI_TYPE_ID"] != null) { if (drow["TAMELI_TYPE_ID"].ToString() != "") { tameliInfo.TameliTypeID = int.Parse(drow["TAMELI_TYPE_ID"].ToString()); } } if (drow["TAMELI_STATUS_ID"] != null) { if (drow["TAMELI_STATUS_ID"].ToString() != "") { tameliInfo.TameliStatusID = int.Parse(drow["TAMELI_STATUS_ID"].ToString()); } } if (drow["TAMELI_ORG"] != null) { if (drow["TAMELI_ORG"].ToString() != "") { tameliInfo.TameliOrg = int.Parse(drow["TAMELI_ORG"].ToString()); } } tameliInfo.RegDiaryName = drow["REG_DIARY_NAME"].ToString(); tameliInfo.MyaadType = drow["MYAAD_TYPE"].ToString(); tameliInfoList.Add(tameliInfo); } return(tameliInfoList); } catch (Exception) { throw; } }
public static DataTable GetTameliSearch(ATTTameliSearch tameli) { try { // string SelectSql = "SELECT * FROM VW_TAMELI_INFO WHERE 1=1 "; string SelectSql = "SELECT * FROM VW_TAMELI_INFO WHERE ((court_id=" + tameli.OrgID + " and tameli_org is null and received_by>0) or (tameli_org =" + tameli.OrgID + " and received_by>0 ))"; List <OracleParameter> ParamLIST = new List <OracleParameter>(); if (tameli.CaseID > 0) { SelectSql += " AND CASE_ID = :CaseID"; ParamLIST.Add(Utilities.GetOraParam(":CaseID", tameli.CaseID, OracleDbType.Int64, ParameterDirection.Input)); } if (tameli.LitigantID > 0) { SelectSql += " AND LITIGANT_ID = :LitigantID"; ParamLIST.Add(Utilities.GetOraParam(":CaseID", tameli.LitigantID, OracleDbType.Int64, ParameterDirection.Input)); } if (tameli.CaseTypeID > 0) { SelectSql += " AND CASE_TYPE_ID = :CaseTypeID"; ParamLIST.Add(Utilities.GetOraParam(":CaseTypeID", tameli.CaseTypeID, OracleDbType.Int64, ParameterDirection.Input)); } if (tameli.RegNo != null) { if (tameli.RegNo != "") { SelectSql += " AND REG_NO = :RegNo"; ParamLIST.Add(Utilities.GetOraParam(":RegNo", tameli.RegNo, OracleDbType.Varchar2, ParameterDirection.Input)); } } if (tameli.CaseNo != null) { if (tameli.CaseNo != "") { SelectSql += " AND CASE_NO = :CaseNo"; ParamLIST.Add(Utilities.GetOraParam(":CaseNo", tameli.CaseNo, OracleDbType.Varchar2, ParameterDirection.Input)); } } if (tameli.CaseRegDate != null) { if (tameli.CaseRegDate != "") { SelectSql += " AND CASE_REG_DATE = :CaseRegDate"; ParamLIST.Add(Utilities.GetOraParam(":CaseRegDate", tameli.CaseRegDate, OracleDbType.Varchar2, ParameterDirection.Input)); } } if (tameli.TameliYesNo != null) { if (tameli.TameliYesNo == "null") { SelectSql += " AND TAMELI_YES_NO is NULL "; } else if (tameli.TameliYesNo == "notnull") { SelectSql += " AND TAMELI_YES_NO is NOT NULL "; } else if (tameli.TameliYesNo != "") { SelectSql += " AND TAMELI_YES_NO = :TameliYesNo"; ParamLIST.Add(Utilities.GetOraParam(":TameliYesNo", tameli.TameliYesNo, OracleDbType.Varchar2, ParameterDirection.Input)); } } if (tameli.TameliDate != null) { if (tameli.TameliDate == "null") { SelectSql += " AND TAMELI_DATE is NULL "; } else if (tameli.TameliDate == "notnull") { SelectSql += " AND TAMELI_DATE is not NULL "; } else if (tameli.TameliDate != "") { SelectSql += " AND TAMELI_DATE = :TameliDate"; ParamLIST.Add(Utilities.GetOraParam(":TameliDate", tameli.TameliDate, OracleDbType.Varchar2, ParameterDirection.Input)); } } if (tameli.SecClrkRcvdDate != null) { if (tameli.SecClrkRcvdDate == "null") { SelectSql += " AND SEC_CLRK_RCVD_DATE is NULL "; } else if (tameli.TameliDate == "notnull") { SelectSql += " AND TAMELI_DATE is not NULL "; } else if (tameli.TameliYesNo != "") { SelectSql += " AND SEC_CLRK_RCVD_DATE = :SecClrkRcvdDate"; ParamLIST.Add(Utilities.GetOraParam(":SecClrkRcvdDate", tameli.SecClrkRcvdDate, OracleDbType.Varchar2, ParameterDirection.Input)); } } if (tameli.VerifiedYesNo != null) { if (tameli.VerifiedYesNo == "null") { SelectSql += " AND VERIFIED_YES_NO is NULL "; } else if (tameli.VerifiedYesNo == "notnull") { SelectSql += " AND VERIFIED_YES_NO is not NULL "; } else { SelectSql += " AND VERIFIED_YES_NO = :VerifiedYesNo"; ParamLIST.Add(Utilities.GetOraParam(":VerifiedYesNo", tameli.VerifiedYesNo, OracleDbType.Varchar2, ParameterDirection.Input)); } } SelectSql += " ORDER BY ISSUED_DATE"; GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.CMS); DataSet ds = SqlHelper.ExecuteDataset(DBConn, CommandType.Text, SelectSql, ParamLIST.ToArray()); return((DataTable)ds.Tables[0]); //DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, SelectSql, ParamLIST.ToArray()); //return (DataTable)ds.Tables[0]; } catch (Exception ex) { throw ex; } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (grdTameli.SelectedIndex < 0) { lblStatusMessage.Text = "Select Tameli To Be Processed"; this.programmaticModalPopup.Show(); return; } if (txtTameliDate.Text == "____/__/__" || txtTameliDate.Text.Trim() == "") { lblStatusMessage.Text = "Tameli Date Missing"; this.programmaticModalPopup.Show(); return; } if (txtSecClrkRcvdDate.Text == "____/__/__" || txtSecClrkRcvdDate.Text.Trim() == "") { lblStatusMessage.Text = "SectionClerk Received Date Missing"; this.programmaticModalPopup.Show(); return; } if (rdblstTameliSuccess.SelectedIndex < 0) { lblStatusMessage.Text = "Choose Success Yes/No"; this.programmaticModalPopup.Show(); return; } else if (rdblstTameliSuccess.SelectedIndex == 0) { if (ddlTameliStatus.SelectedIndex < 1) { lblStatusMessage.Text = "Select Tameli Status"; this.programmaticModalPopup.Show(); return; } //if (ddlTameliStatus.SelectedIndex == 1) //{ // if (true) // { //if (txtTameliWitnessPerson.Text.Trim() == "") //{ // lblStatusMessage.Text = "Tameli Witness Person Missing"; // this.programmaticModalPopup.Show(); // return; //} //if (txtPost.Text.Trim() == "") //{ // lblStatusMessage.Text = "Post of Tameli Witness Person Missing"; // this.programmaticModalPopup.Show(); // return; //} // } //} } ATTTameli tamProcess = new ATTTameli(); ATTTameliSearch tamSearch = TameliSend[grdTameli.SelectedIndex]; tamProcess.CaseID = tamSearch.CaseID; tamProcess.LitigantID = tamSearch.LitigantID; tamProcess.IssuedDate = tamSearch.IssuedDate; tamProcess.SeqNo = tamSearch.SeqNo; tamProcess.TameliDate = txtTameliDate.Text.Trim(); tamProcess.SecClrkRcvdDate = txtSecClrkRcvdDate.Text.Trim(); tamProcess.TameliYesNo = rdblstTameliSuccess.SelectedValue; tamProcess.TameliStatusID = int.Parse(ddlTameliStatus.SelectedValue); //tamProcess.TameliStatusID = (tamProcess.TameliYesNo == "Y") ? int.Parse(ddlTameliStatus.SelectedValue) : null; tamProcess.TamilDaarRemrks = txtTameliRemarks.Text.ToString(); //if (tamProcess.TameliStatusID==1) if (tamProcess.TameliYesNo == "Y") { List <ATTTameliWitnessPerson> lst = TameliWitnessPers; foreach (ATTTameliWitnessPerson var in lst) { var.CaseID = tamProcess.CaseID; var.LitigantID = tamProcess.LitigantID; var.IssuedDate = tamProcess.IssuedDate; var.SeqNo = tamProcess.SeqNo; var.Action = "A"; var.EntryBy = entryBy; } tamProcess.TameliWitnessPersonLIST = lst; } if (BLLTameli.SaveTamelildaarFeedBack(tamProcess)) { lblStatusMessage.Text = "Tameli Processed Successfully"; this.programmaticModalPopup.Show(); } else { lblStatusMessage.Text = "Problem Occured"; this.programmaticModalPopup.Show(); } ClearSession(); LoadTameliList(); ClearControls(); LoadDeleteData(); } catch (Exception ex) { lblStatusMessage.Text = "Select Tameli To Be Processed " + ex.Message.ToString(); this.programmaticModalPopup.Show(); } }