public void AddDataToChartFromDb() {// prideda duomenis i grafika. Matomos vartotojo islaidos using (var db = new UsersInfoDbContext()) { Value1.Value = db.usersavings.Where(a => a.id_Savings == gotUserName).Select(a => a.fuelCosts).FirstOrDefault(); //fuel //Value2.Value = db.usersavings.Where(a => a.UserData.id == gotUserName).Select(a => a.foodCosts).FirstOrDefault(); //food // galiu vel susisiekti su lentele per rakta? Value2.Value = db.usersavings.Where(a => a.id_Savings == gotUserName).Select(a => a.foodCosts).FirstOrDefault(); //food // galiu vel susisiekti su lentele per rakta? Value3.Value = db.usersavings.Where(a => a.id_Savings == gotUserName).Select(a => a.tripsCosts).FirstOrDefault(); //trips Value4.Value = db.usersavings.Where(a => a.id_Savings == gotUserName).Select(a => a.gadgetsCosts).FirstOrDefault(); //gadgets double userSalaryCheck = db.usersavings.Where(a => a.id_Savings == gotUserName).Select(a => a.salary).FirstOrDefault(); // salary // userSalaryCheck = userSalaryCheck - Value1.Value - Value2.Value - Value3.Value - Value4.Value; nereikia foreach (var item in db.usersavings) { if (item.id_Savings == gotUserName) { item.salary = userSalaryCheck; } } salaryLeft.Content = Convert.ToString(userSalaryCheck); totalSavings.Content = Convert.ToString(db.usersavings.Where(a => a.id_Savings == gotUserName).Select(a => a.savings).FirstOrDefault()); db.SaveChanges(); } }
public void AddSalaryTodb(double numberFromParse) { // prideda alga. Galima tik su viena db using (var db = new UsersInfoDbContext()) { foreach (var item in db.usersavings) { if (item.id_Savings == gotUserName) { item.salary = numberFromParse; } } db.SaveChanges(); } }
//public IEnumerable ts (string colName) //{ // string asd = "Fuel"; // List<string> asdas = new List<string>(); // var querys = dcs.usersavings.Where($"{asd}"); // return Convert.ToString(querys); //} public void UpdateTable(double upDateValue, string whichToChoose) { // atnaujina grafikus pridedamos islaidos using (var db = new UsersInfoDbContext()) { if (whichToChoose == "Fuel") { foreach (var item in db.usersavings) { if (item.id_Savings == gotUserName) { item.fuelCosts = upDateValue; } } } else if (whichToChoose == "Food") { foreach (var item in db.usersavings) { if (item.id_Savings == gotUserName) { item.foodCosts = upDateValue; } } } else if (whichToChoose == "Trips") { foreach (var item in db.usersavings) { if (item.id_Savings == gotUserName) { item.tripsCosts = upDateValue; } } } else if (whichToChoose == "Gadgets") { foreach (var item in db.usersavings) { if (item.id_Savings == gotUserName) { item.gadgetsCosts = upDateValue; } } } db.SaveChanges(); } }
public void updateSalaryOrSavings(double upDateValue) {//Atnaujinamos tik salary arba savings lenteles using (var db = new UsersInfoDbContext()) { double salaryToChechIfNotEqualsZero = db.usersavings.Where(a => a.id_Savings == gotUserName).Select(a => a.salary).FirstOrDefault(); double userSavings = db.usersavings.Where(a => a.id_Savings == gotUserName).Select(a => a.savings).FirstOrDefault(); double checkHowMuchLeft = salaryToChechIfNotEqualsZero - upDateValue; //MessageBox.Show(Convert.ToString(salaryToChechIfNotEqualsZero)); foreach (var item in db.usersavings) { if (item.id_Savings == gotUserName) { if (checkHowMuchLeft <= 0) { item.salary = 0; salaryLeft.Content = Convert.ToString(item.salary); userSavings = userSavings + checkHowMuchLeft; item.savings = userSavings; totalSavings.Content = Convert.ToString(item.savings); } else { salaryToChechIfNotEqualsZero = salaryToChechIfNotEqualsZero - upDateValue; item.salary = salaryToChechIfNotEqualsZero; salaryLeft.Content = Convert.ToString(item.salary); } //if (salaryToChechIfNotEqualsZero >= 0) //{ // // salaryToChechIfNotEqualsZero = salaryToChechIfNotEqualsZero - upDateValue; // // item.salary = salaryToChechIfNotEqualsZero; // salaryToChechIfNotEqualsZero = salaryToChechIfNotEqualsZero - upDateValue; // item.salary = salaryToChechIfNotEqualsZero; // salaryLeft.Content = Convert.ToString(item.salary); //} //else //{ // userSavings = userSavings - upDateValue; // item.savings = userSavings; // totalSavings.Content = Convert.ToString(item.savings); //} } } db.SaveChanges(); } }
private void Login_Click(object sender, RoutedEventArgs e) { using (var db = new UsersInfoDbContext()) { bool noUser = true; int UsersCounter = db.userDatas.Max(a => a.id); int UsersCounterControl = 0; foreach (var item in db.userDatas) { if (item.firstName == UserName.Text && item.firstName == "Admin") { // admino patikra ir jungimasis string checkPassword = ReadFromUSB(); if (checkPassword == "No") { MessageBox.Show("Key was not found!"); } else { if (checkPassword != "898989891919" || UserPassword.Password != db.userDatas.Where(a => a.firstName == "Admin").Select(a => a.userPassword).FirstOrDefault()) // reikes linq gauti admino slaptazodi { MessageBox.Show("Wrong password or key!"); } else { //MessageBox.Show("Log"); // naujas langas pas admin AdminWindow adminWindow = new AdminWindow(); //this.Visibility = Visibility.Hidden; adminWindow.Show(); this.Close(); } } } else if (item.fakeNameLog == UserName.Text && item.userPassword == UserPassword.Password && item.lockInfo == false) { //prisijungimas prie sistemos vartotojo // MainWindowForAll.Navigate(new UserPage()); //UserData userDataWindow = new UserData(); WindowForUser windowForUser = new WindowForUser(); windowForUser.getAllData(item.id); //this.Visibility = Visibility.Hidden; windowForUser.Show(); this.Close(); } else if (item.fakeNameLog == UserName.Text && item.lockInfo == true) { // tikrina ar vartotojas uzrakintas MessageBox.Show("Account locked!"); } else if (item.fakeNameLog == UserName.Text && UserName.Text == previousName && item.userPassword != UserPassword.Password) { lockCounter--; MessageBox.Show($"Wrong password"); // kai lockCounter tampa 0 tada vartotojas tampa uzrakintas if (lockCounter == 0) { item.lockInfo = true; MessageBox.Show("Your account is locked Please wait administration call!"); sendMessage.NotificationsForAdmin(); //db.SaveChanges(); lockCounter = 0; // taip pat butu gerai sms zinute admin del vartotojo uzrakinimo } } else if (item.fakeNameLog == UserName.Text && item.fakeNameLog != previousName && item.userPassword != UserPassword.Password) { // tikrina ar atsirado naujas vartotojo vardas, jei taip, tada galima kartoti vel tris kartus lockCounter = 3; } else if (item.fakeNameLog != UserName.Text) { UsersCounterControl++; if (UsersCounterControl == UsersCounter) { noUser = false; UsersCounterControl = 0; } } if (noUser == false) { MessageBox.Show($"There is no user with this name:{UserName.Text}"); lockCounter = 3; // pridetas kad kartoti noUser = true; } }// foreach db.SaveChanges(); previousName = UserName.Text; } }