private void ResetTransaction() { NewEntryVM.ResetEntryFields(); NewEntryVM.NewEntryWarehouse = null; IsTransactionNotPaid = true; NotEditMode = true; IsTransactionTaxCheckBoxSelected = false; Model = new PurchaseTransaction(); TransactionSupplier = null; TransactionDOID = null; TransactionTax = 0; TransactionDiscount = 0; TransactionNote = null; TransactionDate = UtilityMethods.GetCurrentDate().Date; TransactionDueDate = UtilityMethods.GetCurrentDate().Date; Warehouses.Clear(); SupplierItems.Clear(); DisplayedLines.Clear(); UpdateSuppliers(); OnPropertyChanged("TransactionGrossTotal"); OnPropertyChanged("TransactionNetTotal"); SetTransactionID(); }
public int AddSupplierItems(SupplierItems SI) { dbCon.openCon(); cmd = new SqlCommand("insert into supplier_items (item_id,sup_id,item_type) values('" + SI.SupItem_Id + "','" + SI.Sup_Id + "','" + SI.ItemType + "')", dbCon.con); int status = cmd.ExecuteNonQuery(); dbCon.closeCon(); return(status); }
private void UpdateSupplierItems() { SupplierItems.Clear(); using (var context = new ERPContext()) { var items = context.Inventory.Include("Suppliers").Where(item => item.IsActive).OrderBy(item => item.Name).ToList(); foreach (var item in items.Where(item => item.IsActive && item.Suppliers.Contains(_transactionSupplier.Model))) { SupplierItems.Add(new ItemVM { Model = item }); } } }
public void ResetFields() { selectedItem = null; selectedSupplier = null; selectedTemplateItem = null; SupplierItems.Clear(); TemplateItems.Clear(); systemName = ""; tenderName = ""; location = ""; templateCode = ""; templateRemark = ""; discount = 0; discountedCost = 0; totalCost = 0; }
private void btn_SupReg_Click(object sender, EventArgs e) { try { if (String.IsNullOrEmpty(txt_SupName.Text)) { MetroMessageBox.Show(this, "\n\nPlease enter Supplier Name", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (String.IsNullOrEmpty(txt_Add.Text)) { MetroMessageBox.Show(this, "\n\nPlease enter Supplier Address", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (String.IsNullOrEmpty(txt_Email.Text)) { MetroMessageBox.Show(this, "\n\nPlease enter Supplier Email Address", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (String.IsNullOrEmpty(txt_Contact.Text)) { MetroMessageBox.Show(this, "\n\nPlease enter Supplier Contact Number", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (txt_SupName.Text.Any(Char.IsDigit)) { MetroFramework.MetroMessageBox.Show(this, "Please enter letter only for Name!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (txt_Contact.Text.Any(Char.IsLetter)) { MetroFramework.MetroMessageBox.Show(this, "Cannot enter letters for contact number.enter numbers only!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (txt_Contact.Text.Length != 10) { MetroFramework.MetroMessageBox.Show(this, "Contact Number should be 10 digits!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (chk_But.Checked == false && chk_cut.Checked == false && chk_Lether.Checked == false && chk_sew.Checked == false) { MetroFramework.MetroMessageBox.Show(this, "Please select at least one Item type", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { Supplier supplier = new Supplier(); // new supplier object created and get values to variables supplier.Sup_Id = txt_SupId.Text.ToString(); supplier.Sup_Name = txt_SupName.Text.ToString(); supplier.Address = txt_Add.Text.ToString(); supplier.Email = txt_Email.Text.ToString(); supplier.ContactNo = txt_Contact.Text.ToString(); SupplierItems suppItem = new SupplierItems(); suppItem.Sup_Id = txt_SupId.Text.ToString(); SupplierDBaccess SA = new SupplierDBaccess(); int Status = SA.createSupplier(supplier); if (Status == 1) { if (chk_cut.Checked) { suppItem.SupItem_Id = SA.GetSuppItemId(); suppItem.ItemType = lb_cut.Text; SA.AddSupplierItems(suppItem); } if (chk_sew.Checked) { suppItem.SupItem_Id = SA.GetSuppItemId(); suppItem.ItemType = lb_sew.Text; SA.AddSupplierItems(suppItem); } if (chk_But.Checked) { suppItem.SupItem_Id = SA.GetSuppItemId(); suppItem.ItemType = lb_But.Text; SA.AddSupplierItems(suppItem); } if (chk_Lether.Checked) { suppItem.SupItem_Id = SA.GetSuppItemId(); suppItem.ItemType = lb_Lether.Text; SA.AddSupplierItems(suppItem); } MetroMessageBox.Show(this, "\n\nYou were registerd succesfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); txt_SupName.Clear(); txt_Add.Clear(); txt_Email.Clear(); txt_Contact.Clear(); chk_But.Checked = false; chk_cut.Checked = false; chk_Lether.Checked = false; chk_sew.Checked = false; } else { MetroMessageBox.Show(this, "\n\nRegistation Fail", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } DataTable dt = SA.getAllSuppliers(); Grid_sup.DataSource = dt; txt_SupId.Text = SA.GetSupplierId(); } } catch (SqlException) { MetroMessageBox.Show(this, "\n\nConnecton Failed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (FormatException) { MetroMessageBox.Show(this, "\n\nInvalid Format", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (OutOfMemoryException) { MetroMessageBox.Show(this, "\n\nInsuffisent memory", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception) { MetroMessageBox.Show(this, "\n\nERROR", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } }