public AccountHeadService()
{
_dbContext = new MFISDBContext();
_commonService = new CommonService();
_accountHeadDll = new AccountHeadDll();
AutoMapperEntityConfiguration.Configure();
}
public MemberLoanDisbursementService()
{
_LoanDisbursementDataAccess = new LoanDisbursementDataAccess();
_MemberLoanDisbursementDataAccess = new MemberLoanDisbursementDataAccess();
_dbContext = new MFISDBContext();
AutoMapperEntityConfiguration.Configure();
}
public MemberService()
{
_dbContext = new MFISDBContext();
_commonService = new CommonService();
AutoMapperEntityConfiguration.Configure();
}
public GroupJournalService1()
{
_dbContext = new MFISDBContext();
_dbContext.Configuration.LazyLoadingEnabled = false;
AutoMapperEntityConfiguration.Configure();
_commonService = new CommonService();
}
public GroupMeetingService()
{
_dbContext = new MFISDBContext();
_commonService = new CommonService();
AutoMapperEntityConfiguration.Configure();
}
public ScheduleDTO GetDisbusementDate(int LoanMasterId)
{
ObjectParameter prmAccountMasterId = new ObjectParameter("LoanMasterId", LoanMasterId);
var results = new MFISDBContext()
.MultipleResults(MFIEntityFrameWork.CustomProcNames.GetDisbursementDatebyLoanMasterID, prmAccountMasterId)
.With <ScheduleDTO>()
.Execute();
var ScheduleDto = (results[0] as List <ScheduleDTO>)[0];
return(ScheduleDto);
}
public VillageViewDto GetViewByID(int villageId)
{
var prmVillageId = new ObjectParameter("VillageID", villageId);
var results = new MFISDBContext()
.MultipleResults(CustomProcNames.uspVillageGetViewByID, prmVillageId)
.With <VillageViewDto>()
.Execute();
var villageViewDto = (results[0] as List <VillageViewDto>)[0];
return(villageViewDto);
}
public PanchayatViewDto GetViewByID(int panchayatId)
{
var prmPanchayatId = new ObjectParameter("PanchayatID", panchayatId);
var results = new MFISDBContext()
.MultipleResults(CustomProcNames.uspPanchayatGetViewByID, prmPanchayatId)
.With <PanchayatViewDto>()
.Execute();
var panchayatViewDto = (results[0] as List <PanchayatViewDto>)[0];
return(panchayatViewDto);
}
public BankMasterViewDto GetViewByID(int bankEntryId)
{
var prmbankEntryId = new ObjectParameter("BankEntryID", bankEntryId);
var results = new MFISDBContext()
.MultipleResults(CustomProcNames.uspBankMasterGetViewByID, prmbankEntryId)
.With <BankMasterViewDto>()
.Execute();
var bankMasterViewDto = (results[0] as List <BankMasterViewDto>)[0];
return(bankMasterViewDto);
}
//public bool CreateGroup(GroupMasterDto objGroupMasterDto)
//{
// bool isSuccess = true;
// try
// {
// GroupMaster groupMaster = Mapper.Map<GroupMasterDto, GroupMaster>(objGroupMasterDto);
// groupMaster.CreatedBy = 1;
// groupMaster.StatusID =
// _dbContext.StatusMasters.ToList().Find(l => l.StatusCode == Constants.StatusCodes.Active).StatusID;
// groupMaster.CreatedOn = DateTime.Now;
// _dbContext.GroupMasters.Add(groupMaster);
// _dbContext.SaveChanges();
// }
// catch (Exception)
// {
// isSuccess = false;
// }
// return isSuccess;
//}
public GroupMasterViewDto GetViewByID(int groupId)
{
var prmGroupId = new ObjectParameter("GroupID", groupId);
var results = new MFISDBContext()
.MultipleResults(CustomProcNames.uspGroupGetViewByID, prmGroupId)
.With <GroupMasterViewDto>()
.Execute();
var groupViewDto = (results[0] as List <GroupMasterViewDto>)[0];
return(groupViewDto);
}
public ClusterViewDto GetViewByID(int clusterId)
{
var prmClusterId = new ObjectParameter("ClusterID", clusterId);
var results = new MFISDBContext()
.MultipleResults(CustomProcNames.uspClusterGetViewByID, prmClusterId)
.With <ClusterViewDto>()
.Execute();
var clusterViewDto = (results[0] as List <ClusterViewDto>)[0];
return(clusterViewDto);
}
public BranchViewDto GetViewByID(int branchId)
{
var prmBranchId = new ObjectParameter("BranchID", branchId);
var results = new MFISDBContext()
.MultipleResults(CustomProcNames.uspBranchGetViewByID, prmBranchId)
.With <BranchViewDto>()
.Execute();
var branchViewDto = (results[0] as List <BranchViewDto>)[0];
return(branchViewDto);
}
public PaymentsToFederationController()
{
_clusterService = new ClusterService();
_groupService = new GroupService();
_accountheadService = new AccountHeadService();
_employeeService = new EmployeeService();
_generalpaymentsService = new FederationGeneralPaymentsService();
_groupReceiptService = new GroupReceiptService();
_bankService = new BankService();
_dbContext = new MFISDBContext();
_dbContext = new MFISDBContext();
//_paymentsToFederationService = new PaymentsToFederationService();
_bankService = new BankService();
_groupReceiptService = new GroupReceiptService();
_employeeService = new EmployeeService();
}
public InterestMasterDto GetByID(int interestID)
{
var prmInterestId = new ObjectParameter("InterestID", interestID);
var results = new MFISDBContext()
.MultipleResults(MFIEntityFrameWork.CustomProcNames.uspInterestByID, prmInterestId)
.With <InterestMasterDto>()
.With <InterestRatesDto>()
.Execute();
var interestMasterDto = (results[0] as List <InterestMasterDto>)[0];
var interestRatesDtoList = results[1] as List <InterestRatesDto>;
interestMasterDto.InterestRates = interestRatesDtoList;
return(interestMasterDto);
}
public ReceiptMasterDto GetByID(int AccountMasterID)
{
var prmAccountMasterID = new ObjectParameter("AccountMasterID", AccountMasterID);
var results = new MFISDBContext()
.MultipleResults(MFIEntityFrameWork.CustomProcNames.uspMemberReceiptByID, prmAccountMasterID)
.With <ReceiptMasterDto>()
.With <ReceiptTranscationDto>()
.Execute();
var receiptMasterDto = (results[0] as List <ReceiptMasterDto>)[0];
var receiptTranscationDtoList = results[1] as List <ReceiptTranscationDto>;
receiptMasterDto.lstGroupReceiptTranscationDto = receiptTranscationDtoList;
return(receiptMasterDto);
}
public ReceiptMasterDto GetByID(long AccountMasterId)
{
long accountmasterID = Convert.ToInt64(AccountMasterId);
ObjectParameter prmAccountMasterId = new ObjectParameter("AccountMasterId", accountmasterID);
var results = new MFISDBContext()
.MultipleResults(CustomProcNames.uspJournalEntryVoucherGetById, prmAccountMasterId)
.With <ReceiptMasterDto>()
.With <ReceiptTranscationDto>()
.Execute();
var journalEntryDto = (results[0] as List <ReceiptMasterDto>)[0];
var addAmountDtoList = results[1] as List <ReceiptTranscationDto>;
journalEntryDto.lstGroupReceiptTranscationDto = addAmountDtoList;
return(journalEntryDto);
}
public GeneralPaymentsDto GetByViewID(long AccountMasterId)
{
long accountmasterID = Convert.ToInt64(AccountMasterId);
ObjectParameter prmAccountMasterId = new ObjectParameter("AccountMasterId", accountmasterID);
var results = new MFISDBContext()
.MultipleResults(CustomProcNames.uspGeneralPaymentsViewGetById, prmAccountMasterId)
.With <GeneralPaymentsDto>()
.With <AddAmountDto>()
.Execute();
var generalPaymentsDto = (results[0] as List <GeneralPaymentsDto>)[0];
var addAmountDtoList = results[1] as List <AddAmountDto>;
generalPaymentsDto.Addamount = addAmountDtoList;
return(generalPaymentsDto);
}
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 = (results[0] as List <GeneralReceiptDto>)[0];
var addAmountDtoList = results[1] as List <AddAmountDto>;
generalPaymentsDto.Addamount = addAmountDtoList;
return(generalPaymentsDto);
}
public ContraEntryDepositedDto GroupContraEntryDepositedGetByAccountMasterId(long AccountMasterId)
{
long accountmasterID = Convert.ToInt64(AccountMasterId);
ObjectParameter prmAccountMasterId = new ObjectParameter("AccountMasterId", accountmasterID);
var results = new MFISDBContext()
.MultipleResults(CustomProcNames.uspGroupContraEntryWithDrawlByAccountMasterID, prmAccountMasterId)
.With <ContraEntryDepositedDto>()
.With <ContraEntryDepositedTransactionsDto>()
.Execute();
var contraEntryDepositedDto = (results[0] as List <ContraEntryDepositedDto>)[0];
var contraEntryDepositedTransactionsList = results[1] as List <ContraEntryDepositedTransactionsDto>;
List <ContraEntryDepositedTransactionsDto> finalcontraEntryDepositedTransactions = new List <ContraEntryDepositedTransactionsDto>();
ContraEntryDepositedTransactionsDto singleContraEntryDepositedTransactionsDto = null;
foreach (var contraEntryDepositedTransactions in contraEntryDepositedTransactionsList)
{
singleContraEntryDepositedTransactionsDto = new ContraEntryDepositedTransactionsDto();
singleContraEntryDepositedTransactionsDto.BankAccount = contraEntryDepositedTransactions.BankAccount;
singleContraEntryDepositedTransactionsDto.BankAccountName = contraEntryDepositedTransactions.BankAccountName;
singleContraEntryDepositedTransactionsDto.AccountTranID = contraEntryDepositedTransactions.AccountTranID;
singleContraEntryDepositedTransactionsDto.AHCode = contraEntryDepositedTransactions.AHCode;
singleContraEntryDepositedTransactionsDto.AHID = contraEntryDepositedTransactions.AHID;
singleContraEntryDepositedTransactionsDto.AHName = contraEntryDepositedTransactions.AHName;
singleContraEntryDepositedTransactionsDto.AmountId = contraEntryDepositedTransactions.AmountId;
singleContraEntryDepositedTransactionsDto.ClosingBalance = contraEntryDepositedTransactions.ClosingBalance;
singleContraEntryDepositedTransactionsDto.CrAmount = contraEntryDepositedTransactions.CrAmount;
singleContraEntryDepositedTransactionsDto.DrAmount = contraEntryDepositedTransactions.DrAmount;
singleContraEntryDepositedTransactionsDto.Type = contraEntryDepositedTransactions.Type;
singleContraEntryDepositedTransactionsDto.Narration = contraEntryDepositedTransactions.Narration;
finalcontraEntryDepositedTransactions.Add(singleContraEntryDepositedTransactionsDto);
singleContraEntryDepositedTransactionsDto.IsMaster = contraEntryDepositedTransactions.IsMaster;
}
contraEntryDepositedDto.contraEntryDepositedTransactions = finalcontraEntryDepositedTransactions;
return(contraEntryDepositedDto);
}
public OrganizationService()
{
_dbContext = new MFISDBContext();
AutoMapperEntityConfiguration.Configure();
}
public GroupGeneralReceiptService()
{
_dbContext = new MFISDBContext();
AutoMapperEntityConfiguration.Configure();
_commonService = new CommonService();
}
public BalanceSheetController()
{
_dbContext = new MFISDBContext();
}
public ContraEntryService()
{
_dbContext = new MFISDBContext();
AutoMapperEntityConfiguration.Configure();
}
public FundSourceService()
{
_dbContext = new MFISDBContext();
AutoMapperEntityConfiguration.Configure();
}
public GroupMemberReceiptService()
{
_groupMemberReceiptDal = new GroupMemberReceiptDal();
_groupMemberReceiptDto = new GroupMemberReceiptDto();
_dbContext = new MFISDBContext();
}
public IncomeAndExpenditureController()
{
_dbContext = new MFISDBContext();
}
public LoanSecurityMasterService()
{
_dbContext = new MFISDBContext();
_commonService = new CommonService();
AutoMapperEntityConfiguration.Configure();
}
public DistrictService()
{
_dbContext = new MFISDBContext();
AutoMapperEntityConfiguration.Configure();
}
public FederationGeneralPaymentsService()
{
_dbContext = new MFISDBContext();
AutoMapperEntityConfiguration.Configure();
_commonService = new CommonService();
}
public EmployeeService()
{
_dbContext = new MFISDBContext();
AutoMapperEntityConfiguration.Configure();
}
