public int InsertPreMaturityApproval(PreMaturityApproval thePreMaturityApprovals) { int ReturnValue = 0; using (SqlCommand InsertCommand = new SqlCommand()) { InsertCommand.CommandType = CommandType.StoredProcedure; InsertCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; InsertCommand.Parameters.Add(GetParameter("@PreMaturityApplicationID", SqlDbType.Int, thePreMaturityApprovals.PreMaturityApplicationID)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityApprovalDate", SqlDbType.VarChar, thePreMaturityApprovals.PreMaturityApprovalDate)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityPrincipalPayable", SqlDbType.Decimal, thePreMaturityApprovals.PreMaturityPrincipalPayable)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityPrincipalApproved", SqlDbType.Decimal, thePreMaturityApprovals.PreMaturityPrincipalApproved)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityInterestPayable", SqlDbType.Decimal, thePreMaturityApprovals.PreMaturityInterestPayable)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityInterestApproved", SqlDbType.Decimal, thePreMaturityApprovals.PreMaturityInterestApproved)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityBonusPayable", SqlDbType.Decimal, thePreMaturityApprovals.PreMaturityBonusPayable)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityBonusApproved", SqlDbType.Decimal, thePreMaturityApprovals.PreMaturityBonusApproved)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityTotalPayable", SqlDbType.Decimal, thePreMaturityApprovals.PreMaturityTotalPayable)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityTotalPaid", SqlDbType.Decimal, thePreMaturityApprovals.PreMaturityTotalPaid)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityApprovalRemark", SqlDbType.VarChar, thePreMaturityApprovals.PreMaturityApprovalRemark)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityApprovedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityApprovalLetterDate", SqlDbType.VarChar, thePreMaturityApprovals.PreMaturityApprovalLetterDate)); InsertCommand.Parameters.Add(GetParameter("@PreMaturityApprovalLetterReference", SqlDbType.VarChar, thePreMaturityApprovals.PreMaturityApprovalLetterReference)); InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); InsertCommand.CommandText = "pCRM_PreMaturityApprovals_Insert"; ExecuteStoredProcedure(InsertCommand); ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString()); return(ReturnValue); } }
public static PreMaturityApproval DataRowToObject(DataRow dr) { PreMaturityApproval ThePreMaturityApprovals = new PreMaturityApproval(); ThePreMaturityApprovals.PreMaturityApprovalID = int.Parse(dr["PreMaturityApprovalID"].ToString()); ThePreMaturityApprovals.PreMaturityApplicationID = int.Parse(dr["PreMaturityApplicationID"].ToString()); ThePreMaturityApprovals.CustomerAccountID = int.Parse(dr["CustomerAccountID"].ToString()); ThePreMaturityApprovals.CustomerAccountCode = dr["CustomerAccountCode"].ToString(); ThePreMaturityApprovals.CustomerName = dr["CustomerName"].ToString(); ThePreMaturityApprovals.PreMaturityApprovalDate = DateTime.Parse(dr["PreMaturityApprovalDate"].ToString()).ToString(MicroConstants.DateFormat); ThePreMaturityApprovals.PreMaturityPrincipalPayable = decimal.Parse(dr["PreMaturityPrincipalPayable"].ToString()); ThePreMaturityApprovals.PreMaturityPrincipalApproved = decimal.Parse(dr["PreMaturityPrincipalApproved"].ToString()); ThePreMaturityApprovals.PreMaturityInterestPayable = decimal.Parse(dr["PreMaturityInterestPayable"].ToString()); ThePreMaturityApprovals.PreMaturityInterestApproved = decimal.Parse(dr["PreMaturityInterestApproved"].ToString()); ThePreMaturityApprovals.PreMaturityBonusPayable = decimal.Parse(dr["PreMaturityBonusPayable"].ToString()); ThePreMaturityApprovals.PreMaturityBonusApproved = decimal.Parse(dr["PreMaturityBonusApproved"].ToString()); ThePreMaturityApprovals.PreMaturityTotalPayable = decimal.Parse(dr["PreMaturityTotalPayable"].ToString()); ThePreMaturityApprovals.PreMaturityTotalPaid = decimal.Parse(dr["PreMaturityTotalPaid"].ToString()); ThePreMaturityApprovals.PreMaturityApprovalRemark = dr["PreMaturityApprovalRemark"].ToString(); ThePreMaturityApprovals.PreMaturityApprovedBy = int.Parse(dr["PreMaturityApprovedBy"].ToString()); ThePreMaturityApprovals.PreMaturityApprovalLetterDate = DateTime.Parse(dr["PreMaturityApprovalLetterDate"].ToString()).ToString(MicroConstants.DateFormat); ThePreMaturityApprovals.PreMaturityApprovalLetterReference = dr["PreMaturityApprovalLetterReference"].ToString(); return(ThePreMaturityApprovals); }
public static PreMaturityApproval GetPrematurityApprovalDetailsById(int PreMaturityApprovalID) { DataRow PreMaturityApprovalsRow = PreMaturityApprovalDataAccess.GetInstance.GetPrematurityApprovalDetailsById(PreMaturityApprovalID); PreMaturityApproval ThePreMaturityApprovals = DataRowToObject(PreMaturityApprovalsRow); return(ThePreMaturityApprovals); }
public static List <PreMaturityApproval> GetPrematurityApprovalUnpaidList(bool allOffices = false) { List <PreMaturityApproval> ApprovalUnpaidList = new List <PreMaturityApproval>(); DataTable GetApprovalUnpaidTable = PreMaturityApprovalDataAccess.GetInstance.GetPrematurityApprovalUnpaidList(allOffices); foreach (DataRow dr in GetApprovalUnpaidTable.Rows) { PreMaturityApproval TheApprovalUnpaid = DataRowToObject(dr); ApprovalUnpaidList.Add(TheApprovalUnpaid); } return(ApprovalUnpaidList); }
public static int InsertPreMaturityApproval(PreMaturityApproval thePreMaturityApprovals) { return(PreMaturityApprovalDataAccess.GetInstance.InsertPreMaturityApproval(thePreMaturityApprovals)); }
public int InsertPreMaturityApproval(PreMaturityApproval thePreMaturityApprovals) { return(PreMaturityApprovalIntegration.InsertPreMaturityApproval(thePreMaturityApprovals)); }