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(); } }
private void Upload_Click(object sender, EventArgs e) { string Nm, PSW; Nm = NameField.Text; PSW = PswField.Text; using (Films_dbEntities db = new Films_dbEntities()) { var user = db.Users.Where(x => x.Name.Equals(Nm) && x.Password.Equals(PSW)).FirstOrDefault(); if (user != null) { MessageBox.Show("Sign In Succesfully"); this.Hide(); Main.ControlID.UserName = Nm; var form2 = new Main(); form2.Closed += (s, args) => this.Close(); form2.Show(); } else { MessageBox.Show("password or Email is incorrect"); NameField.ResetText(); PswField.ResetText(); } } }
public Main() { InitializeComponent(); loadTable(); dataGridView.Columns[0].Visible = false; dataGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView.AllowUserToOrderColumns = true; var context = new Films_dbEntities(); var posts = context.Users .Where(p => p.Admin == 1); var query = posts.ToList(); foreach (var nm in query) { if (!string.Equals(ControlID.UserName, nm.Name)) { Delete.Visible = false; Insert.Visible = false; FeedBacks.Visible = false; UpdateButton.Visible = false; dataGridView.ReadOnly = true; } else { Delete.Visible = true; Insert.Visible = true; FeedBack.Visible = false; } } }
public void loadData() { using (Films_dbEntities db = new Films_dbEntities()) { var films = db.Films.Where(x => x.Name.Equals(NameObj)).FirstOrDefault(); if (films != null) { NameField.Text = NameObj; MarkField.Text = films.Mark; GenreField.Text = films.Genre; } } }
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"); }
public void loadTable() { using (Films_dbEntities db = new Films_dbEntities()) { var result = from Films in db.Films select Films; dataGridView.DataSource = result.OrderBy(x => x.ID).Skip(5 * page).Take(5).ToList(); int Count = result.ToList().Count(); PageCount = Count / 5; if (Count % 5 > 0) { PageCount = PageCount + 1; } PageLabel.Text = page + 1 + "/" + PageCount; } //var result = Get(); //List<Film> FilmList = result.ToList(); }
public static IQueryable <Feedback> Get() { var context1 = new Films_dbEntities(); return(context1.Feedbacks); }