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!");
}
}