public tblUser AddUser(tblUser user) { try { using (MyCakesEntities context = new MyCakesEntities()) { tblUser newUser = new tblUser(); newUser.Fullname = user.Fullname; newUser.TelephoneNumber = user.TelephoneNumber; newUser.UserAddress = user.UserAddress; newUser.Username = user.Username; newUser.UserPassword = user.UserPassword; context.tblUsers.Add(newUser); context.SaveChanges(); return(newUser); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public List <tblCake> GetAdultsCakes() { try { using (MyCakesEntities context = new MyCakesEntities()) { List <tblCake> list = new List <tblCake>(); list = (from x in context.tblCakes where x.CakeType.Equals("o") select x).ToList(); return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public tblUser GetUserByUserNameAndPassword(string username, string password) { try { using (MyCakesEntities context = new MyCakesEntities()) { tblUser user = (from x in context.tblUsers where x.Username.Equals(username) && x.UserPassword.Equals(password) select x).First(); return(user); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }