public async Task <ResponseModel> Delete(EmployeeInfoModel model)
{
ResponseModel response = new ResponseModel();
try
{
EmployeeInfo md = await _context.EmployeeInfoRepository.FirstOrDefaultAsync(m => m.Id == model.Id);
if (!md.RowVersion.SequenceEqual(model.RowVersion))
{
response.ResponseStatus = Core.CommonModel.Enums.ResponseStatus.OutOfDateData;
return(response);
}
md.Deleted = true;
md.UpdateBy = base.UserId;
md.UpdateDate = DateTime.Now;
_context.EmployeeInfoRepository.Update(md);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public ActionResult Employee()
{
var result = EmployeeInfoRepo.loadEmployees();
var model = new List <EmployeeInfoModel>();
if (!result.HasError)
{
foreach (var v in result.Data)
{
var emp = new EmployeeInfoModel()
{
Address = v.Address,
Email = v.Email,
ID = v.ID,
IsActive = v.IsActive,
Name = v.Name,
UserCode = v.UserCode,
UserName = v.UserName,
UserTypeID = v.UserTypeID
};
model.Add(emp);
}
}
if (TempData["trash"] != null)
{
ViewBag.Success = TempData["trash"];
}
if (TempData["trashError"] != null)
{
ViewBag.Error = TempData["trashError"];
}
return(View(model));
}
public async Task <ResponseModel> Insert(EmployeeInfoModel model)
{
ResponseModel response = new ResponseModel();
try
{
EmployeeInfo md = new EmployeeInfo();
md.EmployeeId = model.EmployeeId;
md.FirstName = model.FirstName.Trim();
md.LastName = model.LastName.Trim();
md.Gender = model.Gender;
md.DateOfBirth = model.DateOfBirth;
md.MaterialStatusId = model.MaterialStatusId;
md.ReligionId = model.ReligionId;
md.EthnicityId = model.EthnicityId;
md.NationalityId = model.NationalityId;
md.AcademicLevelId = model.AcademicLevelId;
md.ProfessionalQualificationId = model.ProfessionalQualificationId;
md.IsActive = model.IsActive;
md.CreateBy = base.UserId;
md.CreateDate = DateTime.Now;
md.Deleted = false;
await _context.EmployeeInfoRepository.AddAsync(md).ConfigureAwait(true);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
response.ResponseStatus = Core.CommonModel.Enums.ResponseStatus.Error;
response.Errors.Add(ex.Message);
}
return(response);
}
public static EmployeeInfoModel GetEmployeeInfoForEdit(int id)
{
using (var context = new MakeMyJobsEntities())
{
if (context.Employees.Any(x => x.UserId == id))
{
EmployeeInfoModel employeeInfoModel = context.Employees.Join(context.Users, e => e.UserId, u => u.UserId, (e, u) => new EmployeeInfoModel()
{
employeeId = e.EmployeeId,
userId = e.UserId,
firstName = e.FirstName,
lastName = e.LastName,
city = e.City,
contactNumber = e.ContactNumber,
dateOfBirth = e.DateOfBirth,
resume = e.Resume,
dateJoined = e.DateJoined,
address = e.Address,
state = e.State,
country = e.Country,
email = u.Email,
zipCode = e.ZipCode
}).FirstOrDefault(x => x.userId == id);
return(employeeInfoModel);
}
else
{
return(null);
}
}
}
public static EmployeeInfoModel UpdateEmployeeBasicInfo(EmployeeInfoModel model)
{
using (var context = new MakeMyJobsEntities())
{
int updated = 0;
var user = context.Users.FirstOrDefault(x => x.UserId == model.userId && x.IsActive == 1);
var employee = context.Employees.FirstOrDefault(x => x.EmployeeId == model.employeeId);
if (user == null || employee == null)
{
return(null);
}
else
{
user.Email = model.email;
updated += context.SaveChanges();
employee.FirstName = model.firstName;
employee.LastName = model.lastName;
employee.ContactNumber = model.contactNumber;
employee.DateOfBirth = model.dateOfBirth;
employee.City = model.city;
employee.Address = model.address;
employee.State = model.state;
employee.Country = model.country;
employee.ZipCode = model.zipCode;
updated += context.SaveChanges();
}
return(GetUpdatedEmployeeInfo(user.UserId, employee.EmployeeId));
}
}
public async Task <ResponseModel> Update(EmployeeInfoModel model)
{
ResponseModel response = new ResponseModel();
try
{
EmployeeInfo md = await _context.EmployeeInfoRepository.FirstOrDefaultAsync(m => m.Id == model.Id);
if (!md.RowVersion.SequenceEqual(model.RowVersion))
{
response.ResponseStatus = Core.CommonModel.Enums.ResponseStatus.OutOfDateData;
return(response);
}
md.EmployeeId = model.EmployeeId;
md.Gender = model.Gender;
md.DateOfBirth = model.DateOfBirth;
md.MaterialStatusId = model.MaterialStatusId;
md.ReligionId = model.ReligionId;
md.EthnicityId = model.EthnicityId;
md.NationalityId = model.NationalityId;
md.AcademicLevelId = model.AcademicLevelId;
md.ProfessionalQualificationId = model.ProfessionalQualificationId;
md.IsActive = model.IsActive;
md.UpdateBy = base.UserId;
md.UpdateDate = DateTime.Now;
_context.EmployeeInfoRepository.Update(md);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public static EmployeeInfoModel GetEmployeeInfo(int id)
{
using (var context = new MakeMyJobsEntities())
{
if (context.Employees.Any(x => x.UserId == id))
{
EmployeeInfoModel employeeInfoModel = context.Employees.Join(context.States, e => e.State, st => st.StateId, (e, st) => new
{
StateName = st.StateName,
employee = e
}).Join(context.Countries, e => e.employee.Country, c => c.CountryId, (e, c) => new
{
employee = e,
stateName = e.StateName,
countryName = c.CountryName
}).Join(context.Users, e => e.employee.employee.UserId, u => u.UserId, (e, u) => new EmployeeInfoModel()
{
employeeId = e.employee.employee.EmployeeId,
userId = e.employee.employee.UserId,
firstName = e.employee.employee.FirstName,
lastName = e.employee.employee.LastName,
city = e.employee.employee.City,
contactNumber = e.employee.employee.ContactNumber,
dateOfBirth = e.employee.employee.DateOfBirth,
resume = e.employee.employee.Resume,
dateJoined = e.employee.employee.DateJoined,
address = e.employee.employee.Address + (e.employee.employee.City == null ? "" : (", " + e.employee.employee.City)) + (e.employee.employee.State == 0 ? "" : (", " + e.employee.StateName)) + (e.employee.employee.Country == 0 ? "" : (", " + e.countryName)),
state = e.employee.employee.State,
country = e.employee.employee.Country,
email = u.Email,
zipCode = e.employee.employee.ZipCode
}).FirstOrDefault(x => x.userId == id);
employeeInfoModel.employeeEducation = new List <EmployeeEducationModel>();
employeeInfoModel.employeeEducation = context.EmployeeEducations.Where(x => x.EmployeeId == employeeInfoModel.employeeId && x.IsActive == 1).Select(x => new EmployeeEducationModel()
{
empEducationId = x.EmpEducationId,
employeeId = x.EmployeeId,
instituteName = x.InstituteName,
instituteType = x.InstituteType,
percentage = x.Percentage,
joinedOn = x.JoinedOn,
passedOn = x.PassedOn,
isActive = x.IsActive
}).ToList();
employeeInfoModel.employeeExperience = new List <EmployeeExperienceModel>();
employeeInfoModel.employeeExperience = context.EmployeeExperiences.Where(x => x.EmployeeId == employeeInfoModel.employeeId && x.IsActive == 1).Select(x => new EmployeeExperienceModel()
{
empExperienceId = x.EmpExperienceId,
employeeId = x.EmployeeId,
companyName = x.CompanyName,
position = x.Position,
joinedOn = x.JoinedOn,
leftOn = x.LeftOn,
isActive = x.IsActive,
}).ToList();
if (context.EmployeeDocuments.Any(x => x.EmployeeId == employeeInfoModel.employeeId && x.DocumentType == EmployeeDocumentTypes.Resume))
{
employeeInfoModel.resume = "1";
}
return(employeeInfoModel);
}
else
{
return(null);
}
}
}
