public void Load(WageDto wage) { if (wage == null) { return; } this._id = wage.Manager.IDManager; tbCurrentSum.Text = wage.CurrentSum.ToString(); tbSumOrders.Text = wage.SumOrders.ToString(); tbPaid.Text = wage.Paid.ToString(); tbRest.Text = wage.Rest.ToString(); foreach (ManagersDto m in managerGet) { if (m.IDManager == wage.Manager.IDManager) { this.cbManager.SelectedItem = m; break; } } if ((wage.Rest == 0) && wage.Paid != 0) { tbPaid.IsEnabled = false; } cbManager.IsEnabled = false; }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (tbPaid.Text == null) { tbPaid.BorderBrush = Brushes.Red; } if (cbManager.Text == null) { cbManager.BorderBrush = Brushes.Red; } try { if (((float)Convert.ToDouble(tbCurrentSum.Text) - (float)Convert.ToDouble(tbPaid.Text)) < 0) { MessageBox.Show("Сумма для выплаты не может составлять более " + tbCurrentSum.Text + " рyблей."); return; } } catch { return; } try { WageDto man = new WageDto(); man.Manager = cbManager.SelectedItem as ManagersDto; man.Paid = (float)Convert.ToDouble(tbPaid.Text); man.Rest = (float)Convert.ToDouble(tbCurrentSum.Text) - (float)Convert.ToDouble(tbPaid.Text); man.SumOrders = Convert.ToInt32(tbSumOrders.Text); man.CurrentSum = (float)Math.Round(Convert.ToDouble(tbCurrentSum.Text), 0); IWageProcessDb w = ProcessFactory.GetWageProcess(); if (_id == 0) { w.Add(man); } else { if (man.Rest == 0) { man.Paid = 0; man.CurrentSum = 0; } man.Manager.IDManager = _id; w.Update(man); } } catch (Exception exc) { MessageBox.Show(exc.Message); return; } Close(); }
public static WageDto Convert(Wage country) { if (country == null) { return(null); } WageDto countryDto = new WageDto(); countryDto.CurrentSum = country.CurrentSum; countryDto.IDWage = country.IDWage; countryDto.Manager = Convert(DaoFactory.GetManagersDao().Get(country.Manager)); countryDto.Paid = country.Paid; countryDto.Rest = country.Rest; countryDto.SumOrders = country.SumOrders; return(countryDto); }
public static Wage Convert(WageDto wageDto) { if (wageDto == null) { return(null); } Wage country = new Wage(); country.CurrentSum = wageDto.CurrentSum; country.IDWage = wageDto.IDWage; country.Manager = wageDto.Manager.IDManager; country.Paid = wageDto.Paid; country.Rest = wageDto.Rest; country.SumOrders = wageDto.SumOrders; return(country); }
private void btnEditW_Click(object sender, RoutedEventArgs e) { WageDto item = dgWage.SelectedItem as WageDto; if (item == null) { MessageBox.Show("Выберите запись для редактирования", "Редактирование"); return; } AddWageManager window = new AddWageManager(); window.Load(item); window.ShowDialog(); btnUpdateW_Click(sender, e); }
private void btnDeleteW_Click(object sender, RoutedEventArgs e) { WageDto item = dgWage.SelectedItem as WageDto; if (item == null) { MessageBox.Show("Выберите запись для удаления", "Удаление информации о з/п"); return; } MessageBoxResult result = MessageBox.Show("Удалить информации о з/п для менеджера " + item.Manager.FullName + " ?", "Удаление информации о з/п", MessageBoxButton.YesNo, MessageBoxImage.Warning); if (result != MessageBoxResult.Yes) { return; } ProcessFactory.GetWageProcess().Delete(item.Manager.IDManager); btnUpdateW_Click(sender, e); }
public string genHtmlRating() { List <object> works = ProcessFactory.GetWageProcess().GetList().Cast <object>().ToList(); string res_html = "["; try { foreach (var work in works) { WageDto WorkItem = (WageDto)work; res_html += "{x: '" + WorkItem.Manager.FullName + "', y: " + WorkItem.SumOrders + "},"; } res_html = res_html.Remove(res_html.LastIndexOf(','), 1); res_html += "]"; } catch (Exception exc) { MessageBox.Show(exc.Message, "Ошибка"); } return(res_html); }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (tbPaid.Text == "") { tbPaid.BorderBrush = Brushes.Red; } if (tbSum.Text == "") { tbSum.BorderBrush = Brushes.Red; } if (dpFinallyDate.Text == "") { dpFinallyDate.BorderBrush = Brushes.Red; } if (dpStartDate.Text == "") { dpStartDate.BorderBrush = Brushes.Red; } if (cbEnterprise.Text == "") { cbEnterprise.BorderBrush = Brushes.Red; } if (cbManager.Text == "") { cbManager.BorderBrush = Brushes.Red; } if (cbReklama.Text == "") { cbReklama.BorderBrush = Brushes.Red; } try { if ((Convert.ToDouble(tbAllSum.Text) - Convert.ToDouble(tbPaid.Text) < 0)) { MessageBox.Show("Цена превышает размер " + tbAllSum.Text + " рублей."); return; } } catch { } try { if (Convert.ToDateTime(dpStartDate.Text) > Convert.ToDateTime(dpFinallyDate.Text)) { MessageBox.Show("Дата начала размещения рекламы не должна быть позже даты окончания рекламы."); return; } } catch { } try { OrdersDto or = new OrdersDto(); or.Cost = (float)Convert.ToDouble(this.tbSum.Text); if (tbPaid.Text == "") { or.Paid = 0; } else { or.Paid = (float)Convert.ToDouble(this.tbPaid.Text); } or.FinallyDate = Convert.ToDateTime(this.dpFinallyDate.Text); or.FullNameManager = this.cbManager.SelectedItem as ManagersDto; or.NameEnterprise = this.cbEnterprise.SelectedItem as EnterprisesDto; or.StartDate = Convert.ToDateTime(this.dpStartDate.Text); or.TypeReklama = this.cbReklama.SelectedItem as TypeReklamaDto; int d1 = IntFromDMY(or.StartDate.Day, or.StartDate.Month, or.StartDate.Year); int d2 = IntFromDMY(or.FinallyDate.Day, or.FinallyDate.Month, or.FinallyDate.Year); int ddif = d2 - d1; if (or.TypeReklama.CarrierForReklama.TimeCarrier == "День") { int t = 0; if ((ddif / 30) == 0) { t = 1; } or.AllSum = (float)Math.Round(or.Cost * (ddif / 1), 0); } else if (or.TypeReklama.CarrierForReklama.TimeCarrier == "Неделя") { int t = 0; if ((ddif / 30) == 0) { t = 1; } or.AllSum = (float)Math.Round(or.Cost * (ddif / 7)); } else { int t = 0; if ((ddif / 30) == 0) { t = 1; } or.AllSum = (float)Math.Round(or.Cost * t); } or.Debt = (float)Convert.ToDouble(or.AllSum) - (float)Convert.ToDouble(this.tbPaid.Text); IOrdersProcessDb orProcess = ProcessFactory.GetOrdersProcess(); IWageProcessDb wageProcess = ProcessFactory.GetWageProcess(); if (wageProcess.Get(or.FullNameManager.IDManager) == null) { WageDto wage = new WageDto(); IManagersProcessDb mp = ProcessFactory.GetManagersProcess(); ManagersDto manager = mp.Get(or.FullNameManager.IDManager); wage.CurrentSum = or.Cost * manager.PercentOnSale / 100; wage.Manager = or.FullNameManager; wage.Paid = 0; wage.Rest = (float)Math.Abs(Convert.ToDouble(wage.Paid - wage.CurrentSum)); wage.SumOrders = 1; wageProcess.Add(wage); } else { IManagersProcessDb mp = ProcessFactory.GetManagersProcess(); ManagersDto manager = mp.Get(or.FullNameManager.IDManager); IWageProcessDb wProcess = ProcessFactory.GetWageProcess(); WageDto wage = wProcess.Get(or.FullNameManager.IDManager); wage.CurrentSum += or.Cost * manager.PercentOnSale / 100; wage.Rest = (float)Math.Abs(Convert.ToDouble(wage.Paid - wage.CurrentSum)); wage.SumOrders += 1; wageProcess.Update(wage); } if (_id == 0) { orProcess.Add(or); } else { or.IDOrder = _id; orProcess.Update(or); } } catch (Exception exc) { return; } this.Close(); }
public void Update(WageDto wage) { _wageDao.Update(DtoConvert.Convert(wage)); }
public void Add(WageDto wage) { _wageDao.Add(DtoConvert.Convert(wage)); }
public void fillExcelTableByType(IEnumerable <object> grid, string status, FileInfo xlsxFile) { try { if (grid != null) { ExcelPackage pck = new ExcelPackage(xlsxFile); var excel = pck.Workbook.Worksheets.Add(status); int x = 1; int y = 1; CultureInfo cultureInfo = new CultureInfo(Thread.CurrentThread.CurrentCulture.Name); Thread.CurrentThread.CurrentCulture = cultureInfo; cultureInfo.NumberFormat.NumberDecimalSeparator = "."; excel.Cells["A1:Z1"].Style.Font.Bold = true; excel.Cells.Style.HorizontalAlignment = ExcelHorizontalAlignment.Left; excel.Cells.Style.Numberformat.Format = "General"; Object dtObj = new Object(); switch (status) { case "Managers": dtObj = new ManagersDto(); break; case "Enterprises": dtObj = new EnterprisesDto(); break; case "TypeReklama": dtObj = new TypeReklamaDto(); break; case "Orders": dtObj = new OrdersDto(); break; case "Carrier": dtObj = new CarrierDto(); break; case "Wage": dtObj = new WageDto(); break; } foreach (var prop in dtObj.GetType().GetProperties()) { excel.Cells[y, x].Value = prop.Name.Trim(); x++; } foreach (var item in grid) { y++; Object itemObj = item; x = 1; foreach (var prop in itemObj.GetType().GetProperties()) { object t = prop.GetValue(itemObj, null); object val; if (t == null) { val = ""; } else { val = t.ToString(); if (t is ManagersDto) { val = ((ManagersDto)t).FullName; } if (t is EnterprisesDto) { val = ((EnterprisesDto)t).NameEnterprise; } if (t is CarrierDto) { val = ((CarrierDto)t).NameCarrier; } if (t is TypeReklamaDto) { val = ((TypeReklamaDto)t).NameReklama; } } excel.Cells[y, x].Value = val; x++; } } excel.Cells.AutoFitColumns(); pck.Save(); } else { MessageBox.Show("Данные не загружены!"); } } catch (Exception exc) { // MessageBox.Show(exc.Message, "Ошибка"); } }