public List <UserEmploymentDetail> Get(int userId)
{
var reader = this.GetReader($"select * from useremploymentDetails where userId={userId}");
var userEmpolymentDetails = new List <UserEmploymentDetail>();
while (reader.Read())
{
var userEmploymentDetail = new UserEmploymentDetail();
userEmploymentDetail.Designation = reader.GetString(2);
userEmploymentDetail.CompanyName = reader.GetString(3);
userEmploymentDetail.SalaryLakhs = reader.GetString(4);
userEmploymentDetail.SalaryThousands = reader.GetString(5);
userEmploymentDetail.StartYear = reader.GetInt32(6);
userEmploymentDetail.StartMonth = reader.GetString(7);
userEmploymentDetail.EndYear = reader.GetInt32(8);
userEmploymentDetail.EndMonth = reader.GetString(9);
userEmploymentDetail.City = reader.GetString(10);
userEmploymentDetail.NoticPeriod = reader.GetString(11);
userEmploymentDetail.Industry = reader.GetString(12);
userEmploymentDetail.FunctionalArea = reader.GetString(13);
userEmploymentDetail.Role = reader.GetString(14);
userEmpolymentDetails.Add(userEmploymentDetail);
}
return(userEmpolymentDetails);
}
public static string AddEmploymentDetails(string[] OrganizationName, string[] City, int[] StateId, string[] TelephoneNumber, string[] PositionTitle, string[] Description, int[] StartMonth, int[] StartYear, int[] EndMonth, int[] EndYear, string[] IsAttending)
{
// DateTime[] StartDate, DateTime?[] EndDate,
UserProfileInfo userProfileInfo = new UserProfileInfo();
string message = Constant.CONST_PROFESSIONAL_EXP_FAILURE;
if (SessionWrapper.LoggedUser == null)
{
return(message = Constant.SESSION_EXPIRE);
}
try
{
List <UserEmploymentDetail> empDetailList = new List <UserEmploymentDetail>();
UserEmploymentDetail empDetails;
int count = 0;
while (count < OrganizationName.Length)
{
if (!String.IsNullOrEmpty(OrganizationName[count]))
{
empDetails = new UserEmploymentDetail();
empDetails.OrgName = OrganizationName[count].Trim();
empDetails.City = City[count].Trim();
empDetails.Telephone = TelephoneNumber[count].Trim();
empDetails.StateId = StateId[count];
empDetails.PositionTitle = PositionTitle[count].Trim();
empDetails.StartMonth = StartMonth[count];
empDetails.StartYear = StartYear[count];
empDetails.EndMonth = EndMonth[count];
empDetails.EndYear = EndYear[count];
empDetails.Description = Description[count].Trim();
empDetails.IsAttending = Convert.ToBoolean(IsAttending[count]);
empDetails.UserId = SessionWrapper.LoggedUser.UserId;
empDetailList.Add(empDetails);
}
count++;
}
userProfileInfo = UserEmploymentDetailsHelper.SaveUserEmpDetails(empDetailList);
}
catch { }
if (userProfileInfo.IsFirstRecord)
{
message = Constant.CONST_PROFESSIONAL_ADD_SUCCESS;
}
else
{
message = Constant.CONST_PROFESSIONAL_EXP_SUCCESS;
}
return(message);
}
public static bool DeleteEmpDetailsById(int EmpDetailsId)
{
bool isDeleted = false;
try
{
Repository <UserEmploymentDetail> repository = new Repository <UserEmploymentDetail>("UserEmploymentDetailId");
UserEmploymentDetail empDetails = repository.SelectByKey(EmpDetailsId.ToString());
if (empDetails != null)
{
repository.Delete(empDetails);
repository.Save();
isDeleted = true;
}
}
catch { }
return(isDeleted);
}
private void SetFromSessionData()
{
List <UserEmploymentDetail> userEmpDetails = new List <UserEmploymentDetail>();
int proCount = SessionWrapper.ResumeParserData.SegregatedExperience.WorkHistory.Count;
UserEmploymentDetail userEmpDetail;
for (int i = 0; i < proCount; i++)
{
userEmpDetail = new UserEmploymentDetail();
userEmpDetail.OrgName = SessionWrapper.ResumeParserData.SegregatedExperience.WorkHistory[i].Employer;
userEmpDetail.City = SessionWrapper.ResumeParserData.SegregatedExperience.WorkHistory[i].JobLocation.EmployerCity;
userEmpDetail.PositionTitle = SessionWrapper.ResumeParserData.SegregatedExperience.WorkHistory[i].JobProfile.Title;
userEmpDetail.Description = SessionWrapper.ResumeParserData.SegregatedExperience.WorkHistory[i].JobDescription;
userEmpDetails.Add(userEmpDetail);
}
if (userEmpDetails.Count > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "AddEmpControl(" + userEmpDetails.Count + ");", true);
FillInformation(userEmpDetails);
}
}
public void Add(UserEmploymentDetail userEmploymentDetail)
{
this.ExecuteNonQuery($"insert into useremploymentdetails(UserId,Designation,CompanyName,SalaryLakhs,SalaryThousands,StartYear,StartMonth,EndYear,EndMonth,City,NoticePeriod,Industry,FunctionalArea,Role) values({userEmploymentDetail.UserId},'{userEmploymentDetail.Designation}','{userEmploymentDetail.CompanyName}','{userEmploymentDetail.SalaryLakhs}','{userEmploymentDetail.SalaryThousands}',{userEmploymentDetail.StartYear},'{userEmploymentDetail.StartMonth}',{userEmploymentDetail.EndYear},'{userEmploymentDetail.EndMonth}','{userEmploymentDetail.City}','{userEmploymentDetail.NoticPeriod}','{userEmploymentDetail.Industry}','{userEmploymentDetail.FunctionalArea}','{userEmploymentDetail.Role}')");
}
public IActionResult Post(UserEmploymentDetail userEmploymentDetail)
{
this.UserEmploymentDetailDomain.Add(userEmploymentDetail);
return(Ok());
}
public static UserProfileInfo SaveUserEmpDetails(List <UserEmploymentDetail> UserEmpDetail)
{
//bool isSaved = false;
Repository <UserEmploymentDetail> EmpDetailNewRepository = new Repository <UserEmploymentDetail>();
UserEmploymentDetail userEmpdetails;
int userId = UserEmpDetail[0].UserId;
ISpecification <UserEmploymentDetail> specification = new Specification <UserEmploymentDetail>(u => u.UserId == userId);
Repository <UserEmploymentDetail> repository = new Repository <UserEmploymentDetail>();
IList <UserEmploymentDetail> empDetailList = repository.SelectAll(specification);
UserProfileInfo userProfileInfo = new UserProfileInfo();
if (empDetailList.Count == 0)
{
userProfileInfo.IsFirstRecord = true;
}
else
{
userProfileInfo.IsFirstRecord = false;
}
try
{
int count = 0;
while (count < UserEmpDetail.Count)
{
if (count < empDetailList.Count)
{
empDetailList[count].OrgName = UserEmpDetail[count].OrgName;
empDetailList[count].City = UserEmpDetail[count].City;
empDetailList[count].StateId = UserEmpDetail[count].StateId;
empDetailList[count].Telephone = UserEmpDetail[count].Telephone;
empDetailList[count].PositionTitle = UserEmpDetail[count].PositionTitle;
empDetailList[count].StartMonth = UserEmpDetail[count].StartMonth;
empDetailList[count].StartYear = UserEmpDetail[count].StartYear;
empDetailList[count].EndMonth = UserEmpDetail[count].EndMonth;
empDetailList[count].EndYear = UserEmpDetail[count].EndYear;
empDetailList[count].Description = UserEmpDetail[count].Description;
empDetailList[count].IsAttending = UserEmpDetail[count].IsAttending;
repository.Save();
count++;
}
else
{
userEmpdetails = new UserEmploymentDetail();
userEmpdetails.OrgName = UserEmpDetail[count].OrgName;
userEmpdetails.City = UserEmpDetail[count].City;
userEmpdetails.StateId = UserEmpDetail[count].StateId;
userEmpdetails.Telephone = UserEmpDetail[count].Telephone;
userEmpdetails.PositionTitle = UserEmpDetail[count].PositionTitle;
userEmpdetails.StartMonth = UserEmpDetail[count].StartMonth;
userEmpdetails.StartYear = UserEmpDetail[count].StartYear;
userEmpdetails.EndMonth = UserEmpDetail[count].EndMonth;
userEmpdetails.EndYear = UserEmpDetail[count].EndYear;
userEmpdetails.Description = UserEmpDetail[count].Description;
userEmpdetails.IsAttending = UserEmpDetail[count].IsAttending;
userEmpdetails.UserId = UserEmpDetail[count].UserId;
EmpDetailNewRepository.Add(userEmpdetails);
EmpDetailNewRepository.Save();
count++;
}
}
//isSaved = true;
}
catch { }
return(userProfileInfo);
}
public static void FillSessionValues(person person)
{
SessionWrapper.LinkedinData = new LinkedinData();
SessionWrapper.LinkedinData.EducationalDetail = new EknowIDModel.UserEducationalDetail();
SessionWrapper.LinkedinData.EmploymentDetailes = new List <UserEmploymentDetail>();
UserEducationalDetail educationdetail = new UserEducationalDetail();
UserPostGraduation postGraduation = new UserPostGraduation();
UserEmploymentDetail empDetails;
string startDate = string.Empty;
string endDate = string.Empty;
int educations = 0, positions = 0;
if (person.educations != null)
{
educations = Convert.ToInt32(person.educations.total);
}
if (person.Positions != null)
{
positions = Convert.ToInt32(person.Positions.total);
}
if (educations != 0)
{
educationdetail.Basic = person.educations.education[0].degree;
educationdetail.Specialization = person.educations.education[0].FieldOfStudy;
if (person.educations.education[0].StartDate != null)
{
educationdetail.StartYear = Convert.ToInt32(person.educations.education[0].StartDate.year);
educationdetail.StartMonth = 1;
}
if (person.educations.education[0].StartDate != null)
{
educationdetail.EndYear = Convert.ToInt32(person.educations.education[0].EndDate.year);
educationdetail.EndMonth = 1;
}
SessionWrapper.LinkedinData.EducationalDetail = educationdetail;
if (educations >= 2)
{
postGraduation.PostGraduation = person.educations.education[1].degree;
postGraduation.Specialization = person.educations.education[1].FieldOfStudy;
if (person.educations.education[1].StartDate != null)
{
postGraduation.StartYear = Convert.ToInt32(person.educations.education[1].StartDate.year);
postGraduation.StartMonth = 1;
}
if (person.educations.education[1].StartDate != null)
{
postGraduation.EndYear = Convert.ToInt32(person.educations.education[1].EndDate.year);
postGraduation.EndMonth = 1;
}
SessionWrapper.LinkedinData.Postgraduation = postGraduation;
}
}
if (positions != 0)
{
for (int i = 0; i < Convert.ToInt32(person.Positions.total); i++)
{
empDetails = new UserEmploymentDetail();
startDate = string.Empty;
endDate = string.Empty;
empDetails.OrgName = person.Positions.position[i].company.name;
empDetails.PositionTitle = person.Positions.position[i].title;
empDetails.Description = person.Positions.position[i].summary;
if (person.phonenumbers != null && person.phonenumbers.phonenumber != null)
{
empDetails.Telephone = person.phonenumbers.phonenumber.phoneNumber;
}
if (person.Positions.position[i].StartDate != null)
{
empDetails.StartYear = Convert.ToInt32(person.Positions.position[i].StartDate.year);
empDetails.StartMonth = Convert.ToInt32(person.Positions.position[i].StartDate.month);
}
if (person.Positions.position[i].EndDate != null)
{
empDetails.EndYear = Convert.ToInt32(person.Positions.position[i].EndDate.year);
empDetails.EndMonth = Convert.ToInt32(person.Positions.position[i].EndDate.month);
}
SessionWrapper.LinkedinData.EmploymentDetailes.Add(empDetails);
}
}
}
public static string AddEmploymentDetails(string[] OrganizationName, string[] City, int[] StateId, string[] TelephoneNumber, string[] PositionTitle, string[] Description, int[] StartMonth, int[] StartYear, int[] EndMonth, int[] EndYear, string[] IsAttending)
{
UserProfileInfo userProfileInfo = new UserProfileInfo();
string message = Constant.CONST_PROFESSIONAL_EXP_FAILURE;
if (SessionWrapper.LoggedUser == null)
{
return(message = Constant.SESSION_EXPIRE);
}
try
{
List <UserEmploymentDetail> userEmpDetails = new List <UserEmploymentDetail>();
UserEmploymentDetail userEmpDetail;
OrderDetails orderDetails = GetSessionOrderDetails();
orderDetails.EmploymentDetailes = new List <EmploymentDetail>();
EmploymentDetail empDetails;
List <EmploymentDetail> EmployeeDateGapCheck = new List <EmploymentDetail>();
int count = 0;
while (count < OrganizationName.Length)
{
empDetails = new EmploymentDetail();
userEmpDetail = new UserEmploymentDetail();
empDetails.OrgName = OrganizationName[count].Trim();
empDetails.City = City[count].Trim();
empDetails.Telephone = TelephoneNumber[count].Trim();
empDetails.StateId = StateId[count];
empDetails.PositionTitle = PositionTitle[count].Trim();
empDetails.StartMonth = StartMonth[count];
empDetails.StartYear = StartYear[count];
empDetails.EndMonth = EndMonth[count];
empDetails.EndYear = EndYear[count];
empDetails.IsAttending = Convert.ToBoolean(IsAttending[count]);
empDetails.Description = Description[count].Trim();
userEmpDetail.OrgName = OrganizationName[count].Trim();
userEmpDetail.City = City[count].Trim();
userEmpDetail.Telephone = TelephoneNumber[count].Trim();
userEmpDetail.StateId = StateId[count];
userEmpDetail.PositionTitle = PositionTitle[count].Trim();
userEmpDetail.StartMonth = StartMonth[count];
userEmpDetail.StartYear = StartYear[count];
userEmpDetail.EndMonth = EndMonth[count];
userEmpDetail.EndYear = EndYear[count];
userEmpDetail.Description = Description[count].Trim();
userEmpDetail.IsAttending = Convert.ToBoolean(IsAttending[count]);
userEmpDetail.UserId = SessionWrapper.LoggedUser.UserId;
userEmpDetails.Add(userEmpDetail);
orderDetails.EmploymentDetailes.Add(empDetails);
empDetails.EmploymentDetailId = count;
string month = empDetails.StartMonth != 0 ? empDetails.StartMonth.ToString("00") : "01";
string year = empDetails.StartYear != 0 ? empDetails.StartYear.ToString(): "1900";
string startDate = "01/" + month + "/" + year;
DateTime StartDate = DateTime.ParseExact(startDate, "MM/dd/yyyy", null);
empDetails.StartDate = StartDate;
month = empDetails.EndMonth != 0 ? empDetails.EndMonth.ToString("00") : "01";
year = empDetails.EndYear != 0 ? empDetails.EndYear.ToString() : "1900";
string endDate = "01/" + month + "/" + year;
DateTime EndDate = DateTime.ParseExact(endDate, "MM/dd/yyyy", null);
empDetails.EndDate = EndDate;
EmployeeDateGapCheck.Add(empDetails);
count++;
}
SessionWrapper.OrderDetail = orderDetails;
if (userEmpDetails.Count != 0)
{
userProfileInfo = UserEmploymentDetailsHelper.SaveUserEmpDetails(userEmpDetails);
if (userProfileInfo.IsFirstRecord)
{
message = Constant.CONST_PROFESSIONAL_ADD_SUCCESS;
}
else
{
message = Constant.CONST_PROFESSIONAL_EXP_SUCCESS;
}
}
else
{
message = Constant.CONST_PROFESSIONAL_ADD_SUCCESS;
}
}
catch { }
return(message);
}
