public static List <ClaimsData> Rejectedclaims()
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.ClaimsDatas.Where(x => x.IsApproved == false).ToList());
}
}
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 List <UserMaster> GetUserinfo(int id)
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.UserMasters.Where(x => x.UID == id).ToList());
}
}
public static List <PlansMaster> GetData()
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.PlansMasters.ToList());
}
}
public static List <ClaimsData> GetClaimData()
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.ClaimsDatas.Where(x => x.IsApproved == null).ToList());
}
}
public static List <UserMaster> LoginValidate(string Username, string Password)
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.UserMasters.Where(x => x.UserName == Username && x.Password == Password).ToList());
}
}
public static List <UserMaster> GetApprovalData()
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.UserMasters.Where(x => x.IsActive == null).ToList());
}
}
public static List <UserMaster> Displayclaim(int id, string name)
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.UserMasters.Where(z => z.UID == id && z.UserName == name).ToList());
}
}
public static List <ClaimsData> GetClaims(int id)
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.ClaimsDatas.Where(x => x.MemberId == id).ToList());
}
}
public static List <ClaimsData> claim_display(int claimid, long amount)
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.ClaimsDatas.Where(x => x.ClaimId == claimid && x.ClaimAmount == amount).ToList());
}
}
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 List <UserMaster> DisplayName(string Firstname, string Lastname)
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.UserMasters.Where(z => z.FirstName == Firstname && z.LastName == Lastname).ToList());
}
}
public static List <UserMaster> GetAllUsersData()
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.UserMasters.ToList());
}
}
public static List <ClaimsData> Approvedclaims()
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.ClaimsDatas.Where(x => x.ClaimStatus == "Approved").ToList());
}
}
public static List <ClaimsData> GetClaimStatus(int claimId)
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.ClaimsDatas.Where(x => x.ClaimId == claimId).ToList());
}
}
public static List <ClaimsData> GetClaimsApproval()
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.ClaimsDatas.Where(x => x.ClaimStatus == "Pending").ToList());
}
}
public static List <ClaimsData> GetClaimsData()
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.ClaimsDatas.ToList());
}
}
public static List <PlansMaster> claimdisplay(int planid)
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
return(db.PlansMasters.Where(y => y.PlanID == planid).ToList());
}
}
public static bool CheckUserId(string username)
{
using (DBEntitiesDataContext db = new DBEntitiesDataContext())
{
if (db.UserMasters.Where(x => x.UserName == username).ToList().Count > 0)
{
return(true);
}
else
{
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 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 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 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); }
}
