public DeSection Save(DeSection obj) { if (GetByID(obj.ID) == null) { using (MySqlConnection conn = GetConnection()) { conn.Open(); var script = $"INSERT INTO `section` (`ID`, `SectionDescription`, `LangCode`, `OrderNumber`) VALUES ({obj.ID}, '{obj.SectionDescription}', '{obj.LangCode}', {obj.OrderNumber});"; MySqlCommand cmd = new MySqlCommand(script, conn); cmd.ExecuteNonQuery(); } } else { using (MySqlConnection conn = GetConnection()) { conn.Open(); var script = $"UPDATE `section` SET `SectionDescription` = '{obj.SectionDescription}', `OrderNumber`= {obj.OrderNumber} WHERE `ID` = {obj.ID};"; MySqlCommand cmd = new MySqlCommand(script, conn); cmd.ExecuteNonQuery(); } } return(obj); }
public static DeSection Save(DeSection obj) { return(new DlSection().Save(obj)); }