public GroupGeneralPaymentDto GetGroupGeneralPaymentById(long accountMasterId) { GroupGeneralPaymentDto objGp = null; SqlConnection con = new SqlConnection(DBConstants.MFIS_CS); SqlCommand cmd = new SqlCommand("uspGeneralPaymentsGetById_NEW", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AccountMasterId", accountMasterId); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { objGp = new GroupGeneralPaymentDto(); objGp.AccountMasterID = accountMasterId; objGp.TransactionDate = Convert.ToDateTime(dr["TransactionDate"]); objGp.TransactionMode = Convert.ToString(dr["TransactionMode"]); objGp.VoucherNumber = Convert.ToString(dr["VoucherNumber"]); objGp.VoucherRefNumber = Convert.ToString(dr["VoucherRefNumber"]); objGp.CollectionAgent = Convert.ToInt32(dr["EmployeeID"]); objGp.CollectionAgentName = Convert.ToString(dr["EmployeeName"]); objGp.ChequeNumber = Convert.ToString(dr["ChequeNumber"]); if (!Convert.IsDBNull(dr["ChequeDate"])) { objGp.ChequeDate = Convert.ToDateTime(dr["ChequeDate"]); } objGp.TotalAmount = Convert.ToDecimal(dr["Amount"]); if (!Convert.IsDBNull(dr["BankAccount"])) { objGp.BankEntryId = Convert.ToInt32(dr["BankAccount"]); } objGp.ToAhNameForView = Convert.ToString(dr["ToAhName"]); objGp.Narration = Convert.ToString(dr["Narration"]); } if (dr.NextResult()) { objGp.TransactionsList = new List <GroupGeneralPaymentTranDto>(); GroupGeneralPaymentTranDto objTran = null; while (dr.Read()) { objTran = new GroupGeneralPaymentTranDto(); objTran.GLAccountId = Convert.ToInt32(dr["GLAhId"]); objTran.SLAccountId = Convert.ToInt32(dr["SLAhId"]); objTran.GLAccount = Convert.ToString(dr["GLAHNAME"]); objTran.SLAccount = Convert.ToString(dr["SLAHNAME"]); objTran.Amount = Convert.ToDecimal(dr["Amount"]); objGp.TransactionsList.Add(objTran); } } return(objGp); }
public ActionResult AddGeneralPayment(FormCollection form) { GroupGeneralPaymentDto _groupGeneralPaymentDto = new GroupGeneralPaymentDto(); try { _groupGeneralPaymentDto.AccountMasterID = Convert.ToInt32(Request.Form["AccountMasterID"]); _groupGeneralPaymentDto.TransactionMode = Convert.ToString(Request.Form["TransactionMode"]); string tranDate = _groupGeneralPaymentDto.TransactionMode == "C" ? Request.Form["TransactionDate"] : Request.Form["txtTransactionDate"]; DateTime dtTranDate = tranDate.ConvertToDateTime(); _groupGeneralPaymentDto.TransactionDate = dtTranDate; _groupGeneralPaymentDto.VoucherRefNumber = Convert.ToString(Request.Form["VoucherRefNumber"]); _groupGeneralPaymentDto.CollectionAgent = Convert.ToInt32(Request.Form["CollectionAgent"]); if (_groupGeneralPaymentDto.TransactionMode == "BC") { _groupGeneralPaymentDto.ChequeNumber = Convert.ToString(Request.Form["ChequeNumber"]); _groupGeneralPaymentDto.ChequeDate = Request.Form["ChequeDate"].ConvertToDateTime(); } _groupGeneralPaymentDto.TotalAmount = Convert.ToDecimal(Request.Form["hdnTotalAmount"]); if (_groupGeneralPaymentDto.TransactionMode != "C") { _groupGeneralPaymentDto.BankEntryId = Convert.ToInt32(Request.Form["BankEntryId"]); } _groupGeneralPaymentDto.Narration = Convert.ToString(Request.Form["Narration"]); ViewBag.LockStatus = GroupInfo.LockStatus; //Transactions Read _groupGeneralPaymentDto.TransactionsList = new List <GroupGeneralPaymentTranDto>(); int maxCount = Convert.ToInt32(Request.Form["hdnMaxTranCount"]); GroupGeneralPaymentTranDto objTran = null; for (int index = 0; index <= maxCount; index++) { if (Request.Form["hdnSLId_" + index] == null) { continue; } objTran = new GroupGeneralPaymentTranDto(); objTran.GLAccount = Convert.ToString(Request.Form["hdnGLAccount_" + index]); objTran.SLAccount = Convert.ToString(Request.Form["hdnSLAccount_" + index]); objTran.SLAccountId = Convert.ToInt32(Request.Form["hdnSLId_" + index]); objTran.Amount = Convert.ToDecimal(Request.Form["hdnAmount_" + index]); _groupGeneralPaymentDto.TransactionsList.Add(objTran); } //Save ResultDto resultDto = new ResultDto(); int GroupId = GroupInfo.GroupID; resultDto = _groupGeneralPayemntService.AddUpdateGeneralPayment(_groupGeneralPaymentDto, UserInfo.UserID, GroupId); _groupGeneralPaymentDto.VoucherNumber = resultDto.ObjectCode; _groupGeneralPaymentDto.AccountMasterID = resultDto.ObjectId; LoadOtherReceiptDropDowns(); } catch (Exception ex) { throw ex; } return(View(_groupGeneralPaymentDto)); }