private void refreshitems()
{
DataTable dtsup = SupplierDB.GetData();
int nindex = Convert.ToInt32(bindingNavigatorSup.PositionItem.Text) - 1;
txtSupId.Text = dtsup.Rows[nindex]["SupplierId"].ToString();
txtSupName.Text = dtsup.Rows[nindex]["SupName"].ToString();
dgvSups.DataSource = SupplierDB.GetData();
if (dgvSups.DataSource != null)
{
for (int i = 0; i < dgvSups.Rows.Count; i++)
{
dgvSups.Rows[i].Selected = false;
dgvSups.Rows[i].DefaultCellStyle.BackColor = Color.White;
}
if (nindex < dgvSups.Rows.Count)
{
dgvSups.Rows[nindex].Selected = true;
dgvSups.Rows[nindex].DefaultCellStyle.BackColor = Color.LightYellow;
}
}
}
private void SupplierFrm_Load(object sender, EventArgs e)
{
BindingSource supbindsource = new BindingSource();
supbindsource.DataSource = SupplierDB.GetData();
bindingNavigatorSup.BindingSource = supbindsource;
refreshitems();
}
private void BindingNavigatorAddNewItem_Click(object sender, EventArgs e)
{
BindingSource supbindsource = new BindingSource();
supbindsource.DataSource = SupplierDB.GetData();
bindingNavigatorSup.BindingSource = supbindsource;
txtSupId.Text = "-1";
txtSupName.Text = "";
}
private void BindingNavigatorDeleteItem_Click(object sender, EventArgs e)
{
if (Validation())
{
if (txtSupId.Text == "-1" || txtSupId.Text == "")
{
CustMesg msgfrm = new CustMesg();
msgfrm.Showmsg("Not a valid Supplier!");
msgfrm.Show();
refreshitems();
BindingSource supbindsource = new BindingSource();
supbindsource.DataSource = SupplierDB.GetData();
bindingNavigatorSup.BindingSource = supbindsource;
//MessageBox.Show("Not a valid Supplier!");
}
else
{
int supId = Convert.ToInt32(txtSupId.Text);
Suppliers sup = new Suppliers();
sup.nSupId = supId;
sup.strSupName = txtSupName.Text;
if (!Prod_SuppliersDB.CheckSupInusebySupId(supId) && !SupplierContactsDB.CheckSupplierInuse(supId))
{
//if the supplier information is not in use in Prod_supplier table
SupplierDB.DeleteSupplier(sup);
refreshitems();
}
else
{
//if the supplier info is using in Prod_supplier table
CustMesg custMesg = new CustMesg();
custMesg.Showmsg("The Supplier is in use in Product_Supplier table,\n Please delete record in Product_Supplier table first!");
custMesg.Show();
refreshitems();
BindingSource supbindsource = new BindingSource();
supbindsource.DataSource = SupplierDB.GetData();
bindingNavigatorSup.BindingSource = supbindsource;
}
}
}
else
{
refreshitems();
BindingSource supbindsource = new BindingSource();
supbindsource.DataSource = SupplierDB.GetData();
bindingNavigatorSup.BindingSource = supbindsource;
}
}
private void refreshitems()
{
DataTable dtps = Prod_SuppliersDB.GetAllDatabyName();
//bindingNavigatorPS.PositionItem.Text = dtps.Rows.Count.ToString();
int nindex = Convert.ToInt32(bindingNavigatorPS.PositionItem.Text) - 1;
if (nindex < dtps.Rows.Count)
{
txtProdSupID.Text = dtps.Rows[nindex]["ProductSupplierId"].ToString();
cbProducts.DisplayMember = "ProdName";
cbProducts.ValueMember = "ProductId";
cbProducts.DataSource = ProductDB.GetData();
cbSuppliers.DisplayMember = "SupName";
cbSuppliers.ValueMember = "SupplierId";
cbSuppliers.DataSource = SupplierDB.GetData();
cbProducts.Text = dtps.Rows[nindex]["ProdName"].ToString();
cbSuppliers.Text = dtps.Rows[nindex]["SupName"].ToString();
}
//if (dgvProdSup.DataSource==null)
{
dgvProdSup.DataSource = Prod_SuppliersDB.GetAllDatabyName();
}
if (dgvProdSup.DataSource != null)
{
for (int i = 0; i < dgvProdSup.Rows.Count; i++)
{
dgvProdSup.Rows[i].Selected = false;
dgvProdSup.Rows[i].DefaultCellStyle.BackColor = Color.White;
}
if (nindex < dgvProdSup.Rows.Count)
{
dgvProdSup.Rows[nindex].Selected = true;
dgvProdSup.Rows[nindex].DefaultCellStyle.BackColor = Color.LightYellow;
}
}
}
private void ToolStripBtnSave_Click(object sender, EventArgs e)
{
if (Validation())
{
if (txtSupId.Text != "")
{
int supId = Convert.ToInt32(txtSupId.Text);
Suppliers sup = new Suppliers();
sup.nSupId = supId;
sup.strSupName = txtSupName.Text;
if (txtSupId.Text == "-1")
{
//insert new
if (SupplierDB.CheckSuppliersExistbyName(txtSupName.Text))
{
CustMesg msgfrm = new CustMesg();
msgfrm.Showmsg("Supplier exist already!");
msgfrm.Show();
//MessageBox.Show("Supplier exist already!");
}
else
{
SupplierDB.AddSupplier(sup);
}
}
else
{
//update
SupplierDB.UpdateSupplier(sup, sup);
}
refreshitems();
BindingSource supbindsource = new BindingSource();
supbindsource.DataSource = SupplierDB.GetData();
bindingNavigatorSup.BindingSource = supbindsource;
}
}
}