private void btnEdit_Click(object sender, EventArgs e)
        {
            if (gridSocialNetworkType.SelectedRows.Count == 0)
            {
                DataValidationMesaage.NoSelectedItemFromList(gridSocialNetworkType.Text);

                return;
            }

            DataBaseDataContext myConnection = Setting.DataBase;

            #region SocialNetworkType Casting

            int socialNetworkTypeID = int.Parse(gridSocialNetworkType.SelectedRows[0].Cells[1].Value.ToString());

            if (!SocialNetworkType.Validation(socialNetworkTypeID, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeID, myConnection);

            #endregion

            txtTitle.Text = socialNetworkType.Title;

            FormManagement.EnableYesNo(this.Controls);

            txtTitle.Focus();
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            DataBaseDataContext myConnection = Setting.DataBase;

            if (string.IsNullOrEmpty(txtTitle.Text) || string.IsNullOrWhiteSpace(txtTitle.Text))
            {
                DataValidationMesaage.BlankTextBox("عنوان");

                return;
            }
            if (myConnection.SocialNetworkTypes.Any(a => a.Title == txtTitle.Text.Trim()))
            {
                DataValidationMesaage.DuplicateData(txtTitle.Text);

                return;
            }

            SocialNetworkType socialNetworkType = SocialNetworkType.Insert(txtTitle.Text.Trim(), myConnection);

            clearTextBox();

            DataValidationMesaage.AcceptMessage(socialNetworkType.Title);

            SocialNetworkType.LoadGrid(gridSocialNetworkType, myConnection);
        }
        public static void LoadGridBySocialNetworkType(RadGridView grid, SocialNetworkType socialNetworkType,
                                                       DataBaseDataContext connection)
        {
            var myQuery = connection.SocialNetworkAccounts.Where(a => a.SocialNetworkType == socialNetworkType)
                          .Select(a => new
            {
                id      = a.ID,
                status  = a.Status,
                account = a.Account
            });

            grid.DataSource = myQuery;

            grid.Columns[1].IsVisible = false;

            grid.Columns[2].HeaderText = "وضعیت";

            grid.Columns[2].Width = 300;

            grid.Columns[3].HeaderText = "نام کاربری";

            grid.Columns[3].Width = 100;

            for (int i = 0; i < grid.RowCount; i++)
            {
                grid.Rows[i].Cells[0].Value = i + 1;
            }
        }
예제 #4
0
        public static SocialNetworkType Insert(string title, DataBaseDataContext connection)
        {
            SocialNetworkType socialNetworkType = new SocialNetworkType(title);

            connection.SocialNetworkTypes.InsertOnSubmit(socialNetworkType);

            connection.SubmitChanges();

            return(socialNetworkType);
        }
예제 #5
0
        private void btnSocialAccountTypeGet_Click(object sender, EventArgs e)
        {
            FrmSocialNetworkType frm = new FrmSocialNetworkType();

            frm.ShowDialog();

            SocialNetworkType.LoadComboBox(cmbSocialNetworkType, Setting.DataBase);

            Setting.DataBase.Dispose();
        }
        public static void Edit(SocialNetworkAccount socialNetworkAccount, SocialNetworkType socialNetworkType, Member member,
                                bool status, string account, DataBaseDataContext connection)
        {
            socialNetworkAccount.Status = status;

            socialNetworkAccount.Account = account;

            socialNetworkAccount.SocialNetworkType = socialNetworkType;

            socialNetworkAccount.Member = member;

            connection.SubmitChanges();
        }
        public static SocialNetworkAccount Insert(SocialNetworkType socialNetworkType, Member member,
                                                  bool status, string account, DataBaseDataContext connection)
        {
            SocialNetworkAccount socialNetworkAccount = new SocialNetworkAccount(status, account);

            socialNetworkAccount.SocialNetworkType = socialNetworkType;

            socialNetworkAccount.Member = member;

            connection.SocialNetworkAccounts.InsertOnSubmit(socialNetworkAccount);

            connection.SubmitChanges();

            return(socialNetworkAccount);
        }
        private void btnYes_Click(object sender, EventArgs e)
        {
            DataBaseDataContext myConnection = Setting.DataBase;

            if (string.IsNullOrEmpty(txtTitle.Text) || string.IsNullOrWhiteSpace(txtTitle.Text))
            {
                DataValidationMesaage.BlankTextBox("عنوان");

                return;
            }

            #region SocialNetworkType Casting

            int socialNetworkTypeID = int.Parse(gridSocialNetworkType.SelectedRows[0].Cells[1].Value.ToString());

            if (!SocialNetworkType.Validation(socialNetworkTypeID, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeID, myConnection);

            #endregion

            if (myConnection.SocialNetworkTypes.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != socialNetworkType.ID))
            {
                DataValidationMesaage.DuplicateData(txtTitle.Text);

                return;
            }

            SocialNetworkType.Edit(socialNetworkType, txtTitle.Text.Trim(), myConnection);

            DataValidationMesaage.EditMessage();

            clearTextBox();

            txtTitle.Focus();

            SocialNetworkType.LoadGrid(gridSocialNetworkType, myConnection);

            FormManagement.DisableYesNo(this.Controls);
        }
예제 #9
0
        private void FrmProfile_Load(object sender, EventArgs e)
        {
            DataBaseDataContext myConnection = Setting.DataBase;

            Phone.LoadComboBox(cmbPhone, myConnection);

            PhoneNumber.ShowListByMember(lstPhoneNumber, FrmMember.MemberProfile, myConnection);

            SocialNetworkType.LoadComboBox(cmbSocialAccount, myConnection);

            SocialNetworkAccount.ShowListByMember(lstSocialNetwork, FrmMember.MemberProfile, myConnection);

            lblCode.Text = FrmMember.MemberProfile.Code;

            lblFirstName.Text = FrmMember.MemberProfile.FirstName;

            lblLastName.Text = FrmMember.MemberProfile.LastName;

            lblBirthDate.Text = BTM.Date.ConvertToPersianDate(FrmMember.MemberProfile.BirthDate);

            lblNationalCode.Text = FrmMember.MemberProfile.NationalCode;

            byte[] myBytes = FrmMember.MemberProfile.Image;

            if (myBytes != null)
            {
                _memoryStream = new MemoryStream(myBytes);

                PicBox.Image = Image.FromStream(_memoryStream);
            }

            if (lstPhoneNumber.Items.Count == 1)
            {
                btnPhoneDelete.Enabled = false;
            }

            if (lstSocialNetwork.Items.Count == 1)
            {
                btnSocialAccountDelete.Enabled = false;
            }

            myConnection.Dispose();
        }
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (gridSocialNetworkType.SelectedRows.Count == 0)
            {
                DataValidationMesaage.NoSelectedItemFromList(gridSocialNetworkType.Text);

                return;
            }

            DataBaseDataContext myConnection = Setting.DataBase;

            #region SocialNetworkType Casting

            int socialNetworkTypeID = int.Parse(gridSocialNetworkType.SelectedRows[0].Cells[1].Value.ToString());

            if (!SocialNetworkType.Validation(socialNetworkTypeID, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeID, myConnection);

            #endregion

            if (socialNetworkType.SocialNetworkAccounts.Any())
            {
                DataValidationMesaage.DataInUse(socialNetworkType.Title, gridSocialNetworkType.Text);

                return;
            }
            DialogResult message = DataValidationMesaage.ConfirmDeleteData(socialNetworkType.Title);

            if (message == DialogResult.Yes)
            {
                SocialNetworkType.Delete(socialNetworkType, myConnection);

                DataValidationMesaage.DeleteMessage();

                SocialNetworkType.LoadGrid(gridSocialNetworkType, myConnection);
            }
        }
예제 #11
0
        private void FrmMember_Load(object sender, EventArgs e)
        {
            DataBaseDataContext myConnection = Setting.DataBase;

            Level.LoadComboBox(cmbLevel, myConnection);

            Phone.LoadComboBox(cmbPhone, myConnection);

            SocialNetworkType.LoadComboBox(cmbSocialNetworkType, myConnection);

            cmbType.SelectedIndex = 0;

            cmbSex.SelectedIndex = 0;

            GetCode();

            Member.LoadGridJoinSocialNetworkAccountJoinPhoneNumber(gridMember, myConnection);

            myConnection.Dispose();
        }
        public static void LoadComboBoxBySocialNetworkType(ComboBox cmbBox, SocialNetworkType socialNetworkType,
                                                           DataBaseDataContext connection)
        {
            IQueryable <SocialNetworkAccount> myQuery = connection.SocialNetworkAccounts.
                                                        Where(a => a.SocialNetworkType == socialNetworkType);

            cmbBox.Items.Clear();

            foreach (var item in myQuery)
            {
                cmbBox.Items.Add(item);
            }

            if (!myQuery.Any())
            {
                cmbBox.Items.Add("یک آیتم به ثبت برسانید");

                cmbBox.SelectedIndex = 0;

                return;
            }

            cmbBox.SelectedIndex = 0;
        }
예제 #13
0
        public static void Edit(SocialNetworkType socialNetworkType, string title, DataBaseDataContext connection)
        {
            socialNetworkType.Title = title;

            connection.SubmitChanges();
        }
예제 #14
0
        private void btnSocialAccountSave_Click(object sender, EventArgs e)
        {
            DataBaseDataContext myConnection = Setting.DataBase;

            if (string.IsNullOrWhiteSpace(txtSocialAccount.Text) || string.IsNullOrEmpty(txtSocialAccount.Text))
            {
                DataValidationMesaage.BlankTextBox("اکانت شبکه های اجتماعی");

                return;
            }

            #region Member Casting

            int memberId = FrmMember.MemberProfile.ID;

            if (!Member.Validation(memberId, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            Member member = Member.Get(memberId, myConnection);

            #endregion

            #region SocialNetworkType Casting

            int socialNetworkTypeId = ((SocialNetworkType)cmbSocialAccount.SelectedItem).ID;

            if (!SocialNetworkType.Validation(socialNetworkTypeId, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeId, myConnection);

            #endregion

            if (myConnection.SocialNetworkAccounts.Any(
                    a => a.Account == txtSocialAccount.Text.Trim() && a.Member == member &&
                    a.SocialNetworkType == socialNetworkType))
            {
                DataValidationMesaage.DuplicateData(txtSocialAccount.Text.Trim());

                return;
            }

            var query = myConnection.SocialNetworkAccounts.Where(a => a.Member == member);

            foreach (var item in query)
            {
                item.Status = false;

                myConnection.SubmitChanges();
            }



            SocialNetworkAccount socialNetworkAccount = SocialNetworkAccount.Insert(socialNetworkType, member, true, txtSocialAccount.Text.Trim(), myConnection);

            DataValidationMesaage.AcceptMessage(socialNetworkAccount.Account);

            SocialNetworkAccount.ShowListByMember(lstSocialNetwork, member, myConnection);

            txtSocialAccount.Clear();

            if (lstSocialNetwork.Items.Count > 1)
            {
                btnSocialAccountDelete.Enabled = true;
            }

            myConnection.Dispose();
        }
예제 #15
0
        public static void Delete(SocialNetworkType socialNetworkType, DataBaseDataContext connection)
        {
            connection.SocialNetworkTypes.DeleteOnSubmit(socialNetworkType);

            connection.SubmitChanges();
        }
예제 #16
0
        static void Main()
        {
            DataBaseDataContext myConnection = Setting.DataBase;

            if (!myConnection.DatabaseExists())
            {
                myConnection.CreateDatabase();

                #region Insert RaspberryPins

                for (int i = 1; i <= 24; i++)
                {
                    RaspberryPin.Insert(i.ToString(), true, myConnection);
                }

                #endregion

                #region Insert SocialNetworkTypes

                SocialNetworkType.Insert("اینستاگرام", myConnection);
                SocialNetworkType.Insert("تلگرام", myConnection);
                SocialNetworkType.Insert("وایبر", myConnection);
                SocialNetworkType.Insert("وی چت", myConnection);
                SocialNetworkType.Insert("توییتر", myConnection);
                SocialNetworkType.Insert("لینکداین", myConnection);
                SocialNetworkType.Insert("فیسبوک", myConnection);

                #endregion

                #region Insert PhoneOperators

                Phone.Insert("ایرانسل", myConnection);
                Phone.Insert("همراه اول", myConnection);
                Phone.Insert("رایتل", myConnection);
                Phone.Insert("تالیا", myConnection);
                Phone.Insert("تلفن ثابت", myConnection);

                #endregion

                #region Insert Levels

                Level.Insert("طلایی", myConnection);
                Level.Insert("نقره ای", myConnection);
                Level.Insert("برنزی", myConnection);
                Level.Insert("VIP", myConnection);

                #endregion

                #region BankAccounts

                BankAccount.Insert("کشاورزی", "", "", myConnection);
                BankAccount.Insert("ملی", "", "", myConnection);
                BankAccount.Insert("ملت", "", "", myConnection);


                #endregion
            }
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);
            Application.Run(new FrmMain());
        }
예제 #17
0
        private void btnYes_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(txtFirstName.Text) || string.IsNullOrEmpty(txtLastName.Text) ||
                string.IsNullOrEmpty(txtNationalCode.Text) ||
                string.IsNullOrWhiteSpace(txtFirstName.Text) || string.IsNullOrWhiteSpace(txtLastName.Text) ||
                string.IsNullOrWhiteSpace(txtNationalCode.Text))
            {
                MessageBox.Show("کاربر گرامی مقادیر نام یا نام خانوادگی یا کد ملی نمی توانند خالی باشند ", "اخطار در ورود اطلاعات", MessageBoxButtons.OK,
                                MessageBoxIcon.Error);

                return;
            }

            DataBaseDataContext myConnection = Setting.DataBase;

            #region Level Casting

            int levelId = ((Level)cmbLevel.SelectedItem).ID;

            if (!Level.Validation(levelId, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            Level level = Level.Get(levelId, myConnection);

            #endregion

            #region Member Casting

            int memeberId = int.Parse(gridMember.SelectedRows[0].Cells[1].Value.ToString());

            if (!Member.Validation(memeberId, myConnection))

            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            Member member = Member.Get(memeberId, myConnection);

            #endregion

            #region PhoneNumber Casting

            string gridPhoneNumber = gridMember.SelectedRows[0].Cells[9].Value.ToString();

            PhoneNumber phoneNumber =
                myConnection.PhoneNumbers.FirstOrDefault(a => a.Number == gridPhoneNumber && a.Member == member);

            if (phoneNumber != null && !PhoneNumber.Validation(phoneNumber.ID, myConnection))

            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            #endregion

            #region SocialNetworkAccount Casting

            string gridSocialAccount = gridMember.SelectedRows[0].Cells[8].Value.ToString();

            SocialNetworkAccount socialNetworkAccount =
                myConnection.SocialNetworkAccounts.FirstOrDefault(
                    a => a.Account == gridSocialAccount && a.Member == member);

            if (socialNetworkAccount != null && !SocialNetworkAccount.Validation(socialNetworkAccount.ID, myConnection))

            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            #endregion

            #region Phone Casting

            int phoneId = ((Phone)cmbPhone.SelectedItem).ID;

            if (!Phone.Validation(phoneId, myConnection))
            {
                //TODO Fix Message

                DataValidationMesaage.NoDataInBank();

                return;
            }

            Phone phone = Phone.Get(phoneId, myConnection);

            #endregion

            #region SocialNetwork Casting

            int socialNetworkTypeID = ((SocialNetworkType)cmbSocialNetworkType.SelectedItem).ID;

            if (!Phone.Validation(socialNetworkTypeID, myConnection))
            {
                //TODO Fix Message

                DataValidationMesaage.NoDataInBank();

                return;
            }

            SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeID, myConnection);

            #endregion

            bool query = myConnection.PhoneNumbers.Any(a => a.Number == CorrectPhoneNumber() &&
                                                       a.Member == member && a.ID != phoneNumber.ID);
            if (query)
            {
                DataValidationMesaage.DuplicateData("شماره تماس برای این کاربر");

                return;
            }

            query =
                myConnection.SocialNetworkAccounts.Any(
                    a =>
                    a.Account == txtSocialAccount.Text.Trim() && a.Member == member &&
                    a.ID != socialNetworkAccount.ID);

            if (query)
            {
                DataValidationMesaage.DuplicateData("اکانت شبکه های اجتماعی برای این کاربر");

                return;
            }

            query = myConnection.Members.Any(a => a.NationalCode == txtNationalCode.Text.Trim() && a.ID != memeberId);

            if (query)
            {
                DataValidationMesaage.DuplicateData("کاربر با این کد ملی");

                return;
            }

            if (!flag)
            {
                Image picImage = Properties.Resources.profile;

                picBox.Image = picImage;

                picImage.Save(_memory, picBox.Image.RawFormat);

                _myArray = _memory.GetBuffer();
            }

            if (flag)
            {
                _image.Save(_memory, picBox.Image.RawFormat);

                _myArray = _memory.GetBuffer();
            }


            Phone.Edit(phone, cmbPhone.Text.Trim(), myConnection);

            PhoneNumber.Edit(phoneNumber, phone, member, true, CorrectPhoneNumber(), myConnection);

            SocialNetworkType.Edit(socialNetworkType, cmbSocialNetworkType.Text.Trim(), myConnection);

            SocialNetworkAccount.Edit(socialNetworkAccount, socialNetworkType, member, true, txtSocialAccount.Text.Trim(), myConnection);

            //TODO How to check Has Cabinet or not?

            Member.Edit(member, txtCode.Text.Trim(), txtFirstName.Text.Trim(), txtLastName.Text.Trim(),
                        txtNationalCode.Text.Trim(), BTM.Date.ConvertToGorgianDate(txtBirthDate.Text.Trim()),
                        cmbType.Text.Trim(), cmbSex.Text.Trim(), _myArray, level, myConnection);

            DataValidationMesaage.EditMessage();

            ClearTextBox();

            txtFirstName.Focus();

            Member.LoadGridJoinSocialNetworkAccountJoinPhoneNumber(gridMember, myConnection);

            FormManagement.DisableYesNo(this.Controls);
        }
 private void FrmSocialNetworkType_Load(object sender, EventArgs e)
 {
     SocialNetworkType.LoadGrid(gridSocialNetworkType, Setting.DataBase);
 }
예제 #19
0
        private void btnSocialAccountDelete_Click(object sender, EventArgs e)
        {
            DataBaseDataContext myConnection = Setting.DataBase;

            if (lstSocialNetwork.SelectedItems.Count == 0)
            {
                DataValidationMesaage.NoSelectedItemFromList("لیست اکانت های شبکه های اجتماعی");

                return;
            }

            #region Member Casting

            int memberId = FrmMember.MemberProfile.ID;

            if (!Member.Validation(memberId, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            Member member = Member.Get(memberId, myConnection);

            #endregion

            #region SocialNetworkType Casting

            int socialNetworkTypeId = ((SocialNetworkType)cmbSocialAccount.SelectedItem).ID;

            if (!SocialNetworkType.Validation(socialNetworkTypeId, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeId, myConnection);

            #endregion

            #region SocialNetworkAccount Casting

            SocialNetworkAccount socialNetworkAccount = (SocialNetworkAccount)lstSocialNetwork.SelectedItems[0].Tag;

            if (!SocialNetworkAccount.Validation(socialNetworkAccount.ID, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }
            socialNetworkAccount = SocialNetworkAccount.Get(socialNetworkAccount.ID, myConnection);

            #endregion

            DialogResult messageResult =
                DataValidationMesaage.ConfirmDeleteData(lstSocialNetwork.SelectedItems[0].SubItems[1].Text);

            if (messageResult == DialogResult.Yes)
            {
                if (socialNetworkAccount.Status)
                {
                    #region NextSocialNetworkAccount Casting

                    int nextSocialNetworkAccountIndex = (int.Parse(lstSocialNetwork.SelectedItems[0].Text)) %
                                                        lstSocialNetwork.Items.Count;

                    SocialNetworkAccount nextSocialNetworkAccount =
                        (SocialNetworkAccount)lstSocialNetwork.Items[nextSocialNetworkAccountIndex].Tag;

                    if (!SocialNetworkAccount.Validation(nextSocialNetworkAccount.ID, myConnection))
                    {
                        DataValidationMesaage.NoDataInBank();

                        return;
                    }
                    nextSocialNetworkAccount = SocialNetworkAccount.Get(nextSocialNetworkAccount.ID, myConnection);

                    var query = myConnection.SocialNetworkAccounts.Where(a => a.Member == member);

                    foreach (var item in query)
                    {
                        item.Status = false;

                        myConnection.SubmitChanges();
                    }

                    #endregion

                    nextSocialNetworkAccount.Status = true;

                    myConnection.SubmitChanges();
                }
                SocialNetworkAccount.Delete(socialNetworkAccount, myConnection);

                SocialNetworkAccount.ShowListByMember(lstSocialNetwork, FrmMember.MemberProfile, myConnection);

                if (lstSocialNetwork.Items.Count == 1)
                {
                    btnPhoneDelete.Enabled = false;
                }
            }

            txtSocialAccount.Clear();

            myConnection.Dispose();
        }
예제 #20
0
        private void btnSocialAccountEdit_Click(object sender, EventArgs e)
        {
            DataBaseDataContext myConnection = Setting.DataBase;

            if (lstSocialNetwork.SelectedItems.Count == 0)
            {
                DataValidationMesaage.NoSelectedItemFromList("لیست اکانت های شبکه های اجتماعی");

                return;
            }

            #region Member Casting

            int memberId = FrmMember.MemberProfile.ID;

            if (!Member.Validation(memberId, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            Member member = Member.Get(memberId, myConnection);

            #endregion

            #region SocialNetworkType Casting

            int socialNetworkTypeId = ((SocialNetworkType)cmbSocialAccount.SelectedItem).ID;

            if (!SocialNetworkType.Validation(socialNetworkTypeId, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeId, myConnection);

            #endregion

            #region SocialNetworkAccount Casting

            SocialNetworkAccount socialNetworkAccount = (SocialNetworkAccount)lstSocialNetwork.SelectedItems[0].Tag;

            if (!SocialNetworkAccount.Validation(socialNetworkAccount.ID, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }
            socialNetworkAccount = SocialNetworkAccount.Get(socialNetworkAccount.ID, myConnection);

            #endregion

            DialogResult message = MessageBox.Show("در صورت تایید اکانت فعلی فعال گردیده و مابقی غیرفعال میگردند",
                                                   "کاربر گرامی", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (message == DialogResult.Yes)
            {
                if (lstSocialNetwork.SelectedItems.Count == 0)
                {
                    DataValidationMesaage.NoSelectedItemFromList("لیست اکانت های شبکه های اجتماعی");

                    return;
                }


                var query = myConnection.SocialNetworkAccounts.Where(a => a.Member == member);

                foreach (var item in query)
                {
                    item.Status = false;

                    myConnection.SubmitChanges();
                }

                SocialNetworkAccount.Edit(socialNetworkAccount, socialNetworkType, member, true, txtSocialAccount.Text.Trim(), myConnection);

                txtSocialAccount.Clear();

                SocialNetworkAccount.ShowListByMember(lstSocialNetwork, member, myConnection);
            }

            myConnection.Dispose();
        }
예제 #21
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            DataBaseDataContext myConnection = Setting.DataBase;

            #region Level Casting

            int levelId = ((Level)cmbLevel.SelectedItem).ID;

            if (!Level.Validation(levelId, myConnection))
            {
                DataValidationMesaage.NoDataInBank();

                return;
            }

            Level level = Level.Get(levelId, myConnection);

            #endregion

            #region Phone Casting

            int phoneId = ((Phone)cmbPhone.SelectedItem).ID;

            if (!Phone.Validation(phoneId, myConnection))
            {
                //TODO Fix Message

                DataValidationMesaage.NoDataInBank();

                return;
            }

            Phone phone = Phone.Get(phoneId, myConnection);

            #endregion



            #region Save Image

            if (!flag)
            {
                Image picImage = Properties.Resources.profile;

                picBox.Image = picImage;

                picImage.Save(_memoryStream, picBox.Image.RawFormat);

                _myArray = _memoryStream.GetBuffer();
            }

            if (flag)
            {
                _image.Save(_memoryStream, picBox.Image.RawFormat);

                _myArray = _memoryStream.GetBuffer();
            }

            #endregion

            if (myConnection.Members.Any(a => a.Code == txtCode.Text))
            {
                DataValidationMesaage.DuplicateData(txtCode.Text);

                return;
            }

            if (myConnection.Members.Any(a => a.NationalCode == txtNationalCode.Text))
            {
                DataValidationMesaage.DuplicateData(txtNationalCode.Text);

                return;
            }

            if (string.IsNullOrEmpty(txtNationalCode.Text.Trim()) || string.IsNullOrWhiteSpace(txtNationalCode.Text.Trim()))
            {
                DataValidationMesaage.BlankTextBox("کد ملی");

                return;
            }

            if (!BTM.Date.Validation(txtBirthDate.Text))
            {
                MessageBox.Show("قالب تاریخ تولد وارد شده صحیح نمی باشد", "اخطار در ورود اطلاعات", MessageBoxButtons.OK,
                                MessageBoxIcon.Error);

                return;
            }


            Member member = Member.Insert(txtCode.Text.Trim(), txtFirstName.Text.Trim(), txtLastName.Text.Trim(),
                                          txtNationalCode.Text.Trim(),
                                          BTM.Date.ConvertToGorgianDate(txtBirthDate.Text.Trim()), cmbType.Text.Trim(), cmbSex.Text.Trim(),
                                          _myArray, false, level, myConnection);

            PhoneNumber.Insert(phone, member, true, CorrectPhoneNumber(), myConnection);


            if (txtSocialAccount.Text.Length > 0)
            {
                #region SocialNetwork Casting

                int socialNetworkTypeID = ((SocialNetworkType)cmbSocialNetworkType.SelectedItem).ID;

                if (!Phone.Validation(socialNetworkTypeID, myConnection))
                {
                    //TODO Fix Message

                    DataValidationMesaage.NoDataInBank();

                    return;
                }

                SocialNetworkType socialNetworkType = SocialNetworkType.Get(socialNetworkTypeID, myConnection);

                #endregion

                SocialNetworkAccount.Insert(socialNetworkType, member, true, txtSocialAccount.Text.Trim(), myConnection);
            }
            GetCode();

            Member.LoadGridJoinSocialNetworkAccountJoinPhoneNumber(gridMember, myConnection);

            ClearTextBox();

            myConnection.Dispose();
        }