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