public List <Pubs> GetAllPubList()
{
try
{
List <Pubs> Pubs = new List <Pubs>();
using (var db = new rftkocsmadbEntities3())
{
Pubs = db.Pubs.ToList();
foreach (Pubs pub in Pubs)
{
pub.customerOverallRatings = PubManager.CalculateOverAllRatingPub(pub.pubID.ToString());
}
db.SaveChanges();
Pubs = db.Pubs.ToList();
return(Pubs);
}
}
catch (Exception e)
{
throw e;
}
}
public Pubs GetPubByID(string pubID)
{
try
{
using (var db = new rftkocsmadbEntities3())
{
return(db.Pubs.Find(pubID));
}
}
catch (Exception e)
{
throw e;
}
}
public customerOpinions GetCustomerOpinion(string opinionID)
{
try
{
using (var db = new rftkocsmadbEntities3())
{
return(db.customerOpinions.Find(opinionID));
}
}
catch (Exception e)
{
throw e;
}
}
public void AddPub(Pubs PubToBeAdded)
{
try
{
using (var db = new rftkocsmadbEntities3())
{
db.Pubs.Add(PubToBeAdded);
db.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
}
public void DeletePubByID(string pubID)
{
try
{
using (var db = new rftkocsmadbEntities3())
{
db.Pubs.Remove(db.Pubs.Find(pubID));
db.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
}
public void DeleteOpinionByID(string opinionID)
{
try
{
using (var db = new rftkocsmadbEntities3())
{
db.customerOpinions.Remove(db.customerOpinions.Find(opinionID));
db.Pubs.Find(db.customerOpinions.Find(opinionID).pubID).customerOverallRatings = PubManager.CalculateOverAllRatingPub(db.customerOpinions.Find(opinionID).pubID.ToString());
db.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
}
public void AddOpinion(customerOpinions OpinionToBeAdded)
{
try
{
using (var db = new rftkocsmadbEntities3())
{
db.customerOpinions.Add(OpinionToBeAdded);
db.Pubs.Find(OpinionToBeAdded.pubID).customerOverallRatings = PubManager.CalculateOverAllRatingPub(OpinionToBeAdded.pubID.ToString());
db.SaveChanges();
}
}
catch (System.Data.Entity.Core.UpdateException e)
{
Debug.WriteLine(e.ToString());
throw e;
}
}
public static float CalculateOverAllRatingPub(string pubID)
{
try
{
List <customerOpinions> ops = new List <customerOpinions>();
float sum = 0;
float overallRating = 0;
if (int.TryParse(pubID, out int tmp))
{
using (var db = new rftkocsmadbEntities3())
{
ops = db.customerOpinions.SqlQuery("SELECT * FROM dbo.customerOpinions WHERE pubID=" + tmp + ";").ToList();
foreach (customerOpinions op in ops)
{
sum += op.rating;
}
if (ops.Count != 0)
{
overallRating = sum / ops.Count;
}
else
{
overallRating = 0;
}
}
return(overallRating);
}
else
{
return(0);
}
}
catch (Exception e)
{
throw e;
}
}
public List <customerOpinions> GetAllOpinionListAboutPubByID(string pubID)
{
try
{
if (int.TryParse(pubID, out int tmp))
{
using (var db = new rftkocsmadbEntities3())
{
return(db.customerOpinions.Where(p => p.pubID == tmp).ToList());
//eturn db.customerOpinions.SqlQuery("SELECT * FROM dbo.customerOpinions WHERE pubID=" + tmp + ";").ToList();
}
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
}
