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 int GetNumber(int id) { HealthMeApp_Data db = new HealthMeApp_Data(); int num = (from a in db.Answer where a.QuestionId == id select a).Count(); return(num); }
public IQueryable <IdValue> Get() { HealthMeApp_Data db = new HealthMeApp_Data(); var Id_Name = from item in db.Question select new IdValue { Id = item.Id, Name = item.Name }; return(Id_Name); }
public IQueryable <IdNameAnswer> Get(int id_Q) { HealthMeApp_Data db = new HealthMeApp_Data(); var Id_NameAnswer = from item in db.Answer where (item.QuestionId == id_Q) select new IdNameAnswer { Id = item.Id, Name = item.Name }; return(Id_NameAnswer); }
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 int?GetUserId(string userName, string passWord) { //AllContext db = new AllContext(); //var id_user = (from item in db.User // where (item.username == userName && item.password == passWord) // select item.Id); //return id_user; HealthMeApp_Data db = new HealthMeApp_Data(); var id_user = db.User.First(a => a.Username == userName && a.Password == passWord).Id; return(id_user); }
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(); } }
public IEnumerable <string> Get(string usr) { //Context db = new Context(); //var user = db.Users // // .Where(u => u.login.Equals(login)) // .Select(usr => // usr.username) // .FirstOrDefault(); //var users = from u in db.Users where u.username == usr select u; //var tipsName = users.First().tipsList.Select(c => c.Name); //return tipsName.ToList(); HealthMeApp_Data db = new HealthMeApp_Data(); var users = from u in db.User where u.Username == usr select u; var tipsName = users.First().Tip.Select(c => c.Name); return(tipsName); }
//-----------return UserId + Age(Name) + Sex(Name)----------------------------------------// public static AnswerName Get(int uId) { using (HealthMeApp_Data db = new HealthMeApp_Data()) { // foreach (var user in db.User) // { var age = (from item_a in db.Result where (item_a.QuestionId == 1 && item_a.UserId == uId) select item_a.AnswerId).FirstOrDefault(); //id=2 var ageName = (from a in db.Answer where (a.Id == age) select a.Name).FirstOrDefault(); var sex = (from item_s in db.Result where (item_s.QuestionId == 2 && item_s.UserId == uId) select item_s.AnswerId).FirstOrDefault(); var sexName = (from s in db.Answer where (s.Id == sex) select s.Name).FirstOrDefault(); var sleep = (from item_slp in db.Result where (item_slp.QuestionId == 3 && item_slp.UserId == uId) select item_slp.AnswerId).FirstOrDefault(); var sleepName = (from slp in db.Answer where (slp.Id == sleep) select slp.Name).FirstOrDefault(); var alcohol = (from item_alc in db.Result where (item_alc.QuestionId == 4 && item_alc.UserId == uId) select item_alc.AnswerId).FirstOrDefault(); var alcName = (from alc in db.Answer where (alc.Id == alcohol) select alc.Name).FirstOrDefault(); var stress = (from item_str in db.Result where (item_str.QuestionId == 5 && item_str.UserId == uId) select item_str.AnswerId).FirstOrDefault(); var stressName = (from str in db.Answer where (str.Id == stress) select str.Name).FirstOrDefault(); var activity = (from item_act in db.Result where (item_act.QuestionId == 6 && item_act.UserId == uId) select item_act.AnswerId).FirstOrDefault(); var activityName = (from act in db.Answer where (act.Id == activity) select act.Name).FirstOrDefault(); var smoke = (from item_smk in db.Result where (item_smk.QuestionId == 7 && item_smk.UserId == uId) select item_smk.AnswerId).FirstOrDefault(); var smokeName = (from smk in db.Answer where (smk.Id == smoke) select smk.Name).FirstOrDefault(); var breakfast = (from item_brk in db.Result where (item_brk.QuestionId == 8 && item_brk.UserId == uId) select item_brk.AnswerId).FirstOrDefault(); var breakName = (from brk in db.Answer where (brk.Id == breakfast) select brk.Name).FirstOrDefault(); var water = (from item_wtr in db.Result where (item_wtr.QuestionId == 9 && item_wtr.UserId == uId) select item_wtr.AnswerId).FirstOrDefault(); var waterName = (from wtr in db.Answer where (wtr.Id == water) select wtr.Name).FirstOrDefault(); // agesex.Add(new AgeSexDrools() { Id = user.Id, Age = age, Sex = sex }); //answerName.Add(new AnswerName() //{ answerName.Id = uId; answerName.AgeN = ageName; answerName.SexN = sexName; answerName.AlcN = alcName; answerName.BreakN = breakName; answerName.ActivityN = activityName; answerName.SmokingN = smokeName; answerName.WtrN = waterName; answerName.StressN = stressName; answerName.SleepN = sleepName; //}); //} } return(answerName); }
public bool PostUsername(string userName) { HealthMeApp_Data db = new HealthMeApp_Data(); return(db.User.Any(u => u.Username == userName)); }
public bool Post(string userName, string passWord) { HealthMeApp_Data db = new HealthMeApp_Data(); return(db.User.Any(u => u.Username == userName && u.Password == passWord)); }