private void CreateCountryStatesButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.Country country = databaseContext.Countries .FirstOrDefault(); // Solution (1) Models.State state1 = new Models.State(); state1.Name = "State (1)"; state1.CountryId = country.Id; databaseContext.States.Add(state1); // /Solution (1) // Solution (2) Models.State state2 = new Models.State(); state2.Name = "State (2)"; state2.Country = country; databaseContext.States.Add(state2); // /Solution (2) // Solution (3) Models.State state3 = new Models.State(); state3.Name = "State (3)"; country.States.Add(state3); // /Solution (3) databaseContext.SaveChanges(); System.Guid id1 = state1.CountryId; System.Guid id2 = state2.CountryId; System.Guid id3 = state3.CountryId; } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } finally { if (databaseContext != null) { databaseContext.Dispose(); //databaseContext = null; } } }
private void DeleteUserButton_Click(object sender, System.EventArgs e) { if (usersListBox.SelectedItems.Count == 0) { System.Windows.Forms.MessageBox.Show("You did not select any users for deleting!"); return; } Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); foreach (var selectedItem in usersListBox.SelectedItems) { Models.User selectedUser = selectedItem as Models.User; if (selectedUser != null) { Models.User foundedUser = databaseContext.Users .Where(current => current.Id == selectedUser.Id) .FirstOrDefault(); if (foundedUser != null) { if (foundedUser.IsAdmin == false) { if (string.Compare(foundedUser.Username, Infrastructure.Utility.AuthenticatedUser.Username, ignoreCase: true) != 0) { databaseContext.Users.Remove(foundedUser); databaseContext.SaveChanges(); } } } } } Search(); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void CreateButton_Click(object sender, System.EventArgs e) { if (string.IsNullOrWhiteSpace(titleTextBox.Text)) { System.Windows.Forms.MessageBox.Show("Title is required!"); return; } if (string.IsNullOrWhiteSpace(authorTextBox.Text)) { System.Windows.Forms.MessageBox.Show("Author is required!"); return; } if (string.IsNullOrWhiteSpace(publishYearTextBox.Text)) { System.Windows.Forms.MessageBox.Show("Publish year is required!"); return; } Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.Resource resource = new Models.Resource { Title = titleTextBox.Text, Author = authorTextBox.Text, Translator = translatorTextBox.Text, Description = descriptionTextBox.Text, Type = (Models.Enums.ResourceType)typeComboBox.SelectedValue, PublishYear = System.Convert.ToInt32(publishYearTextBox.Text), }; databaseContext.Resources.Add(resource); databaseContext.SaveChanges(); System.Windows.Forms.MessageBox .Show("Resource created successfully..."); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show($"Error: { ex.Message }"); } finally { if (databaseContext != null) { databaseContext.Dispose(); //databaseContext = null; } } }
private void SaveButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.User user = databaseContext.Users .Where(current => current.Id == SelectedUser.Id) .FirstOrDefault(); if (user == null) { System.Windows.Forms.MessageBox.Show("Please contact Support team", caption: "Error", buttons: System.Windows.Forms.MessageBoxButtons.OK, icon: System.Windows.Forms.MessageBoxIcon.Error ); System.Windows.Forms.Application.Exit(); } user.IsAdmin = isAdminCheckBox.Checked; user.IsActive = isActiveCheckBox.Checked; user.FullName = fullNameTextBox.Text; user.Description = descriptionTextBox.Text; databaseContext.SaveChanges(); System.Windows.Forms.MessageBox.Show("user Profile updated successfully!", caption: "", buttons: System.Windows.Forms.MessageBoxButtons.OK, icon: System.Windows.Forms.MessageBoxIcon.Asterisk ); Infrastructure.Utility.AuthenticatedUser = databaseContext.Users .Where(current => string.Compare(current.Username, Infrastructure.Utility.AuthenticatedUser.Username, true) == 0) .FirstOrDefault(); Infrastructure.Utility.MainForm.ResetForm(); Close(); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.ToString()); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void btnDelete_Click(object sender, System.EventArgs e) { int b = int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()); db = dt.Tasks.FirstOrDefault(i => i.Id == b); dt.Tasks.Remove(db); dt.SaveChanges(); dataGridView1.DataSource = dt.Tasks.ToList(); }
private void SaveButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); var currentUser = databaseContext.Users .Where(current => current.Id == Infrastructure.Utility.AuthenticatedUser.Id) .FirstOrDefault(); // ************************************************** if (currentUser == null) { System.Windows.Forms.Application.Exit(); } if (currentUser.IsActive == false) { System.Windows.Forms.Application.Exit(); } // ************************************************** currentUser.FullName = fullNameTextBox.Text; currentUser.Description = descriptionTextBox.Text; databaseContext.SaveChanges(); // ************************************************** Infrastructure.Utility.AuthenticatedUser = currentUser; Infrastructure.Utility.MainForm.ResetForm(); // ************************************************** System.Windows.Forms.MessageBox .Show("Your profile updated successfully..."); // استفاده کنیم Close فرم به طور اتوماتیک بسته شود، میتوانیم از دستور MessageBox اگر بخواهیم بعد از UpdateProfileForm در داخل //Close(); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show($"Error: { ex.Message }"); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void RegisterButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.User user = databaseContext.Users .Where(current => string.Compare(current.Username, usernameTextBox.Text, true) == 0) .FirstOrDefault(); if (user != null) { System.Windows.Forms.MessageBox.Show ("This username is already exist! please choose another one ..."); ResetForm(); usernameTextBox.Focus(); return; } user = new Models.User { FullName = fullNameTextBox.Text, Password = passwordTextBox.Text, Username = usernameTextBox.Text, IsActive = true }; databaseContext.Users.Add(user); databaseContext.SaveChanges(); System.Windows.Forms.MessageBox.Show("Registeration Done!"); ResetForm(); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show("Error: " + ex.Message); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void btn_UpdateSave_Click(object sender, EventArgs e) { Models.DatabaseContext oDatabaseContext = null; try { oDatabaseContext = new Models.DatabaseContext(); Models.User oUser = oDatabaseContext.Users .Where(current => current.Id == Infrastructure.Utility.AuthenticatedUser.Id) .FirstOrDefault(); if (oUser == null) { // می توانیم پیغام به کاربر نشان دیم که همچین نام کاربری دیگر وجود ندارد. System.Windows.Forms.Application.Exit(); } oUser.FullName = fullNameTextBox.Text; oUser.Description = fullNameTextBox.Text; oDatabaseContext.SaveChanges(); //Infrastructure.Utility.AuthenticatedUser = oUser; Infrastructure.Utility.AuthenticatedUser = oUser; //System.Windows.Forms.MessageBox // .Show("Your profile was updated successfully..."); //------------------------------------------------------------------------- MessageBox .Show(this, text: "پروفایل کاربری شما با موفقیا بروز رسانی شده است!", caption: "اطلاع رسانی", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error, defaultButton: MessageBoxDefaultButton.Button2, options: MessageBoxOptions.RightAlign | MessageBoxOptions.RtlReading); //------------------------------------------------------------------------- } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show("Error: " + ex.Message); } finally { if (oDatabaseContext != null) { oDatabaseContext.Dispose(); oDatabaseContext = null; } } }
private void EditContact(object sender, EventArgs e) { Models.DatabaseContext oDatabaseContext = null; try { oDatabaseContext = new Models.DatabaseContext(); //Find Row of Selected Cell and Find Guid Of This Row (Guid Column is Number 4 Column. That is Hidden) //By These info We Can Find Record in Database And Call its Info into Our Fields //Then After Edit Info Refresh Grid And Empty Fields //*********************************************************************************** int row = dataGridView.CurrentCell.RowIndex; string cellIndex = dataGridView.Rows[row].Cells[4].Value.ToString(); Guid guid = new Guid(cellIndex); Models.Person p1 = oDatabaseContext.People.Where(current => current.Id == guid).FirstOrDefault(); p1.Name = NameTextbox.Text; p1.Family = FamilyTextbox.Text; p1.Email = EmailTextbox.Text; p1.Phone = PhoneTextbox.Text; if (p1.Name == string.Empty) { MessageBox.Show("Name Can not Be Empty"); } else { oDatabaseContext.SaveChanges(); //Clear Grid For Call New Info dataGridView.Rows.Clear(); dataGridView.Refresh(); NameTextbox.Text = string.Empty; FamilyTextbox.Text = string.Empty; PhoneTextbox.Text = string.Empty; EmailTextbox.Text = string.Empty; var contacts = oDatabaseContext.People.Where(current => current.Id != null).OrderBy(c => c.Name).ToList(); for (int i = 0; i < contacts.Count(); i++) { //Add Row In Grid this.dataGridView.Rows.Add(contacts[i].Name, contacts[i].Family, contacts[i].Phone, contacts[i].Email, contacts[i].Id); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (oDatabaseContext != null) { oDatabaseContext.Dispose(); oDatabaseContext = null; } } }
private void SaveButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.User foundedUser = databaseContext.Users .Where(current => current.Id == SelectedUser.Id) //.Where(current => current.Id == SelectedUserId) .FirstOrDefault(); if (foundedUser == null) { System.Windows.Forms.MessageBox .Show("There is no such a user anymore!"); Close(); } foundedUser.IsAdmin = isAdminCheckBox.Checked; foundedUser.IsActive = isActiveCheckBox.Checked; foundedUser.FullName = fullNameTextBox.Text; foundedUser.Description = descriptionTextBox.Text; databaseContext.SaveChanges(); if (Infrastructure.Utility.AuthenticatedUser.Id == SelectedUser.Id) { Infrastructure.Utility.AuthenticatedUser = foundedUser; Infrastructure.Utility.MainForm.ResetForm(); } Close(); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show($"Error: { ex.Message }"); Close(); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void ChangePasswordButton_Click(object sender, System.EventArgs e) { string errorMessages = string.Empty; if (string.IsNullOrWhiteSpace(oldPasswordTextBox.Text)) { errorMessages = "Old password is required!"; } Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.User currentUser = databaseContext.Users .Where(current => current.Id == Infrastructure.Utility.AuthenticatedUser.Id) .FirstOrDefault(); if (currentUser == null) { System.Windows.Forms.Application.Exit(); } if (string.Compare(currentUser.Password, oldPasswordTextBox.Text, ignoreCase: false) != 0) { System.Windows.Forms.MessageBox.Show("The old password is not correct!"); oldPasswordTextBox.Focus(); return; } currentUser.Password = newPasswordTextBox.Text; databaseContext.SaveChanges(); System.Windows.Forms.MessageBox.Show("Your password changed successfully."); Close(); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void btnAddNewCountry_Click(object sender, System.EventArgs e) { //ایجاد یک شی از دیتا بیس کانتکست Models.DatabaseContext oDatabaseContext = null; try { //New DatabaseContext oDatabaseContext = new Models.DatabaseContext(); // راه حل اول //ایجاد یک شی از کلاس کانتری Models.Country oCountry = new Models.Country(); //ایجاد خود کار یک نام کشور //oCountry.Name = "New Country"; //ایجاد نام کشور به واسطه تکست باکس oCountry.Name = txtCountryName.Text; //افزودن به کالکشن کانتریز در دیتابیس کانتکست oDatabaseContext.Countries.Add(oCountry); // پایان راه حل اول // راه حل دوم //Models.Country oCountry = // new Models.Country(); //oCountry.Name = "New Country"; //oDatabaseContext.Entry(oCountry).State = // System.Data.EntityState.Added; // پایان راه حل دوم //افزودن اطلاعات در دیتا بیس oDatabaseContext.SaveChanges(); } //درصورت بروز خطا آن را نمایش میدهیم catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } //در نهایت اگر شی دیتا بیس کانتکست نال نیود آن را نال میکنیم finally { if (oDatabaseContext != null) { oDatabaseContext.Dispose(); oDatabaseContext = null; } } }
private void AddContact(object sender, EventArgs e) { Models.DatabaseContext oDatabaseContext = null; try { oDatabaseContext = new Models.DatabaseContext(); //Get Info Of Fields And Add These Into Database And Empty Fields //Then Clear And Refresh Grid For Call New Info //*********************************************************************************** Models.Person p1 = new Models.Person(); p1.Id = Guid.NewGuid(); p1.Name = NameTextbox.Text; p1.Family = FamilyTextbox.Text; p1.Email = EmailTextbox.Text; p1.Phone = PhoneTextbox.Text; if (p1.Name == string.Empty) { MessageBox.Show("Name Can not Be Empty"); } else { oDatabaseContext.People.Add(p1); oDatabaseContext.SaveChanges(); //Clear Grid For Call New Info dataGridView.Rows.Clear(); dataGridView.Refresh(); NameTextbox.Text = string.Empty; FamilyTextbox.Text = string.Empty; PhoneTextbox.Text = string.Empty; EmailTextbox.Text = string.Empty; var contacts = oDatabaseContext.People.Where(current => current.Id != null).OrderBy(c => c.Name).ToList(); for (int i = 0; i < contacts.Count(); i++) { //Add Row In Grid this.dataGridView.Rows.Add(contacts[i].Name, contacts[i].Family, contacts[i].Phone, contacts[i].Email, contacts[i].Id); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (oDatabaseContext != null) { oDatabaseContext.Dispose(); oDatabaseContext = null; } } }
private void saveButton_Click(object sender, EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.User currentUser = databaseContext.Users .Where(current => current.Id == Infrastructure.Utility.AuthenticatedUser.Id) .FirstOrDefault(); if (currentUser == null) { System.Windows.Forms.Application.Exit(); } currentUser.FullName = fullnametextBox.Text; currentUser.Description = descriptionTextBox.Text; databaseContext.SaveChanges(); Infrastructure.Utility.AuthenticatedUser = currentUser; //MainForm mainForm = this.MdiParent as MdiForm; //if (mainForm != null) //{ // mainForm.InitializeMainForm(); //} Infrastructure.Utility.MainForm.InitializeMainForm(); System.Windows.Forms.MessageBox .Show(" your profile was update successfully..."); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show("Error:" + ex.Message); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
internal static void Main() { System.Windows.Forms.Application.EnableVisualStyles(); System.Windows.Forms.Application.SetCompatibleTextRenderingDefault(false); #region Database Context Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); bool hasAnyUser = databaseContext.Users .Any(); if (hasAnyUser == false) { Models.User adminUser = new Models.User { IsAdmin = true, IsActive = true, Username = "******", Password = "******", FullName = "Arad Aryan", }; databaseContext.Users.Add(adminUser); databaseContext.SaveChanges(); } } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); return; } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } #endregion Database Context System.Windows.Forms.Application.Run(Infrastructure.Utility.SplashScreenForm); }
public void Save() { try { DatabaseContext.SaveChanges(); } //catch (System.Exception ex) catch { //Hmx.LogHandler.Report(GetType(), null, ex); throw; } }
private void AddButton_Click(object sender, System.EventArgs e) { if (DataValidation() == false) { return; } Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.Contact contact = new Models.Contact { FirstName = firstNameTextEdit.Text.ToString(), LastName = lastNameTextEdit.Text.ToString(), PhoneNumber = phoneNumberTextEdit.Text.ToString(), MobileNumber = mobileTextEdit.Text.ToString(), Address = addressRichText.Text.ToString(), }; databaseContext.Contacts.Add(contact); databaseContext.SaveChanges(); DevExpress.XtraEditors.XtraMessageBox.Show($"!{ firstNameTextEdit.Text } { lastNameTextEdit.Text } با موفقیت اضافه شد", caption: "", buttons: System.Windows.Forms.MessageBoxButtons.OK, icon: System.Windows.Forms.MessageBoxIcon.Asterisk ); Reset(); firstNameTextEdit.Focus(); } catch (System.Exception ex) { DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message.ToString()); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
protected void Page_Load(object sender, EventArgs e) { Session.Abandon(); string key = Response.Cookies["OpenPasteLogin"].Value; Response.Cookies["OpenPasteLogin"].Expires = DateTime.MinValue; Response.Redirect("Pastes.aspx"); using (var ctx = new Models.DatabaseContext()) { Models.LoggedByCookie lbc = (from logging in ctx.LoggedUsers where logging.session_id == key select logging).First(); ctx.LoggedUsers.Remove(lbc); ctx.SaveChanges(); } }
private void SaveButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.User user = databaseContext.Users .Where(current => string.Compare(current.Username, Username, true) == 0) .FirstOrDefault(); if (user == null) { Dtx.Windows.Forms.MessageBox.ShowError("اطلاعات این کاربر حذف شده است!"); Close(); } user.FullName = fullNameTextBox.Text; user.Description = descriptionTextBox.Text; user.IsActive = isActiveCheckBox.Checked; user.IsAdministrator = isAdministratorCheckBox.Checked; databaseContext.SaveChanges(); Dtx.Windows.Forms.MessageBox.ShowInformation("اطلاعات شما با موفقیت ذخیره گردید."); // ************************************************** MyUserListForm.Search(); Program.AuthenticatedUser = user; Program.MainForm.Initialize(); // ************************************************** } catch (System.Exception ex) { Dtx.Windows.Forms.MessageBox.ShowError(ex.Message); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void deleteUsersButton_Click(object sender, System.EventArgs e) { if (usersListBox.SelectedItems.Count == 0) { System.Windows.Forms.MessageBox.Show("You did not select any users for deleting!"); return; } Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); foreach (var selectedItem in usersListBox.SelectedItems) { Models.User selectedUser = selectedItem as Models.User; if (selectedUser != null) { if (selectedUser.IsAdmin == false) { databaseContext.Entry(selectedUser).State = System.Data.Entity.EntityState.Deleted; // Note: Does Not Work! //databaseContext.Users.Remove(selectedUser); databaseContext.SaveChanges(); } } } Search(); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void DisplayResourceForm_Load(object sender, System.EventArgs e) { typeComboBox.DataSource = System.Enum.GetValues(typeof(Models.Enums.ResourceType)); Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.Resource resource = databaseContext.Resources .Where(current => current.Id == Id) .FirstOrDefault(); if (resource == null) { System.Windows.Forms.MessageBox.Show("There is not resource any more!"); Close(); } resource.VisitCount++; databaseContext.SaveChanges(); titleTextBox.Text = resource.Title; authorTextBox.Text = resource.Author; translatorTextBox.Text = resource.Translator; descriptionTextBox.Text = resource.Description; publishYearTextBox.Text = resource.PublishYear.ToString(); //typeComboBox.SelectedText = resource.Type.ToString(); typeComboBox.SelectedItem = (Models.Enums.ResourceType)resource.Type; } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show($"Error: { ex.Message }"); } finally { if (databaseContext != null) { databaseContext.Dispose(); //databaseContext = null; } } }
private void RegistrationButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext oDatabaseContext = null; try { oDatabaseContext = new Models.DatabaseContext(); Models.Task oTask = new Models.Task(); oTask.TaskTitle = TitleTextBox.Text; oTask.TaskDescription = DescriptionTextBox.Text; oTask.ImportanceLevel = ImportanceComboBox.Text; oTask.Date = dateTimePicker1.Text; oDatabaseContext.Tasks.Add(oTask); oDatabaseContext.SaveChanges(); System.Windows.Forms.MessageBox.Show("کار جدید مورد نظر شما اضافه گردید."); TitleTextBox.Text = string.Empty; DescriptionTextBox.Text = string.Empty; } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show("Error: " + ex.Message); } finally { if (oDatabaseContext != null) { oDatabaseContext.Dispose(); oDatabaseContext = null; Main oMian = new Main(); oMian.Show(); } } }
private void EditButton_Click(object sender, System.EventArgs e) { if (DataValidation() == false) { return; } Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.Contact contact = databaseContext.Contacts .Where(current => current.Id == SelectedContact.Id) .FirstOrDefault(); contact.Address = addressRichText.Text.ToString(); contact.LastName = lastNameTextEdit.Text.ToString(); contact.MobileNumber = mobileTextEdit.Text.ToString(); contact.FirstName = firstNameTextEdit.Text.ToString(); contact.PhoneNumber = phoneNumberTextEdit.Text.ToString(); databaseContext.SaveChanges(); DevExpress.XtraEditors.XtraMessageBox.Show($"!{ firstNameTextEdit.Text } { lastNameTextEdit.Text } با موفقیت ویرایش شد", caption: "", buttons: System.Windows.Forms.MessageBoxButtons.OK, icon: System.Windows.Forms.MessageBoxIcon.Asterisk ); this.Close(); } catch (System.Exception ex) { DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message.ToString()); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void registerBook_Click(object sender, EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.Book book = databaseContext.Books .Where(current => string.Compare(current.ISBN, isbnTextBox.Text, true) == 0) .FirstOrDefault(); if (book != null) { System.Windows.Forms.MessageBox.Show ("This book is already exist! Please choose another one..."); isbnTextBox.Focus(); return; } book = new Models.Book(); book.ISBN = isbnTextBox.Text; book.AuthorName = authorNameTextBox.Text; book.Title = titleTextBox.Text; book.PublicationDate = DateTime.Now; Image temp = new Bitmap(strFilePath); System.IO.MemoryStream strm = new System.IO.MemoryStream(); temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg); imageByteArray = strm.ToArray(); book.ImageByteArray = imageByteArray; databaseContext.Books.Add(book); databaseContext.SaveChanges(); System.Windows.Forms.MessageBox.Show("Registration Done!"); Close(); } catch (Exception) { throw; } }
private void SaveButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.User authenticatedUser = Program.AuthenticatedUser; Models.User user = databaseContext.Users .Where(current => current.Id == authenticatedUser.Id) .FirstOrDefault(); if (user == null) { System.Windows.Forms.Application.Exit(); } user.FullName = fullNameTextBox.Text; user.Description = descriptionTextBox.Text; databaseContext.SaveChanges(); Dtx.Windows.Forms.MessageBox.ShowInformation("اطلاعات شما با موفقیت ذخیره گردید."); // ************************************************** Program.AuthenticatedUser = user; Program.MainForm.Initialize(); // ************************************************** } catch (System.Exception ex) { Dtx.Windows.Forms.MessageBox.ShowError(ex.Message); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void saveButton_Click(object sender, EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.Book foundedBook = databaseContext.Books .Where(current => current.Id == SelectedBook.Id) .FirstOrDefault(); if (foundedBook == null) { System.Windows.Forms.MessageBox.Show("There is no such a user anymore!"); Close(); } foundedBook.IsActive = activeCheckBox.Checked; foundedBook.BookName = bookNameTextbox.Text; databaseContext.SaveChanges(); Close(); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); Close(); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void CreateANewCountryButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.Country country = databaseContext.Countries .Where(current => current.Name.ToLower() == "Iran".ToLower()) .FirstOrDefault(); if (country == null) { country = new Models.Country { Name = "Iran", }; databaseContext.Countries.Add(country); databaseContext.SaveChanges(); System.Windows.Forms.MessageBox.Show("Iran country created successfully!"); } else { System.Windows.Forms.MessageBox.Show("Iran country already exists!"); } } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); } finally { if (databaseContext != null) { databaseContext.Dispose(); //databaseContext = null; } } }
private void SaveAndClosebutton_Click(object sender, System.EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.User foundedUser = databaseContext.Users .Where(current => current.Id == SelectedUser.Id) .FirstOrDefault(); if (foundedUser == null) { System.Windows.Forms.MessageBox.Show("There is no such a user anymore!"); Close(); } foundedUser.IsAdmin = isAdminCheckBox.Checked; foundedUser.IsActive = isActiveCheckBox.Checked; foundedUser.FullName = fullNameTextBox.Text; foundedUser.Description = descriptionTextBox.Text; databaseContext.SaveChanges(); Close(); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); Close(); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void EditButton_Click(object sender, EventArgs e) { var foundedEntity = databasecontext.Tasks .Where(current => current.Id == postedTaskViewModel.Id) .FirstOrDefault() ; var taskStatus = databasecontext.TaskStatuses .ToList() ; foundedEntity.Name = nameTextBox.Text; foundedEntity.Description = descriptionTextBox.Text; if (ToDoRadioButton.Checked == true) { foundedEntity.TaskStatus = taskStatus.Where(current => current.Titile.ToLower() == "ToDo".ToLower()).FirstOrDefault(); } if (DoneRadioButton.Checked == true) { foundedEntity.TaskStatus = taskStatus.Where(current => current.Titile.ToLower() == "Done".ToLower()).FirstOrDefault(); } foundedEntity.EndtDate = DateTime.TryParse(endDateMaskedTextBox.Text.ToString(), out DateTime dateTime) == true ? dateTime : foundedEntity.EndtDate; if (deactiveCheckBox.Checked == true) { foundedEntity.IsActive = false; } else { foundedEntity.IsActive = true; } databasecontext.SaveChanges(); MessageBox.Show(text: "Edit Completed", caption: "", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Information); this.Close(); }
private void saveButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.User currentUser = databaseContext.Users .Where(current => current.Id == Infrastructure.Utility.AuthenticatedUser.Id) .FirstOrDefault(); if (currentUser == null) { System.Windows.Forms.Application.Exit(); } currentUser.FullName = fullNameTextBox.Text; currentUser.Description = descriptionTextBox.Text; databaseContext.SaveChanges(); Infrastructure.Utility.AuthenticatedUser = currentUser; ((MainForm)this.MdiParent).UpdateWelcomeToolStripStatusLabel(); System.Windows.Forms.MessageBox .Show("Your profile was updated successfully..."); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show("Error: " + ex.Message); } finally { if (databaseContext != null) { databaseContext.Dispose(); databaseContext = null; } } }
private void saveButton_Click(object sender, System.EventArgs e) { Models.DatabaseContext oDatabaseContext = null; try { oDatabaseContext = new Models.DatabaseContext(); Models.User oUser = oDatabaseContext.Users .Where(current => current.Id == Infrastructure.Utility.AuthenticatedUser.Id) .FirstOrDefault(); if (oUser == null) { System.Windows.Forms.Application.Exit(); } oUser.FullName = fullNameTextBox.Text; oUser.Description = descriptionTextBox.Text; oDatabaseContext.SaveChanges(); Infrastructure.Utility.AuthenticatedUser = oUser; System.Windows.Forms.MessageBox .Show("Your profile was updated successfully..."); } catch (System.Exception ex) { System.Windows.Forms.MessageBox.Show("Error: " + ex.Message); } finally { if (oDatabaseContext != null) { oDatabaseContext.Dispose(); oDatabaseContext = null; } } }
public ActionResult NyKunde(FormCollection innListe) { if (ModelState.IsValid) { /* return "Fornavn: " + innListe["Fornavn"] + "\nEtternavn: " + innListe["Etternavn"] + "\nAdresse: " + innListe["Adresse"] + "\nTelefonnr: " + innListe["Telefonnummer"] + "\nEpost: " + innListe["Epost"] + "\nPassord: " + innListe["Passord"] + "\nPoststed: " + innListe["Poststed"] + "\nPostnr: " + innListe["Postnummer"]; */ // Console.WriteLine("In the mucK"); try { using (var db = new Models.DatabaseContext()) { Session["Bruker"] = null; Session["LoggetInn"] = false; var nyKunde = new Models.dbKunde(); nyKunde.Fornavn = innListe["Fornavn"]; nyKunde.Etternavn = innListe["Etternavn"]; nyKunde.Adresse = innListe["Adresse"]; nyKunde.Telefonnummer = int.Parse(innListe["Telefonnummer"]); nyKunde.Epost = innListe["Epost"]; if (innListe["Passord"].Equals(innListe["PassordKopi"])) { nyKunde.Passord = (Logikk.hashPword(innListe["Passord"])); } //Kan ikke bruke dette array i LINQ nedenfor string innPostNr = innListe["Postnummer"]; var funnetPoststed = db.Poststeder .FirstOrDefault(p => p.Postnummer == innPostNr); if (funnetPoststed == null) //fant ikke poststed, må legge inn et nytt { var nyttPoststed = new Models.dbPoststed(); nyttPoststed.Postnummer = innListe["Postnummer"]; nyttPoststed.Poststed = innListe["Poststed"]; db.Poststeder.Add(nyttPoststed); //det nye poststedet legges i den nye brukeren nyKunde.Poststed = nyttPoststed; } else { //fant poststedet, legger det inn på bruker nyKunde.Poststed = funnetPoststed; } var exist = db.Kunder .FirstOrDefault(k => k.Epost == nyKunde.Epost); if (exist == null) { db.Kunder.Add(nyKunde); Session["Bruker"] = nyKunde; db.SaveChanges(); } else if(funnetPoststed== null) { db.SaveChanges(); } return RedirectToAction("RegistreringsResultat"); } } catch (Exception feil) { return View(); } } else return View(); }