public ActionResult GoBroker(broker broker)
{
using (agendaEntities1 db = new agendaEntities1())
{
db.brokers.Add(broker);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.MessageSuccess = "successful";
return(View("AddBroker", new broker()));
}
public ActionResult ListCustomers()
{
agendaEntities1 db = new agendaEntities1();
string query =
"SELECT [idCustomer], [lastname], [firstname], [mail], [phoneNumber], [budget]"
+ "FROM [dbo].[customers]"
+ "ORDER BY [lastname];";
IEnumerable <agenda.Models.customer> data = db.Database.SqlQuery <agenda.Models.customer>(query); // Enumére une à une les données
return(View("ListCustomers", data.ToList())); // Affiche la vue en list
// A la place de ienumerable et tolist ==> ViewData.Model = db.customers.SqlQuery(query);
}
public ActionResult GoAppointment()
{
agendaEntities1 entities = new agendaEntities1();
var getlastnameBroker = entities.brokers.ToList<broker>();
SelectList list = new SelectList(getlastnameBroker, "idBroker", "lastname");
ViewBag.brokerListName = list;
agendaEntities1 entitie = new agendaEntities1();
var getlastnameCustomer = entities.customers.ToList<customer>();
SelectList listCustomer = new SelectList(getlastnameCustomer, "idCustomer", "lastname");
ViewBag.customerListName = listCustomer;
return View();
}
public ActionResult ListBrokers(int id = 0)
{
agendaEntities1 db = new agendaEntities1();
return(View("ListBrokers", db.brokers.ToList()));
}
