public static bool DisplayClaim(int Claimid, int Memberid, DateTime Claimsubmissiondate, long claimamount, long appamount) { try { using (DBEntitiesDataContext db = new DBEntitiesDataContext()) { List <ClaimsData> claimList = db.ClaimsDatas.Where(x => x.ClaimId == Claimid).ToList(); foreach (ClaimsData item in claimList) { item.MemberId = Memberid; item.ClaimStatus = "Approved"; item.ClaimSubmissionDate = Claimsubmissiondate; item.ClaimAmount = claimamount; item.ApprovedAmount = appamount; item.IsApproved = true; item.ClaimProcessedDate = DateTime.Now; item.ClaimServiceDate = DateTime.Now; item.ApprovedOn = DateTime.Now; item.ApprovedBy = "Admin"; item.ClaimId = Claimid; } db.SubmitChanges(); } return(true); } catch { return(false); } }
public static bool Editplan(int id, string planname, string plan_description, string cov1, string cov2, string cov3, int valid, long amount) { try { using (DBEntitiesDataContext db = new DBEntitiesDataContext()) { List <PlansMaster> plan = db.PlansMasters.Where(x => x.PlanID == id).ToList(); foreach (PlansMaster item in plan) { item.PlanName = planname; item.PlanDescription = plan_description; item.Coverage1 = cov1; item.Coverage2 = cov2; item.Coverage3 = cov3; item.ValidityInYears = valid; item.PlanAmount = amount; item.IsActive = true; } db.SubmitChanges(); } return(true); } catch { return(false); } }
public static bool feedback(Feedback fm) { try { using (DBEntitiesDataContext db = new DBEntitiesDataContext()) { db.Feedbacks.InsertOnSubmit(fm); db.SubmitChanges(); } return(true); } catch (Exception ex) { return(false); } }
public static bool Registration(UserMaster um) { try { using (DBEntitiesDataContext db = new DBEntitiesDataContext()) { db.UserMasters.InsertOnSubmit(um); db.SubmitChanges(); } return(true); } catch (Exception ex) { return(false); } }
public static bool addplan(PlansMaster pm) { try { using (DBEntitiesDataContext db = new DBEntitiesDataContext()) { db.PlansMasters.InsertOnSubmit(pm); db.SubmitChanges(); } return(true); } catch (Exception ex) { return(false); } }
public static bool ApproveUsers(int id, bool status) { try { using (DBEntitiesDataContext db = new DBEntitiesDataContext()) { var result = db.UserMasters.Where(x => x.UID == id).FirstOrDefault(); result.IsActive = status; db.SubmitChanges(); return(true); } } catch { return(false); } }
public static bool rejplan(int id, bool detail) { try { using (DBEntitiesDataContext db = new DBEntitiesDataContext()) { var result = db.PlansMasters.Where(x => x.PlanID == id).FirstOrDefault(); result.IsActive = detail; db.SubmitChanges(); return(true); } } catch { return(false); } }
public static bool ApproveClaim(int ID, bool Status) { try { using (DBEntitiesDataContext db = new DBEntitiesDataContext()) { var result = db.ClaimsDatas.Where(x => x.ClaimId == ID).FirstOrDefault(); result.IsApproved = Status; result.ClaimStatus = "Rejected"; db.SubmitChanges(); return(true); } } catch { return(false); } }
public static bool RequestClaim(long amount, long MemberId) { try { using (DBEntitiesDataContext db = new DBEntitiesDataContext()) { ClaimsData _claim = new ClaimsData { ClaimAmount = amount, ClaimStatus = "Pending", MemberId = MemberId, ClaimSubmissionDate = DateTime.Now }; db.ClaimsDatas.InsertOnSubmit(_claim); db.SubmitChanges(); } return(true); } catch { return(false); } }