public void Execute(object parameter)
{
ItemViewPage itemViewPage = parameter as ItemViewPage;
ItemViewModel vm = itemViewPage.Resources["ItemVM"] as ItemViewModel;
AddItemPopup popup = new AddItemPopup();
popup.Resources["ItemVM"] = vm;
vm.IsItemPopup = true;
ItemPopupViewModel popUpVM = popup.Resources["PopUpVM"] as ItemPopupViewModel;
ItemModel model = new ItemModel();
popUpVM.Shop_Name = model.Shop_Name;
popUpVM.Memo = model.Memo;
popUpVM.Name = model.Name;
popUpVM.Link = model.Link;
popUpVM.Item_ID = model.Item_ID;
popUpVM.Price = model.Price;
if (model.Liked == 1)
{
popUpVM.Liked = true;
}
else
{
popUpVM.Liked = false;
}
popUpVM.Temp = model.Temp;
popUpVM.Image = model.Image;
popUpVM.Category = model.Category;
popup.Show();
}
public void Execute(object parameter)
{
MainWindow window = parameter as MainWindow;
MainViewModel MainVM = window.Resources["MainVM"] as MainViewModel;
// 페이지 변경
// 룩북 뷰 <---> 아이템 뷰
if (window.Mainframe.Content.GetType() == typeof(LookBookPage) || window.Mainframe.Content.GetType() == typeof(SearchViewPage))
{
// itemView 처리
ItemViewPage itemView = new ItemViewPage();
ItemViewModel itemVM = itemView.Resources["ItemVM"] as ItemViewModel;
MainVM.itemVM = itemVM;
itemVM.itemViewPage = itemView;
itemVM.setUser(MainVM.user);
itemVM.setItemlist();
string temp_str = (window.Resources["WeatherAPI"] as WeatherAPI).T3H;
int temp = int.Parse(temp_str.Replace("°", ""));
itemVM.Temp = temp;
itemVM.updateWeatherRecommands(temp);
if (itemVM.recommandsList.Count() > 4)
{
for (int i = 0; i < 4; i++)
{
itemVM.recommand_four.Add(itemVM.recommandsList[i]);
itemVM.recommand_four[i].x = i;
}
}
else
{
for (int i = 0; i < itemVM.recommandsList.Count(); i++)
{
itemVM.recommand_four.Add(itemVM.recommandsList[i]);
itemVM.recommand_four[i].x = i;
}
}
itemView.itemListView.ItemsSource = itemVM.items;
itemView.recommandListView.ItemsSource = itemVM.recommand_four;
window.Mainframe.Navigate(itemView);
}
else if (window.Mainframe.Content.GetType() == typeof(ItemViewPage) || window.Mainframe.Content.GetType() == typeof(SearchViewPage))
{
// lookbookView 처리
LookBookPage lookBookView = new LookBookPage();
LookBookViewModel lookBookVM = lookBookView.Resources["lookBookVM"] as LookBookViewModel;
MainVM.lookBookVM = lookBookVM;
lookBookVM.setUser(MainVM.user);
lookBookVM.setLookBookList();
lookBookView.LookBookListView.ItemsSource = lookBookVM.lookBookItems;
window.Mainframe.Navigate(lookBookView);
}
}
public ItemID_ItemPage_Class(object id, object vp)
{
ItemID = (int)id;
_ItemViewPage = vp as ItemViewPage;
}
public ItemID_ItemPage_Class(int id, ItemViewPage vp)
{
ItemID = id;
_ItemViewPage = vp;
}
public void Execute(object parameter)
{
LoginWindow window = parameter as LoginWindow;
try
{
MainWindow mainWindow;
User user;
// ssh 접속
using (var client = new SshClient("106.10.57.242", 5000, "root", "qawzsx351"))
{
client.Connect();
if (client.IsConnected)
{
try
{
// 내부 db 접속을 위한 포트포워딩
var portForwarded = new ForwardedPortLocal("127.0.0.1", 3306, "127.0.0.1", 3306);
client.AddForwardedPort(portForwarded);
portForwarded.Start();
// db 접속
using (MySqlConnection con = new MySqlConnection("SERVER=localhost;PORT=3306;UID=root;PASSWORD=qawzsx351;DATABASE=codibook;SslMode=None"))
{
con.Open();
if (window.ID_BOX.Text.Equals(string.Empty) || window.ID_BOX.Text.Length <= 5)
{
MessageBox.Show("id는 6글자 이상이어야 햡니다.");
return;
}
if (window.Password_BOX.Password.Equals(string.Empty) || window.Password_BOX.Password.Length <= 7)
{
MessageBox.Show("password는 8글자 이상이어야 햡니다.");
return;
}
if (!CheckEnglish(window.ID_BOX.Text))
{
MessageBox.Show("id에는 영어가 포함되어야 합니다.");
return;
}
user = new User(window.ID_BOX.Text, (window.Password_BOX.Password.GetHashCode() & 0x7fffffff).ToString(), "", "");
string query1 = "SELECT COUNT(*) FROM user WHERE ID='" + window.ID_BOX.Text + "' AND PASSWORD='******'";
MySqlCommand sqlCom = new MySqlCommand(query1, con);
if (sqlCom.ExecuteScalar().ToString().Equals("1"))
{
string query2 = "SELECT * FROM user WHERE ID='" + window.ID_BOX.Text + "' AND PASSWORD='******'";
MySqlCommand sqlCom2 = new MySqlCommand(query2, con);
MySqlDataReader reader = sqlCom2.ExecuteReader();
while (reader.Read())
{
user.User_ID = ((int)reader["USER_ID"]).ToString();
user.Time = reader["TIME"] as string;
}
con.Close();
client.Disconnect();
mainWindow = new MainWindow();
MainViewModel MainVM = mainWindow.Resources["MainVM"] as MainViewModel;
MainVM.user = user;
// 뷰페이지 데이터 db에서 받아오기
ItemViewPage itemView = new ItemViewPage();
ItemViewModel vm = itemView.Resources["ItemVM"] as ItemViewModel;
MainVM.itemVM = vm;
vm.itemViewPage = itemView;
vm.setUser(user);
vm.setItemlist();
string temp_str = (mainWindow.Resources["WeatherAPI"] as WeatherAPI).T3H;
int temp = int.Parse(temp_str.Replace("°", ""));
vm.Temp = temp;
vm.updateWeatherRecommands(temp);
if (vm.recommandsList.Count() > 4)
{
for (int i = 0; i < 4; i++)
{
vm.recommand_four.Add(vm.recommandsList[i]);
vm.recommand_four[i].x = i;
}
}
else
{
for (int i = 0; i < vm.recommandsList.Count(); i++)
{
vm.recommand_four.Add(vm.recommandsList[i]);
vm.recommand_four[i].x = i;
}
}
itemView.itemListView.ItemsSource = vm.items;
itemView.recommandListView.ItemsSource = vm.recommand_four;
// 프레임 네비게이션
mainWindow.Mainframe.Navigate(itemView);
mainWindow.Show();
window.Close();
}
else
{
MessageBox.Show("로그인 정보가 잘못되었습니다.");
return;
}
con.Close();
client.Disconnect();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Client cannot be reached...");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void Execute(object parameter)
{
LoginWindow window = parameter as LoginWindow;
try
{
// ssh 접속
using (var client = new SshClient("106.10.57.242", 5000, "root", "qawzsx351"))
{
client.Connect();
if (client.IsConnected)
{
try
{
// 내부 db 접속을 위한 포트포워딩
var portForwarded = new ForwardedPortLocal("127.0.0.1", 3306, "127.0.0.1", 3306);
client.AddForwardedPort(portForwarded);
portForwarded.Start();
// db 접속
using (MySqlConnection con = new MySqlConnection("SERVER=localhost;PORT=3306;UID=root;PASSWORD=qawzsx351;DATABASE=codibook;SslMode=None"))
{
con.Open();
string query1 = "SELECT COUNT(*) FROM user WHERE ID='" + window.ID_BOX.Text + "'";
MySqlCommand sqlCom = new MySqlCommand(query1, con);
object query1_result = sqlCom.ExecuteScalar();
if (int.Parse(query1_result.ToString()) != 0)
{
MessageBox.Show("이미 존재하는 id입니다.");
return;
}
if (window.ID_BOX.Text.Equals(string.Empty) || window.ID_BOX.Text.Length <= 5)
{
MessageBox.Show("id는 6글자 이상이어야 햡니다.");
return;
}
else if (!CheckEnglish(window.ID_BOX.Text))
{
MessageBox.Show("id는 6글자 이상이어야 햡니다.");
return;
}
if (window.Password_BOX.Password.Equals(string.Empty) || window.Password_BOX.Password.Length <= 7)
{
MessageBox.Show("password는 8글자 이상이어야 햡니다.");
return;
}
// 조건에 어긋나지 않으면 새로운 유저 객체를 만들어서 그 값을 서버에 저장한다.
User user = new User(window.ID_BOX.Text, window.Password_BOX.Password);
string query2 = "INSERT INTO user VALUE (" + user.User_ID + ", '" + user.ID + "', '" + user.Password + "', '" + user.Time + "');";
sqlCom = new MySqlCommand(query2, con);
sqlCom.ExecuteNonQuery();
con.Close();
client.Disconnect();
MainWindow mainWindow = new MainWindow();
MainViewModel MainVM = mainWindow.Resources["MainVM"] as MainViewModel;
MainVM.user = user;
// 뷰페이지 데이터 db에서 받아오기
ItemViewPage itemView = new ItemViewPage();
ItemViewModel vm = itemView.Resources["ItemVM"] as ItemViewModel;
MainVM.itemVM = vm;
vm.itemViewPage = itemView;
vm.setUser(user);
vm.setItemlist();
string temp_str = (mainWindow.Resources["WeatherAPI"] as WeatherAPI).T3H;
int temp = int.Parse(temp_str.Replace("°", ""));
vm.Temp = temp;
vm.updateWeatherRecommands(temp);
if (vm.recommandsList.Count() > 4)
{
for (int i = 0; i < 4; i++)
{
vm.recommand_four.Add(vm.recommandsList[i]);
}
}
else
{
for (int i = 0; i < vm.recommandsList.Count(); i++)
{
vm.recommand_four.Add(vm.recommandsList[i]);
}
}
itemView.itemListView.ItemsSource = vm.items;
itemView.recommandListView.ItemsSource = vm.recommand_four;
// 프레임 네비게이션
mainWindow.Mainframe.Navigate(itemView);
mainWindow.Show();
window.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Client cannot be reached...");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
