/// <summary>
/// This method is used for Get Sections
/// </summary>
/// <param name="SectionId"></param>
/// <param name="intUserId"></param>
/// <returns></returns>
public List <DCSections> GetSections(int AssessmentTypeId, int intUserId)
{
objDatabaseHelper = new DatabaseHelper();
lstDCSections = new List <DCSections>();
objDatabaseHelper.AddParameter("pUserId", intUserId == 0 ? DBNull.Value : (object)intUserId);
objDatabaseHelper.AddParameter("pAssessmentTypeId", AssessmentTypeId == 0 ? DBNull.Value : (object)AssessmentTypeId);
DbDataReader reader = objDatabaseHelper.ExecuteReader(BLDBRoutines.SP_GETSECTIONSBYASSESSMENTTYPEID, CommandType.StoredProcedure);
if (reader.HasRows)
{
while (reader.Read())
{
objDCSections = new DCSections();
objDCSections.SectionId = reader.IsDBNull(reader.GetOrdinal("SectionId")) ? 0 : reader.GetInt32(reader.GetOrdinal("SectionId"));
objDCSections.SectionName = reader.IsDBNull(reader.GetOrdinal("SectionName")) ? string.Empty : reader.GetString(reader.GetOrdinal("SectionName"));
objDCSections.SectionNumber = reader.IsDBNull(reader.GetOrdinal("SectionNumber")) ? string.Empty : reader.GetString(reader.GetOrdinal("SectionNumber"));
objDCSections.Description = reader.IsDBNull(reader.GetOrdinal("Description")) ? string.Empty : reader.GetString(reader.GetOrdinal("Description"));
objDCSections.AssessmentTypeId = reader.IsDBNull(reader.GetOrdinal("AssessmentTypeId")) ? 0 : reader.GetInt32(reader.GetOrdinal("AssessmentTypeId"));
objDCSections.Critical = reader.IsDBNull(reader.GetOrdinal("Critical")) ? string.Empty : reader.GetString(reader.GetOrdinal("Critical"));
lstDCSections.Add(objDCSections);
}
objDCSections.Code = GetSuccessCode;
}
return(lstDCSections);
}
public JsonResult QuestionsSortingBySortKey(int QuestionId, int SectionId, string Arrow, string AssessmentTypeId)
{
lstDCQuestions = new List <DCQuestions>();
objBLQuestions = new BLQuestions();
objDCSections = new DCSections();
if (Session["UserLogon"] != null)
{
DCUsers objDCUsers = (DCUsers)Session["UserLogon"];
lstDCQuestions = objBLQuestions.QuestionsSortingBySortKey(QuestionId, SectionId, Arrow, Convert.ToInt32(AssessmentTypeId), objDCUsers.UserId);
}
var result = Json(lstDCQuestions, JsonRequestBehavior.AllowGet);
result.MaxJsonLength = int.MaxValue;
return(result);
}
/// <summary>
///This method is used for Get Questions
/// </summary>
/// <returns></returns>
public JsonResult GetQuestionsBySectionId(int SectionId)
{
lstDCQuestions = new List <DCQuestions>();
objBLQuestions = new BLQuestions();
objDCSections = new DCSections();
if (Session["UserLogon"] != null)
{
DCUsers objDCUsers = (DCUsers)Session["UserLogon"];
lstDCQuestions = objBLQuestions.GetQuestionsBySectionId(SectionId, objDCUsers.UserId);
}
var result = Json(lstDCQuestions, JsonRequestBehavior.AllowGet);
result.MaxJsonLength = int.MaxValue;
return(result);
}
/// <summary>
///This method is used for Get Questions
/// </summary>
/// <returns></returns>
public JsonResult GetQuestions(string strQuestionID)
{
lstDCQuestions = new List <DCQuestions>();
objBLQuestions = new BLQuestions();
objDCSections = new DCSections();
if (Session["UserLogon"] != null)
{
DCUsers objDCUsers = (DCUsers)Session["UserLogon"];
lstDCQuestions = objBLQuestions.GetQuestions(Convert.ToInt32(strQuestionID));
}
var result = Json(lstDCQuestions, JsonRequestBehavior.AllowGet);
result.MaxJsonLength = int.MaxValue;
return(result);
}
/// <summary>
/// Author : Satish
/// Description : Add Update Sections this method used to add or update the Sections
/// Date : 12/10/2016
/// </summary>
/// <returns></returns>
public DataOperationResponse AddUpdateSections(DCSections objDCSections)
{
try
{
objDatabaseHelper = new DatabaseHelper();
objDataOperationResponse = new DataOperationResponse();
objDatabaseHelper.AddParameter("pSectionId", objDCSections.SectionId == 0 ? DBNull.Value : (object)objDCSections.SectionId);
objDatabaseHelper.AddParameter("pSectionName", objDCSections.SectionName == string.Empty ? DBNull.Value : (object)objDCSections.SectionName);
objDatabaseHelper.AddParameter("pUserId", objDCSections.CreatedBy == 0 ? DBNull.Value : (object)objDCSections.CreatedBy);
objDatabaseHelper.AddParameter("pSectionNumber", objDCSections.SectionNumber == string.Empty ? DBNull.Value : (object)objDCSections.SectionNumber);
objDatabaseHelper.AddParameter("pAssessmentTypeId", objDCSections.AssessmentTypeId == 0 ? DBNull.Value : (object)objDCSections.AssessmentTypeId);
objDatabaseHelper.AddParameter("pDescription", objDCSections.Description == string.Empty ? DBNull.Value : (object)objDCSections.Description);
objDatabaseHelper.AddParameter("pCritical", objDCSections.Critical == string.Empty ? DBNull.Value : (object)objDCSections.Critical);
objDatabaseHelper.AddParameter("oRegisterMessage", string.Empty, ParameterDirection.Output);
int result = objDatabaseHelper.ExecuteNonQuery(BLDBRoutines.SP_ADDUPDATESECTIONS, CommandType.StoredProcedure);
string strMessage = Convert.ToString(objDatabaseHelper.Command.Parameters["oRegisterMessage"].Value);
if (result > 0)
{
objDataOperationResponse.Code = GetSuccessCode;
if (strMessage == "Maximum critical Count is Six")
{
objDataOperationResponse.Message = objDCSections.SectionId == 0 ? "Section Added Successfully,Unable to Mark as Critical" : "Section Updated Successfully,Unable to Mark as Critical";
}
else
{
objDataOperationResponse.Message = objDCSections.SectionId == 0 ? "Section Added Successfully" : "Section Updated Successfully";
}
}
else
{
objDataOperationResponse.Code = GetErrorCode;
objDataOperationResponse.Message = strMessage;
}
return(objDataOperationResponse);
}
catch (Exception exce)
{
throw exce;
}
finally
{
if (objDatabaseHelper != null)
{
objDatabaseHelper.Dispose();
}
}
}
/// <summary>
/// This method is used for Add Update Sections
/// </summary>
/// <param name="strSectionName"></param>
/// <param name="hdnSectionId"></param>
/// <param name="strSectionNumber"></param>
/// <returns></returns>
public string AddUpdateSections(string strSectionName, string hdnSectionId, string strSectionNumber, string strAssessmentType, string strDescription, string strCritical)
{
objBLSections = new BLSections();
objDCSections = new DCSections();
if (Session["UserLogon"] != null)
{
DCUsers objDCUsers = (DCUsers)Session["UserLogon"];
objDCSections.SectionName = strSectionName;
objDCSections.CreatedBy = objDCUsers.UserId;
objDCSections.SectionNumber = strSectionNumber;
objDCSections.AssessmentTypeId = Convert.ToInt32(strAssessmentType);
objDCSections.SectionId = string.IsNullOrEmpty(hdnSectionId) ? 0 : Convert.ToInt32(hdnSectionId);
objDCSections.Description = strDescription;
objDCSections.Critical = strCritical;
objDataOperationResponse = objBLSections.AddUpdateSections(objDCSections);
}
return(objDataOperationResponse.Message);
}
public List <DCSections> SectionSortingBySortkey(int SectionId, string Arrow, int AssessmentTypeId, int UserId)
{
objDatabaseHelper = new DatabaseHelper();
lstDCSections = new List <DCSections>();
objDCSections = new DCSections();
objDatabaseHelper.AddParameter("pSectionId", SectionId == 0 ? DBNull.Value : (object)SectionId);
objDatabaseHelper.AddParameter("pUserId", UserId == 0 ? DBNull.Value : (object)UserId);
objDatabaseHelper.AddParameter("pArrow", Arrow == string.Empty ? DBNull.Value : (object)Arrow);
objDatabaseHelper.AddParameter("pAssessmentTypeId", AssessmentTypeId == 0 ? DBNull.Value : (object)AssessmentTypeId);
DbDataReader reader = objDatabaseHelper.ExecuteReader(BLDBRoutines.SP_SECTIONSORTINGBYSORTKEY, CommandType.StoredProcedure);
if (reader.HasRows)
{
objDCSections.Code = GetSuccessCode;
}
else
{
objDCSections.Code = GetErrorCode;
}
lstDCSections.Add(objDCSections);
return(lstDCSections);
}
public List <DCSections> GetSDV_Sections(int intUserId, int intAssessmentTypeId, int intSectionId)
{
try
{
objDatabaseHelper = new DatabaseHelper();
lstDCSections = new List <DCSections>();
objDatabaseHelper.AddParameter("pUserId", intUserId == 0 ? DBNull.Value : (object)intUserId);
objDatabaseHelper.AddParameter("pAssessmentTypeId", intAssessmentTypeId == 0 ? DBNull.Value : (object)intAssessmentTypeId);
objDatabaseHelper.AddParameter("pSectionId", intSectionId == 0 ? DBNull.Value : (object)intSectionId);
DbDataReader reader = objDatabaseHelper.ExecuteReader(BLDBRoutines.SP_GETSDV_SECTIONS, CommandType.StoredProcedure);
if (reader.HasRows)
{
while (reader.Read())
{
objDCSections = new DCSections();
objDCSections.SectionId = reader.IsDBNull(reader.GetOrdinal("SectionId")) ? 0 : reader.GetInt32(reader.GetOrdinal("SectionId"));
objDCSections.SectionName = reader.IsDBNull(reader.GetOrdinal("SectionName")) ? string.Empty : reader.GetString(reader.GetOrdinal("SectionName"));
objDCSections.SectionNumber = reader.IsDBNull(reader.GetOrdinal("SectionNumber")) ? string.Empty : reader.GetString(reader.GetOrdinal("SectionNumber"));
objDCSections.RefKey = reader.IsDBNull(reader.GetOrdinal("RefKey")) ? 0 : reader.GetInt32(reader.GetOrdinal("RefKey"));
//objDCSections.AssessmentTopic=reader.IsDBNull(reader.GetOrdinal("WAC"))?string.Empty:reader.GetString(reader.GetOrdinal("WAC"));
//objDCSections.AssessmentTopicItem = reader.IsDBNull(reader.GetOrdinal("DOCReview")) ? string.Empty : reader.GetString(reader.GetOrdinal("DOCReview"));
lstDCSections.Add(objDCSections);
}
}
return(lstDCSections);
}
catch (Exception exec)
{
throw exec;
}
finally
{
if (objDatabaseHelper != null)
{
objDatabaseHelper.Dispose();
}
}
}
