public bool DeleteEmployeeQualification(int qualId, int enployeeId)
{
bool isDeleted = false;
tbl_PM_EmployeeQualificationMatrix qual = dbContext.tbl_PM_EmployeeQualificationMatrix.Where(qd => qd.EmployeeQualificationID == qualId && qd.EmployeeID == enployeeId).FirstOrDefault();
if (qual != null && qual.EmployeeQualificationID > 0)
{
dbContext.DeleteObject(qual);
dbContext.SaveChanges();
isDeleted = true;
}
return(isDeleted);
}
public bool SaveEmployeeQualification(EmployeeQualifications model, bool IsLoggedInEmployee, int?SelectedQualificationID, int?SelectedDegreeID, int?SelectedYearID, int?SelectedTypeID, int?EmployeeId)
{
bool isAdded = false;
tbl_PM_EmployeeQualificationMatrix emp = dbContext.tbl_PM_EmployeeQualificationMatrix.Where(ed => ed.EmployeeQualificationID == model.EmployeeQualificationID).FirstOrDefault();
if (emp == null || emp.EmployeeQualificationID <= 0)
{
tbl_PM_EmployeeQualificationMatrix employeeQualifications = new tbl_PM_EmployeeQualificationMatrix();
employeeQualifications.EmployeeQualificationID = model.EmployeeQualificationID;
employeeQualifications.EmployeeID = EmployeeId;
employeeQualifications.QualificationID = SelectedQualificationID;
employeeQualifications.QualificationGroupID = SelectedDegreeID;
if (model.Specialization != null && model.Specialization != "")
{
employeeQualifications.Specialization = model.Specialization.Trim();
}
else
{
employeeQualifications.Specialization = model.Specialization;
}
if (model.Institute != null && model.Institute != "")
{
employeeQualifications.Institute = model.Institute.Trim();
}
else
{
employeeQualifications.Institute = model.Institute;
}
if (model.University != null && model.University != "")
{
employeeQualifications.University = model.University.Trim();
}
else
{
employeeQualifications.University = model.University;
}
//Courses = model.NewEmployeeQualification.Course;
employeeQualifications.PassoutYear = SelectedYearID;
employeeQualifications.QualificationTypeID = SelectedTypeID;
if (model.Percentage != null && model.Percentage != "")
{
employeeQualifications.Class = model.Percentage.Trim();
}
else
{
employeeQualifications.Class = model.Percentage;
}
dbContext.tbl_PM_EmployeeQualificationMatrix.AddObject(employeeQualifications);
dbContext.SaveChanges();
if (IsLoggedInEmployee == true)
{
tbl_PM_EmployeeQualificationMatrix_History Qualifications = new tbl_PM_EmployeeQualificationMatrix_History();
Qualifications.EmployeeQualificationID = employeeQualifications.EmployeeQualificationID;
Qualifications.EmployeeID = EmployeeId;
Qualifications.QualificationID = SelectedQualificationID;
Qualifications.QualificationGroupID = SelectedDegreeID;
if (model.Specialization != null && model.Specialization != "")
{
Qualifications.Specialization = model.Specialization.Trim();
}
else
{
Qualifications.Specialization = model.Specialization;
}
if (model.Institute != null && model.Institute != "")
{
Qualifications.Institute = model.Institute.Trim();
}
else
{
Qualifications.Institute = model.Institute;
}
if (model.University != null && model.University != "")
{
Qualifications.University = model.University.Trim();
}
else
{
Qualifications.University = model.University;
}
//Courses = model.NewEmployeeQualification.Course;
Qualifications.PassoutYear = SelectedYearID;
Qualifications.QualificationTypeID = SelectedTypeID;
if (model.Percentage != null && model.Percentage != "")
{
Qualifications.Class = model.Percentage.Trim();
}
else
{
Qualifications.Class = model.Percentage;
}
Qualifications.ActionType = "Add";
Qualifications.CreatedBy = EmployeeId.ToString();
Qualifications.CreatedDate = DateTime.Now;
Qualifications.SendMail = true;
dbContext.tbl_PM_EmployeeQualificationMatrix_History.AddObject(Qualifications);
dbContext.SaveChanges();
}
}
//for edit
else
{
if (
emp.EmployeeID != EmployeeId ||
//emp.Courses != model.NewEmployeeQualification.Course ||
emp.Institute != model.Institute ||
emp.PassoutYear != SelectedYearID ||
//column percentage from db was not allowing to edit nvarchar values properly so using class column to store percentage as well grades
emp.Class != model.Percentage ||
emp.Specialization != model.Specialization ||
emp.QualificationTypeID != SelectedTypeID ||
emp.QualificationID != SelectedQualificationID ||
emp.QualificationGroupID != SelectedDegreeID ||
emp.University != model.University
)
{
if (IsLoggedInEmployee == true)
{
tbl_PM_EmployeeQualificationMatrix_History Qualifications = new tbl_PM_EmployeeQualificationMatrix_History();
Qualifications.EmployeeQualificationID = model.EmployeeQualificationID;
Qualifications.EmployeeID = emp.EmployeeID;
Qualifications.QualificationID = emp.QualificationID;
Qualifications.QualificationGroupID = emp.QualificationGroupID;
if (emp.Specialization != null && emp.Specialization != "")
{
Qualifications.Specialization = emp.Specialization.Trim();
}
else
{
Qualifications.Specialization = emp.Specialization;
}
if (emp.Institute != null && emp.Institute != "")
{
Qualifications.Institute = emp.Institute.Trim();
}
else
{
Qualifications.Institute = emp.Institute;
}
if (emp.University != null && emp.University != "")
{
Qualifications.University = emp.University.Trim();
}
else
{
Qualifications.University = emp.University;
}
Qualifications.Courses = emp.Courses;
Qualifications.PassoutYear = emp.PassoutYear;
Qualifications.QualificationTypeID = emp.QualificationTypeID;
if (emp.Class != null && emp.Class != "")
{
Qualifications.Class = emp.Class.Trim();
}
else
{
Qualifications.Class = emp.Class;
}
Qualifications.ActionType = "Edit";
Qualifications.ModifiedBy = EmployeeId.ToString();
Qualifications.ModifiedDate = DateTime.Now;
Qualifications.SendMail = true;
dbContext.tbl_PM_EmployeeQualificationMatrix_History.AddObject(Qualifications);
dbContext.SaveChanges();
}
emp.EmployeeID = EmployeeId;
//emp.Courses = model.NewEmployeeQualification.Course;
if (model.Institute != null && model.Institute != "")
{
emp.Institute = model.Institute.Trim();
}
else
{
emp.Institute = model.Institute;
}
emp.PassoutYear = SelectedYearID;
//column percentage from db was not allowing to edit nvarchar values properly so using class column to store percentage as well grades
if (model.Percentage != null && model.Percentage != "")
{
emp.Class = model.Percentage.Trim();
}
else
{
emp.Class = model.Percentage;
}
if (model.Specialization != null && model.Specialization != "")
{
emp.Specialization = model.Specialization.Trim();
}
else
{
emp.Specialization = model.Specialization;
}
emp.QualificationTypeID = SelectedTypeID;
emp.QualificationID = SelectedQualificationID;
emp.QualificationGroupID = SelectedDegreeID;
if (model.University != null && model.University != "")
{
emp.University = model.University.Trim();
}
else
{
emp.University = model.University;
}
}
}
dbContext.SaveChanges();
isAdded = true;
return(isAdded);
}
