public static void Delete(int id) { // Create an entity to represent the Entity you wish to delete // Notice you don't need to know all the properties, in this // case just the ID will do. PolicyLimit limit = new PolicyLimit { PolicyLimitID = id }; // Now attach the category stub object to the "Categories" set. // This puts the Entity into the context in the unchanged state, // This is same state it would have had if you made the query DbContextHelper.DbContext.AttachTo("PolicyLimits", limit); // Do the delete the category DbContextHelper.DbContext.DeleteObject(limit); // Apply the delete to the database DbContextHelper.DbContext.SaveChanges(); }
public static void UpdatePolicyLimit(PolicyLimit objlimit) { int limitID = objlimit.LimitID; int PolicyID = objlimit.PolicyID; PolicyLimit objPolicyLimit = DbContextHelper.DbContext.PolicyLimit.First(x => x.LimitID == limitID && x.PolicyID == PolicyID); objPolicyLimit.LimitAmount = objlimit.LimitAmount; objPolicyLimit.LimitDeductible = objlimit.LimitDeductible; objPolicyLimit.LimitDeductible = objlimit.LimitDeductible; objPolicyLimit.CATDeductible = objlimit.CATDeductible; objPolicyLimit.ConInsuranceLimit = objlimit.ConInsuranceLimit; objPolicyLimit.ITV = objlimit.ITV; objPolicyLimit.Reserve = objlimit.Reserve; objPolicyLimit.ApplyAcrossAllCoverage = objlimit.ApplyAcrossAllCoverage; objPolicyLimit.ApplyTo = objlimit.ApplyTo; DbContextHelper.DbContext.SaveChanges(); }
public static PolicyLimit Save(PolicyLimit limit) { if (limit.PolicyLimitID == 0) { DbContextHelper.DbContext.Add(limit); } DbContextHelper.DbContext.SaveChanges(); return limit; }
public static void primePolicyLimits(int policyID) { PolicyLimit propertyLimit = null; List<Limit> limits = null; // read policy limits limits = LimitManager.GetAll(LimitType.LIMIT_TYPE_PROPERTY); if (limits != null && limits.Count > 0) { using (TransactionScope scope = new TransactionScope()) { try { foreach (Limit limit in limits) { // create new policy limit propertyLimit = new PolicyLimit { LimitID = limit.LimitID, PolicyID = policyID, }; // add policy limit Save(propertyLimit); } scope.Complete(); } catch (Exception ex) { } } } }