Ejemplo n.º 1
0
        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();
        }
Ejemplo n.º 2
0
        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();
            }
        }