public static ObjectValidation Validate(ATTCaseRegistration caseX) { ObjectValidation result = new ObjectValidation(); if (caseX.CourtID <= 0) { result.IsValid = false; result.ErrorMessage = "Please select court."; return(result); } if (caseX.CaseRegistrationDate.Trim() == "") { result.IsValid = false; result.ErrorMessage = "Case registration date cannot be blank.."; return(result); } if (caseX.FY.Trim() == "") { result.IsValid = false; result.ErrorMessage = "Fiscal year cannot be blank.."; return(result); } return(result); }
//UPDATE CASE SUMMARY public static bool UpdateCaseSummary(ATTCaseRegistration objCaseRegistration) { string SP = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam("P_CASE_ID", objCaseRegistration.CaseID, OracleDbType.Double, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("P_CASE_SUMMARY", objCaseRegistration.CaseSummary, OracleDbType.Varchar2, ParameterDirection.Input)); GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "UPDATE_CASE_REG_SUMMARY", paramArray.ToArray()); if (objCaseRegistration.CaseDocumentLST.Count > 0) { List <ATTCaseDocuments> CDLST = DLLCaseDocuments.SaveCaseDocument(objCaseRegistration.CaseDocumentLST, Tran); int idx; foreach (ATTCaseDocumentsLit obj in objCaseRegistration.CaseDocumentLitLST) { idx = CDLST.FindIndex(delegate(ATTCaseDocuments objCD) { return(obj.DocSeq == objCD.DocSeq && obj.Action != ""); }); obj.DocumentID = CDLST[idx].DocumentID; } } if (objCaseRegistration.CaseDocumentLitLST.Count > 0) { DLLCaseDocumentLit.SaveCaseDocumentLit(objCaseRegistration.CaseDocumentLitLST, Tran); } if (objCaseRegistration.CaseEvidenceLST.Count > 0) { DLLCaseEvidence.SaveCaseEvidence(objCaseRegistration.CaseEvidenceLST, Tran); } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { GetConn.CloseDbConn(); } }
public static bool UpdateCaseSummary(ATTCaseRegistration objCase) { try { return(DLLCaseRegistration.UpdateCaseSummary(objCase)); } catch (Exception ex) { throw ex; } }
public static bool RegisterCase(ATTCaseRegistration objCase) { try { return(DLLCaseRegistration.RegisterCase(objCase)); } catch (Exception ex) { throw ex; } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (this.grdCase.SelectedIndex == -1) { this.lblStatusMessage.Text = "Please Select Case To Verify"; this.programmaticModalPopup.Show(); return; } if (this.ddlVerify.SelectedValue == "0") { this.lblStatusMessage.Text = "No Case is Verified"; this.programmaticModalPopup.Show(); return; } ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]); List <ATTCaseSearch> CaseRegLST = (List <ATTCaseSearch>)Session["CaseRegistration"]; ATTCaseRegistration CaseRegOBJ = new ATTCaseRegistration(); CaseRegOBJ.CaseID = double.Parse(this.grdCase.SelectedRow.Cells[2].Text); CaseRegOBJ.CourtID = CaseRegLST[this.grdCase.SelectedIndex].CourtID; CaseRegOBJ.CaseTypeID = CaseRegLST[this.grdCase.SelectedIndex].CaseTypeID; CaseRegOBJ.RegDiaryID = CaseRegLST[this.grdCase.SelectedIndex].RegistrationDiaryID; CaseRegOBJ.CaseRegistrationDate = CaseRegLST[this.grdCase.SelectedIndex].CaseRegDate; CaseRegOBJ.VerifiedYesNo = this.ddlVerify.SelectedValue; CaseRegOBJ.VerifiedBy = user.PID; CaseRegOBJ.VerifiedDate = this.txtVerifiedDate.Text; CaseRegOBJ.DarpithRemarks = this.txtDarpit.Text; CaseRegOBJ.Action = "E"; if (BLLCaseRegistration.RegisterCase(CaseRegOBJ) == true) { CaseRegLST.RemoveAll(delegate(ATTCaseSearch obj) { return(obj.CaseID == double.Parse(this.grdCase.SelectedRow.Cells[2].Text)); }); } this.grdCase.DataSource = CaseRegLST; this.grdCase.DataBind(); this.grdCase.SelectedIndex = -1; this.lblSearch.Text = "Total Records:- " + CaseRegLST.Count.ToString(); ClearControls(false); }
public static List <ATTCaseRegistration> GetCaseVerification(double?caseID, int defaultFlag, string verifiedYN) { List <ATTCaseRegistration> CaseRegList = new List <ATTCaseRegistration>(); try { foreach (DataRow row in DLLCaseRegistration.GetCaseVerification(caseID, verifiedYN).Rows) { ATTCaseRegistration objCaseReg = new ATTCaseRegistration(); objCaseReg.CaseID = double.Parse(row["CASE_ID"].ToString()); objCaseReg.CourtID = int.Parse(row["COURT_ID"].ToString()); objCaseReg.CaseTypeID = int.Parse(row["CASE_TYPE_ID"].ToString()); objCaseReg.CaseTypeName = row["CASE_TYPE_NAME"].ToString(); objCaseReg.RegDiaryID = int.Parse(row["REG_DIARY_ID"].ToString()); objCaseReg.RegDiaryName = row["REG_DIARY_NAME"].ToString(); objCaseReg.RegSubjectID = int.Parse(row["REG_SUBJECT_ID"].ToString()); objCaseReg.RegSubjectName = row["SUBJECT_NAME"].ToString(); objCaseReg.RegDiaryNameID = int.Parse(row["REG_DIARY_NAME_ID"].ToString()); objCaseReg.RegDiarySubName = row["REG_DIARY_SUB_NAME"].ToString(); objCaseReg.CaseRegistrationDate = row["CASE_REG_DATE"].ToString(); objCaseReg.ProceedingID = int.Parse(row["PROCEEDING_ID"].ToString()); objCaseReg.ProceedingType = row["PROCEEDING_NAME"].ToString(); objCaseReg.RegTypeID = int.Parse(row["REG_TYPE_ID"].ToString()); objCaseReg.RegTypeName = row["REG_TYPE_NAME"].ToString(); objCaseReg.AccountForwarded = row["ACCOUNT_FORWARDED"].ToString(); CaseRegList.Add(objCaseReg); } //if (defaultFlag > 0) // CaseStatusList.Insert(0, new ATTCaseStatus(0, "छान्नुहोस", "")); return(CaseRegList); } catch (Exception ex) { throw ex; } }
public ATTCaseRegistration LoadCaseRegistrationDetails(double caseNo, object sender, EventArgs e) { ATTCaseRegistration objCR = ((List <ATTCaseRegistration>)BLLCaseRegistration.GetCaseRegistration(caseNo, 1, 0, 1, 0, 0, 1, 1, 1, 0, null))[0]; lblCaseNo.Text = objCR.CaseID.ToString(); //Case Details this.lblCaseType.Text = objCR.CaseTypeName; this.lblRegType.Text = objCR.RegTypeName; this.lblRegDiary.Text = objCR.RegDiaryName; this.lblRegSubject.Text = objCR.RegSubjectName; this.lblRegSubName.Text = objCR.RegDiarySubName; this.lblRegDate.Text = objCR.CaseRegistrationDate; this.lblPreceedingType.Text = objCR.ProceedingType; this.lblForwardToAccount.Text = objCR.AccountForwarded == "Y" ? "पठाउने" : "नपठाउने"; Session["Appellant"] = objCR.AppellantLST; Session["Respondant"] = objCR.RespondantLST; this.grdAppellant.DataSource = objCR.AppellantLST; this.grdAppellant.DataBind(); this.grdRespondant.DataSource = objCR.RespondantLST; this.grdRespondant.DataBind(); this.heCaseSummary.Text = objCR.CaseSummary; this.grdEvidence.DataSource = objCR.CaseEvidenceLST; this.grdEvidence.DataBind(); Session["Evidence"] = objCR.CaseEvidenceLST; this.grdLitDocument.DataSource = objCR.CaseDocumentLitLST; this.grdLitDocument.DataBind(); Session["LitDocuments"] = objCR.CaseDocumentLitLST; return(objCR); }
protected void btnNext_Click(object sender, EventArgs e) { ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]); ATTCaseRegistration objCR = new ATTCaseRegistration(); objCR.CaseID = double.Parse(this.lblCaseNo.Text); objCR.CaseSummary = this.heCaseSummary.Text; objCR.Action = "E"; //ADDS CASE EVIDENCE TO THE LIST ATTCaseEvidence objCaseEvidence;// = new ATTCaseEvidence(); foreach (GridViewRow gvRow in this.grdEvidence.Rows) { if (CheckNull.NullString(gvRow.Cells[2].Text) != "") { objCaseEvidence = new ATTCaseEvidence(); objCaseEvidence.CaseID = double.Parse(this.lblCaseNo.Text); objCaseEvidence.EvidenceID = int.Parse(gvRow.Cells[0].Text); objCaseEvidence.Evidence = gvRow.Cells[1].Text; objCaseEvidence.EntryBy = user.UserName; objCaseEvidence.Action = gvRow.Cells[2].Text; objCR.CaseEvidenceLST.Add(objCaseEvidence); } } //ADDS CASE DOCUMENTS List <ATTCaseDocuments> CDocLST = (List <ATTCaseDocuments>)Session["CaseDocuments"]; //List<ATTCaseDocuments> CaseDocLST = new List<ATTCaseDocuments>(); //ATTCaseDocuments CaseDocOBJ; //foreach (DocFup obj in CDocLST) //{ // CaseDocOBJ = new ATTCaseDocuments(); // CaseDocOBJ.CaseID = double.Parse(lblCaseNo.Text); // CaseDocOBJ.DocSeq = obj.DocSeq; // CaseDocOBJ.DocumentID = 0; // CaseDocOBJ.DocumentFileName = obj.FileName; // CaseDocOBJ.DocumentContent = obj.FileContents; // CaseDocOBJ.EntryBy = "manoz"; // CaseDocOBJ.Action = "A"; // CaseDocLST.Add(CaseDocOBJ); //} CDocLST.RemoveAll(delegate(ATTCaseDocuments obj) { return(obj.DocumentFileName == null); }); objCR.CaseDocumentLST = CDocLST; //ADDS CASE LITIGANT DOCUMENTS List <ATTCaseDocumentsLit> CaseDocLitLST = (List <ATTCaseDocumentsLit>)Session["LitDocuments"]; CaseDocLitLST.RemoveAll(delegate(ATTCaseDocumentsLit obj) { return(obj.Action == ""); }); objCR.CaseDocumentLitLST = CaseDocLitLST; if (BLLCaseRegistration.UpdateCaseSummary(objCR) == true) { Session["CaseNo"] = this.txtCaseNo.Text; Response.Redirect("CaseRegistrationInfo.aspx"); } }
public static List <ATTCaseRegistration> GetCaseRegistration(double?caseID, int defaultFlag, int AccFWDRQD, int AppOrRespRQD, int checkListRQD, int LawyerRQD, int EvidenceRQD, int DocumentsRQD, int SummaryRQD, int WitnessRQD, string PersonDocActive) { List <ATTCaseRegistration> CaseRegList = new List <ATTCaseRegistration>(); try { foreach (DataRow row in DLLCaseRegistration.GetCaseRegistration(caseID).Rows) { ATTCaseRegistration objCaseReg = new ATTCaseRegistration(); objCaseReg.CaseID = double.Parse(row["CASE_ID"].ToString()); objCaseReg.CourtID = int.Parse(row["COURT_ID"].ToString()); objCaseReg.CaseTypeID = int.Parse(row["CASE_TYPE_ID"].ToString()); objCaseReg.CaseTypeName = row["CASE_TYPE_NAME"].ToString(); objCaseReg.RegDiaryID = int.Parse(row["REG_DIARY_ID"].ToString()); objCaseReg.RegDiaryName = row["REG_DIARY_NAME"].ToString(); objCaseReg.RegSubjectID = int.Parse(row["REG_SUBJECT_ID"].ToString()); objCaseReg.RegSubjectName = row["SUBJECT_NAME"].ToString(); objCaseReg.RegDiaryNameID = int.Parse(row["REG_DIARY_NAME_ID"].ToString()); objCaseReg.RegDiarySubName = row["REG_DIARY_SUB_NAME"].ToString(); objCaseReg.CaseRegistrationDate = row["CASE_REG_DATE"].ToString(); objCaseReg.ProceedingID = int.Parse(row["PROCEEDING_ID"].ToString()); objCaseReg.ProceedingType = row["PROCEEDING_NAME"].ToString(); objCaseReg.RegTypeID = int.Parse(row["REG_TYPE_ID"].ToString()); objCaseReg.RegTypeName = row["REG_TYPE_NAME"].ToString(); objCaseReg.AccountForwarded = row["ACCOUNT_FORWARDED"].ToString(); if (AccFWDRQD == 1) { objCaseReg.CaseAccountForwardLST = BLLCaseAccountForward.GetCaseAccountForward(objCaseReg.CaseID, null, "N"); } if (AppOrRespRQD == 1) { objCaseReg.AppellantLST = BLLLitigants.GetLitigants(objCaseReg.CaseID, null, "A", 0, 1, PersonDocActive); objCaseReg.RespondantLST = BLLLitigants.GetLitigants(objCaseReg.CaseID, null, "R", 0, 1, PersonDocActive); } if (checkListRQD == 1) { objCaseReg.CaseCheckListLST = BLLCaseCheckList.GetCaseCheckList(objCaseReg.CaseID, objCaseReg.CourtID, objCaseReg.CaseTypeID, objCaseReg.RegTypeID, null, 0); } if (LawyerRQD == 1) { objCaseReg.CaseLawyerLST = BLLCaseLawyer.GetCaseLawyer(objCaseReg.CaseID, null, null); } if (WitnessRQD == 1) { objCaseReg.WitnessPersonLST = BLLWitnessPerson.GetWitness(objCaseReg.CaseID, null, null, null); } if (EvidenceRQD == 1) { objCaseReg.CaseEvidenceLST = BLLCaseEvidence.GetCaseEvidence(objCaseReg.CaseID); } if (DocumentsRQD == 1) { objCaseReg.CaseDocumentLitLST = BLLCaseDocumentLit.GetCaseDocuments(objCaseReg.CaseID, null, null); } if (SummaryRQD == 1) { objCaseReg.CaseSummary = row["CASE_SUMMARY"].ToString(); } CaseRegList.Add(objCaseReg); } //if (defaultFlag > 0) // CaseStatusList.Insert(0, new ATTCaseStatus(0, "छान्नुहोस", "")); return(CaseRegList); } catch (Exception ex) { throw ex; } }
public static bool RegisterCase(ATTCaseRegistration objCaseRegistration) { string SP = ""; if (objCaseRegistration.Action == "A") { SP = "sp_add_case"; } else if (objCaseRegistration.Action == "E") { SP = "sp_edit_case"; } else if (objCaseRegistration.Action == "D") { SP = "sp_del_case"; } List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam("P_CASE_ID", objCaseRegistration.CaseID, OracleDbType.Double, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("P_COURT_ID", objCaseRegistration.CourtID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_CASE_TYPE_ID", objCaseRegistration.CaseTypeID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_REG_TYPE_ID", objCaseRegistration.RegTypeID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_REG_DIARY_ID", objCaseRegistration.RegDiaryID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_REG_SUBJECT_ID", objCaseRegistration.RegSubjectID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_REG_DIARY_NAME_ID", objCaseRegistration.RegDiaryNameID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_CASE_REG_DATE", objCaseRegistration.CaseRegistrationDate, OracleDbType.Varchar2, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("P_REG_NO", objCaseRegistration.RegistrationNumber, OracleDbType.Varchar2, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("P_CASE_NO", objCaseRegistration.CaseNumber, OracleDbType.Varchar2, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("P_WRIT_SUB_ID", objCaseRegistration.WritSubjectID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_WRIT_CAT_ID", objCaseRegistration.WritCatID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_WRIT_CAT_TITLE_ID", objCaseRegistration.WirtCatTitleID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_WRIT_CAT_SUBTITLE_ID", objCaseRegistration.WritCatSubTitleID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_ACCOUNT_FORWARDED", objCaseRegistration.AccountForwarded, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_VERIFIED_BY", objCaseRegistration.VerifiedBy, OracleDbType.Double, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_VERIFIED_YES_NO", objCaseRegistration.VerifiedYesNo, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_VERIFIED_DATE", objCaseRegistration.VerifiedDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_DARPITH_REMARKS", objCaseRegistration.DarpithRemarks, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_PROCEEDING_ID", objCaseRegistration.ProceedingID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_CASE_SUMMARY", objCaseRegistration.CaseSummary, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_RELATED_CASE_ID", objCaseRegistration.RelatedCaseID, OracleDbType.Int16, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_FY", objCaseRegistration.FY, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("CASE_NUMBER", null, OracleDbType.Varchar2, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("REG_NUMBER", null, OracleDbType.Varchar2, ParameterDirection.InputOutput)); paramArray[8].Size = 100; paramArray[9].Size = 100; paramArray[23].Size = 100; paramArray[24].Size = 100; GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, SP, paramArray.ToArray()); objCaseRegistration.CaseID = double.Parse(paramArray[0].Value.ToString()); objCaseRegistration.CaseNumber = paramArray[22].Value.ToString(); objCaseRegistration.RegistrationNumber = paramArray[23].Value.ToString(); if (objCaseRegistration.AppellantLST.Count > 0) { DLLLitigants.AddEditLitigants(objCaseRegistration.AppellantLST, Tran, objCaseRegistration.CaseID); } if (objCaseRegistration.RespondantLST.Count > 0) { DLLLitigants.AddEditLitigants(objCaseRegistration.RespondantLST, Tran, objCaseRegistration.CaseID); } if (objCaseRegistration.CaseCheckListLST.Count > 0) { DLLCaseCheckList.AddEditCaseCheckList(objCaseRegistration.CaseCheckListLST, Tran, objCaseRegistration.CaseID); } if (objCaseRegistration.CaseAccountForwardLST.Count > 0) { DLLCaseAccountForward.SaveCaseAccountForward(objCaseRegistration.CaseAccountForwardLST, Tran, objCaseRegistration.CaseID); } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { GetConn.CloseDbConn(); } }
protected void getCaseRegDetails(double caseID) { ATTCaseRegistration CaseRegOBJ = BLLCaseRegistration.GetCaseRegistration(caseID, 0, 1, 1, 1, 1, 1, 1, 1, 1, null)[0]; //Case Details this.lblCaseType.Text = CaseRegOBJ.CaseTypeName; this.lblRegType.Text = CaseRegOBJ.RegTypeName; this.lblRegDiary.Text = CaseRegOBJ.RegDiaryName; this.lblRegSubject.Text = CaseRegOBJ.RegSubjectName; this.lblRegSubName.Text = CaseRegOBJ.RegDiarySubName; this.lblRegDate.Text = CaseRegOBJ.CaseRegistrationDate; this.lblPreceedingType.Text = CaseRegOBJ.ProceedingType; this.lblForwardToAccount.Text = CaseRegOBJ.AccountForwarded == "Y" ? "पठाउने" : "नपठाउने"; //ACCOUNT FORWARD DETAILS if (CaseRegOBJ.AccountForwarded == "Y") { pnlAccountInfo.Visible = true; } else { pnlAccountInfo.Visible = false; } this.grdAccountFWD.DataSource = CaseRegOBJ.CaseAccountForwardLST; this.grdAccountFWD.DataBind(); //CHECK LIST DETAILS this.grdCheckList.DataSource = CaseRegOBJ.CaseCheckListLST; this.grdCheckList.DataBind(); //APPELLANTS DETAILS this.grdAppellant.DataSource = CaseRegOBJ.AppellantLST; this.grdAppellant.DataBind(); //RESPONDANTS DETAILS this.grdRespondant.DataSource = CaseRegOBJ.RespondantLST; this.grdRespondant.DataBind(); //LAWYERS DETAILS CaseRegOBJ.CaseLawyerLST.RemoveAll( delegate(ATTCaseLaywer obj) { return(CaseRegOBJ.CaseLawyerLST.IndexOf(obj) != CaseRegOBJ.CaseLawyerLST.FindIndex( delegate(ATTCaseLaywer obj1) { return obj.LawyerID == obj1.LawyerID; })); }); this.grdLawyers.DataSource = CaseRegOBJ.CaseLawyerLST; this.grdLawyers.DataBind(); //WITNESS DETAILS CaseRegOBJ.WitnessPersonLST.RemoveAll( delegate(ATTWitnessPerson obj) { return(CaseRegOBJ.WitnessPersonLST.IndexOf(obj) != CaseRegOBJ.WitnessPersonLST.FindIndex( delegate(ATTWitnessPerson obj1) { return obj.WitnessID == obj1.WitnessID; })); }); this.grdWitness.DataSource = CaseRegOBJ.WitnessPersonLST; this.grdWitness.DataBind(); //EVIDENCE DETAILS this.grdEvidence.DataSource = CaseRegOBJ.CaseEvidenceLST; this.grdEvidence.DataBind(); //DOCUMENTS DETAILS this.grdLitDocument.DataSource = CaseRegOBJ.CaseDocumentLitLST; this.grdLitDocument.DataBind(); //CASE SUMMARY this.litCaseSummary.Text = CaseRegOBJ.CaseSummary; }