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