コード例 #1
0
ファイル: ReportMain.cs プロジェクト: anushkaD/AnushkaPrivate
        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;
        }
コード例 #2
0
        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);
            }
        }
コード例 #3
0
        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);
            }
        }
コード例 #4
0
        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);
            }
        }
コード例 #5
0
        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);
            }
        }
コード例 #6
0
ファイル: FormLookUp.cs プロジェクト: anushkaD/AnushkaPrivate
        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;
            }
        }
コード例 #7
0
ファイル: SubItem.cs プロジェクト: anushkaD/AnushkaPrivate
        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);
            }
        }
コード例 #8
0
ファイル: SubItem.cs プロジェクト: anushkaD/AnushkaPrivate
        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);
            }
        }