public static IEnumerable <InsurancePolicy> GetPoliciesFromDataBase() { using (InsurancePolicyContext dataBase = new InsurancePolicyContext()) { return(dataBase.InsurancePolicy.ToList()); } }
public static void СhangePolicyInDataBase(InsurancePolicy policy) { using (InsurancePolicyContext dataBase = new InsurancePolicyContext()) { dataBase.Update(policy); dataBase.SaveChanges(); } }
public static void AddPolicyToDataBase(InsurancePolicy policy) { using (InsurancePolicyContext dataBase = new InsurancePolicyContext()) { policy.Id = Guid.NewGuid().ToString(); policy.DateOfCreation = DateTime.UtcNow; dataBase.InsurancePolicy.Add(policy); dataBase.InsurancePolicy.Add(policy); dataBase.SaveChanges(); } }
public static void DeletePolicyDataBase(string id) { using (InsurancePolicyContext dataBase = new InsurancePolicyContext()) { var InsurancePoliciesFromDelete = dataBase.InsurancePolicy.Where(val => val.Id == id); foreach (var policy in InsurancePoliciesFromDelete) { dataBase.InsurancePolicy.Remove(policy); } dataBase.SaveChanges(); } }