private void OrderForm_FormClosed(object sender, FormClosedEventArgs e)
{
orderFormClosed = true;
profileForm.Activate();
if (newOrder && submitted)
{
DisplayPickingList();
profileForm.setupListView();
}
if (newOrder && !submitted)
{
OrderItemController itemCont = new OrderItemController(order.OrderNum);
ProductController prodCont = new ProductController();
Collection <OrderItem> items = itemCont.AllOrderItems;
foreach (OrderItem item in items)
{
prodCont.Unreserve(item.ProductNum, item.Quantity);
}
prodCont.Refresh();
itemCont.DeleteOrder();
profileForm.setupListView();
}
submitted = false;
}
private void LoadItem(string orderNo)
{
DataTable dtOrderItem = new DataTable("ORDERS_ITEM");
dtOrderItem = OrderItemController.GetOrderItems(orderNo, "N");
gvDt.DataSource = dtOrderItem;
}
public AddItemForm(Order order, OrderItem orderItem, OrderForm orderForm)
{
InitializeComponent();
PopulateForm(order, orderItem, orderForm);
prodCont = new ProductController();
itemCont = new OrderItemController(order.OrderNum);
}
private void LoadDetail()
{
dtOrderItem = new DataTable("ORDERS_ITEM");
dtOrderItem = OrderItemController.GetOrderItems(orderNo, "Y");
gv.DataSource = dtOrderItem;
gv.Columns["seq"].Visible = false;
gv.Columns["issue_unit_method"].Visible = false;
gv.Columns["unit_code"].Visible = false;
gv.Columns["unload_qty"].Visible = false;
gv.Columns["unload_wgh"].Visible = false;
}
private void LoadDetail()
{
dtOrderItem = new DataTable("ORDERS_ITEM");
dtOrderItem = OrderItemController.GetOrderItems(orderNo, "Y");
gv.DataSource = dtOrderItem;
gv.Columns[ConstColumns.SEQ].Visible = false;
gv.Columns[ConstColumns.ISSUE_UNIT_METHOD].Visible = false;
gv.Columns[ConstColumns.UNLOAD_QTY].Visible = false;
gv.Columns[ConstColumns.UNIT_CODE_QTY].Visible = false;
gv.Columns[ConstColumns.UNLOAD_WGH].Visible = false;
gv.Columns[ConstColumns.UNIT_CODE_WGH].Visible = false;
}
private void LoadOrderData()
{
OrderItemController orderItemController = new OrderItemController();
int currentRow = 0;
if (OrderGrid.CurrentRow != null)
{
currentRow = OrderGrid.CurrentRow.Index;
}
OrderGrid.DataSource = orderItemController.GetAllByOrderId((int)_order.id);
SetUpGrid();
if (OrderGrid.Rows.Count > 0)
{
if (OrderGrid.Rows.Count > currentRow)
{
OrderGrid.CurrentCell = OrderGrid.Rows[currentRow].Cells[0];
}
else
{
OrderGrid.CurrentCell = OrderGrid.Rows[0].Cells[0];
}
}
if (!Convert.ToBoolean(_order.complete))
{
ToolStripCompleteOrderButton.Enabled = OrderGrid.Rows.Count != 0;
ToolStripRemItemButton.Enabled = OrderGrid.Rows.Count != 0;
RemoveItemToolStripMenuItem.Enabled = OrderGrid.Rows.Count != 0;
ToolStripEditItemButton.Enabled = OrderGrid.Rows.Count != 0;
EditItemToolStripMenuItem.Enabled = OrderGrid.Rows.Count != 0;
}
else
{
ToolStripCompleteOrderButton.Enabled = false;
ToolStripRemItemButton.Enabled = false;
RemoveItemToolStripMenuItem.Enabled = false;
ToolStripEditItemButton.Enabled = false;
EditItemToolStripMenuItem.Enabled = false;
toolStripCancelButton.Enabled = false;
ToolStripAddItemButton.Enabled = false;
OrderGrid.Enabled = false;
}
ShowTotal();
}
private void LoadDetail()
{
if (String.IsNullOrEmpty(this.invoiceNo))
{
dtInvoiceItem = new DataTable("INVOICE_ITEM");
dtInvoiceItem = OrderItemController.GetOrderItemReadyToSell(this.orderNo);
if (dtInvoiceItem.Rows.Count > 0)
{
decimal unitPrice;
decimal unitPriceCurrent;
decimal discPer;
//decimal discountPer;
Product product;
for (int i = 0; i < dtInvoiceItem.Rows.Count; i++)
{
string productCode = dtInvoiceItem.Rows[i][ConstColumns.PRODUCT_CODE].ToString();
unitPrice = Globals.GetPriceList(cboCustomer.SelectedValue.ToString(), productCode, dtpInvoiceDate.Value);
unitPriceCurrent = unitPrice; // Globals.GetPriceListCurrent(cboCustomer.SelectedValue.ToString(), productCode, dtpInvoiceDate.Value);
discPer = 0; //Globals.GetDiscountPer(cboCustomer.SelectedValue.ToString(), dtpInvoiceDate.Value);
product = ProductController.GetProduct(productCode);
dtInvoiceItem.Rows[i][ConstColumns.UNIT_PRICE_CURRENT] = unitPriceCurrent;
dtInvoiceItem.Rows[i][ConstColumns.DISC_PER] = discPer;
dtInvoiceItem.Rows[i][ConstColumns.UNIT_PRICE] = unitPrice;
dtInvoiceItem.Rows[i][ConstColumns.SALE_UNIT_METHOD] = product.SaleUnitMethod;
if (dtInvoiceItem.Rows[i][ConstColumns.SALE_UNIT_METHOD].ToString() == "Q")
{
dtInvoiceItem.Rows[i][ConstColumns.GROSS_AMT] = Convert.ToDecimal(dtInvoiceItem.Rows[i][ConstColumns.UNIT_PRICE]) * Convert.ToDecimal(dtInvoiceItem.Rows[i][ConstColumns.QTY]);
}
else
{
dtInvoiceItem.Rows[i][ConstColumns.GROSS_AMT] = Convert.ToDecimal(dtInvoiceItem.Rows[i][ConstColumns.UNIT_PRICE]) * Convert.ToDecimal(dtInvoiceItem.Rows[i][ConstColumns.WGH]);
}
}
dtInvoiceItem.AcceptChanges();
gv.Refresh();
}
Calculate_Total();
}
else
{
dtInvoiceItem = new DataTable("INVOICE_ITEM");
dtInvoiceItem = InvoiceItemController.GetInvoiceItems(this.invoiceNo);
}
gv.DataSource = dtInvoiceItem;
}
public void Should_Return_BadRequest_When_GetAll_And_An_Error_Occurs()
{
var fakeRepository = _fakes.FakeOrderItemRepository(true).Object;
var service = new OrderItemService(_fakes.Mapper, fakeRepository);
var controller = new OrderItemController(_fakes.Mapper, service);
var actual = controller.GetAll();
Assert.NotNull(actual);
Assert.IsType <ObjectResult>(actual.Result);
var result = actual.Result as ObjectResult;
Assert.NotNull(result.Value);
Assert.IsType <Response>(result.Value);
Assert.Equal(Responses.StatusCode(HttpStatusCode.BadRequest), result.StatusCode);
}
public void Should_Return_NotFound_When_Delete_With_An_Incorrect_Id()
{
var id = 0; // Does not exist!
var fakeRepository = _fakes.FakeOrderItemRepository().Object;
var service = new OrderItemService(_fakes.Mapper, fakeRepository);
var controller = new OrderItemController(_fakes.Mapper, service);
var actual = controller.Delete(id);
Assert.NotNull(actual);
Assert.IsType <ObjectResult>(actual.Result);
var result = actual.Result as ObjectResult;
Assert.NotNull(result.Value);
Assert.IsType <Response>(result.Value);
Assert.Equal(Responses.StatusCode(HttpStatusCode.NotFound), result.StatusCode);
}
public async Task OrderItemController_GetOrderItems_Ok()
{
var db = _builder
.ConfigureInMemory()
.AddTenOrderItems()
.Build();
var repository = new Repository <Models.OrderItem>(db);
var controller = new OrderItemController(repository);
var response = (await controller.GetOrderItems())
.Result as OkObjectResult;
var values = response.Value as List <Models.OrderItem>;
values.Count.Should().Be(10);
}
public async Task OrderItemController_CreateOrderItem_Ok()
{
var db = _builder
.ConfigureInMemory()
.Build();
var repository = new Repository <Models.OrderItem>(db);
var controller = new OrderItemController(repository);
var newOrderItem = A.New <Models.OrderItem>();
var response = (await controller.PostOrderItem(newOrderItem))
.Result as OkObjectResult;
var values = Convert.ToInt32(response.Value);
values.Should().Be(newOrderItem.Id);
}
public void Should_Return_Ok_When_GetAllByOrderId()
{
var orderId = 1;
var fakeRepository = _fakes.FakeOrderItemRepository().Object;
var service = new OrderItemService(_fakes.Mapper, fakeRepository);
var controller = new OrderItemController(_fakes.Mapper, service);
var actual = controller.GetAllByOrderId(orderId);
Assert.NotNull(actual);
Assert.IsType <ObjectResult>(actual.Result);
var result = actual.Result as ObjectResult;
Assert.NotNull(result.Value);
Assert.IsType <Response>(result.Value);
Assert.Equal(Responses.StatusCode(HttpStatusCode.OK), result.StatusCode);
}
private void btnAddItem_Click(object sender, EventArgs e)
{
OrderItemController itemCont = new OrderItemController(order.OrderNum);
OrderItem item = new OrderItem();
item.OrderItemNum = itemCont.NextID;
if (itemForm == null || itemForm.itemFormClosed)
{
itemForm = new AddItemForm(order, item, this);
itemForm.MdiParent = this.mainForm;
itemForm.StartPosition = FormStartPosition.CenterScreen;
itemForm.Show();
}
else
{
itemForm.PopulateForm(order, item, this);
}
itemListView.Refresh();
}
public async Task OrderItemController_DeleteOrderItem_Ok()
{
var db = _builder
.ConfigureInMemory()
.AddTenOrderItems()
.Build();
var repository = new Repository <Models.OrderItem>(db);
var controller = new OrderItemController(repository);
var OrderItem = db.OrderItems.Find(1);
var response = (await controller.DeleteOrderItem(OrderItem.Id))
.Result as OkObjectResult;
var values = Convert.ToBoolean(response.Value);
values.Should().Be(true);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cboSeller.SelectedIndex > -1)
{
if (txtPrice.Text.Trim().Length > 0)
{
OrderItem orderItem = new OrderItem();
double price;
int sellerId;
double.TryParse(txtPrice.Text.Replace("$", ""), out price);
int.TryParse(cboSeller.SelectedValue.ToString(), out sellerId);
orderItem.price = price;
orderItem.sellerId = sellerId;
orderItem.description = txtDesc.Text;
orderItem.id = OrderItemId;
if (orderItem.IsValid)
{
OrderItemController orderItemController = new OrderItemController();
orderItemController.Edit(orderItem);
this.Close();
}
else
{
MessageBox.Show(orderItem.Validator().ErrorMessage, "Invalid Data", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Please enter a price.", "Invalid Data", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtPrice.Focus();
}
}
else
{
MessageBox.Show("Please enter a valid seller.", "Invalid Seller", MessageBoxButtons.OK, MessageBoxIcon.Information);
cboSeller.Focus();
}
}
public void DisplayPickingList()
{
OrderItemController itemCont = new OrderItemController(order.OrderNum);
ProductController prodCont = new ProductController();
Collection <OrderItem> items = itemCont.AllOrderItems;
string message = "Product No. \t Qty \t Shelf";
foreach (OrderItem item in items)
{
Product product = prodCont.FindByID(item.ProductNum);
if (product != null)
{
message += "\n" + product.ProductNum.ToString() +
" \t\t " + item.Quantity.ToString() +
" \t " + product.Shelf.ToString();
}
}
MessageBox.Show(message, "Picking List");
}
private void LoadDetail()
{
DataTable dtOrdersIteemItem = new DataTable("ORDERS_ITEM");
dtOrdersIteemItem = OrderItemController.GetOrderItems(orderNo, "N");
gvSo.DataSource = dtOrdersIteemItem;
gvSo.Columns[0].Visible = false;
if (String.IsNullOrEmpty(txtProductSlipNo.Text))
{
dtProductSlipItem = new DataTable("PRODUCT_SLIP_ITEM");
dtProductSlipItem = ProductSlipItemController.GetProductSlipItemByOrderNo(orderNo, dtpProductSlipDate.Value);
gv.DataSource = dtProductSlipItem;
}
else
{
dtProductSlipItem = new DataTable("PRODUCT_SLIP_ITEM");
dtProductSlipItem = ProductSlipItemController.GetProductSlipItem(txtProductSlipNo.Text);
gv.DataSource = dtProductSlipItem;
}
}
private void ToolStripRemItemButton_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("Are you sure you wish to remove this item?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
if (OrderGrid.SelectedRows != null && OrderGrid.SelectedRows.Count > 0)
{
int orderItemId;
int.TryParse(OrderGrid.SelectedRows[0].Cells[3].Value.ToString(), out orderItemId);
if (orderItemId > 0)
{
OrderItemController orderItemController = new OrderItemController();
orderItemController.Remove(orderItemId);
LoadOrderData();
}
}
}
}
private void LoadDataDetail(string orderNo)
{
DataTable dt = new DataTable();
dt = OrderItemController.GetOrderItemReadyToSell(orderNo);
gvDt.DataSource = dt;
gvDt.Columns[0].HeaderText = "ลำดับ";
gvDt.Columns[1].HeaderText = "รหัสสินค้า";
gvDt.Columns[2].HeaderText = "ชื่อสินค้า";
gvDt.Columns[3].HeaderText = "หน่วยคำนวณ";
gvDt.Columns[4].HeaderText = "ปริมาณ";
gvDt.Columns[5].HeaderText = "น้ำหนัก";
gvDt.Columns[6].HeaderText = "ปริมาณจ่าย";
gvDt.Columns[7].HeaderText = "น้ำหนักจ่าย";
gvDt.Columns[8].HeaderText = "ราคาต่อหน่วย";
gvDt.Columns[9].HeaderText = "ราคา";
gvDt.Columns[1].Visible = false;
gvDt.Columns[3].Visible = false;
gvDt.Columns[8].Visible = false;
gvDt.Columns[9].Visible = false;
}
public async Task OrderItemController_UpdateOrderItem_Ok()
{
var db = _builder
.ConfigureInMemory()
.AddOrderItem()
.Build();
var repository = new Repository <Models.OrderItem>(db);
var controller = new OrderItemController(repository);
var updateOrderItem = db.OrderItems.Find(1);
updateOrderItem.Quantity = 15;
var response = (await controller.PutOrderItem(updateOrderItem))
.Result as OkObjectResult;
var values = Convert.ToBoolean(response.Value);
values.Should().Be(true);
}
public void setupListView()
{
submitted = false;
ListViewItem itemListItem;
OrderItemController itemCont = new OrderItemController(order.OrderNum);
ProductController prodCont = new ProductController();
Collection <OrderItem> items = itemCont.AllOrderItems;
itemListView.Clear();
itemListView.Columns.Insert(0, "Product No.", 150, HorizontalAlignment.Left);
itemListView.Columns.Insert(1, "Product Name", 350, HorizontalAlignment.Left);
itemListView.Columns.Insert(2, "Product Price", 100, HorizontalAlignment.Left);
itemListView.Columns.Insert(3, "Quantity", 100, HorizontalAlignment.Left);
itemListView.Columns.Insert(4, "Product Total", 100, HorizontalAlignment.Left);
decimal totalPrice = 0;
foreach (OrderItem item in items)
{
itemListItem = new ListViewItem();
Product product = prodCont.FindByID(item.ProductNum);
if (product != null)
{
decimal productTotal = item.Quantity * product.Price;
totalPrice += productTotal;
itemListItem.Text = product.ProductNum.ToString();
itemListItem.SubItems.Add(product.Name);
itemListItem.SubItems.Add(product.Price.ToString());
itemListItem.SubItems.Add(item.Quantity.ToString());
itemListItem.SubItems.Add(productTotal.ToString());
itemListView.Items.Add(itemListItem);
}
}
TotalLabel.Text = totalPrice.ToString();
itemListView.Refresh();
itemListView.GridLines = true;
}
private void Gv_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
DataGridView senderGrid = (DataGridView)sender;
string orderNo = gv.Rows[e.RowIndex].Cells[ConstColumns.ORDER_NO].Value.ToString();
if ((senderGrid.Columns[e.ColumnIndex] is DataGridViewImageColumn || senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn) && e.RowIndex >= 0)
{
switch (senderGrid.Columns[e.ColumnIndex].Name)
{
case "Edit":
var frm = new Form_OrderAddEdit
{
orderNo = orderNo
};
if (frm.ShowDialog() == DialogResult.OK)
{
LoadOrder();
}
break;
case "Print":
break;
case ConstColumns.BTN_INVOICE:
string invocieFlag = gv.Rows[e.RowIndex].Cells[ConstColumns.INVOICE_FLAG].Value.ToString();
if (invocieFlag == "1")
{
return;
}
bool pickingCompleteFlag = OrderItemController.CheckPickingComplete(orderNo);
if (pickingCompleteFlag == false)
{
DialogResult result = MessageBox.Show("จำนวนสินยังไม่ครบตามใบสั่งขาย ท่านยังต้องขายใช่ไหม", "Warning ", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
var frmInv = new Form_InvoiceAddEdit
{
orderNo = orderNo
};
if (frmInv.ShowDialog() == DialogResult.OK)
{
LoadOrder();
}
}
else
{
LoadItem(orderNo);
return;
}
}
else
{
var frmInv = new Form_InvoiceAddEdit
{
orderNo = orderNo
};
if (frmInv.ShowDialog() == DialogResult.OK)
{
LoadOrder();
}
}
break;
case ConstColumns.BTN_PRODUCT_SLIP:
var frmSlip = new Form_ProductSlip
{
orderNo = orderNo,
};
if (frmSlip.ShowDialog() == DialogResult.OK)
{
LoadOrder();
}
break;
}
}
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewLinkColumn)
{
LoadItem(orderNo);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public OrderItemControllerTest()
{
_orderItemController = new OrderItemController(
new NorthwindUniOftWork(ConfigSettings.NorthwindConnectionString)
);
}
