private void btnEdit_Click(object sender, EventArgs e) { if (gridPhone.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridPhone.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region Phone Casting int phoneID = int.Parse(gridPhone.SelectedRows[0].Cells[1].Value.ToString()); if (!Phone.Validation(phoneID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Phone phone = Phone.Get(phoneID, myConnection); #endregion txtTitle.Text = phone.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 Phone Casting int phoneID = int.Parse(gridPhone.SelectedRows[0].Cells[1].Value.ToString()); if (!Phone.Validation(phoneID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Phone phone = Phone.Get(phoneID, myConnection); #endregion if (myConnection.Phones.Any(a => a.Title == txtTitle.Text.Trim() && a.ID != phoneID)) { DataValidationMesaage.DuplicateData(txtTitle.Text); return; } Phone.Edit(phone, txtTitle.Text.Trim(), myConnection); DataValidationMesaage.EditMessage(); clearTextBox(); txtTitle.Focus(); Phone.LoadGrid(gridPhone, myConnection); FormManagement.DisableYesNo(this.Controls); }
private void btnDelete_Click(object sender, EventArgs e) { if (gridPhone.SelectedRows.Count == 0) { DataValidationMesaage.NoSelectedItemFromList(gridPhone.Text); return; } DataBaseDataContext myConnection = Setting.DataBase; #region Phone Casting int phoneID = int.Parse(gridPhone.SelectedRows[0].Cells[1].Value.ToString()); if (!Phone.Validation(phoneID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Phone phone = Phone.Get(phoneID, myConnection); #endregion if (phone.PhoneNumbers.Any()) { DataValidationMesaage.DataInUse(phone.Title, gridPhone.Text); return; } DialogResult message = DataValidationMesaage.ConfirmDeleteData(phone.Title); if (message == DialogResult.Yes) { Phone.Delete(phone, myConnection); DataValidationMesaage.DeleteMessage(); Phone.LoadGrid(gridPhone, myConnection); } }
private void btnPhoneSave_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (string.IsNullOrWhiteSpace(txtPhoneNumber.Text) || string.IsNullOrEmpty(txtPhoneNumber.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 Phone Casting int phoneId = ((Phone)cmbPhone.SelectedItem).ID; if (!Phone.Validation(phoneId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Phone phone = Phone.Get(phoneId, myConnection); #endregion if (myConnection.PhoneNumbers.Any(a => a.Number == txtPhoneNumber.Text.Trim() && a.Member == member && a.Phone == phone)) { DataValidationMesaage.DuplicateData(txtPhoneNumber.Text.Trim()); return; } var query = myConnection.PhoneNumbers.Where(a => a.Member == member); foreach (var item in query) { item.Status = false; myConnection.SubmitChanges(); } PhoneNumber phoneNumber = PhoneNumber.Insert(phone, member, true, txtPhoneNumber.Text, myConnection); DataValidationMesaage.AcceptMessage(phoneNumber.Number); PhoneNumber.ShowListByMember(lstPhoneNumber, member, myConnection); txtPhoneNumber.Clear(); if (lstPhoneNumber.Items.Count > 1) { btnPhoneDelete.Enabled = true; } myConnection.Dispose(); }
private void btnPhoneDelete_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (lstPhoneNumber.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 Phone Casting int phoneId = ((Phone)cmbPhone.SelectedItem).ID; if (!Phone.Validation(phoneId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Phone phone = Phone.Get(phoneId, myConnection); #endregion #region PhoneNumber Casting PhoneNumber phoneNumber = (PhoneNumber)lstPhoneNumber.SelectedItems[0].Tag; if (!PhoneNumber.Validation(phoneNumber.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } phoneNumber = PhoneNumber.Get(phoneNumber.ID, myConnection); #endregion DialogResult messageResult = DataValidationMesaage.ConfirmDeleteData(lstPhoneNumber.SelectedItems[0].SubItems[1].Text); if (messageResult == DialogResult.Yes) { if (phoneNumber.Status) { #region NextPhoneNumber Casting int nextPhoneNumberIndex = (int.Parse(lstPhoneNumber.SelectedItems[0].Text)) % lstPhoneNumber.Items.Count; PhoneNumber nextPhoneNumber = (PhoneNumber)lstPhoneNumber.Items[nextPhoneNumberIndex].Tag; if (!PhoneNumber.Validation(nextPhoneNumber.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } nextPhoneNumber = PhoneNumber.Get(nextPhoneNumber.ID, myConnection); var query = myConnection.PhoneNumbers.Where(a => a.Member == member); foreach (var item in query) { item.Status = false; myConnection.SubmitChanges(); } #endregion nextPhoneNumber.Status = true; myConnection.SubmitChanges(); } PhoneNumber.Delete(phoneNumber, myConnection); PhoneNumber.ShowListByMember(lstPhoneNumber, FrmMember.MemberProfile, myConnection); if (lstPhoneNumber.Items.Count == 1) { btnPhoneDelete.Enabled = false; } } txtPhoneNumber.Clear(); myConnection.Dispose(); }
private void btnPhoneEdit_Click(object sender, EventArgs e) { DataBaseDataContext myConnection = Setting.DataBase; if (lstPhoneNumber.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 Phone Casting int phoneId = ((Phone)cmbPhone.SelectedItem).ID; if (!Phone.Validation(phoneId, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } Phone phone = Phone.Get(phoneId, myConnection); #endregion #region PhoneNumber Casting PhoneNumber phoneNumber = (PhoneNumber)lstPhoneNumber.SelectedItems[0].Tag; if (!PhoneNumber.Validation(phoneNumber.ID, myConnection)) { DataValidationMesaage.NoDataInBank(); return; } phoneNumber = PhoneNumber.Get(phoneNumber.ID, myConnection); #endregion DialogResult message = MessageBox.Show("در صورت تایید شماره تماس فعلی فعال گردیده و مابقی غیرفعال میگردند", "کاربر گرامی", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (message == DialogResult.Yes) { if (lstPhoneNumber.SelectedItems.Count == 0) { DataValidationMesaage.NoSelectedItemFromList("لیست شماره های تماس"); return; } var query = myConnection.PhoneNumbers.Where(a => a.Member == member); foreach (var item in query) { item.Status = false; myConnection.SubmitChanges(); } PhoneNumber.Edit(phoneNumber, phone, member, true, txtPhoneNumber.Text, myConnection); txtPhoneNumber.Clear(); PhoneNumber.ShowListByMember(lstPhoneNumber, member, myConnection); } 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(); }