public bool CreateEmployee(String employeeName, String employeeEmail, String employeePassword, String employeeContact) { SqlConnection con = ConnectionutilityService.Connect(); bool msg = false; using (SqlCommand cmd = new SqlCommand("INSERT INTO Employee (emp_name, emp_email, emp_password, emp_contactNo) VALUES (@emp_name, @emp_email, @emp_password, @emp_contactNo)")) { cmd.Parameters.AddWithValue("@emp_name", employeeName); cmd.Parameters.AddWithValue("@emp_email", employeeEmail); cmd.Parameters.AddWithValue("@emp_password", employeePassword); cmd.Parameters.AddWithValue("@emp_contactNo", employeeContact); cmd.Connection = con; con.Open(); try { cmd.ExecuteNonQuery(); msg = true; } catch { msg = false; } con.Close(); } return(msg); }
public bool Login(String email, String password) { SqlConnection con = ConnectionutilityService.Connect(); using (SqlCommand cmd = new SqlCommand("SELECT emp_name, emp_email, emp_password from Employee where emp_email= @emp_email and emp_password = @emp_password")) { cmd.Parameters.AddWithValue("@emp_email", email); cmd.Parameters.AddWithValue("@emp_password", password); cmd.Connection = con; con.Open(); bool msg = false; SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); msg = true; } else { msg = false; } return(msg); } }
public bool updateCustomerInformation(String CId, String customerName, String CustomerAddress, String CustomerContact, String CustomerEmail, String scale) { DBConnectionUtilityService ConnectionutilityService = new DBConnectionUtilityService(); SqlConnection con = ConnectionutilityService.Connect(); int id = Convert.ToInt32(CId); bool pUpdate = false; using (SqlCommand cmd = new SqlCommand("UPDATE Customer SET cus_name=@cus_name, cus_address=@cus_address, cus_contact=@cus_contact, cus_email=@cus_email, cus_status=@cus_status where cus_id=@cus_id")) { cmd.Parameters.AddWithValue("@cus_id", id); cmd.Parameters.AddWithValue("@cus_name", customerName); cmd.Parameters.AddWithValue("@cus_address", CustomerAddress); cmd.Parameters.AddWithValue("@cus_contact", CustomerContact); cmd.Parameters.AddWithValue("@cus_email", CustomerEmail); cmd.Parameters.AddWithValue("@cus_status", scale); cmd.Connection = con; con.Open(); try { cmd.ExecuteNonQuery(); pUpdate = true; } catch { pUpdate = false; } con.Close(); } return(pUpdate); }
public bool DoPurchase(String PId, int Quantity, String Scale, String Price, String CId) { int ProductId = Convert.ToInt16(PId); float price = (float)Convert.ToDouble(Price); float totalPrice = price * Quantity; int CustomerId = Convert.ToInt16(CId); DateTime currentDateTime = dataUtilityService.GetCurrentDateTime(); bool purchaseAdd = false; int PrevQuantity = Convert.ToInt32(productService.GetProductQuantityById(PId)); int newQuantity = 0; newQuantity = PrevQuantity - Quantity; if (newQuantity >= 0) { SqlConnection con = ConnectionUtilityService.Connect(); using (SqlCommand cmd = new SqlCommand("INSERT INTO Purchase (product_id, quantity, scale, total_price, cus_id, purchase_date) VALUES (@product_id, @quantity, @scale, @total_price, @cus_id, @purchase_date)")) { cmd.Parameters.AddWithValue("@product_id", ProductId); cmd.Parameters.AddWithValue("@quantity", Quantity); cmd.Parameters.AddWithValue("@scale", Scale); cmd.Parameters.AddWithValue("@total_price", totalPrice); cmd.Parameters.AddWithValue("@cus_id", CustomerId); cmd.Parameters.AddWithValue("@purchase_date", currentDateTime); cmd.Connection = con; con.Open(); try { cmd.ExecuteNonQuery(); purchaseAdd = true; } catch { purchaseAdd = false; } con.Close(); } } else { purchaseAdd = false; } return(purchaseAdd); }
public bool AddCustomer(String customerName, String customerAddress, String customerContact, String customerEmail, String customerStatus) { SqlConnection con = ConnectionUtilityService.Connect(); bool msg = false; using (SqlCommand cmd = new SqlCommand("INSERT INTO Customer (cus_name, cus_address, cus_contact, cus_email, cus_status) VALUES (@cus_name, @cus_address, @cus_contact, @cus_email, @cus_status)")) { cmd.Parameters.AddWithValue("@cus_name", customerName); cmd.Parameters.AddWithValue("@cus_address", customerAddress); cmd.Parameters.AddWithValue("@cus_contact", customerContact); cmd.Parameters.AddWithValue("@cus_email", customerEmail); cmd.Parameters.AddWithValue("@cus_status", customerStatus); cmd.Connection = con; con.Open(); try { cmd.ExecuteNonQuery(); msg = true; } catch { msg = false; } con.Close(); } return(msg); }
public bool AddCategory(String Catname) { bool catAdd = false; SqlConnection con = ConnectionutilityService.Connect(); using (SqlCommand cmd = new SqlCommand("INSERT INTO ProductCategory (CategoryName) VALUES (@cat_name)")) { cmd.Parameters.AddWithValue("@cat_name", Catname); cmd.Connection = con; con.Open(); try { cmd.ExecuteNonQuery(); catAdd = true; } catch { catAdd = false; } con.Close(); } return(catAdd); //return "Hello World"; }