public NoteDTO Replace(long id, NoteEntity newEntity) { var transaction = _humanManagerContext.Database.BeginTransaction(); NoteEntity oldEntity = null; try { NoteEntity entity = _humanManagerContext.Notes.SingleOrDefault(item => item.Id == id); if (entity != null) { entity.Id = newEntity.Id; entity.Content = newEntity.Content; _humanManagerContext.SaveChanges(); } transaction.Commit(); NoteDTO dto = _mapper.Map <NoteDTO>(entity); return(dto); } catch { transaction.Rollback(); return(null); } }
public WardDTO Edit(long id, WardEntity ward) { var transaction = _humanManagerContext.Database.BeginTransaction(); try { WardEntity entity = _humanManagerContext.Wards.SingleOrDefault(item => item.Id == id); if (entity != null) { // entity.Id = ward.Id; entity.Name = ward.Name; entity.District_Id = ward.District_Id; _humanManagerContext.SaveChanges(); } transaction.Commit(); WardDTO dto = _mapper.Map <WardDTO>(entity); return(dto); } catch { transaction.Rollback(); return(null); } }
public List <TimeKeepingDTO> Save() { var transaction = _humanManagerContext.Database.BeginTransaction(); //lấy ngày hiện tại trong máy DateTime nowDate = DateTime.Now; String date = nowDate.ToString("dd/MM/yyyy"); List <EmployeeEntity> entities = _humanManagerContext.Employees.ToList(); List <TimeKeepingDTO> listDTO = new List <TimeKeepingDTO>(); entities.ForEach(entity => { TimeKeepingEntity entityTimeKeeping = new TimeKeepingEntity(); entityTimeKeeping.idEmployee = entity.Id; entityTimeKeeping.minimumTime = 6; entityTimeKeeping.status = 1; entityTimeKeeping.morning = 1; entityTimeKeeping.afternoon = 1; entityTimeKeeping.dateStart = date; entityTimeKeeping = _humanManagerContext.Timekeepings.Add(entityTimeKeeping).Entity; listDTO.Add(_mapper.Map <TimeKeepingDTO>(entityTimeKeeping)); // dtos.Add(_mapper.Map<EmployeeDTO>(entity)); }); _humanManagerContext.SaveChanges(); transaction.Commit(); // return(listDTO); }
public CandidateDTO Save(CandidateForm canForm) { CandidateEntity entity = null; NoteDTO note = new NoteDTO(); note.Content = ""; note.Id = 0; canForm.Note = note; note = _noteService.Save(_mapper.Map <NoteEntity>(canForm.Note)); canForm.Note = note; var transaction = _humanManagerContext.Database.BeginTransaction(); try { string folderName = SystemContant.Candidate_Uploading_Path; string uploadPath = _hostingEnvironment.ContentRootPath; string newPath = Path.Combine(uploadPath, folderName); UploadUtil.Uploader uploader = _uploadUtil.DoFileUploading(newPath, canForm.UploadedFile); CandidateEntity newEntity = _mapper.Map <CandidateEntity>(canForm); newEntity.ImageName = uploader.fileName; entity = _humanManagerContext.Candidates.Add(newEntity).Entity; _humanManagerContext.SaveChanges(); transaction.Commit(); CandidateDTO dto = _mapper.Map <CandidateDTO>(entity); return(dto); } catch { transaction.Rollback(); return(null); } }
// chức năng kết thúc ngày công public TimeKeepingDetailDTO endTimeKeepingforOneDay(TimeKeepingDetailEntity oldEntity) { var transaction = _humanManagerContext.Database.BeginTransaction(); DateTime nowDate = DateTime.Now; // DateTime endDate = new DateTime('8/11/2020 10:06:00 PM'); try { TimeKeepingDetailEntity old = _humanManagerContext.TimeKeepingDetails.Where(tkd => tkd.Id == oldEntity.Id).SingleOrDefault(); TimeKeepingEntity oldTimeKeeping = _humanManagerContext.Timekeepings.Where(tk => tk.Id == old.timeKeepingId).SingleOrDefault(); String test = oldTimeKeeping.Id + ""; DateTime oldDateTime = old.timeStart; TimeSpan t = nowDate - oldDateTime; int count = t.Hours; //Cộng thời gian làm lên oldTimeKeeping.plusWorkingTime(count); old.status = 0; old.timeEnd = nowDate; old.timeWorking = count; _humanManagerContext.SaveChanges(); //Cộng thời gian làm lên oldTimeKeeping.plusWorkingTime(count); old.status = 0; old.timeEnd = nowDate; old.timeWorking = count; _humanManagerContext.SaveChanges(); return(_mapper.Map <TimeKeepingDetailDTO>(old)); } catch { transaction.Rollback(); return(null); } }
public JobDTO Save(JobEntity newEntity) { var transaction = _humanManagerContext.Database.BeginTransaction(); JobEntity entity = null; try { entity = _humanManagerContext.Jobs.Add(newEntity).Entity; _humanManagerContext.SaveChanges(); transaction.Commit(); JobDTO dto = _mapper.Map <JobDTO>(entity); return(dto); } catch { transaction.Rollback(); return(null); } }
public EmployeeDTO Save(EmployeeEntity emp) { emp.Job = null; var transaction = _humanManagerContext.Database.BeginTransaction(); EmployeeEntity entity = null; try { entity = _humanManagerContext.Employees.Add(emp).Entity; _humanManagerContext.SaveChanges(); transaction.Commit(); EmployeeDTO dto = _mapper.Map <EmployeeDTO>(entity); return(dto); } catch (Exception ex) { transaction.Rollback(); throw ex; } }
public LogDTO Save(LogEntity entity) { var transaction = _humanManagerContext.Database.BeginTransaction(); try { entity = _humanManagerContext.Logs.Add(entity).Entity; _humanManagerContext.SaveChanges(); transaction.Commit(); LogDTO dto = _mapper.Map <LogDTO>(entity); return(dto); } catch { transaction.Rollback(); return(null); } }
public ProvinceDTO save(ProvinceEntity entity) { var transaction = _humanManagerContext.Database.BeginTransaction(); try { entity = _humanManagerContext.Provinces.Add(entity).Entity; _humanManagerContext.SaveChanges(); transaction.Commit(); ProvinceDTO dto = _mapper.Map <ProvinceDTO>(entity); return(dto); } catch { transaction.Rollback(); return(null); } }
public DistrictDTO Save(DistrictEntity district) { var transaction = _humanManagerContext.Database.BeginTransaction(); try { district = _humanManagerContext.Districts.Add(district).Entity; _humanManagerContext.SaveChanges(); transaction.Commit(); DistrictDTO dto = _mapper.Map <DistrictDTO>(district); return(dto); } catch { transaction.Rollback(); return(null); } }
public ScheduleDTO Save(ScheduleEntity schedule) { var transaction = _humanManagerContext.Database.BeginTransaction(); ScheduleEntity entity = null; try { entity = _humanManagerContext.Schedules.Add(schedule).Entity; _humanManagerContext.SaveChanges(); transaction.Commit(); ScheduleDTO dto = _mapper.Map <ScheduleDTO>(entity); transaction.Dispose(); return(dto); } catch { transaction.Rollback(); return(null); } }
public bool DoSalaryCounting(long empId, Date countingDate) { var transaction = _humanManagerContext.Database.BeginTransaction(); try { // Lấy cấu hình ConfigureEntity configure = _humanManagerContext.Configures.SingleOrDefault(); // lấy nhân viên EmployeeEntity employeeEntity = _humanManagerContext.Employees .Where(e => e.Id == empId) .Include(e => e.Job) .ThenInclude(j => j.JobLevel) .Include(e => e.RewardPunishes) .SingleOrDefault(); // Lấy bảo hiểm List <InsurranceEntity> insurrances = _humanManagerContext.Insurrances.ToList(); // Lấy lương quy định tối thiểu int miniumSalary = (int)configure.MinimumSalary; // Tính hệ số lương double salaryCoefficient = SalaryUtil.GetSalaryCoefficient(employeeEntity.Job.JobLevel, employeeEntity.JobLevel); // Lây số ngày công quy định int regulationWorkDay = (int)configure.RegulationWorkDay; // Lấy số ngày công thực tế int empWorkDay = 30; // Tính phụ cấp // Tính thưởng phạt int rewardMoney = SalaryUtil.DoRewardMoneyCounting(employeeEntity.RewardPunishes); int publishMoney = SalaryUtil.DoPublishMoneyCounting(employeeEntity.RewardPunishes); // Tính bảo hiểm double totalInsurranceRatio = SalaryUtil.CountTotalInsurranceRatio(insurrances); // Lấy bảng thuế List <TaxEntity> taxs = _humanManagerContext.Taxs.ToList(); // Tính lương SalaryHistoryEntity salaryHistoryEntity =// SalaryUtil.DoSalaryConting(employeeEntity, new DateTime(countingDate.year, countingDate.month, countingDate.day), miniumSalary, salaryCoefficient, regulationWorkDay, empWorkDay, rewardMoney, publishMoney, totalInsurranceRatio, taxs); // kiểm tra thay đổi lương SalaryHistoryEntity oldSalaryHistory = _humanManagerContext.SalaryHistories.Where(sh => sh.EmployeeId == employeeEntity.Id && sh.CountedDate.Month == countingDate.month && sh.CountedDate.Year == countingDate.year && sh.IsActive == true).SingleOrDefault(); if (oldSalaryHistory == null || salaryHistoryEntity.NetSalary != oldSalaryHistory.NetSalary) { // Chuyển trạng thái lương cũ if (oldSalaryHistory != null) { oldSalaryHistory.IsActive = false; } // Lưu lương mới salaryHistoryEntity = _humanManagerContext.SalaryHistories.Add(salaryHistoryEntity).Entity; _humanManagerContext.SaveChanges(); transaction.Commit(); } else { transaction.Rollback(); return(false); } return(true); } catch (Exception ex) { transaction.Rollback(); throw ex; } }