public List <HCM_QuestionnarieClientMapper> GetAllQuestionnairesList(int UserID, int ModuleID)
{
List <HCM_QuestionnarieClientMapper> questionnaire_list = new List <HCM_QuestionnarieClientMapper>();
HCM_QuestionnarieClientMapper questionnaire_obj = new HCM_QuestionnarieClientMapper();
int Srl_Numbers = 0;
try
{
using (SqlConnection sql_obj = new SqlConnection())
{
sql_obj.ConnectionString = sql.GetConnection();
sql_obj.Open();
using (SqlCommand cmd = new SqlCommand("HCM_PROC_GetAllQuestionnaires", sql_obj))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.AddWithValue("@UserID", UserID);
cmd.Parameters.AddWithValue("@ModuleID", ModuleID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
sql_obj.Close();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
questionnaire_obj = new HCM_QuestionnarieClientMapper();
questionnaire_obj.SerialNo = Convert.ToString(Srl_Numbers = i + 1);
questionnaire_obj.Module.ModuleName = Convert.ToString(dt.Rows[i]["ModuleName"]);
questionnaire_obj.WorkStream.WorkStreamName = Convert.ToString(dt.Rows[i]["WorkStreamName"]);
questionnaire_obj.Area.AreaID = Convert.ToInt32(dt.Rows[i]["AreaID"]);
questionnaire_obj.Area.AreaName = Convert.ToString(dt.Rows[i]["AreaName"]);
questionnaire_obj.SubArea.SubAreaID = Convert.ToInt32(dt.Rows[i]["SubAreaID"]);
questionnaire_obj.SubArea.SubAreaName = Convert.ToString(dt.Rows[i]["SubAreaName"]);
// questionnaire_obj.QuestionnaireClientMapperID = Convert.ToInt32(dt.Rows[i]["QuestionnaireClientMapperID"]);
questionnaire_obj.QuestionnaireName = Convert.ToString(dt.Rows[i]["QuestionnaireName"]);
questionnaire_obj.RowNumber = Convert.ToInt32(dt.Rows[i]["RowNumber"]);
questionnaire_obj.Response = Convert.ToString(dt.Rows[i]["Response"]);
questionnaire_obj.Comments = Convert.ToString(dt.Rows[i]["Comments"]);
questionnaire_obj.QuestionnaireID = Convert.ToInt32(dt.Rows[i]["QuestionnaireID"]);
questionnaire_obj.VersionID = Convert.ToInt32(dt.Rows[i]["VersionID"]);
questionnaire_list.Add(questionnaire_obj);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(questionnaire_list);
}
public List <HCM_QuestionnarieClientMapper> GetAllQuestionnairesList(int ClientID, string VersionID)
{
List <HCM_QuestionnarieClientMapper> questionnaire_list = new List <HCM_QuestionnarieClientMapper>();
HCM_QuestionnarieClientMapper questionnaire_obj = new HCM_QuestionnarieClientMapper();
try
{
using (SqlConnection sql_obj = new SqlConnection())
{
sql_obj.ConnectionString = sql.GetConnection();
sql_obj.Open();
using (SqlCommand cmd = new SqlCommand("HCM_PROC_GetAllQuestionnairesList", sql_obj))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.AddWithValue("@ClientID", ClientID);
cmd.Parameters.AddWithValue("@VersionID", Convert.ToInt32(VersionID));
cmd.Parameters.AddWithValue("@ProductID", Convert.ToInt32(HttpContext.Current.Session["ProductID"]));
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
sql_obj.Close();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
questionnaire_obj = new HCM_QuestionnarieClientMapper();
questionnaire_obj.Product.ProductID = dt.Rows[i]["ProductID"] == DBNull.Value ?(int?)null: Convert.ToInt32(dt.Rows[i]["ProductID"]);
questionnaire_obj.Product.ProductName = Convert.ToString(dt.Rows[i]["ProductName"]);
questionnaire_obj.Module.ModuleID = dt.Rows[i]["ModuleID"] == DBNull.Value ?(int?)null : Convert.ToInt32(dt.Rows[i]["ModuleID"]);
questionnaire_obj.Module.ModuleName = Convert.ToString(dt.Rows[i]["ModuleName"]);
questionnaire_obj.WorkStream.WorkStreamID = dt.Rows[i]["WorkStreamID"] == DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[i]["WorkStreamID"]);
questionnaire_obj.WorkStream.WorkStreamName = Convert.ToString(dt.Rows[i]["WorkStreamName"]);
questionnaire_obj.Area.AreaID = Convert.ToInt32(dt.Rows[i]["AreaID"]);
questionnaire_obj.Area.AreaName = Convert.ToString(dt.Rows[i]["AreaName"]);
questionnaire_obj.SubArea.SubAreaID = Convert.ToInt32(dt.Rows[i]["SubAreaID"]);
questionnaire_obj.SubArea.SubAreaName = Convert.ToString(dt.Rows[i]["SubAreaName"]);
questionnaire_obj.QuestionnaireClientMapperID = Convert.ToInt32(dt.Rows[i]["QuestionnaireClientMapperID"]);
questionnaire_obj.QuestionnaireName = Convert.ToString(dt.Rows[i]["QuestionnaireName"]);
questionnaire_obj.OverallRating_Yes = dt.Rows[i]["OverallRating_Yes"] == DBNull.Value ? 0 : Convert.ToDecimal(dt.Rows[i]["OverallRating_Yes"]);
questionnaire_obj.BusinessScore_Yes = dt.Rows[i]["BusinessScore_Yes"] == DBNull.Value ? 0 : Convert.ToDecimal(dt.Rows[i]["BusinessScore_Yes"]);
questionnaire_obj.BusinessWeight_Yes = dt.Rows[i]["BusinessWeight_Yes"] == DBNull.Value ? 0 : Convert.ToDecimal(dt.Rows[i]["BusinessWeight_Yes"]);
questionnaire_obj.TechnologyScore_Yes = dt.Rows[i]["TechnologyScore_Yes"] == DBNull.Value ? 0 : Convert.ToDecimal(dt.Rows[i]["TechnologyScore_Yes"]);
questionnaire_obj.TechnologyWeight_Yes = dt.Rows[i]["TechnologyWeight_Yes"] == DBNull.Value ? 0 : Convert.ToDecimal(dt.Rows[i]["TechnologyWeight_Yes"]);
questionnaire_obj.OverallRating_No = dt.Rows[i]["OverallRating_No"] == DBNull.Value ? 0 : Convert.ToDecimal(dt.Rows[i]["OverallRating_No"]);
questionnaire_obj.BusinessScore_No = dt.Rows[i]["BusinessScore_No"] == DBNull.Value ? 0 : Convert.ToDecimal(dt.Rows[i]["BusinessScore_No"]);
questionnaire_obj.BusinessWeight_No = dt.Rows[i]["BusinessWeight_No"] == DBNull.Value ? 0 : Convert.ToDecimal(dt.Rows[i]["BusinessWeight_No"]);
questionnaire_obj.TechnologyScore_No = dt.Rows[i]["TechnologyScore_No"] == DBNull.Value ? 0 : Convert.ToDecimal(dt.Rows[i]["TechnologyScore_No"]);
questionnaire_obj.TechnologyWeight_No = dt.Rows[i]["TechnologyWeight_No"] == DBNull.Value ? 0 : Convert.ToDecimal(dt.Rows[i]["TechnologyWeight_No"]);
questionnaire_obj.Security = Convert.ToBoolean(dt.Rows[i]["Security"]);
questionnaire_obj.Audit = Convert.ToBoolean(dt.Rows[i]["Audit"]);
questionnaire_obj.Compliance = Convert.ToBoolean(dt.Rows[i]["Compliance"]);
questionnaire_obj.Opertional = Convert.ToBoolean(dt.Rows[i]["Opertional"]);
// questionnaire_obj.IsDefault = Convert.ToBoolean(dt.Rows[i]["IsDefault"]);
//questionnaire_obj.Mapped = Convert.ToBoolean(dt.Rows[i]["Mapped"]);
questionnaire_obj.Status = Convert.ToBoolean(dt.Rows[i]["Status"]);
questionnaire_list.Add(questionnaire_obj);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(questionnaire_list);
}
