private void Delete_Click(object sender, EventArgs e)
{
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("DELETE FROM MYORDER WHERE ORD_ID = @oid", con);
cmd.Parameters.AddWithValue("@oid", OrderID.Text);
int i = cmd.ExecuteNonQuery();
con.Close();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Order Deletion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Order Deletion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
OrderID.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void Search_Click(object sender, EventArgs e)
{
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
var select = "SELECT * FROM ORDER_VIEW WHERE DATE BETWEEN @start AND @end ;";
var dataAdapter = new SqlDataAdapter(select, con);
dataAdapter.SelectCommand.Parameters.AddWithValue("@start", FromDate.Text);
dataAdapter.SelectCommand.Parameters.AddWithValue("@end", Todate.Text);
var commandBuilder = new SqlCommandBuilder(dataAdapter);
var ds = new DataSet();
dataAdapter.Fill(ds);
dataGridView1.ReadOnly = true;
dataGridView1.DataSource = ds.Tables[0];
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void Delete_Click(object sender, EventArgs e)
{
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("DELETE FROM VENDOR WHERE VID = @vid", con);
cmd.Parameters.AddWithValue("@vid", VendorID.Text);
int i = cmd.ExecuteNonQuery();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Customer Deletion Successful!");
}
else
{
MessageBox.Show("Customer Deletion Failed");
}
con.Close();
//Clear the fields
VendorID.Clear();
VendorName.Clear();
}
catch (Exception ex)
{
MessageBox.Show("Vendor Not found");
}
}
private void Search_Click(object sender, EventArgs e)
{
try
{
Connect connectObj = new Connect();
using (con = connectObj.connect())
{
using (SqlCommand cmd = new SqlCommand("SELECT C_ID FROM CUSTOMER WHERE CNAME = @cname"))
{
cmd.Parameters.AddWithValue("@cname", CustomerName.Text);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
sdr.Read();
CustomerID.Text = sdr["C_ID"].ToString();
}
con.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Customer not found", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void ReportVendors_Load(object sender, EventArgs e)
{
try
{
var select = "SELECT * FROM VENDOR";
Connect connectObj = new Connect();
con = connectObj.connect();
var dataAdapter = new SqlDataAdapter(select, con);
var commandBuilder = new SqlCommandBuilder(dataAdapter);
var ds = new DataSet();
dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.Fill);
dataAdapter.Fill(ds);
dataGridView1.ReadOnly = true;
dataGridView1.DataSource = ds.Tables[0];
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void Search_Click(object sender, EventArgs e)
{
try
{
var select = "SELECT * FROM ORDER_VIEW WHERE ORD_ID = " + orderID.Text + ";";
Connect connectObj = new Connect();
con = connectObj.connect();
var dataAdapter = new SqlDataAdapter(select, con);
var commandBuilder = new SqlCommandBuilder(dataAdapter);
var ds = new DataSet();
dataAdapter.Fill(ds);
ViewData.ReadOnly = true;
ViewData.DataSource = ds.Tables[0];
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void search_Click(object sender, EventArgs e)
{
try
{
Connect connectObj = new Connect();
using (con = connectObj.connect())
{
using (SqlCommand cmd = new SqlCommand("SELECT PNAME FROM PRODUCT WHERE PID = @pid"))
{
cmd.Parameters.AddWithValue("@pid", ProductID.Text);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
sdr.Read();
ProductName.Text = sdr["PNAME"].ToString();
}
con.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Product not found", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void ReportCustomer_Load(object sender, EventArgs e)
{
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
var select = "SELECT * FROM CUSTOMER";
var dataAdapter = new SqlDataAdapter(select, con);
var commandBuilder = new SqlCommandBuilder(dataAdapter);
var ds = new DataSet();
dataAdapter.Fill(ds);
dataGridView1.ReadOnly = true;
dataGridView1.DataSource = ds.Tables[0];
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void submit_Click(object sender, EventArgs e)
{
if (VendorName.Text == "" || VendorAddress.Text == "" || PhoneNO.Text == "" || Email.Text == "" || VendorID.Text == "")
{
MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (PhoneNO.Text.Length != 10)
{
MessageBox.Show("Enter valid Phone number", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("Insert into VENDOR (vid,vname,address,phone_number,email) values(@id,@vname,@address,@phno,@email);", con);
cmd.Parameters.AddWithValue("@id", VendorID.Text);
cmd.Parameters.AddWithValue("@vname", VendorName.Text);
cmd.Parameters.AddWithValue("@phno", Convert.ToInt64(PhoneNO.Text));
cmd.Parameters.AddWithValue("@address", VendorAddress.Text);
cmd.Parameters.AddWithValue("@email", Email.Text);
int i = cmd.ExecuteNonQuery();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Vendor Insertion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Vendor Insertion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.Close();
//Clear all the fields.
VendorName.Clear();
VendorAddress.Clear();
PhoneNO.Clear();
Email.Clear();
VendorID.Clear();
}
catch (Exception ex)
{
MessageBox.Show("Failed!! Try with Different ID!!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void updateButton_Click(object sender, EventArgs e)
{
if (customerName.Text == "" || CustPhno.Text == "" || customerAddress.Text == "" || Email.Text == "" || customerID.Text == "")
{
MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("UPDATE CUSTOMER SET cname = @cname,address = @address,phone_number = @phno,email = @email WHERE c_id = @id;", con);
cmd.Parameters.AddWithValue("@id", customerID.Text);
cmd.Parameters.AddWithValue("@cname", customerName.Text);
cmd.Parameters.AddWithValue("@phno", Convert.ToInt64(CustPhno.Text));
cmd.Parameters.AddWithValue("@address", customerAddress.Text);
cmd.Parameters.AddWithValue("@email", Email.Text);
int i = cmd.ExecuteNonQuery();
if (i != 0)
{
MessageBox.Show("Customer Updation Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Customer Updation Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.Close();
}catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
//Clear the texboxes after inserting
customerName.Clear();
CustPhno.Clear();
customerAddress.Clear();
Email.Clear();
customerID.Clear();
}
private void update_Click(object sender, EventArgs e)
{
if (VendorName.Text == "" || VendorAddress.Text == "" || PhoneNumber.Text == "" || email.Text == "" || VendorID.Text == "")
{
MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("UPDATE VENDOR SET vname = @vname,address = @address,phone_number = @phno,email = @email WHERE vid = @id;", con);
cmd.Parameters.AddWithValue("@id", VendorID.Text);
cmd.Parameters.AddWithValue("@vname", VendorName.Text);
cmd.Parameters.AddWithValue("@phno", Convert.ToInt64(PhoneNumber.Text));
cmd.Parameters.AddWithValue("@address", VendorAddress.Text);
cmd.Parameters.AddWithValue("@email", email.Text);
int i = cmd.ExecuteNonQuery();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Vendor Updation Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Vendor Updation Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show("Vendor not found", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
VendorName.Clear();
VendorAddress.Clear();
PhoneNumber.Clear();
email.Clear();
VendorID.Clear();
}
private void Submit_Click(object sender, EventArgs e)
{
if (ProductName.Text == "" || VendorID.Text == "" || Amount.Text == "" || ProductID.Text == "")
{
MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("Insert into PRODUCT (PID,PNAME,AMOUNT,VID) values(@pid,@pname,@amount,@vid);", con);
cmd.Parameters.AddWithValue("@pid", ProductID.Text);
cmd.Parameters.AddWithValue("@pname", ProductName.Text);
cmd.Parameters.AddWithValue("@vid", VendorID.Text);
cmd.Parameters.AddWithValue("@amount", Amount.Text);
int i = cmd.ExecuteNonQuery();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Product Insertion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Product Insertion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
con.Close();
ProductName.Clear();
VendorID.Clear();
Amount.Clear();
ProductID.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void Add_Click(object sender, EventArgs e)
{
if (ProductID.Text == "" || Quantity.Text == "" || ProductName.Text == "")
{
MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("Insert into STOCK (PID,QUANTITY) values(@pID,@quantity);", con);
cmd.Parameters.AddWithValue("@pid", ProductID.Text);
cmd.Parameters.AddWithValue("@quantity", Quantity.Text);
int i = cmd.ExecuteNonQuery();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Stock Insertion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Stock Insertion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.Close();
//Clear all the fields
ProductID.Clear();
Quantity.Clear();
ProductName.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void Update_Click(object sender, EventArgs e)
{
if (ProductName.Text == "" || productID.Text == "" || VendorID.Text == "" || Amount.Text == "")
{
MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
Connect conObj = new Connect();
con = conObj.connect();
SqlCommand cmd = new SqlCommand("UPDATE PRODUCT SET pname = @pname,amount = @amount,vid = @vid WHERE pid = @id;", con);
cmd.Parameters.AddWithValue("@id", productID.Text);
cmd.Parameters.AddWithValue("@pname", ProductName.Text);
cmd.Parameters.AddWithValue("@vid", VendorID.Text);
cmd.Parameters.AddWithValue("@amount", Amount.Text);
//cid += 1;
int i = cmd.ExecuteNonQuery();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Product Updation Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Product Updation Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
ProductName.Clear();
productID.Clear();
VendorID.Clear();
Amount.Clear();
}
private void Product_search_TextChanged(object sender, EventArgs e)
{
String keyword = Product_search.Text;
if (keyword == "")
{
return;
}
Connect connectObj = new Connect();
con = connectObj.connect();
DataTable dt = new DataTable();
try
{
String sql = "SELECT PID,PNAME,AMOUNT FROM PRODUCT WHERE PID LIKE '%" + keyword + "%' OR PNAME LIKE '%" + keyword + "%';";
SqlDataAdapter adpt = new SqlDataAdapter(sql, con);
adpt.Fill(dt);
if (dt.Rows.Count > 0)
{
Product_Name.Text = dt.Rows[0]["PNAME"].ToString();
ProductID.Text = dt.Rows[0]["PID"].ToString();
Amount.Text = dt.Rows[0]["AMOUNT"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void Cust_search_TextChanged(object sender, EventArgs e)
{
String keyword = Cust_search.Text;
if (keyword == "")
{
Cust_search.Clear();
CustName.Clear();
PhoneNumber.Clear();
Cust_address.Clear();
custEmail.Clear();
return;
}
Connect connectObj = new Connect();
con = connectObj.connect();
DataTable dt = new DataTable();
try
{
String sql = "SELECT CNAME,ADDRESS,PHONE_NUMBER,EMAIL,C_ID FROM CUSTOMER WHERE C_ID LIKE '%" + keyword + "%' OR CNAME LIKE '%" + keyword + "%';";
SqlDataAdapter adpt = new SqlDataAdapter(sql, con);
adpt.Fill(dt);
if (dt.Rows.Count > 0)
{
CustName.Text = dt.Rows[0]["CNAME"].ToString();
PhoneNumber.Text = dt.Rows[0]["PHONE_NUMBER"].ToString();
Cust_address.Text = dt.Rows[0]["ADDRESS"].ToString();
custEmail.Text = dt.Rows[0]["EMAIL"].ToString();
cid = dt.Rows[0]["C_ID"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Search_Click(object sender, EventArgs e)
{
try
{
Connect connectObj = new Connect();
using (con = connectObj.connect())
{
using (SqlCommand cmd = new SqlCommand("SELECT C_ID,CNAME,PHONE_NUMBER,ADDRESS,EMAIL FROM CUSTOMER WHERE CNAME = @cname"))
{
cmd.Parameters.AddWithValue("@cname", CustomerName.Text);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
sdr.Read();
CustName.Text = sdr["CNAME"].ToString();
PhoneNo.Text = sdr["PHONE_NUMBER"].ToString();
Address.Text = sdr["ADDRESS"].ToString();
Email.Text = sdr["EMAIL"].ToString();
CustID.Text = sdr["C_ID"].ToString();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Customer Not found!!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
//Close the connection
if (con != null)
{
con.Close();
}
}
}
private void Search_Click(object sender, EventArgs e)
{
try
{
Connect connectObj = new Connect();
using (con = connectObj.connect())
{
using (SqlCommand cmd = new SqlCommand("SELECT VID,VNAME,PHONE_NUMBER,ADDRESS,EMAIL FROM VENDOR WHERE VNAME = @vname"))
{
cmd.Parameters.AddWithValue("@vname", VendorName.Text);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
sdr.Read();
VendorID.Text = sdr["VID"].ToString();
VendorName2.Text = sdr["VNAME"].ToString();
VendorPhoneNo.Text = sdr["PHONE_NUMBER"].ToString();
VendorAddress.Text = sdr["ADDRESS"].ToString();
Email.Text = sdr["EMAIL"].ToString();
}
con.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Vendor not Found!!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void Search_Click(object sender, EventArgs e)
{
try
{
Connect connectObj = new Connect();
using (con = connectObj.connect())
{
using (SqlCommand cmd = new SqlCommand("SELECT VID FROM VENDOR WHERE VNAME = @vname"))
{
cmd.Parameters.AddWithValue("@vname", VendorName.Text);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
sdr.Read();
VendorID.Text = sdr["VID"].ToString();
}
con.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Vendor not found");
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void submitButton_Click(object sender, EventArgs e)
{
if (CustomerName.Text == "" || phno.Text == "" || CustomerAddress.Text == "" || CustomerEmail.Text == "" || customerId.Text == "")
{
MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (phno.Text.Length != 10)
{
MessageBox.Show("Enter valid Phone number", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("customer_in", con);
//To execute a stored procedure
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cid", customerId.Text);
cmd.Parameters.AddWithValue("@cname", CustomerName.Text);
cmd.Parameters.AddWithValue("@phone_number", Convert.ToInt64(phno.Text));
cmd.Parameters.AddWithValue("@address", CustomerAddress.Text);
cmd.Parameters.AddWithValue("@email", CustomerEmail.Text);
cid += 1;
int i = cmd.ExecuteNonQuery();
if (i != 0)
{
MessageBox.Show("Customer Insertion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Customer Insertion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.Close();
//Clear all the textboxes.
CustomerName.Clear();
phno.Clear();
CustomerAddress.Clear();
CustomerEmail.Clear();
customerId.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void loginButton_Click(object sender, EventArgs e)
{
/*
*
* This method is called on click on login button
*
*/
if (userName.Text == "" || this.password.Text == "")
{
MessageBox.Show("Please provide UserName and Password", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string username = userName.Text;
string password = this.password.Text;
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("Select * from LOGIN where UserName=@username and Password=@password", con);
cmd.Parameters.AddWithValue("@username", userName.Text);
cmd.Parameters.AddWithValue("@password", this.password.Text);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
int count = ds.Tables[0].Rows.Count;
//If count is equal to 1, than show frmMain form
if (count == 1)
{
MessageBox.Show("Login Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
FormMenu menu = new FormMenu();
this.Hide();
menu.Show();
}
else
{
MessageBox.Show("Invalid UserName or Password", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void Save_Click(object sender, EventArgs e)
{
//Create the orders
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("Insert into MYORDER (ORD_ID,CID,DATE,AMOUNT) values(@oid,@cid,@date,@amount);", con);
cmd.Parameters.AddWithValue("@oid", OrderID.Text);
//cmd.Parameters.AddWithValue("@pid", textBox8.Text);
cmd.Parameters.AddWithValue("@cid", cid);
cmd.Parameters.AddWithValue("@date", date.Text);
cmd.Parameters.AddWithValue("@amount", Total_Amt.Text);
int i = cmd.ExecuteNonQuery();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Order Insertion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Order Insertion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
//Insert into orderDetails
try
{
int j;
Connect connectObj = new Connect();
con = connectObj.connect();
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
SqlCommand cmd = new SqlCommand("Insert into ORDER_DETAILS (ord_id,pid,quantity) values(@oid,@pid,@quantity);", con);
cmd.Parameters.AddWithValue("@oid", OrderID.Text);
cmd.Parameters.AddWithValue("@pid", transactionDT.Rows[i]["Product ID"].ToString());
cmd.Parameters.AddWithValue("@quantity", transactionDT.Rows[i]["Quantity"].ToString());
j = cmd.ExecuteNonQuery();
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
//Update stock table after creating order
try
{
int j;
Connect connectObj = new Connect();
con = connectObj.connect();
for (int i = 0; i < transactionDT.Rows.Count; i++)
{
SqlCommand cmd = new SqlCommand("UPDATE STOCK SET QUANTITY = QUANTITY - @quantity WHERE PID = @pid", con);
cmd.Parameters.AddWithValue("@pid", transactionDT.Rows[i]["Product ID"].ToString());
cmd.Parameters.AddWithValue("@quantity", transactionDT.Rows[i]["Quantity"].ToString());
j = cmd.ExecuteNonQuery();
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
//Clear all the fields.
Cust_search.Clear();
CustName.Clear();
PhoneNumber.Clear();
Cust_address.Clear();
custEmail.Clear();
Product_search.Clear();
Product_Name.Clear();
ProductID.Clear();
Total_Amt.Text = "0";
SubTotal.Clear();
Discount.Text = "0";
GST.Clear();
PaidAmount.Clear();
ReturnAmount.Clear();
Quantity.Text = "0";
Amount.Text = "0";
AddedProducts.DataSource = null;
}
private void Add_Click(object sender, EventArgs e)
{
String PNAME = Product_Name.Text;
String PID = ProductID.Text;
if (Quantity.Text == "" || Product_Name.Text == "" || ProductID.Text == "")
{
MessageBox.Show("Enter the Quantity!!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("Select * from STOCK where PID =@pid and QUANTITY >= @quantity", con);
cmd.Parameters.AddWithValue("@pid", ProductID.Text);
cmd.Parameters.AddWithValue("@quantity", Quantity.Text);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
con.Close();
int count = ds.Tables[0].Rows.Count;
//If count is equal to 1, than show frmMain form
if (count != 1)
{
MessageBox.Show("Check stock!!!!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
decimal quantity = decimal.Parse(Quantity.Text);
decimal amount = decimal.Parse(Amount.Text);
decimal total = amount * quantity;
decimal subtotal = decimal.Parse(SubTotal.Text);
subtotal += total;
if (PNAME == "")
{
MessageBox.Show("select a product and try again", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
transactionDT.Rows.Add(PNAME, PID, quantity, amount, total);
AddedProducts.DataSource = transactionDT;
SubTotal.Text = subtotal.ToString();
if (ProductID.Text == "" || OrderID.Text == "")
{
MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Product_Name.Clear();
ProductID.Clear();
Quantity.Text = "0";
Amount.Text = "0";
}
}