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