public static ProductGroup GetProductGroup(string product_group_code)
{
try
{
using (var conn = new MySqlConnection(Globals.CONN_STR))
{
conn.Open();
var sb = new StringBuilder();
sb.Append("select * from product_group");
sb.Append(" where product_group_code = @product_group_code");
var cmd = new MySqlCommand(sb.ToString(), conn);
cmd.Parameters.AddWithValue("product_group_code", product_group_code);
var da = new MySqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
var farm = new ProductGroup();
if (ds.Tables[0].Rows.Count > 0)
{
return(new ProductGroup
{
ProductGroupCode = (int)ds.Tables[0].Rows[0]["product_group_code"],
ProductGroupName = ds.Tables[0].Rows[0]["product_group_name"].ToString(),
Active = (bool)ds.Tables[0].Rows[0]["active"],
CreateAt = (DateTime)ds.Tables[0].Rows[0]["create_at"],
});
}
else
{
return(null);
}
}
}
catch (Exception)
{
throw;
}
}