// Application.Current.MainWindow = this;
public CreateSurvey(string id, string name, string Descript)
{
InitializeComponent();
Application.Current.MainWindow = this;
myViewModel = new BindingList <SurveyViewModel>();
DG1.ItemsSource = myViewModel;
s_id = id;
s_name = name;
s_descrip = Descript;
ManageSql Sql = new ManageSql();
Data = Sql.selectSurvey(s_id);
Console.WriteLine("---------테스트");
Console.WriteLine(Data);
if (!string.IsNullOrEmpty(Data))
{
State = 1;
LoadSurvey(Data);
}
//ConnectWeb();
//CreateTableColumn();
}
//***********************************************
//저장 버튼 클릭 화면에 입력된 데이터 JSON 변경
//***********************************************
private void SaveButton_Click(object sender, RoutedEventArgs e)
{
var FormData = new JObject();
var Title = new JObject();
Title.Add("Title", s_name);
Title.Add("Descrip", s_descrip);
var Item = new JArray();
for (int i = 0; i < myViewModel.Count; i++)
{
var SurveySubject = new JObject();
SurveySubject.Add("Title", myViewModel[i].SurveyTitle);
SurveySubject.Add("Descrip", myViewModel[i].SurveyDescrip);
SurveySubject.Add("Option", myViewModel[i].OptionNumber);
SurveySubject.Add("OptionName", myViewModel[i].SurveyOption);
if (myViewModel[i].SurveyOption != "단답형" && myViewModel[i].SurveyOption != "장문형")
{
var SurveyRow = new JArray();
var SurveyColumn = new JArray();
var SurveyItem = new JArray();
var SurveyItemRowAndColumn = new JObject();
for (int j = 0; j < myViewModel[i].SurveyItem.Count; j++)
{
if (myViewModel[i].SurveyOption == "객관식1" || myViewModel[i].SurveyOption == "객관식2")
{
SurveyItem.Add(myViewModel[i].SurveyItem[j].SurveyItem);
}
else if (myViewModel[i].SurveyOption == "그리드")
{
if (!string.IsNullOrEmpty(myViewModel[i].SurveyItem[j].SurveyRow))
{
SurveyRow.Add(myViewModel[i].SurveyItem[j].SurveyRow);
}
if (!string.IsNullOrEmpty(myViewModel[i].SurveyItem[j].SurveyColumn))
{
SurveyColumn.Add(myViewModel[i].SurveyItem[j].SurveyColumn);
}
}
}
SurveyItemRowAndColumn.Add("Row", SurveyRow);
SurveyItemRowAndColumn.Add("Column", SurveyColumn);
if (myViewModel[i].SurveyOption == "그리드")
{
SurveySubject.Add("item", SurveyItemRowAndColumn);
}
else
{
SurveySubject.Add("item", SurveyItem);
}
}
Item.Add(SurveySubject);
}
FormData.Add("Title", Title);
FormData.Add("item", Item);
string str_json = JsonConvert.SerializeObject(FormData);
string Url = "&Collection=" + str_json;
Console.WriteLine(str_json);
ConnectWeb(Url);
ManageSql Sql = new ManageSql();
//Console.WriteLine(s_id);
//저장
if (State == 0)
{
Sql.insertSurvey(str_json, s_id);
State = 1;
return;
}
//업데이트
if (State == 1)
{
Sql.updateSurvey(str_json, s_id);
}
}
