public override void saveButton_Click(object sender, EventArgs e)
{
if (categoryComboBox.SelectedIndex != -1 && categoryComboBox.SelectedIndex != 0)
{
foreach (DataGridViewRow row in displayDataGridView.Rows)
{
if ((bool)row.Cells["selectGV"].FormattedValue == true)
{
float disc, pm, bp, sp;
int pID;
pID = Convert.ToInt32(row.Cells["proIDGV"].Value.ToString());
bp = Convert.ToSingle(row.Cells["buyingPriceGV"].Value.ToString());
disc = row.Cells["discountGV"].Value == null? 0 : Convert.ToSingle(row.Cells["discountGV"].Value.ToString());
pm = row.Cells["profitMarginGV"].Value == null? 0 : Convert.ToSingle(row.Cells["profitMarginGV"].Value.ToString());
if (disc == 0 && pm == 0)
{
sp = bp;
}
else
{
sp = Convert.ToSingle(row.Cells["FinalPriceGV"].Value.ToString());
}
u.updateProductPrice(pID, bp, sp, disc, pm);
}
}
MainClass.ShowMsg("Product Pricing Updated Successfully...", "Success", "Success");
}
}
private void loginButton_Click(object sender, EventArgs e)
{
if (usernameTextBox.Text == "")
{
nameErrorLabel.Visible = true;
}
else
{
nameErrorLabel.Visible = false;
}
if (passwordTextBox.Text == "")
{
passwordErrorLabel.Visible = true;
}
else
{
passwordErrorLabel.Visible = false;
}
if (nameErrorLabel.Visible || passwordErrorLabel.Visible)
{
MainClass.ShowMsg("Fields with * are mandatory", "Stop", "Error");//Error is the type of msg
}
else
{
if (retrival.getUserDetails(usernameTextBox.Text, passwordTextBox.Text))
{
HomeScreen hs = new HomeScreen();
MainClass.showWindow(hs, this, MDI.ActiveForm);
}
else
{
}
}
}
public void showStockDetails(DataGridView gv, DataGridViewColumn proIDGV, DataGridViewColumn proGV, DataGridViewColumn barcodeGV, DataGridViewColumn expiryGV, DataGridViewColumn catGV, DataGridViewColumn bpGV, DataGridViewColumn spGV, DataGridViewColumn availStGV, DataGridViewColumn statusGV, DataGridViewColumn totGV)
{
try
{
SqlCommand cmd = new SqlCommand("sp_getAllStock", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
proIDGV.DataPropertyName = dt.Columns["Product ID"].ToString();
proGV.DataPropertyName = dt.Columns["Product"].ToString();
barcodeGV.DataPropertyName = dt.Columns["Barcode"].ToString();
expiryGV.DataPropertyName = dt.Columns["Expiry Date"].ToString();
bpGV.DataPropertyName = dt.Columns["Buying Price"].ToString();
spGV.DataPropertyName = dt.Columns["Selling Price"].ToString();
catGV.DataPropertyName = dt.Columns["Catergory"].ToString();
statusGV.DataPropertyName = dt.Columns["Status"].ToString();
availStGV.DataPropertyName = dt.Columns["Available Stock"].ToString();
totGV.DataPropertyName = dt.Columns["Total Amount"].ToString();
gv.DataSource = dt;
}
catch (Exception)
{
MainClass.ShowMsg("Unable to load Suppliers Data.", "Error", "Error");
}
}
public void updateProduct(int proID, string product, string barcode, int catID, DateTime?expiry = null)
{
try
{
SqlCommand cmd = new SqlCommand("st_productUpdate", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", product);
cmd.Parameters.AddWithValue("@barcode", barcode);
if (expiry == null)
{
cmd.Parameters.AddWithValue("@expiry", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@expiry", expiry);
}
cmd.Parameters.AddWithValue("@catID", catID);
cmd.Parameters.AddWithValue("@proID", proID);
MainClass.con.Open();
cmd.ExecuteNonQuery();
MainClass.con.Close();
MainClass.ShowMsg(product + "updated to the system successfully", "Success", "Success");
}
catch (Exception e)
{
MainClass.con.Close();
MainClass.ShowMsg(e.Message, "Error", "Error");
}
}
public void showPurchaseInvoiceDetails(Int64 pid, DataGridView gv, DataGridViewColumn mPIDGV, DataGridViewColumn proIDGV, DataGridViewColumn proNameGV, DataGridViewColumn quantGV, DataGridViewColumn pupGV, DataGridViewColumn totGV)
{
try
{
SqlCommand cmd = new SqlCommand("sp_getPurchaseInvoiceDetails", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pid", pid);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
mPIDGV.DataPropertyName = dt.Columns["mPID"].ToString();
proIDGV.DataPropertyName = dt.Columns["Product ID"].ToString();
proNameGV.DataPropertyName = dt.Columns["Product"].ToString();
pupGV.DataPropertyName = dt.Columns["Per Unit Price"].ToString();
totGV.DataPropertyName = dt.Columns["Total Price"].ToString();
quantGV.DataPropertyName = dt.Columns["quantity"].ToString();
gv.DataSource = dt;
}
catch (Exception)
{
MainClass.ShowMsg("Unable to load Product Data.", "Error", "Error");
}
}
public void showProductsWRTCategory(int catID, DataGridView gv, DataGridViewColumn proIDGV, DataGridViewColumn proNameGV, DataGridViewColumn bpGV, DataGridViewColumn spGV,
DataGridViewColumn disGV, DataGridViewColumn profitPerGV)
{
try
{
SqlCommand cmd = new SqlCommand("st_getProductsWRTCategory", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@catID", catID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
proIDGV.DataPropertyName = dt.Columns["Product ID"].ToString();
proNameGV.DataPropertyName = dt.Columns["Product"].ToString();
bpGV.DataPropertyName = dt.Columns["Buying Price"].ToString();
spGV.DataPropertyName = dt.Columns["Selling Price"].ToString();
disGV.DataPropertyName = dt.Columns["Discount"].ToString();
profitPerGV.DataPropertyName = dt.Columns["Profit Percentage"].ToString();
gv.DataSource = dt;
}
catch (Exception)
{
MainClass.ShowMsg("Unable to load Products Data.", "Error", "Error");
}
}
public void updateUser(int id, string name, string username, string pass, string email, string phone, Int16 status)
{
try
{
SqlCommand cmd = new SqlCommand("st_updateUsers", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@username", username);
cmd.Parameters.AddWithValue("@pwd", pass);
cmd.Parameters.AddWithValue("@phone", phone);
cmd.Parameters.AddWithValue("@email", email);
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@status", status);
MainClass.con.Open();
cmd.ExecuteNonQuery();
MainClass.con.Close();
MainClass.ShowMsg(name + "updated to the system successfully", "Success", "Success");
}
catch (Exception e)
{
MainClass.con.Close();
MainClass.ShowMsg(e.Message, "Error", "Error");
}
}
public void showCategories(DataGridView gv, DataGridViewColumn catIDGV, DataGridViewColumn catNameGV, DataGridViewColumn statusGV, string data = null)
{
try
{
SqlCommand cmd;
if (data == null)
{
cmd = new SqlCommand("st_getCategoriesData", MainClass.con);
}
else
{
cmd = new SqlCommand("st_getCategoryDataLIKE", MainClass.con);
cmd.Parameters.AddWithValue("@data", data);
}
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
catIDGV.DataPropertyName = dt.Columns["ID"].ToString();
catNameGV.DataPropertyName = dt.Columns["Category"].ToString();
statusGV.DataPropertyName = dt.Columns["Status"].ToString();
gv.DataSource = dt;
}
catch (Exception)
{
MainClass.ShowMsg("Unable to load Categories Data.", "Error", "Error");
}
}
public void showSuppliers(DataGridView gv, DataGridViewColumn suppIDGV, DataGridViewColumn comNameGV, DataGridViewColumn personGV, DataGridViewColumn phone1GV, DataGridViewColumn phone2GV, DataGridViewColumn addressGV, DataGridViewColumn ntnGV, DataGridViewColumn statusGV)
{
try
{
SqlCommand cmd = new SqlCommand("sp_getSupplierData", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
suppIDGV.DataPropertyName = dt.Columns["ID"].ToString();
comNameGV.DataPropertyName = dt.Columns["Compnay"].ToString();
personGV.DataPropertyName = dt.Columns["Contact Person"].ToString();
phone1GV.DataPropertyName = dt.Columns["Phone 1"].ToString();
phone2GV.DataPropertyName = dt.Columns["Phone 2"].ToString();
addressGV.DataPropertyName = dt.Columns["Address"].ToString();
statusGV.DataPropertyName = dt.Columns["Status"].ToString();
ntnGV.DataPropertyName = dt.Columns["NTN #"].ToString();
gv.DataSource = dt;
}
catch (Exception)
{
MainClass.ShowMsg("Unable to load Suppliers Data.", "Error", "Error");
}
}
public override void saveButton_Click(object sender, EventArgs e)
{
if (displayDataGridView.Rows.Count > 0)
{
Int64 purchaseInvoiceID;
insertion i = new insertion();
updation u = new updation();
using (TransactionScope sc = new TransactionScope())
{
purchaseInvoiceID = i.insertPurchaseInvoice(DateTime.Today, retrival.USER_ID,
Convert.ToInt32(supplierComboBox.SelectedValue));
foreach (DataGridViewRow row in displayDataGridView.Rows)
{
co += i.insertPurchaseInvoiceDetails(purchaseInvoiceID, Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), Convert.ToInt32(row.Cells["quantGV"].Value.ToString()), Convert.ToSingle(row.Cells["totalGV"].Value.ToString()));
if (r.checkProductPriceExistance(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString())))
{
u.updateProductPrice(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), Convert.ToSingle(row.Cells["pupGV"].Value.ToString()));
}
else
{
i.insertProductPrice(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), Convert.ToSingle(row.Cells["pupGV"].Value.ToString()));
}
int q;
object ob = r.getProductQuantity(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()));
if (ob != null)
{
q = Convert.ToInt32(ob);
q += Convert.ToInt32(row.Cells["quantGV"].Value.ToString());
u.updateStock(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), q);
}
else
{
i.insertStock(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), Convert.ToInt32(row.Cells["quantGV"].Value.ToString()));
}
}
if (co > 0)
{
MainClass.ShowMsg("Purchase Invoice Created Successfully.", "Success", "Success");
}
else
{
MainClass.ShowMsg("Unable to create purchase invoice.", "Error", "Error");
}
sc.Complete();
}
}
}
public static bool getUserDetails(string username, string password)
{
try
{
SqlCommand cmd = new SqlCommand("st_getUserDetails", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@user", username);
cmd.Parameters.AddWithValue("@pass", password);
MainClass.con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
checkLogin = true;
while (dr.Read())
{
USER_ID = Convert.ToInt32(dr["ID"].ToString());
EMP_NAME = dr["Name"].ToString();
user_name = dr["Username"].ToString();
pass_word = dr["Password"].ToString();
}
}
else
{
checkLogin = false;
if (username != null && password != null)
{
if (user_name != username && pass_word == password)
{
MainClass.ShowMsg("Invalid Username", "Error", "Error");
}
else if (user_name == username && pass_word != password)
{
MainClass.ShowMsg("Invalid Password", "Error", "Error");
}
else if (user_name != username && pass_word != password)
{
MainClass.ShowMsg("Invalid Password & Username", "Error", "Error");
}
}
}
MainClass.con.Close();
}
catch (Exception)
{
MainClass.con.Close();
MainClass.ShowMsg("Unable to login....", "Error", "Error");
}
return(checkLogin);
}
private void cartButton_Click(object sender, EventArgs e)
{
if (supplierComboBox.SelectedIndex == -1)
{
supplierErrorLabel.Visible = true;
}
else
{
supplierErrorLabel.Visible = false;
}
if (quantityTextBox.Text == "")
{
quantityErrorLabel.Visible = true;
}
else
{
quantityErrorLabel.Visible = false;
}
if (barcodeTextBox.Text == "")
{
barcodeErrorLabel.Visible = true;
}
else
{
barcodeErrorLabel.Visible = false;
}
if (supplierErrorLabel.Visible || quantityErrorLabel.Visible || barcodeErrorLabel.Visible)
{
MainClass.ShowMsg("Fields with * are mandatory", "Stop", "Error");//Error is the type of msg
}
else
{
displayDataGridView.Rows.Add(productID, producTextBox.Text, quantityTextBox.Text, priceTextBox.Text,
totlabel.Text);
gt += Convert.ToSingle(totlabel.Text);
grossLabel.Text = gt.ToString();
productID = 0;
producTextBox.Text = "";
priceTextBox.Text = "";
barcodeTextBox.Text = "";
totlabel.Text = "0.00";
quantityTextBox.Text = "";
Array.Clear(prodARR, 0, prodARR.Length);
}
}
public void delete(object id, string proc, string param)
{
try
{
SqlCommand cmd = new SqlCommand(proc, MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(param, id);
MainClass.con.Open();
cmd.ExecuteNonQuery();
MainClass.con.Close();
MainClass.ShowMsg("Data deleted successfully", "Success", "Success");
}
catch (Exception e)
{
MainClass.con.Close();
MainClass.ShowMsg(e.Message, "Error", "Error");
}
}
public void updateSupplier(int supID, string company, string person, string phone1, string address, Int16 status, string phone2 = null, string ntn = null)
{
try
{
SqlCommand cmd = new SqlCommand("sp_updateSupplier", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@company", company);
cmd.Parameters.AddWithValue("@conPerson", person);
cmd.Parameters.AddWithValue("@phone1", phone1);
if (phone2 == null)
{
cmd.Parameters.AddWithValue("@phone2", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@phone2", phone2);
}
if (ntn == null)
{
cmd.Parameters.AddWithValue("@ntn", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ntn", ntn);
}
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@status", status);
cmd.Parameters.AddWithValue("@suppID", supID);
MainClass.con.Open();
cmd.ExecuteNonQuery();
MainClass.con.Close();
MainClass.ShowMsg(company + "updated successfully", "Success", "Success");
}
catch (Exception e)
{
MainClass.con.Close();
MainClass.ShowMsg(e.Message, "Error", "Error");
}
}
public void insertProductPrice(int proID, float buyingAmount)
{
try
{
SqlCommand cmd = new SqlCommand("st_insertProductPrice", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@proID", proID);
cmd.Parameters.AddWithValue("@bp", buyingAmount);
MainClass.con.Open();
cmd.ExecuteNonQuery();
MainClass.con.Close();
}
catch (Exception e)
{
MainClass.con.Close();
MainClass.ShowMsg(e.Message, "Error", "Error");
}
}
public void insertCat(string name, Int16 status)
{
try
{
SqlCommand cmd = new SqlCommand("st_insertCategory", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@isActive", status);
MainClass.con.Open();
cmd.ExecuteNonQuery();
MainClass.con.Close();
MainClass.ShowMsg(name + "added to the system successfully", "Success", "Success");
}
catch (Exception e)
{
MainClass.con.Close();
MainClass.ShowMsg(e.Message, "Error", "Error");
}
}
public void insertDeletedItem(Int64 pid, int proid, int quan, int userid, DateTime date)
{
try
{
SqlCommand cmd = new SqlCommand("sp_insertDeletedItemPI", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pi", pid);
cmd.Parameters.AddWithValue("@usrID", userid);
cmd.Parameters.AddWithValue("@proID", proid);
cmd.Parameters.AddWithValue("@quan", quan);
cmd.Parameters.AddWithValue("@date", date);
MainClass.con.Open();
cmd.ExecuteNonQuery();
MainClass.con.Close();
}
catch (Exception e)
{
MainClass.con.Close();
MainClass.ShowMsg(e.Message, "Error", "Error");
}
}
public Int64 insertPurchaseInvoice(DateTime date, int doneBy, int suppID)
{
try
{
SqlCommand cmd = new SqlCommand("st_insertPurchaseInvoice", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@date", date);
cmd.Parameters.AddWithValue("@doneBy", doneBy);
cmd.Parameters.AddWithValue("@suppID", suppID);
MainClass.con.Open();
cmd.ExecuteNonQuery();
cmd.CommandText = "st_getLastPurchaseID";
cmd.Parameters.Clear();
purchaseInvoiceID = Convert.ToInt64(cmd.ExecuteScalar());
MainClass.con.Close();
}
catch (Exception e)
{
MainClass.con.Close();
MainClass.ShowMsg(e.Message, "Error", "Error");
}
return(purchaseInvoiceID);
}
public void showProducts(DataGridView gv, DataGridViewColumn proIDGV, DataGridViewColumn proNameGV, DataGridViewColumn expiryGV, DataGridViewColumn catGV, DataGridViewColumn barcodeGV, DataGridViewColumn catIDGV)
{
try
{
SqlCommand cmd = new SqlCommand("st_getProductsData", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
proIDGV.DataPropertyName = dt.Columns["Product ID"].ToString();
proNameGV.DataPropertyName = dt.Columns["Product"].ToString();
barcodeGV.DataPropertyName = dt.Columns["Barcode"].ToString();
expiryGV.DataPropertyName = dt.Columns["Expiry"].ToString();
catGV.DataPropertyName = dt.Columns["Category"].ToString();
catIDGV.DataPropertyName = dt.Columns["Category ID"].ToString();
gv.DataSource = dt;
}
catch (Exception)
{
MainClass.ShowMsg("Unable to load Product Data.", "Error", "Error");
}
}
public override void saveButton_Click(object sender, EventArgs e)
{
if (productTextBox.Text == "")
{
productNameErrorLabel.Visible = true;
}
else
{
productNameErrorLabel.Visible = false;
}
if (barcodeTextBox.Text == "")
{
barcodeErrorLabel.Visible = true;
}
else
{
barcodeErrorLabel.Visible = false;
}
if (expiryDateTimePicker.Value < DateTime.Now)
{
expiryDateLabel.Visible = true; expiryDateLabel.Text = "invalid Date";
}
else
{
expiryDateLabel.Visible = false;
}
if (expiryDateTimePicker.Value.Date == DateTime.Now.Date)
{
expiryDateLabel.Visible = false;
}
if (categoryComboBox.SelectedIndex == -1 || categoryComboBox.SelectedIndex == 0)
{
categoryErrorLabel.Visible = true;
}
else
{
categoryErrorLabel.Visible = false;
}
if (productNameErrorLabel.Visible || barcodeErrorLabel.Visible || expiryDateLabel.Visible || categoryErrorLabel.Visible)
{
MainClass.ShowMsg("Fields with * are mandatory", "Stop", "Error");//Error is the type of msg
}
else
{
if (edit == 0)//code for save operation
{
insertion i = new insertion();
if (expiryDateTimePicker.Value.Date == DateTime.Now.Date)
{
i.insertProduct(productTextBox.Text, barcodeTextBox.Text,
Convert.ToInt32(categoryComboBox.SelectedValue));
}
else
{
i.insertProduct(productTextBox.Text, barcodeTextBox.Text,
Convert.ToInt32(categoryComboBox.SelectedValue), expiryDateTimePicker.Value);
}
r.showProducts(displayDataGridView, proIDGV, proGV, ExpiryGV, catGV, barcodeGV, CatIDGV);
MainClass.disableReset(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.Warning);
if (dr == DialogResult.Yes)
{
updation u = new updation();
if (expiryDateTimePicker.Value.Date == DateTime.Now.Date)
{
u.updateProduct(prodId, productTextBox.Text, barcodeTextBox.Text, Convert.ToInt32(categoryComboBox.SelectedValue));
}
else
{
u.updateProduct(prodId, productTextBox.Text, barcodeTextBox.Text, Convert.ToInt32(categoryComboBox.SelectedValue), expiryDateTimePicker.Value);
}
r.showProducts(displayDataGridView, proIDGV, proGV, ExpiryGV, catGV, barcodeGV, CatIDGV);
MainClass.disableReset(leftPanel);
}
}
}
}
public override void saveButton_Click(object sender, EventArgs e)
{
if (nameTextBox.Text == "")
{
nameErrorLabel.Visible = true;
}
else
{
nameErrorLabel.Visible = false;
}
if (usernameTextBox.Text == "")
{
usernameErrorLabel.Visible = true;
}
else
{
usernameErrorLabel.Visible = false;
}
if (passwordTextBox.Text == "")
{
passwordErrorLabel.Visible = true;
}
else
{
passwordErrorLabel.Visible = false;
}
if (emailTextBox.Text == "")
{
emailErrorLabel.Visible = true;
}
else
{
emailErrorLabel.Visible = false;
}
if (phoneTextBox.Text == "")
{
phoneErrorLabel.Visible = true;
}
else
{
phoneErrorLabel.Visible = false;
}
if (statusComboBox.SelectedIndex == -1)
{
statusErrorLabel.Visible = true;
}
else
{
statusErrorLabel.Visible = false;
}
if (nameErrorLabel.Visible || usernameErrorLabel.Visible || passwordErrorLabel.Visible ||
emailErrorLabel.Visible || phoneErrorLabel.Visible || statusErrorLabel.Visible)
{
MainClass.ShowMsg("Fields with * are mandatory", "Stop", "Error");//Error is the type of msg
}
else
{
if (statusComboBox.SelectedIndex == 0)
{
stat = 1;
}
else if (statusComboBox.SelectedIndex == 1)
{
stat = 0;
}
if (edit == 0)//code for save operation
{
insertion i = new insertion();
i.insertUser(nameTextBox.Text, usernameTextBox.Text, passwordTextBox.Text, emailTextBox.Text, phoneTextBox.Text, stat);
r.showUsers(displayDataGridView, userIDGV, NameGV, UserNameGV, passGV, EmailGV, PhoneGV, statusGV);
MainClass.disableReset(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.Warning);
if (dr == DialogResult.Yes)
{
updation u = new updation();
if (statusComboBox.SelectedIndex == 0)
{
stat = 1;
}
else if (statusComboBox.SelectedIndex == 1)
{
stat = 0;
}
u.updateUser(userId, nameTextBox.Text, usernameTextBox.Text, passwordTextBox.Text, emailTextBox.Text, phoneTextBox.Text, stat);
r.showUsers(displayDataGridView, userIDGV, NameGV, UserNameGV, passGV, EmailGV, PhoneGV, statusGV);
MainClass.disableReset(leftPanel);
}
}
}
}
public override void saveButton_Click(object sender, EventArgs e)
{
if (supplierTextBox.Text == "")
{
supplierNameErrorLabel.Visible = true;
}
else
{
supplierNameErrorLabel.Visible = false;
}
if (personNameTextBox.Text == "")
{
contactPersonLabel.Visible = true;
}
else
{
contactPersonLabel.Visible = false;
}
if (phone1TextBox.Text == "")
{
phoneErrorLabel.Visible = true;
}
else
{
phoneErrorLabel.Visible = false;
}
if (addressTextBox.Text == "")
{
addressErrorLabel.Visible = true;
}
else
{
addressErrorLabel.Visible = false;
}
if (statusComboBox.SelectedIndex == -1)
{
statusErrorLabel.Visible = true;
}
else
{
statusErrorLabel.Visible = false;
}
if (supplierNameErrorLabel.Visible || contactPersonLabel.Visible || phoneErrorLabel.Visible ||
addressErrorLabel.Visible || statusErrorLabel.Visible)
{
MainClass.ShowMsg("Fields with * are mandatory", "Stop", "Error");//Error is the type of msg
}
else
{
if (statusComboBox.SelectedIndex == 0)
{
stat = 1;
}
else if (statusComboBox.SelectedIndex == 1)
{
stat = 0;
}
if (edit == 0)//code for save operation
{
insertion i = new insertion();
if (phone2TextBox.Text == "" && nTNTextBox.Text != "")
{
i.insertSupplier(supplierTextBox.Text, personNameTextBox.Text, phone1TextBox.Text, addressTextBox.Text, stat, null, nTNTextBox.Text);
}
else if (phone2TextBox.Text != "" && nTNTextBox.Text == "")
{
i.insertSupplier(supplierTextBox.Text, personNameTextBox.Text, phone1TextBox.Text, addressTextBox.Text, stat, phone2TextBox.Text, null);
}
else if (phone2TextBox.Text == "" && nTNTextBox.Text == "")
{
i.insertSupplier(supplierTextBox.Text, personNameTextBox.Text, phone1TextBox.Text, addressTextBox.Text, stat, null, null);
}
else
{
i.insertSupplier(supplierTextBox.Text, personNameTextBox.Text, phone1TextBox.Text, addressTextBox.Text, stat, phone2TextBox.Text, nTNTextBox.Text);
}
r.showSuppliers(displayDataGridView, suppIDGV, comGV, conPerGV, phone1GV, phone2GV, addressGV,
ntnGV, statusGV);
MainClass.disableReset(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.Warning);
if (dr == DialogResult.Yes)
{
updation u = new updation();
if (statusComboBox.SelectedIndex == 0)
{
stat = 1;
}
else if (statusComboBox.SelectedIndex == 1)
{
stat = 0;
}
if (phone2TextBox.Text == "" && nTNTextBox.Text != "")
{
u.updateSupplier(supplierId, supplierTextBox.Text, personNameTextBox.Text, phone1TextBox.Text, addressTextBox.Text, stat, null, nTNTextBox.Text);
}
else if (phone2TextBox.Text != "" && nTNTextBox.Text == "")
{
u.updateSupplier(supplierId, supplierTextBox.Text, personNameTextBox.Text, phone1TextBox.Text, addressTextBox.Text, stat, phone2TextBox.Text, null);
}
else if (phone2TextBox.Text == "" && nTNTextBox.Text == "")
{
u.updateSupplier(supplierId, supplierTextBox.Text, personNameTextBox.Text, phone1TextBox.Text, addressTextBox.Text, stat, null, null);
}
else
{
u.updateSupplier(supplierId, supplierTextBox.Text, personNameTextBox.Text, phone1TextBox.Text, addressTextBox.Text, stat, phone2TextBox.Text, nTNTextBox.Text);
}
r.showSuppliers(displayDataGridView, suppIDGV, comGV, conPerGV, phone1GV, phone2GV, addressGV,
ntnGV, statusGV);
MainClass.disableReset(leftPanel);
}
}
}
}
public override void saveButton_Click(object sender, EventArgs e)
{
if (categoryTextBox.Text == "")
{
categoryNameErrorLabel.Visible = true;
}
else
{
categoryNameErrorLabel.Visible = false;
}
if (isActiveComboBox.SelectedIndex == -1)
{
isActiveErrorLabel.Visible = true;
}
else
{
isActiveErrorLabel.Visible = false;
}
if (isActiveErrorLabel.Visible || categoryNameErrorLabel.Visible)
{
MainClass.ShowMsg("Fields with * are mandatory", "Stop", "Error");//Error is the type of msg
}
else
{
if (isActiveComboBox.SelectedIndex == 0)
{
stat = 1;
}
else if (isActiveComboBox.SelectedIndex == 1)
{
stat = 0;
}
if (edit == 0)//code for save operation
{
insertion i = new insertion();
i.insertCat(categoryTextBox.Text, stat);
r.showCategories(displayDataGridView, catIDGV, NameGV, statusGV);
MainClass.disableReset(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.Warning);
if (dr == DialogResult.Yes)
{
updation u = new updation();
if (isActiveComboBox.SelectedIndex == 0)
{
stat = 1;
}
else if (isActiveComboBox.SelectedIndex == 1)
{
stat = 0;
}
u.updateCat(catId, categoryTextBox.Text, stat);
r.showCategories(displayDataGridView, catIDGV, NameGV, statusGV);
MainClass.disableReset(leftPanel);
}
}
}
}
