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