public void PostTip(int id_user, List <TipName> listTips)
{
using (HealthMeApp_Data db = new HealthMeApp_Data())
{
Tip insert = new Tip();
if (db.Tip.Any(u => u.UserId == id_user))
{
var tt = (from t in db.Tip where t.UserId == id_user select t).ToList();
foreach (var newT in listTips)
{
foreach (var item in tt)
{
item.Name = newT.Name;
}
}
}
else
{
foreach (var item in listTips)
{
insert.Name = item.Name;
insert.UserId = id_user;
db.Tip.Add(insert);
db.SaveChanges();
}
}
}
}
public void PostLongLat(int id_U, double lon, double lat)
{
using (HealthMeApp_Data db = new HealthMeApp_Data())
{
var item = (from u in db.User where u.Id == id_U select u).SingleOrDefault();
item.Latitude = lat;
item.Longitude = lon;
db.SaveChanges();
}
}
public void Post(int id_A, int id_U)
{
using (HealthMeApp_Data db = new HealthMeApp_Data())
{
var id_Q = (from item in db.Answer
where (item.Id == id_A)
select item.QuestionId).First();
Result insert = new Result();
insert.AnswerId = id_A;
insert.QuestionId = id_Q;
insert.UserId = id_U;
db.Result.Add(insert);
db.SaveChanges();
}
}
public void PostRegister(string r_usr, string r_psw)
{
using (HealthMeApp_Data db = new HealthMeApp_Data())
{
//var id_Q = (from item in db.Answer
// where (item.Id == id_A)
// select item.QuestionId).First();
User insert = new User();
insert.Username = r_usr;
insert.Password = r_psw;
insert.Id += insert.Id;
db.User.Add(insert);
db.SaveChanges();
}
}
