public static List <FuneralPaymentsModel> ReturnMemberPayment(string intMemberID)
{
DataTable dr = MemberPaymetsDAL.ReturnMemberPaymentdt(intMemberID);
return(FuneralHelper.DataTableMapToList <FuneralPaymentsModel>(dr));
}
public static ApplicationSettingsModel GetAllApplicationList2(Guid parlourid, int param, int AppID)
{
SqlDataReader dr = ToolsSetingDAL.GetAllApplicationList(parlourid, param, AppID);
return(FuneralHelper.DataReaderMapToList <ApplicationSettingsModel>(dr).FirstOrDefault());
}
public static ApplicationSettingsModel GetApplictionByID(int ID)
{
SqlDataReader dr = ToolsSetingDAL.GetApplictionByID(ID);
return(FuneralHelper.DataReaderMapToList <ApplicationSettingsModel>(dr).FirstOrDefault());
}
public static smsTempletModel GetEmailTemplateByID(int ID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetEmailTemplateByID(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <smsTempletModel>(dr).FirstOrDefault());
}
public static List <FuneralServiceManageModel> SelectFuneralManageServiceByParlID(Guid ParlourId, int PageSize, int PageNum, string Keyword, string SortBy, string SortOrder)
{
SqlDataReader dr = ToolsSetingDAL.SelectFuneralManageServiceByParlID(ParlourId, PageSize, PageNum, Keyword, SortBy, SortOrder);
return(FuneralHelper.DataReaderMapToList <FuneralServiceManageModel>(dr));
}
public static PlanModel GetPlanByID(string ID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetPlanByID(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <PlanModel>(dr).FirstOrDefault());
}
public static List <smsTempletModel> GetTemplateList(Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetTemplateList(ParlourId);
return(FuneralHelper.DataReaderMapToList <smsTempletModel>(dr));
}
public static List <SecureGroupModel> GetSecureGrouList()
{
SqlDataReader dr = ToolsSetingDAL.GetSecureGrouList();
return(FuneralHelper.DataReaderMapToList <SecureGroupModel>(dr));
}
public static List <SecureUserGroupsModel> EditSecurUserbyID(int ID)
{
SqlDataReader dr = ToolsSetingDAL.EditSecurUserbyID(ID);
return(FuneralHelper.DataReaderMapToList <SecureUserGroupsModel>(dr));
}
public static List <smsSendingGroupModel> EditsmsGroupbyID(int ID)
{
SqlDataReader dr = ToolsSetingDAL.EditsmsGroupbyID(ID);
return(FuneralHelper.DataReaderMapToList <smsSendingGroupModel>(dr));
}
public static smsSendingGroupModel GetsmsGroupbyID(int ID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetsmsGroupbyID(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <smsSendingGroupModel>(dr).FirstOrDefault());
}
public static OtherPaymentModel OtherPaymentSelect(int InvoiceId, Guid Parlourid)
{
SqlDataReader dr = OtherPaymentDAl.OtherPaymentSelect(InvoiceId, Parlourid);
return(FuneralHelper.DataReaderMapToList <OtherPaymentModel>(dr)[0]);
}
public static List <OtherPaymentModel> OtherPaymentSelectByMemberId(int MemberId, Guid Parlourid)
{
SqlDataReader dr = OtherPaymentDAl.OtherPaymentSelectByMemberId(MemberId, Parlourid);
return(FuneralHelper.DataReaderMapToList <OtherPaymentModel>(dr).ToList());
}
public static JoiningFeeModel JoiningFees(int memberId, Guid parlourId)
{
DataTable dr = MemberPaymetsDAL.JoiningFeesdt(memberId, parlourId);
return(FuneralHelper.DataTableMapToList <JoiningFeeModel>(dr).FirstOrDefault());
}
public static AddonProductsModal EditAddonProductbyID(Guid ID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.EditAddonProductbyID(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <AddonProductsModal>(dr).FirstOrDefault());
}
public static BranchModel EditBranchbyID(Guid ID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.EditBranchbyID(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <BranchModel>(dr).FirstOrDefault());
}
public static List <PlanModel> GetAllPlans(Guid ParlourId, int PageSize, int PageNum, string Keyword, string SortBy, string SortOrder)
{
SqlDataReader dr = ToolsSetingDAL.GetAllPlans(ParlourId, PageSize, PageNum, Keyword, SortBy, SortOrder);
return(FuneralHelper.DataReaderMapToList <PlanModel>(dr));
}
public static List <SocietyModel> GetAllSocietye(Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetAllSocietye(ParlourId);
return(FuneralHelper.DataReaderMapToList <SocietyModel>(dr));
}
public static List <MembersModel> GetAllMemberCellphon(Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetAllMemberCellphon(ParlourId);
return(FuneralHelper.DataReaderMapToList <MembersModel>(dr));
}
public static AdditionalApplicationSettingsModel SaveAdditionalApplication(AdditionalApplicationSettingsModel model)
{
SqlDataReader dr = ToolsSetingDAL.SaveAdditionalApplication(model);
return(FuneralHelper.DataReaderMapToList <AdditionalApplicationSettingsModel>(dr).FirstOrDefault());
}
public static BankingDetailSending SaveBankingDetail(BankingDetailSending Model)
{
SqlDataReader dr = ToolsSetingDAL.SaveBankingDetail(Model);
return(FuneralHelper.DataReaderMapToList <BankingDetailSending>(dr).FirstOrDefault());
}
public static List <ExpensesModel> GetAllExpenseses(Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetAllExpenseses(ParlourId);
return(FuneralHelper.DataReaderMapToList <ExpensesModel>(dr));
}
public static ApplicationTnCModel SelectApplicationTermsAndCondition(Guid parlourid)
{
SqlDataReader dr = ToolsSetingDAL.SelectApplicationTermsAndCondition(parlourid);
return(FuneralHelper.DataReaderMapToList <ApplicationTnCModel>(dr).FirstOrDefault());
}
public static ExpensesModel EditExpensesbyID(int ID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.EditExpensesbyID(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <ExpensesModel>(dr).FirstOrDefault());
}
public static FuneralServiceManageModel SelectFuneralManageServiceByParlANdID(int pkiServiceID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.SelectFuneralManageServiceByParlANdID(pkiServiceID, ParlourId);
return(FuneralHelper.DataReaderMapToList <FuneralServiceManageModel>(dr).FirstOrDefault());
}
public static AgentInfoSetupModel SaveAgentInfo(AgentInfoSetupModel model)
{
SqlDataReader dr = ToolsSetingDAL.SaveAgentInfo(model);
return(FuneralHelper.DataReaderMapToList <AgentInfoSetupModel>(dr).FirstOrDefault());
}
public static List <SecureUserGroupsModel> GetSuperUserAccessByID(int ID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetSuperUserAccessByID(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <SecureUserGroupsModel>(dr));
}
public static List <AddonProductsModal> GetAllAddonProductes(Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetAllAddonProductes(ParlourId);
return(FuneralHelper.DataReaderMapToList <AddonProductsModal>(dr));
}
public static BankingDetailSending GetBankingByID(Guid ID)
{
SqlDataReader dr = ToolsSetingDAL.GetBankingByID(ID);
return(FuneralHelper.DataReaderMapToList <BankingDetailSending>(dr).FirstOrDefault());
}
public static List <FuneralPaymentsModel> ReturnFuneralPayments(Guid parlourid, string pIntFnrlID)
{
DataTable dr = MemberPaymetsDAL.ReturnFuneralPaymentsdt(parlourid, pIntFnrlID);
return(FuneralHelper.DataTableMapToList <FuneralPaymentsModel>(dr));
}