public List <rate> GetAllRatings()
{
List <rate> ratings = new List <rate>();
using (SqlConnection conn = new SqlConnection(connstring))
{
try
{
conn.Open();
query = "select * from Ratings";
cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
rate obj = new rate();
obj.ProductId = Convert.ToInt32(reader[1]);
obj.TotalPoint = Convert.ToInt32(reader[2]);
obj.ObtainedPoint = Convert.ToInt32(reader[3]);
ratings.Add(obj);
}
}
catch (Exception ex)
{
}
}
return(ratings);
}
public HttpResponseMessage rate(rate rate)
{
barkode_ProjectEntities.rate.Add(rate);
barkode_ProjectEntities.SaveChanges();
message = Request.CreateResponse(HttpStatusCode.OK, rate);
return(message);
}
public ActionResult Dislike()
{
//check logged in?
if (Session["loggedIn"] == null)
{
return(Redirect("~/Home/LoginPage"));
}
int idea_id = Convert.ToInt32(Request.Form["idea_id"].ToString());
int user_id = ((user)Session["loggedIn"]).user_id;
rate rate;
IQueryable <rate> rates = dbData.rates.Where(r => r.idea_id == idea_id).Where(r => r.user_id == user_id);
if (rates.Any())
{
rate = rates.First();
rate.rate_point = -1;
rate.created_at = DateTime.Now;
}
else
{
rate = new rate();
rate.user_id = user_id;
rate.idea_id = idea_id;
rate.rate_point = -1;
rate.created_at = DateTime.Now;
dbData.rates.Add(rate);
}
dbData.SaveChanges();
return(Redirect("~/Idea/Details?idea_id=" + idea_id));
}
public static CurrencyEF MapToEntity(this rate rate)
{
return(new CurrencyEF
{
Name = rate.Id.Substring(0, 3),
LastUpdate = MapTheDate(rate.Date, rate.Time),
CurrentValue = rate.Rate.MapTheDouble()
});
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text.Length != 0)
{
Client c = (Client)Session["client_now"];
rate bikoret = new rate(park.GetparkID(), c.GetidNum(), TextBox1.Text, DateTime.Now.ToString());
ratesHelper.AddRate(bikoret);
TextBox1.Text = "";
handleComments();
}
}
public ActionResult Add(FormCollection form)
{
try
{
rate target = new rate();
//get property
TryUpdateModel(target, new string[] { "rate_name", "rate_measurement", "amount", "start_date", "end_date", "deleted" }, form.ToValueProvider());
target.deleted = false;
target.end_date = new DateTime(2222, 1, 1);
ViewBag.Error = null;
// Update Previous Cost Detail
string query = "";
int PrevId = 0;
DateTime dt1 = target.start_date;
dt1 = dt1.AddDays(-1);
if (db.rates.Any(p => p.rate_name == target.rate_name && p.deleted == false))
{
ViewBag.m = "Duplicate Entry.";
return(View());
}
else
{
var ctx1 = new ckdatabase();
query = "Select Top 1 Rate_number from rates where rate_name ='" + target.rate_name + "' and start_date<'" + target.start_date +
"' and deleted=0 order by start_date Desc";
PrevId = ctx1.Database.SqlQuery <int>(query).FirstOrDefault <int>();
if (PrevId != 0)
{
query = "Update rates set end_date='" + dt1 + "' where tax_number='" + PrevId.ToString() + "'";
var ctx2 = new ckdatabase();
int noOfRowUpdated = ctx2.Database.ExecuteSqlCommand(query);
}
db.rates.Add(target);
db.SaveChanges();
ViewBag.m = "The Labor Cost was successfully created " + "on " + System.DateTime.Now;
string search = null;
return(RedirectToAction("ListLaborCost", new { search, msg = ViewBag.m }));
}
}
catch (Exception e)
{
ViewBag.m = "The Labor was not created " + e.Message;
return(View());
}
}
public ActionResult Edit(int id, FormCollection form)
{
try
{
List <rate> rate_list = db.rates.Where(d => d.rate_number == id).ToList();
ViewBag.Employeeslist = rate_list;
rate target = rate_list[0];
TryUpdateModel(target, new string[] { "rate_name", "rate_measurement", "amount", "start_date", "end_date", "deleted" }, form.ToValueProvider());
target.deleted = false;
target.end_date = new DateTime(2222, 1, 1);
ViewBag.Error = null;
// Update Previous Labor Cost Detail
string query = "";
int PrevId = 0;
DateTime dt1 = target.start_date;
DateTime dt2 = new DateTime(2222, 1, 1);;
dt1 = dt1.AddDays(-1);
var ctx1 = new ckdatabase();
query = "Select Top 1 rate_number from rates where deleted=0 and rate_number<> '" + id.ToString() + "' order by start_date Desc";
PrevId = ctx1.Database.SqlQuery <int>(query).FirstOrDefault <int>();
if (PrevId != 0)
{
query = "Update rates set end_date='" + dt1 + "' where rate_number='" + PrevId.ToString() + "'";
var ctx2 = new ckdatabase();
int noOfRowUpdated = ctx2.Database.ExecuteSqlCommand(query);
}
db.SaveChanges();
ViewBag.m = " The Labor Cost was successfully updated " + " on " + System.DateTime.Now;
//return View(target);
string search = null;
return(RedirectToAction("ListLaborCost", new { search, msg = ViewBag.m }));
}
catch (Exception e)
{
ViewBag.m = "Something went wrong ... " + e.Message;
return(View());
}
}
static List <rate> GetRates()
{
List <rate> rates = new List <rate>();
//foreach (XmlNode root in doc.SelectNodes("rss/channel/item"))
//{
//}
foreach (XmlNode root in GetExchangeRates().SelectNodes("rss/channel/item"))
{
rate rate = new rate();
rate.title = root.SelectSingleNode("title").InnerText;
rate.pubDate = DateTime.Parse(root.SelectSingleNode("pubDate").InnerText);
rate.discreaption = double.Parse(root.SelectSingleNode("description").InnerText.Replace(".", ","));
rates.Add(rate);
}
return(rates);
}
public ActionResult Update(int id)
{
try
{
//setting dropdown list for forgern key
var utype = new List <SelectListItem>();
utype.AddRange(db.users_types.Where(x => x.deleted != true).Select(a => new SelectListItem
{
Text = a.user_type_name,
Selected = false,
Value = a.user_type_number.ToString()
}));
var branchtypes = new List <SelectListItem>();
branchtypes.AddRange(db.branches.Where(x => x.deleted != true).Select(b => new SelectListItem
{
Text = b.branch_name,
Selected = false,
Value = b.branch_number.ToString()
}));
//setting variable passing
ViewBag.utype = utype;
ViewBag.branch = branchtypes;
ViewBag.id = id;
List <rate> rate_list = db.rates.Where(d => d.rate_number == id).ToList();
ViewBag.Customerslist = rate_list;
rate target = rate_list[0];
//branchtypes.Where(q => int.Parse(q.Value) == target.branch.branch_number).First().Selected = true;
//utype.Where(t => int.Parse(t.Value) == target.users_types.user_type_number).First().Selected = true;
return(View(target));
}
catch (Exception e)
{
ViewBag.m = "Something went wrong ... " + e.Message;
return(View());
}
}
public ActionResult Delete(int id)
{
try
{
List <rate> rate_list = db.rates.Where(d => d.rate_number == id).ToList();
ViewBag.Customerslist = rate_list;
rate target = rate_list[0];
target.deleted = true;
db.SaveChanges();
ViewBag.m = "The Labor Cost was successfully deleted.";
string search = null;
return(RedirectToAction("ListLaborCost", new { search, msg = ViewBag.m }));
}
catch (Exception e)
{
ViewBag.m = "The Labor Cost was not deleted ..." + e.Message;
string search = null;
return(RedirectToAction("ListLaborCost", new { search, msg = ViewBag.m }));
}
}
public IActionResult KnnPrediction(rate Rate)
{
if (Rate.userBasedPrediction != 0)
{
ViewData["userBasedPrediction"] = Rate.userBasedPrediction;
}
else
{
ViewData["userBasedPrediction"] = "Sorry, we can't calculate prediction for this movie.";
}
if (Rate.itemBasedPrediction != 0)
{
ViewData["itemBasedPrediction"] = Rate.itemBasedPrediction;
}
else
{
ViewData["itemBasedPrediction"] = "Sorry, we can't calculate prediction for this movie.";
}
return(View(movieRepository.GetMovie(Rate.movieId)));
}
public static async Task <List <rate> > readRates(int userId)
{
List <rate> rates = new List <rate>();
await databaseManager.selectQuery($"SELECT * FROM rates WHERE ratedId = '{userId}'", delegate(DbDataReader reader)
{
if (reader.HasRows)
{
rate rate = new rate();
rate.id = ( int )reader["id"];
rate.ratedId = ( int )reader["ratedId"];
rate.raterId = ( int )reader["raterId"];
rate.csgoId = ( int )reader["csgoId"];
rate.date = ( DateTime )reader["date"];
rate.message = ( string )reader["message"];
rate.value = ( bool )reader["rate"];
rate.ratedUsername = ( string )reader["ratedUsername"];
rate.raterUsername = ( string )reader["raterUsername"];
rates.Add(rate);
}
}).Execute();
return(rates);
}
public IActionResult KnnPrediction(long key)
{
IEnumerable <MovieRate> movieRates = movieRateRepository.MovieRates;
string[] lines = new string[movieRates.ToList().Count];
int count = 0;
foreach (var i in movieRates)
{
string s;
s = i.UserId.ToString() + " " + i.MovieId.ToString() + " " + i.Rate.ToString();
lines[count] = s;
count++;
}
System.IO.File.WriteAllLines(@"C:\Users\nuria\source\repos\DataAcquisitionTermProject\DataAcquisitionTermProject\MatlabFiles\movieRates.txt", lines);
MLApp.MLApp matlab = new MLApp.MLApp();
matlab.Execute(@"cd C:\Users\nuria\source\repos\DataAcquisitionTermProject\DataAcquisitionTermProject\MatlabFiles\");
object result = null;
object result2 = null;
User user = JsonConvert.DeserializeObject <User>(HttpContext.Session.GetString("SessionUser"));
matlab.Feval("UserBasedKNN", 1, out result, "movieRates.txt", user.UserId, key);
object[] res = result as object[];
matlab.Feval("ItemBasedKNN", 1, out result2, "movieRates.txt", user.UserId, key);
object[] res2 = result2 as object[];
rate rate = new rate();
Console.WriteLine(res[0]);
if (res[0] != System.Reflection.Missing.Value && res2[0] != System.Reflection.Missing.Value)
{
int prediction = int.Parse(res[0].ToString());
int prediction2 = int.Parse(res2[0].ToString());
rate.movieId = key;
rate.userBasedPrediction = prediction;
rate.itemBasedPrediction = prediction2;
return(RedirectToAction("KnnPrediction", "Home", rate));
}
else if (res[0] != System.Reflection.Missing.Value && res2[0] == System.Reflection.Missing.Value)
{
int prediction = int.Parse(res[0].ToString());
rate.movieId = key;
rate.userBasedPrediction = prediction;
rate.itemBasedPrediction = 0;
return(RedirectToAction("KnnPrediction", "Home", rate));
}
else if (res[0] == System.Reflection.Missing.Value && res2[0] != System.Reflection.Missing.Value)
{
int prediction2 = int.Parse(res2[0].ToString());
rate.movieId = key;
rate.itemBasedPrediction = prediction2;
rate.userBasedPrediction = 0;
return(RedirectToAction("KnnPrediction", "Home", rate));
}
else
{
rate.movieId = key;
rate.itemBasedPrediction = 0;
rate.userBasedPrediction = 0;
return(RedirectToAction("KnnPrediction", "Home", rate));
}
}
public static void AddRate(rate r)
{
string sql = "INSERT INTO rates ( content, clientID, parkID, date_ ) VALUES('" + r.GetContent() + "'," + r.GetClientID() + "," + r.GetParkID() + ", '" + r.Get_Date() + "');";
MyAdoHelper.DoQuery(fileName, sql);
}
