public static string Authorizate(string login, string pass)
{
string error = default;
try
{
using (var context = new PavilionsEntities())
{
var user = context.Staff.FirstOrDefault(empl => empl.Login == login);
if (user == null || user.Password != pass)
{
error = "неверная комбинация логин-пароль";
}
else
{
CurrentUser.FirstName = user.FirstName;
CurrentUser.LastName = user.LastName;
CurrentUser.Patronymic = user.Patronymic;
CurrentUser.Role = user.Role;
CurrentUser.ID = user.ID;
}
}
}
catch (Exception ex)
{
error = ex.ToString();
}
return(error);
}
public static ObservableCollection <ShoppingCenterElement> GetSC()
{
ObservableCollection <ShoppingCenterElement> result = new ObservableCollection <ShoppingCenterElement>();
try
{
using (var context = new PavilionsEntities())
{
var centers = (from scenters in context.ShoppingCenters
join cities in context.Cities on scenters.City equals cities.Code
join statuses in context.Statuses on scenters.Status equals statuses.ID
select new
{
scenters.Name,
statuses.Status,
scenters.Quantity,
cities.City,
scenters.Cost,
scenters.Floors,
scenters.Coefficient,
scenters.ID
}).ToList();
foreach (var item in centers)
{
result.Add(new ShoppingCenterElement
{
Name = item.Name,
Status = item.Status,
Quantity = item.Quantity,
City = item.City,
Cost = (double?)item.Cost,
Floors = (Int32?)item.Floors,
Coefficient = (double?)item.Coefficient,
Number = item.ID
});
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return(result);
}
public static string Remove(ShoppingCenterElement elem)
{
string error = default;
try
{
using (var context = new PavilionsEntities())
{
ShoppingCenters pavilion = context.ShoppingCenters.Where(o => o.ID == elem.Number).FirstOrDefault();
context.ShoppingCenters.Remove(pavilion);
context.SaveChanges();
}
}
catch (Exception ex)
{
error = ex.ToString();
}
return(error);
}
