private void PurchasingDetailsForm_Load(object sender, EventArgs e) { try { FormBorderStyle = FormBorderStyle.None; WindowState = FormWindowState.Maximized; TopMost = false; using (InventoryDataContext context = new InventoryDataContext()) { GetPurchaseOrderByIdResult obj = new GetPurchaseOrderByIdResult(); PurchaseManager manager = new PurchaseManager(); obj = manager.GetPurchaseOrderById(context, PurchaseOrderId).Single(); txtBoxMetroSupplierName.Text = obj.SupplierName; txtBoxMetroStatus.Text = obj.PurchaseOrderStatus; txtBoxMetroOrderNumber.Text = obj.PurchaseOrderId.ToString(); PurchaseOrderId = obj.PurchaseOrderId; PurchaseOrderStatusId = obj.PurchaseOrderStatusId; SupplierId = obj.SupplierId; IsUpdatedToDB = obj.IsUpdatedToDB; if (obj.CustomerId != null) { CustomerId = (int)obj.CustomerId; txtBoxMetroCustomerName.Text = obj.LastName + ", " + obj.FirstName; } if (obj.OrderDate != null) { dateTimeMetroOrderDate.Value = System.Convert.ToDateTime(obj.OrderDate); } txtBoxMetroTotalAmount.Text = obj.TotalAmount.ToString(); if (!IsAddMode) { AreAllItemsReceived = System.Convert.ToBoolean(manager.CheckPurchaseProductIfReceived(context, PurchaseOrderId)); } } if (!IsAddMode) { LoadProductList(PurchaseOrderId); AddDynamicLinkOnGrid(grdMetroProduct, 13, 14); EnableHideColumnGrid(); } else { VisibleControls(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void grdMetroProduct_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (grdMetroProduct.RowCount > 0) { if (e.RowIndex >= 0) { int Id; DataGridViewRow row = grdMetroProduct.Rows[e.RowIndex]; if (grdMetroProduct.Columns[e.ColumnIndex].Name == "View/Edit") { Id = System.Convert.ToInt32(row.Cells["PurchaseProductId"].Value.ToString()); AddPurchaseProductForm form = new AddPurchaseProductForm(SupplierId, PurchaseOrderId, Id, false); form.ShowDialog(); if (!form.IsCancelUpdate) { LoadProductList(PurchaseOrderId); } } else if (grdMetroProduct.Columns[e.ColumnIndex].Name == "Delete") { if (MessageBox.Show("Are you sure do you want to delete this product?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Id = System.Convert.ToInt32(row.Cells["PurchaseProductId"].Value.ToString()); using (InventoryDataContext context = new InventoryDataContext()) { PurchaseManager manager = new PurchaseManager(); manager.DeletePurchaseProductById(context, Id); } LoadProductList(PurchaseOrderId); } } else if (grdMetroProduct.Columns[e.ColumnIndex].Name == "Change Status") { int pOrderId = System.Convert.ToInt32(row.Cells["PurchaseOrderId"].Value.ToString()); int pId = System.Convert.ToInt32(row.Cells["PurchaseProductId"].Value.ToString()); string status = row.Cells["PurchaseProductStatus"].Value.ToString(); string remarks = row.Cells["Remarks"].Value.ToString(); PurchaseProductStatusForm form = new PurchaseProductStatusForm(pOrderId, pId, status, remarks); form.ShowDialog(); if (!form.IsCancelUpdate) { using (InventoryDataContext context = new InventoryDataContext()) { PurchaseManager manager = new PurchaseManager(); GetPurchaseOrderByIdResult obj = new GetPurchaseOrderByIdResult(); obj = manager.GetPurchaseOrderById(context, PurchaseOrderId).Single(); PurchaseOrderStatusId = obj.PurchaseOrderStatusId; txtBoxMetroStatus.Text = obj.PurchaseOrderStatus.ToString(); AreAllItemsReceived = form.AreAllItemsReceived; LoadProductList(PurchaseOrderId); } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }