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));
}
