public IActionResult CreateOrEditRoles(CreateOrEditRolesDto input)
{
if (input.ID == Guid.Empty.ToString() || string.IsNullOrEmpty(input.ID))
{
return(Ok(_rolesTLSRepository.CreateRoles(input, User.FindFirst(ClaimTypes.NameIdentifier).Value)));
}
else
{
return(Ok(_rolesTLSRepository.EditRoles(input, User.FindFirst(ClaimTypes.NameIdentifier).Value)));
}
}
public ResponseForm <string> CreateRoles(CreateOrEditRolesDto input, string USER_ID)
{
try
{
DynamicParameters param = new DynamicParameters();
String sql = "INSERT INTO ROLES_TLS (" +
"ID," +
"NAME," +
"DESCRIPTION, " +
"CREATED_BY, " +
"MODIFIED_USER_ID, " +
"DATE_ENTERED, " +
"DATE_MODIFIED)" +
"VALUES (" +
"@ID," +
"@NAME," +
"@DESCRIPTION, " +
"@CREATED_BY, " +
"@MODIFIED_USER_ID, " +
"@DATE_ENTERED, " +
"@DATE_MODIFIED )";
var Id = Guid.NewGuid().ToString();
param.Add("@ID", Id);
param.Add("@NAME", input.NAME);
param.Add("@DESCRIPTION", input.DESCRIPTION);
param.Add("@CREATED_BY", USER_ID);
param.Add("@MODIFIED_USER_ID", USER_ID);
param.Add("@DATE_ENTERED", DateTime.Now);
param.Add("@DATE_MODIFIED", DateTime.Now);
DapperORM.ExcecuteReturnList <RoleTLS>(sql, param);
return(new ResponseForm <string>(Id));
}
catch (Exception ex)
{
return(new ResponseForm <string>(input.ID, ex.Message, 600));
}
}
public ResponseForm <string> EditRoles(CreateOrEditRolesDto input, string USER_ID)
{
try
{
DynamicParameters param = new DynamicParameters();
string sql = "UPDATE ROLES_TLS SET " +
"NAME=@NAME, " +
"DESCRIPTION = @DESCRIPTION, " +
"MODIFIED_USER_ID = @MODIFIED_USER_ID, " +
"DATE_MODIFIED = @DATE_MODIFIED " +
"Where ID = @ID ";
param.Add("@ID", input.ID);
param.Add("@NAME", input.NAME);
param.Add("@DESCRIPTION", input.DESCRIPTION);
param.Add("@MODIFIED_USER_ID", USER_ID);
param.Add("@DATE_MODIFIED", DateTime.Now);
DapperORM.Execute(sql, param);
return(new ResponseForm <string>(input.ID));
}
catch (Exception ex)
{
return(new ResponseForm <string>(input.ID, ex.Message, 600));
}
}
