public static List <MemberAddonProductsModel> SelectMembarAddonProductBypkiMemberProductID(Guid PkInoteID)
{
// return MembersDAL.SelectMembarAddonProductBypkiMemberProductID(PkInoteID);
DataTable dr = MembersDAL.SelectMembarAddonProductBypkiMemberProductIDdt(PkInoteID);
return(FuneralHelper.DataTableMapToList <MemberAddonProductsModel>(dr));
}
public static MembersModel GetMemberByID(int ID, Guid ParlourId)
{
//SqlDataReader dr = MembersDAL.GetMemberByID(ID, ParlourId);
//return FuneralHelper.DataReaderMapToList<MembersModel>(dr).FirstOrDefault();
DataTable dr = MembersDAL.GetMemberByIDdt(ID, ParlourId);
return(FuneralHelper.DataTableMapToList <MembersModel>(dr).FirstOrDefault());
}
public static MembersViewModel GetAllDebitOrderMembers(Guid ParlourId, int PageSize, int PageNum, string Keyword, string SortBy, string SortOrder)
{
DataSet ds = MembersDAL.GetAllDebitMembersdt(ParlourId, PageSize, PageNum, Keyword, SortBy, SortOrder);
DataTable dr = ds.Tables[0];
MembersViewModel objViewModel = new MembersViewModel();
objViewModel.MemberList = FuneralHelper.DataTableMapToList <MembersModel>(dr, true);
objViewModel.TotalRecord = Convert.ToInt64(ds.Tables[1].Rows[0]["TotalRecord"].ToString());
return(objViewModel);
}
public static MembersPaymentViewModel GetAllPayentMembers(Guid ParlourId, string PolicyNo, string IDNumber, int PageSize, int PageNum, string SortBy, string SortOrder)
{
DataSet ds = MemberPaymetsDAL.GetAllPayentMembersdt(ParlourId, PolicyNo, IDNumber, PageSize, PageNum, SortBy, SortOrder);
DataTable dr = ds.Tables[0];
MembersPaymentViewModel objViewModel = new MembersPaymentViewModel();
objViewModel.MemberList = FuneralHelper.DataTableMapToList <MembersPaymentModel>(dr, true);
objViewModel.TotalRecord = Convert.ToInt64(ds.Tables[1].Rows[0]["TotalRecord"].ToString());
return(objViewModel);
}
public static VehiclesModel SelectVehicleByVehicleId(int pkiVehicleID)
{
return(FuneralHelper.DataTableMapToList <VehiclesModel>(MembersDAL.SelectVehicleByVehicleIddt(pkiVehicleID)).FirstOrDefault());
}
public static List <RelationShipModel> SelectRelationship()
{
return(FuneralHelper.DataTableMapToList <RelationShipModel>(MembersDAL.SelectRelationshipdt()));
}
public static FamilyDependencyModel SelectFamilyDependencyById(int pkiDependentID)
{
return(FuneralHelper.DataTableMapToList <FamilyDependencyModel>(MembersDAL.SelectFamilyDependencyByIddt(pkiDependentID)).FirstOrDefault());
}
public static MembersPaymentDetailsModel GetMemberPaymnetDetailsByID(int ID)
{
DataTable dr = MemberPaymetsDAL.GetMemberPaymnetDetailsByIDdt(ID);
return(FuneralHelper.DataTableMapToList <MembersPaymentDetailsModel>(dr).FirstOrDefault());
}
public static List <FamilyDependencyTypeModel> GetAllFamilyDependencyTypes()
{
return(FuneralHelper.DataTableMapToList <FamilyDependencyTypeModel>(MembersDAL.GetFamilyDependencyTypesdt()));
}
public static List <PolicyPremiumDashboardModel> SelectPolicyPremiumByParlourId(Guid ParlourId, int PageSize, int PageNum, string Keyword, string SortBy, string SortOrder, bool isAdmin, bool isSuperUser, string UserName)
{
DataTable dr = MembersDAL.SelectPolicyPremiumByParlourIddt(ParlourId, PageSize, PageNum, Keyword, SortBy, SortOrder, isAdmin, isSuperUser, UserName);
return(FuneralHelper.DataTableMapToList <PolicyPremiumDashboardModel>(dr));
}
public static JoiningFeeModel JoiningFees(int memberId, Guid parlourId)
{
DataTable dr = MemberPaymetsDAL.JoiningFeesdt(memberId, parlourId);
return(FuneralHelper.DataTableMapToList <JoiningFeeModel>(dr).FirstOrDefault());
}
public static List <AddonProductsModal> MemberListBindAddonProduct(Guid pkiProductID)
{
DataTable dr = MembersDAL.MemberListBinddt(pkiProductID);
return(FuneralHelper.DataTableMapToList <AddonProductsModal>(dr));
}
public static List <FuneralPaymentsModel> ReturnFuneralPayments(Guid parlourid, string pIntFnrlID)
{
DataTable dr = MemberPaymetsDAL.ReturnFuneralPaymentsdt(parlourid, pIntFnrlID);
return(FuneralHelper.DataTableMapToList <FuneralPaymentsModel>(dr));
}
//public static List<SupportedDocument> SelectSupportDocumentsByMemberId(int MemberId)
//{s
// return FuneralHelper.DataReaderMapToList<SupportedDocument>(MembersDAL.SelectSupportDocumentsByMemberId(MemberId));
//}
//public static int SaveSupportDocument(SupportedDocument model)
//{
// return MembersDAL.SaveSupportDocument(model);
//}
//product
public static List <AddonProductsModal> SelectProductName(Guid Parlourid)
{
DataTable dr = MembersDAL.selectProductNamedt(Parlourid);
return(FuneralHelper.DataTableMapToList <AddonProductsModal>(dr));
}
public static List <MemberAddonProductsModel> SelectMemberAddonProducts(int fkiMemberid)
{
DataTable dr = MembersDAL.GetAddonProductsdt(fkiMemberid);
return(FuneralHelper.DataTableMapToList <MemberAddonProductsModel>(dr));
}
public static List <MemberNotesModel> GetMemberNoteByMemberID(int MemberId)
{
DataTable dr = MembersDAL.MemberNotesByMemberIDdt(MemberId);
return(FuneralHelper.DataTableMapToList <MemberNotesModel>(dr));
}
public static List <MemberInvoiceModel> GetInvoicesByMemberID(Guid parlourid, int MemberId)
{
DataTable dr = MembersDAL.GetInvoicesByMemberIDdt(parlourid, MemberId);
return(FuneralHelper.DataTableMapToList <MemberInvoiceModel>(dr));
}
//public static List<FamilyDependencyModel> GetFamilyDependencyByMemberID(Guid parlourid, int MemberId)
//{
// SqlDataReader dr = MembersDAL.GetFamilyDependencyByMemberID(parlourid, MemberId);
// return FuneralHelper.DataReaderMapToList<FamilyDependencyModel>(dr);
//}
public static List <VehiclesModel> GetVehicleByMemberID(int fkiMemberId)
{
DataTable dr = MembersDAL.GetVehicleByMemberIDdt(fkiMemberId);
return(FuneralHelper.DataTableMapToList <VehiclesModel>(dr));
}
public static List <AgentModel> SelectAllAgent(Guid ParlourId)
{
DataTable dr = MembersDAL.SelectAllAgentdt(ParlourId);
return(FuneralHelper.DataTableMapToList <AgentModel>(dr));
}
public static FamilyDependencyModel GetDependencByIDNum(string ID, Guid ParlourId, int MemberID)
{
DataTable dr = MembersDAL.GetDependencByIDNumdt(ID, ParlourId, MemberID);
return(FuneralHelper.DataTableMapToList <FamilyDependencyModel>(dr).FirstOrDefault());
}
public static NewMemberInvoiceModel GetInvoiceByid(int InvoiceId)
{
DataTable dr = MembersDAL.GetInvoiceByiddt(InvoiceId);
return(FuneralHelper.DataTableMapToList <NewMemberInvoiceModel>(dr).FirstOrDefault());
}
public static MembersPaymentDetailsModel ReturnMemberPlanDetailsWithBalance(string strMemberNo)
{
DataTable dr = MemberPaymetsDAL.ReturnMemberPlanDetailsWithBalancedt(strMemberNo);
return(FuneralHelper.DataTableMapToList <MembersPaymentDetailsModel>(dr).FirstOrDefault());
}
public static List <StatusModel> GetStatus(string associatedTable)
{
DataTable dr = MembersDAL.GetStatus(associatedTable);
return(FuneralHelper.DataTableMapToList <StatusModel>(dr));
}
public static List <FuneralPaymentsModel> ReturnMemberPayment(string intMemberID)
{
DataTable dr = MemberPaymetsDAL.ReturnMemberPaymentdt(intMemberID);
return(FuneralHelper.DataTableMapToList <FuneralPaymentsModel>(dr));
}
public static MembersModel GetMemberByIDNum(string ID, Guid ParlourId)
{
DataTable dr = MembersDAL.GetMemberByIDNumdt(ID, ParlourId);
return(FuneralHelper.DataTableMapToList <MembersModel>(dr).FirstOrDefault());
}
/// <summary>
/// SupportedDocumentModel
/// </summary>
/// <param name="MemberId"></param>
/// <returns></returns>
public static List <SupportedDocumentModel> SelectSupportDocumentsByMemberId(int MemberId)
{
return(FuneralHelper.DataTableMapToList <SupportedDocumentModel>(MembersDAL.SelectSupportDocumentsByMemberIddt(MemberId)));
}
public static VehiclesModel GetVehicleByVinNo(string VinNo, Guid ParlourId, int MemberID)
{
DataTable dr = MembersDAL.GetVehicleByVinNodt(VinNo, ParlourId, MemberID);
return(FuneralHelper.DataTableMapToList <VehiclesModel>(dr).FirstOrDefault());
}
public static SupportedDocumentModel SelectSupportDocumentsById(int DocumentId)
{
return(FuneralHelper.DataTableMapToList <SupportedDocumentModel>(MembersDAL.SelectSupportDocumentsByIddt(DocumentId)).FirstOrDefault());
}
public static List <string> GetDistinctPolicyStatusList()
{
DataTable dr = MembersDAL.GetDistinctPolicyStatusListdt();
return(FuneralHelper.DataTableMapToList <string>(dr));
}
public static List <CountryModel> GetCountry()
{
DataTable dr = MembersDAL.GetCountrydt();
return(FuneralHelper.DataTableMapToList <CountryModel>(dr));
}