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