public bool DeleteCertificationDetails(int certId, int employeeId)
{
bool isDeleted = false;
tbl_PM_EmployeeCertificationMatrix cert = dbContext.tbl_PM_EmployeeCertificationMatrix.Where(cd => cd.EmployeeCertificationID == certId && cd.EmployeeID == employeeId).FirstOrDefault();
if (cert != null && cert.EmployeeCertificationID > 0)
{
dbContext.DeleteObject(cert);
dbContext.SaveChanges();
isDeleted = true;
}
return(isDeleted);
}
public bool SaveCertificationDetails(CertificationDetails model, bool IsLoggedInEmployee, int?SelectedCertificationID, int?EmployeeId)
{
bool isAdded = false;
tbl_PM_EmployeeCertificationMatrix emp = dbContext.tbl_PM_EmployeeCertificationMatrix.Where(ed => ed.EmployeeCertificationID == model.EmployeeCertificationID).FirstOrDefault();
if (emp == null || emp.EmployeeCertificationID <= 0)
{
tbl_PM_EmployeeCertificationMatrix certificationDetails = new tbl_PM_EmployeeCertificationMatrix();
certificationDetails.EmployeeCertificationID = model.EmployeeCertificationID;
certificationDetails.EmployeeID = EmployeeId;
certificationDetails.CertificationID = SelectedCertificationID;
if (model.CertificationNo != null && model.CertificationNo != "")
{
certificationDetails.CertificationNo = model.CertificationNo.Trim();
}
else
{
certificationDetails.CertificationNo = model.CertificationNo;
}
certificationDetails.CertificationDate = model.CertificationDate;
if (model.Institution != null && model.Institution != "")
{
certificationDetails.InstituteName = model.Institution.Trim();
}
else
{
certificationDetails.InstituteName = model.Institution;
}
if (model.CertificationScore != null && model.CertificationScore != "")
{
certificationDetails.TotalScore = model.CertificationScore.Trim();
}
else
{
certificationDetails.TotalScore = model.CertificationScore;
}
if (model.CertificationGrade != null && model.CertificationGrade != "")
{
certificationDetails.Grade = model.CertificationGrade.Trim();
}
else
{
certificationDetails.Grade = model.CertificationGrade;
}
dbContext.tbl_PM_EmployeeCertificationMatrix.AddObject(certificationDetails);
dbContext.SaveChanges();
if (IsLoggedInEmployee == true)
{
tbl_PM_EmployeeCertificationMatrixHistory certificationHistory = new tbl_PM_EmployeeCertificationMatrixHistory();
certificationHistory.EmployeeCertificationID = certificationDetails.EmployeeCertificationID;
certificationHistory.EmployeeID = EmployeeId;
certificationHistory.CertificationID = SelectedCertificationID;
if (model.CertificationNo != null && model.CertificationNo != "")
{
certificationHistory.CertificationNo = model.CertificationNo.Trim();
}
else
{
certificationHistory.CertificationNo = model.CertificationNo;
}
certificationHistory.CertificationDate = model.CertificationDate;
if (model.Institution != null && model.Institution != "")
{
certificationHistory.InstituteName = model.Institution.Trim();
}
else
{
certificationHistory.InstituteName = model.Institution;
}
if (model.CertificationScore != null && model.CertificationScore != "")
{
certificationHistory.TotalScore = model.CertificationScore.Trim();
}
else
{
certificationHistory.TotalScore = model.CertificationScore;
}
if (model.CertificationGrade != null && model.CertificationGrade != "")
{
certificationHistory.Grade = model.CertificationGrade.Trim();
}
else
{
certificationHistory.Grade = model.CertificationGrade;
}
certificationHistory.ActionType = "Add";
certificationHistory.CreatedBy = EmployeeId.ToString();
certificationHistory.CreatedDate = DateTime.Now;
certificationHistory.SendMail = true;
dbContext.tbl_PM_EmployeeCertificationMatrixHistory.AddObject(certificationHistory);
dbContext.SaveChanges();
}
}
else
{
if (emp.EmployeeID != EmployeeId ||
emp.CertificationID != SelectedCertificationID ||
emp.CertificationNo != model.CertificationNo ||
emp.CertificationDate != model.CertificationDate ||
emp.Grade != model.CertificationGrade ||
emp.InstituteName != model.Institution ||
emp.TotalScore != model.CertificationScore)
{
if (IsLoggedInEmployee == true)
{
tbl_PM_EmployeeCertificationMatrixHistory Certifications = new tbl_PM_EmployeeCertificationMatrixHistory();
Certifications.EmployeeCertificationID = model.EmployeeCertificationID;
Certifications.EmployeeID = emp.EmployeeID;
Certifications.CertificationID = emp.CertificationID;
if (emp.CertificationNo != null && emp.CertificationNo != "")
{
Certifications.CertificationNo = emp.CertificationNo.Trim();
}
else
{
Certifications.CertificationNo = emp.CertificationNo;
}
Certifications.CertificationDate = emp.CertificationDate;
if (emp.InstituteName != null && emp.InstituteName != "")
{
Certifications.InstituteName = emp.InstituteName.Trim();
}
else
{
Certifications.InstituteName = emp.InstituteName;
}
if (emp.TotalScore != null && emp.TotalScore != "")
{
Certifications.TotalScore = emp.TotalScore.Trim();
}
else
{
Certifications.TotalScore = emp.TotalScore;
}
if (emp.Grade != null && emp.Grade != "")
{
Certifications.Grade = emp.Grade.Trim();
}
else
{
Certifications.Grade = emp.Grade;
}
Certifications.ActionType = "Edit";
Certifications.ModifiedBy = EmployeeId.ToString();
Certifications.ModifiedDate = DateTime.Now;
Certifications.SendMail = true;
dbContext.tbl_PM_EmployeeCertificationMatrixHistory.AddObject(Certifications);
dbContext.SaveChanges();
}
emp.EmployeeID = EmployeeId;
emp.CertificationID = SelectedCertificationID;
if (model.CertificationNo != null && model.CertificationNo != "")
{
emp.CertificationNo = model.CertificationNo.Trim();
}
else
{
emp.CertificationNo = model.CertificationNo;
}
emp.CertificationDate = model.CertificationDate;
if (model.CertificationGrade != null && model.CertificationGrade != "")
{
emp.Grade = model.CertificationGrade.Trim();
}
else
{
emp.Grade = model.CertificationGrade;
}
if (model.Institution != null && model.Institution != "")
{
emp.InstituteName = model.Institution.Trim();
}
else
{
emp.InstituteName = model.Institution;
}
if (model.CertificationScore != null && model.CertificationScore != "")
{
emp.TotalScore = model.CertificationScore.Trim();
}
else
{
emp.TotalScore = model.CertificationScore;
}
}
}
dbContext.SaveChanges();
isAdded = true;
return(isAdded);
}
