void LoadRespondents(int?caseID)
{
ATTLitigantSearch obj = new ATTLitigantSearch();
obj.CaseID = caseID;
obj.LitigantType = "R";
try
{
List <ATTLitigantSearch> LitigantSearch = BLLLitigantSearch.GetLitigantSearch(obj);
this.grdLitigantRes.DataSource = LitigantSearch;
this.grdLitigantRes.DataBind();
if (LitigantSearch.Count > 0)
{
this.colCaseSearch.Collapsed = true;
this.colCaseSearch.ClientState = "true";
this.colRespondent.Collapsed = false;
this.colRespondent.ClientState = "false";
}
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
private void GetAllLitigants(int caseID)
{
try
{
ATTLitigantSearch obj = new ATTLitigantSearch();
obj.CourtID = courtID;
obj.CaseID = caseID;
List <ATTLitigantSearch> lstLitigants = BLLLitigantSearch.GetLitigantSearch(obj);
LitigantsLIST = lstLitigants;
}
catch (Exception ex)
{
lblStatusMessage.Text = ex.Message.ToString();
this.programmaticModalPopup.Show();
}
}
protected void btnSearchLitigants_Click(object sender, EventArgs e)
{
if (txtCaseNo.Text.Trim() == "" && txtRegNo.Text.Trim() == "")
{
lblStatusMessage.Text = "All Fields Can't be empty";
this.programmaticModalPopup.Show();
return;
}
ATTLitigantSearch obj = new ATTLitigantSearch();
if (txtCaseNo.Text.Trim() == "___-__-____" && txtRegNo.Text.Trim() == "__-___-_____")
{
lblStatusMessage.Text = "All Fields Can't be empty";
this.programmaticModalPopup.Show();
return;
}
if (txtRegNo.Text.Trim() == "__-___-_____")
{
obj.RegNo = "";
}
else
{
obj.RegNo = txtRegNo.Text;
}
if (txtCaseNo.Text.Trim() == "___-__-____")
{
obj.CaseNo = "";
}
else
{
obj.CaseNo = txtCaseNo.Text;
}
try
{
grdLitigants.DataSource = BLLLitigantSearch.GetLitigantSearch(obj);
grdLitigants.DataBind();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
void LoadLitigantsAndAttorney(double caseID)
{
try
{
ATTLitigantSearch attLitigant = new ATTLitigantSearch();
attLitigant.CaseID = caseID;
List <ATTLitigantSearch> LitigantList = BLLLitigantSearch.GetLitigantSearch(attLitigant);
List <ATTAttorney> AttorneyList = BLLAttorney.GetAttorney(caseID, "Y");
List <ATTLitigantandAttorney> lstLA = new List <ATTLitigantandAttorney>();
foreach (ATTLitigantSearch attL in LitigantList)
{
ATTLitigantandAttorney attLA = new ATTLitigantandAttorney();
attLA.CaseID = attL.CaseID;
attLA.LitigantID = attL.LitigantID;
attLA.AttorneyID = 0;
attLA.Name = attL.LitigantName;
attLA.Gender = attL.Gender;
attLA.DOB = attL.DOB;
lstLA.Add(attLA);
}
foreach (ATTAttorney attA in AttorneyList)
{
ATTLitigantandAttorney attLA = new ATTLitigantandAttorney();
attLA.CaseID = attA.CaseID;
attLA.AttorneyID = attA.LitigantID;
attLA.LitigantID = 0;
attLA.Name = attA.AttorneyName;
attLA.Gender = attA.AttorneyGender;
attLA.DOB = attA.AttorneyDOB;
lstLA.Add(attLA);
}
grdLitigants.DataSource = lstLA;
grdLitigants.DataBind();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
ATTLitigantSearch obj = new ATTLitigantSearch();
if (txtCaseNo.Text.Trim() == "___-__-____" && txtRegNo.Text.Trim() == "__-___-_____")
{
lblStatusMessage.Text = "All Fields Can't be empty";
this.programmaticModalPopup.Show();
return;
}
if (txtRegNo.Text.Trim() == "__-___-____")
{
obj.RegNo = "";
}
else
{
obj.RegNo = txtRegNo.Text;
}
if (txtCaseNo.Text.Trim() == "___-__-____")
{
obj.CaseNo = "";
}
else
{
obj.CaseNo = txtCaseNo.Text;
}
List <ATTLitigantSearch> AppellantList = new List <ATTLitigantSearch>();
List <ATTLitigantSearch> RespondantList = new List <ATTLitigantSearch>();
try
{
List <ATTLitigantSearch> LitigantList = BLLLitigantSearch.GetLitigantSearch(obj);
Session["CaseID"] = double.Parse(LitigantList[0].CaseID.ToString());
foreach (ATTLitigantSearch att in LitigantList)
{
if (att.LitigantType == "A")
{
ATTLitigantSearch attA = new ATTLitigantSearch();
attA.LitigantName = att.LitigantName;
attA.Gender = att.Gender;
attA.DOB = att.DOB;
attA.IsPrisoned = att.IsPrisoned;
attA.LitigantSubTypeName = att.LitigantSubTypeName;
AppellantList.Add(attA);
}
else
{
ATTLitigantSearch attR = new ATTLitigantSearch();
attR.LitigantName = att.LitigantName;
attR.Gender = att.Gender;
attR.DOB = att.DOB;
attR.IsPrisoned = att.IsPrisoned;
attR.LitigantSubTypeName = att.LitigantSubTypeName;
RespondantList.Add(attR);
}
}
grdAppellant.DataSource = AppellantList;
grdAppellant.DataBind();
grdRespondent.DataSource = RespondantList;
grdRespondent.DataBind();
}
catch (Exception ex)
{
lblStatusMessage.Text = ex.Message;
programmaticModalPopup.Show();
}
}
public static DataTable GetLitigantSearch(ATTLitigantSearch litigantSearch)
{
try
{
string SelectSql = "SELECT * FROM VW_CASE_REGISTRATION WHERE 1=1 ";
List <OracleParameter> ParamLIST = new List <OracleParameter>();
if (litigantSearch.CourtID > 0)
{
SelectSql += " AND COURT_ID = :CourtId";
ParamLIST.Add(Utilities.GetOraParam(":CourtId", litigantSearch.CourtID, OracleDbType.Int64, ParameterDirection.Input));
}
if (litigantSearch.CaseID > 0)
{
SelectSql += " AND CASE_ID = :CaseId";
ParamLIST.Add(Utilities.GetOraParam(":CaseId", litigantSearch.CaseID, OracleDbType.Int64, ParameterDirection.Input));
}
if (!string.IsNullOrEmpty(litigantSearch.CaseNo))
{
SelectSql += " AND CASE_NUMBER = :CaseNo";
ParamLIST.Add(Utilities.GetOraParam(":CaseNo", litigantSearch.CaseNo, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (!string.IsNullOrEmpty(litigantSearch.RegNo))
{
SelectSql += " AND REG_NUMBER = :RegNo";
ParamLIST.Add(Utilities.GetOraParam(":RegNo", litigantSearch.RegNo, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (!string.IsNullOrEmpty(litigantSearch.LitigantType))
{
SelectSql += " AND LITIGANT_TYPE = :LitigantType";
ParamLIST.Add(Utilities.GetOraParam(":LitigantType", litigantSearch.LitigantType, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (litigantSearch.LitigantSubTypeID > 0)
{
SelectSql += " AND LITIGANT_SUB_TYPE_ID = :LitigantSubTypeId";
ParamLIST.Add(Utilities.GetOraParam(":LitigantSubTypeId", litigantSearch.LitigantSubTypeID, OracleDbType.Int64, ParameterDirection.Input));
}
if (!string.IsNullOrEmpty(litigantSearch.AccountForwarded))
{
SelectSql += " AND ACCOUNT_FORWARDED = :AccForwarded";
ParamLIST.Add(Utilities.GetOraParam(":AccForwarded", litigantSearch.AccountForwarded, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (!string.IsNullOrEmpty(litigantSearch.Verified))
{
SelectSql += " AND Verified = :Verified";
ParamLIST.Add(Utilities.GetOraParam(":Verified", litigantSearch.Verified, 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 <ATTLitigantSearch> GetLitigantSearch(ATTLitigantSearch litigantSearch)
{
try
{
List <ATTLitigantSearch> litigantLIST = new List <ATTLitigantSearch>();
foreach (DataRow drow in DLLLitigantSearch.GetLitigantSearch(litigantSearch).Rows)
{
ATTLitigantSearch litigant = new ATTLitigantSearch();
if (drow["CASE_ID"] != null)
{
if (drow["CASE_ID"].ToString() != "")
{
litigant.CaseID = int.Parse(drow["CASE_ID"].ToString());
}
}
if (drow["COURT_ID"] != null)
{
if (drow["COURT_ID"].ToString() != "")
{
litigant.CourtID = int.Parse(drow["COURT_ID"].ToString());
}
}
litigant.CaseRegDate = drow["CASE_REG_DATE"].ToString();
litigant.CaseNo = drow["CASE_NUMBER"].ToString();
litigant.RegNo = drow["REG_NUMBER"].ToString();
if (drow["CASE_TYPE_ID"] != null)
{
if (drow["CASE_TYPE_ID"].ToString() != "")
{
litigant.CaseTypeID = int.Parse(drow["CASE_TYPE_ID"].ToString());
}
}
litigant.CaseTypeName = drow["CASE_TYPE_NAME"].ToString();
if (drow["REG_DIARY_ID"] != null)
{
if (drow["REG_DIARY_ID"].ToString() != "")
{
litigant.RegistrationDiaryID = int.Parse(drow["REG_DIARY_ID"].ToString());
}
}
litigant.RegistrationDiary = drow["REG_DIARY"].ToString();
litigant.RegistrationDiaryCode = drow["REG_DIARY_CODE"].ToString();
if (drow["REG_SUBJECT_ID"] != null)
{
if (drow["REG_SUBJECT_ID"].ToString() != "")
{
litigant.RegistrationSubjectID = int.Parse(drow["REG_SUBJECT_ID"].ToString());
}
}
litigant.SubjectName = drow["SUBJECT_NAME"].ToString();
if (drow["REG_DIARY_NAME_ID"] != null)
{
if (drow["REG_DIARY_NAME_ID"].ToString() != "")
{
litigant.RegistrationDiaryNameID = int.Parse(drow["REG_DIARY_NAME_ID"].ToString());
}
}
litigant.RegistrationDiaryName = drow["REG_DIARY_NAME"].ToString();
if (drow["WRIT_SUB_ID"] != null)
{
if (drow["WRIT_SUB_ID"].ToString() != "")
{
litigant.WritSubID = int.Parse(drow["WRIT_SUB_ID"].ToString());
}
}
litigant.WritSubName = drow["WRIT_SUB_NAME"].ToString();
if (drow["WRIT_CAT_ID"] != null)
{
if (drow["WRIT_CAT_ID"].ToString() != "")
{
litigant.WritCatID = int.Parse(drow["WRIT_CAT_ID"].ToString());
}
}
litigant.WritSubCatName = drow["WRIT_SUB_CAT_NAME"].ToString();
if (drow["WRIT_CAT_TITLE_ID"] != null)
{
if (drow["WRIT_CAT_TITLE_ID"].ToString() != "")
{
litigant.WritCatTitleID = int.Parse(drow["WRIT_CAT_TITLE_ID"].ToString());
}
}
litigant.WritSubCatTitleName = drow["WRIT_SUB_CAT_TITLE_NAME"].ToString();
if (drow["WRIT_CAT_SUBTITLE_ID"] != null)
{
if (drow["WRIT_CAT_SUBTITLE_ID"].ToString() != "")
{
litigant.WritCatSubTitleID = int.Parse(drow["WRIT_CAT_SUBTITLE_ID"].ToString());
}
}
litigant.WritSubCatSubTitleName = drow["WRIT_SUB_CAT_SUBTITLE_NAME"].ToString();
litigant.LitigantID = int.Parse(drow["LITIGANT_ID"].ToString());
litigant.LitigantName = drow["LITIGANTNAME"].ToString();
litigant.DOB = drow["DOB"].ToString();
litigant.Gender = drow["GENDER"].ToString();
litigant.DisplayName = drow["DISPLAY_NAME"].ToString();
litigant.LitigantType = drow["LITIGANT_TYPE"].ToString();
if (drow["LITIGANT_SUB_TYPE_ID"] != null)
{
if (drow["LITIGANT_SUB_TYPE_ID"].ToString() != "")
{
litigant.LitigantSubTypeID = int.Parse(drow["LITIGANT_SUB_TYPE_ID"].ToString());
}
}
litigant.LitigantSubTypeName = drow["LITIGANT_SUB_TYPE_NAME"].ToString();
if (drow["S_NO"] != null)
{
if (drow["S_NO"].ToString() != "")
{
litigant.SNo = int.Parse(drow["S_NO"].ToString());
}
}
litigant.IsPrisoned = drow["IS_PRISONED"].ToString();
litigant.AccountForwarded = drow["ACCOUNT_FORWARDED"].ToString();
litigant.Verified = drow["VERIFIED_YES_NO"].ToString();
litigantLIST.Add(litigant);
}
return(litigantLIST);
}
catch (Exception)
{
throw;
}
}
