public bool CreateNewProduct(string name, int idType, uint price, string description, int inew) { const string query = "INSERT INTO product (name, id_type, price, description, new) VALUES (@name,@type,@pri,@des,@inew)"; var sqlParameters = new MySqlParameter[5]; sqlParameters[0] = new MySqlParameter("@name", MySqlDbType.String) { Value = name }; sqlParameters[1] = new MySqlParameter("@type", MySqlDbType.Int32) { Value = idType }; sqlParameters[2] = new MySqlParameter("@pri", MySqlDbType.UInt32) { Value = price }; sqlParameters[3] = new MySqlParameter("@des", MySqlDbType.String) { Value = description }; sqlParameters[4] = new MySqlParameter("@inew", MySqlDbType.Int32) { Value = inew }; return(_mySqlDbConnection.ExecuteInsertQuery(query, sqlParameters)); }
public bool CreateNewProductType(string name, string image) { const string query = "INSERT INTO product_type(name, image) values (@name, @img)"; var sqlParameters = new MySqlParameter[2]; sqlParameters[0] = new MySqlParameter("@name", MySqlDbType.String) { Value = name }; sqlParameters[1] = new MySqlParameter("@img", MySqlDbType.String) { Value = image }; return(_mySqlDbConnection.ExecuteInsertQuery(query, sqlParameters)); }
public bool CreateImage(string link, int?sp) { const string query = "insert into images(link,id_product) values (@link, @sp)"; var sqlParameters = new MySqlParameter[2]; sqlParameters[0] = new MySqlParameter("@link", MySqlDbType.VarChar) { Value = link }; sqlParameters[1] = new MySqlParameter("@sp", MySqlDbType.Int32) { Value = sp }; return(mySqlDbConnection.ExecuteInsertQuery(query, sqlParameters)); }
public bool CreateNewBill(int idCus, DateTime dateOrder, DateTime expectedDateOrder, int total, string addr, string dis, string city, string note, int status, int idShipper) { const string query = "INSERT INTO bill (id_customer, date_order, expected_date_order, total, address, district, city, note, status, id_shipper) VALUES (@cus, @dateOrder, @expDateOrder, @total, @addr, @dis, @city, @note, @stt, @shipper)"; var sqlParameters = new MySqlParameter[6]; sqlParameters[0] = new MySqlParameter("@cus", MySqlDbType.Int32) { Value = idCus }; sqlParameters[1] = new MySqlParameter("@dateOrder", MySqlDbType.DateTime) { Value = dateOrder }; sqlParameters[2] = new MySqlParameter("@expDateOrder", MySqlDbType.DateTime) { Value = expectedDateOrder }; sqlParameters[3] = new MySqlParameter("@total", MySqlDbType.String) { Value = total }; sqlParameters[4] = new MySqlParameter("@addr", MySqlDbType.String) { Value = addr }; sqlParameters[5] = new MySqlParameter("@dis", MySqlDbType.String) { Value = dis }; sqlParameters[6] = new MySqlParameter("@city", MySqlDbType.String) { Value = city }; sqlParameters[7] = new MySqlParameter("@note", MySqlDbType.Text) { Value = note }; sqlParameters[8] = new MySqlParameter("@stt", MySqlDbType.Int32) { Value = status }; sqlParameters[9] = new MySqlParameter("@shipper", MySqlDbType.Int32) { Value = idShipper }; return(_mySqlDbConnection.ExecuteInsertQuery(query, sqlParameters)); }
public bool CreateNewShipper(string name, string phone, string mail) { const string query = "INSERT INTO shippers (name, phone, email) VALUES(@name, @phone, @mail)"; var sqlParameters = new MySqlParameter[3]; sqlParameters[0] = new MySqlParameter("@name", MySqlDbType.VarChar) { Value = name }; sqlParameters[1] = new MySqlParameter("@mail", MySqlDbType.VarChar) { Value = mail }; sqlParameters[2] = new MySqlParameter("@phone", MySqlDbType.VarChar) { Value = phone }; return(_mySqlDbConnection.ExecuteInsertQuery(query, sqlParameters)); }
public bool CreateImportProduct(int supplierId, string supplierName, int productId, string productName, uint quantity, uint unitPrice) { const string query = "INSERT INTO import (supplierId, supplierName, productId, productName, quantity, unitPrice, totalPrice) VALUES (@supplierId, @supplierName, @productId, @productName, @quantity, @unitPrice, @totalPrice)"; var sqlParameters = new MySqlParameter[7]; sqlParameters[0] = new MySqlParameter("@supplierId", MySqlDbType.Int32) { Value = supplierId }; sqlParameters[1] = new MySqlParameter("@supplierName", MySqlDbType.VarChar) { Value = supplierName }; sqlParameters[2] = new MySqlParameter("@productId", MySqlDbType.Int32) { Value = productId }; sqlParameters[3] = new MySqlParameter("@productName", MySqlDbType.VarChar) { Value = productName }; sqlParameters[4] = new MySqlParameter("@quantity", MySqlDbType.Int32) { Value = quantity }; sqlParameters[5] = new MySqlParameter("@unitPrice", MySqlDbType.Int32) { Value = unitPrice }; sqlParameters[6] = new MySqlParameter("@totalPrice", MySqlDbType.Int32) { Value = quantity * unitPrice }; return(_mySqlDbConnection.ExecuteInsertQuery(query, sqlParameters)); }