//check if the serialnumber exist public bool CheckVisibleSerialnumber(string serialnumber) { GetConnectionString(connection.server(), connection.database(), connection.username(), connection.password()); SalesProductModel ldata = new SalesProductModel(); string txt = "select * from product where serialnumber=" + serialnumber; MySqlCommand command = new MySqlCommand(txt, Connection); Connection.Open(); MySqlDataReader r = command.ExecuteReader(); while (r.Read()) { ldata.Id = r[0].ToString(); ldata.Name = r[1].ToString(); ldata.Serialnumber = Convert.ToInt32(r[2]); ldata.Quantity = Convert.ToInt32(r[4]); ldata.Unitprice = Convert.ToInt32(r[5]); } Connection.Close(); if (Convert.ToInt32(serialnumber) != ldata.Serialnumber) { return(false); } return(true); }
public SalesProductModel GetProductByID(string id) { SalesProductModel ldata = new SalesProductModel(); string txt = "select * from product where id=" + id; MySqlCommand command = new MySqlCommand(txt, Connection); Connection.Open(); MySqlDataReader r = command.ExecuteReader(); while (r.Read()) { ldata.Id = r[0].ToString(); ldata.Name = r[1].ToString(); ldata.Serialnumber = Convert.ToInt32(r[2]); ldata.Quantity = Convert.ToInt32(r[4]); ldata.Unitprice = Convert.ToInt32(r[5]); } Connection.Close(); return(ldata); }
public bool AddProduct(SalesProductModel data) { try { string txt = "INSERT INTO `product`(`name`, `serialnumber`, `description`, `quantity`, `priceperunit`, `dateimport`) " + "VALUES (@name, @serialnumber, @description,@quantity,@priceperunit,@dateimport)"; MySqlCommand command = new MySqlCommand(txt, Connection); Connection.Open(); command.Parameters.AddWithValue("@name", data.Name); command.Parameters.AddWithValue("@serialnumber", data.Serialnumber); command.Parameters.AddWithValue("@description", data.Description); command.Parameters.AddWithValue("@quantity", data.Quantity); command.Parameters.AddWithValue("@priceperunit", data.Unitprice); command.Parameters.AddWithValue("@dateimport", data.DateImport); command.ExecuteNonQuery(); Connection.Close(); return(true); } catch (Exception e) { return(false); } }