// Get User for login public DataTable get_user(string u_name, string pass) { D = new DataAccessLayer.DAL(); if (D.getError()) return null; DataTable dt = new DataTable(); MySqlParameter[] param = new MySqlParameter[2]; param[0] = new MySqlParameter("u_name", MySqlDbType.VarChar); param[0].Value = u_name; param[1] = new MySqlParameter("pass", MySqlDbType.VarChar); param[1].Value = pass; dt = D.SelectData("get_user", param); return dt; }
// Add new Product public void add_product(string name, float price, int size, string category) { D = new DataAccessLayer.DAL(); if (D.getError()) return; MySqlParameter[] param = new MySqlParameter[4]; param[0] = new MySqlParameter("pro_name", MySqlDbType.VarChar); param[0].Value = name; param[1] = new MySqlParameter("price", MySqlDbType.Float); param[1].Value = price; param[2] = new MySqlParameter("size", MySqlDbType.Int32); param[2].Value = size; param[3] = new MySqlParameter("category", MySqlDbType.VarChar); param[3].Value = category; D.ExecuteCommand("add_product", param); }