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