public UserEmploymentDetailsVM GetUserEmploymentDetails(int userId)
{
try
{
l2g_tbl_UserEmployeementDetails user = db.l2g_tbl_UserEmployeementDetails.Where(x => x.UserId == userId).First();
return(MappingConfig.UserEmploymentDetailsToBusinessEntity(user));
}
catch (Exception)
{
return(new UserEmploymentDetailsVM());
}
}
public static l2g_tbl_UserEmployeementDetails GetUserEmploymentDetailsToDataEntity(GetUserEmploymentDetails userVM)
{
l2g_tbl_UserEmployeementDetails user = new l2g_tbl_UserEmployeementDetails()
{
UserId = userVM.UserId,
Company = userVM.Company,
Salary = userVM.Salary,
CreditScore = userVM.CreditScore,
EmployeeStatusId = userVM.EmployeeStatusId,
ContractId = userVM.ContractId
};
return(user);
}
public bool AddUserEmployementDetails(GetUserEmploymentDetails userVM)
{
l2g_tbl_UserEmployeementDetails user = MappingConfig.GetUserEmploymentDetailsToDataEntity(userVM);
user.CreatedDate = DateTime.Now;
try
{
db.l2g_tbl_UserEmployeementDetails.Add(user);
db.SaveChanges();
}
catch (Exception) {
return(false);
}
return(true);
}
public static UserEmploymentDetailsVM UserEmploymentDetailsToBusinessEntity(l2g_tbl_UserEmployeementDetails user)
{
var userVM = new UserEmploymentDetailsVM()
{
UserId = user.UserId,
Company = user.Company,
Salary = user.Salary,
CreditScore = user.CreditScore,
EmployeeStatusId = user.EmployeeStatusId ?? 4,
ContractId = user.ContractId ?? 2,
};
using (var db = new Lead2OrderGenerateDbEntities())
{
userVM.ContractType = db.l2g_tbl_Contract.Find(userVM.ContractId).ContractType;
userVM.EmployeeStatusType = db.l2g_tbl_EmployeeStatus.Find(userVM.EmployeeStatusId).EmployeeStatusType;
}
return(userVM);
}
public bool UpdateUserEmploymentDetails(GetUserEmploymentDetails userVM)
{
//l2g_tbl_UserEmployeementDetails user = MappingConfig.GetUserEmploymentDetailsToDataEntity(userVM);
try
{
l2g_tbl_UserEmployeementDetails userEntity = db.l2g_tbl_UserEmployeementDetails.Where(x => x.UserId == userVM.UserId).First();
userEntity.Company = userVM.Company;
userEntity.ContractId = userVM.ContractId;
userEntity.CreditScore = userVM.CreditScore;
userEntity.EmployeeStatusId = userVM.EmployeeStatusId;
userEntity.Salary = userVM.Salary;
db.SaveChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
