public Storage(Storekeeper storekeeper)
{
dataBase = new VeredContext();
InitializeComponent();
storekeeper1 = storekeeper;
showData();
}
public IActionResult DeleteKeeperDB([FromBody] int kepId) //Удаление записи КЛАДОВЩИК из БД
{
Storekeeper b = _context.Storekeepers.Find(kepId);
if (b == null)
{
return(Json("Запись удалена ранее. Обновите страницу!"));
}
var detail = _context.Details.FromSql("SELECT * From Details").ToList();
int count = detail.Count;
for (int i = 0; i < count; i++)
{
if (b.Id == detail.ElementAt(i).StorekeeperId&& detail.ElementAt(i).Count != null && detail.ElementAt(i).Count != 0)
{
return(Json("Запись не может быть удалена:за кладовщиком числятся детали!"));
}
}
if (b != null)
{
_context.Storekeepers.Remove(b);
_context.SaveChanges();
}
return(Json("Запись успешно удалена"));
}
public void InputHandler()
{
var storekeeper = new Storekeeper();
storekeeper = LoginStorekeeper();
if (storekeeper.Id != 0)
{
int userInput = 0;
do
{
userInput = StorekeeperMenu();
if (userInput == 1)
{
GetTransactions();
}
if (userInput == 2)
{
GetInProgressTransactions();
}
if (userInput == 3)
{
CreateReceipt(storekeeper.Id);
}
if (userInput == 4)
{
StorekeeperMenu();
}
} while (userInput != 0);
}
}
public Menu(Storekeeper storekeeper)
{
InitializeComponent();
dataBase = new VeredContext();
storekeeper1 = storekeeper;
btnBuyThrroughPos.Visibility = Visibility.Hidden;
btnAllDataShop.Visibility = Visibility.Hidden;
}
/// <summary>
/// Constructor with one parameter
/// </summary>
/// <param name="storeOpen">Storekeeper window</param>
public StorekeeperViewModel(Storekeeper storeOpen)
{
storekeeper = storeOpen;
using (WarehouseDBEntities context = new WarehouseDBEntities())
{
ProductList = context.Products.ToList();
}
service.GetCurrentWarehouseQuantity();
}
private static void CreateStorekeepersData()
{
firstStorekeeper = new Storekeeper {
FullName = "Белов Андрей Владимирович"
};
secondStorekeeper = new Storekeeper {
FullName = "Попова Александра Михайловна"
};
}
public void Add(Store store, Waybill waybill, Storekeeper storekeeper)
{
var sql = "Insert into AcceptedWaybills (Id, StoreId, WaybillId, StorekeeperId) Values (@Id, @StoreId, @WaybillId, @StorekeeperId);";
using (var connection = new SqlConnection(connectionString))
{
connection.Execute(sql, new { Id = Guid.NewGuid(), StoreId = store.Id, WaybillId = waybill.Id, StorekeeperId = storekeeper.Id });
}
}
public void Delete(int storekeeperId)
{
Storekeeper storekeeperDetail = _context.Storekeepers.FirstOrDefault(x => x.Id == storekeeperId);
if (_context.Details.Any(a => a.StorekeeperId == storekeeperId))
{
throw new ValidationException("Нельзя удалить кладовщика, за которым числятся детали");
}
_context.Storekeepers.Remove(storekeeperDetail ?? throw new InvalidOperationException());
_context.SaveChanges();
}
private void Entry_Click(object sender, EventArgs e)
{
string mySelectQuery = "SELECT Роль FROM dbo.Пользователь WHERE [Логин] = '" + textBox1.Text + "'and [Пароль]='" + textBox2.Text + "'";
SqlConnection ThisConnection = new SqlConnection(MainForm.CS);
ThisConnection.Open();
SqlCommand thisCommand = ThisConnection.CreateCommand();
thisCommand.CommandText = "SELECT Роль FROM dbo.Пользователь WHERE Логин = '" + textBox1.Text + "'and Пароль ='" + textBox2.Text + "'";
SqlDataReader thisReader = thisCommand.ExecuteReader();
string res = string.Empty;
while (thisReader.Read())
{
res += thisReader["Роль"];
}
thisReader.Close();
ThisConnection.Close();
switch (res)
{
case "Сlient":
Client CL = new Client();
CL.Show();
Logname = textBox1.Text;
this.Visible = false;
break;
case "Storekeeper":
Storekeeper SK = new Storekeeper();
SK.Show();
Logname = textBox1.Text;
this.Visible = false;
break;
case "Director":
Director Dr = new Director();
Dr.Show();
Logname = textBox1.Text;
this.Visible = false;
break;
case "Manager":
Manager Mn = new Manager();
Mn.Show();
Logname = textBox1.Text;
this.Visible = false;
break;
default:
MessageBox.Show("Пользователь не найден");
break;
}
}
public void Add(Storekeeper storekeeper)
{
string query = "Insert into Storekeepers values(@Id, @CreationDate, @DeletedDate, @FullName)";
using (var connection = new SqlConnection(configurationService.connectionString))
{
var rowsAffected = connection.Execute(query, storekeeper);
if (rowsAffected != 1)
{
throw new Exception("Error");
}
}
}
private static bool Entry()
{
Console.Clear();
Console.WriteLine("Введите Имя: ");
string name = Console.ReadLine();
Console.WriteLine("Введите пароль: ");
string pass = Console.ReadLine();
if (storekeeperRepository.Authorization(name, pass))
{
storekeeper = storekeeperRepository.GetStorekeeper(name);
return(true);
}
return(false);
}
public Waybill MakeWaybill(Dictionary <Product, int> waybillDetails, Storekeeper storekeeper)
{
var waybill = new Waybill
{
WaybillNumber = $"{new Random().Next(1000, 10000)}",
StorekeeperId = storekeeper.Id
};
foreach (var waybillDetail in waybillDetails)
{
context.WaibillDetails.Add(new WaybillDetail
{
ProductId = waybillDetail.Key.Id,
WaibillId = waybill.Id,
Count = waybillDetail.Value
});
}
return(waybill);
}
private StockOrder MakeStockOrder(Storekeeper storekeeper)
{
var provider = _providerService.GetProvider("BricoWorld");
var articles = new List <Article>();
articles.Add(ArticleConsts.Screwdriver);
articles.Add(ArticleConsts.Probe);
articles.Add(ArticleConsts.WoodenGardenChair);
articles.Add(ArticleConsts.RJ45Cable3Meters);
var stockOrder = _stockOrderService.AddStockOrder(
provider,
storekeeper,
articles
);
return(stockOrder);
}
private void BtStoCreate_Click(object sender, EventArgs e)
{
if (TxtStoName.Text == "" || TxtStoPhone.Text == "" || TxtStoEmail.Text == "" || TxtStoAddress.Text == "")
{
MessageBox.Show("Fill in all information");
return;
}
Storekeeper Sto = new Storekeeper();
Sto.Ad = TxtStoAddress.Text;
Sto.Email = TxtStoEmail.Text;
Sto.Name = TxtStoName.Text;
Sto.PhoneNumber = TxtStoPhone.Text;
Sto.DateOfBirth = BirthDay.Value;
db.Storekeepers.Add(Sto);
db.SaveChanges();
MessageBox.Show("Add item successfully");
LoadDgv();
LoadDetail();
}
public StockOrder AddStockOrder(
Provider provider,
Storekeeper backer,
IEnumerable <Article> articles
)
{
var stockOrder = new StockOrder(
Guid.NewGuid().ToString(),
provider,
backer,
articles,
new OrderReport(
OrderReportStatus.Created,
DateTime.Now
)
);
_stockOrders.Add(stockOrder);
return(stockOrder);
}
public async Task <IActionResult> Get()
{
List <Storekeeper> keeper_ = new List <Storekeeper>();
var Keepers = await(from data in _context.Storekeepers
select new
{
Id = data.Id,
KeeperName = data.KeeperName
}).ToListAsync();
Keepers.ForEach(x =>
{
Storekeeper pro = new Storekeeper();
pro.Id = x.Id;
pro.KeeperName = x.KeeperName;
keeper_.Add(pro);
});
return(Json(keeper_));
}
/// <summary>
/// Checks if its possible to login depending on the given username and password
/// </summary>
/// <param name="obj"></param>
private void LoginExecute(object obj)
{
string password = (obj as PasswordBox).Password;
if (Username == "Mag2019" && password == "Mag2019")
{
Storekeeper sk = new Storekeeper();
LabelInfo = "Logged in";
view.Close();
sk.Show();
}
else if (Username == "Man2019" && password == "Man2019")
{
MainWindow mw = new MainWindow();
LabelInfo = "Logged in";
view.Close();
mw.Show();
}
else
{
LabelInfo = "Wrong Username or Password";
}
}
//raktáros belépés
private static Storekeeper LoginStorekeeper()
{
var storekeeper = new Storekeeper();
return(storekeeper.Login());
}
public ConcreteStrategyE(Storekeeper storekeeper)
{
Storekeeper = storekeeper;
}
private void AddUser_Click(object sender, RoutedEventArgs e)
{
try
{
if ((chkbx1.IsChecked == true && chkbx2.IsChecked == true) || (chkbx1.IsChecked == true && chkbx3.IsChecked == true) ||
(chkbx3.IsChecked == true && chkbx2.IsChecked == true) || (chkbx1.IsChecked == true && chkbx2.IsChecked == true && chkbx3.IsChecked == true))
{
MessageBox.Show("You can choose only one table!", "Caution", MessageBoxButton.OK);
txbxUserFirstName.Clear();
txbxUserLastName.Clear();
txbxEmail.Clear();
txbxPassword.Clear();
txbxSalary.Clear();
}
if (txbxUserFirstName.Text == "" || txbxUserLastName.Text == "" || txbxEmail.Text == "" || txbxPassword.Text == "")
{
MessageBox.Show("Name Should be Filled!", "Warning!", MessageBoxButton.OK);
txbxUserFirstName.Focus();
txbxUserLastName.Focus();
txbxEmail.Focus();
txbxPassword.Focus();
}
else if (chkbx1.IsChecked == true)
{
txbxSalary.IsEnabled = false;
var client = new Client()
{
FirstName = txbxUserFirstName.Text,
LastName = txbxUserLastName.Text,
Email = txbxEmail.Text,
Password = txbxPassword.Text,
};
dataBase.Clients.Add(client);
dataBase.SaveChanges();
showData();
MessageBox.Show("New Client Is Added");
txbxUserFirstName.Clear();
txbxUserLastName.Clear();
txbxEmail.Clear();
txbxPassword.Clear();
txbxSalary.Clear();
}
if (chkbx2.IsChecked == true)
{
if (txbxUserFirstName.Text == "" || txbxUserLastName.Text == "" || txbxEmail.Text == "" || txbxPassword.Text == "" || txbxSalary.Text == "")
{
MessageBox.Show("Name Should be Filled!", "Warning!", MessageBoxButton.OK);
txbxUserFirstName.Focus();
txbxUserLastName.Focus();
txbxEmail.Focus();
txbxPassword.Focus();
txbxSalary.Focus();
}
var seller = new Seller()
{
FirstName = txbxUserFirstName.Text,
LastName = txbxUserLastName.Text,
Email = txbxEmail.Text,
Password = txbxPassword.Text,
Salary = Convert.ToInt32(txbxSalary.Text),
};
dataBase.Sellers.Add(seller);
dataBase.SaveChanges();
showData();
MessageBox.Show("New Seller Is Added");
txbxUserFirstName.Clear();
txbxUserLastName.Clear();
txbxEmail.Clear();
txbxPassword.Clear();
txbxSalary.Clear();
}
if (chkbx3.IsChecked == true)
{
if (txbxUserFirstName.Text == "" || txbxUserLastName.Text == "" || txbxEmail.Text == "" || txbxPassword.Text == "" || txbxSalary.Text == "")
{
MessageBox.Show("Name Should be Filled!", "Warning!", MessageBoxButton.OK);
txbxUserFirstName.Focus();
txbxUserLastName.Focus();
txbxEmail.Focus();
txbxPassword.Focus();
txbxSalary.Focus();
}
var storekeeper = new Storekeeper()
{
FirstName = txbxUserFirstName.Text,
LastName = txbxUserLastName.Text,
Email = txbxEmail.Text,
Password = txbxPassword.Text,
Salary = Convert.ToInt32(txbxSalary.Text),
};
dataBase.Storekeepers.Add(storekeeper);
dataBase.SaveChanges();
showData();
MessageBox.Show("New Storekepper Is Added");
txbxUserFirstName.Clear();
txbxUserLastName.Clear();
txbxEmail.Clear();
txbxPassword.Clear();
txbxSalary.Clear();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Login_Click(object sender, RoutedEventArgs e)
{
Manager manager = Manager.Instance();
manager.ManagerOperation();
string managerEmail = manager.GetManagerEmail();
string managerPassword = manager.GetManagerPassword();
if (LoginBox.Text == managerEmail && PassBox.Password == managerPassword)
{
context = new Context(new ConcreteStrategyE());
context.ContextInterface();
this.Close();
}
else
{
try
{
var email = DB.Clients.Where(u => u.Email == LoginBox.Text).FirstOrDefault();
var email2 = DB.Sellers.Where(u => u.Email == LoginBox.Text).FirstOrDefault();
var email3 = DB.Storekeepers.Where(u => u.Email == LoginBox.Text).FirstOrDefault();
if ((LoginBox.Text == "") || (PassBox.Password == ""))
{
if (LoginBox.Text == "")
{
MessageBox.Show("Email is Required!", "Caution", MessageBoxButton.OK);
LoginBox.Focus();
}
else if (PassBox.Password == "")
{
MessageBox.Show("Password is Required!", "Caution", MessageBoxButton.OK);
PassBox.Focus();
}
}
else
{
if (email != null)
{
var pass = email.Password;
pass = PassBox.Password;
if (PassBox.Password == pass)
{
MessageBox.Show("Login Successfully!", "Login Success", MessageBoxButton.OK);
client = DB.Clients.Where(u => u.Email == LoginBox.Text).FirstOrDefault();
context = new Context(new ConcreteStrategyE(client));
context.ContextInterface();
this.Close();
}
else
{
MessageBox.Show("Email or Password are wrong!");
}
}
else if (email2 != null)
{
var pass = email2.Password;
pass = PassBox.Password;
if (PassBox.Password == pass)
{
MessageBox.Show("Login Successfully!", "Login Success", MessageBoxButton.OK);
seller = DB.Sellers.Where(u => u.Email == LoginBox.Text).FirstOrDefault();
context = new Context(new ConcreteStrategyE(seller));
context.ContextInterface();
this.Close();
}
else
{
MessageBox.Show("Email and Password or wrong!");
}
}
else if (email3 != null)
{
var pass = email3.Password;
pass = PassBox.Password;
if (PassBox.Password == pass)
{
MessageBox.Show("Login Successfully!", "Login Success", MessageBoxButton.OK);
storekeeper = DB.Storekeepers.Where(u => u.Email == LoginBox.Text).FirstOrDefault();
context = new Context(new ConcreteStrategyE(storekeeper));
context.ContextInterface();
this.Close();
}
else
{
MessageBox.Show("Email and Password or wrong!");
}
}
else
{
MessageBox.Show("Email and Password is invalid");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void Add(StorekeeperDto storekeeper)
{
Storekeeper result = _mapper.Map <StorekeeperDto, Storekeeper>(storekeeper);
_dalFactory.StorekeeperDal.Add(result);
}
public void AddNewUser(UserViewModel newUser)
{
Person person = null;
SystemUser systemUser = new SystemUser
{
UserName = newUser.UserName,
Email = newUser.Email,
PhoneNumber = newUser.PhoneNumber
};
string passHash = userManager.PasswordHasher.HashPassword(systemUser, newUser.Password);
systemUser.PasswordHash = passHash;
userManager.CreateAsync(systemUser).Wait();
string role = newUser.Role.ToString();
userManager.AddToRoleAsync(systemUser, role).Wait();
switch (newUser.Role)
{
case UserRoleTypes.Admin:
person = new Admin();
SetPersonProperties(person, newUser, systemUser);
context.Admins.Add(person as Admin);
break;
case UserRoleTypes.Patient:
person = new Patient();
SetPersonProperties(person, newUser, systemUser);
context.Patients.Add(person as Patient);
break;
case UserRoleTypes.Doctor:
person = new Doctor();
SetPersonProperties(person, newUser, systemUser);
context.Doctors.Add(person as Doctor);
break;
case UserRoleTypes.Nurse:
person = new Nurse();
SetPersonProperties(person, newUser, systemUser);
context.Nurses.Add(person as Nurse);
break;
case UserRoleTypes.InternalPharmacist:
person = new InternalPharmacist();
SetPersonProperties(person, newUser, systemUser);
context.InternalPharmacists.Add(person as InternalPharmacist);
break;
case UserRoleTypes.ExternalPharmacist:
person = new ExternalPharmacist();
SetPersonProperties(person, newUser, systemUser);
context.ExternalPharmacists.Add(person as ExternalPharmacist);
break;
case UserRoleTypes.Storekeeper:
person = new Storekeeper();
SetPersonProperties(person, newUser, systemUser);
context.Storekeepers.Add(person as Storekeeper);
break;
default:
throw new Exception("Unknown user type when creating new user!");
}
context.SaveChanges();
}
public IActionResult AddKeeper([FromBody] Storekeeper kepObj)
{
_context.Storekeepers.Add(kepObj);
_context.SaveChanges();
return(Json("OK"));
}
public void Update(StorekeeperDto data)
{
Storekeeper result = _mapper.Map <StorekeeperDto, Storekeeper>(data);
_dalFactory.StorekeeperDal.UpdateVoid(result, result.Id);
}
