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;
}
}
