public dynamic getMoreData(string name)
{
userT user = db.userTs.Where(yy => yy.Name == name).FirstOrDefault();
userINF gender = db.userINFs.Where(uu => uu.idOfUser == user.userID).FirstOrDefault();
userWork work = db.userWorks.Where(ii => ii.idUser == user.userID).First();
dynamic obj = new ExpandoObject();
obj.Name = user.Name;
obj.Surname = user.Surname;
obj.Gender = gender.gender;
obj.TypeOfWork = work.workType;
return(obj);
}
public dynamic insertData(string name, string surname, string gender, string work)
{
//Get all user info
userT user = new userT();
userINF u = new userINF();
userWork w = new userWork();
user.Name = name;
user.Surname = surname;
db.userTs.Add(user);
db.SaveChanges();
//Get id of user that we just inserted
userT uID = db.userTs.Where(uu => uu.Name == user.Name).FirstOrDefault();
//ADD gender and worktype inthe db
u.idOfUser = uID.userID;
u.gender = gender;
db.userINFs.Add(u);
db.SaveChanges();
w.idUser = uID.userID;
w.workType = work;
db.userWorks.Add(w);
db.SaveChanges();
//Send back this data to showcase the info we just added to the db
dynamic obj = new ExpandoObject();
obj.Name = name;
obj.Surname = surname;
obj.gender = gender;
obj.TypeOfWork = work;
return(obj);
}
