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