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