public override void saveBtn_Click(object sender, EventArgs e)
{
//Here we enable and disable the red asterisc "*" in the form, validating that no txt left unfilled
if (supplierCompanyTxt.Text == "")
{
supplierNameErrorLbl.Visible = true;
}
else
{
supplierNameErrorLbl.Visible = false;
}
if (personNameTxt.Text == "")
{
contactPersonErrorLbl.Visible = true;
}
else
{
contactPersonErrorLbl.Visible = false;
}
if (Phone1Txt.Text == "")
{
phone1ErrorLbl.Visible = true;
}
else
{
phone1ErrorLbl.Visible = false;
}
if (addressTxt.Text == "")
{
addressErrorLbl.Visible = true;
}
else
{
addressErrorLbl.Visible = false;
}
if (statusDD.SelectedIndex == -1)
{
statusErrorLbl.Visible = true;
}
else
{
statusErrorLbl.Visible = false;
}
if (supplierNameErrorLbl.Visible || contactPersonErrorLbl.Visible || phone1ErrorLbl.Visible || addressErrorLbl.Visible || statusErrorLbl.Visible)
{
MainClass.ShowMSG("Fields with * are mandatory", "Stop", "Error"); //Error is the type of msg
}
else
{
if (statusDD.SelectedIndex == 0)
{
stat = 1;
}
else if (statusDD.SelectedIndex == 1)
{
stat = 0;
}
if (edit == 0) //Code for SAVE operation
{
insertion i = new insertion();
//validating the null fields
if (phone2Txt.Text == "" && ntnTxt.Text != "")
{
i.insertSupplier(supplierCompanyTxt.Text, personNameTxt.Text, Phone1Txt.Text, addressTxt.Text, stat, null, ntnTxt.Text);
}
else if (phone2Txt.Text != "" && ntnTxt.Text == "")
{
i.insertSupplier(supplierCompanyTxt.Text, personNameTxt.Text, Phone1Txt.Text, addressTxt.Text, stat, phone2Txt.Text, null);
}
else if (phone2Txt.Text == "" && ntnTxt.Text == "")
{
i.insertSupplier(supplierCompanyTxt.Text, personNameTxt.Text, Phone1Txt.Text, addressTxt.Text, stat, null, null);
}
else
{
i.insertSupplier(supplierCompanyTxt.Text, personNameTxt.Text, Phone1Txt.Text, addressTxt.Text, stat, phone2Txt.Text, ntnTxt.Text);
}
r.showSuppliers(dataGridView1, SuppIDGV, companyGV, personGV, phone1GV, phone2GV, addressGV, ntnGV, StatusGV);
MainClass.disable_reset(leftPanel);
}
else if (edit == 1) //Code for UPDATE operation
{
DialogResult dr = MessageBox.Show("Are you sure , you want to update record?", "Question...", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
updation u = new updation();
if (statusDD.SelectedIndex == 0)
{
stat = 1;
}
else if (statusDD.SelectedIndex == 1)
{
stat = 0;
}
//validating the null fields
if (phone2Txt.Text == "" && ntnTxt.Text != "")
{
u.updateSupplier(supplierID, supplierCompanyTxt.Text, personNameTxt.Text, Phone1Txt.Text, addressTxt.Text, stat, null, ntnTxt.Text);
}
else if (phone2Txt.Text != "" && ntnTxt.Text == "")
{
u.updateSupplier(supplierID, supplierCompanyTxt.Text, personNameTxt.Text, Phone1Txt.Text, addressTxt.Text, stat, phone2Txt.Text, null);
}
else if (phone2Txt.Text == "" && ntnTxt.Text == "")
{
u.updateSupplier(supplierID, supplierCompanyTxt.Text, personNameTxt.Text, Phone1Txt.Text, addressTxt.Text, stat, null, null);
}
else
{
u.updateSupplier(supplierID, supplierCompanyTxt.Text, personNameTxt.Text, Phone1Txt.Text, addressTxt.Text, stat, phone2Txt.Text, ntnTxt.Text);
}
r.showSuppliers(dataGridView1, SuppIDGV, companyGV, personGV, phone1GV, phone2GV, addressGV, ntnGV, StatusGV);
MainClass.disable_reset(leftPanel);
}
}
}
}
public override void button3_Click(object sender, EventArgs e)
{
if (supplierComTxt.Text == "")
{
nameErrorLbl.Visible = true;
}
else
{
nameErrorLbl.Visible = false;
}
if (personNameTxt.Text == "")
{
ContPerErrorlbl.Visible = true;
}
else
{
ContPerErrorlbl.Visible = false;
}
if (phone1txt.Text == "")
{
phone1Errorlbl.Visible = true;
}
else
{
phone1Errorlbl.Visible = false;
}
// if (phone2txt.Text == "") { phone2Errorlbl.Visible = true; } else { phone2Errorlbl.Visible = false; }
if (addresstxt.Text == "")
{
AddressErroorlbl.Visible = true;
}
else
{
AddressErroorlbl.Visible = false;
}
// if (TaxNotxt.Text == "") { TaxNoErrorlbl.Visible = true; } else { TaxNoErrorlbl.Visible = false; }
if (statusDD.SelectedIndex == -1)
{
statusErrorlbl.Visible = true;
}
else
{
statusErrorlbl.Visible = false;
}
if (nameErrorLbl.Visible || ContPerErrorlbl.Visible || phone1Errorlbl.Visible || AddressErroorlbl.Visible || statusErrorlbl.Visible)
{
MainClass.showMG("Filds With * Are Mandatory", "Stop", "Error"); // Error is the type of Message
}
else
{
if (statusDD.SelectedIndex == 0)
{
stat = 1;
}
else if (statusDD.SelectedIndex == 1)
{
stat = 0;
}
if (edit == 0)//code for save operation
{
insertion i = new insertion();
if (phone2txt.Text == "" && TaxNotxt.Text != "")
{
i.insertSupplier(supplierComTxt.Text, personNameTxt.Text, phone1txt.Text, addresstxt.Text, stat, null, TaxNotxt.Text);
}
else if (phone2txt.Text != "" && TaxNotxt.Text == "")
{
i.insertSupplier(supplierComTxt.Text, personNameTxt.Text, phone1txt.Text, addresstxt.Text, stat, phone2txt.Text, null);
}
else if (phone2txt.Text == "" && TaxNotxt.Text == "")
{
i.insertSupplier(supplierComTxt.Text, personNameTxt.Text, phone1txt.Text, addresstxt.Text, stat, null, null);
}
else
{
i.insertSupplier(supplierComTxt.Text, personNameTxt.Text, phone1txt.Text, addresstxt.Text, stat, phone2txt.Text);
}
r.showSupplier(dataGridView1, suppIDGV, companyGV, personGV, phone1GV, phone2GV, addressGV, ntnGV, statusGV);
MainClass.disable_reset(lftPanel);
}
else if (edit == 1)///for Updte Operation
{
DialogResult dr = MessageBox.Show("Are you sure, you want to updata Record", "Question..", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
updation u = new updation();
if (statusDD.SelectedIndex == 0)
{
stat = 1;
}
else if (statusDD.SelectedIndex == 1)
{
stat = 0;
}
if (phone2txt.Text == "" && TaxNotxt.Text != "")
{
u.updateSupplier(SupplierID, supplierComTxt.Text, personNameTxt.Text, phone1txt.Text, addresstxt.Text, stat, null, TaxNotxt.Text);
}
else if (phone2txt.Text != "" && TaxNotxt.Text == "")
{
u.updateSupplier(SupplierID, supplierComTxt.Text, personNameTxt.Text, phone1txt.Text, addresstxt.Text, stat, phone2txt.Text, null);
}
else if (phone2txt.Text == "" && TaxNotxt.Text == "")
{
u.updateSupplier(SupplierID, supplierComTxt.Text, personNameTxt.Text, phone1txt.Text, addresstxt.Text, stat, null, null);
}
else
{
u.updateSupplier(SupplierID, supplierComTxt.Text, personNameTxt.Text, phone1txt.Text, addresstxt.Text, stat, phone1txt.Text, phone2txt.Text);
}
r.showSupplier(dataGridView1, suppIDGV, companyGV, personGV, phone1GV, phone2GV, addressGV, ntnGV, statusGV);
MainClass.disable_reset(lftPanel);
}
}
}
}