/// <summary> /// Obtiene informacion de diferentes tablas en relacion a la cotizaciones /// </summary> /// <returns>Lista de cotizaciones</returns> public ActionResult QuotationList() { BostreamEntities1 db = new BostreamEntities1(); List <Quotation> quotationList = db.Quotations.ToList(); QuotationViewModel quotationViewModel = new QuotationViewModel(); var list = (from q in db.Quotations join c in db.Customers on q.CustomerID equals c.CustomerID join p in db.People on c.PersonID equals p.PersonId join s in db.Services on q.ServiceID equals s.ServiceID select new QuotationViewModel { CustomerID = c.CustomerID, Name = p.FirstName + " " + p.LastName, QuotationService = s.Name, CreationDate = q.CreationDate, ExpirationDate = q.ExpirationDate, Price = q.Price }).ToList(); return(View(list)); }
public ActionResult Authentication(Admin login) { if (ModelState.IsValid) { BostreamEntities1 db = new BostreamEntities1(); List <Admin> adminList = db.Admins.ToList(); var user = (from userlist in adminList where userlist.username == login.username && userlist.password == login.password select new { userlist.AdminId, userlist.username }).ToList(); if (user.FirstOrDefault() != null) { Session["UserName"] = user.FirstOrDefault().username; Session["UserID"] = user.FirstOrDefault().AdminId; return(RedirectToAction("NewCustomer", "Customer")); } else { return(RedirectToAction("LogIn", "Admin")); } } return(new EmptyResult()); }
public ActionResult AddNewTask(TaskViewModel model) { BostreamEntities1 db = new BostreamEntities1(); List <Task> tasks = db.Tasks.ToList(); Task tsk = new Task(); try { tsk.Title = model.TaskTitle; DateTime date = DateTime.Parse(model.Deadline); tsk.Deadline = date; tsk.Priority = model.Priority; tsk.CustomerID = model.CustomerID; tsk.Description = model.Description; db.Tasks.Add(tsk); db.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } return(View("NewTask", model)); }
public ActionResult AddCustomer(CustomerViewModel model) { var person = new Person { FirstName = model.FirstName, LastName = model.LastName, Email = model.Email }; var customer = new Customer { CompanyName = model.CompanyName, Phone = model.Phone, Note = model.Note, PersonID = person.PersonId }; using (var context = new BostreamEntities1()) { context.People.Add(person); context.Customers.Add(customer); context.SaveChanges(); } return(View("NewCustomer", model)); }
/// <summary> /// Metodo para la obtencion de datos de clintes de diferentes tablas. /// </summary> /// <returns>lista con infromacion de cada cliente</returns> public ActionResult CustomerView() { BostreamEntities1 db = new BostreamEntities1(); List <Customer> customerList = db.Customers.ToList(); CustomerViewModel customerViewModel = new CustomerViewModel(); var list = (from c in db.Customers join p in db.People on c.PersonID equals p.PersonId //join t in db.Tasks // on c.CustomerID equals t.CustomerID into ljt //from t in ljt.DefaultIfEmpty() select new CustomerViewModel { CustomerID = c.CustomerID, Name = p.FirstName + " " + p.LastName, Email = p.Email, CompanyName = c.CompanyName, Phone = c.Phone, Note = c.Note, ////TaskID = t.TaskId, ////TaskTitle = t.Title, ////TaskDesc = t.Description, PersonID = c.PersonID, }).ToList(); return(View(list)); }
public void DBInstance() { // Arrange QuotationController controller = new QuotationController(); // Act BostreamEntities1 result = new BostreamEntities1();; // Assert Assert.IsNotNull(result); }
public ActionResult AddQuotation([Bind(Include = "QuotationID, CustomerID, ServiceID, CreationDate, ExpirationDate, Price")] Quotation _NewQuotation) { if (ModelState.IsValid) { BostreamEntities1 db = new BostreamEntities1(); db.Quotations.Add(_NewQuotation); db.SaveChanges(); return(RedirectToAction("CustomerView")); } return(View(_NewQuotation)); }
public ActionResult AddNewQuotation(QuotationViewModel model) { BostreamEntities1 db = new BostreamEntities1(); List <Quotation> tasks = db.Quotations.ToList(); Quotation qt = new Quotation(); try { qt.CreationDate = DateTime.Now; qt.CustomerID = model.CustomerID; qt.ExpirationDate = model.ExpirationDate; qt.Price = model.Price; qt.ServiceID = model.ServiceID; db.Quotations.Add(qt); db.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } return(View("NewQuotation", model)); }
public ActionResult TaskList() { BostreamEntities1 db = new BostreamEntities1(); List <Task> taskList = db.Tasks.ToList(); TaskViewModel taskViewModel = new TaskViewModel(); var list = (from t in db.Tasks join c in db.Customers on t.CustomerID equals c.CustomerID into ljt from c in ljt.DefaultIfEmpty() join p in db.People on c.PersonID equals p.PersonId select new TaskViewModel { Name = p.FirstName + " " + p.LastName, TaskTitle = t.Title, Deadline = t.Description, Description = t.Description, Priority = t.Priority }).ToList(); return(View(list)); }