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