public ActionResult DeleteConfirmed(int id, int id2) { HelpUser helpUser = db.HelpUsers.Find(id2, id); db.HelpUsers.Remove(helpUser); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "HelpID,UserID,HelpUserDate,DisasterID")] HelpUser helpUser) { if (ModelState.IsValid) { db.Entry(helpUser).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserID = new SelectList(db.AppUsers, "ID", "Name", helpUser.UserID); ViewBag.DisasterID = new SelectList(db.Disasters, "ID", "ID", helpUser.DisasterID); ViewBag.HelpID = new SelectList(db.Helps, "ID", "Help1", helpUser.HelpID); return(View(helpUser)); }
public void LoginClick(object sender, RoutedEventArgs e) { string userr = Username1.Text; HelpUser help = new HelpUser() { Username = Username1.Text, Password = Password1.Text, UserID = UserContext.UserId }; SqlConnection myConnection = new SqlConnection (@"server=THE-PROFESSOR\ANDREW;" + "Integrated security=sspi;" + "database= Journal;" + "MultipleActiveResultSets=true;" + "connection timeout=10;"); { try { myConnection.Open(); SqlCommand cmd = new SqlCommand(@"SELECT userID FROM [Journal].[dbo].[User] WHERE Username=@uname and password=@pass", myConnection); cmd.Parameters.AddWithValue("@uname", Username1.Text); cmd.Parameters.AddWithValue("@pass", Password1.Text); int result = (int)cmd.ExecuteScalar(); if (result > 0) { UserContext.UserId = result; MessageBox.Show($"Welcome {userr}! "); Menu menu = new Menu(); menu.Show(); this.Close(); } else { MessageBox.Show("Incorrect login"); } } catch (Exception ex) { MessageBox.Show("Incorrect login"); } } }
// GET: HelpUsers/Details/5 public ActionResult Details(int?id, int?id2) { if (id == null || id2 == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HelpUser helpUser = db.HelpUsers.Find(id2, id); if (helpUser == null) { return(HttpNotFound()); } return(View(helpUser)); }
public View() { InitializeComponent(); bool temp = false; SqlConnection con = new SqlConnection (@"server=THE-PROFESSOR\ANDREW;" + "Integrated security=sspi;" + "database= Journal;" + "MultipleActiveResultSets=true;" + "connection timeout=10;"); HelpUser HU = new HelpUser() { }; con.Open(); SqlCommand cmd = new SqlCommand("select Title from Journal where UserID= @UserId order by title asc", con); cmd.Parameters.Add("@UserId", System.Data.SqlDbType.Int); cmd.Parameters["@UserId"].Value = UserContext.UserId; SqlDataReader dr = cmd.ExecuteReader(); var ordinal = dr.GetOrdinal("Title"); while (dr.Read()) { try { titles.Text += dr.GetString(ordinal) + Environment.NewLine; } catch { MessageBox.Show("Error"); } temp = true; } if (temp == false) { MessageBox.Show("not found"); } con.Close(); }
// GET: HelpUsers/Edit/5 public ActionResult Edit(int?id, int?id2) { if (id == null || id2 == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HelpUser helpUser = db.HelpUsers.Find(id2, id); if (helpUser == null) { return(HttpNotFound()); } ViewBag.UserID = new SelectList(db.AppUsers, "ID", "Name", helpUser.UserID); ViewBag.DisasterID = new SelectList(db.Disasters, "ID", "ID", helpUser.DisasterID); ViewBag.HelpID = new SelectList(db.Helps, "ID", "Help1", helpUser.HelpID); return(View(helpUser)); }