private void LoadMisil()
{
ATTMisil objmisil = new ATTMisil();
MisilDartaa = null;
MisilChalaani = null;
MisilReply = null;
objmisil.ReqOrg = orgID;
List <ATTMisil> MisilLST = BLLMisil.GetMisilForProcessing(objmisil);
MisilDartaa = MisilLST.FindAll(delegate(ATTMisil obj)
{
return(obj.ReqRecDartaNo.Trim() == "");
}
);
MisilChalaani = MisilLST.FindAll(delegate(ATTMisil obj)
{
return(obj.ReqReplyChalaniNo.Trim() == "" && obj.ReqRecDartaNo.Trim() != "");
}
);
MisilReply = MisilLST.FindAll(delegate(ATTMisil obj)
{
return(obj.ReqReplyChalaniNo.Trim() != "" && obj.ReqRecDartaNo.Trim() != "" && obj.RecDartaNo.Trim() == "");
}
);
}
public static DataTable GetMisilForProcessing(ATTMisil att)
{
try
{
string SelectSql = "SELECT * FROM VW_MISIL_PROCESS WHERE 1=1 ";
List <OracleParameter> ParamLIST = new List <OracleParameter>();
if (att.ReqOrg > 0)
{
SelectSql += " AND REQ_ORG = :CourtId";
ParamLIST.Add(Utilities.GetOraParam(":CourtId", att.ReqOrg, OracleDbType.Int64, ParameterDirection.Input));
}
//SelectSql += " AND REQ_REPLY_CHALAANI_NO IS NULL ";
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]);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Session["CaseID"] == null)
{
lblStatusMessage.Text = "Please Litigant First";
programmaticModalPopup.Show();
return;
}
if (DDLMisilType.SelectedIndex == -1)
{
lblStatusMessage.Text = "Please Misil Type First";
programmaticModalPopup.Show();
return;
}
if (DDLReqOrg.SelectedIndex == -1)
{
lblStatusMessage.Text = "Please Organization First";
programmaticModalPopup.Show();
return;
}
if (txtReqDate.Text == "")
{
lblStatusMessage.Text = "Please Enter Requested Date First";
programmaticModalPopup.Show();
return;
}
ATTMisil objMisil = new ATTMisil();
objMisil.CaseID = double.Parse(Session["CaseID"].ToString());
objMisil.ReqDate = txtReqDate.Text.Trim();
objMisil.ReqOrg = int.Parse(DDLReqOrg.SelectedValue);
objMisil.DocTypeID = int.Parse(DDLMisilType.SelectedValue);
objMisil.ReqChalaniNo = txtReqChalaniNo.Text.Trim();
objMisil.ReqRecDate = txtReqRecDate.Text.Trim();
objMisil.ReqRecDartaNo = txtReqRecRegNo.Text.Trim();
objMisil.ReqRecPID = double.Parse(hdnReqRecPersonID.Value.ToString());
objMisil.ReqReplyDate = txtReqReplyDate.Text.Trim();
objMisil.ReqReplyChalaniNo = txtReqReplyChalaniNo.Text.Trim();
objMisil.RecDate = txtRecDate.Text.Trim();
objMisil.RecDartaNo = txtRecRegNo.Text.Trim();
objMisil.RecPID = double.Parse(hdnRecPersonID.Value.ToString());
objMisil.IsReturn = (chkIsReturned.Checked == true) ? "Y" : "N";
objMisil.ReturnDate = txtReturnDate.Text.Trim();
objMisil.Remarks = txtRemarks.Text.Trim();
objMisil.EntryBy = strUser;
try
{
BLLMisil.SaveMisil(objMisil);
ClearCotrols();
}
catch (Exception ex)
{
lblStatusMessage.Text = ex.Message;
programmaticModalPopup.Show();
}
}
public static bool EditMisil(ATTMisil attCAM)
{
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.CMS);
//OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction();
string InsertUpdateSQL = "SP_EDIT_MISIL";
try
{
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":P_CASE_ID", attCAM.CaseID, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_REQ_DATE", attCAM.ReqDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_REQ_ORG", attCAM.ReqOrg, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_DOC_TYPE_ID", attCAM.DocTypeID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_REQ_CHALAANI_NO", attCAM.ReqChalaniNo, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_REQ_RCVD_DATE", attCAM.ReqRecDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_REQ_RCVD_DARTAA_NO", attCAM.ReqRecDartaNo, OracleDbType.Varchar2, ParameterDirection.Input));
if (attCAM.ReqRecPID == 0)
{
paramArray.Add(Utilities.GetOraParam(":P_REQ_RCVD_P_ID", null, OracleDbType.Double, ParameterDirection.Input));
}
else
{
paramArray.Add(Utilities.GetOraParam(":P_REQ_RCVD_P_ID", attCAM.ReqRecPID, OracleDbType.Double, ParameterDirection.Input));
}
paramArray.Add(Utilities.GetOraParam(":P_REQ_REPLY_DATE", attCAM.ReqReplyDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_REQ_REPLY_CHALAANI_NO", attCAM.ReqReplyChalaniNo, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_RCVD_DATE", attCAM.RecDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_RCVD_DARTAA_NO", attCAM.RecDartaNo, OracleDbType.Varchar2, ParameterDirection.Input));
if (attCAM.RecPID == 0)
{
paramArray.Add(Utilities.GetOraParam(":P_RCVD_P_ID", null, OracleDbType.Double, ParameterDirection.Input));
}
else
{
paramArray.Add(Utilities.GetOraParam(":P_RCVD_P_ID", attCAM.RecPID, OracleDbType.Double, ParameterDirection.Input));
}
paramArray.Add(Utilities.GetOraParam(":P_IS_RETURN", attCAM.IsReturn, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_RETURN_DATE", attCAM.ReturnDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_REMARKS", attCAM.Remarks, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", attCAM.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray());
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
public static bool EditMisil(ATTMisil att)
{
try
{
return(DLLMisil.EditMisil(att));
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTMisil> GetMisilForProcessing(ATTMisil searchCriteria)
{
try
{
List <ATTMisil> lstMisil = new List <ATTMisil>();
foreach (DataRow dr in DLLMisil.GetMisilForProcessing(searchCriteria).Rows)
{
ATTMisil obj = new ATTMisil();
obj.CaseID = double.Parse(dr["CASE_ID"].ToString());
obj.ReqDate = dr["REQ_DATE"].ToString();
obj.ReqOrg = int.Parse(dr["REQ_ORG"].ToString());
obj.DocTypeID = int.Parse(dr["DOCUMENT_TYPE_ID"].ToString());
obj.DocTYpeName = dr["DOCUMENT_TYPE_NAME"].ToString();
obj.ReqChalaniNo = dr["REQ_CHALAANI_NO"].ToString();
obj.ReqRecDate = dr["REQ_RCVD_DATE"].ToString();
obj.ReqRecDartaNo = dr["REQ_RCVD_DARTAA_NO"].ToString();
obj.ReqRecPID = double.Parse((dr["REQ_RCVD_P_ID"].ToString() == "" ? "0" : dr["REQ_RCVD_P_ID"].ToString()));
obj.ReqReplyDate = dr["REQ_REPLY_DATE"].ToString();
obj.ReqReplyChalaniNo = dr["REQ_REPLY_CHALAANI_NO"].ToString();
obj.RecDate = dr["RCVD_DATE"].ToString();
obj.RecDartaNo = dr["RCVD_DARTAA_NO"].ToString();
obj.RecPID = double.Parse((dr["RCVD_P_ID"].ToString() == "" ? "0" : dr["RCVD_P_ID"].ToString()));
obj.OrgName = dr["ORG_NAME"].ToString();
obj.IsReturn = dr["IS_RETURN"].ToString();
obj.ReturnDate = dr["RETURN_DATE"].ToString();
obj.Remarks = dr["REMARKS"].ToString();
obj.CaseNo = dr["CASE_NUMBER"].ToString();
obj.RegNo = dr["REG_NUMBER"].ToString();
obj.CaseTypeName = dr["CASE_TYPE_NAME"].ToString();
//obj.CaseName = dr["CASE_NAME"].ToString();
obj.Appelant = dr["APPELLANT"].ToString();
obj.Respondant = dr["RESPONDENT"].ToString();
lstMisil.Add(obj);
}
return(lstMisil);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSubmitMisilReply_Click(object sender, EventArgs e)
{
if (grdReply.SelectedIndex == -1)
{
lblStatusMessage.Text = "Select Misil";
this.programmaticModalPopup.Show();
return;
}
if (txtReqReplyReceivedDate.Text.Trim() == "")
{
lblStatusMessage.Text = "Dartaa No Missing";
this.programmaticModalPopup.Show();
return;
}
if (txtReqReplyDartaaNo.Text.Trim() == "")
{
lblStatusMessage.Text = "Received Date Missing";
this.programmaticModalPopup.Show();
return;
}
ATTMisil misil = MisilReply[grdReply.SelectedIndex];
misil.RecDate = txtReqReplyReceivedDate.Text.Trim();
misil.RecDartaNo = txtReqReplyDartaaNo.Text.Trim();
misil.RecPID = userID;
if (BLLMisil.EditMisil(misil))
{
lblStatusMessage.Text = "Misil Information Saved Successfully";
this.programmaticModalPopup.Show();
}
else
{
lblStatusMessage.Text = "Misil Information Was not Saved";
this.programmaticModalPopup.Show();
}
ClearControlsReply();
}
protected void btnSubmitMisilChalaani_Click(object sender, EventArgs e)
{
if (grdMisilChalaani.SelectedIndex == -1)
{
lblStatusMessage.Text = "Select Misil";
this.programmaticModalPopup.Show();
return;
}
if (txtReplyDate.Text.Trim() == "")
{
lblStatusMessage.Text = "Reply Date Missing";
this.programmaticModalPopup.Show();
return;
}
if (txtChalaaniNo.Text.Trim() == "")
{
lblStatusMessage.Text = "Chalaani No Missing";
this.programmaticModalPopup.Show();
return;
}
ATTMisil misil = MisilChalaani[grdMisilChalaani.SelectedIndex];
misil.ReqReplyDate = txtReplyDate.Text.Trim();
misil.ReqReplyChalaniNo = txtChalaaniNo.Text.Trim();
if (BLLMisil.EditMisil(misil))
{
lblStatusMessage.Text = "Misil Information Saved Successfully";
this.programmaticModalPopup.Show();
}
else
{
lblStatusMessage.Text = "Misil Information Was not Saved";
this.programmaticModalPopup.Show();
}
ClearControlsChalaani();
}
