public ActionResult UpdateJobRoleDetails(int InstanceSubClassificationId) { var instanceId = Session["InstanceId"]; GetStateList(); GetSSCList(instanceId.ToString()); if (instanceId != null) { if (InstanceSubClassificationId == 0) { ViewData["InstanceSubClassificationId"] = null; } else { JobroleDetailBl objBl = new JobroleDetailBl(); SaveJobRoleDO objDO = new SaveJobRoleDO(); objDO = objBl.GetTrainingDetailsById(InstanceSubClassificationId); if (objDO != null) { ViewData["JobRoleDetails"] = objDO; } else { ViewData["JobRoleDetails"] = null; ViewData["InstanceSubClassificationId"] = null; } } } else { } return(View()); }
public JsonResult SaveJobRoleDetails(List <SaveJobRoleDO> SaveJobeRole) { JsonResult result = new JsonResult(); JobroleDetailBl objBL = new JobroleDetailBl(); int returnStatus = 0; SaveJobRoleDO objDO = new SaveJobRoleDO(); foreach (var item in SaveJobeRole) { objDO.InstanceId = item.InstanceId; objDO.InstanceClassificationId = item.InstanceClassificationId; objDO.SubClassificationName = item.SubClassificationName; objDO.SubClassificationDescription = item.SubClassificationDescription; objDO.ResultsModeId = item.ResultsModeId; objDO.CreatedBy = item.CreatedBy; objDO.CreatedDate = item.CreatedDate; int obj = 0; obj = objBL.SaveJobRoleDetail(objDO); if (obj == 1) { returnStatus = 1; } else { returnStatus = -1; } result.Data = obj; } return(result); }
public SaveJobRoleDO GetTrainingDetailsById(int InstanceSubClassificationId) { SaveJobRoleDO objDO = new SaveJobRoleDO(); objDO = objDAL.GetTrainingDetailsById(InstanceSubClassificationId); return(objDO); }
public int SaveJobRoleDetails(SaveJobRoleDO objDO) { int resultStatus = 0; var result = db.stp_tblJobRole_INSERT_SSC(objDO.InstanceId, objDO.InstanceClassificationId, objDO.SubClassificationName, objDO.SubClassificationDescription, objDO.ResultsModeId, objDO.CreatedBy, DateTime.Now); if (result > 0) { resultStatus = 1; } else { resultStatus = result; } return(resultStatus); }
public int UpdateJobROleDetails(SaveJobRoleDO objDO) { var result = db.stp_tblJobRole_UPDATE_SSC(objDO.InstanceId, objDO.InstanceSubClassificationId, objDO.InstanceClassificationId, objDO.SubClassificationName, objDO.SubClassificationDescription, objDO.ResultsModeId, objDO.CreatedBy, DateTime.Now); var returnStatus = 0; if (result != null) { foreach (var item in result) { returnStatus = item.Value; } } return(returnStatus); }
public SaveJobRoleDO GetTrainingDetailsById(int InstanceSubClassificationId) { SaveJobRoleDO objDO = new SaveJobRoleDO(); var result = db.STP_tblInstanceSubClassification_GetJobRoleById(InstanceSubClassificationId); if (result != null) { foreach (var item in result) { objDO.InstanceId = Convert.ToInt32(item.InstanceId); objDO.InstanceClassificationId = Convert.ToInt32(item.InstanceClassificationId); objDO.InstanceSubClassificationId = Convert.ToInt32(item.InstanceSubClassificationId); objDO.SubClassificationName = item.SubClassificationName; objDO.SubClassificationDescription = item.SubClassificationDescription; objDO.ResultsModeId = Convert.ToInt32(item.ResultsModeId); } } return(objDO); }
public int UpdateJobRoleDetails(tblInstanceSubClassification obj) { var result = (from s in db.tblInstanceSubClassifications where s.InstanceSubClassificationId == obj.InstanceSubClassificationId select s).SingleOrDefault(); SaveJobRoleDO objNew = new SaveJobRoleDO(); objNew.InstanceId = Convert.ToInt32(obj.InstanceId); objNew.InstanceClassificationId = Convert.ToInt32(obj.InstanceClassificationId); objNew.InstanceSubClassificationId = Convert.ToInt32(obj.InstanceSubClassificationId); objNew.SubClassificationName = obj.SubClassificationName; objNew.SubClassificationDescription = obj.SubClassificationDescription; objNew.ResultsModeId = Convert.ToInt32(obj.ResultsModeId); if (db.SaveChanges() > 0) { return(1); } else { return(-1); } }
public int UpdateJobROleDetails(SaveJobRoleDO objDO) { return(objDAL.UpdateJobROleDetails(objDO)); }
public int SaveJobRoleDetail(SaveJobRoleDO objDO) { return(objDAL.SaveJobRoleDetails(objDO)); }