public void getAllData(int userLoginName) {// gauti duomenys is pirmos formos. Ar tai geras budas? gotUserName = userLoginName; int monthNow = dayToDay.GetTodaysDay(); //int monthPreviuos = Convert.ToInt32(ConfigurationManager.AppSettings.Get("checkTime"));// blogas sprendimas, visi users tures atnaujinta menesi. // Tikrina ar naujas menuo if (dcs.logChecks.Where(a => a.LogData_id == gotUserName).Select(a => a.logData).FirstOrDefault() == monthNow) { AddDataToChartFromDb(); } else { // Visos lenteles atnaujinamos i nulius. logData verte tampa dabartiniu menesiu. Sekanti menesi ji bus pasenusi ClearAllTablesNewMonth(); Submit.IsEnabled = false; Salary.IsEnabled = true; foreach (var item in dcs.logChecks) { if (item.LogData_id == gotUserName) { item.logData = monthNow; } } dcs.SaveChanges(); } }
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(); } }
private void Unlock_Click(object sender, RoutedEventArgs e) {//update user mygtukas if ("False" == LockStatusBox.Text || "True" == LockStatusBox.Text) { if (long.TryParse(UserPhoneBox.Text, out long number)) { if (number > 999999999) { //Convert.ToInt64(UserPhoneBox.Text) MessageBox.Show("Phone number can't be longer than 9 digits"); } else { foreach (var item in dcs.userDatas) { if (item.id == userIdForchanges) { item.fakeNameLog = LogNameBox.Text; item.firstName = FirstNameBox.Text; item.lastName = LastNameBox.Text; item.userPassword = PasswordBox.Text; item.lockInfo = Convert.ToBoolean(LockStatusBox.Text); item.number = UserPhoneBox.Text; } } dcs.SaveChanges(); Unlock.IsEnabled = false; ClearForUpdates(); users.Clear(); showUsersData.ItemsSource = null; LoadUsersData(); } } else { MessageBox.Show("Wrong input, please write numbers!"); } } else { MessageBox.Show(LockStatusBox.Text); MessageBox.Show("Wrong input! lock status must be True or False"); } }
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; } }