public ActionResult Update(string Message, string PatientName, string PatientEmail, string RoomNumber, int CardId, int CardDesignId)
{
GetWellSoonCard Card = db.GetWellSoonCards.Find(CardId);
Card.Message = Message;
Card.CardDesignId = CardDesignId;
Card.PatientName = PatientName;
Card.PatientEmail = PatientEmail;
Card.RoomNumber = RoomNumber;
db.SaveChanges();
/*string query = "Update GetWellSoonCards set Message=@Message, PatientName=@PatientName, PatientEmail=@PatientEmail, CardDesignId=@CardDesignId, RoomNumber=@RoomNumber where CardId=@CardId";
* SqlParameter[] sqlparams = new SqlParameter[6];
* sqlparams[0] = new SqlParameter("@Message", Message);
* sqlparams[1] = new SqlParameter("@CardDesignId", CardDesignId);
* sqlparams[2] = new SqlParameter("@PatientName", PatientName);
* sqlparams[3] = new SqlParameter("@PatientEmail", PatientEmail);
* sqlparams[4] = new SqlParameter("@RoomNumber", RoomNumber);
* sqlparams[5] = new SqlParameter("@CardId", CardId);
*
* //Execute
* db.Database.ExecuteSqlCommand(query, sqlparams);*/
Debug.WriteLine("I am trying to edit the card with the message " + Message);
return(RedirectToAction("/Show/" + CardId));
}
public ActionResult Update(int id)
{
GetWellSoonCard Card = db.GetWellSoonCards.Find(id);
List <CardDesign> Designs = db.CardDesigns.ToList();
//GetWellSoonCard Card = db.GetWellSoonCards.SqlQuery("Select * from GetWellSoonCards where CardId = @id", new SqlParameter("@id", id)).FirstOrDefault();
//List<CardDesign> Designs = db.CardDesigns.SqlQuery("Select * from CardDesigns").ToList();
Debug.WriteLine("I am trying to show card id" + id);
UpdateGetWell UpdateGetWellViewModel = new UpdateGetWell();
UpdateGetWellViewModel.GetWellSoonCard = Card;
UpdateGetWellViewModel.CardDesigns = Designs;
return(View(UpdateGetWellViewModel));
}
public ActionResult Delete(int id)
{
//find the card with that particular id
GetWellSoonCard Card = db.GetWellSoonCards.Find(id);
/*GetWellSoonCard Card = db.GetWellSoonCards.SqlQuery("Select * from GetWellSoonCards where CardId = @id", new SqlParameter("@id", id)).FirstOrDefault();*/
//To do: Look into inner join Linq
CardDesign Design = db.CardDesigns.SqlQuery("Select * from CardDesigns inner join GetWellSoonCards on GetWellSoonCards.CardDesignId = CardDesigns.CardDesignId where CardId = @id", new SqlParameter("@id", id)).FirstOrDefault();
Debug.WriteLine("I am trying to show card id" + id);
ShowGetWell ShowGetWellViewModel = new ShowGetWell();
ShowGetWellViewModel.GetWellSoonCard = Card;
ShowGetWellViewModel.CardDesign = Design;
return(View(ShowGetWellViewModel));
}
public ActionResult Show(int id)
{
//grab the id of current logged in user to display their names, phone etc...
string userId = User.Identity.GetUserId();
ApplicationUser currentUser = db.Users.FirstOrDefault(x => x.Id == userId);
//display the cards and the design of cards
GetWellSoonCard Card = db.GetWellSoonCards.Find(id);
//GetWellSoonCard Card = db.GetWellSoonCards.SqlQuery("Select * from GetWellSoonCards where CardId = @id", new SqlParameter("@id", id)).FirstOrDefault();
//Look into Inner join
CardDesign Design = db.CardDesigns.SqlQuery("Select * from CardDesigns inner join GetWellSoonCards on GetWellSoonCards.CardDesignId = CardDesigns.CardDesignId where CardId = @id", new SqlParameter("@id", id)).FirstOrDefault();
Debug.WriteLine("I am trying to show card id" + id);
//instanciate the class
ShowGetWell ShowGetWellViewModel = new ShowGetWell();
ShowGetWellViewModel.GetWellSoonCard = Card;
ShowGetWellViewModel.CardDesign = Design;
ShowGetWellViewModel.User = currentUser;
return(View(ShowGetWellViewModel));
}
public ActionResult Delete(int id, int CardId)
{
GetWellSoonCard Card = db.GetWellSoonCards.Find(CardId);
db.GetWellSoonCards.Remove(Card);
db.SaveChanges();
/*string query = "Delete from GetWellSoonCards where CardId = @CardID";
* SqlParameter[] sqlparams = new SqlParameter[1];
* sqlparams[0] = new SqlParameter("@CardId", CardId);
* db.Database.ExecuteSqlCommand(query, sqlparams);*/
//when deleting is done, admin will return to the total list
//user will return to personal list
if (User.IsInRole("Admin"))
{
return(RedirectToAction("List"));
}
else
{
return(RedirectToAction("PersonalList"));
}
//return RedirectToAction("List");
}
