public ActionResult AssignAssessment(AssignAssessmentViewModel obj, FormCollection objf) { bool flag = false; if (ModelState.IsValid) { AssessmentPaperModel assessmentPaperModel = new AssessmentPaperModel(); assessmentPaperModel.CourseId = obj.CourseId; assessmentPaperModel.CreatedBy = Convert.ToInt32(Session["EmpID"]); assessmentPaperModel.EmpIdAll = Convert.ToString(objf["SelectedEmp"]); flag = _IAssessmentService.SetAssessment(assessmentPaperModel); } if (flag) { TempData["Result"] = "Assessment Set successfully"; obj.ListCourses = LoadTrainingCourses("AssignAssessment", 0); //Vrp Hard code : for Admin login no neeed to pass empid obj.CourseId = 0; obj.CourseName = ""; return(View("AssignAssessment", obj)); } else { return(View("Error")); } }
public bool SetAssessment(AssessmentPaperModel obj) { bool flag = false; DataAccessClass dataAccessClass = new DataAccessClass(); try { dataAccessClass.OpenConnection(DBConstants.GetDBConnectionString()); SqlParameter[] sqlParam = new SqlParameter[3]; sqlParam[0] = new SqlParameter(SPParameter.CourseId, SqlDbType.Int); sqlParam[0].Value = Int32.Parse(obj.CourseId.ToString()); sqlParam[1] = new SqlParameter(SPParameter.EmployeesId, SqlDbType.Text); sqlParam[1].Value = Convert.ToString(obj.EmpIdAll.ToString()); sqlParam[2] = new SqlParameter(SPParameter.CreatedBy, SqlDbType.Int); sqlParam[2].Value = Int32.Parse(obj.CreatedBy.ToString()); SqlDataReader dr = dataAccessClass.ExecuteReaderSP(SPNames.SetAssessment, sqlParam); while (dr.Read()) { flag = Convert.ToBoolean(dr[DbTableColumn.Status]); } } catch (Exception ex) { throw ex; } return(flag); }
public int SaveAssessmentPaper(AssessmentPaperModel assessmentPaperModel) { int asessmentPaperId = 0; if (assessmentPaperModel.AssessmentPaperId == 0) { asessmentPaperId = 1; } return(asessmentPaperId); }
public int SaveAssessmentPaper(AssessmentPaperModel assessmentPaperModel) { int saveStatus = 0; int assessmentPaperId = 0; SqlConnection objConnection = null; SqlCommand objCommand = null; string ConnStr = string.Empty; try { ConnStr = DBConstants.GetDBConnectionString(); objConnection = new SqlConnection(ConnStr); objConnection.Open(); Master master = new Master(); objCommand = new SqlCommand(SPNames.AssessmentPaperSave, objConnection); objCommand.CommandType = CommandType.StoredProcedure; SqlParameter[] sqlParam = new SqlParameter[7]; sqlParam[0] = objCommand.Parameters.AddWithValue(SPParameter.CourseId, assessmentPaperModel.CourseId); sqlParam[1] = objCommand.Parameters.AddWithValue(SPParameter.AssessmentDate, assessmentPaperModel.AssessmentDate); sqlParam[2] = objCommand.Parameters.AddWithValue(SPParameter.TimeDuration, assessmentPaperModel.TimeDuration); sqlParam[3] = objCommand.Parameters.AddWithValue(SPParameter.CreatedById, master.GetEmployeeIDByEmailID()); sqlParam[4] = objCommand.Parameters.AddWithValue(SPParameter.IsActive, assessmentPaperModel.IsActive); sqlParam[5] = objCommand.Parameters.AddWithValue(SPParameter.Status, 0); sqlParam[6] = objCommand.Parameters.AddWithValue(SPParameter.AssessmentPaperId, 0); sqlParam[5].Direction = ParameterDirection.Output; sqlParam[6].Direction = ParameterDirection.Output; objCommand.ExecuteNonQuery(); saveStatus = Convert.ToInt32(sqlParam[5].Value); assessmentPaperId = Convert.ToInt32(sqlParam[6].Value); } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, "SaveAssessmentPaper", "SaveAssessmentPaper", EventIDConstants.TRAINING_DATA_ACCESS_LAYER); } finally { if (objConnection.State == ConnectionState.Open) { objConnection.Close(); } } return(assessmentPaperId); }
public ActionResult CreateAssessment(AssessmentViewModel assessmentPaperViewModel) //AssessmentPaperViewModel assessmentPaperViewModel { int assessmentPaperId = 0; AssessmentPaperModel assessmentPaperModel = new AssessmentPaperModel(); assessmentPaperModel.AssessmentPaperId = assessmentPaperViewModel.AssessmentPaper.AssessmentPaperId; assessmentPaperModel.CourseId = assessmentPaperViewModel.AssessmentPaper.CourseId; assessmentPaperModel.AssessmentDate = assessmentPaperViewModel.AssessmentPaper.AssessmentDate; assessmentPaperModel.TimeDuration = assessmentPaperViewModel.AssessmentPaper.TimeDuration; assessmentPaperModel.IsActive = true; assessmentPaperModel.CreatedOn = DateTime.Now; assessmentPaperModel.LastEditedOn = DateTime.Now; assessmentPaperId = _IAssessmentService.SaveAssessmentPaper(assessmentPaperModel); if (assessmentPaperId > 0) { string passessmentPaperId = CheckAccessAttribute.Encode(Convert.ToString(assessmentPaperId)); return(RedirectToAction("ShowAssessmentPaperDetails", new { Id = passessmentPaperId })); } else { return(View("Error")); } }
public bool SetAssessment(AssessmentPaperModel obj) { return(_IAssessmentRepository.SetAssessment(obj)); }
public int SaveAssessmentPaper(AssessmentPaperModel assessmentPaperModel) { return(_IAssessmentRepository.SaveAssessmentPaper(assessmentPaperModel)); }