private void buttonSave_Click(object sender, EventArgs e) { bool hasError = false; foreach (DataGridViewRow row in dataGridViewItems.Rows) { var item = new ItemBO(); item.ItemID = int.Parse(row.Cells[0].Value.ToString()); item.QtyInHand = decimal.Parse(row.Cells[4].Value.ToString()); var result =new ItemDAL().UpdateQuantityInHand(item); if (!result) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_021"), false); hasError = true; return; } } if (!hasError) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_022"), false); } }
private void buttonDelete_Click(object sender, EventArgs e) { try { var result = new ItemDAL().DeleteItemByID(ItemID); if (result) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_017"), false); button1_Click(null, null); } else { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_016"), false); } } catch (SqlException ex) { MessageBoxClass.ShowMessage(ex.Message, false); } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true); } }
private void timerInventoryCheck_Tick(object sender, EventArgs e) { try { var list = new ItemDAL().CheckInventory(); if (list.Count > 0) { toolStripStatusLabelInventory.Text = list.Count + " items have have reached the break even point click hear for more details"; } else { toolStripStatusLabelInventory.Text = string.Empty; } } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true); } }
private void statusStrip_ItemClicked(object sender, ToolStripItemClickedEventArgs e) { if (e.ClickedItem.Name.Equals("toolStripStatusLabelInventory")) { var list = new ItemDAL().CheckInventory(); if (!FormOpen(new ItemInventory(null))) { ItemInventory formItemInventory = new ItemInventory(list); formItemInventory.MdiParent = this; FormMain = this; formItemInventory.Show(); } } }
private void textBoxItemNo_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { var item = new ItemDAL().GetItemByItemNo(textBoxItemNo.Text.Trim()); ItemID = item.ItemID; if (ItemID > 0) { FillItemByItemID(ItemID); } else { buttonItemLookUp_Click(null, null); } } else if (e.KeyCode == Keys.F1) { buttonItemLookUp_Click(null, null); } SaveKeysPresed(e); }
private void FillItemByItemID(int id) { var item =new ItemDAL().GetItemByID(id); ItemID = id; MeasuringUnit = item.MeasuringUnit; textBoxItemNo.Text = item.ItemSerial; textBoxItemDescription.Text = item.Description; //Get From the lookup method textBoxMeasuringUnit.Text = new MeasuringUnitDAL().GetAllMeasuringUnitsForLookUp().Find(mu => mu.UnitID==MeasuringUnit).UnitDescription; numericUpDownBreakEvenPoint.Value = item.BreakEven; numericUpDownQtyInHand.Value = item.QtyInHand; numericUpDownUnitPrice.Value = item.UnitPrice; }
private void buttonSave_Click(object sender, EventArgs e) { try { if (ItemID > 0 && !ScreenFunctions.Update) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_020"), false); return; } DialogResult dialogResult = MessageBoxClass.ShowDialog(CommonMethods.GetError("INV_018")); if (dialogResult == DialogResult.Yes) { if (CommonMethods.IsEmpty(textBoxItemDescription.Text)) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_001"), false); return; } if (CommonMethods.IsEmpty(textBoxItemNo.Text)) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_002"), false); return; } if (CommonMethods.IsEmpty(textBoxMeasuringUnit.Text)) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_003"), false); return; } var item = new ItemBO(); if (ItemID > 0) item.ItemID = ItemID; else item.ItemID = -1; item.ItemSerial = textBoxItemNo.Text.Trim(); item.MeasuringUnit = MeasuringUnit; item.QtyInHand = numericUpDownQtyInHand.Value; item.UnitPrice = numericUpDownUnitPrice.Value; item.BreakEven = numericUpDownBreakEvenPoint.Value; item.CreatedUser = 0; item.Description = textBoxItemDescription.Text.Trim(); var objItemDAL = new ItemDAL(); bool result = objItemDAL.AddItem(item); if (result) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_004"), false); button1_Click(null, null); } else { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_005"), false); } } } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true); } }
private void treeViewReports_AfterSelect(object sender, TreeViewEventArgs e) { reportViewerMain.Clear(); reportViewerMain.LocalReport.DataSources.Clear(); reportViewerMain.RefreshReport(); reportViewerMain.Reset(); panelRefundReport.Visible = false; panelSalesByPlu.Visible = false; if (e.Node.Name == "dailySalesNode") { tableLayoutPanelReport.RowStyles[0].Height = 0; DateTime sysDate = new DayProcessDAL().GetCurrentDayProcessDate(); DataSet ds = new InvoiceDAL().GetDailySalesReport(sysDate, sysDate); tableLayoutPanelReport.Visible = true; LoadDailySalesReport(ds, sysDate, sysDate); } if (e.Node.Name == "DailyInventoryNode") { tableLayoutPanelReport.RowStyles[0].Height = 0; DataSet ds = new ItemDAL().GetAllItemsReport(); tableLayoutPanelReport.Visible = true; LoadInventoryReport(ds); } if (e.Node.Name == "SalesbyPLUNode") { tableLayoutPanelReport.RowStyles[0].Height = 10; panelReportForm.Controls.Add(panelSalesByPlu); panelSalesByPlu.Dock = DockStyle.Fill; panelSalesByPlu.Visible = true; LoadSubItems(comboBoxSubItems); tableLayoutPanelReport.Visible = true; } if (e.Node.Name == "RefundNode") { tableLayoutPanelReport.RowStyles[0].Height = 20; panelReportForm.Controls.Add(panelRefundReport); panelRefundReport.Dock = DockStyle.Fill; panelRefundReport.Visible = true; LoadSubItems(comboBoxRefundItem); tableLayoutPanelReport.Visible = true; } }
private void SetLookUp(string lookupName) { try { Name = lookupName.Trim(); if (LookUpType.Equals(CommonEnums.LookUps.Item)) { ItemList = new ItemDAL().GetAllItemsForLookUp(); dataGridViewLookUpData.DataSource = ItemList; } else if (LookUpType.Equals(CommonEnums.LookUps.MeasuringUnit)) { measuringUnitList = new MeasuringUnitDAL().GetAllMeasuringUnitsForLookUp(); dataGridViewLookUpData.DataSource = measuringUnitList; } else if (LookUpType.Equals(CommonEnums.LookUps.user)) { userList = new UserDAL().GetAllUsersForLookUp(); dataGridViewLookUpData.DataSource = userList; } else if (LookUpType.Equals(CommonEnums.LookUps.subItem)) { subItemList = new SubItemDAL().GetAllSubItemsForLookUp(); dataGridViewLookUpData.DataSource = subItemList; } else if (LookUpType.Equals(CommonEnums.LookUps.role)) { roleList = new RoleDAL().GetRolesLookUp(); dataGridViewLookUpData.DataSource = roleList; } else if (LookUpType.Equals(CommonEnums.LookUps.screen)) { screenList = new ScreenDAL().LoadScreensForLookUp(); dataGridViewLookUpData.DataSource = screenList; } else if (LookUpType.Equals(CommonEnums.LookUps.invoice)) { invoiceList = new InvoiceDAL().LoadAllInvoicesForLookUp(); dataGridViewLookUpData.DataSource = invoiceList; } CellResize(); PopulateCombo(); if (!string.IsNullOrEmpty(InitialValue)) { textBoxValue.Text = InitialValue; buttonFind_Click(null, null); } } catch (Exception ex) { throw ex; } }
private void textBoxItemNo_KeyDown(object sender, KeyEventArgs e) { try { if (e.KeyCode == Keys.F1) { buttonItemLookUp_Click(null, null); } else if (e.KeyCode == Keys.Enter) { var item = new ItemDAL().GetItemByItemNo(textBoxItemNo.Text.Trim()); ItemID = item.ItemID; FillItemByItemID(ItemID); } SaveKeysPresed(e); } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true); } }
private void FillItemByItemID(int id) { try { var item = new ItemDAL().GetItemByID(id); ItemID = id; ItemMeasuringUnit = item.MeasuringUnit; textBoxItemNo.Text = item.ItemSerial; textBoxItemDescription.Text = item.Description; //Get From the lookup method textBoxItemMesuringUnit.Text = new MeasuringUnitDAL().GetAllMeasuringUnitsForLookUp().Find(mu => mu.UnitID == ItemMeasuringUnit).UnitDescription; numericUpDownQtyAllocated.Value = 1; } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true); } }