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();
}
}
