//read user by hmo: public static HMO_TBL ReadUserByHmo(USERS_TBL user) { using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities()) { HMO_TBL hmo = ctx.HMO_TBL.Where(u => u.hmoId == user.hmoId).FirstOrDefault(); return(hmo); } }
public static HMO_DTO CastToDTO(HMO_TBL a) { return(new HMO_DTO { hmoId = a.hmoId, hmoMail = a.hmoMail, hmoName = a.hmoName }); }
//create public static void Create(HMO_PROGECTEntities ctx, HMO_TBL hmo) { ctx.HMO_TBL.Add(new HMO_TBL() { hmoName = hmo.hmoName, hmoMail = hmo.hmoMail }); ctx.SaveChanges(); }
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 IHttpActionResult Delete(HMO_PROGECTEntities ctx, HMO_TBL hmo) { try { HmoCRUD.delete(ctx, hmo); return(Ok()); } catch (Exception) { return(InternalServerError()); } }
//delete public static void delete(HMO_PROGECTEntities ctx, HMO_TBL hmo) { ctx.HMO_TBL.Remove(ctx.HMO_TBL.FirstOrDefault(u => u.hmoId == hmo.hmoId)); ctx.SaveChanges(); }