public static List <Order> GetOrdersByDept(Filter filter, DateTime?dateFrom = null, DateTime?dateTo = null) { var employeeId = Convert.ToInt32(HttpContext.Current.Session["EmployeeId"]); Department department = (Department)Enum.Parse(typeof(Department), HttpContext.Current.Session["Department"].ToString(), true); return(OrderLists.GetOrdersByDepartment(employeeId, department, filter, dateFrom, dateTo)); }
public ResultModel AddOrder(OrderDTO order) { ResultModel result = new ResultModel(); BookDTO book = new BookDTO { AuthorId = order.Author.Id, Title = order.Book.Title }; int bookId = AddBook(book); if (bookId > 0) { using (var transaction = _context.Database.BeginTransaction()) { try { OrderLists item = new OrderLists { Book = bookId, Cost = order.Cost, Supply = order.Supply.Id }; OrderLists item1 = (OrderLists)order; item.Book = bookId; _context.OrderLists.Add(item); Supplies supply = _context.Supplies.FirstOrDefault(c => c.Id == order.Supply.Id); double oldSumm = supply.Summ.HasValue ? supply.Summ.Value : 0; supply.Summ = oldSumm + order.Cost; _context.Entry(supply).State = EntityState.Modified; _context.SaveChanges(); transaction.Commit(); } catch (Exception ex) { result.Code = OperationStatusEnum.UnexpectedError; result.Message = ex.StackTrace; transaction.Rollback(); } } } else { result.Code = OperationStatusEnum.UnexpectedError; result.Message = "Ошибка при добавлении книги"; } return(result); }
private void ModifyPO_Load(object sender, EventArgs e) { this.BackColor = ColorTranslator.FromHtml("#d6d6d6"); this.panel1.BackColor = ColorTranslator.FromHtml("#d6d6d6"); this.btnClose.BackColor = ColorTranslator.FromHtml("#d6d6d6"); cboFilter.Items.Add("Pending"); cboFilter.Items.Add("Closed"); cboFilter.Items.Add("All"); cboFilter.SelectedIndex = 0; employee = Bismark.employee; orderList = new BindingList <Order>(OrderLists.GetOrdersByEmployeeId(employee.EmployeeId, Filter.Pending)); gdvOrders.DataSource = orderList; }
private void btnGo_Click(object sender, EventArgs e) { try { ClearFormBindings(); txtName.ResetText(); txtDescription.ResetText(); txtPrice.ResetText(); txtQuantity.ResetText(); txtJustification.ResetText(); txtSource.ResetText(); var filter = (Filter)cboFilter.SelectedIndex; if (string.IsNullOrEmpty(txtOrderId.Text)) { if (chkDateRange.Checked) { orderList = new BindingList <Order>(OrderLists.GetOrdersByEmployeeId(employee.EmployeeId, filter, dtpFrom.Value, dtpTo.Value)); } else { orderList = new BindingList <Order>(OrderLists.GetOrdersByEmployeeId(employee.EmployeeId, filter)); } } else { orderList = new BindingList <Order>(); orderList.Add(Order.Create(employee.EmployeeId, Convert.ToInt32(txtOrderId.Text))); } if (orderList != null && orderList.Count > 0) { gdvOrders.DataSource = orderList; gdvOrders.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; gdvOrders.Columns["GrandTotal"].DefaultCellStyle.Format = "c"; gdvOrders.Columns["EmployeeId"].Visible = false; gdvOrders.Columns["SubTotal"].Visible = false; gdvOrders.Columns["TaxTotal"].Visible = false; gdvOrders.Columns["IsComplete"].Visible = false; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Bismark", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnGo_Click(object sender, EventArgs e) { gdvOrders.DataSource = null; gdvItems.DataSource = null; txtSubTotal.Text = string.Empty; txtTaxTotal.Text = string.Empty; txtGrandTotal.Text = string.Empty; var filter = (Filter)cboFilter.SelectedIndex; try { if (rdoDepartment.Checked) { if (!chkDateRange.Checked) { orderList = new BindingList <Order>(OrderLists.GetOrdersByDepartment(employee.EmployeeId, employee.JobAssignment.Department, filter)); } else { orderList = new BindingList <Order>(OrderLists.GetOrdersByDepartment(employee.EmployeeId, employee.JobAssignment.Department, filter, dtpFrom.Value, dtpTo.Value)); } } else if (rdoEmployee.Checked) { var firstName = txtFirstName.Text; var lastName = txtLastName.Text; if (!chkDateRange.Checked) { orderList = new BindingList <Order>(OrderLists.GetOrdersByEmployeeName(employee.EmployeeId, employee.JobAssignment.Department, filter, firstName, lastName)); } else { orderList = new BindingList <Order>(OrderLists.GetOrdersByEmployeeName(employee.EmployeeId, employee.JobAssignment.Department, filter, firstName, lastName, dtpFrom.Value, dtpTo.Value)); } } else if (rdoOrderId.Checked) { var orderId = Convert.ToInt32(txtOrderId.Text); orderList = new BindingList <Order>(); orderList.Add(Order.Create(employee.EmployeeId, orderId)); } if (orderList.Count > 0) { gdvOrders.DataSource = orderList; gdvOrders.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; gdvOrders.Columns["GrandTotal"].DefaultCellStyle.Format = "c"; gdvOrders.Columns["EmployeeId"].Visible = false; gdvOrders.Columns["SubTotal"].Visible = false; gdvOrders.Columns["TaxTotal"].Visible = false; gdvOrders.Columns["IsComplete"].Visible = false; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Bismark", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static List <Order> GetOrdersByEmployeeId(Filter filter, DateTime?dateFrom = null, DateTime?dateTo = null) { var employeeId = Convert.ToInt32(HttpContext.Current.Session["EmployeeId"]); return(OrderLists.GetOrdersByEmployeeId(employeeId, filter, dateFrom, dateTo)); }