private void showRate() { using (KonwerterBaza context = new KonwerterBaza()) { rateControl.RateValue = context.newStar.OrderByDescending(o => o.Id).Select(o => o.valueOfStar).FirstOrDefault(); } }
private void rateControl_RateValueChanged(object sender, Common.Controls.RateEventArgs e) { using (KonwerterBaza context2 = new KonwerterBaza()) { Star newRegistrationStar = new Star() { valueOfStar = e.Value }; context2.newStar.Add(newRegistrationStar); context2.SaveChanges(); } }
private void registration(string ConverterName, string UnitFrom, string UnitTo, decimal ValueFrom, string ValueTo) { DateTime nowTime = DateTime.Now; using (KonwerterBaza context = new KonwerterBaza()) { Wpis newRegistration = new Wpis() { ConverterName = ConverterName, UnitFrom = UnitFrom, UnitTo = UnitTo, Data = nowTime, ValueFrom = ValueFrom, ValueTo = ValueTo }; context.registrations.Add(newRegistration); context.SaveChanges(); } }
private List <Wpis> statisticView(int number) { using (KonwerterBaza context = new KonwerterBaza()) { if (number == 1) { List <Wpis> list = context.registrations.OrderBy(w => w.Id).ToList(); return(list); } else if (number == 2) { List <Wpis> list = context.registrations.Where(w => w.ConverterName == "Konwerter masy").OrderBy(w => w.Id).ToList(); return(list); } else if (number == 3) { List <Wpis> list = context.registrations.Where(w => w.ConverterName == "Konwerter objętości").OrderBy(w => w.Id).ToList(); return(list); } else if (number == 4) { List <Wpis> list = context.registrations.Where(w => w.ConverterName == "Konwerter godziny").OrderBy(w => w.Id).ToList(); return(list); } else if (number == 5) { List <Wpis> list = context.registrations.Where(w => w.ConverterName == "Konwerter temperatury").OrderBy(w => w.Id).ToList(); return(list); } else if (number == 6) { List <Wpis> list = context.registrations.Where(w => w.ConverterName == "Konwerter długości").OrderBy(w => w.Id).ToList(); return(list); } return(null); } }