private void LoadSubItems(ComboBox comboBox) { var subItemList = new SubItemDAL().GetAllSubItemsForLookUp(); subItemList.ForEach(delegate(SubItemLookUp obj) { obj.SubItemDescription = obj.SubItemSerial + " - " + obj.SubItemDescription; }); var subItem = new SubItemLookUp(); subItem.SubItemDescription = "Select PLU"; subItem.SubItemID = -1; subItemList.Add(subItem); comboBox.DataSource = subItemList; comboBox.ValueMember = "SubItemID"; comboBox.DisplayMember = "SubItemDescription"; comboBox.SelectedValue = -1; }
private void textBoxSubItemNo_KeyDown(object sender, KeyEventArgs e) { try { if (e.KeyCode == Keys.Enter) { var subItem = new SubItemDAL().GetSubItemByItemSerial(textBoxSubItemNo.Text.Trim()); if (subItem != null) { SubItemID = subItem.SubItemID; textBoxSubItemNo.Text = subItem.SubItemSerial; SubItemMeasuringUnit = subItem.SubItemMeasureUnit; //textBoxSubItemMeasuringUnit.Text = new MeasuringUnitDAL().GetAllMeasuringUnitsForLookUp().Find(mu => mu.UnitID == SubItemMeasuringUnit).UnitDescription; textBoxUnitPrice.Text = subItem.SubItemUnitPrice.ToString(); SubItemDescription = subItem.SubItemDescription; //SubItemDetailBOList = new SubItemDetailDAL().GetSubItemDetailBySubItemID(SubItemID); BindDataToGridView(); } else { MessageBoxClass.ShowMessage(CommonMethods.GetError("SAL_011"), false); } } else if (e.KeyCode == Keys.Add) { e.SuppressKeyPress = true; AddItem(); } else if (e.KeyCode == Keys.F1) { buttonSubItemLookUp_Click(null, null); } SaveKeysPresed(e); } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true); } }
private void AddItem() { try { var invoiceDetailBO = new InvoiceDetailBO(); var subItem = new SubItemDAL().GetSubItemByItemSerial(textBoxSubItemNo.Text.Trim()); SubItemID = subItem.SubItemID; decimal unitPrice = subItem.SubItemUnitPrice; SubItemDescription = subItem.SubItemDescription; invoiceDetailBO.InvoiceDetailId = -1; invoiceDetailBO.InvoiceId = InvoiceID; invoiceDetailBO.ItemId = SubItemID; invoiceDetailBO.Quantity = numericUpDownQty.Value; //invoiceDetailBO.SubTotal = numericUpDownQty.Value * decimal.Parse(textBoxUnitPrice.Text); invoiceDetailBO.SubTotal = numericUpDownQty.Value * unitPrice; invoiceDetailBO.ItemSerial = textBoxSubItemNo.Text.Trim(); invoiceDetailBO.ItemDescription = SubItemDescription; var foundObject =new InvoiceDetailBO(); if (InvoiceDetailBOList != null) foundObject = InvoiceDetailBOList.Find(s => s.ItemId == SubItemID); if (foundObject !=null ) { //MessageBoxClass.ShowMessage(CommonMethods.GetError("SAL_010"), false); InvoiceDetailBOList.Find(s => s.ItemId == SubItemID).Quantity = foundObject.Quantity + invoiceDetailBO.Quantity; InvoiceDetailBOList.Find(s => s.ItemId == SubItemID).SubTotal = foundObject.SubTotal + invoiceDetailBO.SubTotal; } else { InvoiceDetailBOList.Add(invoiceDetailBO); } BindDataToGridView(); ClearInvoiceDetail(); } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true); } }
private void FillSubItemBySubItemID(int id) { try { var subItem = new SubItemDAL().GetSubItemByID(id); SubItemID = id; SubItemMeasuringUnit = subItem.SubItemMeasureUnit; textBoxUnitPrice.Text = subItem.SubItemUnitPrice.ToString(); textBoxSubItemNo.Text = subItem.SubItemSerial; //Get From the lookup method //textBoxItemMesuringUnit.Text = new MeasuringUnitDAL().GetAllMeasuringUnitsForLookUp().Find(mu => mu.UnitID == ItemMeasuringUnit).UnitDescription; } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true); } }
private void buttonSubItemLookUp_Click(object sender, EventArgs e) { try { FormLookUp objLookUp = new FormLookUp("Sub Item Look Up", CommonEnums.LookUps.subItem, this, textBoxSubItemNo.Text.Trim()); try { objLookUp.ShowDialog(); if (objLookUp.SelectedID!=null) { textBoxSubItemNo.Text = objLookUp.SelectedValue; SubItemID = int.Parse(objLookUp.SelectedID); var subItem = new SubItemDAL().GetSubItemByID(SubItemID); textBoxSubItemNo.Text = subItem.SubItemSerial; SubItemMeasuringUnit = subItem.SubItemMeasureUnit; //textBoxSubItemMeasuringUnit.Text = new MeasuringUnitDAL().GetAllMeasuringUnitsForLookUp().Find(mu => mu.UnitID == SubItemMeasuringUnit).UnitDescription; textBoxUnitPrice.Text = subItem.SubItemUnitPrice.ToString(); SubItemDescription = subItem.SubItemDescription; //SubItemDetailBOList = new SubItemDetailDAL().GetSubItemDetailBySubItemID(SubItemID); BindDataToGridView(); } } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true); } finally { objLookUp.Dispose(); } } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_008"), 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 buttonSave_Click(object sender, EventArgs e) { try { if (SubItemID > 0 && !ScreenFunctions.Update) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_020"), false); return; } DialogResult dialogResult = MessageBoxClass.ShowDialog(CommonMethods.GetError("INV_019")); if (dialogResult == DialogResult.Yes) { var subItemBO = new SubItemBO(); subItemBO.SubItemID = SubItemID; subItemBO.SubItemSerial = textBoxSubItemNo.Text.Trim(); subItemBO.SubItemDescription = textBoxSubItemDescription.Text.Trim(); subItemBO.SubItemMeasureUnit = SubItemMeasuringUnit; subItemBO.SubItemUnitPrice = numericUpDownSubItemUnitPrice.Value; foreach (DataGridViewRow row in dataGridViewSubItemDetails.Rows)//editing enable in grid view { SubItemDetailBOList.Find(s => s.Serial == row.Cells[0].Value.ToString().Trim()).QtyForUnit = decimal.Parse(row.Cells[3].Value.ToString()); } bool result = new SubItemDAL().SaveSubItem(subItemBO, SubItemDetailBOList); if (result) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_007"), false); buttonNew_Click(null, null); } else { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_006"), true); } } } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_006"), true); } }
private void buttonDelete_Click(object sender, EventArgs e) { try { var result = new SubItemDAL().DeleteSubItemByID(SubItemID); if (result) { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_015"), false); buttonNew_Click(null, null); } else { MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_014"), false); } } catch (SqlException ex) { MessageBoxClass.ShowMessage(ex.Message, false); } catch { MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true); } }