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";
}
