public static bool Update(CustomerClassPrice customerClassPrice) { try { using (var conn = new MySqlConnection(Globals.CONN_STR)) { conn.Open(); var sql = @"UPDATE customer_class_price set end_date =@end_date, unit_price=@unit_price, modified_at=CURRENT_TIMESTAMP, modified_by=@modified_by WHERE product_code = @product_code And class_id = @class_id And start_date = @start_date"; var cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("class_id", customerClassPrice.MasterClass.ClassId); cmd.Parameters.AddWithValue("product_code", customerClassPrice.Product.ProductCode); cmd.Parameters.AddWithValue("start_date", customerClassPrice.StartDate); cmd.Parameters.AddWithValue("end_date", customerClassPrice.EndDate); cmd.Parameters.AddWithValue("unit_price", customerClassPrice.UnitPrice); cmd.Parameters.AddWithValue("modified_by", customerClassPrice.ModifiedBy); var affRow = cmd.ExecuteNonQuery(); } return(true); } catch (Exception) { throw; } }
public static bool Insert(CustomerClassPrice customerClassPrice) { try { using (var conn = new MySqlConnection(Globals.CONN_STR)) { conn.Open(); var sql = @"INSERT INTO customer_class_price (class_id, product_code, start_date, end_date, unit_price, create_by) VALUES (@class_id, @product_code, @start_date, @end_date, @unit_price, @create_by) "; var cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("class_id", customerClassPrice.MasterClass.ClassId); cmd.Parameters.AddWithValue("product_code", customerClassPrice.Product.ProductCode); cmd.Parameters.AddWithValue("start_date", customerClassPrice.StartDate); cmd.Parameters.AddWithValue("end_date", customerClassPrice.EndDate); cmd.Parameters.AddWithValue("unit_price", customerClassPrice.UnitPrice); cmd.Parameters.AddWithValue("create_by", customerClassPrice.CreateBy); var affRow = cmd.ExecuteNonQuery(); } return(true); } catch (Exception) { throw; } }