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);
}
}
