public static CustomDetails GetCustomDetails(int Id, Guid ParlourId, int CustomType)
{
SqlDataReader dr = CustomDetailsDAL.GetCustomDetails(Id, ParlourId, CustomType);
var model = FuneralHelper.DataReaderMapToList <CustomDetails>(dr).FirstOrDefault();
model.CustomType = (CustomDetailsEnums.CustomDetailsType)CustomType;
return(model);
}
public static List <CustomDetails> GetAllCustomDetailsByParlourId(Guid ParlourId, int CustomType)
{
SqlDataReader dr = CustomDetailsDAL.GetAllCustomDetailsByParlourId(ParlourId, CustomType);
List <CustomDetails> model = FuneralHelper.DataReaderMapToList <CustomDetails>(dr);
foreach (var item in model)
{
item.CustomType = (CustomDetailsEnums.CustomDetailsType)CustomType;
}
return(model);
}
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;
}
/// <summary>
/// Do Admin Login
/// </summary>
/// <param name="Email"></param>
/// <param name="Password"></param>
/// <returns></returns>
public static AdminModel AdminLogin(string Email, string Password)
{
SqlDataReader dr = Funeral.DAL.AdminDAL.AdminLogin(Email, Password);
return(FuneralHelper.DataReaderMapToList <AdminModel>(dr).FirstOrDefault());
//if (dr != null && dr.HasRows)
//{
// return MakeObject(dr);
//}
//else
// return null;
}
public static ClaimsViewModel SelectAllClaimsBySearch(Guid ParlourId, int PageSize, int PageNum, string Keyword, string SortBy, string SortOrder, bool ClaimingForMember, bool ApplyWaitingPeriod)
{
SqlDataReader dr = ClaimsDAL.SelectAllClaimsBySearch(ParlourId, PageSize, PageNum, Keyword, SortBy, SortOrder, ClaimingForMember, ApplyWaitingPeriod);
ClaimsViewModel objViewModel = new ClaimsViewModel();
objViewModel.ClaimsList = FuneralHelper.DataReaderMapToList <ClaimsModel>(dr, true);
dr.NextResult();
dr.Read();
objViewModel.TotalRecord = Convert.ToInt64(dr["TotalRecord"]);
dr.Close();
dr.Dispose();
return(objViewModel);
}
public static MembersModel selectMemberByPkidAndParlor(Guid ParlourId, int MemId)
{
SqlDataReader dr = ClaimsDAL.selectMemberByPkidAndParlor(ParlourId, MemId);
return(FuneralHelper.DataReaderMapToList <MembersModel>(dr).FirstOrDefault());
}
public static ClaimsModel SelectClaimsBypkid(int ID, Guid ParlourId)
{
SqlDataReader dr = ClaimsDAL.SelectClaimsBypkid(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <ClaimsModel>(dr).FirstOrDefault());
}
public static ClaimDocumentModel SelectClaimsDocumentsByPKId(int DocumentId)
{
return(FuneralHelper.DataReaderMapToList <ClaimDocumentModel>(ClaimsDAL.SelectClaimsDocumentsByPKId(DocumentId)).FirstOrDefault());
}
public static List <PolicyModel> GetPlanSubscriptionByPlanId(int pkiPlanID)
{
SqlDataReader dr = MembersDAL.GetPlanSubscriptionByPlanId(pkiPlanID);
return(FuneralHelper.DataReaderMapToList <PolicyModel>(dr));
}
public static List <BranchModel> GetAllBranch(Guid Parlourid)
{
SqlDataReader dr = MembersDAL.GetAllBranch(Parlourid);
return(FuneralHelper.DataReaderMapToList <BranchModel>(dr));
}
public static List <TombstonePackageModel> SelectAllPackage(Guid ParlourId)
{
SqlDataReader dr = TombstonePackageDAL.SelectAllPackage(ParlourId);
return(FuneralHelper.DataReaderMapToList <TombstonePackageModel>(dr));
}
public static List <tblPageModel> LoadSideMenu(Guid ParlourId, int UserId)
{
SqlDataReader dr = RightsDAL.LoadSideMenu(ParlourId, UserId);
return(FuneralHelper.DataReaderMapToList <tblPageModel>(dr).ToList());
}
public static List <tblPageModel> GetAllActiveTblPages()
{
SqlDataReader dr = RightsDAL.GetAllActiveTblPages();
return(FuneralHelper.DataReaderMapToList <tblPageModel>(dr).ToList());
}
public static List <NewRightsModel> GetRightsByGroupId(Guid ParlourId, int GroupId)
{
SqlDataReader dr = RightsDAL.GetRightsByGroupId(ParlourId, GroupId);
return(FuneralHelper.DataReaderMapToList <NewRightsModel>(dr).ToList());
}
public static RightsModel SelecttblRightById(int ID)
{
SqlDataReader dr = RightsDAL.SelecttblRightById(ID);
return(FuneralHelper.DataReaderMapToList <RightsModel>(dr).FirstOrDefault());
}
public static List <PolicyModel> GetPolicyByParlourId(Guid parlourid)
{
SqlDataReader dr = MembersDAL.GetPolicyByParlourId(parlourid);
return(FuneralHelper.DataReaderMapToList <PolicyModel>(dr));
}
public static List <SocietyModel> GetAllSociety(Guid parlourid)
{
SqlDataReader dr = MembersDAL.GetAllSociety(parlourid);
return(FuneralHelper.DataReaderMapToList <SocietyModel>(dr));
}
public static List <TombstonePackageModel> SelectPackageServiceByPackgeId(Guid ParlourId, int PackgeId)
{
SqlDataReader dr = TombstonePackageDAL.SelectPackageServiceByPackgeId(ParlourId, PackgeId);
return(FuneralHelper.DataReaderMapToList <TombstonePackageModel>(dr));
}
public static List <PlanModel> GetAllPlanName(Guid ParlourId)
{
SqlDataReader dr = MembersDAL.GetAllPlanName(ParlourId);
return(FuneralHelper.DataReaderMapToList <PlanModel>(dr));
}
public static TombStonesPaymentModel TombStonesPaymentSelect(Guid parlourid, int invoiceId)
{
SqlDataReader dr = TombStonesPaymentDAL.TombStonesPaymentSelect(parlourid, invoiceId);
return(FuneralHelper.DataReaderMapToList <TombStonesPaymentModel>(dr).FirstOrDefault());
}
public static List <ClaimDocumentModel> SelectClaimDocumentsByClaimId(int fkiClaimID)
{
SqlDataReader dr = ClaimsDAL.SelectClaimDocumentsByClaimId(fkiClaimID);
return(FuneralHelper.DataReaderMapToList <ClaimDocumentModel>(dr));
}
public static List <TombStonesPaymentModel> TombStonesPaymentSelectByTombstoneID(Guid parlourid, int tombstoneId)
{
SqlDataReader dr = TombStonesPaymentDAL.TombStonesPaymentSelectByTombstoneID(parlourid, tombstoneId);
return(FuneralHelper.DataReaderMapToList <TombStonesPaymentModel>(dr));
}
public static List <ClaimsModel> SelectAllClaimsByParlourId(Guid ParlourId, int PageSize, int PageNum, string Keyword, string SortBy, string SortOrder, DateTime DateFrom, DateTime DateTo)
{
SqlDataReader dr = ClaimsDAL.SelectAllClaimsByParlourId(ParlourId, PageSize, PageNum, Keyword, SortBy, SortOrder, DateFrom, DateTo);
return(FuneralHelper.DataReaderMapToList <ClaimsModel>(dr));
}
public static List <UnderwriterModel> SelectAllUnderwriterByParlourId(Guid ParlourId, int PageSize, int PageNum, string Keyword, string SortBy, string SortOrder)
{
SqlDataReader dr = UnderwriterDAL.SelectAllUnderwriterByParlourId(ParlourId, PageSize, PageNum, Keyword, SortBy, SortOrder);
return(FuneralHelper.DataReaderMapToList <UnderwriterModel>(dr));
}
public static List <ClaimsModel> GetClaimsbyMemeberNumber(int MemeberNo)
{
SqlDataReader dr = ClaimsDAL.GetClaimsbyMemeberNumber(MemeberNo);
return(FuneralHelper.DataReaderMapToList <ClaimsModel>(dr));
}
public static UnderwriterModel SelectUnderwriterBypkid(int ID, Guid ParlourId)
{
SqlDataReader dr = UnderwriterDAL.SelectUnderwriterBypkid(ID, ParlourId);
return(FuneralHelper.DataReaderMapToList <UnderwriterModel>(dr).FirstOrDefault());
}
public static List <FamilyDependencyModel> SelectMembersAndDependencies2(Guid ParlourId, bool MainMem, string Keyword)
{
SqlDataReader dr = ClaimsDAL.SelectMembersAndDependencies(ParlourId, MainMem, Keyword);
return(FuneralHelper.DataReaderMapToList <FamilyDependencyModel>(dr));
}
public static UnderwriterModel SelectUnderwriterByName(string UnderwriterName, Guid ParlourId)
{
SqlDataReader dr = UnderwriterDAL.SelectUnderwriterByName(UnderwriterName, ParlourId);
return(FuneralHelper.DataReaderMapToList <UnderwriterModel>(dr).FirstOrDefault());
}
public static PlanModel GetPlanDetailsByPlanId(int planid)
{
SqlDataReader dr = ClaimsDAL.GetPlanDetailsByPlanId(planid);
return(FuneralHelper.DataReaderMapToList <PlanModel>(dr).FirstOrDefault());
}
public static List <UnderwriterModel> SelectUnderwriterNotDeleted()
{
SqlDataReader dr = UnderwriterDAL.SelectUnderwriterNotDeleted();
return(FuneralHelper.DataReaderMapToList <UnderwriterModel>(dr));
}
