public bool EditUserName(int id, string newname) { Model1 testcontext = new Model1(); users tmp = new users(); try { tmp = testcontext.users.First(i => i.id == id); UserInfo newuser = new UserInfo(tmp.id, newname, tmp.passsword); DeleteUser(id); newuser.AddUser(); testcontext.SaveChanges(); } catch { return(false); } return(true); }
public string EditText(string Title = null, string Lead = null, string Content = null, int CategoryId = -1, List <int> Tags = null) { string ret = "Edytowano tekst"; try { using (var db = new Model1()) { var temp = db.Art.SingleOrDefault(b => b.Title == Title && b.CategoryId == CategoryId); if (temp != null) { if (Title != null) { temp.Title = Title; } if (Lead != null) { temp.Lead = Lead; } if (Content != null) { temp.Content = Content; } if (CategoryId != -1) { temp.CategoryId = CategoryId; } if (Tags != null) { temp.Tags = Tags.ToString(); } } db.SaveChanges(); } } catch (Exception e) { ret = "Ponów akcję: " + e; } return(ret); }
public bool DeleteUser(int id) { Model1 testcontext = new Model1(); users tmp = testcontext.users.First(i => i.id == id); if (tmp == null) { return(true); } try { testcontext.users.Remove(tmp); testcontext.SaveChanges(); } catch { return(false); } return(true); }
public string DeleteText(string Title, int CategoryId) { string ret = "Usunięto tekst"; try { using (var db = new Model1()) { var result = db.Art.SingleOrDefault(b => b.Title == Title && b.CategoryId == CategoryId); if (result != null) { db.Art.Remove(result); db.SaveChanges(); } } } catch (Exception e) { ret = "Ponów akcję: " + e; } return(ret); }
public string PublishText(string Title, int CategoryId) { string ret = "Wysłano tekst"; try { using (var db = new Model1()) { var result = db.Art.SingleOrDefault(b => b.Title == Title && b.CategoryId == CategoryId); if (result != null) { result.IsPublish = 1; db.SaveChanges(); } } } catch (Exception e) { ret = "Ponów akcję: " + e; } return(ret); }
public bool AddUser() { Model1 testcontext = new Model1(); users tmp = new users(); tmp.id = this.id; tmp.name = this.name; tmp.passsword = this.pass; if (TestOnDB(tmp) == true) { return(false); } try { testcontext.users.Add(tmp); testcontext.SaveChanges(); } catch { return(false); } return(true); }