public ActionResult GetListCertificationGrid(string certificationName)
{
#region JQGrid Params
string sortColumn = (Request.Params[GridConstants.SORT_COLUMN]).ToString();
string sortOrder = (Request.Params[GridConstants.SORT_ORDER]).ToString();
int pageIndex = Convert.ToInt32(Request.Params[GridConstants.PAGE_INDEX]);
int rowCount = Convert.ToInt32(Request.Params[GridConstants.ROW_COUNT]);
#endregion
SetSessionFilter(certificationName, sortColumn, sortOrder, pageIndex, rowCount);
string name = string.Empty;
if (certificationName != Constants.TRAINING_CERTIFICATION_MASTER_SEARCH_NAME && !string.IsNullOrEmpty(certificationName))
{
name = certificationName;
}
List<sp_GetTrainingCertificationResult> trainingCerList = new TrainingCertificationDao().GetTrainingCertificationList(name).Where(p => p.IsActive == true).ToList();
int totalRecords = trainingCerList.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)rowCount);
int currentPage = CommonFunc.SetJqGridPageIndex(totalRecords, pageIndex, rowCount);
//List<sp_GetTrainingCertificationResult> finalList = trainingCerDao.Sort(trainingCerList, sortColumn, sortOrder).Skip((currentPage - 1) * rowCount)
// .Take(rowCount).ToList<sp_GetTrainingCertificationResult>();
var finalList = trainingCerList.Skip((currentPage - 1) * rowCount).Take(rowCount);
var jsonData = new
{
total = totalPages,
page = currentPage,
records = totalRecords,
rows = (
from m in finalList
select new
{
i = m.ID,
cell = new string[] {
HttpUtility.HtmlEncode(m.ID.ToString()),
HttpUtility.HtmlEncode(m.ID.ToString()),
CommonFunc.Link(HttpUtility.HtmlEncode(m.Name.ToString()), "javascript:ChooseCertificationID(\"" + m.ID + "\", \"" + m.Name + "\");", HttpUtility.HtmlEncode(m.Name.ToString()), false),
HttpUtility.HtmlEncode(m.Description)
}
}
).ToArray()
};
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
public Message Insert(Employee_Certification objUI)
{
TrainingCertificationDao trainDao = new TrainingCertificationDao();
Message msg = null;
try
{
Employee_Certification empCer = GetEmployeeAssignedCertification(objUI.EmployeeId, objUI.CertificationId);
if (objUI != null && empCer == null)
{
dbContext.Employee_Certifications.InsertOnSubmit(objUI);
dbContext.SubmitChanges();
// Show success message
objUI.Training_CertificationMaster = trainDao.GetById(objUI.CertificationId.ToString());
msg = new Message(MessageConstants.I0001, MessageType.Info, "Certification '" + objUI.Training_CertificationMaster.Name + "'", "added");
}
else
{
objUI.Training_CertificationMaster = trainDao.GetById(objUI.CertificationId.ToString());
msg = new Message(MessageConstants.E0020, MessageType.Error, "Certification '" + objUI.Training_CertificationMaster.Name + "'", "this employee");
}
}
catch (Exception ex)
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
throw ex;
}
return msg;
}