private void LoadDropDowns() { ReceiptMasterDto objreceipt = new ReceiptMasterDto(); List <SelectListDto> lstClusters = _ClusterService.GetClusterSelectList(); SelectList slClusters = new SelectList(lstClusters, "ID", "Text"); ViewBag.Clusters = slClusters; #region DropDowns List <SelectListDto> groupSelectList = _groupService.GetGroupByClusterID(objreceipt.ClusterID); SelectList lstGroupNames = new SelectList(groupSelectList, "ID", "Text"); ViewBag.GroupNames = lstGroupNames; //List<SelectListDto> villageSelectList = _villageService.GetVillageByClusterID(objreceipt.ClusterID); //SelectList lstvillage = new SelectList(villageSelectList, "ID", "Text"); //ViewBag.Village = lstvillage; //List<SelectListDto> groupSelectList = _groupService.GetGroupByVillageID(objreceipt.VillageID); //SelectList lstGroupNames = new SelectList(groupSelectList, "ID", "Text"); //ViewBag.GroupNames = lstGroupNames; //List<BankMasterViewDto> lstAllBanks = _groupReceiptService.GetGroupBanks(); //SelectList lstgroupBanks = new SelectList(lstAllBanks, "BankEntryID", "AccountNumber", objBank.BankEntryID); //ViewBag.GroupBanks = lstgroupBanks; #endregion DropDowns BankMasterViewDto objBank = new BankMasterViewDto(); List <BankMasterViewDto> lstFedBanks = _groupReceiptService.GetFederationBanks(); SelectList lstFederationBanks = new SelectList(lstFedBanks, "BankEntryID", "AccountNumber", objBank.BankEntryID); ViewBag.federationbanks = lstFederationBanks; }
public ActionResult GetReceiptTemplate(int groupid, string transactiondate) { ReceiptDll objDll = new ReceiptDll(); List <ReceiptTranscationDto> lstreceiptsHeads = objDll.GetGroupReceiptAccountdetails(groupid, transactiondate); ReceiptMasterDto objreceipt = new ReceiptMasterDto(); objreceipt.lstGroupReceiptTranscationDto = lstreceiptsHeads; if (groupid > 0) { // objreceipt = _groupReceiptService.GetByID(groupid); // get repayments start List <RepaymentDto> list = new List <RepaymentDto>(); list = _repaymentService.GetRepayment(groupid, transactiondate); objreceipt.lstRepeyment = list; //ViewBag.Repayments = list.Find(t => t.Amount); //ViewBag.Repayments = list; ///end } var receiptDto = GetAccountHeadClosingBalnces(); ViewBag.CashInHandDetails = receiptDto; return(View("_ReceiptTemplate", objreceipt)); }
public ActionResult CreateJournalEntryVoucher(string Id) { long AccountMasterId = string.IsNullOrEmpty(Id.DecryptString()) ? default(int) : Convert.ToInt64(Id.DecryptString()); ReceiptMasterDto objDto = new ReceiptMasterDto(); if (AccountMasterId > 0) { objDto = _journalService.GetByID(AccountMasterId); if (objDto.lstGroupReceiptTranscationDto.Count > 0) { List <ReceiptTranscationDto> lstAccounts = new List <ReceiptTranscationDto>(); var list = objDto.lstGroupReceiptTranscationDto; foreach (var i in list) { ReceiptTranscationDto Addrecaccount = new ReceiptTranscationDto(); Addrecaccount.AHID = i.AHID; Addrecaccount.AHName = i.AHName; Addrecaccount.AHCode = i.AHCode; Addrecaccount.DrAmount = i.DrAmount; Addrecaccount.CrAmount = i.CrAmount; lstAccounts.Add(Addrecaccount); } objDto.lstGroupReceiptTranscationDto = lstAccounts; } } LoadDropDown(); int EmployeeID = UserInfo.UserID; EmployeeDto ObjEmployee = _employeeService.GetByID(EmployeeID); objDto.EmployeeCode = ObjEmployee.EmployeeCode; objDto.EmployeeName = ObjEmployee.EmployeeName; return(View(objDto)); }
public ResultDto InsertUpdateJournalEntry(ReceiptMasterDto journalEntry) { ResultDto resultDto = new ResultDto(); string objectName = "Journal Entry Voucher"; try { string amountxml = CommonMethods.SerializeListDto <List <ReceiptTranscationDto> >(journalEntry.lstGroupReceiptTranscationDto); ObjectParameter paramAccountMasterID = new ObjectParameter("AccountMasterID", journalEntry.AccountMasterID); ObjectParameter paramVoucherNumber = new ObjectParameter("VoucherNumber", string.Empty);//journalEntry.SLAcNo, journalEntry.SLAName, int effectedCount = _dbContext.uspJournalEntryInsertUpdate(paramAccountMasterID, journalEntry.TransactionDate, paramVoucherNumber, journalEntry.VoucherRefNumber, journalEntry.EmployeeID, journalEntry.AHID, journalEntry.SubHeadID, journalEntry.Amount, //journalEntry.BankAccount, journalEntry.Narration, journalEntry.PartyName, journalEntry.TransactionType, journalEntry.TransactionMode, journalEntry.IsGroup, journalEntry.GroupID, journalEntry.UserID, amountxml); long masterObjectId = Convert.ToInt64(paramAccountMasterID.Value); resultDto.ObjectId = Convert.ToInt32(masterObjectId); resultDto.ObjectCode = string.IsNullOrEmpty((string)paramVoucherNumber.Value) ? journalEntry.VoucherNumber : (string)paramVoucherNumber.Value; if (resultDto.ObjectId > 0) { resultDto.Message = string.Format("{0} details saved successfully with code : {1}", objectName, resultDto.ObjectCode); } else if (resultDto.ObjectId == -1) { resultDto.Message = string.Format("Error occured while generating {0} code", objectName); } else { resultDto.Message = string.Format("Error occured while saving {0} details", objectName); } } catch (Exception) { resultDto.Message = string.Format("Service layer error occured while saving the {0} details", objectName); resultDto.ObjectId = -98; } return(resultDto); }
private ReceiptMasterDto ReadFormData(FormCollection form) { ReceiptMasterDto groupReceiptDto = new ReceiptMasterDto(); int AccountMasterID = default(int); DateTime dtTransactiondate = form["txtTransactionDate"].ConvertToDateTime(); int.TryParse(form["AccountTranID"], out AccountMasterID); groupReceiptDto.UserID = UserInfo.UserID; groupReceiptDto.EmployeeID = UserInfo.UserID; groupReceiptDto.VoucherRefNumber = Convert.ToString(form["JournalEntryRefNo"]); groupReceiptDto.AccountMasterID = Convert.ToInt64(form["AccountMasterID"]); groupReceiptDto.Amount = Convert.ToDecimal(form["hdnTotal"]); groupReceiptDto.EmployeeName = Convert.ToString(form["EmployeeName"]); groupReceiptDto.TransactionDate = dtTransactiondate; groupReceiptDto.AHID = Convert.ToInt32(form["AHID"]); groupReceiptDto.AHCode = Convert.ToString(form["AHCode"]); groupReceiptDto.AHName = Convert.ToString(form["AHName"]); groupReceiptDto.Amount = Convert.ToDecimal(form["hdnTotal"]); groupReceiptDto.TransactionMode = Convert.ToString(form["TransactionMode"]); groupReceiptDto.Narration = Convert.ToString(form["Narration"]); groupReceiptDto.TransactionType = Convert.ToInt32(form["TransactionType"]); int maxIndex = Convert.ToInt32(form["hdnMaxJournalIndex"]); groupReceiptDto.lstGroupReceiptTranscationDto = new List <ReceiptTranscationDto>(); ReceiptTranscationDto Amount = null; for (int i = 1; i <= maxIndex; i++) { if (form["hdnAHCode_" + i] == null) { continue; } Amount = new ReceiptTranscationDto(); //if ((form["hdnSLAccountNo_" + i]) != "") //{ // Amount.AHID = Convert.ToInt32(form["hdnSLAccountID_" + i]); //} //else //{ Amount.AHID = Convert.ToInt32(form["hdnAHID_" + i]); //} Amount.AHName = form["hdnAHCode_" + i]; //Amount.AHCode = form["hdnSLACNo_" + i]; //Amount.AHName = form["hdnSLAName_" + i]; Amount.DrAmount = Convert.ToDecimal(form["hdnDrAmount_" + i]); Amount.CrAmount = Convert.ToDecimal(form["hdnCrAmount_" + i]); Amount.AccountTranID = Convert.ToInt64(form["hdnAccountTranID_" + i]); groupReceiptDto.lstGroupReceiptTranscationDto.Add(Amount); } return(groupReceiptDto); }
public ActionResult CreateJournalEntryVoucher(string Id) { long AccountMasterId = string.IsNullOrEmpty(Id.DecryptString()) ? default(int) : Convert.ToInt64(Id.DecryptString()); ReceiptMasterDto objDto = new ReceiptMasterDto(); if (AccountMasterId > 0) { objDto = _journalService.GetByID(AccountMasterId); } LoadDropDown(); int EmployeeID = UserInfo.UserID; EmployeeDto ObjEmployee = _employeeService.GetByID(EmployeeID); objDto.EmployeeCode = ObjEmployee.EmployeeCode; objDto.EmployeeName = ObjEmployee.EmployeeName; return(View(objDto)); }
public ReceiptMasterDto GetByID(int AccountMasterID) { var prmAccountMasterID = new ObjectParameter("AccountMasterID", AccountMasterID); var results = new MFISDBContext() .MultipleResults(CustomProcNames.uspgroupReceiptByID, prmAccountMasterID) .With <ReceiptMasterDto>() .With <ReceiptTranscationDto>() .Execute(); var receiptMasterDto = new ReceiptMasterDto(); if ((results[0] as List <ReceiptMasterDto>).Count > 0) { receiptMasterDto = (results[0] as List <ReceiptMasterDto>)[0]; var receiptTranscationDtoList = results[1] as List <ReceiptTranscationDto>; receiptMasterDto.lstGroupReceiptTranscationDto = receiptTranscationDtoList; } return(receiptMasterDto); }
private ResultDto InsertUpdateMemberReceipt(ReceiptMasterDto groupReceiptdto) { ResultDto resultDto = new ResultDto(); string objectName = "MemberReceipt"; try { string receiptxml = CommonMethods.SerializeListDto <List <ReceiptTranscationDto> >(groupReceiptdto.lstGroupReceiptTranscationDto); ObjectParameter paramaccounmasterID = new ObjectParameter("AccountMasterID", groupReceiptdto.AccountMasterID); ObjectParameter paramreceiptCode = new ObjectParameter("VoucherNumber", string.Empty); _dbContext.uspMemberReceiptInsertUpdate(paramaccounmasterID, groupReceiptdto.TransactionDate, paramreceiptCode, groupReceiptdto.VoucherRefNumber, groupReceiptdto.CodeSno, groupReceiptdto.PartyName, groupReceiptdto.EmployeeID, groupReceiptdto.AHID, groupReceiptdto.SubHeadID, groupReceiptdto.TransactionType, groupReceiptdto.Amount, groupReceiptdto.TransactionMode, groupReceiptdto.ChequeNumber, groupReceiptdto.ChequeDate, groupReceiptdto.BankAccount, groupReceiptdto.Narration, receiptxml, groupReceiptdto.IsGroup, groupReceiptdto.GroupID, groupReceiptdto.MemberId, groupReceiptdto.UserID); resultDto.ObjectId = Convert.ToInt32(paramaccounmasterID.Value); resultDto.ObjectCode = string.IsNullOrEmpty((string)paramreceiptCode.Value) ? groupReceiptdto.VoucherNumber : (string)paramreceiptCode.Value; if (resultDto.ObjectId > 0) { resultDto.Message = string.Format("{0} details saved successfully with code : {1}", objectName, resultDto.ObjectCode); } else if (resultDto.ObjectId == -1) { resultDto.Message = string.Format("Error occured while generating {0} code", objectName); } else { resultDto.Message = string.Format("Error occured while saving {0} details", objectName); } } catch (Exception) { resultDto.Message = string.Format("Service layer error occured while saving the {0} details", objectName); resultDto.ObjectId = -98; } return(resultDto); }
public ActionResult GetReceiptTemplate(int memberid, string transactiondate) { ReceiptDll objDll = new ReceiptDll(); List <ReceiptTranscationDto> lstreceiptsHeads = objDll.GetMemberReceiptAccountdetails(memberid, transactiondate); ReceiptMasterDto objreceipt = new ReceiptMasterDto(); objreceipt.lstGroupReceiptTranscationDto = lstreceiptsHeads; if (memberid > 0) { List <RepaymentDto> list = new List <RepaymentDto>(); list = _repaymentService.GetRepayment(memberid, transactiondate); objreceipt.lstRepeyment = list; } List <ReceiptTranscationDto> lstDto = new List <ReceiptTranscationDto>(); AccountHeadDto objAccountHead = _accountheadService.GetCashInHandAccount(false); ViewBag.CashInHandDetails = objAccountHead; return(View("_ReceiptTemplate", objreceipt)); }
public ActionResult CreateGroupReceipt(string id) { int AccountMasterID = string.IsNullOrEmpty(id.DecryptString()) ? default(int) : Convert.ToInt32(id.DecryptString()); ReceiptMasterDto objreceipt = new ReceiptMasterDto(); //objreceipt.lstGroupReceiptTranscationDto = Accountheads(); var ReceiptTranscationDto = GetAccountHeadClosingBalnces(); ViewBag.CashInHandDetails = ReceiptTranscationDto; int EmployeeID = UserInfo.UserID; EmployeeDto obj = _employeeService.GetByID(EmployeeID); objreceipt.EmployeeName = obj.EmployeeName; objreceipt.EmployeeCode = obj.EmployeeCode; objreceipt.EmployeeID = obj.EmployeeID; LoadDropDowns(); return(View(objreceipt)); }
private void LoadDropDowns() { ReceiptMasterDto objreceipt = new ReceiptMasterDto(); MemberDto memberdto = new MemberDto(); int GroupId = GroupInfo.GroupID; List <MemberLookupDto> lstmemberlookupDto = _memberservice.LookUp(GroupId); //SelectList lstmemberCodes = new SelectList(lstmemberlookupDto, "MemberId", "MemberCode", memberdto.MemberID); SelectList lstmemberCodes = new SelectList(lstmemberlookupDto, "MemberId", "MemberName", memberdto.MemberID); ViewBag.MemberCodes = lstmemberCodes; int groupId = GroupInfo.GroupID; BankMasterViewDto objBank = new BankMasterViewDto(); List <BankMasterViewDto> lstAllBanks = _ContraEntryService.GetAllGroupBanksByGroupId(groupId); SelectList lstgroupBanks = new SelectList(lstAllBanks, "BankEntryID", "AccountNumber", objBank.BankEntryID); ViewBag.GroupBanks = lstgroupBanks; //BankMasterViewDto objBank = new BankMasterViewDto(); //List<BankMasterViewDto> lstAllBanks = _groupReceiptService.GetGroupBanks(); //SelectList lstgroupBanks = new SelectList(lstAllBanks, "AHID", "AccountNumber", objBank.BankEntryID); //ViewBag.GroupBanks = lstgroupBanks; }
private ReceiptMasterDto ReadFormData(FormCollection form) { ReceiptMasterDto groupReceiptDto = new ReceiptMasterDto(); int accountMasterId = default(int); int.TryParse(form["AccountMasterID"], out accountMasterId); groupReceiptDto.IsGroup = true; groupReceiptDto.SubHeadID = 1; groupReceiptDto.AccountMasterID = accountMasterId; groupReceiptDto.MemberId = Convert.ToInt32(form["MemberId"]); groupReceiptDto.VoucherRefNumber = Convert.ToString(form["VoucherRefNumber"]); //groupReceiptDto.GroupID = Convert.ToInt32(form["GroupID"]); groupReceiptDto.EmployeeID = UserInfo.UserID; //groupReceiptDto.EmployeeCode = UserInfo.e ; //groupReceiptDto.EmployeeName = Convert.ToString(form["EmployeeName"]); groupReceiptDto.TransactionDate = Convert.ToDateTime(form["TransactionDate"]); groupReceiptDto.TransactionType = Convert.ToInt32(form["TransactionType"]); groupReceiptDto.TransactionMode = Convert.ToString(Request.Form["TransactionMode"]); groupReceiptDto.Amount = Convert.ToDecimal(form["Amount"]); if (form["GroupBankAccountNumber"] != null && form["GroupBankAccountNumber"] != string.Empty && form["GroupBankAccountNumber"] != "0") { groupReceiptDto.BankAccount = Convert.ToInt32(form["GroupBankAccountNumber"]); } if (groupReceiptDto.TransactionMode == "B") { groupReceiptDto.GroupBankAccountName = Convert.ToString(form["GroupBankAccountName"]); groupReceiptDto.ChequeNumber = Convert.ToString(form["ChequeNumber"]); groupReceiptDto.ChequeDate = Convert.ToDateTime(form["ChequeDate"]); } groupReceiptDto.AHID = Convert.ToInt32(form["hdnCashInHandAHID"]); groupReceiptDto.ReferenceNumber = Convert.ToString(form["ReferenceNumber"]); groupReceiptDto.FederationBankAccountNumber = Convert.ToString(form["FederationBankAccountNumber"]); groupReceiptDto.FederationBankAccountName = Convert.ToString(form["FederationBankAccountName"]); groupReceiptDto.Narration = Convert.ToString(form["Narration"]); groupReceiptDto.PartyName = Convert.ToString(form["PartyName"]); groupReceiptDto.UserID = UserInfo.UserID; groupReceiptDto.GroupID = GroupInfo.GroupID; int myIndex = Convert.ToInt32(form["index"]); groupReceiptDto.lstGroupReceiptTranscationDto = new List <ReceiptTranscationDto>(); ReceiptTranscationDto receipt = null; //foreach (var rpt in groupReceiptDto.lstGroupReceiptTranscationDto) for (int i = 1; i <= myIndex; i++) { receipt = new ReceiptTranscationDto(); receipt.CrAmount = Convert.ToDecimal(form["CrAmount_" + i]); if (receipt.CrAmount <= 0) { continue; } receipt.AHID = Convert.ToInt32(form["AHID_" + i]); receipt.AHName = Convert.ToString(form["AHName_" + i]); //receipt.OpeningBalance = Convert.ToDecimal(form["OpeningBalance_" + i]); receipt.IsMaster = false; groupReceiptDto.lstGroupReceiptTranscationDto.Add(receipt); } receipt = new ReceiptTranscationDto(); receipt.AHID = groupReceiptDto.AHID; receipt.AHName = ""; receipt.IsMaster = true; //receipt.OpeningBalance = Convert.ToDecimal(form["OpeningBalance_" + i]); receipt.DrAmount = groupReceiptDto.lstGroupReceiptTranscationDto.Sum(s => s.CrAmount); groupReceiptDto.lstGroupReceiptTranscationDto.Add(receipt); return(groupReceiptDto); }
public ResultDto Update(ReceiptMasterDto journalEntry) { return(InsertUpdateJournalEntry(journalEntry)); }
/* End Member Receipt && Group Receipt AccountDetails Start---- 07/17/2016 */ public ResultDto MemberReceiptInsertUpdate(ReceiptMasterDto groupReceiptdto) { ResultDto result = new ResultDto(); string receiptxml = CommonMethods.SerializeListDto <List <ReceiptTranscationDto> >(groupReceiptdto.lstGroupReceiptTranscationDto); List <ReceiptTranscationDto> lstGroupReceiptDto = new List <ReceiptTranscationDto>(); try { AdoHelper obj = new AdoHelper(); SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@accountMasterID", groupReceiptdto.AccountMasterID) { SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output }, new SqlParameter("@TransactionDate", groupReceiptdto.TransactionDate) { SqlDbType = SqlDbType.DateTime }, new SqlParameter("@voucherNumber", groupReceiptdto.VoucherNumber) { SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Output, Size = 250 }, new SqlParameter("@VoucherRefNumber", groupReceiptdto.VoucherRefNumber) { SqlDbType = SqlDbType.VarChar }, new SqlParameter("@CodeSno", groupReceiptdto.CodeSno) { SqlDbType = SqlDbType.Int }, new SqlParameter("@PartyName", groupReceiptdto.PartyName) { SqlDbType = SqlDbType.VarChar }, new SqlParameter("@EmployeeID", groupReceiptdto.EmployeeID) { SqlDbType = SqlDbType.Int }, new SqlParameter("@AHID", groupReceiptdto.AHID) { SqlDbType = SqlDbType.Int }, new SqlParameter("@SubHeadID", groupReceiptdto.SubHeadID) { SqlDbType = SqlDbType.Int }, new SqlParameter("@TransactionType", groupReceiptdto.TransactionType) { SqlDbType = SqlDbType.Int }, new SqlParameter("@Amount", groupReceiptdto.Amount) { SqlDbType = SqlDbType.Decimal }, new SqlParameter("@TransactionMode", groupReceiptdto.TransactionMode) { SqlDbType = SqlDbType.VarChar }, new SqlParameter("@ChequeNumber", groupReceiptdto.ChequeNumber) { SqlDbType = SqlDbType.VarChar }, new SqlParameter("@ChequeDate", groupReceiptdto.ChequeDate) { SqlDbType = SqlDbType.DateTime }, new SqlParameter("@BankAccount", groupReceiptdto.BankAccount) { SqlDbType = SqlDbType.Int }, new SqlParameter("@Narration", groupReceiptdto.Narration) { SqlDbType = SqlDbType.VarChar }, new SqlParameter("@TranscationXML", receiptxml) { SqlDbType = SqlDbType.Xml }, new SqlParameter("@IsGroup", groupReceiptdto.IsGroup) { SqlDbType = SqlDbType.Bit }, new SqlParameter("@GroupID", groupReceiptdto.GroupID) { SqlDbType = SqlDbType.Int }, new SqlParameter("@MemberID", groupReceiptdto.MemberId) { SqlDbType = SqlDbType.Int }, new SqlParameter("@UserId", groupReceiptdto.UserID) { SqlDbType = SqlDbType.Int } }; SqlDataReader sdr = obj.ExecDataReaderProc("uspMemberReceiptInsertUpdate", parms); while (sdr.Read()) { result.ObjectId = Convert.ToInt32(sdr["accountMasterID"]); result.ObjectCode = Convert.ToString(sdr["voucherNumber"]); } } catch (Exception ex) { } return(result); }
public ResultDto Update(ReceiptMasterDto groupReceiptdto) { return(InsertUpdateMemberReceipt(groupReceiptdto)); }
public ResultDto Insert(ReceiptMasterDto groupReceiptdto) { //return InsertUpdateMemberReceipt(groupReceiptdto); return(new ReceiptDll().MemberReceiptInsertUpdate(groupReceiptdto)); }
public ResultDto Insert(ReceiptMasterDto groupReceiptdto) { return(InsertUpdateGroupReceipt(groupReceiptdto)); }
public ActionResult CreateMemberReceipt(string id) { int AccountMasterID = string.IsNullOrEmpty(id.DecryptString()) ? default(int) : Convert.ToInt32(id.DecryptString()); ViewBag.MID = AccountMasterID; ReceiptMasterDto objreceipt = new ReceiptMasterDto(); //objreceipt.lstGroupReceiptTranscationDto = Accountheads(); //objreceipt.lstGroupReceiptTranscationDto = Accountheads(); if (AccountMasterID > 0) { objreceipt = _memberReceiptService.GetByID(AccountMasterID); List <ReceiptTranscationDto> lstTransactionDto = new List <ReceiptTranscationDto>(); lstTransactionDto = objreceipt.lstGroupReceiptTranscationDto; ReceiptDll objDll = new ReceiptDll(); List <ReceiptTranscationDto> lstreceiptsHeads = objDll.GetMemberReceiptAccountdetails(objreceipt.MemberId.Value, DateTime.Now.ToDisplayDateFormat()); objreceipt.lstGroupReceiptTranscationDto = lstreceiptsHeads; foreach (var tranHead in lstTransactionDto) { if (objreceipt.lstGroupReceiptTranscationDto.Exists(l => l.AHID == tranHead.AHID)) { objreceipt.lstGroupReceiptTranscationDto.Find(l => l.AHID == tranHead.AHID).CrAmount = tranHead.CrAmount; objreceipt.lstGroupReceiptTranscationDto.Find(l => l.AHID == tranHead.AHID).DrAmount = tranHead.DrAmount; } } objreceipt.CrTotal = objreceipt.lstGroupReceiptTranscationDto.FindAll(l => l.IsMaster == false).Sum(l => l.CrAmount + l.DrAmount); objreceipt.DrTotal = objreceipt.CrTotal; } LoadDropDowns(); EmployeeDto obj = _employeeService.GetByID(UserInfo.UserID); //meeting date changes GroupMeetingService gms = new GroupMeetingService(); List <GroupMeetingLookupDto> list = gms.Lookup(GroupInfo.GroupID); if (list.Count > 0) { DateTime meetingdate = list.Max(l => l.MeetingDate); ViewBag.MeetingDate = meetingdate; AccountHeadDto objAccountHead = _accountheadService.GetCashInHandAccount(false); ViewBag.CashInHandDetails = objAccountHead; //var receiptDto = GetAccountHeadClosingBalnces(); //ViewBag.CashInHandDetails = receiptDto; objreceipt.EmployeeName = obj.EmployeeName; objreceipt.EmployeeCode = obj.EmployeeCode; objreceipt.EmployeeID = obj.EmployeeID; objreceipt.TransactionDate = meetingdate; //LoadDropDowns(); return(View(objreceipt)); } else { throw new Exception("There is no meeting date for this group please create meeting"); } }
private ReceiptMasterDto ReadFormData(FormCollection form) { var ReceiptTranscationDto = GetAccountHeadClosingBalnces(); ViewBag.CashInHandDetails = ReceiptTranscationDto; ReceiptMasterDto groupReceiptDto = new ReceiptMasterDto(); int accountMasterId = default(int); int.TryParse(form["AccountMasterID"], out accountMasterId); groupReceiptDto.IsGroup = false; groupReceiptDto.SubHeadID = 1; groupReceiptDto.AccountMasterID = Convert.ToInt32(form["AccountMasterID"]); groupReceiptDto.VoucherNumber = Convert.ToString(form["VoucherNumber"]); groupReceiptDto.GroupID = Convert.ToInt32(form["GroupID"]); groupReceiptDto.GroupName = Convert.ToString(form["GroupName"]); groupReceiptDto.EmployeeID = Convert.ToInt32(form["EmployeeID"]); groupReceiptDto.EmployeeCode = Convert.ToString(form["EmployeeCode"]); groupReceiptDto.EmployeeName = Convert.ToString(form["EmployeeName"]); DateTime dtTransactionDate = DateTime.ParseExact(form["TransactionDate"], "dd/MMM/yyyy", provider); DateTime dtChequeDate = DateTime.Now; if (form["ChequeDate"] != null && form["ChequeDate"] != string.Empty) { dtChequeDate = DateTime.ParseExact(form["ChequeDate"], "dd/MMM/yyyy", provider); } groupReceiptDto.TransactionDate = dtTransactionDate; groupReceiptDto.ChequeDate = dtChequeDate; groupReceiptDto.AHID = Convert.ToInt32(form["AccountHeadId"]); groupReceiptDto.TransactionType = Convert.ToInt32(form["TransactionType"]); groupReceiptDto.TransactionMode = Convert.ToString(Request.Form["TransactionMode"]); groupReceiptDto.Amount = Convert.ToDecimal(form["Amount"]); groupReceiptDto.GroupBankAccountName = Convert.ToString(form["GroupBankAccountName"]); groupReceiptDto.GroupBankAccountNumber = Convert.ToString(form["GroupBankAccountNumber"]); groupReceiptDto.ChequeNumber = Convert.ToString(form["ChequeNumber"]); groupReceiptDto.VoucherRefNumber = Convert.ToString(form["VoucherRefNumber"]); if (form["FederationBankAccountNumber"] != null && form["FederationBankAccountNumber"] != string.Empty && form["FederationBankAccountNumber"] != "0") { groupReceiptDto.BankAccount = Convert.ToInt32(form["FederationBankAccountNumber"]); } groupReceiptDto.FederationBankAccountName = Convert.ToString(form["FederationBankAccountName"]); groupReceiptDto.Narration = Convert.ToString(form["Narration"]); groupReceiptDto.PartyName = Convert.ToString(form["PartyName"]); groupReceiptDto.UserID = UserInfo.UserID; int myIndex = Convert.ToInt32(form["index"]); groupReceiptDto.lstGroupReceiptTranscationDto = new List <ReceiptTranscationDto>(); ReceiptTranscationDto receipt = null; //foreach (var rpt in groupReceiptDto.lstGroupReceiptTranscationDto) for (int i = 1; i <= myIndex; i++) { receipt = new ReceiptTranscationDto(); receipt.AHID = Convert.ToInt32(form["AHID_" + i]); receipt.AHName = Convert.ToString(form["AHName_" + i]); receipt.OpeningBalance = Convert.ToDecimal(form["OpeningBalance_" + i]); receipt.CrAmount = Convert.ToDecimal(form["CrAmount_" + i]); receipt.IsMaster = false; groupReceiptDto.lstGroupReceiptTranscationDto.Add(receipt); } receipt = new ReceiptTranscationDto(); receipt.AHID = groupReceiptDto.AHID; receipt.AHName = ""; receipt.IsMaster = true; //receipt.OpeningBalance = Convert.ToDecimal(form["OpeningBalance_" + i]); receipt.CrAmount = groupReceiptDto.lstGroupReceiptTranscationDto.Sum(s => s.CrAmount); groupReceiptDto.lstGroupReceiptTranscationDto.Add(receipt); return(groupReceiptDto); }