public JsonResultEntity Create([FromBody] UserAdministratorEntity useradministratorEntity)
{
UserAdministratorBL useradministratorBL = new UserAdministratorBL();
JsonResultEntity response = new JsonResultEntity();
try
{
useradministratorEntity.CreatedBy = GetUserID();
var result = useradministratorBL.Create(useradministratorEntity);
if (result.HasWarning())
{
response.Message = String.Join(",", result.Warning);
return(response);
}
response.Success = true;
response.Data = result.Value;
}
catch (Exception ex)
{
response.Message = ex.Message;
LoggerHelper.Error(ex);
}
return(response);
}
public UserAdministratorEntity Create(UserAdministratorEntity useradministratorEntity)
{
var query = @"INSERT INTO ""UserAdministrator""(""UserName"",""Password"",""Name"",""Email"",""Phone"",""CreatedDate"",""Picture"",""GroupID"",""CreatedBy"") VALUES(@UserName,@Password,@Name,@Email,@Phone,@CreatedDate,@Picture,@GroupID,@CreatedBy) RETURNING ""ID"";";
int id = DbConnection.Query <int>(query, useradministratorEntity).Single();
useradministratorEntity.ID = id;
return(useradministratorEntity);
}
public int Update(UserAdministratorEntity useradministratorEntity)
{
int affectedRows = 0;
if (IsHaveId <UserAdministratorEntity>(useradministratorEntity) == false)
{
//var query = @"UPDATE ""UserAdministrator"" SET ""UserName""=@UserName,""Password""=@Password,""Name""=@Name,""Email""=@Email,""Phone""=@Phone,""CreatedDate""=@CreatedDate,""ModifiedDate""=@ModifiedDate,""Picture""=@Picture,""IsLocked""=@IsLocked,""IsDeleted""=@IsDeleted,""PasscodeExpired""=@PasscodeExpired,""GroupID""=@GroupID WHERE ""ID""=@ID";
var query = @"UPDATE ""UserAdministrator"" SET ""UserName""=@UserName,""Password""=@Password,""Name""=@Name,""Email""=@Email,""Phone""=@Phone,""ModifiedDate""=@ModifiedDate,""Picture""=@Picture,""GroupID""=@GroupID,""ModifiedBy""=@ModifiedBy WHERE ""ID""=@ID";
affectedRows = DbConnection.Execute(query, useradministratorEntity);
}
return(affectedRows);
}
public ResultEntity <UserAdministratorEntity> Update(UserAdministratorEntity useradministratorEntity)
{
var validationResult = new ResultEntity <UserAdministratorEntity>();
//useradministratorEntity.Password = UtilityHelper.PasswordHash(useradministratorEntity.Password);
using (var useradministratorDA = new UserAdministratorDA())
{
var userAdminList = useradministratorDA.GetByUserName(useradministratorEntity.UserName);
var linq = (from x in userAdminList
where x.ID != useradministratorEntity.ID
select x).ToList <UserAdministratorEntity>();
if (linq.Count() > 0)
{
validationResult.Warning.Add("Username " + useradministratorEntity.UserName + " already exist");
return(validationResult);
}
var isOldPassword = useradministratorDA.CheckPassword(useradministratorEntity.ID, useradministratorEntity.Password);
if (isOldPassword == null)
{
useradministratorEntity.Password = UtilityHelper.PasswordHash(useradministratorEntity.Password);
}
var resultUpdate = useradministratorDA.Update(useradministratorEntity);
if (resultUpdate <= 0)
{
validationResult.Warning.Add("Failed Updating UserAdministrator!");
return(validationResult);
}
validationResult.Value = useradministratorEntity;
}
return(validationResult);
}
public ResultEntity <UserAdministratorEntity> Create(UserAdministratorEntity useradministratorEntity)
{
var validationResult = new ResultEntity <UserAdministratorEntity>();
useradministratorEntity.Password = UtilityHelper.PasswordHash(useradministratorEntity.Password);
using (var useradministratorDA = new UserAdministratorDA())
{
var userAdminList = useradministratorDA.GetByUserName(useradministratorEntity.UserName);
if (userAdminList.Count() > 0)
{
validationResult.Warning.Add("Username " + useradministratorEntity.UserName + " already exist");
return(validationResult);
}
useradministratorEntity.CreatedDate = DateTime.Now;
validationResult.Value = useradministratorDA.Create(useradministratorEntity);
}
return(validationResult);
}