public async Task <IActionResult> Create([Bind("Id,Name,Email,Password,Address,PostCode,Telephone,IsManagement")] StaffDto staff)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
await _staffService.PostStaffAsync(new StaffDto
{
Name = staff.Name,
Email = staff.Email,
Address = staff.Address,
PostCode = staff.PostCode,
Telephone = staff.Telephone,
IsManagement = staff.IsManagement
});
return(RedirectToAction(nameof(Index)));
}
catch (HttpRequestException)
{
_logger.LogWarning("Exception Occured using staff service.");
}
return(View(staff));
}
public Result Verify(StaffDto dto)
{
try
{
var list = UnitOfWorkService.Execute(() => _repo.Get(dto.Id));
if (list == null)
{
return new Result {
Status = false, Message = "账户名或密码错误"
}
}
;
if (list.Status == 8)
{
return(new Result {
Status = false, Message = "该员工禁止登录"
});
}
dto.Password = Hx.Security.Md5Getter.Get(dto.Password);
return(list.Password.Equals(dto.Password, StringComparison.OrdinalIgnoreCase) ? new Result(true, "") : new Result {
Status = false, Message = "账户名或密码错误"
});
}
catch (Exception ex)
{
Logger.Error("login error", ex);
return(new Result(false, "账户名或密码错误"));
}
}
public async Task <StaffQualificationResponse> RetriveStaffByUserId(long userId)
{
var staff = await _schoolHubDbContext.Staff.FirstOrDefaultAsync(x => x.UserId == userId);
if (staff == null)
{
return(null);
}
var staffDto = new StaffDto
{
Id = staff.Id,
UserId = staff.UserId,
Firstname = staff.Firstname,
Middlename = staff.Middlename,
Lastname = staff.Lastname,
Age = staff.Age,
DateEmployed = staff.DateEmployed,
Gender = staff.Gender.GetDescription(),
IsActive = staff.IsActive,
IsUpdate = staff.IsUpdate,
UserType = staff.UserType.GetDescription(),
ImagePath = staff.ImagePath,
};
var qualDto = await GetQualificationsByStaffId(staff.Id);
var response = new StaffQualificationResponse
{
Staff = staffDto,
Qualification = qualDto.ToList()
};
return(response);
}
public static void AddStaffToCache(StaffDto staff)
{
var policy = new CacheItemPolicy();
policy.SlidingExpiration = new TimeSpan(0, 60, 0);
cache.Add(staff.StaffNo.ToString(), staff, policy);
}
public StaffDto FindByID(string staffID, string password)
{
StaffDto staffDto = null;
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("stpGetStaffByStaffID", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] sqlParams = { new SqlParameter("@StaffID", staffID),
new SqlParameter("@Password", password) };
cmd.Parameters.AddRange(sqlParams);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
staffDto = new StaffDto()
{
CreatedBy = reader["CreatedBy"].ToString(),
EntryDate = DateTime.Parse(reader["EntryDate"].ToString()),
Firstname = reader["Firstname"].ToString(),
Lastname = reader["Lastname"].ToString(),
Password = reader["Password"].ToString(),
StaffID = reader["StaffID"].ToString(),
StaffNo = reader["StaffNo"].ToString()
};
}
}
}
return(staffDto);
}
public void EnsureWaiterIsLoadedAndWaitersAreLoadedIfWaiterIdIsNotNull()
{
var system = A.Fake <IServiceRegistry>();
var waiter = new StaffDto {
Id = 1, EmailAddress = "*****@*****.**"
};
var user = A.Fake <MembershipUser>();
A.CallTo(() => user.GetPassword()).Returns("pass");
A.CallTo(() => system.StaffService.LoadStaffMember(null)).WithAnyArguments().Returns(new StaffResponse {
Staff = waiter
});
var action = new LoadStaffMemberAction <dynamic>(system)
{
OnComplete = (m) => new { Value = m },
};
var result = action.Invoke(1, 1).Value as StaffMemberViewModel;
Assert.IsTrue(result.Staff.Id == 1);
Assert.IsFalse(result.Notifications.HasErrors());
}
public SimpleResponse <StaffDto> Create(StaffDto dto)
{
var response = new SimpleResponse <StaffDto>();
try
{
var model = SimpleMapper.Map <StaffDto, StaffViewModel>(dto);
var resp = iStaffBusiness.Create(model);
response = new SimpleResponse <StaffDto>()
{
ResponseCode = resp.ResponseCode,
ResponseMessage = resp.ResponseMessage,
RCode = resp.RCode
};
response.Data = SimpleMapper.Map <StaffViewModel, StaffDto>(resp.Data);
}
catch (Exception ex)
{
response.ResponseCode = BusinessResponseValues.InternalError;
response.ResponseMessage = "Okuma iþleminde hata oluþtu.";
SimpleFileLogger.Instance.Error(ex);
}
return(response);
}
public List <StaffDto> GetAll()
{
List <StaffDto> staffMembers = new List <StaffDto>();
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("stpGetAllStaff", conn);
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
StaffDto staffDto = new StaffDto()
{
CreatedBy = reader["CreatedBy"].ToString(),
EntryDate = DateTime.Parse(reader["EntryDate"].ToString()),
Firstname = reader["Firstname"].ToString(),
Lastname = reader["Lastname"].ToString(),
Password = reader["Password"].ToString(),
StaffID = reader["StaffID"].ToString(),
StaffNo = reader["StaffNo"].ToString()
};
staffMembers.Add(staffDto);
}
}
}
return(staffMembers);
}
public IActionResult OnGet(int?id)
{
var t = Request.Cookies["logon"];
if (t == null)
{
return(RedirectToPage("../Accounts/Login"));
}
if (t == "false")
{
return(RedirectToPage("../Accounts/Login"));
}
if (id == null)
{
return(NotFound());
}
Staff = _service.GetStaff(id ?? default(int));
if (Staff == null)
{
return(NotFound());
}
return(Page());
}
public static bool checkPassword(int staffID, string password)
{
StaffDto dto = null;
dto = StaffDao.Where(n => n.StaffId == staffID && n.Password.Equals(password)).FirstOrDefault();
return(dto != null);
}
public async Task Create([FromBody] StaffDto staff)
{
await _commandDispatcher.Dispatch <CreateStaff.Command>(new CreateStaff.Command()
{
staff = staff
});
}
/// <summary>
/// 修改员工
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
/// <inheritdoc cref="" />
public Result <string> Update(StaffDto dto)
{
try
{
var staff = dto.MapTo <StaffEntity>();
var rlt = UnitOfWorkService.Execute(() =>
{
var rlt1 = ObjectContainer.Resolve <IStaffRepository>().Update(staff);
if (rlt1)
{
return new Result <string> {
Status = true
}
}
;
return(new Result <string> {
Status = false, Message = "数据库写入失败"
});
}
);
if (!rlt.Status)
{
Logger.Error($"修改员工失败：{dto.Id}");
return(rlt);
}
return(rlt);
}
catch (Exception ex)
{
Logger.Error($"update staff to exception:{ex}");
return(new Result <string> {
Status = false, Message = ex.Message
});
}
}
public void UpdateStaff(StaffDto staffDto)
{
var staff = staffRepository.GetBy(staffDto.Id);
staffDto.MappingStaff(staff);
staffRepository.Update(staff);
}
public StaffDto AddStaff(StaffDto staffDto)
{
var staff = MapperHelper.Map <StaffDto, Staff>(staffDto);
staff = new StaffService().AddStaff(staff);
Console.WriteLine($"Add new staff success: {JsonConvert.SerializeObject(staff)}");
return(MapperHelper.Map <Staff, StaffDto>(staff));
}
/// <summary>
/// 增加员工
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
/// <inheritdoc cref="" />
public Result <string> Add(StaffDto dto, int orgId, UserType roleId)
{
try
{
var staff = dto.MapTo <StaffEntity>();
var userInRole = new UserInRoleEntity
{
RoleId = ((int)dto.UserType).ToString(),
UserId = dto.Id
};
var rlt = UnitOfWorkService.Execute(() =>
{
var sta = _repo.Get(dto.Id);
if (sta != null)
{
return(new Result <string> {
Status = false, Message = "该账号已存在"
});
}
var rlt1 = _repo.InsertAndGetId(staff);
var rlt2 = _userInRoleRepository.InsertAndGetId(userInRole);
var dataInOrg = new DataInOrgEntity
{
DataId = rlt1,
DataType = (int)DataType.Staff,
OrgId = orgId,
RoleId = ((int)roleId).ToString()
};
var dataRlt = _dataInOrgRepository.Inserts(dataInOrg);//数据部门权限
var executeRlt = rlt1.IsNotEmpty() && rlt2 > 0 && dataRlt;
if (executeRlt)
{
return new Result <string> {
Status = true
}
}
;
return(new Result <string> {
Status = false, Message = "数据库写入失败"
});
});
if (!rlt.Status)
{
Logger.Error($"新增员工失败：{dto.Id}");
return(rlt);
}
return(rlt);
}
catch (Exception ex)
{
Logger.Error($" add staff to exception:{ex}");
return(new Result <string> {
Status = false, Message = ex.Message
});
}
}
public ActionResult Create(StaffDto staff)
{
try {
return(RedirectToAction("Index"));
}
catch {
return(View());
}
}
public static int Insert(StaffDto staff)
{
int id = StaffDao.Insert(staff);
staff.UserId = id;
allStaffs.Add(staff);
allStaffs.OrderBy(n => n.UserId);
return(id);
}
public StaffDto getStaff(long id)
{
Staff staff = db.Staff.Where(s => s.Id == id).FirstOrDefault();
StaffDto dto = new StaffDto(staff.Id, staff.Name, staff.Gmail,
positionRepository.getPosision(staff.PositionId),
storeRepository.getStoreDto(staff.StoreId),
statusRepository.getStatus(staff.StatusId), staff.PicUrl, staff.AuthToken, staff.DeviceToken);
return(dto);
}
public IActionResult Put(int id, StaffDto staffDto)
{
var staff = _mapper.Map <Staff>(staffDto);
staff.Id = id;
var result = _staffService.UpdateStaff(staff);
var response = new ApiResponse <bool>(result);
return(Ok(response));
}
public IActionResult Staff(StaffDto staffDto)
{
var staff = _mapper.Map <Staff>(staffDto);
_staffService.InsertStaff(staff);
staffDto = _mapper.Map <StaffDto>(staff);
var response = new ApiResponse <StaffDto>(staffDto);
return(Ok(response));
}
public dynamic Deletestaff(long id)
{
StaffDto dto = staffRepository.deleteStaff(id);
if (dto == null)
{
return(NotFound());
}
return(Ok(dto));
}
public dynamic GetstaffByAccessToken(long id)
{
StaffDto dto = staffRepository.getStaff(id);
if (dto == null)
{
return(NotFound());
}
return(Ok(dto));
}
public async Task <IActionResult> AddStaff(StaffDto staffDto)
{
var staff = _mapper.Map <Staff>(staffDto);
_appRepository.Add(staff);
await _unitOfWork.SaveAll();
return(Ok(staff));
}
public StaffDto getStaff(string accessToken)
{
staff staff = db.staffs.Where(s => s.auth_token == accessToken).FirstOrDefault();
StaffDto dto = new StaffDto(staff.id.ToString(), staff.name, staff.gmail,
positionRepository.getPosision(staff.position_id),
storeRepository.getStoreDto(staff.store_id),
statusRepository.getStatus(staff.status_id), staff.pic_url, staff.auth_token);
return(dto);
}
public async Task <ActionResult> Edit(long id, StaffDto staffDto)
{
var requestDispatcher = CreateAsyncRequestDispatcher();
requestDispatcher.Add(new SaveDtoRequest <StaffDto> {
DataTransferObject = staffDto
});
var response = await requestDispatcher.GetAsync <DtoResponse <StaffDto> >();
return(RedirectToAction("Edit", new { id }));
}
public static void Save(StaffDto staff)
{
if (staff.Id == 0)
{
HttpResponseMessage response = GlobalVariables.WebApiClient.PostAsJsonAsync("Staff", staff).Result;
}
else
{
HttpResponseMessage response = GlobalVariables.WebApiClient.PutAsJsonAsync("Staff/" + staff.Id, staff).Result;
}
}
public IHttpActionResult GetstaffByAccessToken(string accessToken)
{
staff staff = db.staffs.Where(s => s.auth_token == accessToken).FirstOrDefault();
if (staff == null)
{
return(NotFound());
}
StaffDto dto = staffRepository.getStaff(staff.auth_token);
return(Ok(dto));
}
public async Task SavePicture(StaffDto staffDto)
{
var staff = await _schoolHubDbContext.Staff.FirstOrDefaultAsync(x => x.Id == staffDto.Id);
if (staff != null)
{
staff.Id = staffDto.Id;
staff.ImagePath = staffDto.ImagePath;
}
_schoolHubDbContext.Entry(staff).State = EntityState.Modified;
await _schoolHubDbContext.SaveChangesAsync();
}
public static int Login(string username, string encryptedPassword)
{
StaffDto dto = StaffDao.Where(n => n.Username.Equals(username) && n.Password.Equals(encryptedPassword)).FirstOrDefault();
if (dto == null)
{
return(0);
}
Config.Manager.CURRENT_USER = dto;
DatabaseCommon.DatabaseUtils.CurrentUserId = dto.UserId;
return(dto.Active ? 1 : -1);
}
internal List <StaffDto> getStaffs()
{
List <Staff> staffs = db.Staff.ToList();
List <StaffDto> results = new List <StaffDto>();
foreach (Staff staff in staffs)
{
StaffDto dto = getStaff(staff.Id);
results.Add(dto);
}
return(results);
}
