public ResultDto AddUpdateGeneralPayment(GroupGeneralPaymentDto _groupGeneralPaymentDto, int userId, int groupId) { GroupGeneralPaymentDal objDal = new GroupGeneralPaymentDal(); string generalPaymentTranxml = CommonMethods.SerializeListDto <List <GroupGeneralPaymentTranDto> >(_groupGeneralPaymentDto.TransactionsList); return(objDal.AddUpdateGeneralPayment(_groupGeneralPaymentDto, generalPaymentTranxml, userId, groupId)); }
public ResultDto AddUpdateGeneralPayment(GroupGeneralPaymentDto objDto, string generalPaymentTranxml, int userId, int groupId) { ResultDto res = new ResultDto(); try { SqlConnection con = new SqlConnection(DBConstants.MFIS_CS); SqlCommand cmd = new SqlCommand("uspGroupGeneralPaymentInsertUpdate", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TransactionMode", objDto.TransactionMode); cmd.Parameters.AddWithValue("@TransactionDate", objDto.TransactionDate); if (!string.IsNullOrWhiteSpace(objDto.VoucherRefNumber)) { cmd.Parameters.AddWithValue("@VoucherRefNumber", objDto.VoucherRefNumber); } cmd.Parameters.AddWithValue("@CollectionAgent", objDto.CollectionAgent); if (objDto.TransactionMode == "BC") { cmd.Parameters.AddWithValue("@ChequeNumber", objDto.ChequeNumber); cmd.Parameters.AddWithValue("@ChequeDate", objDto.ChequeDate); } cmd.Parameters.AddWithValue("@Amount", objDto.TotalAmount); if (objDto.TransactionMode != "C") { cmd.Parameters.AddWithValue("@BankEntryId", objDto.BankEntryId); } cmd.Parameters.AddWithValue("@Narration", objDto.Narration); cmd.Parameters.AddWithValue("@UserId", userId); cmd.Parameters.AddWithValue("@GroupId", groupId); cmd.Parameters.AddWithValue("@TransactionXML", generalPaymentTranxml); SqlParameter prmAccountMasterId = new SqlParameter("@AccountMasterId", SqlDbType.Int); prmAccountMasterId.Value = objDto.AccountMasterID; prmAccountMasterId.Direction = ParameterDirection.InputOutput; cmd.Parameters.Add(prmAccountMasterId); SqlParameter prmVcoherNumber = new SqlParameter("@VoucherNumber", SqlDbType.VarChar, 32); prmVcoherNumber.Value = objDto.VoucherNumber; prmVcoherNumber.Direction = ParameterDirection.InputOutput; cmd.Parameters.Add(prmVcoherNumber); con.Open(); cmd.ExecuteNonQuery(); res.ObjectId = Convert.ToInt32(prmAccountMasterId.Value); res.ObjectCode = prmVcoherNumber.Value.ToString(); con.Close(); } catch (Exception ex) { throw ex; } return(res); }
public ActionResult AddGeneralPayment(string Id) { int accountMasterId = string.IsNullOrEmpty(Id.DecryptString()) ? default(int) : Convert.ToInt32(Id.DecryptString()); GroupGeneralPaymentDto grpGeneralPaymentDto = new GroupGeneralPaymentDto(); if (accountMasterId > 0) { grpGeneralPaymentDto = _groupGeneralPayemntService.GetGroupGeneralPaymentById(accountMasterId); } LoadOtherReceiptDropDowns(); return(View(grpGeneralPaymentDto)); }
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 ViewGeneralPayment(string id) { int accountMasterId = Convert.ToInt32(id.DecryptString()); GroupGeneralPaymentDto grpGeneralPaymentDto = new GroupGeneralPaymentDto(); if (accountMasterId > 0) { grpGeneralPaymentDto = _groupGeneralPayemntService.GetGroupGeneralPaymentById(accountMasterId); } if (accountMasterId < 1) { return(RedirectToAction("GeneralPaymentsLookup")); } return(View(grpGeneralPaymentDto)); }
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)); }