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