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