public async Task <Users> GetUserById(int userid, string username)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
var result = await context.Users.FromSql("dbo.Users_ById @p_USERNAME = {0}, @p_USERID = {1}", username, userid).SingleAsync();
return(result);
}
public async Task <IEnumerable <Optionlinks> > Get(string domain)
{
var pagination = Request.Headers["Pagination"];
if (!string.IsNullOrEmpty(pagination))
{
string[] vals = pagination.ToString().Split(',');
int.TryParse(vals[0], out _page);
int.TryParse(vals[1], out _pageSize);
}
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
var result = await context.Optionlinks.FromSql("dbo.Optionlinks_Search @DOMAIN = {0} ", domain).ToArrayAsync();
int currentPage = _page;
int currentPageSize = _pageSize;
var totalRecord = result.Count();
var totalPages = (int)Math.Ceiling((double)totalRecord / _pageSize);
var optionlinks = result.Skip((currentPage - 1) * currentPageSize).Take(currentPageSize);
Response.AddPagination(_page, _pageSize, totalRecord, totalPages);
IEnumerable <Optionlinks> listPagedOptionLink = Mapper.Map <IEnumerable <Optionlinks>, IEnumerable <Optionlinks> >(optionlinks);
return(listPagedOptionLink);
}
public async Task <OptionSearchObject> Get(string domain)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
var result = await context.OptionSearchObject.FromSql("dbo.Option_Search @DOMAIN = {0} , @USERNAME='', @RECORD_STATUS = '',@IS_LIMIT ='',@TIMES='' ", domain).SingleAsync();
return(result);
}
public async Task <IEnumerable <Users> > Get(int parentid, string parentname)
{
var pagination = Request.Headers["Pagination"];
if (!string.IsNullOrEmpty(pagination))
{
string[] vals = pagination.ToString().Split(',');
int.TryParse(vals[0], out _page);
int.TryParse(vals[1], out _pageSize);
}
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
var result = await context.Users.FromSql("dbo.Users_ByParent @p_PARENT_ID = {0}, @p_PARENT_NAME = {1}", 1056, "thieu1234").ToArrayAsync();
int currentPage = _page;
int currentPageSize = _pageSize;
var totalRecord = result.Count();
var totalPages = (int)Math.Ceiling((double)totalRecord / _pageSize);
var users = result.Skip((currentPage - 1) * currentPageSize).Take(currentPageSize);
Response.AddPagination(_page, _pageSize, totalRecord, totalPages);
IEnumerable <Users> listPagedUser = Mapper.Map <IEnumerable <Users>, IEnumerable <Users> >(users);
return(listPagedUser);
}
public async Task <IEnumerable <ListdomainObject> > Get(string userid)
{
var pagination = Request.Headers["Pagination"];
if (!string.IsNullOrEmpty(pagination))
{
string[] vals = pagination.ToString().Split(',');
int.TryParse(vals[0], out _page);
int.TryParse(vals[1], out _pageSize);
}
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
string command = $"dbo.Listdomain_Search @USER = '******', @DOMAIN = '',@RECORD_STATUS = '1',@CREATE_DT=''";
var result = await context.ListdomainObject.FromSql(command).ToArrayAsync();
int currentPage = _page;
int currentPageSize = _pageSize;
var totalRecord = result.Count();
var totalPages = (int)Math.Ceiling((double)totalRecord / _pageSize);
var domains = result.Skip((currentPage - 1) * currentPageSize).Take(currentPageSize);
Response.AddPagination(_page, _pageSize, totalRecord, totalPages);
IEnumerable <ListdomainObject> listPagedDomain = Mapper.Map <IEnumerable <ListdomainObject>, IEnumerable <ListdomainObject> >(domains);
return(listPagedDomain);
}
public IEnumerable <UserDomainSearchObject> Get(string domain)
{
var pagination = Request.Headers["Pagination"];
if (!string.IsNullOrEmpty(pagination))
{
string[] vals = pagination.ToString().Split(',');
int.TryParse(vals[0], out _page);
int.TryParse(vals[1], out _pageSize);
}
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
string command = $"dbo.Optionsuser_Search @USER = '', @DOMAIN = '{domain}'";
var result = context.UserDomainSearchObject.FromSql(command).ToArray();
int currentPage = _page;
int currentPageSize = _pageSize;
var totalRecord = result.Count();
var totalPages = (int)Math.Ceiling((double)totalRecord / _pageSize);
var optionlinks = result.Skip((currentPage - 1) * currentPageSize).Take(currentPageSize);
Response.AddPagination(_page, _pageSize, totalRecord, totalPages);
IEnumerable <UserDomainSearchObject> listPagedOptionLink = Mapper.Map <IEnumerable <UserDomainSearchObject>, IEnumerable <UserDomainSearchObject> >(optionlinks);
return(listPagedOptionLink);
}
public async Task <IActionResult> Delete(int id)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
var result = await context.Database.ExecuteSqlCommandAsync("Users_Del @ID = {0}", cancellationToken : CancellationToken.None, parameters : id);
//return result;
GenericResult removeResult = new GenericResult();
if (result == 1)
{
removeResult = new GenericResult()
{
Succeeded = true,
Message = "Users removed."
};
}
else
{
removeResult = new GenericResult()
{
Succeeded = false,
Message = "Failed to delete"
};
}
ObjectResult deleteResult = new ObjectResult(removeResult);
return(deleteResult);
}
public async Task <int> Put(string id, [FromBody] List <UserConfigObject> user)
{
XElement xmldata = new XElement(new XElement("Root"));
foreach (var item in user)
{
if (item.VALUE_TYPE.Equals("CHECKBOX"))
{
if (item.CONF_VALUE.Equals("true"))
{
item.CONF_VALUE = "1";
}
else if (item.CONF_VALUE.Equals("false"))
{
item.CONF_VALUE = "0";
}
}
XElement x = new XElement("Config", new XElement("CONF_TYPE", item.CONF_TYPE),
new XElement("CONF_VALUE", item.CONF_VALUE));
xmldata.Add(x);
}
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
string command = $"dbo.Userconfig_Upd @USER = '******', @CONFIG = '{xmldata}'";
var result = context.Database.ExecuteSqlCommand(command);
int t = 5;
//string password = MD5Encoder.MD5Hash(user.Password);
//string command = $"dbo.Users_Upd @p_ID={user.Id},@p_USERNAME = {user.Username},@p_FULLNAME={user.Fullname},@p_PASSWORD={password},@p_EMAIL = {user.Email},@p_PHONE={user.Phone},@p_PARENT_ID={user.ParentId},@p_DESCRIPTION={user.Description},@p_RECORD_STATUS={user.RecordStatus},@p_AUTH_STATUS={user.AuthStatus},@p_CREATE_DT={user.CreateDt},@p_APPROVE_DT={user.ApproveDt},@p_EDIT_DT={user.EditDt},@p_MAKER_ID={user.MakerId},@p_CHECKER_ID={user.CheckerId},@p_EDITOR_ID={user.EditorId}";
//var result = await context.Database.ExecuteSqlCommandAsync(command, cancellationToken: CancellationToken.None);
return(result);
}
public async Task <IEnumerable <UserConfigObject> > Get(string id)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
var result = await context.UserConfigObject.FromSql("dbo.Configtype_ByUser @USER = {0}", id).ToArrayAsync();
return(result);
}
public async Task <int> Put(int id, [FromBody] OptionUpdateObject option)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
string command = $"dbo.Options_Upd @p_ID= {option.OPTION.ID},@p_DOMAIN_ID ='{option.OPTION.DOMAIN_ID}',@p_IS_LIMIT ='{option.OPTION.IS_LIMIT}',@p_TIMES= {option.OPTION.TIMES} ";
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);
}
public async Task <int> Delete(int id)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
string command = $"dbo.Listdomain_Del @ID={id}";
var result = await context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None);
return(result);
}
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] Users user)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
string password = MD5Encoder.MD5Hash(user.Password);
string command = $"dbo.Users_Upd @p_ID={user.Id},@p_USERNAME = '******',@p_FULLNAME='{user.Fullname}',@p_PASSWORD='******',@p_EMAIL = '{user.Email}',@p_PHONE={user.Phone},@p_PARENT_ID={user.ParentId},@p_DESCRIPTION='{user.Description}',@p_RECORD_STATUS='{user.RecordStatus}',@p_AUTH_STATUS='{user.AuthStatus}',@p_CREATE_DT='{user.CreateDt}',@p_APPROVE_DT='{user.ApproveDt}',@p_EDIT_DT='{user.EditDt}',@p_MAKER_ID='{user.MakerId}',@p_CHECKER_ID='{user.CheckerId}',@p_EDITOR_ID='{user.EditorId}'";
var result = await context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None);
return(result);
}
public async Task <int> Post([FromBody] Features feature)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
feature.CreateDt = DateTime.Now;
feature.MakerId = "thieu1234";
feature.RecordStatus = "1";
feature.AuthStatus = "U";
var command = $"dbo.Features_Ins @p_FEA_TYPE = '{feature.FeaType}' ,@p_CONTENTS = '{feature.Contents}', @p_LEVEL ={feature.Level}, @p_RESOURCE = '{feature.Resource}', @p_RECORD_STATUS='{feature.RecordStatus}', @p_AUTH_STATUS = '{feature.AuthStatus}', @p_APPROVE_DT = '{feature.ApproveDt.Value.Date}', @p_EDIT_DT = '{feature.EditDt.Value.Date}', @p_CHECKER_ID = '{feature.CheckerId}', @p_EDITOR_ID = '{feature.EditorId}', @p_CREATE_DT='{feature.CreateDt.Value.Date}', @p_MAKER_ID = '{feature.MakerId}'";
var result = await context.Database.ExecuteSqlCommandAsync(command);
return(result);
}
public async Task <int> Post([FromBody] UserObject user)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
string pass = MD5Encoder.MD5Hash(user.Password);
XElement xmldata = new XElement(new XElement("Root"));
XElement x = new XElement("Domain", new XElement("DOMAIN", user.Domain),
new XElement("DESCRIPTION", user.DomainDesc));
xmldata.Add(x);
string command = $"dbo.Users_Ins @p_USERNAME = '******', @p_FULLNAME='{user.Fullname}',@p_PASSWORD = '******',@p_EMAIL = '{user.Email}',@p_PHONE = {user.Phone},@p_PARENT_ID = {user.ParentId},@p_DESCRIPTION = '{user.Description}',@p_RECORD_STATUS = '{user.RecordStatus}',@p_AUTH_STATUS = '{user.AuthStatus}',@p_CREATE_DT = '{DateTime.Now}',@p_APPROVE_DT ='',@p_EDIT_DT='',@p_MAKER_ID ='{user.MakerId}',@p_CHECKER_ID = '{user.CheckerId}',@p_EDITOR_ID = '{user.EditorId}',@DOMAIN ={xmldata}";
var result = await context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None);
return(result);
}
public async Task <IActionResult> Login([FromBody] LoginViewModel user)
{
IActionResult _result = new ObjectResult(false);
GenericResult _authenticationResult = null;
try
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
string password = MD5Encoder.MD5Hash(user.Password);
string command = $"dbo.Users_CheckLogin @p_USERNAME = '******',@p_PASSWORD='******',@p_TOKEN='{null}'";
var result = await context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None);
if (result == 1)
{
_authenticationResult = new GenericResult()
{
Succeeded = true,
Message = "Authentication succeeded"
};
}
else
{
_authenticationResult = new GenericResult()
{
Succeeded = false,
Message = "Authentication failed"
};
}
}
catch (Exception ex)
{
_authenticationResult = new GenericResult()
{
Succeeded = false,
Message = ex.Message
};
_loggingRepository.Add(new Error()
{
Message = ex.Message, StackTrace = ex.StackTrace, DateCreated = DateTime.Now
});
_loggingRepository.Commit();
}
_result = new ObjectResult(_authenticationResult);
return(_result);
}
public int ChangePassword(string username, string currentpassword, string newpassword)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
var result = context.Users.FromSql("dbo.Users_ById @p_USERNAME = {0}, @p_USERID = null ", username).Single();
if (MD5Encoder.MD5Hash(currentpassword).Equals(result.Password))
{
result.Password = MD5Encoder.MD5Hash(newpassword);
string command = $"dbo.Users_Upd @p_ID={result.Id},@p_USERNAME = '******',@p_FULLNAME=N'{result.Fullname}',@p_PASSWORD='******',@p_EMAIL = '{result.Email}',@p_PHONE={result.Phone},@p_PARENT_ID='{result.ParentId}',@p_DESCRIPTION=N'{result.Description}',@p_RECORD_STATUS='{result.RecordStatus}',@p_AUTH_STATUS='{result.AuthStatus}',@p_CREATE_DT='{result.CreateDt}',@p_APPROVE_DT='{result.ApproveDt}',@p_EDIT_DT='{DateTime.Now.Date}',@p_MAKER_ID='{result.MakerId}',@p_CHECKER_ID='{result.CheckerId}',@p_EDITOR_ID='{result.EditorId}'";
int updResult = context.Database.ExecuteSqlCommand(command);
return(updResult);
}
else
{
return(-1);
}
}
public async Task <IActionResult> Get(int?page, int?pageSize)
{
//var file = Request.;
PaginationSet <Messages> pagedSet = new PaginationSet <Messages>();
// var pagination = Request.Headers;
//if (!string.IsNullOrEmpty(pagination))
//{
// string[] vals = pagination.ToString().Split(',');
// int.TryParse(vals[0], out _page);
// int.TryParse(vals[1], out _pageSize);
//}
//if (await _authorizationService.AuthorizeAsync(User, "AdminOnly"))
//{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
var result =
await context.Messages.FromSql("dbo.Messages_Search @USER = {0}, @DOMAIN = {1} , @STATUS = {2}",
"thieu1234", null, null).ToArrayAsync();
int currentPage = page.Value;
int currentPageSize = pageSize.Value;
var totalRecord = result.Count();
var totalPages = (int)Math.Ceiling((double)totalRecord / _pageSize);
var messages = result.Skip((currentPage - 1) * currentPageSize).Take(currentPageSize);
Response.AddPagination(_page, _pageSize, totalRecord, totalPages);
IEnumerable <Messages> listPagedMessage =
Mapper.Map <IEnumerable <Messages>, IEnumerable <Messages> >(messages);
pagedSet = new PaginationSet <Messages>()
{
Page = currentPage,
TotalCount = totalRecord,
TotalPages = totalPages,
Items = listPagedMessage
};
return(new ObjectResult(pagedSet));
// }
//CodeResultStatus _codeResult = new CodeResultStatus(401);
//return new ObjectResult(_codeResult);
}
public ApplicationUserController(
UserManager <ApplicationUser> userManager,
SignInManager <ApplicationUser> signInManager,
IOptions <IdentityCookieOptions> identityCookieOptions,
ILoggerFactory loggerFactory, IOptions <JwtIssuerOptions> jwtOptions, RoleManager <IdentityRole> roleManager, ILoggingRepository loggingRepository, IApplicationGroupService appGroupService, IApplicationRoleService appRoleService, DEFACEWEBSITEContext context)
{
_userManager = userManager;
_signInManager = signInManager;
_roleManager = roleManager;
_loggingRepository = loggingRepository;
_appGroupService = appGroupService;
_appRoleService = appRoleService;
_context = context;
_externalCookieScheme = identityCookieOptions.Value.ExternalCookieAuthenticationScheme;
_logger = loggerFactory.CreateLogger <AccountController>();
_jwtOptions = jwtOptions.Value;
}
public async Task <IEnumerable <Users> > GetListByParent(int parentid, string parentname)
{
var pagination = Request.Headers["Pagination"];
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
var result = await context.Users.FromSql("dbo.Users_ByParent @p_PARENT_ID = {0}, @p_PARENT_NAME = {1}", 1056, "thieu1234").ToArrayAsync();
//int currentPage = _page;
//int currentPageSize = _pageSize;
//var totalRecord = result.Count();
//var totalPages = (int)Math.Ceiling((double)totalRecord / _pageSize);
//var users = result.Skip((currentPage - 1) * currentPageSize).Take(currentPageSize);
//Response.AddPagination(_page, _pageSize, totalRecord, totalPages);
//IEnumerable<Users> listPagedUser = Mapper.Map<IEnumerable<Users>, IEnumerable<Users>>(users);
return(result);
}
public async Task <int> Put(int id, [FromBody] OptionUpdateObject option)
{
DEFACEWEBSITEContext context = new DEFACEWEBSITEContext();
XElement xmlLink = new XElement(new XElement("Root"));
XElement xmlUser = new XElement(new XElement("Root"));
if (option.IsEditLink.Equals("1"))
{
xmlUser = null;
xmlLink = new XElement(new XElement("Root"));
foreach (var item in option.DOMAINLINK)
{
XElement childElement = new XElement("Link", new XElement("OPTIONS_ID", option.OPTION.ID),
new XElement("DOMAIN_ID", option.OPTION.DOMAIN_ID),
new XElement("LINK", item.Link),
new XElement("RECORD_STATUS", "1"));
xmlLink.Add(childElement);
}
}
if (option.IsEditUser.Equals("1"))
{
xmlLink = null;
xmlUser = new XElement(new XElement("Root"));
foreach (var item in option.DOMAINUSER)
{
XElement childElement = new XElement("User", new XElement("DOMAIN", item.DOMAIN_ID),
new XElement("USERNAME", item.USERID),
new XElement("NOTE", item.NOTES));
}
}
string command = $"dbo.Options_Upd @p_ID= {option.OPTION.ID},@p_DOMAIN_ID ='{option.OPTION.DOMAIN_ID}',@p_IS_LIMIT ='{option.OPTION.IS_LIMIT}',@p_TIMES= {option.OPTION.TIMES},@p_DESCRIPTION = '{option.OPTION.DESCRIPTION}',@p_RECORD_STATUS = '{option.OPTION.RECORD_STATUS}',@p_AUTH_STATUS = '{option.OPTION.AUTH_STATUS}',@p_CREATE_DT = '{option.OPTION.CREATE_DT}',@p_APPROVE_DT = '{option.OPTION.APPROVE_DT}', @p_EDIT_DT ='{option.OPTION.EDIT_DT}',@p_MAKER_ID ='{option.OPTION.MAKER_ID}',@p_CHECKER_ID ='{option.OPTION.CHECKER_ID}',@p_EDITOR_ID = '{option.OPTION.EDITOR_ID}',@DOMAINLINK = '{xmlLink}',@DOMAINUSER= '******',@IsEditUser = '******',@IsEditLink = '{option.IsEditLink}' ";
var result = await context.Database.ExecuteSqlCommandAsync(command, cancellationToken : CancellationToken.None);
return(result);
}
//protected override void Dispose(bool disposing)
//{
// _context.Dispose();
//}
public DomainsController(DEFACEWEBSITEContext context)
{
_context = context;
}
public UserConfigsController(DEFACEWEBSITEContext context)
{
this._context = context;
}
public OptionsController(DEFACEWEBSITEContext context)
{
this._context = context;
}
public FeaturesController(DEFACEWEBSITEContext context)
{
this._context = context;
}
public UsersController(DEFACEWEBSITEContext context)
{
_context = context;
}
public MessagesController(DEFACEWEBSITEContext context)
{
this._context = context;
}
