public ActionResult SaveLoanPreClose(string LoanMasterId) { MemberLoanClosure memberLoanClosure = new MemberLoanClosure(); int ID = string.IsNullOrEmpty(LoanMasterId.DecryptString()) ? default(int) : Convert.ToInt32(LoanMasterId.DecryptString()); var memberLoanDisbursement = _memberloanapplicationService.GetMemberLoanDisbursementDetailsById(ID, UserInfo.UserID); LoadDropDowns(); memberLoanClosure = _memberloanapplicationService.GetLoanClosureDemands(ID, GroupInfo.MeetingDate); List <GroupMemberDemandDto> lstDemands = new List <GroupMemberDemandDto>(); lstDemands = _groupMemberReceiptService.GetTransactionDemands(Convert.ToString(GroupInfo.MeetingDate), memberLoanDisbursement.MemberID); var lstloanDemands = lstDemands.Where(x => x.LoanMasterId == ID).ToList(); GroupMemberReceiptDto _grpMbrRecptDto = new GroupMemberReceiptDto(); try { ViewBag.LockStatus = GroupInfo.LockStatus; _grpMbrRecptDto.AccountMasterID = memberLoanDisbursement.AccountMasterId; _grpMbrRecptDto.TransactionMode = "C"; _grpMbrRecptDto.TransactionDate = GroupInfo.MeetingDate; _grpMbrRecptDto.VoucherRefNumber = memberLoanDisbursement.PaymentVoucherNumber; _grpMbrRecptDto.CollectionAgent = 0; _grpMbrRecptDto.TotalAmount = memberLoanClosure.InterestDemand + memberLoanClosure.PrincipleDemand; _grpMbrRecptDto.MemberId = memberLoanDisbursement.MemberID; _grpMbrRecptDto.Narration = "Loan Pre Closing"; //Transactions Read _grpMbrRecptDto.Transactions = new List <GroupMemberReceiptTranDto>(); foreach (var memberdemand in lstloanDemands) { GroupMemberReceiptTranDto objTran = null; objTran = new GroupMemberReceiptTranDto(); objTran.SLAccountId = memberdemand.SLAhId; objTran.GLAccount = memberdemand.GLAhName; objTran.SLAccount = memberdemand.SLAhName; objTran.ReferenceNumber = "RefCloser"; objTran.SubAhId = memberdemand.SubAhId; objTran.Amount = memberLoanClosure.PrincipleDemand; objTran.InterestDue = 0; _grpMbrRecptDto.Transactions.Add(objTran); } //Save int GroupId = GroupInfo.GroupID; ResultDto resultDto = _groupMemberReceiptService.AddUpdateMemberReceipt(_grpMbrRecptDto, UserInfo.UserID, GroupId); _grpMbrRecptDto.VoucherNumber = resultDto.ObjectCode; _grpMbrRecptDto.AccountMasterID = resultDto.ObjectId; } catch (Exception ex) { throw ex; } return(View()); }
public GroupMemberReceiptDto EditGroupMemberReceipt(int AccountMasterId) { SqlConnection con = new SqlConnection(DBConstants.MFIS_CS); SqlCommand cmd = new SqlCommand(ProcNames.uspGetGroupMemberReceiptByAccountMasterId, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AccountMasterId", AccountMasterId); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); GroupMemberReceiptDto recptDto = null; if (dr.Read()) { recptDto = new GroupMemberReceiptDto(); recptDto.AccountMasterID = AccountMasterId; recptDto.TransactionDate = Convert.ToDateTime(dr["TransactionDate"]); recptDto.TransactionMode = Convert.ToString(dr["TransactionMode"]); recptDto.VoucherNumber = Convert.ToString(dr["VoucherNumber"]); recptDto.VoucherRefNumber = Convert.ToString(dr["VoucherRefNumber"]); recptDto.TotalAmount = Convert.ToDecimal(dr["Amount"]); recptDto.CollectionAgent = Convert.ToInt32(dr["EmployeeID"]); recptDto.MemberId = Convert.ToInt32(dr["MemberId"]); if (!Convert.IsDBNull(dr["ChequeDate"])) { recptDto.ChequeDate = Convert.ToDateTime(dr["ChequeDate"]); } recptDto.ChequeNumber = Convert.ToString(dr["ChequeNumber"]); if (!Convert.IsDBNull(dr["BankAccount"])) { recptDto.BankEntryId = Convert.ToInt32(dr["BankAccount"]); } recptDto.Narration = Convert.ToString(dr["Narration"]); } if (dr.NextResult()) { recptDto.Transactions = new List <GroupMemberReceiptTranDto>(); GroupMemberReceiptTranDto objTran = null; while (dr.Read()) { objTran = new GroupMemberReceiptTranDto(); objTran.SLAccountId = Convert.ToInt32(dr["SLAHId"]); if (dr["SubAhId"] != DBNull.Value) { objTran.SubAhId = Convert.ToInt32(dr["SubAhId"]); } objTran.ReferenceNumber = Convert.ToString(dr["ReferenceNumber"]); objTran.Amount = Convert.ToDecimal(dr["CrAmount"]); objTran.GLAccount = Convert.ToString(dr["GLAHName"]); objTran.SLAccount = Convert.ToString(dr["SLAHName"]); recptDto.Transactions.Add(objTran); } } return(recptDto); }
public List <GroupMemberReceiptTranDto> GetMemberReceiptTemplate() { List <GroupMemberReceiptTranDto> lstAccountHeadsTemplats = new List <GroupMemberReceiptTranDto>(); SqlConnection con = new SqlConnection(DBConstants.MFIS_CS); SqlCommand cmd = new SqlCommand(ProcNames.uspGroupMemberAccountHeadTemplats, con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); GroupMemberReceiptTranDto tempdto = null; while (dr.Read()) { tempdto = new GroupMemberReceiptTranDto(); tempdto.SLAccountId = Convert.ToInt32(dr["AHID"]); tempdto.GLAccount = Convert.ToString(dr["GLAccountHead"]); tempdto.SLAccount = Convert.ToString(dr["SLAccountHead"]); lstAccountHeadsTemplats.Add(tempdto); } return(lstAccountHeadsTemplats); }
public ActionResult CreateGroupMemberReceipt(FormCollection form) { GroupMemberReceiptDto _grpMbrRecptDto = new GroupMemberReceiptDto(); try { ViewBag.LockStatus = GroupInfo.LockStatus; _grpMbrRecptDto.AccountMasterID = Convert.ToInt32(Request.Form["AccountMasterID"]); _grpMbrRecptDto.TransactionMode = Convert.ToString(Request.Form["TransactionMode"]); string tranDate = _grpMbrRecptDto.TransactionMode == "C" ? Request.Form["TransactionDate"] : Request.Form["txtTransactionDate"]; DateTime dtTranDate = tranDate.ConvertToDateTime(); _grpMbrRecptDto.TransactionDate = dtTranDate; _grpMbrRecptDto.VoucherRefNumber = Convert.ToString(Request.Form["VoucherRefNumber"]); _grpMbrRecptDto.CollectionAgent = Convert.ToInt32(Request.Form["CollectionAgent"]); if (_grpMbrRecptDto.TransactionMode == "BC") { _grpMbrRecptDto.ChequeNumber = Convert.ToString(Request.Form["ChequeNumber"]); _grpMbrRecptDto.ChequeDate = Request.Form["ChequeDate"].ConvertToDateTime(); } _grpMbrRecptDto.TotalAmount = Convert.ToDecimal(Request.Form["hdnTotalAmount"]); if (_grpMbrRecptDto.TransactionMode != "C") { _grpMbrRecptDto.BankEntryId = Convert.ToInt32(Request.Form["BankEntryId"]); } _grpMbrRecptDto.MemberId = Convert.ToInt32(Request.Form["MemberId"]); _grpMbrRecptDto.Narration = Convert.ToString(Request.Form["Narration"]); //Transactions Read _grpMbrRecptDto.Transactions = new List <GroupMemberReceiptTranDto>(); int maxCount = Convert.ToInt32(Request.Form["hdnMaxTranCount"]); GroupMemberReceiptTranDto objTran = null; for (int index = 1; index < maxCount; index++) { objTran = new GroupMemberReceiptTranDto(); objTran.SLAccountId = Convert.ToInt32(Request.Form["hdnSlAccountID_" + index]); objTran.GLAccount = Convert.ToString(Request.Form["hdnGlAccount_" + index]); objTran.SLAccount = Convert.ToString(Request.Form["hdnSlAccount_" + index]); objTran.ReferenceNumber = Convert.ToString(Request.Form["hdnRefNumber_" + index]); decimal expectedDemand = default(decimal); decimal.TryParse(Request.Form["hdnexpectedamount_" + index], out expectedDemand); int subAhId = default(int); int.TryParse(Request.Form["hdnSubAHID_" + index], out subAhId); objTran.SubAhId = subAhId; objTran.Amount = Convert.ToDecimal(Request.Form["CrAmount_" + index]); if (objTran.SLAccount.ToUpper().Contains("SERVICE COST") && objTran.Amount < expectedDemand) { objTran.InterestDue = expectedDemand - objTran.Amount; } if (objTran.SLAccount.ToUpper().Contains("LOAN") && objTran.Amount < expectedDemand && !(objTran.SLAccount.ToUpper().Contains("SERVICE COST"))) { objTran.PrincipleDue = expectedDemand - objTran.Amount; } _grpMbrRecptDto.Transactions.Add(objTran); } //Save int GroupId = GroupInfo.GroupID; ResultDto resultDto = _groupMemberReceiptService.AddUpdateMemberReceipt(_grpMbrRecptDto, UserInfo.UserID, GroupId); _grpMbrRecptDto.VoucherNumber = resultDto.ObjectCode; _grpMbrRecptDto.AccountMasterID = resultDto.ObjectId; LoadMemberReceiptDropDowns(); } catch (Exception ex) { throw ex; } return(View(_grpMbrRecptDto)); }