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