//create public static void Create(REQUEST_DTO request) { ctx.REQUEST_TBL.Add(new REQUEST_TBL { categoryName = request.categoryName, parentCategory = request.parentCategory, requestKind = request.requestKind, requestStatus = request.requestStatus }); ctx.SaveChanges(); }
public IHttpActionResult confirm(REQUEST_DTO request) { try { RequestCRUD.UpdateConfirm(request); return(Ok()); } catch (Exception e) { return(InternalServerError(e)); } }
public IHttpActionResult Delete(REQUEST_DTO request) { try { RequestCRUD.Delete(request); return(Ok()); } catch (Exception) { return(InternalServerError()); } }
public static REQUEST_DTO UpdateConfirm(REQUEST_DTO request) { var change = ctx.REQUEST_TBL.FirstOrDefault(u => u.requestId == request.requestId); if (change.requestStatus != 0) { change.requestStatus = 0; } else { change.requestStatus = 2; } ctx.SaveChanges(); return(Casting.REQUEST_Casting.CastToDTO(change)); }
//readList //public static List<REQUEST_DTO> read() //{ // var x = ctx.REQUEST_TBL.ToList().Select(u => Casting.REQUEST_Casting.CastToDTO(u)).ToList(); // return x; //} public static List <REQUEST_DTO> Read() { //return List <REQUEST_DTO> list = new List <REQUEST_DTO>(); var requestList = ctx.REQUEST_TBL.ToList(); //.Select(p=> Casting.PRICE_Casting.CastToDTO(p)).ToList(); foreach (var request in requestList) { REQUEST_DTO item = new REQUEST_DTO() { categoryName = request.categoryName, requestId = request.requestId, userName = request.USERS_TBL.firstName + " " + request.USERS_TBL.lastName, //discount = price.discount, //hmoName = price.INSURANCE_TBL.HMO_TBL.hmoName, //insuranceName = price.INSURANCE_TBL.insuranceName, //priceText = price.priceText, //productName = price.PRODUCTS_TBL.name, //ageRange = price.AGE_TBL.begins + "-" + price.AGE_TBL.ends, }; list.Add(item); } return(list); }
//delete public static void Delete(REQUEST_DTO request) { ctx.REQUEST_TBL.Remove(ctx.REQUEST_TBL.FirstOrDefault(u => u.requestId == request.requestId)); ctx.SaveChanges(); }