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