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