public static INSURANCE_TBL the_worth_hmo(int age, string categoryName) { categ = db.CATEGORIES_TBL.Where(g => g.categoryName == categoryName).FirstOrDefault(); prod = db.PRODUCTS_TBL.Where(g => g.categoryId == categ.categoriesId).FirstOrDefault(); price1 = db.PRICEs.Where(g => g.productId == prod.productId).FirstOrDefault(); insurance = db.INSURANCE_TBL.Where(g => g.insuranceId == price1.insuranceId).FirstOrDefault(); //age = db.AGE_TBL.Where(g => g.begins >= age && s=>s.ends <= age).FirstOrDefault(); return(insurance); }
public static INSURANCE_DTO CastToDTO(INSURANCE_TBL a) { return(new INSURANCE_DTO { insuranceId = a.insuranceId, insuranceName = a.insuranceName, hmoId = a.hmoId, description = a.description, InsurancePrice = a.InsurancePrice }); }
public static HMO_TBL GetHmoByProduct(PRODUCTS_TBL product) { using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities()) { INSURANCE_TBL insurance = InsuranceModule.GetProductInsurance(product); if (insurance != null) { HMO_TBL hmo = ctx.HMO_TBL.Where(u => u.hmoId == insurance.hmoId).FirstOrDefault(); } return(null); } }
public static double?getInsurancePrice(INSURANCE_TBL insurance) { using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities()) { var selectedInsurance = InsuranceCRUD.Read(insurance.insuranceId); if (selectedInsurance != null) { return(selectedInsurance.InsurancePrice); } return(null); } }
public static INSURANCE_TBL GetProductInsurance(PRODUCTS_TBL product) { using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities()) { var productdetail = ProductsCRUD.ReadById(ctx, product.productId); if (productdetail != null) { PRICE price = ctx.PRICEs.Where(u => u.productId == product.productId).FirstOrDefault(); INSURANCE_TBL insurance = ctx.INSURANCE_TBL.Where(u => u.insuranceId == price.insuranceId).FirstOrDefault(); return(insurance); } return(null); } }