private void pictureBoxWatchlistFilled_Click(object sender, EventArgs e) //asta e de fapt empty { using (var context = new IMDBEntities()) { if (MemberMovieOrTvSeries.Equals("Movie")) { var resultuserid = (from a in context.Users where a.Username.Equals(MemberUserName) select a).First(); var resultfilmid = (from c in context.Filmes where c.Nume.Equals(MemberMovieName) select c).First(); var addWatch = new WatchList() { ID_User = resultuserid.ID_User, ID_Film = resultfilmid.ID_Film, Watched = 1 }; context.WatchLists.Add(addWatch); context.SaveChanges(); pictureBoxWatchlistFilled.Visible = false; //butoanele sunt inversate ca si denumire pictureBoxWatchlistEmpty.Visible = true; MessageBox.Show("Filmul " + MemberMovieName + " a fost adaugat in watchlist!"); } else { var resultuserid = (from a in context.Users where a.Username.Equals(MemberUserName) select a).First(); var resultfilmid = (from c in context.Seriales where c.Nume.Equals(MemberMovieName) select c).First(); var addWatch = new WatchlistSeriale() { ID_User = resultuserid.ID_User, ID_Serial = resultfilmid.ID_Serial, Watched = 1 }; context.WatchlistSeriales.Add(addWatch); context.SaveChanges(); pictureBoxWatchlistFilled.Visible = false; //butoanele sunt inversate ca si denumire pictureBoxWatchlistEmpty.Visible = true; MessageBox.Show("Serialul " + MemberMovieName + " a fost adaugat in watchlist!"); } } }
public void schimba_parole() { using (var context = new IMDBEntities()) { var users = (from a in context.Users where a.ID_User == 2 select a).First(); //// int count = users.Count(); // // var item = users.ToList(); // //for(int i= 0;i<count;i++) // //{ // item[i].Password = CalculateMD5Hash(item[i].Password); // } users.Password = CalculateMD5Hash(users.Password); context.SaveChanges(); } }
private void StartOwnTransactionWithinContext() { using (var context = new IMDBEntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { if (verify(textBoxUserName.Text, textBoxEmail.Text, textBoxPhoneNR.Text).Equals("OK")) { var newUser = new User { Username = textBoxUserName.Text, Password = CalculateMD5Hash(textBoxPassword.Text), E_mail = textBoxEmail.Text, PhoneNumber = textBoxPhoneNR.Text, Rights = "user", DateofRegister = DateTime.Now }; context.Users.Add(newUser); } else { MessageBox.Show(verify(textBoxUserName.Text, textBoxEmail.Text, textBoxPhoneNR.Text)); } context.SaveChanges(); dbContextTransaction.Commit(); MessageBox.Show("Welcome to our site!"); } catch (Exception) { Console.WriteLine("Nu exista nume!!!"); dbContextTransaction.Rollback(); } } } }
private void button2_Click(object sender, EventArgs e) //pt creare cont { if (verify(textBoxUserName.Text, textBoxEmail.Text, textBoxPhoneNR.Text).Equals("OK")) { var context = new IMDBEntities(); var newUser = new User { Username = textBoxUserName.Text, Password = textBoxPassword.Text, E_mail = textBoxEmail.Text, PhoneNumber = textBoxPhoneNR.Text, Rights = "user" }; context.Users.Add(newUser); context.SaveChanges(); MessageBox.Show("Welcome to our site!"); } else { MessageBox.Show(verify(textBoxUserName.Text, textBoxEmail.Text, textBoxPhoneNR.Text)); } }
private void buttonSalveaza_Click(object sender, EventArgs e) { try { if (!comboBoxTable.Text.Equals("Alege o tabela...")) { int lengthtext = textBoxID.TextLength; string digit = "0123456789"; for (int i = 0; i < lengthtext; i++) { if (!digit.Contains(textBoxID.Text[i])) { lengthtext = 0; } } if (lengthtext != 0) { using (IMDBEntities context = new IMDBEntities()) { if (comboBoxTable.Text.Equals("Actori")) { int x = Convert.ToInt32(textBoxID.Text); var result = (from b in context.Actoris where b.ID_Actor.Equals(x) select b).First(); if (result != null) { result.Photo = ConvertFiletoByte(this.pictureBoxPhoto.ImageLocation); context.SaveChanges(); MessageBox.Show("Fotografie adaugata cu succes!"); } else { MessageBox.Show("Acest Id nu apartine nici unei inregistrari!"); } } else if (comboBoxTable.Text.Equals("Filme")) { int x = Convert.ToInt32(textBoxID.Text); var result = (from b in context.Filmes where b.ID_Film.Equals(x) select b).First(); if (result != null) { result.Photo = ConvertFiletoByte(this.pictureBoxPhoto.ImageLocation); context.SaveChanges(); MessageBox.Show("Fotografie adaugata cu succes!"); } else { MessageBox.Show("Acest Id nu apartine nici unei inregistrari!"); } } else if (comboBoxTable.Text.Equals("Regizori")) { int x = Convert.ToInt32(textBoxID.Text); var result = (from b in context.Regizoris where b.ID_Regizor.Equals(x) select b).First(); if (result != null) { result.Photo = ConvertFiletoByte(this.pictureBoxPhoto.ImageLocation); context.SaveChanges(); MessageBox.Show("Fotografie adaugata cu succes!"); } else { MessageBox.Show("Acest Id nu apartine nici unei inregistrari!"); } } else if (comboBoxTable.Text.Equals("Seriale")) { int x = Convert.ToInt32(textBoxID.Text); var result = (from b in context.Seriales where b.ID_Serial.Equals(x) select b).First(); if (result != null) { result.Photo = ConvertFiletoByte(this.pictureBoxPhoto.ImageLocation); context.SaveChanges(); MessageBox.Show("Fotografie adaugata cu succes!"); } else { MessageBox.Show("Acest Id nu apartine nici unei inregistrari!"); } } else if (comboBoxTable.Text.Equals("Users")) { int x = Convert.ToInt32(textBoxID.Text); var result = (from b in context.Users where b.ID_User.Equals(x) select b).First(); if (result != null) { result.Photo = ConvertFiletoByte(this.pictureBoxPhoto.ImageLocation); context.SaveChanges(); MessageBox.Show("Fotografie adaugata cu succes!"); } else { MessageBox.Show("Acest Id nu apartine nici unei inregistrari!"); } } } } else { MessageBox.Show("Please insert correct ID!"); } } else { MessageBox.Show("Selecteaza o tabela!"); } } catch { MessageBox.Show("Can't add this file in " + comboBoxTable.Text + " table!"); } }