public bool updateWarehouse(DTO.Kho kho) { string sql = "UPDATE tb_warehouse SET number=@number WHERE id_hh=@id"; MySqlConnection con = dc.getConnection(); try { cmd = new MySqlCommand(sql, con); con.Open(); cmd.Parameters.Add("id", MySqlDbType.VarChar).Value = kho.id_hh; cmd.Parameters.Add("number", MySqlDbType.VarChar).Value = kho.number; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception) { return(false); } return(true); }
public bool insertWarehouse(DTO.Kho kho) { string sql = "INSERT INTO tb_warehouse(id_hh, namecommodity, number) VALUES (@id_hh, @namecommodity, @number)"; MySqlConnection con = dc.getConnection(); try { cmd = new MySqlCommand(sql, con); con.Open(); cmd.Parameters.Add("id_hh", MySqlDbType.VarChar).Value = kho.id_hh; cmd.Parameters.Add("namecommodity", MySqlDbType.VarChar).Value = kho.namecommodity; cmd.Parameters.Add("number", MySqlDbType.VarChar).Value = kho.number; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception) { return(false); } return(true); }
public bool insertWarehouse(DTO.Kho kho) { return(dalk.insertWarehouse(kho)); }
public bool updateWarehouse(DTO.Kho kho) { return(dalk.updateWarehouse(kho)); }