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);
}
