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 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); }
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); } }
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(); }
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(); }
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(); }
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 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(); }