public Controller(WypozyczalniaDataClassesDataContext dbContext, BaseView initForm)
{
activeView = initForm;
this.dbContext = dbContext;
// TODO: sprawdzenie typu przekazanego parametru
clients = (ClientsView)initForm;
// zainicjalizowanie pozostalych okienek
employees = new EmployeesView();
warehouse = new WarehouseView();
clients.SetController(this);
employees.SetController(this);
warehouse.SetController(this);
IsClosing = false;
// inicjalizacja obiektow dbContext
queriesClient = new QueriesClient(dbContext);
queriesEmployee = new QueriesEmployee(dbContext);
queriesWarehouse = new QueriesWarehouse(dbContext);
// inicjalizacja DialogResult
dr = DialogResult.None;
// inicjalizacja danych w domyslnym okienku
SelectAllAtActiveWindow();
UpdateDBStatus();
}
public void Listen()
{
//создать
ClientsView.CreateClient += () =>
{
clientParametersView.SaveClientAction += SaveNewClient;
clientParametersView.ShowDialog();
clientParametersView.SaveClientAction -= SaveNewClient;
};
///удалить
ClientsView.DeleteClient += (id) =>
{
ClientsModel.RemoveClient(id);
SaveClientsModel();
ClientsView.RefreshList(ClientsModel.GetAll());
};
//изменить клиенta
ClientsView.ModifyClient += (id) =>
{
clientParametersView.SaveClientAction += SaveExistingClient;
Client cl = ClientsModel.GetClientById(id);
clientParametersView.ShowView(cl);
clientParametersView.SaveClientAction -= SaveExistingClient;
};
}
private void SaveNewClient(Client client)
{
ClientsModel.AddClient(client); //добавляем клиента в модель
SaveClientsModel(); //сохраняем модель
clientParametersView.Close(); //закрываем форму
ClientsView.RefreshList(ClientsModel.GetAll()); //обновляем списк клиентов в окне
}
private void SaveExistingClient(Client client)
{
ClientsModel.ModifyClient(client); //редактируем клиента
SaveClientsModel(); //сохраняем модель
clientParametersView.Close(); //закрываем форму
ClientsView.RefreshList(ClientsModel.GetAll()); //обновляем списк клиентов в окне
}
public IActionResult Members()
{
ViewBag.CurrentChoice = ControllerContext.RouteData.Values["action"].ToString();
var DBmembers = _userRepository.Users.Where(u => (u.UserType == 2 || u.UserType == 3) && u.IsActive == true);
var members = new List <ClientsViewModel>();
foreach (var user in DBmembers)
{
var userModel = new ClientsViewModel()
{
Id = user.Id,
Username = _userRepository.GetUsername(user.ExtId),
Name = _userRepository.GetName(user.Id),
Email = _userRepository.GetEmail(user.ExtId),
NumberOfOrders = user.TransactionOwner.Where(t => t.IsProcessed == 1 && t.Type == 2).Count(),
UserType = user.UserType
};
members.Add(userModel);
}
var model = new ClientsView()
{
Clients = members
.OrderBy(u => u.UserType)
.ThenByDescending(u => u.NumberOfOrders)
.ToList()
};
return(View(model));
}
private void Initializate()
{
//roomsView = new RoomsView();
//navigateToView(roomsView);
clientsView = new ClientsView();
navigateToView(clientsView);
}
public ActionResult EditClientsGridView(Int32 id)
{
var clientsview = new ClientsView();
try
{
clientsview = ObjEntities.ClientsViews.Where(x => x.Id == id).FirstOrDefault();
DateTime myDateTime = new DateTime();
if (clientsview != null)
{
ViewBag.Id = id;
var Eshtriackstype = new SelectList(ObjEntities.EshtiracksTypes.ToList(), "Id", "Description");
ViewData["EshtiracksTypes"] = Eshtriackstype;
}
var date = clientsview.Date.ToString();
if (date != "")
{
myDateTime = Convert.ToDateTime(clientsview.Date.ToString());
ViewBag.Tdate = myDateTime.ToString("yyyy-MM-dd");
}
date = clientsview.FullPaymentuptodate.ToString();
if (date != "")
{
myDateTime = Convert.ToDateTime(clientsview.FullPaymentuptodate.ToString());
ViewBag.FDate = myDateTime.ToString("yyyy-MM-dd");
}
ViewBag.Id = id;
TempData["Heading"] = 3;
TempData["Success"] = "Successfully Updated";
}
catch (Exception ex) { }
return(View(clientsview));
}
public ActionResult ClientsGridView(ClientsView clientsview, FormCollection Form)
{
try {
if (ModelState.IsValid)
{
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
clientsview.Date = DateTime.Parse(clientsview.Date.ToShortTimeString());
clientsview.FullPaymentuptodate = DateTime.Parse(clientsview.FullPaymentuptodate.ToShortTimeString());
clientsview.EntryDate = DateTime.Parse(DateTime.Now.ToShortTimeString());
ObjEntities.ClientsViews.Add(clientsview);
ObjEntities.SaveChanges();
int id = clientsview.Id;
if (id > 0)
{
TempData["Success"] = "Successfully Saved";
}
else
{
TempData["Failed"] = "Not Saved";
}
}
}
}
catch (Exception ex) { }
//TempData["ClientData"] = ObjEntities.ClientsView.ToList();
return(RedirectToAction("ClientsGridView"));
}
public ActionResult UpdateClientsGridView(ClientsView clientsview)
{
try
{
using (ArchitectureEntitiesModel entities = new ArchitectureEntitiesModel())
{
ClientsView updatedclientsview = (from c in entities.ClientsViews
where c.Id == clientsview.Id
select c).FirstOrDefault();
updatedclientsview.Name = clientsview.Name;
updatedclientsview.Location = clientsview.Location;
updatedclientsview.Type = clientsview.Type;
updatedclientsview.Date = clientsview.Date;
updatedclientsview.Amount = clientsview.Amount;
updatedclientsview.FullPaymentuptodate = clientsview.FullPaymentuptodate;
updatedclientsview.EntryDate = DateTime.Now;
entities.SaveChanges();
TempData["Success"] = "Successfully Updated";
}
}
catch (Exception ex) { }
return(RedirectToAction("ClientsGridView"));
}
public void Login()
{
WypozyczalniaDataClassesDataContext dbContext = new WypozyczalniaDataClassesDataContext(
//"Data Source=HANIA-LAPTOP\\SQLEXPRESS;Initial Catalog=Test2;User ID=sa;Password=Admin1");
DatabaseSettings.CreateConnectionString(form.UserName, form.Password));
DatabaseSettings.Save(form.UserName);
BaseView initForm = new ClientsView();
Controller controller = new Controller(dbContext, initForm);
initForm.Show();
form.Hide();
}
public void CreateAndOpenClientView()
{
UserControl clientView;
if (!views.TryGetValue(clientKey, out clientView))
{
clientView = new ClientsView();
views.Add(clientKey, clientView);
}
var window = new Window();
window.Content = clientView;
window.Show();
}
private void UpdateClientsPayment(string Amount, int id)
{
using (ArchitectureEntitiesModel entities = new ArchitectureEntitiesModel())
{
ClientsView updatedclientsview = (from c in entities.ClientsViews
where c.Id == id
select c).FirstOrDefault();
long clientamount = long.Parse(updatedclientsview.Amount);
long clientpayments = long.Parse(Amount);
long updatedamount = clientamount - clientpayments;
updatedclientsview.Amount = updatedamount.ToString();
updatedclientsview.EntryDate = DateTime.Now;
entities.SaveChanges();
}
}
private void mi_Clients_Click(object sender, RoutedEventArgs e)
{
ClientsView v = new ClientsView();
v.ShowDialog();
}
private void FindClientOnPropertyChanged(object sender, PropertyChangedEventArgs e)
{
ClientsView.Refresh();
}
public App()
{
InitializeComponent();
MainPage = new ClientsView();
}
public async Task <IActionResult> PromoteToAdmin(ClientsView modelReturned)
{
var userId = modelReturned.UserId;
var dbUser = _userRepository.Users.FirstOrDefault(u => u.Id == userId);
var IdUser = await _userManager.FindByIdAsync(dbUser.ExtId);
var result = await _userManager.AddToRoleAsync(IdUser, "Admin");
if (result.Succeeded)
{
dbUser.UserType = 3;
await _userRepository.UpdateUserAsync(dbUser);
var DBmembersS = _userRepository.Users.Where(u => (u.UserType == 2 || u.UserType == 3) && u.IsActive == true);
var membersS = new List <ClientsViewModel>();
foreach (var user in DBmembersS)
{
var userModel = new ClientsViewModel()
{
Id = user.Id,
Username = _userRepository.GetUsername(user.ExtId),
Name = _userRepository.GetName(user.Id),
Email = _userRepository.GetEmail(user.ExtId),
NumberOfOrders = user.TransactionOwner.Where(t => t.IsProcessed == 1 && t.Type == 2).Count(),
UserType = user.UserType
};
membersS.Add(userModel);
}
var successModel = new ClientsView()
{
Clients = membersS
.OrderBy(u => u.UserType)
.ThenByDescending(u => u.NumberOfOrders)
.ToList()
};
return(View("Members", successModel));
}
var DBmembers = _userRepository.Users.Where(u => (u.UserType == 2 || u.UserType == 3) && u.IsActive == true);
var clients = new List <ClientsViewModel>();
foreach (var user in DBmembers)
{
var userModel = new ClientsViewModel()
{
Id = user.Id,
Username = _userRepository.GetUsername(user.ExtId),
Name = _userRepository.GetName(user.Id),
Email = _userRepository.GetEmail(user.ExtId),
NumberOfOrders = user.TransactionOwner.Where(t => t.IsProcessed == 1 && t.Type == 2).Count(),
UserType = user.UserType
};
clients.Add(userModel);
}
var model = new ClientsView()
{
Clients = clients
.OrderBy(u => u.UserType)
.ThenByDescending(u => u.NumberOfOrders)
.ToList(),
ErrorMessage = "Something went wrong"
};
return(View("Members", model));
}
