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); }
}