//
// GET: /Users/
public ActionResult Index()
{
SqlDbConsultor consultor = new SqlDbConsultor();
consultor.conn.setConnectionString("MadaschiAzure");
List <UsersModel> users = consultor.getUsersList();
return(View(users));
}
public ActionResult Delete(int personId)
{
SqlDbConsultor consultor = new SqlDbConsultor();
consultor.conn.setConnectionString("MadaschiAzure");
consultor.DeleteUser(personId);
return(RedirectToAction("Index"));
}
public ActionResult Update(int personId)
{
SqlDbConsultor consultor = new SqlDbConsultor();
consultor.conn.setConnectionString("MadaschiAzure");
UsersModel user = consultor.GetUser(personId);
return(View("Update", user));
}
public ActionResult CreateNewUser(UsersModel user)//string firstName, string lastName, string address, string city)
{
SqlDbConsultor consultor = new SqlDbConsultor();
consultor.conn.setConnectionString("MadaschiAzure");
consultor.CreateNewUser(user);
List <UsersModel> users = consultor.getUsersList();
return(View("Index", users));
}
public ActionResult UpdateUser(string firstName, string lastName, string address, string city, int personId)
{
UsersModel user = new UsersModel();
user.firstName = firstName;
user.lastName = lastName;
user.address = address;
user.city = city;
user.personId = personId;
SqlDbConsultor consultor = new SqlDbConsultor();
consultor.conn.setConnectionString("MadaschiAzure");
consultor.updateUser(user);
List <UsersModel> users = consultor.getUsersList();
return(View("Index", users));
}
