public static WOInformation GetWOInformationForm(string InfoCode) { var question = new WOInformation(); using (var con = new SqlConnection(ConnectionUtility.GetConnectionString())) { con.Open(); var cmd = new SqlCommand("SpGetWOInfoFormByGridCode", con) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@InfoCode", InfoCode); var reader = cmd.ExecuteReader(); while (reader.Read()) question.FetchData(question, new SafeDataReader(reader)); reader.NextResult(); while (reader.Read()) { var item = new WOInformationForm(); question.FetchItems(item, new SafeDataReader(reader)); question.QItems.Add(item); } } return question; }
private void FetchItems(WOInformationForm item, SafeDataReader reader) { item.ID = reader.GetInt32("Id"); item.FieldName = reader.GetString("FieldName"); item.FieldDisplayName = reader.GetString("FieldDisplayName"); item.InfoCode = reader.GetString("InfoCode"); item.QuestionOptions = reader.GetString("QuestionOptions"); item.FieldType = reader.GetInt32("FieldType"); item.RatingFrom = reader.GetInt32("RatingFrom"); item.RatingTo = reader.GetInt32("RatingTo"); item.IsMandatory = reader.GetInt32("IsMandatory"); item.AnswerType = reader.GetInt32("AnswerType"); item.IncludeOthers = reader.GetInt32("IncludeOthers"); item.IsMultiSelection = reader.GetInt32("IsMultiSelection"); item.DefaultValue = reader.GetString("DefaultValue"); }