protected void btnSearch_Click(object sender, EventArgs e) { if ((this.ddlCaseType.SelectedIndex < 1) && (this.txtRegDate.Text == "____/__/__") && (this.txtAppelantName.Text.Trim() == "") && (this.txtRespondantName.Text.Trim() == "")) { this.lblStatusMessage.Text = "Please Enter (Or) Select Atleast One Field."; this.programmaticModalPopup.Show(); return; } try { ATTCaseSearch obj = new ATTCaseSearch(); //obj.CourtID = orgID; if (ddlCaseType.SelectedIndex > 0) { obj.CaseTypeID = int.Parse(ddlCaseType.SelectedValue); } if (txtRegDate.Text.Trim() != "" && txtRegDate.Text.Trim() != "____/__/__") { obj.RegDate = txtRegDate.Text; } if (txtAppelantName.Text.Trim() != "") { obj.Appelant = txtAppelantName.Text; } if (txtRespondantName.Text.Trim() != "") { obj.Respondant = txtRespondantName.Text; } obj.Verified = "U"; obj.DecisionYesNo = null; List <ATTCaseSearch> lst = BLLCaseSearch.GetCaseSearch(obj); Session["CaseRegistration"] = lst; grdCase.DataSource = lst; // CaseCount = lst.Count; grdCase.DataBind(); grdCase.SelectedIndex = -1; this.lblSearch.Text = "Total Records:- " + lst.Count; } catch (Exception ex) { lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); } }
public static List <ATTCaseSearch> GetCaseSearch(ATTCaseSearch caseSrchSearch) { try { List <ATTCaseSearch> caseSrchLIST = new List <ATTCaseSearch>(); foreach (DataRow drow in DLLCaseSearch.GetCaseSearch(caseSrchSearch).Rows) { ATTCaseSearch caseSrch = new ATTCaseSearch(); if (drow["CASE_ID"] != null) { if (drow["CASE_ID"].ToString() != "") { caseSrch.CaseID = int.Parse(drow["CASE_ID"].ToString()); } } if (drow["COURT_ID"] != null) { if (drow["COURT_ID"].ToString() != "") { caseSrch.CourtID = int.Parse(drow["COURT_ID"].ToString()); } } caseSrch.CaseRegDate = drow["CASE_REG_DATE"].ToString(); caseSrch.CaseNo = drow["CASE_NUMBER"].ToString(); caseSrch.RegNo = drow["REG_NUMBER"].ToString(); if (drow["CASE_TYPE_ID"] != null) { if (drow["CASE_TYPE_ID"].ToString() != "") { caseSrch.CaseTypeID = int.Parse(drow["CASE_TYPE_ID"].ToString()); } } caseSrch.CaseTypeName = drow["CASE_TYPE_NAME"].ToString(); if (drow["REG_DIARY_ID"] != null) { if (drow["REG_DIARY_ID"].ToString() != "") { caseSrch.RegistrationDiaryID = int.Parse(drow["REG_DIARY_ID"].ToString()); } } caseSrch.RegistrationDiary = drow["REG_DIARY_NAME"].ToString(); caseSrch.RegistrationDiaryCode = drow["REG_DIARY_CODE"].ToString(); if (drow["REG_SUBJECT_ID"] != null) { if (drow["REG_SUBJECT_ID"].ToString() != "") { caseSrch.RegistrationSubjectID = int.Parse(drow["REG_SUBJECT_ID"].ToString()); } } caseSrch.SubjectName = drow["SUBJECT_NAME"].ToString(); if (drow["REG_DIARY_NAME_ID"] != null) { if (drow["REG_DIARY_NAME_ID"].ToString() != "") { caseSrch.RegistrationDiaryNameID = int.Parse(drow["REG_DIARY_NAME_ID"].ToString()); } } caseSrch.RegDiaryNameDesc = drow["REG_DIARY_NAME_DESC"].ToString(); if (drow["WRIT_SUB_ID"] != null) { if (drow["WRIT_SUB_ID"].ToString() != "") { caseSrch.WritSubID = int.Parse(drow["WRIT_SUB_ID"].ToString()); } } caseSrch.WritSubName = drow["WRIT_SUB_NAME"].ToString(); if (drow["WRIT_CAT_ID"] != null) { if (drow["WRIT_CAT_ID"].ToString() != "") { caseSrch.WritCatID = int.Parse(drow["WRIT_CAT_ID"].ToString()); } } caseSrch.WritSubCatName = drow["WRIT_SUB_CAT_NAME"].ToString(); if (drow["WRIT_CAT_TITLE_ID"] != null) { if (drow["WRIT_CAT_TITLE_ID"].ToString() != "") { caseSrch.WritCatTitleID = int.Parse(drow["WRIT_CAT_TITLE_ID"].ToString()); } } caseSrch.WritSubCatTitleName = drow["WRIT_SUB_CAT_TITLE_NAME"].ToString(); if (drow["WRIT_CAT_SUBTITLE_ID"] != null) { if (drow["WRIT_CAT_SUBTITLE_ID"].ToString() != "") { caseSrch.WritCatSubTitleID = int.Parse(drow["WRIT_CAT_SUBTITLE_ID"].ToString()); } } caseSrch.WritSubCatSubTitleName = drow["WRIT_SUB_CAT_SUBTITLE_NAME"].ToString(); caseSrch.AccountForwarded = drow["ACCOUNT_FORWARDED"].ToString(); caseSrch.Verified = drow["VERIFIED_YES_NO"].ToString(); if (drow["VERIFIED_BY"] != null) { if (drow["VERIFIED_BY"].ToString() != "") { caseSrch.VerifiedBy = int.Parse(drow["VERIFIED_BY"].ToString()); } } if (drow["DECISION_YES_NO"] != null) { if (drow["DECISION_YES_NO"].ToString() != "") { caseSrch.DecisionYesNo = drow["DECISION_YES_NO"].ToString(); } } caseSrch.VerifiedDate = drow["VERIFIED_DATE"].ToString(); caseSrch.DarpithRemarks = drow["DARPITH_REMARKS"].ToString(); if (drow["PROCEEDING_ID"] != null) { if (drow["PROCEEDING_ID"].ToString() != "") { caseSrch.ProceedingID = int.Parse(drow["PROCEEDING_ID"].ToString()); } } caseSrch.CaseSummary = drow["CASE_SUMMARY"].ToString(); if (drow["RELATED_CASE_ID"] != null) { if (drow["RELATED_CASE_ID"].ToString() != "") { caseSrch.RelatedCaseID = int.Parse(drow["RELATED_CASE_ID"].ToString()); } } caseSrch.FY = drow["FY"].ToString(); caseSrch.Appelant = drow["APPELLANT"].ToString(); caseSrch.Respondant = drow["RESPONDENT"].ToString(); caseSrchLIST.Add(caseSrch); } return(caseSrchLIST); } catch (Exception) { throw; } }
public static DataTable GetCaseSearch(ATTCaseSearch caseSearch) { try { string SelectSql = "SELECT * FROM VW_CASE_REG WHERE 1=1 "; List <OracleParameter> ParamLIST = new List <OracleParameter>(); if (caseSearch.CourtID > 0) { SelectSql += " AND COURT_ID = :CourtId"; ParamLIST.Add(Utilities.GetOraParam(":CourtId", caseSearch.CourtID, OracleDbType.Int64, ParameterDirection.Input)); } if (!string.IsNullOrEmpty(caseSearch.CaseNo)) { SelectSql += " AND CASE_NUMBER = :CaseNo"; ParamLIST.Add(Utilities.GetOraParam(":CaseNo", caseSearch.CaseNo, OracleDbType.Varchar2, ParameterDirection.Input)); } if (!string.IsNullOrEmpty(caseSearch.RegNo)) { SelectSql += " AND REG_NUMBER = :RegNo"; ParamLIST.Add(Utilities.GetOraParam(":RegNo", caseSearch.RegNo, OracleDbType.Varchar2, ParameterDirection.Input)); } if (caseSearch.CaseTypeID > 0) { SelectSql += " AND CASE_TYPE_ID = :CaseTypeID"; ParamLIST.Add(Utilities.GetOraParam(":CaseTypeID", caseSearch.CaseTypeID, OracleDbType.Int64, ParameterDirection.Input)); } if (!string.IsNullOrEmpty(caseSearch.RegDate)) { SelectSql += " AND CASE_REG_DATE = :RegDate"; ParamLIST.Add(Utilities.GetOraParam(":RegDate", caseSearch.RegDate, OracleDbType.Varchar2, ParameterDirection.Input)); } if (!string.IsNullOrEmpty(caseSearch.Appelant)) { SelectSql += " AND APPELLANT LIKE '%'|| :Appelant ||'%' "; ParamLIST.Add(Utilities.GetOraParam(":Appelant", caseSearch.Appelant, OracleDbType.Varchar2, ParameterDirection.Input)); } if (!string.IsNullOrEmpty(caseSearch.Respondant)) { SelectSql += " AND RESPONDENT LIKE '%'|| :Respondant ||'%' "; ParamLIST.Add(Utilities.GetOraParam(":Respondant", caseSearch.Respondant, OracleDbType.Varchar2, ParameterDirection.Input)); } //if (caseSearch.LitigantSubTypeID > 0) //{ // SelectSql += " AND LITIGANT_SUB_TYPE_ID = :LitigantSubTypeId"; // ParamLIST.Add(Utilities.GetOraParam(":LitigantSubTypeId", caseSearch.LitigantSubTypeID, OracleDbType.Int64, ParameterDirection.Input)); //} if (!string.IsNullOrEmpty(caseSearch.AccountForwarded)) { SelectSql += " AND ACCOUNT_FORWARDED = :AccForwarded"; ParamLIST.Add(Utilities.GetOraParam(":AccForwarded", caseSearch.AccountForwarded, OracleDbType.Varchar2, ParameterDirection.Input)); } if (caseSearch.Verified != null) { if (caseSearch.Verified == "U") { SelectSql += " AND VERIFIED_YES_NO is null"; } else { SelectSql += " AND VERIFIED_YES_NO = :Verified"; ParamLIST.Add(Utilities.GetOraParam(":Verified", caseSearch.Verified, OracleDbType.Varchar2, ParameterDirection.Input)); } } if (caseSearch.DecisionYesNo != null) { if (caseSearch.DecisionYesNo == "U") { SelectSql += " AND DECISION_YES_NO is null"; } else { SelectSql += " AND DECISION_YES_NO = :Verified"; ParamLIST.Add(Utilities.GetOraParam(":Verified", caseSearch.DecisionYesNo, OracleDbType.Varchar2, ParameterDirection.Input)); } } SelectSql += " ORDER BY CASE_ID"; 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 btnSearch_Click(object sender, EventArgs e) { if ((this.ddlCaseType.SelectedIndex < 1) && (this.txtCaseNo.Text == "___-__-____") && (this.txtRegNo.Text == "__-___-_____") && (this.txtRegDate.Text == "____/__/__") && (this.txtAppelantName.Text.Trim() == "") && (this.txtRespondantName.Text.Trim() == "")) { this.lblStatusMessage.Text = "Please Enter (Or) Select Atleast One Field."; this.programmaticModalPopup.Show(); return; } try { ATTCaseSearch obj = new ATTCaseSearch(); obj.CourtID = 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.RegDate = txtRegDate.Text; } if (txtAppelantName.Text.Trim() != "") { obj.Appelant = txtAppelantName.Text; } if (txtRespondantName.Text.Trim() != "") { obj.Respondant = txtRespondantName.Text; } if (VerifiedYesNo.ToString() == "Y") { obj.Verified = "Y"; } else if (VerifiedYesNo.ToString() == "N") { obj.Verified = "N"; } else if (VerifiedYesNo.ToString() == "U") { obj.Verified = "U"; } else { obj.Verified = null; } if (DecisionYesNo.ToString() == "Y") { obj.DecisionYesNo = "Y"; } else if (DecisionYesNo.ToString() == "N") { obj.DecisionYesNo = "N"; } else if (DecisionYesNo.ToString() == "U") { obj.DecisionYesNo = "U"; } else { obj.DecisionYesNo = null; } List <ATTCaseSearch> lst = BLLCaseSearch.GetCaseSearch(obj); grdCase.DataSource = lst; CaseCount = lst.Count; grdCase.DataBind(); grdCase.SelectedIndex = -1; if (lst.Count > 0) { pnlCase.Height = Unit.Pixel(150); } else { pnlCase.Height = Unit.Pixel(30); } if (i1 == 0)//to prevent the event below from executing more than 1 time { i1++; OnBubbleClickBtn(e); } } catch (Exception ex) { lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); } }