public DeAppInfo Save(DeAppInfo obj)
{
if (GetByCode(obj.InfoCode)?.FirstOrDefault(x => x.LangCode == obj.LangCode) == null)
{
using (MySqlConnection conn = GetConnection())
{
conn.Open();
var script = $"INSERT INTO `app_info` (`InfoCode`, `InfoContent`, `LangCode`, `UpdateDateTime`) VALUES ('{obj.InfoCode}', '{obj.InfoContent}', '{obj.LangCode}', '{obj.UpdateDateTime.ToString("yyyy-MM-dd hh:mm:ss")}');";
MySqlCommand cmd = new MySqlCommand(script, conn);
cmd.ExecuteNonQuery();
}
}
else
{
using (MySqlConnection conn = GetConnection())
{
conn.Open();
var script = $"UPDATE `app_info` SET `InfoContent` = '{obj.InfoContent}', `UpdateDateTime` = '{obj.UpdateDateTime.ToString("yyyy-MM-dd HH:mm:ss")}' WHERE `InfoCode` = '{obj.InfoCode}' AND `LangCode` = '{obj.LangCode}';";
MySqlCommand cmd = new MySqlCommand(script, conn);
cmd.ExecuteNonQuery();
}
}
return(obj);
}
public static ApiResponse Save(DeAppInfo model)
{
var result = new ApiResponse();
var dl = new DlAppInfo();
try
{
var obj = dl.GetByCode(model.InfoCode).FirstOrDefault(x => x.LangCode == model.LangCode);
if (obj != null)
{
model.UpdateDateTime = DateTime.Now;
if (obj.InfoContent != model.InfoContent)
{
obj.InfoContent = model.InfoContent;
obj.UpdateDateTime = model.UpdateDateTime;
}
obj = dl.Save(obj);
result = new ApiResponse()
{
Success = true, Payload = obj
};
}
else
{
result = new ApiResponse()
{
Success = false, Payload = null, Message = "Not valid Info"
}
};
}
catch (Exception ex)
{
result = new ApiResponse()
{
Success = false, Payload = null, Message = ex.Message
};
}
return(result);
}
