private void Stag_Select() { MemberDataContext mem = new MemberDataContext(); MyMessageBox myMessageBox = new MyMessageBox(); var innerJoinQuery = from Members in mem.Member join Information in mem.MemberGameInformation on Members.MemberName equals Information.MemberName where Information.MemberName == Player.getInstance().getID() select Information; //DB의 유저의 쫄 카드 정보 받아와서 Card객체 만들고 DeckList에 삽입 foreach (var item in innerJoinQuery) { Stage = (int)item.GameStage; Phase = (int)item.GamePhase; } //MessageBox.Show("현재 "+ UserID + " 님의 게임 진행 상황은 Stage " + Stage + " - " + Phase + " 를 진행 중 입니다."); myMessageBox.SetText = "현재 " + UserID + " 님의 게임 진행 상황은 Stage " + Stage + " - " + Phase + " 를 \n진행 중 입니다."; myMessageBox.ShowDialog(); SamGookStageSelect samgookStageSelect = new SamGookStageSelect(); switch (Stage) { case 1: MainMenu.getInstance().frame.Navigate(samgookStageSelect); break; case 2: GoruelStageSelect goruelStageSelect = new GoruelStageSelect(); MainMenu.getInstance().frame.Navigate(goruelStageSelect); break; case 3: ChosenStageSelect chosenStageSelect = new ChosenStageSelect(); MainMenu.getInstance().frame.Navigate(chosenStageSelect); break; case 4: DarkageStageSelect darkageStageSelect = new DarkageStageSelect(); MainMenu.getInstance().frame.Navigate(darkageStageSelect); break; default: MainMenu.getInstance().frame.Navigate(samgookStageSelect); break; } }
private void Stag_Init() { MemberDataContext mem = new MemberDataContext(); var innerJoinQuery = from Members in mem.Member join Information in mem.MemberGameInformation on Members.MemberName equals Information.MemberName where Information.MemberName == Player.getInstance().getID() select Information; //DB의 유저의 쫄 카드 정보 받아와서 Card객체 만들고 DeckList에 삽입 foreach (var item in innerJoinQuery) { Stage = (int)item.GameStage; } MessageBox.Show("저장된 현재 사용자 스테이지 " + Stage); }
void enemyFace() { MemberDataContext memContext = new MemberDataContext(); var query = from memCharacter in memContext.MemberCharacter where memCharacter.MemberName == enemyID select memCharacter; foreach (var item in query) { byte[] byteimg; byteimg = item.CharacterImage.ToArray(); //Console.WriteLine(item.CharacterImage.ToString()); //Console.WriteLine(); MemoryStream ms = new MemoryStream(); ms.Write(byteimg, 0, byteimg.Length); getImage2(System.Drawing.Image.FromStream(ms)); } }
private void start_Click(object sender, RoutedEventArgs e) { MemberDataContext memContext = new MemberDataContext(); Test test = new Test(); MyMessageBox myMessageBox = new MyMessageBox(); //DB의 Mem.MemberCharacter의 Character 필드가 null일때 CreatedCharactor를 호출 var queryMember = from cust in memContext.MemberCharacter where cust.MemberName == UserID select cust; foreach (var item in queryMember) { if (item.CharacterImage == null) { //MessageBox.Show(UserID + "님은 현재 캐릭터가 없습니다."); myMessageBox.SetText = UserID + "님은 현재 캐릭터가 없습니다."; myMessageBox.ShowDialog(); CreatedCharactor mCreate = new CreatedCharactor(mainmenu); mCreate.Show(); //MainMenu main = (MainMenu)this.Parent; //main.Hide(); // 페이지 숨기기 } else { //MessageBox.Show(UserID + "님 게임을 시작 합니다."); myMessageBox.SetText = UserID + "님 게임을 시작 합니다."; //CreatedCharactor mCreate = new CreatedCharactor(mainmenu); //mCreate.Show(); //StageSelect stageSel = new StageSelect(mainmenu); //MainMenu.getInstance().frame.Content = stageSel; myMessageBox.ShowDialog(); if (myMessageBox.DialogResult == true) { Stag_Select(); } } //게임으로 화면 전환하기 } }
public void loadImagebyte() { MemberDataContext memContext = new MemberDataContext(); //System.Drawing.Image returnImage; var query = from memCharacter in memContext.MemberCharacter where memCharacter.MemberName == Player.getInstance().getID().ToString() select memCharacter; foreach (var item in query) { byte[] byteimg; byteimg = item.CharacterImage.ToArray(); Console.WriteLine(item.CharacterImage.ToString()); Console.WriteLine(); MemoryStream ms = new MemoryStream(); ms.Write(byteimg, 0, byteimg.Length); setImage(System.Drawing.Image.FromStream(ms)); } }
private void save_DB() { check = true; byte[] imgByte; //System.Windows.Forms.MessageBox.Show(AppDomain.CurrentDomain.BaseDirectory); System.Drawing.Image img = System.Drawing.Image.FromFile("aa.png"); MemoryStream ms = new MemoryStream(); img.Save(ms, System.Drawing.Imaging.ImageFormat.Png); imgByte = new byte[ms.Length]; imgByte = ms.ToArray(); MemberDataContext memContext = new MemberDataContext(); var query = from memCharacter in memContext.MemberCharacter where memCharacter.MemberName == Player.getInstance().getID().ToString() select memCharacter; foreach (var item in query) { item.CharacterImage = imgByte; Console.WriteLine(item.CharacterImage.ToString()); } try { memContext.SubmitChanges(); } catch (ChangeConflictException) { memContext.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges); } // System.Windows.Forms.MessageBox.Show(e.ToString()); ms.Close(); }
private void db_Insert() { MemberDataContext memContext = new MemberDataContext(); CardDataContext card = new CardDataContext(); Member mem = new Member(); mem.MemberName = txtID.Text; mem.MemberPassword = txtPassword.Text; mem.MemberPassword2 = txtPassword2.Text; memContext.Member.InsertOnSubmit(mem); try { memContext.SubmitChanges(); card.Game_CardDeck(txtID.Text); } catch { MyMessageBox error = new MyMessageBox(); error.SetText = "같은 아이디가 있습니다."; error.ShowDialog(); } }