public static bool SaveCaseAccountMaster(ATTCaseAccountMaster attCAM) { GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction(); string InsertUpdateSQL = "SP_ADD_CASE_ACCOUNT_MASTER"; 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_TRAN_DATE", attCAM.TransactionDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_TRAN_SEQ", attCAM.TransactionSequence, OracleDbType.Int64, ParameterDirection.InputOutput)); if (attCAM.LitigantID == 0) { paramArray.Add(Utilities.GetOraParam(":P_LITIGANT_ID", null, OracleDbType.Double, ParameterDirection.Input)); } else { paramArray.Add(Utilities.GetOraParam(":P_LITIGANT_ID", attCAM.LitigantID, OracleDbType.Double, ParameterDirection.Input)); } if (attCAM.AttorneyID == 0) { paramArray.Add(Utilities.GetOraParam(":P_ATTORNEY_ID", null, OracleDbType.Double, ParameterDirection.Input)); } else { paramArray.Add(Utilities.GetOraParam(":P_ATTORNEY_ID", attCAM.AttorneyID, OracleDbType.Double, 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)); paramArray.Add(Utilities.GetOraParam(":P_OLD_TRAN_DATE", null, OracleDbType.Varchar2, ParameterDirection.Input)); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray()); DLLCaseAccountDetails.SaveCaseAccountDetail(attCAM.LstAccountDetails, Tran); DLLCaseAccountForward.SaveCaseAccountForward(attCAM.LstAccountForward, Tran, attCAM.CaseID); Tran.Commit(); return(true); } 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(); } }