public MainCRMViewModel() { Messenger.Default.Register<NotificationMessage>(this, (message) => { switch (message.Notification) { case "CloseMainCRMWindow": App.Current.Shutdown(); break; } }); int userId = ApplicationState.GetValue<Int32>("EmployeeID"); Employee u = null; using (dbContext db = new dbContext()) { u = db.Employee.SingleOrDefault(item => item.EmployeeId == userId); this.employeer = u; u.LastLog = DateTime.Now; if (u.NumberOfLogs == null) { u.NumberOfLogs = 1; } else { u.NumberOfLogs += 1; } db.SaveChanges(); } }
public LogBookListViewModel() { int userId = ApplicationState.GetValue<Int32>("EmployeeID"); using (dbContext db = new dbContext()) { Employeer = db.Employee.Find(userId); } GetEmployeers(); GetLogs(); }
public CustomerListViewModel() { using (dbContext db = new dbContext()) { //Employeer = db.Employee.Find(ApplicationState.GetValue<Int32>("EmployeeID")); Employeer = db.Employee.Find(2); db.CustomerGroup.OrderBy(item => item.Name).ToList(); CustomerGroupList = db.CustomerGroup.Local; } GetCustomers(); }
private void AddNewCustomerGroupItem() { using (var db = new dbContext()) { var cg = new CustomerGroup(); cg.Name = this.customerGroupName; db.CustomerGroup.Add(cg); db.SaveChanges(); } Messenger.Default.Send(new NotificationMessage("CloseWindowGroup")); }
public LogBookViewModel(int CustomerId) { this.ContactDate = DateTime.Now; int userId = ApplicationState.GetValue<Int32>("EmployeeID"); using (dbContext db = new dbContext()) { Employeer = db.Employee.Find(userId); Customer = db.Customer.Find(CustomerId); db.CustomerContactType.ToList().OrderBy(item => item.Name); this.CustomerContactTypeList = db.CustomerContactType.Local; } }
public bool CanAddNewCustomerGroupItem() { int userId = ApplicationState.GetValue<Int32>("EmployeeID"); if (this.customerGroupName == null) { return false; } using (var db = new dbContext()) { db.CustomerGroup.ToList(); CustomerGroup tmp = db.CustomerGroup.SingleOrDefault(item => item.Name.ToLower().Equals(this.customerGroupName.ToLower())); if (tmp != null) { return false; } } return true; }
private void AddLogBookItem() { var lbvm = new LogBookViewModel(SelectedCustomer.CustomerId); var lbv = new LogBookView(); Messenger.Default.Register<MessangerLogBook>(this, (message) => { switch (message.id) { case 1: using (dbContext db = new dbContext()) { LogBook x = new LogBook(); x.Customer = db.Customer.Find(message.CustomerId); x.CustomerContactType = db.CustomerContactType.Find(message.CustomerContactTypeId); x.Information = message.Information; x.Employeer = db.Employee.Find(message.EmployeerId); x.ContactDate = message.ContactDate; db.LogBook.Add(x); db.SaveChanges(); //RaisePropertyChanged("SelectedCustomer"); } break; } }); lbv.DataContext = lbvm; lbv.ShowDialog(); SearchCustomers(); }
private void DeleteCustomer() { using (dbContext dba = new dbContext()) { if (SelectedCustomer != null) { Customer cst; cst = dba.Customer.Include("LogBook").SingleOrDefault(item => item.CustomerId == this.SelectedCustomer.CustomerId); this.CustomerListCollection.Remove(CustomerListCollection.FirstOrDefault(item => item.CustomerId == SelectedCustomer.CustomerId)); foreach (LogBook child in cst.LogBook.ToList()) dba.LogBook.Remove(child); if (cst != null) { dba.Customer.Remove(cst); dba.Entry(cst).State = EntityState.Deleted; dba.SaveChanges(); } } } //GetCustomers(); }
internal void GetCustomersInGroup() { using (dbContext db = new dbContext()) { if (String.IsNullOrWhiteSpace(SearchText)) { db.Customer.Where(p => p.CustomerGroup.Any(c => c.CustomerGroupId == SelectedCustomerGroup.CustomerGroupId)).Include("State").Include("CustomerGroup").Include("Category").Include("Status").Include("AccountManager").Include("LogBook").Include("LogBook.CustomerContactType").Include("LogBook.Employeer").ToList(); this.CustomerListCollection = db.Customer.Local; } else { db.Customer.Where(p => p.CustomerGroup.Any(c => c.CustomerGroupId == SelectedCustomerGroup.CustomerGroupId)) .Include("State") .Include("CustomerGroup") .Include("Category") .Include("Status") .Include("AccountManager") .Include("LogBook") .Include("LogBook.CustomerContactType") .Include("LogBook.Employeer") .Where(pa => pa.CustomerFullName.Contains(SearchText) || pa.Street.Contains(SearchText) || pa.City.Contains(SearchText)) .ToList(); this.CustomerListCollection = db.Customer.Local; } } }
private void ChangeUserPassword() { using (var db = new dbContext()) { Employee emp = db.Employee.SingleOrDefault(item => item.EmployeeId == this._userId); emp.Password = this.NewPassword1; db.SaveChanges(); } Messenger.Default.Send(new NotificationMessage("CloseWindow")); }
public CustomerViewModel(int CustomerID = 0, CustomerTemp ct = null ) { int userId = ApplicationState.GetValue<Int32>("EmployeeID"); this.ShowView2Command = new RelayCommand(this.ShowView2CommandExecute); // ?? this.db = new dbContext(); this.Items = new Dictionary<string, object>(); employeer = this.db.Employee.SingleOrDefault(item => item.EmployeeId == userId); this.SelectedItems = new Dictionary<string, object>(); if (CustomerID == 0) { this.isNew = true; this.customer = new Customer(); if (ct != null) { this.ct = ct; this.customer.AccountMarketer = db.Employee.SingleOrDefault(item => item.EmployeeId == userId); } this.customer.CreateDate = DateTime.Now; this.SelectedItems = new Dictionary<string, object>(); } else { this.isNew = false; this.customer = this.db.Customer.Where(s => s.CustomerId == CustomerID).FirstOrDefault<Customer>(); if (ct != null) { this.ct = ct; this.customer.AccountMarketer = db.Employee.SingleOrDefault(item => item.EmployeeId == userId); } } if (this.CustomerContact == null) { this.CustomerContactList = new ObservableCollection<CustomerContact>(); } else { this.CustomerContactList = new ObservableCollection<oneCRM.Model.CustomerContact>(this.CustomerContact); } if (this.LogBook == null) { this.LogBookList = new ObservableCollection<Model.LogBook>(); } else { this.LogBookList = new ObservableCollection<Model.LogBook>(this.LogBook); } if (this.CustomerAktywa == null) { this.CustomerAktywaList = new ObservableCollection<CustomerAktywa>(); } else { this.CustomerAktywaList = new ObservableCollection<CustomerAktywa>(this.CustomerAktywa); } if (this.CustomerZatrudnienie == null) { this.CustomerZatrudnienieList = new ObservableCollection<CustomerZatrudnienie>(); } else { this.CustomerZatrudnienieList = new ObservableCollection<CustomerZatrudnienie>(this.CustomerZatrudnienie); } if (this.CustomerPrzychody == null) { this.CustomerPrzychodyList = new ObservableCollection<CustomerPrzychody>(); } else { this.CustomerPrzychodyList = new ObservableCollection<CustomerPrzychody>(this.CustomerPrzychody); } GetLists(); Items.Clear(); foreach (var item in CustomerGroupList) { Items.Add(item.Name, item); } SelectedItems.Clear(); if(this.CustomerGroup != null) { foreach (CustomerGroup a in this.CustomerGroup.Where(item => item.isSelected == true)) { this.SelectedItems.Add(a.Name, a); } } db.SaveChanges(); }
internal void GetLogs(int i = 0) { using (dbContext db = new dbContext()) { ileDni = i; if (i == 100) // Wszystkie { if (AccountManager == null) { IQueryable<LogBook> clc = (from p in db.LogBook orderby p.ContactDate descending select p).Include(item => item.Customer).Include(item => item.Employeer).Include(item => item.CustomerContactType); this.LogBookCollection = new ObservableCollection<LogBook>(clc); } else { IQueryable<LogBook> clc = (from p in db.LogBook where (p.Employeer.EmployeeId == AccountManager.EmployeeId) orderby p.ContactDate descending select p).Include(item => item.Customer).Include(item => item.Employeer).Include(item => item.CustomerContactType); ; this.LogBookCollection = new ObservableCollection<LogBook>(clc); } } else if (i == 200) // Specyfic client { IQueryable<LogBook> clc = (from p in db.LogBook where (p.Customer.CustomerId == SelectedLogBook.Customer.CustomerId) orderby p.ContactDate descending select p).Include(item => item.Customer).Include(item => item.Employeer).Include(item => item.CustomerContactType); this.LogBookCollection = new ObservableCollection<LogBook>(clc); } else { DateTime now = DateTime.Now.Date.AddDays(-i); DateTime today = DateTime.Now.Date; if (i == 1) { if (AccountManager == null) { IQueryable<LogBook> clc = (from p in db.LogBook where (p.ContactDate >= now && p.ContactDate < today) orderby p.ContactDate descending select p).Include(item => item.Customer).Include(item => item.Employeer).Include(item => item.CustomerContactType); this.LogBookCollection = new ObservableCollection<LogBook>(clc); } else { IQueryable<LogBook> clc = (from p in db.LogBook where (p.ContactDate >= now && p.ContactDate < today && p.Employeer.EmployeeId == AccountManager.EmployeeId) orderby p.ContactDate descending select p).Include(item => item.Customer).Include(item => item.Employeer).Include(item => item.CustomerContactType); this.LogBookCollection = new ObservableCollection<LogBook>(clc); } } else { if (AccountManager == null) { var clc = (from p in db.LogBook where (p.ContactDate >= now) orderby p.ContactDate descending select p).Include(item => item.Customer).Include(item => item.Employeer).Include(item => item.CustomerContactType); this.LogBookCollection = new ObservableCollection<LogBook>(clc); } else { IQueryable<LogBook> clc = (from p in db.LogBook where (p.ContactDate >= now && p.Employeer.EmployeeId == AccountManager.EmployeeId) orderby p.ContactDate descending select p).Include(item => item.Customer).Include(item => item.Employeer).Include(item => item.CustomerContactType); this.LogBookCollection = new ObservableCollection<LogBook>(clc); } } } } RaisePropertyChanged("LogBookCollection"); }
internal void GetEmployeesList() { using (dbContext db = new dbContext()) { db.Employee.OrderBy(item => item.EmployeeFullName).ToList(); this.AccountManagerList = db.Employee.Local; } }
internal void GetEmployeers() { using (dbContext db = new dbContext()) { db.Employee.ToList(); EmployeeCollection = db.Employee.Local; } }
private void MergeSelectedCustomer() { CustomerView cv = new CustomerView(); cv.DataContext = new CustomerViewModel(SelectedCustomer.CustomerId, CustomerTemp); cv.Show(); using (dbContext db = new dbContext()) { var temp = db.CustomerTemp.SingleOrDefault(item => item.CustomerTempId == CustomerTemp.CustomerTempId); db.CustomerTemp.Remove(temp); db.SaveChanges(); } Messenger.Default.Send(new NotificationMessage("CloseSimilarCustomerListViewWindow")); }
private void AddNewLogBook() { using (dbContext db = new dbContext()) { try { var lb = new LogBook(); lb.Employeer = db.Employee.Find(this.Employeer.EmployeeId); lb.Information = this.Information; lb.ContactDate = ContactDate; lb.Customer = db.Customer.Find(this.Customer.CustomerId); lb.CustomerContactType = db.CustomerContactType.Find(this.CustomerContactType.CustomerContactTypeId); db.LogBook.Add(lb); db.SaveChanges(); } catch (Exception ex) { Messenger.Default.Send(new NotificationMessage(ex.ToString())); } } Messenger.Default.Send(new NotificationMessage("CloseWindowLogBookItem")); }
public async Task<List<Customer>> GetCustomerByNamePaged(string sortExpression, string nameSearchString, int startRowIndex, int maximumRows) { if (String.IsNullOrWhiteSpace(sortExpression)) { sortExpression = "CustomerFullName"; } if (String.IsNullOrWhiteSpace(nameSearchString)) { nameSearchString = ""; } using (dbContext db = new dbContext()) { db.Configuration.ProxyCreationEnabled = false; return await db.Customer.Include("State").Include("CustomerGroup").Include("Category").Include("Status").Include("AccountManager").Include("LogBook").Include("LogBook.CustomerContactType").Include("LogBook.Employeer") .OrderBy(o => o.CustomerFullName) .Where(d => d.CustomerFullName.Contains(nameSearchString)) .ToListAsync(); } }
private void AddNewPrzychody() { var lb = new CustomerPrzychody(); lb.Rok = rok; lb.Wartosc = wartosc; lb.Uwagi = uwagi; using (dbContext db = new dbContext()) { Customer = db.Customer.Find(CustomerId); lb.Customers.Add(Customer); try { db.CustomerPrzychody.Add(lb); db.SaveChanges(); } catch (Exception) { Messenger.Default.Send(new NotificationMessage("ERROR")); } } Messenger.Default.Send(new MessangerCustomerPrzychody(lb.Rok, lb.Wartosc, lb.Uwagi)); Messenger.Default.Send(new NotificationMessage("CloseWindowCustomerPrzychody")); }
private void LoginExcute() { Employee emp = null; try { using (var db = new dbContext()) { db.Configuration.ProxyCreationEnabled = false; var x = from d in db.Employee where d.Login == this.login && d.Password == this.Password && d.Status == true select d; emp = x.FirstOrDefault<Employee>(); } } catch (Exception) { emp = null; } if (emp != null) { if (isChecked) { hkcu = Registry.CurrentUser.OpenSubKey(@"Software\oneCRM\", true); if ((string)hkcu.GetValue("Login") == null) { hkcu.SetValue("Login", login, RegistryValueKind.String); } else if ((string)hkcu.GetValue("Login") != login) { hkcu.SetValue("Login", login, RegistryValueKind.String); } if ((string)hkcu.GetValue("Password") == null) { hkcu.SetValue("Password", Password, RegistryValueKind.String); } else if ((string)hkcu.GetValue("Password") != Password) { hkcu.SetValue("Password", Password, RegistryValueKind.String); } hkcu.Close(); } ApplicationState.SetValue("EmployeeID", emp.EmployeeId); this.employeer = emp.EmployeeId; MainCRMView mCRM = new MainCRMView(); mCRM.Show(); Messenger.Default.Send(new NotificationMessage("CloseLoginWindow")); } else { this.Password = null; } }
public bool CanChangeUserPassword() { if (this.NewPassword1 == null || this.NewPassword2 == null) { return false; } if (this.NewPassword1 != this.NewPassword2) { return false; } using (var db = new dbContext()) { IQueryable<Employee> x = db.Employee.Where(item => item.EmployeeId == this._userId && item.Password == this.ActualPassword); if (x == null) { return false; } } return true; }