public static bool AddProducts(Mc_Products pro)
{
MySqlConnection Conn = DBConnection.ConnMcComputers;
string Strsql = "INSERT INTO `mc_product`(`mc_ID`,`mc_Name`,`mc_Description`,`mc_qty`,`mc_unitprice`) VALUES('" + pro.productID + "','" + pro.productName + "','" + pro.productDescription + "','" + pro.productQty + "','" + pro.productUnitPrice + "')";
try
{
if (Conn.State == ConnectionState.Closed)
{
Conn.Open();
}
MySqlCommand cmd = new MySqlCommand(Strsql, Conn);
cmd.CommandTimeout = 60;
if (cmd.ExecuteNonQuery() == 1)
{
return(true);
}
}
catch (MySqlException er)
{
Console.WriteLine(er.Message.ToString());
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
return(false);
}
// POST api/mccomputers
public void Post(string name, string Description, int qty, float unitprice)
{
Mc_Products products = new Mc_Products();
products.productID = MasterImplementation.AutoIDGenarator("mc_product");
products.productName = name;
products.productDescription = Description;
products.productQty = qty;
products.productUnitPrice = unitprice;
if (MasterImplementation.AddProducts(products))
{
string jsonmessage = @"{
'Message': true
}";
var json = JsonConvert.SerializeObject(jsonmessage);
Console.WriteLine(json);
}
else
{
string jsonmessage = @"{
'Message': false
}";
var json = JsonConvert.SerializeObject(jsonmessage);
Console.WriteLine(json);
}
}
public static List <Mc_Products> GetAllProducts()
{
List <Mc_Products> Productslist = new List <Mc_Products>();
MySqlConnection Conn = DBConnection.ConnMcComputers;
String Srtsql = "Select mc_ID,mc_Name,mc_Description,mc_qty,mc_unitprice from mc_product";
try
{
if (Conn.State == ConnectionState.Closed)
{
Conn.Open();
}
MySqlCommand Cmd = new MySqlCommand(Srtsql, Conn);
Cmd.CommandTimeout = 60;
MySqlDataReader dr = Cmd.ExecuteReader();
if (dr.HasRows)
{
try
{
while (dr.Read())
{
Mc_Products products = new Mc_Products();
products.productID = dr.GetString(0);
products.productName = dr.GetString(1);
products.productDescription = dr.GetString(2);
products.productQty = dr.GetInt32(3);
products.productUnitPrice = dr.GetFloat(4);
Productslist.Add(products);
}
return(Productslist);
}
catch (MySqlException er)
{
Console.WriteLine(er.Message.ToString());
}
finally
{
dr.Close();
}
return(Productslist);
}
else
{
return(Productslist);
}
}
catch (MySqlException er)
{
Console.WriteLine(er.Message.ToString());
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
return(Productslist);
}
