private static EmpLoan GetItemFromReader(IDataReader dataReader) { EmpLoan objItem = new EmpLoan(); objItem.LoanCode = SqlHelper.GetString(dataReader, "LoanCode"); objItem.EmpCode = SqlHelper.GetString(dataReader, "EmpCode"); objItem.Amount = SqlHelper.GetDecimal(dataReader, "Amount"); objItem.BRate = SqlHelper.GetDecimal(dataReader, "BRate"); objItem.BMonth = SqlHelper.GetInt(dataReader, "BMonth"); objItem.BYear = SqlHelper.GetDecimal(dataReader, "BYear"); objItem.Balance = SqlHelper.GetDecimal(dataReader, "Balance"); objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser"); objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate"); objItem.BankName = SqlHelper.GetString(dataReader, "BankName"); objItem.LoanDesc = SqlHelper.GetString(dataReader, "LoanDesc"); objItem.CuryId = SqlHelper.GetString(dataReader, "CuryId"); return(objItem); }
public static EmpLoan UpdateItem(EmpLoan model) { String result = String.Empty; using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "tblEmpLoan_Update", CreateSqlParameter(model))) { while (reader.Read()) { result = (String)reader[0]; } } return(GetItemByID(result)); }
public static EmpLoanCollection GetAllItem() { EmpLoanCollection collection = new EmpLoanCollection(); using (var reader = SqlHelper.ExecuteReader("tblEmpLoan_GetAll", null)) { while (reader.Read()) { EmpLoan obj = new EmpLoan(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static EmpLoanCollection GetAllItembyCreatedUser(string CreatedUser) { EmpLoanCollection collection = new EmpLoanCollection(); using (var reader = SqlHelper.ExecuteReader("tblEmpLoan_GetAllByUser", new SqlParameter("@CreatedUser", CreatedUser))) { while (reader.Read()) { EmpLoan obj = new EmpLoan(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static EmpLoan GetItemByID(String loanCode) { EmpLoan item = new EmpLoan(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@LoanCode", loanCode); using (var reader = SqlHelper.ExecuteReader("tblEmpLoan_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
private static SqlParameter[] CreateSqlParameter(EmpLoan model) { return(new SqlParameter[] { new SqlParameter("@LoanCode", model.LoanCode), new SqlParameter("@EmpCode", model.EmpCode), new SqlParameter("@Amount", model.Amount), new SqlParameter("@BRate", model.BRate), new SqlParameter("@BMonth", model.BMonth), new SqlParameter("@BYear", model.BYear), new SqlParameter("@Balance", model.Balance), new SqlParameter("@CreatedUser", model.CreatedUser), new SqlParameter("@CreatedDate", model.CreatedDate), new SqlParameter("@BankName", model.BankName), new SqlParameter("@LoanDesc", model.LoanDesc), new SqlParameter("@CuryId", model.CuryId), }); }
public static LoanCalCollection CalEmpLoan(EmpLoan objItem) { LoanCalCollection objCollection = new LoanCalCollection(); LoanCal objHCal; if (objItem != null) { if (objItem.BRate != 0 && objItem.Amount != 0) { decimal payment = 0; decimal Principal = objItem.Amount / objItem.BMonth; decimal Balance = objItem.Amount; decimal Interest = 0; decimal TotalInter = 0; for (int i = 0; i < objItem.BMonth; i++) { objHCal = new LoanCal(); objHCal.Date = (i + 1).ToString(); objHCal.month = i + 1; objHCal.Principal = Principal; //_row = objDtb.NewRow(); //_row["Date"] = i + 1; //_row["Month"] = i + 1; //_row["Principal"] = Principal; Interest = Balance * objItem.BRate / 100 / 12; Balance = Balance - Principal; TotalInter = TotalInter + Interest; objHCal.Balance = Balance; objHCal.Payment = Interest + Principal; objHCal.Interest = Interest; objHCal.TotalInterest = TotalInter; //_row["Balance"] = Balance; //_row["Payment"] = Interest + Principal; //_row["Interest"] = Interest; //_row["TotalInterest"] = TotalInter; //objDtb.Rows.Add(_row); objCollection.Add(objHCal); } } ///add row to system } // DataColumn objCol return(objCollection); }