protected void btnSearch_Click(object sender, EventArgs e) { if ((this.txtCauseListDate.Text == "____/__/__") || (this.txtCauseListDate.Text.Trim() == "")) { this.lblStatusMessage.Text = "Please Enter Cause List Date ."; this.programmaticModalPopup.Show(); return; } try { ////reset sessions Cases = null; CasesNotAssigned = null; CasesSave = null; ////// ATTCaseSearchForCBA obj = new ATTCaseSearchForCBA(); obj.CourtID = orgID; obj.ClDate = txtCauseListDate.Text; List <ATTCaseSearchForCBA> lst = BLLCaseSeachForCBA.GetCaseSearch(obj); Cases = lst; CasesNotAssigned = lst.FindAll( delegate(ATTCaseSearchForCBA ob) { return(string.IsNullOrEmpty(ob.AssignmentDate)); } ); grdCase.DataSource = CasesNotAssigned; CaseCount = lst.Count; grdCase.DataBind(); grdCase.SelectedIndex = -1; if (lst.Count > 0) { pnlCase.Height = Unit.Pixel(150); } else { pnlCase.Height = Unit.Pixel(5); } } catch (Exception ex) { lblStatusMessage.Text = ex.Message.ToString(); this.programmaticModalPopup.Show(); } }
public static DataTable GetCaseSearch(ATTCaseSearchForCBA caseSearch) { try { string SelectSql = "SELECT * FROM VW_CAUSE_LIST 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.ClDate)) { SelectSql += " AND CL_DATE = :ClDate"; ParamLIST.Add(Utilities.GetOraParam("ClDate", caseSearch.ClDate, OracleDbType.Varchar2, 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 (!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; } }
public static List <ATTCaseSearchForCBA> GetCaseSearch(ATTCaseSearchForCBA caseSrchSearch) { try { List <ATTCaseSearchForCBA> caseSrchLIST = new List <ATTCaseSearchForCBA>(); foreach (DataRow drow in DLLCaseSearchForCBA.GetCaseSearch(caseSrchSearch).Rows) { ATTCaseSearchForCBA caseSrch = new ATTCaseSearchForCBA(); 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(); caseSrch.ClDate = drow["CL_DATE"].ToString(); caseSrch.ClEntryTypeName = drow["CL_ENTRY_TYPE_NAME"].ToString(); caseSrch.AssignmentDate = drow["ASSIGNMENT_DATE"].ToString(); if (drow["BENCH_TYPE_ID"] != null) { if (drow["BENCH_TYPE_ID"].ToString() != "") { caseSrch.BenchTypeID = int.Parse(drow["BENCH_TYPE_ID"].ToString()); } } if (drow["BENCH_NO"] != null) { if (drow["BENCH_NO"].ToString() != "") { caseSrch.BenchNo = int.Parse(drow["BENCH_NO"].ToString()); } } caseSrch.FormDate = drow["FROM_DATE"].ToString(); if (drow["SEQ_NO"] != null) { if (drow["SEQ_NO"].ToString() != "") { caseSrch.SeqNo = int.Parse(drow["SEQ_NO"].ToString()); } } if (drow["BEN_STATUS_ID"] != null) { if (drow["BEN_STATUS_ID"].ToString() != "") { caseSrch.BenStatusID = int.Parse(drow["BEN_STATUS_ID"].ToString()); } } caseSrch.BenStatusName = drow["BEN_SATUS_NAME"].ToString(); caseSrch.Remarks = drow["BEN_REMARKS"].ToString(); if (drow["PRIORITY"] != null) { if (drow["PRIORITY"].ToString() != "") { caseSrch.Priority = int.Parse(drow["PRIORITY"].ToString()); } } caseSrchLIST.Add(caseSrch); } return(caseSrchLIST); } catch (Exception) { throw; } }
protected void btnSearch_Click(object sender, EventArgs e) { if ((this.txtCauseListDate.Text == "____/__/__") || (this.txtCauseListDate.Text.Trim() == "")) { this.lblStatusMessage.Text = "Please Enter Cause List Date ."; this.programmaticModalPopup.Show(); return; } try { ATTCaseSearchForCBA obj = new ATTCaseSearchForCBA(); obj.CourtID = orgID; obj.ClDate = txtCauseListDate.Text; //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 (txtCauseListDate.Text.Trim() != "" && txtCauseListDate.Text.Trim() != "____/__/__") obj.RegDate = txtCauseListDate.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 <ATTCaseSearchForCBA> lst = BLLCaseSeachForCBA.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(); } }