//Method for deleting product
public void Delete(Produce produce)
{
using (var db = new ProduceStoreEntities())
{
db.Produces.Remove(produce);
db.SaveChanges();
}
}
//Method for adding produce
public void Add(Produce produce)
{
using (var db = new ProduceStoreEntities())
{
db.Produces.Add(produce);
db.SaveChanges();
}
}
//Method for editing produce
public void Update(Produce produce)
{
using (var db = new ProduceStoreEntities())
{
db.Entry(produce).State = EntityState.Modified;
db.SaveChanges();
}
}
//Method for deleting a rule
public void Delete(Rule rule)
{
using (var db = new ProduceStoreEntities())
{
db.Rules.Remove(rule);
db.SaveChanges();
}
}
//Method for finding produce by ID
public Produce GetProduceById(int id)
{
using (var db = new ProduceStoreEntities())
{
Produce Find = db.Produces.Find(id);
return(Find);
}
}
//Approver Methods
public void Approve(Rule rule)
{
using (var db = new ProduceStoreEntities())
{
rule.RuleStatus = "Approved";
db.Entry(rule).State = EntityState.Modified;
db.SaveChanges();
}
}
//Editor-only methods
//Method for adding a rule
public void Add(Rule rule)
{
using (var db = new ProduceStoreEntities())
{
rule.RuleStatus = "Pending";
db.Rules.Add(rule);
db.SaveChanges();
}
}
/// <summary>
/// Gets all rules from database
/// </summary>
/// <returns>A list of rules</returns>
public List <Rule> getRules()
{
List <Rule> rules = new List <Rule>();
using (var db = new ProduceStoreEntities())
{
rules = db.Rules.ToList();
}
return(rules);
}
//Domain code for Data Maintainer
//Method for retreiving all produce
public List <Produce> GetProduces(string name)
{
using (var db = new ProduceStoreEntities())
{
var query = from p in db.Produces
where p.ProduceName == name
select p;
return(query.ToList <Produce>());
}
}
//Generic methods
//Method for retrieving all rules with a given status
public List <Rule> GetRulesByStatus(string status)
{
using (var db = new ProduceStoreEntities())
{
var query = from r in db.Rules
where r.RuleStatus == status
select r;
return(query.ToList <Rule>());
}
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Rule GetRuleById(int id)
{
using (var db = new ProduceStoreEntities())
{
/*return (from r in db.Rules
* where r.RuleId == id
* select r).First();*/
Rule rule = db.Rules.Find(id);
return(rule);
}
}
/// <summary>
/// Queries the produce table
/// </summary>
/// <param name="command"></param>
/// <returns>Result of query</returns>
public string QueryProduces(string command)
{
string result = "";
using (var context = new ProduceStoreEntities())
{
var ListOfQueryResults = context.Database.SqlQuery <string>(command).ToList();
foreach (var queryResult in ListOfQueryResults)
{
result += queryResult;
}
}
return(result);
}
