private void button1_Click(object sender, EventArgs e)
{
string Texti, UN;
Texti = richTextBox1.Text;
UN = Main.ControlID.UserName;
var context = new Films_dbEntities();
using (Films_dbEntities db = new Films_dbEntities())
{
var user = db.Users.Where(x => x.Name.Equals(UN)).FirstOrDefault();
var t = new Feedback //Make sure you have a table called test in DB
{
UserID = user.ID,
Text = Texti,
UserName = UN
};
context.Feedbacks.Add(t);
context.SaveChanges();
this.Hide();
}
}
public void Delete_Click1(object sender, EventArgs e)
{
var Context = new Films_dbEntities();
var itemToRemove = Context.Films.SingleOrDefault(x => x.Name == RowName);
if (itemToRemove != null)
{
Context.Films.Remove(itemToRemove);
Context.SaveChanges();
loadTable();
MessageBox.Show(RowName + "is deleted");
}
}
private void Upload_Click(object sender, EventArgs e)
{
using (Films_dbEntities db = new Films_dbEntities())
{
var result = db.Films.SingleOrDefault(b => b.Name == NameObj);
if (result != null)
{
result.Name = NameField.Text;
result.Mark = MarkField.Text;
result.Genre = GenreField.Text;
db.SaveChanges();
MessageBox.Show("Film " + NameField.Text + " is Updated");
this.Hide();
}
}
}
private void Upload_Click(object sender, EventArgs e)
{
string NM, PSW;
NM = NameField.Text;
PSW = PswField.Text;
if (NM.Length < 6 || PSW.Length < 6)
{
MessageBox.Show("Name and Pasword should contain minimum 6 letter");
}
else
{
using (Films_dbEntities db = new Films_dbEntities())
{
var user = db.Users.Where(x => x.Name.Equals(NM)).FirstOrDefault();
if (user == null)
{
MessageBox.Show("Registration Was Succesfully");
this.Hide();
var t = new User
{
Name = NM,
Password = PSW
};
db.Users.Add(t);
db.SaveChanges();
var g = new Thread(() => Application.Run(new LogIn()));
g.Start();
this.Close();
this.Hide();
}
else
{
MessageBox.Show("Same name already exist");
NameField.ResetText();
PswField.ResetText();
}
}
}
}
private void Upload_Click(object sender, EventArgs e)
{
Main mn = new Main();
string NM, Gnr;
NM = NameField.Text;
Gnr = GenreField.Text;
String Mrk;
Mrk = MarkField.Text;
var context = new Films_dbEntities();
var t = new Film //Make sure you have a table called test in DB
{
Name = NM,
Mark = Mrk,
Genre = Gnr
};
context.Films.Add(t);
context.SaveChanges();
NameField.ResetText();
GenreField.ResetText();
MarkField.ResetText();
var form = new Main();
form.Refresh();
mn.loadTable();
MessageBox.Show("Film " + NM + " is added");
}