Example #1
0
        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);
        }
Example #2
0
 public static DeMeasurementUnit Save(DeMeasurementUnit obj)
 {
     return(new DlMeasurementUnit().Save(obj));
 }