public async Task <IActionResult> Put([FromBody] Models.Core.Groups data)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var _data = await db.Connection.GetAsync <Models.Core.Groups>(data.id);
if (_data != null)
{
_data.title = data.title;
_data.descs = data.descs;
_data.content = data.content;
// _data.parent_id = data.parent_id;
// _data.parents = data.parents;
_data.levels = data.levels;
_data.image = data.image;
_data.icon = data.icon;
_data.quantity = data.quantity;
_data.position = data.position;
_data.orders = data.orders;
_data.updated_by = TM.Core.HttpContext.Header();
_data.updated_at = DateTime.Now;
}
await db.Connection.UpdateAsync(_data);
return(Json(new { data = _data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Post([FromBody] Models.Core.Groups data)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
data.created_by = TM.Core.HttpContext.Header();
data.created_at = DateTime.Now;
await db.Connection.InsertOraAsync(data);
var qry = "select * from groups where group_id=(select max(group_id) from groups)";
var _data = await db.Connection.QueryAsync <Models.Core.Groups>(qry);
return(Json(new { data = _data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Put([FromBody] Models.Core.Groups data)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var nd = db.Connection.getUserFromToken(TM.Core.HttpContext.Header("Authorization"));
if (nd == null)
{
return(Json(new { msg = TM.Core.Common.Message.error_token.ToString() }));
}
var _data = await db.Connection.GetAsync <Models.Core.Groups>(data.id);
if (_data != null)
{
_data.app_key = data.app_key;
_data.code = data.code;
_data.dependent = data.dependent;
_data.levels = data.levels;
_data.title = data.title;
_data.icon = data.icon;
_data.image = data.image;
_data.url = data.url;
_data.orders = data.orders;
_data.quantity = data.quantity;
_data.descs = data.descs;
_data.content = data.content;
_data.tags = data.tags;
_data.attach = data.attach;
_data.start_at = data.start_at;
_data.end_at = data.end_at;
_data.updated_by = nd.ma_nd;
_data.updated_at = DateTime.Now;
_data.updated_ip = TM.Core.HttpContext.Header("LocalIP");
_data.flag = data.flag;
}
await db.Connection.UpdateAsync(_data);
return(Json(new { data = _data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Post([FromBody] Models.Core.Groups data)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var nd = db.Connection.getUserFromToken(TM.Core.HttpContext.Header("Authorization"));
if (nd == null)
{
return(Json(new { msg = TM.Core.Common.Message.error_token.ToString() }));
}
// if (db.Connection.isExist("Groups", "code", data.code)) return Json(new { msg = TM.Core.Common.Message.exist.ToString() });
data.created_by = nd.ma_nd;
data.created_at = DateTime.Now;
data.created_ip = TM.Core.HttpContext.Header("LocalIP");
data.flag = 1;
await db.Connection.InsertOraAsync(data);
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
