コード例 #1
0
        public async Task <IHttpActionResult> PuttUserDiet(int id, tUserDiet tUserDiet)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != tUserDiet.ID)
            {
                return(BadRequest());
            }

            db.Entry(tUserDiet).State = EntityState.Modified;

            try
            {
                await db.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!tUserDietExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
コード例 #2
0
        public async Task <IHttpActionResult> GettUserDiet(int id)
        {
            tUserDiet tUserDiet = await db.tUserDiets.FindAsync(id);

            if (tUserDiet == null)
            {
                return(NotFound());
            }

            return(Ok(tUserDiet));
        }
コード例 #3
0
        public async Task <IHttpActionResult> PosttUserDiet(tUserDiet tUserDiet)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.tUserDiets.Add(tUserDiet);
            await db.SaveChangesAsync();

            //  return CreatedAtRoute("DefaultApi", new { id = tUserDiet.ID }, tUserDiet);
            return(Ok(tUserDiet));
        }
コード例 #4
0
        public async Task <IHttpActionResult> SoftDeleteUserDiet(int id, int status)
        {
            tUserDiet tUserDiet = await db.tUserDiets.FindAsync(id);

            if (tUserDiet == null)
            {
                return(NotFound());
            }
            tUserDiet.SystemStatusID      = status;
            tUserDiet.LastUpdatedDateTime = DateTime.Now;
            await db.SaveChangesAsync();

            return(Ok(tUserDiet));
        }
コード例 #5
0
        public async Task <IHttpActionResult> DeletetUserDiet(int id)
        {
            tUserDiet tUserDiet = await db.tUserDiets.FindAsync(id);

            if (tUserDiet == null)
            {
                return(NotFound());
            }

            db.tUserDiets.Remove(tUserDiet);
            await db.SaveChangesAsync();

            return(Ok(tUserDiet));
        }
コード例 #6
0
        public async Task <IHttpActionResult> AddUserDiets(tUserDiet tUserDiet)
        {
            try
            {
                if (!ModelState.IsValid)
                {
                    return(BadRequest(ModelState));
                }


                var tNutrient = await db.tXrefUserDietNutrients.Where(u => u.UserDietID == tUserDiet.ID).ToListAsync();

                //    tUserDiet.ID = 0;
                //   db.tUserDiets.Add(tUserDiet);

                foreach (var item in tNutrient)
                {
                    tUserDiet.tXrefUserDietNutrients.Add(new tXrefUserDietNutrient
                    {
                        CreateDateTime = DateTime.Now,
                        NutrientID     = item.NutrientID,
                        SystemStatusID = 1,
                        UOMID          = item.UOMID,
                        Value          = item.Value
                    });
                }

                db.tUserDiets.Add(tUserDiet);

                await db.SaveChangesAsync();

                //  return CreatedAtRoute("DefaultApi", new { id = tUserDiet.ID }, tUserDiet);
                return(Ok(tUserDiet));
            }
            catch (Exception ex)
            {
                throw;
            }
        }
コード例 #7
0
ファイル: wMeals.cs プロジェクト: aown1982/FreelanceProject
        public IHttpActionResult Post(Meals value)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (value.source == null || value.humanId == null)
            {
                return(BadRequest());
            }
            using (var dbContextTransaction = db.Database.BeginTransaction())
            {
                try
                {
                    tDietCategory dietCategoryObj = db.tDietCategories.SingleOrDefault(x => x.Name == value.type);

                    if (dietCategoryObj == null)
                    {
                        dietCategoryObj      = new tDietCategory();
                        dietCategoryObj.Name = value.type;

                        db.tDietCategories.Add(dietCategoryObj);
                    }

                    tSourceService sourceServiceObj = db.tSourceServices
                                                      .SingleOrDefault(x => x.ServiceName == value.source && x.SourceID == 5);

                    if (sourceServiceObj == null)
                    {
                        sourceServiceObj             = new tSourceService();
                        sourceServiceObj.ServiceName = value.source;
                        sourceServiceObj.TypeID      = 2; //Wellness
                        sourceServiceObj.SourceID    = 5; //HumanAPI

                        db.tSourceServices.Add(sourceServiceObj);
                    }

                    tUserSourceService userSourceServiceObj = null;

                    //Get credentials
                    tCredential credentialObj = db.tCredentials.SingleOrDefault(x => x.SourceID == 5 &&
                                                                                x.SourceUserID == value.humanId &&
                                                                                x.SystemStatusID == 1);
                    if (credentialObj == null)
                    {
                        throw new NoUserCredentialsException("Unable to find any matching HAPI user credentials");
                    }
                    else
                    {
                        userSourceServiceObj = db.tUserSourceServices.SingleOrDefault(
                            x => x.SourceServiceID == sourceServiceObj.ID &&
                            x.CredentialID == credentialObj.ID &&
                            x.SystemStatusID == 1);

                        if (userSourceServiceObj == null)
                        {
                            userSourceServiceObj = new tUserSourceService();
                            userSourceServiceObj.SourceServiceID     = sourceServiceObj.ID;
                            userSourceServiceObj.UserID              = credentialObj.UserID;
                            userSourceServiceObj.CredentialID        = credentialObj.ID;
                            userSourceServiceObj.ConnectedOnDateTime = DateTime.Now;
                            userSourceServiceObj.LastSyncDateTime    = DateTime.Now;
                            userSourceServiceObj.LatestDateTime      = value.updatedAt;
                            userSourceServiceObj.StatusID            = 3; //connected
                            userSourceServiceObj.SystemStatusID      = 1; //valid
                            userSourceServiceObj.tCredential         = credentialObj;

                            db.tUserSourceServices.Add(userSourceServiceObj);
                        }
                        else
                        {
                            //update LatestDateTime to the most recent datetime
                            if (userSourceServiceObj.LatestDateTime == null ||
                                userSourceServiceObj.LatestDateTime < value.updatedAt)
                            {
                                userSourceServiceObj.LatestDateTime = value.updatedAt;
                            }
                        }
                    }

                    tUserDiet userDiet = null;
                    userDiet = db.tUserDiets
                               .SingleOrDefault(x => x.SourceObjectID == value.id);

                    if (userDiet == null)
                    {
                        userDiet = new tUserDiet();
                        userDiet.tUserSourceService  = userSourceServiceObj;
                        userDiet.tDietCategory       = dietCategoryObj;
                        userDiet.UserID              = credentialObj.UserID;
                        userDiet.SourceObjectID      = value.id;
                        userDiet.UserSourceServiceID = sourceServiceObj.ID;
                        userDiet.Name = value.name;
                        if (value.amount != null)
                        {
                            userDiet.Servings = value.amount.value;

                            //UOM
                            if (value.amount.unit != null)
                            {
                                tUnitsOfMeasure uom = null;
                                uom = db.tUnitsOfMeasures.SingleOrDefault(x => x.UnitOfMeasure == value.amount.unit);
                                if (uom == null)
                                {
                                    uom = new tUnitsOfMeasure();
                                    uom.UnitOfMeasure = value.amount.unit;

                                    db.tUnitsOfMeasures.Add(uom);
                                    //db.SaveChanges();
                                }

                                userDiet.tUnitsOfMeasure = uom;
                                userDiet.ServingUOMID    = uom.ID;
                            }
                        }
                        userDiet.DietCategoryID = dietCategoryObj.ID;

                        //Dates
                        DateTimeOffset dtoStart;
                        if (RESTfulBAL.Models.DynamoDB.Utilities.ConvertToDateTimeOffset(value.timestamp,
                                                                                         value.tzOffset,
                                                                                         out dtoStart))
                        {
                            userDiet.EnteredDateTime = dtoStart;
                        }
                        else
                        {
                            userDiet.EnteredDateTime = value.timestamp;
                        }

                        userDiet.SystemStatusID = 1;

                        db.tUserDiets.Add(userDiet);
                    }
                    else
                    {
                        userDiet.tUserSourceService = userSourceServiceObj;
                        userDiet.Name = value.name;
                        if (value.amount != null)
                        {
                            userDiet.Servings = value.amount.value;

                            //UOM
                            if (value.amount.unit != null)
                            {
                                tUnitsOfMeasure uom = null;
                                uom = db.tUnitsOfMeasures.SingleOrDefault(x => x.UnitOfMeasure == value.amount.unit);
                                if (uom == null)
                                {
                                    uom = new tUnitsOfMeasure();
                                    uom.UnitOfMeasure = value.amount.unit;

                                    db.tUnitsOfMeasures.Add(uom);
                                    //db.SaveChanges();
                                }

                                userDiet.tUnitsOfMeasure = uom;
                                userDiet.ServingUOMID    = uom.ID;
                            }
                        }
                        userDiet.DietCategoryID = dietCategoryObj.ID;

                        //Dates
                        DateTimeOffset dtoStart;
                        if (RESTfulBAL.Models.DynamoDB.Utilities.ConvertToDateTimeOffset(value.timestamp,
                                                                                         value.tzOffset,
                                                                                         out dtoStart))
                        {
                            userDiet.EnteredDateTime = dtoStart;
                        }
                        else
                        {
                            userDiet.EnteredDateTime = value.timestamp;
                        }

                        userDiet.LastUpdatedDateTime = DateTime.Now;
                    }

                    AddorUpdateNutrients(userDiet.ID, 170, value.calories, 460);
                    AddorUpdateNutrients(userDiet.ID, 161, value.carbohydrate, 5);
                    AddorUpdateNutrients(userDiet.ID, 248, value.fat, 5);
                    AddorUpdateNutrients(userDiet.ID, 209, value.protein, 5);
                    AddorUpdateNutrients(userDiet.ID, 214, value.sodium, 5);
                    AddorUpdateNutrients(userDiet.ID, 218, value.sugar, 5);
                    AddorUpdateNutrients(userDiet.ID, 177, value.fiber, 5);
                    AddorUpdateNutrients(userDiet.ID, 173, value.saturatedFat, 5);
                    AddorUpdateNutrients(userDiet.ID, 171, value.monounsaturatedFat, 5);
                    AddorUpdateNutrients(userDiet.ID, 172, value.polyunsaturatedFat, 5);
                    AddorUpdateNutrients(userDiet.ID, 164, value.cholesterol, 7);
                    AddorUpdateNutrients(userDiet.ID, 233, value.vitaminA, 7);
                    AddorUpdateNutrients(userDiet.ID, 238, value.vitaminC, 7);
                    AddorUpdateNutrients(userDiet.ID, 159, value.calcium, 7);
                    AddorUpdateNutrients(userDiet.ID, 190, value.iron, 7);
                    AddorUpdateNutrients(userDiet.ID, 207, value.potassium, 7);

                    db.SaveChanges();

                    dbContextTransaction.Commit();

                    return(Ok(userDiet));
                }
                catch (Exception ex)
                {
                    dbContextTransaction.Rollback();

                    //Insert Error Log
                    tUserDataErrLog userErrorLog = new tUserDataErrLog();

                    userErrorLog.ErrTypeID   = (int)ErrorLogging.enumErrorType.Application;
                    userErrorLog.ErrSourceID = (int)AuditLogging.enumApplication.SFCBAL;
                    userErrorLog.Code        = ex.HResult.ToString();
                    userErrorLog.Description = ex.Message;
                    userErrorLog.Trace       = ex.StackTrace;

                    dbErr.tUserDataErrLogs.Add(userErrorLog);
                    dbErr.SaveChanges();

                    string ErrMsg = "An error occured and we have logged the error. Please try again later.";

                    Exception Err = new Exception(ErrMsg, ex);

                    return(InternalServerError(Err));
                }
            }
        }