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