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 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);
}
}
}
private static StudentInfoModel GetUpdatedStudentInfo(int userId, int studentId)
{
using (var context = new MakeMyJobsEntities())
{
var user = context.Users.FirstOrDefault(x => x.UserId == userId && x.IsActive == 1);
var student = context.Students.FirstOrDefault(x => x.StudentId == studentId);
if (user == null || student == null)
{
return(null);
}
else
{
return(new StudentInfoModel()
{
userId = userId,
studentId = studentId,
email = user.Email,
firstName = student.FirstName,
lastName = student.LastName,
contactNumber = student.ContactNumber,
address = student.Address,
state = student.State,
country = student.Country,
dateOfBirth = student.DateOfBirth,
zipCode = student.ZipCode
});
}
}
}
public static int UploadResume(int employeeId, String fileName, String fileNameOnDisk, long fileSize)
{
using (var context = new MakeMyJobsEntities())
{
var previousResume = context.EmployeeDocuments.FirstOrDefault(x => x.EmployeeId == employeeId && x.DocumentType == 1);
if (previousResume != null)
{
context.Entry(previousResume).State = System.Data.Entity.EntityState.Deleted;
}
else
{
context.EmployeeDocuments.Add(new EmployeeDocument()
{
DocumentName = fileName,
DocumentNameOnDisk = fileNameOnDisk,
DocumentSize = fileSize,
DocumentType = 1,
IsActive = 1,
LastUpdatedOn = DateTime.Now,
EmployeeId = employeeId
});
}
return(context.SaveChanges());
}
}
public static EmployeeEducationModel AddEmployeeEducation(EmployeeEducationModel model)
{
using (var context = new MakeMyJobsEntities())
{
EmployeeEducation employeeEducation = new EmployeeEducation();
employeeEducation.EmployeeId = model.employeeId;
employeeEducation.InstituteName = model.instituteName;
employeeEducation.InstituteType = model.instituteType;
employeeEducation.JoinedOn = model.joinedOn;
employeeEducation.PassedOn = model.passedOn;
employeeEducation.Percentage = Convert.ToDecimal(model.percentage);
employeeEducation.IsActive = 1;
context.EmployeeEducations.Add(employeeEducation);
int added = context.SaveChanges();
if (added > 0)
{
return(new EmployeeEducationModel()
{
empEducationId = employeeEducation.EmpEducationId,
employeeId = employeeEducation.EmployeeId,
instituteName = employeeEducation.InstituteName,
instituteType = employeeEducation.InstituteType,
joinedOn = employeeEducation.JoinedOn,
passedOn = employeeEducation.PassedOn,
percentage = employeeEducation.Percentage,
isActive = employeeEducation.IsActive
});
}
else
{
return(null);
}
}
}
public static EmployeeExperienceModel AddEmployeeExperience(EmployeeExperienceModel model)
{
using (var context = new MakeMyJobsEntities())
{
EmployeeExperience employeeExperience = new EmployeeExperience();
employeeExperience.EmployeeId = model.employeeId;
employeeExperience.CompanyName = model.companyName;
employeeExperience.Position = model.position;
employeeExperience.JoinedOn = model.joinedOn;
employeeExperience.LeftOn = model.leftOn;
employeeExperience.IsActive = 1;
context.EmployeeExperiences.Add(employeeExperience);
int added = context.SaveChanges();
if (added > 0)
{
return(new EmployeeExperienceModel()
{
empExperienceId = employeeExperience.EmpExperienceId,
employeeId = employeeExperience.EmployeeId,
companyName = employeeExperience.CompanyName,
position = employeeExperience.Position,
joinedOn = employeeExperience.JoinedOn,
leftOn = employeeExperience.LeftOn,
isActive = employeeExperience.IsActive
});
}
else
{
return(null);
}
}
}
public static int CreateUser(SignupModel model)
{
using (var context = new MakeMyJobsEntities())
{
if (context.Users.Any(x => x.Email == model.email))
{
return(-1);
}
int created = 0;
User user = new User();
user.Email = model.email;
user.Password = model.password;
user.UserType = model.userType;
user.IsActive = 1;
context.Users.Add(user);
created += context.SaveChanges();
if (model.userType == UserTypes.Student)
{
created += AccountBusiness.CreateStudent(model, user.UserId);
}
else if (model.userType == UserTypes.Employee)
{
created += AccountBusiness.CreateEmployee(model, user.UserId);
}
else
{
created += AccountBusiness.CreateCorporate(model, user.UserId);
}
return(created);
}
}
public static StudentInfoModel UpdateStudentInfo(StudentInfoModel model)
{
using (var context = new MakeMyJobsEntities())
{
StudentInfoModel studentInfo = new StudentInfoModel();
int updated = 0;
var user = context.Users.FirstOrDefault(x => x.UserId == model.userId && x.IsActive == 1);
var student = context.Students.FirstOrDefault(x => x.StudentId == model.studentId);
if (user == null || student == null)
{
return(null);
}
else
{
user.Email = model.email;
updated += context.SaveChanges();
student.FirstName = model.firstName;
student.LastName = model.lastName;
student.ContactNumber = model.contactNumber;
student.DateOfBirth = model.dateOfBirth;
student.CollegeName = model.collegeName;
student.Address = model.address;
student.State = model.state;
student.Country = model.country;
student.ZipCode = model.zipCode;
updated += context.SaveChanges();
}
return(GetUpdatedStudentInfo(user.UserId, student.StudentId));
}
}
public static StudentInfoModel GetStudentInfoForEdit(int id)
{
using (var context = new MakeMyJobsEntities())
{
if (context.Students.Any(x => x.UserId == id))
{
StudentInfoModel studentInfoModel = context.Students.Join(context.Users, s => s.UserId, u => u.UserId, (s, u) => new StudentInfoModel()
{
studentId = s.StudentId,
userId = s.UserId,
firstName = s.FirstName,
lastName = s.LastName,
collegeName = s.CollegeName,
contactNumber = s.ContactNumber,
dateOfBirth = s.DateOfBirth,
resume = s.Resume,
dateJoined = s.DateJoined,
address = s.Address,
state = s.State,
country = s.Country,
email = u.Email,
zipCode = s.ZipCode
}).FirstOrDefault(x => x.userId == id);
return(studentInfoModel);
}
else
{
return(null);
}
}
}
private static EmployeeInfoModel GetUpdatedEmployeeInfo(int userId, int employeeId)
{
using (var context = new MakeMyJobsEntities())
{
var user = context.Users.FirstOrDefault(x => x.UserId == userId && x.IsActive == 1);
var employee = context.Employees.FirstOrDefault(x => x.EmployeeId == employeeId);
if (user == null || employee == null)
{
return(null);
}
else
{
return(new EmployeeInfoModel()
{
userId = userId,
employeeId = employeeId,
email = user.Email,
firstName = employee.FirstName,
lastName = employee.LastName,
contactNumber = employee.ContactNumber,
city = employee.City,
address = employee.Address,
state = employee.State,
country = employee.Country,
dateOfBirth = employee.DateOfBirth,
zipCode = employee.ZipCode
});
}
}
}
public static List <DropdownModel> GetSalaryDivision()
{
using (var context = new MakeMyJobsEntities())
{
return(context.Lookups.Where(x => x.LookUpCategory == 3).Select(x => new DropdownModel()
{
value = x.LookupId,
text = x.Name
}).ToList());
}
}
public static List <DropdownModel> GetTags()
{
using (var context = new MakeMyJobsEntities())
{
return(context.Tags.Select(x => new DropdownModel()
{
value = x.TagId,
text = x.TagName
}).ToList());
}
}
public static int CreateStudent(SignupModel model, int userId)
{
using (var context = new MakeMyJobsEntities())
{
context.Students.Add(new Student()
{
FirstName = model.firstName,
LastName = model.lastName,
UserId = userId,
State = 0,
Country = 0,
DateJoined = DateTime.Now,
IsActive = 1
});
return(context.SaveChanges());
}
}
public static StudentInfoModel GetStudentInfo(int id)
{
using (var context = new MakeMyJobsEntities())
{
if (context.Students.Any(x => x.UserId == id))
{
StudentInfoModel studentInfoModel = context.Students.Join(context.States, s => s.State, st => st.StateId, (s, st) => new
{
StateName = st.StateName,
student = s
}).Join(context.Countries, s => s.student.Country, c => c.CountryId, (s, c) => new
{
student = s,
stateName = s.StateName,
countryName = c.CountryName
}).Join(context.Users, s => s.student.student.UserId, u => u.UserId, (s, u) => new StudentInfoModel()
{
studentId = s.student.student.StudentId,
userId = s.student.student.UserId,
firstName = s.student.student.FirstName,
lastName = s.student.student.LastName,
collegeName = s.student.student.CollegeName,
contactNumber = s.student.student.ContactNumber,
dateOfBirth = s.student.student.DateOfBirth,
resume = s.student.student.Resume,
dateJoined = s.student.student.DateJoined,
address = s.student.student.Address + ", " + s.student.StateName + ", " + s.countryName,
state = s.student.student.State,
country = s.student.student.Country,
email = u.Email,
zipCode = s.student.student.ZipCode
}).FirstOrDefault(x => x.userId == id);
if (context.StudentDocuments.Any(x => x.StudentId == studentInfoModel.studentId && x.DocumentType == StudentDocumentTypes.Resume))
{
studentInfoModel.resume = "1";
}
return(studentInfoModel);
}
else
{
return(null);
}
}
}
public static bool DeleteEmployeeEducation(int id)
{
using (var context = new MakeMyJobsEntities())
{
var employeeEducation = context.EmployeeEducations.FirstOrDefault(x => x.EmpEducationId == id);
if (employeeEducation != null)
{
employeeEducation.IsActive = 2;
int deleted = context.SaveChanges();
return(deleted > 0);
}
else
{
return(false);
}
}
}
public static LoginResponseModel Login(LoginModel model)
{
using (var context = new MakeMyJobsEntities())
{
User user = context.Users.FirstOrDefault(x => x.Email == model.email && x.Password == model.password && x.IsActive == 1);
LoginResponseModel loginResponse = new LoginResponseModel();
if (user != null)
{
loginResponse.loggedIn = 1;
if (user.UserType == UserTypes.Student)
{
Student student = context.Students.FirstOrDefault(x => x.UserId == user.UserId);
loginResponse.firstName = student.FirstName;
loginResponse.lastName = student.LastName;
loginResponse.userId = student.UserId;
loginResponse.email = user.Email;
loginResponse.userType = user.UserType;
}
else if (user.UserType == UserTypes.Employee)
{
Employee employee = context.Employees.FirstOrDefault(x => x.UserId == user.UserId);
loginResponse.firstName = employee.FirstName;
loginResponse.lastName = employee.LastName;
loginResponse.userId = employee.UserId;
loginResponse.email = user.Email;
loginResponse.userType = user.UserType;
}
else
{
Corporate corporate = context.Corporates.FirstOrDefault(x => x.UserId == user.UserId);
loginResponse.firstName = corporate.FirstName;
loginResponse.lastName = corporate.LastName;
loginResponse.userId = corporate.UserId;
loginResponse.email = user.Email;
loginResponse.userType = user.UserType;
}
}
else
{
loginResponse.loggedIn = 0;
}
return(loginResponse);
}
}
public static EmployeeExperienceModel EditEmployeeExperience(EmployeeExperienceModel model)
{
using (var context = new MakeMyJobsEntities())
{
EmployeeExperience employeeExperience = context.EmployeeExperiences.FirstOrDefault(x => x.EmpExperienceId == model.empExperienceId);
if (employeeExperience != null)
{
employeeExperience.EmployeeId = model.employeeId;
employeeExperience.CompanyName = model.companyName;
employeeExperience.Position = model.position;
employeeExperience.JoinedOn = model.joinedOn;
employeeExperience.LeftOn = model.leftOn;
employeeExperience.IsActive = 1;
int updated = context.SaveChanges();
if (updated > 0)
{
return(new EmployeeExperienceModel()
{
empExperienceId = employeeExperience.EmpExperienceId,
employeeId = employeeExperience.EmployeeId,
companyName = employeeExperience.CompanyName,
position = employeeExperience.Position,
joinedOn = employeeExperience.JoinedOn,
leftOn = employeeExperience.LeftOn,
isActive = employeeExperience.IsActive
});
}
else
{
return(null);
}
}
else
{
return(null);
}
}
}
public static EmployeeEducationModel EditEmployeeEducation(EmployeeEducationModel model)
{
using (var context = new MakeMyJobsEntities())
{
EmployeeEducation employeeEducation = context.EmployeeEducations.FirstOrDefault(x => x.EmpEducationId == model.empEducationId);
if (employeeEducation != null)
{
employeeEducation.EmployeeId = model.employeeId;
employeeEducation.InstituteName = model.instituteName;
employeeEducation.InstituteType = model.instituteType;
employeeEducation.JoinedOn = model.joinedOn;
employeeEducation.PassedOn = model.passedOn;
employeeEducation.IsActive = 1;
int updated = context.SaveChanges();
if (updated > 0)
{
return(new EmployeeEducationModel()
{
empEducationId = employeeEducation.EmpEducationId,
employeeId = employeeEducation.EmployeeId,
instituteName = employeeEducation.InstituteName,
instituteType = employeeEducation.InstituteType,
joinedOn = employeeEducation.JoinedOn,
passedOn = employeeEducation.PassedOn,
isActive = employeeEducation.IsActive
});
}
else
{
return(null);
}
}
else
{
return(null);
}
}
}
public static int ChangePassword(ChangePasswordModel model)
{
using (var context = new MakeMyJobsEntities())
{
var user = context.Users.FirstOrDefault(x => x.UserId == model.userId && x.IsActive == 1 && x.Password == model.currentPassword);
if (user == null)
{
return(0);
}
else
{
user.Password = model.updatedPassword;
int updated = context.SaveChanges();
if (updated > 0)
{
return(updated);
}
else
{
return(0);
}
}
}
}
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);
}
}
}
