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 int UpdateMemberNumber(int ID, string MemberNumber, string Claimnumber) { return(ClaimsDAL.UpdateMemberNumber(ID, MemberNumber, Claimnumber)); }
public static PlanModel GetPlanDetailsByPlanId(int planid) { SqlDataReader dr = ClaimsDAL.GetPlanDetailsByPlanId(planid); return(FuneralHelper.DataReaderMapToList <PlanModel>(dr).FirstOrDefault()); }
public static MembersModel selectMemberByPkidAndParlor(Guid ParlourId, int MemId) { SqlDataReader dr = ClaimsDAL.selectMemberByPkidAndParlor(ParlourId, MemId); return(FuneralHelper.DataReaderMapToList <MembersModel>(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 int SaveClaimSupportedDocument(ClaimDocumentModel model) { return(ClaimsDAL.SaveClaimSupportedDocument(model)); }
public static ClaimsModel SelectClaimsBypkid(int ID, Guid ParlourId) { SqlDataReader dr = ClaimsDAL.SelectClaimsBypkid(ID, ParlourId); return(FuneralHelper.DataReaderMapToList <ClaimsModel>(dr).FirstOrDefault()); }
public static List <ClaimsModel> GetClaimsbyMemeberNumber(int MemeberNo) { SqlDataReader dr = ClaimsDAL.GetClaimsbyMemeberNumber(MemeberNo); return(FuneralHelper.DataReaderMapToList <ClaimsModel>(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 int ClaimsDelete(int ID, string UserName) { return(ClaimsDAL.ClaimsDelete(ID, UserName)); }
public static int SaveClaims(ClaimsModel model) { return(ClaimsDAL.SaveClaims(model)); }
public static int UpdateClaimStatus(int ID, string status) { return(ClaimsDAL.UpdateClaimStatus(ID, status)); }
public static ClaimDocumentModel SelectClaimsDocumentsByPKId(int DocumentId) { return(FuneralHelper.DataReaderMapToList <ClaimDocumentModel>(ClaimsDAL.SelectClaimsDocumentsByPKId(DocumentId)).FirstOrDefault()); }
public static int DeleteClaimsdocumentById(int pkiClaimPictureID) { return(ClaimsDAL.DeleteClaimsdocumentById(pkiClaimPictureID)); }
public static List <ClaimDocumentModel> SelectClaimDocumentsByClaimId(int fkiClaimID) { SqlDataReader dr = ClaimsDAL.SelectClaimDocumentsByClaimId(fkiClaimID); return(FuneralHelper.DataReaderMapToList <ClaimDocumentModel>(dr)); }