public static List <ATTCaseAccountForward> GetUnPaidAmount(int courtID, string paid) { List <ATTCaseAccountForward> CAFList = new List <ATTCaseAccountForward>(); try { foreach (DataRow row in DLLCaseAccountForward.GetUnPaidAmount(courtID, paid).Rows) { ATTCaseAccountForward att = new ATTCaseAccountForward ( int.Parse(row["CASE_ID"].ToString()), int.Parse(row["ACCOUNT_TYPE_ID"].ToString()), int.Parse(row["TOT_AMOUNT"].ToString()), row["PAID"].ToString() ); att.AccountTypeName = row["ACCOUNT_TYPE_NAME"].ToString(); att.Appellants = row["APPELLANTLIST"].ToString(); att.Respondents = row["RESPONDENTLIST"].ToString(); att.CaseName = row["CASETYPENAME"].ToString(); CAFList.Add(att); } return(CAFList); } catch (Exception ex) { throw ex; } }
public static List <ATTCaseAccountForward> GetCaseAccountForward(double caseID, int?accountTypeID, string paid) { List <ATTCaseAccountForward> CAFList = new List <ATTCaseAccountForward>(); try { foreach (DataRow row in DLLCaseAccountForward.GetCaseAccountForward(caseID, accountTypeID, paid).Rows) { ATTCaseAccountForward att = new ATTCaseAccountForward ( int.Parse(row["CASE_ID"].ToString()), int.Parse(row["ACCOUNT_TYPE_ID"].ToString()), int.Parse(row["TOT_AMOUNT"].ToString()), row["PAID"].ToString() ); att.AccountTypeName = row["ACCOUNT_TYPE_NAME"].ToString(); CAFList.Add(att); } return(CAFList); } catch (Exception ex) { throw ex; } }
public static bool SaveCaseAccountForward(ATTCaseAccountForward attCAF) { GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction(); string InsertUpdateSQL = "SP_ADD_CASE_ACCOUNT_FWD"; try { List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":P_CASE_ID", attCAF.CaseID, OracleDbType.Double, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ACCOUNT_TYPE_ID", attCAF.AccountTypeID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_TOTAL_AMOUNT", attCAF.TotalAmount, OracleDbType.Double, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_PAID", attCAF.Paid, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", attCAF.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray()); Tran.Commit(); return(true); } catch (Exception ex) { throw ex; } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (txtTranDate_RQD.Text == "") { lblStatus.Text = "Saving Error"; lblStatusMessage.Text = "Enter Trasaction Date first"; programmaticModalPopup.Show(); return; } double caseID = 0; //int tranSeq = 0; ATTCaseAccountMaster attCM = new ATTCaseAccountMaster(); foreach (GridViewRow gRow in grdCaseAccount.Rows) { CheckBox cbSelect = (CheckBox)gRow.Cells[0].FindControl("chkPaid"); if (cbSelect.Checked == true) { caseID = double.Parse(gRow.Cells[1].Text); //tranSeq = int.Parse(gRow.Cells[2].Text); ATTCaseAccountDetails attCD = new ATTCaseAccountDetails(double.Parse(gRow.Cells[1].Text), txtTranDate_RQD.Text, 0, int.Parse(gRow.Cells[2].Text), double.Parse(gRow.Cells[4].Text)); attCD.EntryBy = strUser; attCM.LstAccountDetails.Add(attCD); ATTCaseAccountForward attCAF = new ATTCaseAccountForward(double.Parse(gRow.Cells[1].Text), int.Parse(gRow.Cells[2].Text), double.Parse(gRow.Cells[4].Text), "Y"); attCAF.EntryBy = strUser; attCM.LstAccountForward.Add(attCAF); } } if (grdLitigants.SelectedIndex > -1) { GridViewRow row = grdLitigants.SelectedRow; attCM.CaseID = double.Parse(row.Cells[0].Text); attCM.TransactionDate = txtTranDate_RQD.Text.Trim(); attCM.TransactionSequence = 0; attCM.LitigantID = double.Parse(row.Cells[1].Text); attCM.AttorneyID = double.Parse(row.Cells[2].Text); attCM.Remarks = txtRemarks.Text.Trim(); attCM.EntryBy = strUser; } else { attCM.CaseID = caseID; attCM.TransactionDate = txtTranDate_RQD.Text.Trim(); attCM.TransactionSequence = 0; attCM.LitigantID = null; attCM.AttorneyID = null; attCM.Remarks = txtRemarks.Text.Trim(); attCM.EntryBy = strUser; } if (BLLCaseAccountMaster.SaveCaseAccountMaster(attCM)) { LoadUnPiadAmount(); ClearControls(); } }
public static bool SaveCaseAccountForward(ATTCaseAccountForward attCAF) { try { return(DLLCaseAccountForward.SaveCaseAccountForward(attCAF)); } catch (Exception ex) { throw ex; } }