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