public static List <SecureUsersModel> GetAllUsers(Guid ParlourId, int PageSize, int PageNum, string Keyword, string SortBy, string SortOrder)
{
SqlDataReader dr = ToolsSetingDAL.GetAllUsers(ParlourId, PageSize, PageNum, Keyword, SortBy, SortOrder);
//MembersViewModel objViewModel = new MembersViewModel();
return(FuneralHelper.DataReaderMapToList <SecureUsersModel>(dr));
//dr.NextResult();
//dr.Read();
//objViewModel.TotalRecord = Convert.ToInt64(dr["TotalRecord"]);
//return objViewModel;
}
public static int DeleteExpenses(int ID)
{
return(ToolsSetingDAL.DeleteExpenses(ID));
}
public static List <AgentInfoSetupModel> GetAllAgentInfo(Guid ParlourId, int PageSize, int PageNum, string Keyword, string SortBy, string SortOrder)
{
SqlDataReader dr = ToolsSetingDAL.GetAllAgentInfo(ParlourId, PageSize, PageNum, Keyword, SortBy, SortOrder);
return(FuneralHelper.DataReaderMapToList <AgentInfoSetupModel>(dr));
}
public static SecureUserGroupsModel GetUserAccessByID(int ID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetUserAccessByID(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <SecureUserGroupsModel>(dr).FirstOrDefault());
}
public static BankingDetailSending GetBankingByID(Guid ID)
{
SqlDataReader dr = ToolsSetingDAL.GetBankingByID(ID);
return(FuneralHelper.DataReaderMapToList <BankingDetailSending>(dr).FirstOrDefault());
}
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 FuneralServiceManageModel SelectFuneralManageServiceByParlANdID(int pkiServiceID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.SelectFuneralManageServiceByParlANdID(pkiServiceID, ParlourId);
return(FuneralHelper.DataReaderMapToList <FuneralServiceManageModel>(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 int SavePlanDetails(PlanModel model)
{
return(ToolsSetingDAL.SavePlanDetails(model));
}
public static PlanModel GetPlanByID(string ID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetPlanByID(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <PlanModel>(dr).FirstOrDefault());
}
public static int DeleteAddonProduct(Guid ID)
{
return(ToolsSetingDAL.DeleteAddonProduct(ID));
}
public static AddonProductsModal EditAddonProductbyID(Guid ID, Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.EditAddonProductbyID(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <AddonProductsModal>(dr).FirstOrDefault());
}
public static List <AddonProductsModal> GetAllAddonProductes(Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetAllAddonProductes(ParlourId);
return(FuneralHelper.DataReaderMapToList <AddonProductsModal>(dr));
}
public static Guid SaveAddonProductDetails(AddonProductsModal model)
{
return(ToolsSetingDAL.SaveAddonProductDetails(model));
}
public static AgentInfoSetupModel SaveAgentInfo(AgentInfoSetupModel model)
{
SqlDataReader dr = ToolsSetingDAL.SaveAgentInfo(model);
return(FuneralHelper.DataReaderMapToList <AgentInfoSetupModel>(dr).FirstOrDefault());
}
public static ApplicationTnCModel SelectApplicationTermsAndCondition(Guid parlourid)
{
SqlDataReader dr = ToolsSetingDAL.SelectApplicationTermsAndCondition(parlourid);
return(FuneralHelper.DataReaderMapToList <ApplicationTnCModel>(dr).FirstOrDefault());
}
public static int UpdateAutoPolicyNo(ApplicationSettingsModel Model1)
{
return(ToolsSetingDAL.UpdateAutoPolicyNo(Model1));
}
public static int DeletePlan(int ID)
{
return(ToolsSetingDAL.DeletePlan(ID));
}
public static int SaveFuneralManageService(FuneralServiceManageModel Model1)
{
return(ToolsSetingDAL.SaveFuneralManageService(Model1));
}
public static List <MembersModel> GetAllMemberCellphon(Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetAllMemberCellphon(ParlourId);
return(FuneralHelper.DataReaderMapToList <MembersModel>(dr));
}
public static int DeleteFuneralManageServiceById(int pkiServiceID)
{
return(ToolsSetingDAL.DeleteFuneralManageServiceById(pkiServiceID));
}
public static List <smsTempletModel> GetTemplateList(Guid ParlourId)
{
SqlDataReader dr = ToolsSetingDAL.GetTemplateList(ParlourId);
return(FuneralHelper.DataReaderMapToList <smsTempletModel>(dr));
}
public static ApplicationSettingsModel GetApplictionByID(int ID)
{
SqlDataReader dr = ToolsSetingDAL.GetApplictionByID(ID);
return(FuneralHelper.DataReaderMapToList <ApplicationSettingsModel>(dr).FirstOrDefault());
}
public static BankingDetailSending SaveBankingDetail(BankingDetailSending Model)
{
SqlDataReader dr = ToolsSetingDAL.SaveBankingDetail(Model);
return(FuneralHelper.DataReaderMapToList <BankingDetailSending>(dr).FirstOrDefault());
}
public static AgentInfoSetupModel GetAgentByID(int ID)
{
SqlDataReader dr = ToolsSetingDAL.GetAgentByID(ID);
return(FuneralHelper.DataReaderMapToList <AgentInfoSetupModel>(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 <ApplicationSettingsModel> GetAllCompanys(Guid ParlourId, int PageSize, int PageNum, string Keyword, string SortBy, string SortOrder)
{
SqlDataReader dr = ToolsSetingDAL.GetAllCompanys(ParlourId, PageSize, PageNum, Keyword, SortBy, SortOrder);
return(FuneralHelper.DataReaderMapToList <ApplicationSettingsModel>(dr));
}
public static int UpdatesmsTemplate(smsTempletModel model)
{
return(ToolsSetingDAL.UpdatesmsTemplate(model));
}
public static int DeleteCompany(int ID)
{
return(ToolsSetingDAL.DeleteCompany(ID));
}
public static int SaveTermsAndCondition(ApplicationTnCModel Model1)
{
return(ToolsSetingDAL.SaveTermsAndCondition(Model1));
}
