public void AddMeal(int userId, DateTime date, string mealName, DateTime time, double caloriesSupplied) { if (!Verify(userId)) { throw new SoapException("Nie rozpoznano użytkownika.", SoapException.ClientFaultCode); } else { bool contains = false; //int mealId = 0; using (var dB = new DailyServerContext()) { contains = dB.DailyInscriptionSet.AsEnumerable().Any(row => (date == row.Date & userId == row.UserUserId)); DailyInscription newDailyInscription; if (!contains) { newDailyInscription = new DailyInscription() { Date = date, UserUserId = userId, }; dB.DailyInscriptionSet.Add(newDailyInscription); dB.SaveChanges(); } else { newDailyInscription = (from DailyInscriptionSet in dB.DailyInscriptionSet where DailyInscriptionSet.Date == date && DailyInscriptionSet.UserUserId == userId select DailyInscriptionSet).FirstOrDefault(); } var newDailyMeal = new DailyMeal() { DMealName = mealName, Time = time, CaloriesSupplied = caloriesSupplied, DailyInscription = newDailyInscription, }; dB.DailyMealSet.Add(newDailyMeal); dB.SaveChanges(); //mealId = (from DailyMealSet in dB.DailyMealSet // where DailyMealSet.DailyInscriptionDInscriptionId == newDailyInscription.DInscriptionId // select DailyMealSet.DMealId).FirstOrDefault(); ; } //return mealId; } }
public void AddNewDailyMensurationInscription(int userId, DateTime date, int mensurationTypeId, double mensurationResultValue) { if (!Verify(userId)) { throw new SoapException("Nie rozpoznano użytkownika.", SoapException.ClientFaultCode); } else { bool contains = false; using (var dB = new DailyServerContext()) { contains = dB.DailyInscriptionSet.AsEnumerable().Any(row => (date == row.Date & userId == row.UserUserId)); DailyInscription newDailyInscription; if (!contains) { newDailyInscription = new DailyInscription() { Date = date, UserUserId = userId, }; dB.DailyInscriptionSet.Add(newDailyInscription); dB.SaveChanges(); } else { newDailyInscription = (from DailyInscriptionSet in dB.DailyInscriptionSet where DailyInscriptionSet.Date == date && DailyInscriptionSet.UserUserId == userId select DailyInscriptionSet).FirstOrDefault(); } var newDailyMensuration = new DailyMensuration() { TypeOfMensurationTOfMensurationId = mensurationTypeId, MResultValue = mensurationResultValue, DailyInscription = newDailyInscription, }; dB.DailyMensurationSet.Add(newDailyMensuration); dB.SaveChanges(); } } }
public void AddNewDailyTrainingInscription(int userId, DateTime date, int exerciseSerieNumber, int? repetitions, int? timeInMin, int exerciseId, int? weight = null) { if (!Verify(userId)) { throw new SoapException("Nie rozpoznano użytkownika.", SoapException.ClientFaultCode); } else { bool contains = false; using (var dB = new DailyServerContext()) { contains = dB.DailyInscriptionSet.AsEnumerable().Any(row => (date == row.Date & userId == row.UserUserId)); DailyInscription newDailyInscription; if (!contains) { newDailyInscription = new DailyInscription() { Date = date, UserUserId = userId, }; dB.DailyInscriptionSet.Add(newDailyInscription); dB.SaveChanges(); } else { newDailyInscription = (from DailyInscriptionSet in dB.DailyInscriptionSet where DailyInscriptionSet.Date == date && DailyInscriptionSet.UserUserId == userId select DailyInscriptionSet).FirstOrDefault(); } var newDailyTraining = new DailyTraining() { ESNumber = exerciseSerieNumber, Repetitions = repetitions, TimeInMin = timeInMin, Weight = weight, DailyInscription = newDailyInscription, ExerciseExerciseId = exerciseId, }; dB.DailyTrainingSet.Add(newDailyTraining); dB.SaveChanges(); } } }
public void AddNewDailyPhotoInscription(int userId, DateTime date, string fileName, byte[] chosenFile) { if (!Verify(userId)) { throw new SoapException("Nie rozpoznano użytkownika.", SoapException.ClientFaultCode); } else { bool contains = false; using (var dB = new DailyServerContext()) { contains = dB.DailyInscriptionSet.AsEnumerable().Any(row => (date == row.Date & userId == row.UserUserId)); DailyInscription newDailyInscription; if (!contains) { newDailyInscription = new DailyInscription() { Date = date, UserUserId = userId, }; dB.DailyInscriptionSet.Add(newDailyInscription); dB.SaveChanges(); } else { newDailyInscription = (from DailyInscriptionSet in dB.DailyInscriptionSet where DailyInscriptionSet.Date == date && DailyInscriptionSet.UserUserId == userId select DailyInscriptionSet).FirstOrDefault(); } var newDailyPhoto = new DailyPhoto() { PName = fileName, PContent = chosenFile, DailyInscription = newDailyInscription, }; dB.DailyPhotoSet.Add(newDailyPhoto); dB.SaveChanges(); } } }