public static bool Insert(TruckType truckType)
{
try
{
using (var conn = new MySqlConnection(Globals.CONN_STR))
{
conn.Open();
var sql = @"INSERT INTO slaughterhouse.truck_type
(
truck_type_desc,
active,
create_by )
VALUES (
@truck_type_desc,
@active,
@create_by)";
var cmd = new MySqlCommand(sql, conn);
//cmd.Parameters.AddWithValue("truck_type_id", truckType.TruckTypeId);
cmd.Parameters.AddWithValue("truck_type_desc", truckType.TruckTypeDesc);
cmd.Parameters.AddWithValue("active", truckType.Active);
cmd.Parameters.AddWithValue("create_by", truckType.CreateBy);
var affRow = cmd.ExecuteNonQuery();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public static bool Update(TruckType truckType)
{
try
{
using (var conn = new MySqlConnection(Globals.CONN_STR))
{
conn.Open();
var sql = @"UPDATE truck_type
SET truck_type_desc=@truck_type_desc,
active=@active,
modified_at=CURRENT_TIMESTAMP,
modified_by=@modified_by
WHERE truck_type_id=@truck_type_id";
var cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("truck_type_id", truckType.TruckTypeId);
cmd.Parameters.AddWithValue("truck_type_desc", truckType.TruckTypeDesc);
cmd.Parameters.AddWithValue("active", truckType.Active);
cmd.Parameters.AddWithValue("modified_by", truckType.ModifiedBy);
var affRow = cmd.ExecuteNonQuery();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public static TruckType GetTruckType(int truckTypeId)
{
try
{
using (var conn = new MySqlConnection(Globals.CONN_STR))
{
conn.Open();
var sb = new StringBuilder();
sb.Append("select * from truck_type");
sb.Append(" where truck_type_id = @truck_type_id");
var cmd = new MySqlCommand(sb.ToString(), conn);
cmd.Parameters.AddWithValue("truck_type_id", truckTypeId);
var da = new MySqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds);
var truckType = new TruckType();
if (ds.Tables[0].Rows.Count > 0)
{
return(new TruckType
{
TruckTypeId = Convert.ToInt32(ds.Tables[0].Rows[0]["truck_type_id"]),
TruckTypeDesc = ds.Tables[0].Rows[0]["truck_type_desc"].ToString(),
Active = (bool)ds.Tables[0].Rows[0]["active"],
CreateAt = (DateTime)ds.Tables[0].Rows[0]["create_at"],
});
}
else
{
return(null);
}
}
}
catch (Exception)
{
throw;
}
}
