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