public ActionResult SaveWorkExperirnce(EmployeeExperienceViewModel model)
{
DateTime StDate = new DateTime();
DateTime EdDate = new DateTime();
var startDateToString = DateTime.ParseExact(model.JobStartDate, inputFormat, CultureInfo.InvariantCulture);
StDate = Convert.ToDateTime(startDateToString.ToString(outputFormat));
var EndDateToString = DateTime.ParseExact(model.JobEndDate, inputFormat, CultureInfo.InvariantCulture);
EdDate = Convert.ToDateTime(EndDateToString.ToString(outputFormat));
if (model.Id == 0)
{
Employee_Experiences mm = new Employee_Experiences();
mm.EmployeeID = model.EmployeeID;
mm.JobTitle = model.JobTitle;
mm.CompanyName = model.CompanyName;
mm.JobStartDate = StDate;
mm.JobEndDate = EdDate;
mm.OtherInformation = model.OtherInformation;
mm.Archived = false;
mm.CreatedDate = DateTime.Now;
mm.LastModified = DateTime.Now;
mm.UserIDCreatedBy = SessionProxy.UserId;
mm.UserIDLastModifiedBy = SessionProxy.UserId;
_db.Employee_Experiences.Add(mm);
_db.SaveChanges();
}
else
{
var data = _db.Employee_Experiences.Where(x => x.Id == model.Id).FirstOrDefault();
data.JobTitle = model.JobTitle;
data.CompanyName = model.CompanyName;
data.JobStartDate = StDate;
data.JobEndDate = EdDate;
data.OtherInformation = model.OtherInformation;
data.Archived = false;
data.LastModified = DateTime.Now;
data.UserIDLastModifiedBy = SessionProxy.UserId;
_db.SaveChanges();
}
EmployeeResumeViewModel models = AllDetailsList(model.EmployeeID);
return(PartialView("_partialResumeDetailsList", models));
}
public ActionResult AddEditWorkExperience(int Id, int employeeId)
{
EmployeeExperienceViewModel model = new EmployeeExperienceViewModel();
if (Id == 0)
{
model.Id = 0;
model.EmployeeID = employeeId;
model.JobStartDate = String.Format("{0:dd-MM-yyyy}", DateTime.Now);
model.JobEndDate = String.Format("{0:dd-MM-yyyy}", DateTime.Now);
}
else
{
var data = _db.Employee_Experiences.Where(x => x.Id == Id).FirstOrDefault();
model.Id = data.Id;
model.EmployeeID = data.EmployeeID;
model.JobTitle = data.JobTitle;
model.CompanyName = data.CompanyName;
model.JobStartDate = String.Format("{0:dd-MM-yyyy}", data.JobStartDate);
model.JobEndDate = String.Format("{0:dd-MM-yyyy}", data.JobEndDate);
model.OtherInformation = data.OtherInformation;
}
return(PartialView("_partialAddEditWorkExperience", model));
}
private void EmployeeApplication_OnUnloaded(object sender, RoutedEventArgs e)
{
EmployeeExperienceViewModel.CleanUp();
}
public EmployeeResumeViewModel AllDetailsList(int EmployeeId)
{
EmployeeResumeViewModel modelList = new EmployeeResumeViewModel();
modelList.EmployeeID = EmployeeId;
var workdetails = _db.Employee_Experiences.Where(x => x.EmployeeID == EmployeeId && x.Archived == false).ToList();
var educationDetails = _db.Employee_Educations.Where(x => x.EmployeeID == EmployeeId && x.Archived == false).ToList();
var qualificationlist = _db.Employee_Qualifications.Where(x => x.EmployeeID == EmployeeId && x.Archived == false).ToList();
var laguageDetailsList = _db.Employee_Languages.Where(x => x.EmployeeID == EmployeeId && x.Archived == false).ToList();
var resumeText = _db.Employee_Resume.Where(x => x.EmployeeID == EmployeeId).FirstOrDefault();
if (resumeText != null)
{
modelList.ResumeID = resumeText.Id;
modelList.ResumeText = resumeText.ResumeText;
}
if (workdetails.Count > 0)
{
foreach (var item in workdetails)
{
EmployeeExperienceViewModel model = new EmployeeExperienceViewModel();
model.Id = item.Id;
model.EmployeeID = item.EmployeeID;
model.CompanyName = item.CompanyName;
model.JobTitle = item.JobTitle;
model.JobStartDate = String.Format("{0:MMM-yyyy}", item.JobStartDate);
model.JobEndDate = String.Format("{0:MMM-yyyy}", item.JobEndDate);
model.OtherInformation = item.OtherInformation;
modelList.WorkExperienceList.Add(model);
}
}
if (educationDetails.Count > 0)
{
foreach (var item in educationDetails)
{
EmployeeEducationsViewModel model = new EmployeeEducationsViewModel();
model.Id = item.Id;
model.EmployeeID = item.EmployeeID;
model.CourseName = item.CourseName;
model.InstitutionName = item.InstitutionName;
model.StartDate = String.Format("{0:MMM-yyyy}", item.StartDate);
model.EndDate = String.Format("{0:MMM-yyyy}", item.EndDate);
model.OtherInformation = item.OtherInformation;
modelList.EductionList.Add(model);
}
}
if (qualificationlist.Count > 0)
{
foreach (var item in qualificationlist)
{
EmployeeQualificationsViewModel model = new EmployeeQualificationsViewModel();
model.Id = item.Id;
model.EmployeeID = item.EmployeeID;
model.Detail = item.Detail;
modelList.QualificationList.Add(model);
}
}
if (laguageDetailsList.Count > 0)
{
foreach (var item in laguageDetailsList)
{
var languageName = _otherSettingMethod.getSystemListValueById((int)item.LanguageID);
//var SpeakingName = _otherSettingMethod.getSystemListValueById((int)item.SpeakingID);
//var ListeningName = _otherSettingMethod.getSystemListValueById((int)item.ListeningID);
//var WritingName = _otherSettingMethod.getSystemListValueById((int)item.WritingID);
//var ReadingName = _otherSettingMethod.getSystemListValueById((int)item.ReadingID);
EmployeeLanguagesViewModel model = new EmployeeLanguagesViewModel();
model.Id = item.Id;
model.EmployeeID = item.EmployeeID;
model.LanguageID = (int)item.LanguageID;
model.LanguageName = languageName.Value;
modelList.LanguageDetailsList.Add(model);
//model.SpeakingID = (int)item.SpeakingID;
//model.SpeakingName = SpeakingName.Value;
//model.ListeningID = (int)item.ListeningID;
//model.ListeningName = ListeningName.Value;
//model.WritingID = (int)item.WritingID;
//model.WritingName = WritingName.Value;
//model.ReadingID = (int)item.ReadingID;
//model.ReadingName = ReadingName.Value;
}
}
return(modelList);
}
