private void AddorUpdateNutrients(int userDietID, int nutrientID, decimal?value, int uomID) { if (value != null) { tXrefUserDietNutrient userDietNutrient = null; userDietNutrient = db.tXrefUserDietNutrients.SingleOrDefault(x => x.UserDietID == userDietID && x.NutrientID == nutrientID); if (userDietNutrient == null) { userDietNutrient = new tXrefUserDietNutrient(); userDietNutrient.NutrientID = nutrientID; userDietNutrient.UserDietID = userDietID; userDietNutrient.Value = value; userDietNutrient.UOMID = uomID; userDietNutrient.SystemStatusID = 1; db.tXrefUserDietNutrients.Add(userDietNutrient); } else { userDietNutrient.Value = value; userDietNutrient.UOMID = uomID; userDietNutrient.LastUpdatedDateTime = DateTime.Now; } } }
public async Task <IHttpActionResult> PuttXrefUserDietNutrient(int id, tXrefUserDietNutrient tXrefUserDietNutrient) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tXrefUserDietNutrient.ID) { return(BadRequest()); } db.Entry(tXrefUserDietNutrient).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!tXrefUserDietNutrientExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> GettXrefUserDietNutrient(int id) { tXrefUserDietNutrient tXrefUserDietNutrient = await db.tXrefUserDietNutrients.FindAsync(id); if (tXrefUserDietNutrient == null) { return(NotFound()); } return(Ok(tXrefUserDietNutrient)); }
public async Task <IHttpActionResult> PosttXrefUserDietNutrient(tXrefUserDietNutrient tXrefUserDietNutrient) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tXrefUserDietNutrients.Add(tXrefUserDietNutrient); await db.SaveChangesAsync(); // return CreatedAtRoute("DefaultApi", new { id = tXrefUserDietNutrient.ID }, tXrefUserDietNutrient); return(Ok(tXrefUserDietNutrient)); }
public async Task <IHttpActionResult> DeletetXrefUserDietNutrient(int id) { tXrefUserDietNutrient tXrefUserDietNutrient = await db.tXrefUserDietNutrients.FindAsync(id); if (tXrefUserDietNutrient == null) { return(NotFound()); } db.tXrefUserDietNutrients.Remove(tXrefUserDietNutrient); await db.SaveChangesAsync(); return(Ok(tXrefUserDietNutrient)); }
public async Task <IHttpActionResult> SoftDeleteUserDietNutrient(int id, int status) { tXrefUserDietNutrient tXrefUserDietNutrient = await db.tXrefUserDietNutrients.FindAsync(id); if (tXrefUserDietNutrient == null) { return(NotFound()); } tXrefUserDietNutrient.SystemStatusID = status; tXrefUserDietNutrient.LastUpdatedDateTime = DateTime.Now; await db.SaveChangesAsync(); return(Ok(tXrefUserDietNutrient)); }