public int?load_rating()
{
int?rating = 0;
using (ConverterDataEntities context = new ConverterDataEntities())
{
var vRating = context.Ratings.OrderByDescending(u => u.Rating1).Select(u => u.Rating1).FirstOrDefault();
rating = vRating;
}
return(rating);
}
public List <Converter_Saves> GetData()
{
List <Converter_Saves> data_records;
using (ConverterDataEntities context = new ConverterDataEntities())
{
data_records = context.Converter_Saves
.Take(20)
.ToList();
}
return(data_records);
}
public List <Converter_Saves> SortByConverter(string ConverterName)
{
List <Converter_Saves> data_records;
using (ConverterDataEntities context = new ConverterDataEntities())
{
data_records = context.Converter_Saves
.Where(d => d.Converter == ConverterName)
.OrderByDescending(e => e.DateTime)
.Take(20)
.ToList();
}
return(data_records);
}
public List <Converter_Saves> SortFromToDate(DateTime from, DateTime to)
{
List <Converter_Saves> data_records;
using (ConverterDataEntities context = new ConverterDataEntities())
{
data_records = context.Converter_Saves
.Where(e => e.DateTime > from && e.DateTime < to)
.OrderByDescending(e => e.DateTime)
.Take(20)
.ToList();
}
return(data_records);
}
public List <Converter_Saves> GetTop3ResultsOfConverter(DateTime from, DateTime to, string ConverterName)
{
List <Converter_Saves> data_records;
using (ConverterDataEntities context = new ConverterDataEntities())
{
data_records = context.Converter_Saves
.Where(e => (e.DateTime > from && e.DateTime < to) && (e.Converter == ConverterName))
.OrderByDescending(e => e.DateTime)
.Take(3)
.ToList();
}
return(data_records);
}
public void save_to_DB(string Converter, string UnitFrom, string UnitTo, string ValueToConvert, string ConvertedValue, DateTime Date)
{
using (ConverterDataEntities context = new ConverterDataEntities())
{
Converter_Saves newSave = new Converter_Saves()
{
Converter = Converter,
UnitFrom = UnitFrom,
UnitTo = UnitTo,
ValueToConvert = ValueToConvert,
ConvertedValue = ConvertedValue,
DateTime = Date
};
context.Converter_Saves.Add(newSave);
context.SaveChanges();
}
}
public void save_rating(int?Rating)
{
int previous_id = 0;
using (ConverterDataEntities context = new ConverterDataEntities())
{
previous_id = context.Ratings
.Count();
var previous_rating = context.Ratings.First(c => c.id >= 0);
context.Ratings.Remove(previous_rating);
context.SaveChanges();
Rating newSave = new Rating()
{
Rating1 = Rating
};
context.Ratings.Add(newSave);
context.SaveChanges();
}
}
