public static CustomerLoanReceipt DataRowToObject(DataRow dr)
{
CustomerLoanReceipt TheCustomerLoanReceipt = new CustomerLoanReceipt
{
CustomerLoanReceiptID = int.Parse(dr["CustomerLoanReceiptID"].ToString()),
ReceiptSeries = dr["ReceiptSeries"].ToString(),
CustomerLoanReceiptNumber = dr["CustomerLoanReceiptNumber"].ToString(),
CustomerLoanID = int.Parse(dr["CustomerLoanID"].ToString()),
CustomerLoanCode = dr["CustomerLoanCode"].ToString(),
LoanApplicationNumber = dr["LoanApplicationNumber"].ToString(),
LoanApplicationDate = DateTime.Parse(dr["LoanApplicationDate"].ToString()).ToString(MicroConstants.DateFormat),
LoanAmount = decimal.Parse(dr["LoanAmount"].ToString()),
RateOfInterest = decimal.Parse(dr["RateOfInterest"].ToString()),
CustomerID = int.Parse(dr["CustomerID"].ToString()),
CustomerCode = dr["CustomerCode"].ToString(),
CustomerName = dr["CustomerName"].ToString(),
CustomerAccountID = int.Parse(dr["CustomerAccountID"].ToString()),
CustomerAccountCode = dr["CustomerAccountCode"].ToString(),
DateOfRecovery = DateTime.Parse(dr["DateOfRecovery"].ToString()).ToString(MicroConstants.DateFormat),
AmountPaid = decimal.Parse(dr["AmountPaid"].ToString()),
AmountPaidAsPrincipal = decimal.Parse(dr["AmountPaidAsPrincipal"].ToString()),
AmountPaidAsInterest = decimal.Parse(dr["AmountPaidAsInterest"].ToString()),
InstallmentNumber = int.Parse(dr["InstallmentNumber"].ToString()),
Remark = dr["Remark"].ToString(),
IsCancelled = bool.Parse(dr["IsCancelled"].ToString()),
OfficeID = int.Parse(dr["OfficeID"].ToString()),
OfficeName = dr["OfficeName"].ToString()
};
return(TheCustomerLoanReceipt);
}
public static CustomerLoanReceipt GetCustomerLoanReceiptByID(int loanReceiptID)
{
DataRow CustomerLoanReceiptRow = CustomerLoanReceiptDataAccess.GetInstance.GetCustomerLoanReceiptByID(loanReceiptID);
CustomerLoanReceipt TheCustomerLoanReceipt = DataRowToObject(CustomerLoanReceiptRow);
return(TheCustomerLoanReceipt);
}
public static List <CustomerLoanReceipt> GetCustomerLoanReceiptListByCustomerLoanID(int customerLoanID)
{
List <CustomerLoanReceipt> CustomerLoanReceiptList = new List <CustomerLoanReceipt>();
DataTable CustomerLoanReceiptTable = CustomerLoanReceiptDataAccess.GetInstance.GetCustomerLoanReceiptListByCustomerLoanID(customerLoanID);
foreach (DataRow dr in CustomerLoanReceiptTable.Rows)
{
CustomerLoanReceipt TheCustomerLoanReceipt = DataRowToObject(dr);
CustomerLoanReceiptList.Add(TheCustomerLoanReceipt);
}
return(CustomerLoanReceiptList);
}
public int InsertCustomerLoanReceipt(CustomerLoanReceipt theCustomerLoanReceipt)
{
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("@ReceiptSeries", SqlDbType.VarChar, theCustomerLoanReceipt.ReceiptSeries));
InsertCommand.Parameters.Add(GetParameter("@CustomerLoanID", SqlDbType.Int, theCustomerLoanReceipt.CustomerLoanID));
InsertCommand.Parameters.Add(GetParameter("@DateOfRecovery", SqlDbType.VarChar, theCustomerLoanReceipt.DateOfRecovery));
InsertCommand.Parameters.Add(GetParameter("@AmountPaid", SqlDbType.Decimal, theCustomerLoanReceipt.AmountPaid));
InsertCommand.Parameters.Add(GetParameter("@AmountPaidAsPrincipal", SqlDbType.Decimal, theCustomerLoanReceipt.AmountPaidAsPrincipal));
InsertCommand.Parameters.Add(GetParameter("@AmountPaidAsInterest", SqlDbType.Decimal, theCustomerLoanReceipt.AmountPaidAsInterest));
InsertCommand.Parameters.Add(GetParameter("@InstallmentNumber", SqlDbType.Int, theCustomerLoanReceipt.InstallmentNumber));
InsertCommand.Parameters.Add(GetParameter("@Remark", SqlDbType.VarChar, theCustomerLoanReceipt.Remark));
InsertCommand.Parameters.Add(GetParameter("@OfficeId", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.OfficeID));
InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pCRM_CustomerLoanReceipts_Insert";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public int InsertCustomerLoanReceipt(CustomerLoanReceipt theCustomerLoanReceipt)
{
return(CustomerLoanReceiptIntegration.InsertCustomerLoanReceipt(theCustomerLoanReceipt));
}
public static int InsertCustomerLoanReceipt(CustomerLoanReceipt theCustomerLoanReceipt)
{
return(CustomerLoanReceiptDataAccess.GetInstance.InsertCustomerLoanReceipt(theCustomerLoanReceipt));
}