private ResultDto insertUpdaterefundsFromFederation(GeneralReceiptDto generalpayments)
{
ResultDto resultDto = new ResultDto();
generalpayments.IsGroup = true;
generalpayments.IsPairedRecord = true;
string objectName = "Refunds From Federation";
try
{
string amountxml = CommonMethods.SerializeListDto <List <AddAmountDto> >(generalpayments.Addamount);
ObjectParameter paramAccountMasterID = new ObjectParameter("AccountMasterID", generalpayments.AccountMasterID);
ObjectParameter paramVoucherNumber = new ObjectParameter("VoucherNumber", string.Empty);
_dbContext.uspAccountMasterRefundsFromFederationInsert(paramAccountMasterID, generalpayments.TransactionDate, paramVoucherNumber, generalpayments.VoucherRefNumber, generalpayments.PartyName, generalpayments.EmployeeID, generalpayments.AHID,
generalpayments.SubHeadID, generalpayments.TransactionType, generalpayments.Amount, generalpayments.TransactionMode, generalpayments.ChequeNumber, generalpayments.ChequeDate,
generalpayments.BankAccount, generalpayments.Narration, generalpayments.IsGroup, generalpayments.GroupID, generalpayments.UserID, generalpayments.Type, generalpayments.IsPairedRecord, amountxml);
long masterObjectId = Convert.ToInt64(paramAccountMasterID.Value);
resultDto.ObjectId = Convert.ToInt32(masterObjectId);
resultDto.ObjectCode = string.IsNullOrEmpty((string)paramVoucherNumber.Value) ? generalpayments.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);
}
public GeneralReceiptDto GetByID(long AccountMasterId)
{
long accountmasterID = Convert.ToInt64(AccountMasterId);
ObjectParameter prmAccountMasterId = new ObjectParameter("AccountMasterId", accountmasterID);
var results = new MFISDBContext()
.MultipleResults(CustomProcNames.uspGeneralReceiptGetById, prmAccountMasterId)
.With <GeneralReceiptDto>()
.With <AddAmountDto>()
.Execute();
GeneralReceiptDto generalReceiptDto = new GeneralReceiptDto();
if ((results[0] as List <GeneralReceiptDto>).Count > 0)
{
generalReceiptDto = (results[0] as List <GeneralReceiptDto>)[0];
var addAmountDtoList = results[1] as List <AddAmountDto>;
generalReceiptDto.Addamount = addAmountDtoList;
}
return(generalReceiptDto);
}
public GeneralReceiptDto GetByID(long AccountMasterId)
{
long accountmasterID = Convert.ToInt64(AccountMasterId);
ObjectParameter prmAccountMasterId = new ObjectParameter("AccountMasterId", accountmasterID);
var results = new MFISDBContext()
.MultipleResults("uspRefundsFromfederationGetById", prmAccountMasterId)
.With <GeneralReceiptDto>()
.With <AddAmountDto>()
.Execute();
var generalPaymentsDto = new GeneralReceiptDto();
var addAmountDtoList = new List <AddAmountDto>();
if ((results[0] as List <GeneralReceiptDto>).Count > 0)
{
generalPaymentsDto = (results[0] as List <GeneralReceiptDto>)[0];
addAmountDtoList = results[1] as List <AddAmountDto>;
generalPaymentsDto.Addamount = addAmountDtoList;
}
return(generalPaymentsDto);
}
public ResultDto Update(GeneralReceiptDto generalpayments)
{
return(insertUpdaterefundsFromFederation(generalpayments));
}
public ResultDto Update(GeneralReceiptDto generalreceiptDto)
{
return(insertupdateGeneralreceipt(generalreceiptDto));
}
public ActionResult CreatePaymentsToFederation(string Id)
{
bool isFederation = true;
long AccountMasterId = string.IsNullOrEmpty(Id.DecryptString()) ? default(int) : Convert.ToInt64(Id.DecryptString());
GeneralReceiptDto objDto = new GeneralReceiptDto();
if (AccountMasterId > 0)
{
objDto = _paymentsToFederationService.GetByID(AccountMasterId);
if (objDto.Addamount.Count > 0)
{
List <AddAmountDto> lstAccounts = new List <AddAmountDto>();
var list = objDto.Addamount;
foreach (var i in list)
{
AddAmountDto Addamountdto = new AddAmountDto();
int ahId = i.AHID;
AccountHeadDto accountHeadDto = _accountheadService.GetAccountHeadViewBalanceSummary(ahId, isFederation);
if (accountHeadDto.ClosingBalance != 0)
{
Decimal ClosingBalance = accountHeadDto.ClosingBalance + i.CrAmount;
Addamountdto.Balance = ClosingBalance;
}
Addamountdto.AHID = i.AHID;
Addamountdto.AHCode = i.AHCode;
Addamountdto.AHName = i.AHName;
Addamountdto.CrAmount = i.CrAmount;
Addamountdto.DrAmount = i.DrAmount;
lstAccounts.Add(Addamountdto);
}
objDto.Addamount = lstAccounts;
}
}
List <SelectListDto> lstselectDto = _accountheadService.GetGeneralReceiptLedgersDropDown(true);
SelectList lstahcode = new SelectList(lstselectDto, "ID", "Text");
ViewBag.ahcodes = lstahcode;
isFederation = true;
List <SelectListDto> lstClusters = _clusterService.GetClusterSelectList();
SelectList slClusters = new SelectList(lstClusters, "ID", "Text");
ViewBag.clusters = slClusters;
List <GroupLookupDto> lstGroupDto = _groupService.Lookup();
SelectList lstgroup = new SelectList(lstGroupDto, "GroupID", "GroupCode");
ViewBag.GroupNames = lstgroup;
int EmployeeID = UserInfo.UserID;
EmployeeDto ObjEmployee = _employeeService.GetByID(EmployeeID);
objDto.EmployeeCode = ObjEmployee.EmployeeCode;
objDto.EmployeeName = ObjEmployee.EmployeeName;
List <uspAccountHeadGetAll_Result> lstuspAccountHeadGetAll_Result = _dbContext.uspAccountHeadGetAll().ToList();
var listOfSearchedIds = new List <string> {
"2020", "2114", "1231", "1232", "1241", "1242", "1243"
};
lstuspAccountHeadGetAll_Result = (lstuspAccountHeadGetAll_Result.Where(x => listOfSearchedIds.Contains(x.AHCode))).ToList();
SelectList FederationAHeads = new SelectList(lstuspAccountHeadGetAll_Result, "AHID", "AHName");
ViewBag.FederationAH = FederationAHeads;
return(View(objDto));
}
private GeneralReceiptDto ReadFormData(FormCollection form)
{
GeneralReceiptDto generalreceiptDto = new GeneralReceiptDto();
generalreceiptDto.AccountMasterID = Convert.ToInt64(Request.Form["hdnObjectID"]);
if (generalreceiptDto.AccountMasterID == 0)
{
int accountMasterID = default(int);
int.TryParse(form["AccountMasterID"], out accountMasterID);
}
generalreceiptDto.UserID = UserInfo.UserID;
generalreceiptDto.EmployeeID = UserInfo.UserID;
if (form["BankAccount"] != null && form["BankAccount"] != string.Empty && form["BankAccount"] != "0")
{
generalreceiptDto.BankAccount = Convert.ToInt32(form["BankAccount"]);
}
generalreceiptDto.AHID = Convert.ToInt32(form["hdnCashinHandAHID"]);
generalreceiptDto.Amount = Convert.ToDecimal(form["DRAmountTotal"]);
generalreceiptDto.GroupID = GroupInfo.GroupID;
generalreceiptDto.VoucherRefNumber = Convert.ToString(form["VoucherRefNumber"]);
generalreceiptDto.PartyName = Convert.ToString(form["PartyName"]);
generalreceiptDto.TransactionMode = Convert.ToString(form["TransactionMode"]);
generalreceiptDto.ChequeNumber = Convert.ToString(form["ChequeNumber"]);
generalreceiptDto.Narration = Convert.ToString(form["Narration"]);
generalreceiptDto.TransactionType = Convert.ToInt32(form["TransactionType"]);
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);
}
generalreceiptDto.TransactionDate = dtTransactionDate;
generalreceiptDto.ChequeDate = dtChequeDate;
int maxIndex = Convert.ToInt32(form["hdnMaxRateIndex"]);
generalreceiptDto.Addamount = new List <AddAmountDto>();
AddAmountDto Amount = null;
for (int i = 1; i <= maxIndex; i++)
{
if (form["hdnAccountCode_" + i] == null)
{
continue;
}
Amount = new AddAmountDto();
Amount.AHID = Convert.ToInt32(form["FedAHead_" + i]);
Amount.AHCode = form["hdnAccountCode_" + i];
Amount.Type = form["hdntypeBy_" + i];
Amount.AHName = form["hdnAccountName_" + i];
Amount.DrAmount = Convert.ToDecimal(form["hdnDrAmount_" + i]);
Amount.CrAmount = Convert.ToDecimal(form["hdnCrAmount_" + i]);
Amount.IsMaster = false;
generalreceiptDto.Addamount.Add(Amount);
}
var MasterAmount = new AddAmountDto();
MasterAmount.AHID = Convert.ToInt32(form["hdnCashinHandAHID"]);
MasterAmount.CrAmount = 0;
MasterAmount.DrAmount = Convert.ToDecimal(form["DRAmountTotal"]);
MasterAmount.IsMaster = true;
generalreceiptDto.Addamount.Add(MasterAmount);
return(generalreceiptDto);
}
public ActionResult CreateGeneralReceipt(string Id)
{
long AccountMasterId = string.IsNullOrEmpty(Id.DecryptString()) ? default(int) : Convert.ToInt64(Id.DecryptString());
GeneralReceiptDto objDto = new GeneralReceiptDto();
if (AccountMasterId > 0)
{
objDto = _generalReceiptService.GetByID(AccountMasterId);
if (objDto.Addamount.Count > 0)
{
List <AddAmountDto> lstAccounts = new List <AddAmountDto>();
var list = objDto.Addamount;
foreach (var i in list)
{
AddAmountDto Addamountdto = new AddAmountDto();
int ahId = i.AHID;
bool isFederation = true;
AccountHeadDto accountHeadDto = _accountheadService.GetAccountHeadViewBalanceSummary(ahId, isFederation);
if (accountHeadDto.ClosingBalance != 0)
{
Decimal ClosingBalance = accountHeadDto.ClosingBalance + i.CrAmount;
Addamountdto.Balance = ClosingBalance;
}
Addamountdto.AHID = i.AHID;
Addamountdto.AHCode = i.AHCode;
Addamountdto.AHName = i.AHName;
Addamountdto.CrAmount = i.CrAmount;
Addamountdto.DrAmount = i.DrAmount;
lstAccounts.Add(Addamountdto);
}
objDto.Addamount = lstAccounts;
}
}
//bool isFederation = true;
//List<AccountHeadDto> lstslaccounts = _accountheadService.GetAll(isFederation).FindAll(f => f.AHLevel > 4 && f.IsSLAccount == false);
//SelectList slaccountno = new SelectList(lstslaccounts, "AHID", "AHCode");
//ViewBag.slaccounts = slaccountno;
List <SelectListDto> lstselectDto = _accountheadService.GetGeneralReceiptLedgersDropDown(true);
SelectList lstahcode = new SelectList(lstselectDto, "ID", "Text");
ViewBag.ahcodes = lstahcode;
BankMasterViewDto objBank = new BankMasterViewDto();
List <BankMasterViewDto> lstFedBanks = _groupReceiptService.GetFederationBanks();
for (int i = 0; i < lstFedBanks.Count; i++)
{
var lst = lstFedBanks[i].AccountNumber + ':' + lstFedBanks[i].BankCode;
lstFedBanks[i].AccountNumber = lst;
}
SelectList lstFederationBanks = new SelectList(lstFedBanks, "BankEntryID", "AccountNumber", objBank.BankEntryID);
ViewBag.federationbanks = lstFederationBanks;
List <SelectListDto> lstClusters = _clusterService.GetClusterSelectList();
SelectList slClusters = new SelectList(lstClusters, "ID", "Text");
ViewBag.clusters = slClusters;
List <GroupLookupDto> lstGroupDto = _groupService.Lookup();
SelectList lstgroup = new SelectList(lstGroupDto, "GroupID", "GroupCode");
ViewBag.GroupNames = lstgroup;
int EmployeeID = UserInfo.UserID;
EmployeeDto ObjEmployee = _employeeService.GetByID(EmployeeID);
objDto.EmployeeCode = ObjEmployee.EmployeeCode;
objDto.EmployeeName = ObjEmployee.EmployeeName;
return(View(objDto));
}
public ActionResult CreateGeneralReceipt(string Id)
{
long AccountMasterId = string.IsNullOrEmpty(Id.DecryptString()) ? default(int) : Convert.ToInt64(Id.DecryptString());
GeneralReceiptDto objDto = new GeneralReceiptDto();
ViewBag.LockStatus = GroupInfo.LockStatus;
if (AccountMasterId > 0)
{
objDto = _generalReceiptService.GetByID(AccountMasterId);
if (objDto.AccountMasterID > 0)
{
if (objDto.Addamount.Count > 0)
{
List <AddAmountDto> lstAccounts = new List <AddAmountDto>();
var list = objDto.Addamount;
foreach (var i in list)
{
AddAmountDto Addamountdto = new AddAmountDto();
int ahId = i.AHID;
bool isFederation = true;
AccountHeadDto accountHeadDto = _accountheadService.GetAccountHeadViewBalanceSummary(ahId, isFederation);
if (accountHeadDto.ClosingBalance != 0)
{
Decimal ClosingBalance = accountHeadDto.ClosingBalance + i.CrAmount;
Addamountdto.Balance = ClosingBalance;
}
Addamountdto.AHID = i.AHID;
Addamountdto.AHCode = i.AHCode;
Addamountdto.AHName = i.AHName;
Addamountdto.CrAmount = i.CrAmount;
Addamountdto.DrAmount = i.DrAmount;
lstAccounts.Add(Addamountdto);
}
objDto.Addamount = lstAccounts;
}
}
else
{
ViewBag.Message = "General receipt was Not Active";
}
}
//List<SelectListDto> lstselectDto = _accountheadService.GetGeneralReceiptLedgersDropDown(true);
//SelectList lstahcode = new SelectList(lstselectDto, "ID", "Text");
//ViewBag.ahcodes = lstahcode;
List <AccountHeadDto> lstAccountHeadDtos = _accountheadService.GetGroupAccountTree(GroupInfo.GroupID);
lstAccountHeadDtos = lstAccountHeadDtos.FindAll(l => l.AHLevel > 3);
//List<SelectListDto> lstselectDto = _accountheadService.GetGeneralReceiptLedgersDropDown(true);
SelectList lstahcode = new SelectList(lstAccountHeadDtos.OrderBy(l => l.AHNameAndCode), "AHID", "AHNameAndCode");
ViewBag.ahcodes = lstahcode;
BankMasterBll bankBll = new BankMasterBll();
List <BankMasterDto> lstFedBanks = bankBll.GetGroupBanks(GroupInfo.GroupID);
SelectList lstFederationBanks = new SelectList(lstFedBanks, "BankEntryID", "AccountNumber", "Select Bank");
ViewBag.federationbanks = lstFederationBanks;
int EmployeeID = UserInfo.UserID;
EmployeeDto ObjEmployee = _employeeService.GetByID(EmployeeID);
objDto.EmployeeCode = ObjEmployee.EmployeeCode;
objDto.EmployeeName = ObjEmployee.EmployeeName;
if (objDto.AccountMasterID > 0 && objDto.TransactionMode == "B")
{
objDto.AccountName = lstFedBanks.Find(l => l.AHID == objDto.AHID).AHName;
}
return(View(objDto));
}
