public User getUserById(int _id) { try { using (var context = new altinsofraDbEntities()) { if (_id != 0) { var user = context.Users.Find(_id); return(user); } else { return(null); } } } catch (DbEntityValidationException e) { helper hp = new helper(); hp.custonexception(e, "getuserbyid", "userdb"); return(null); } }
public User updateUser(User u) { try { using (var context = new altinsofraDbEntities()) { var user = context.Users.Find(u.Id); user.Name = u.Name; user.IsActivated = u.IsActivated; user.Email = u.Email; user.Phone1 = u.Phone1; user.Phone2 = u.Phone2; user.Surname = u.Surname; user.UserAdresses = u.UserAdresses; u.OrderCarts = u.OrderCarts; u.UserType = u.UserType; int result = context.SaveChanges(); return(result > 0 ? u : null); } } catch (DbEntityValidationException e) { helper hp = new helper(); hp.custonexception(e, "updateUser", "userdb", u.Serializer()); throw; } }
public Ordered AddOrdered(Ordered ordered) { try { using (var context = new altinsofraDbEntities()) { context.Ordereds.Add(ordered); int result = context.SaveChanges(); return((result > 0) ? ordered : null); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } }
public User addUser(User user) { try { using (var context = new altinsofraDbEntities()) { context.Users.Add(user); int result = context.SaveChanges(); return(result > 0 ? user : null); } } catch (DbEntityValidationException e) { helper hp = new helper(); hp.custonexception(e, "adduser", "userdb", user.Serializer()); throw; } }
public void custonexception(DbEntityValidationException e, string functionname, string source, params string [] parametre) { var context = new altinsofraDbEntities(); string message = ""; foreach (var eve in e.EntityValidationErrors) { message = "Entity of type" + eve.Entry.Entity.GetType().Name + " in state " + eve.Entry.State + "has the following validation errors:"; foreach (var ve in eve.ValidationErrors) { message += "- Property:" + ve.PropertyName + ", Error:" + ve.ErrorMessage + ""; } } var log = new ExceptionLog(); log.Message = message; log.FunctionName = functionname; log.Source = source; if (parametre.Length > 0) { List <ExceptionInParameter> parameters = new List <ExceptionInParameter>(); foreach (var item in parametre) { parameters.Add(new ExceptionInParameter() { Parameter = item }); } log.ExceptionInParameters = parameters; } context.ExceptionLogs.Add(log); context.SaveChanges(); }
public User blockeUser(int _id) { try { using (var context = new altinsofraDbEntities()) { var selected = context.Users.Find(_id); selected.IsActivated = 1; int result = context.SaveChanges(); return(result > 0 ? selected : null); } } catch (DbEntityValidationException e) { helper hp = new helper(); hp.custonexception(e, "blockeuser", "userdb", _id.Serializer()); throw; } }
public List <User> getUsers() { try { using (var context = new altinsofraDbEntities()) { var users = context.Users.ToList(); return(users.Count > 0 ? users : null); } } catch (DbEntityValidationException e) { helper hp = new helper(); hp.custonexception(e, "getusers", "userdb"); return(null); } ; }