public string UpdateMyUser(int id, MyUser myuser) { try { triggerDBEntities db = new triggerDBEntities(); MyUser mu = db.MyUsers.Find(id); mu.AccountType = myuser.AccountType; mu.BillingCycle = myuser.BillingCycle; mu.Companies = myuser.Companies; myuser.Email = myuser.Email; mu.FirstName = myuser.FirstName; mu.GUI = myuser.GUI; mu.LastLogin = myuser.LastLogin; mu.LastName = myuser.LastName; mu.Newsletter = myuser.Newsletter; mu.Results = myuser.Results; mu.StartDate = myuser.StartDate; mu.Triggers = myuser.Triggers; mu.UserName = myuser.UserName; db.SaveChanges(); return(myuser.ID.ToString() + " was updated succesfully."); } catch (Exception e) { return("error: " + e); } }
public String InsertMyUser(MyUser myuser) { try { triggerDBEntities db = new triggerDBEntities(); db.MyUsers.Add(myuser); db.SaveChanges(); return(myuser.ID.ToString() + " was added successfully."); } catch (Exception e) { return("error: " + e); } }
public String InsertPost(Post post) { try { triggerDBEntities db = new triggerDBEntities(); db.Posts.Add(post); db.SaveChanges(); return(post.Title + " was added succesfully."); } catch (Exception e) { return("error: " + e); } }
public String InsertTag(Tag tag) { try { triggerDBEntities db = new triggerDBEntities(); db.Tags.Add(tag); db.SaveChanges(); return(tag.Name + " was added succesfully."); } catch (Exception e) { return("error: " + e); } }
public String InsertComment(Comment comment) { try { triggerDBEntities db = new triggerDBEntities(); db.Comments.Add(comment); db.SaveChanges(); return(" was added succesfully."); } catch (Exception e) { return("error: " + e); } }
public String InsertCompany(Company company) { try { triggerDBEntities db = new triggerDBEntities(); db.Companies.Add(company); db.SaveChanges(); return(company.ID.ToString() + " was added successfully."); } catch (Exception e) { return("error: " + e); } }
public String InsertEmailList(EmailList emaillist) { try { triggerDBEntities db = new triggerDBEntities(); db.EmailLists.Add(emaillist); db.SaveChanges(); return(emaillist.Name + " was added succesfully."); } catch (Exception e) { return("error: " + e); } }
public string DeleteMyUser(int id) { try { triggerDBEntities db = new triggerDBEntities(); Tag p = db.Tags.Find(id); Result r = db.Results.Find(id); db.Results.Attach(r); db.Results.Remove(r); db.SaveChanges(); MyUser mu = db.MyUsers.Find(id); db.MyUsers.Attach(mu); db.MyUsers.Remove(mu); db.SaveChanges(); return(mu.ID.ToString() + " was deleted succesfully."); } catch (Exception e) { return("error: " + e); } }
public String InsertResult(Result result) { try { triggerDBEntities db = new triggerDBEntities(); db.Results.Add(result); db.SaveChanges(); return(result.ID.ToString() + " was added successfully."); } catch (Exception e) { return("error: " + e); } }
public string UpdateTag(int id, Tag tag) { try { triggerDBEntities db = new triggerDBEntities(); Tag p = db.Tags.Find(id); p.Name = tag.Name; db.SaveChanges(); return(tag.Name + " was updated succesfully."); } catch (Exception e) { return("error: " + e); } }
public string UpdateEmailList(int id, EmailList emaillist) { try { triggerDBEntities db = new triggerDBEntities(); EmailList p = db.EmailLists.Find(id); p.Name = emaillist.Name; db.SaveChanges(); return(emaillist.Name + " was updated succesfully."); } catch (Exception e) { return("error: " + e); } }
public string UpdateComment(int id) { try { triggerDBEntities db = new triggerDBEntities(); Comment p = db.Comments.Find(id); db.Comments.Attach(p); db.Comments.Remove(p); db.SaveChanges(); return(p.Name + " was deleted succesfully."); } catch (Exception e) { return("error: " + e); } }
public string DeletePost(int id) { try { triggerDBEntities db = new triggerDBEntities(); Post p = db.Posts.Find(id); db.Posts.Attach(p); db.Posts.Remove(p); db.SaveChanges(); return(p.Title + " was deleted succesfully."); } catch (Exception e) { return("error: " + e); } }
public string DeleteCompany(int id) { try { triggerDBEntities db = new triggerDBEntities(); Tag p = db.Tags.Find(id); Company r = db.Companies.Find(id); db.Companies.Attach(r); db.Companies.Remove(r); db.SaveChanges(); return(r.ID.ToString() + " was deleted succesfully."); } catch (Exception e) { return("error: " + e); } }
public string UpdateResult(int id, Result result) { try { triggerDBEntities db = new triggerDBEntities(); Result r = db.Results.Find(id); r.BodyText = result.BodyText; r.Company = result.Company; r.DateSearched = result.DateSearched; r.Triggers = result.Triggers; db.SaveChanges(); return(result.ID.ToString() + " was updated succesfully."); } catch (Exception e) { return("error: " + e); } }
public string UpdateComment(int id, Comment comment) { try { triggerDBEntities db = new triggerDBEntities(); Comment p = db.Comments.Find(id); p.Name = comment.Name; p.Body = comment.Body; p.Email = comment.Email; p.DateTime = comment.DateTime; p.PostID = comment.PostID; db.SaveChanges(); return(comment.Name + " was updated succesfully."); } catch (Exception e) { return("error: " + e); } }
public string UpdateCompany(int id, Company company) { try { triggerDBEntities db = new triggerDBEntities(); Company r = db.Companies.Find(id); r.AlternateName = company.AlternateName; r.CEO = company.CEO; r.CFO = company.CFO; r.Industry = company.Industry; r.Industry2 = company.Industry2; r.Name = company.Name; r.Symbol = company.Symbol; db.SaveChanges(); return(company.ID.ToString() + " was updated succesfully."); } catch (Exception e) { return("error: " + e); } }
public string UpdatePost(int id, Post post) { try { triggerDBEntities db = new triggerDBEntities(); Post p = db.Posts.Find(id); p.Title = post.Title; p.DateTime = post.DateTime; p.Body = post.Body; p.Comments = post.Comments; //p.Tags = post.Tags; p.Tags1 = post.Tags1; p.IsDraft = post.IsDraft; db.SaveChanges(); return(post.Title + " was updated succesfully."); } catch (Exception e) { return("error: " + e); } }