public List <Result> GetResultsForUser(string na)
{
//na = "4401,4357,4288,4187,4109,4100";
List <string> resList = na.Split(',').ToList();
List <Result> myList = new List <Result>();
triggerDBEntities db = new triggerDBEntities();
foreach (string s in resList)
{
if (s.All(Char.IsDigit) && s != "")
{
int i = Convert.ToInt32(s);
Result r = (from x in db.Results
where x.ID == i
select x).FirstOrDefault();
if (r != null)
{
myList.Add(r);
}
}
}
return(myList);
}
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 MyUser GetMyUserByGUI(string GUID)
{
triggerDBEntities db = new triggerDBEntities();
MyUser info = (from x in db.MyUsers
where x.GUI == GUID
select x).FirstOrDefault();
return(info);
}
public MyUser GetUserByName(string na)
{
triggerDBEntities db = new triggerDBEntities();
MyUser use = (from x in db.MyUsers
where x.UserName == na
select x).FirstOrDefault();
return(use);
}
public Company GetCompanyByName(string na)
{
triggerDBEntities db = new triggerDBEntities();
Company comp = (from x in db.Companies
where x.Name == na
select x).FirstOrDefault();
return(comp);
}
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 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 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 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 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 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 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 Result GetResult(int id)
{
try
{
using (triggerDBEntities db = new triggerDBEntities())
{
Result r = db.Results.Find(id);
return(r);
}
}
catch (Exception e)
{
return(null);
}
}
public Company GetCompany(int id)
{
try
{
using (triggerDBEntities db = new triggerDBEntities())
{
Company r = db.Companies.Find(id);
return(r);
}
}
catch (Exception e)
{
return(null);
}
}
public MyUser GetMyUser(int id)
{
try
{
using (triggerDBEntities db = new triggerDBEntities())
{
MyUser m = db.MyUsers.Find(id);
return(m);
}
}
catch (Exception e)
{
return(null);
}
}
public Post GetPost(int id)
{
try
{
using (triggerDBEntities db = new triggerDBEntities())
{
Post p = db.Posts.Find(id);
return(p);
}
}
catch (Exception e)
{
return(null);
}
}
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 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 List <MyUser> GetAllMyUsers()
{
try
{
using (triggerDBEntities db = new triggerDBEntities())
{
List <MyUser> mu = (from x in db.MyUsers
select x).ToList();
return(mu);
}
}
catch (Exception e)
{
return(null);
}
}
public List <Tag> GetAllTags()
{
try
{
using (triggerDBEntities db = new triggerDBEntities())
{
List <Tag> ts = (from x in db.Tags
select x).ToList();
return(ts);
}
}
catch (Exception e)
{
return(null);
}
}
public List <Company> GetAllCompanies()
{
try
{
using (triggerDBEntities db = new triggerDBEntities())
{
List <Company> rs = (from x in db.Companies
select x).ToList();
return(rs);
}
}
catch (Exception e)
{
return(null);
}
}
public List <Result> GetAllResults()
{
try
{
using (triggerDBEntities db = new triggerDBEntities())
{
List <Result> rs = (from x in db.Results
select x).ToList();
return(rs);
}
}
catch (Exception e)
{
return(null);
}
}
public List <Comment> GetAllComments()
{
try
{
using (triggerDBEntities db = new triggerDBEntities())
{
List <Comment> cs = (from x in db.Comments
orderby x.DateTime descending
select x).ToList();
return(cs);
}
}
catch (Exception e)
{
return(null);
}
}
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 List <Post> GetPostsByTag()
{
try
{
using (triggerDBEntities db = new triggerDBEntities())
{
List <Post> ps = (from x in db.Posts
orderby x.DateTime descending
select x).ToList();
return(ps);
}
}
catch (Exception e)
{
return(null);
}
}
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 List <Post> GetAllPosts()
{
try
{
List <Post> ps;
triggerDBEntities db = new triggerDBEntities();
using (db )
{
ps = (from x in db.Posts
orderby x.DateTime descending
select x).ToList();
}
return(ps);
}
catch (Exception e)
{
return(null);
}
}
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);
}
}
