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