public DeMeasurementUnit Save(DeMeasurementUnit obj) { if (GetByCode(obj.Code) == null) { using (MySqlConnection conn = GetConnection()) { conn.Open(); var script = $"INSERT INTO `measurement_unit` (`Code`, `Description`) VALUES ('{obj.Code}', '{obj.Description}');"; MySqlCommand cmd = new MySqlCommand(script, conn); cmd.ExecuteNonQuery(); } } else { using (MySqlConnection conn = GetConnection()) { conn.Open(); var script = $"UPDATE `measurement_unit` SET `Description` = '{obj.Description}' WHERE `Code` = {obj.Code};"; MySqlCommand cmd = new MySqlCommand(script, conn); cmd.ExecuteNonQuery(); } } return(obj); }
public static DeMeasurementUnit Save(DeMeasurementUnit obj) { return(new DlMeasurementUnit().Save(obj)); }