public async Task <ObjectResult> Put(int id, [FromBody] ListdomainObject domain)
{
GenericResult rs = new GenericResult();
//DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
try
{
string command = $"dbo.Listdomain_Upd @p_ID= {domain.ID},@p_DOMAIN = '{domain.DOMAIN}',@p_USER_ID='{domain.USER_ID}',@p_USERNAME='******',@p_DESCRIPTION = N'{domain.DESCRIPTION}',@p_RECORD_STATUS = '{domain.RECORD_STATUS}',@p_AUTH_STATUS = '{domain.AUTH_STATUS}',@p_CREATE_DT = '{domain.CREATE_DT}',@p_APPROVE_DT = '{domain.APPROVE_DT}',@p_EDIT_DT = '{DateTime.Now.Date}',@p_MAKER_ID = '{domain.MAKER_ID}',@p_CHECKER_ID = '{domain.CHECKER_ID}',@p_EDITOR_ID = '{domain.EDITOR_ID}'";
var result = await _context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None);
if (result > 0)
{
rs.Succeeded = true;
rs.Message = "Cập nhật Domain thành công";
}
else
{
rs.Succeeded = false;
rs.Message = "Đã có lỗi xảy ra";
}
ObjectResult objRes = new ObjectResult(rs);
//context.Dispose();
return(objRes);
}
catch (Exception ex)
{
rs.Succeeded = false;
rs.Message = ex.Message;
ObjectResult objRes = new ObjectResult(rs);
//context.Dispose();
return(objRes);
}
}
public async Task <ObjectResult> Post([FromBody] ListdomainObject domain)
{
GenericResult rs = new GenericResult();
//DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
try
{
string command = $"dbo.Listdomain_Ins @p_DOMAIN = '{domain.DOMAIN}',@p_USER_ID = '{domain.USER_ID}',@p_USERNAME='******',@p_DESCRIPTION=N'{domain.DESCRIPTION}',@p_RECORD_STATUS='1',@p_AUTH_STATUS ='U',@p_CREATE_DT = '{DateTime.Now.Date}',@p_APPROVE_DT = '',@p_EDIT_DT ='',@p_MAKER_ID = '{domain.USERNAME}',@p_CHECKER_ID ='',@p_EDITOR_ID=''";
var result = await _context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None);
//return result;
if (result != -1)
{
rs.Message = "Thêm domain thành công";
rs.Succeeded = true;
}
else
{
rs.Message = "Có lỗi xảy ra trong quá trình thêm!";
rs.Succeeded = false;
}
ObjectResult objRes = new ObjectResult(rs);
//context.Dispose();
return(objRes);
}
catch (Exception ex)
{
rs.Message = "Lỗi " + ex.Message;
rs.Succeeded = false;
ObjectResult objRes = new ObjectResult(rs);
//context.Dispose();
return(objRes);
}
}
public async Task <int> Post([FromBody] ListdomainObject domain)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
string command = $"dbo.Listdomain_Ins @p_DOMAIN = '{domain.DOMAIN}',@p_USER_ID = '{domain.USER_ID}',@p_USERNAME='******',@p_DESCRIPTION='{domain.DESCRIPTION}',@p_RECORD_STATUS='1',@p_AUTH_STATUS ='U',@p_CREATE_DT = '{DateTime.Now}',@p_APPROVE_DT = '',@p_EDIT_DT ='',@p_MAKER_ID = 'thieu1234',@p_CHECKER_ID ='',@p_EDITOR_ID=''";
var result = await context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None);
return(result);
}
public async Task <int> Put(int id, [FromBody] ListdomainObject domain)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
string command = $"dbo.Listdomain_Upd @p_ID= {domain.ID},@p_DOMAIN = '{domain.DOMAIN}',@p_USER_ID='{domain.USER_ID}',@p_USERNAME='******',@p_DESCRIPTION = '{domain.DESCRIPTION}',@p_RECORD_STATUS = '{domain.RECORD_STATUS}',@p_AUTH_STATUS = '{domain.AUTH_STATUS}',@p_CREATE_DT = '{domain.CREATE_DT}',@p_APPROVE_DT = '{domain.APPROVE_DT}',@p_EDIT_DT = '{domain.EDIT_DT}',@p_MAKER_ID = '{domain.MAKER_ID}',@p_CHECKER_ID = '{domain.CHECKER_ID}',@p_EDITOR_ID = '{domain.EDITOR_ID}'";
var result = await context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None);
return(result);
}
