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));
}
