public IEnumerable <WorkOrder> GetAll()
{
var context = new CammContext();
var WO = context.WorkOrders.AsEnumerable();
return(WO);
}
public WorkOrder GetById(string WoNumber)
{
var context = new CammContext();
var WO = context.WorkOrders.Find(WoNumber);
return(WO);
}
public WorkOrder Update(WorkOrder workorder)
{
var context = new CammContext();
WorkOrder targetItem = context.WorkOrders.Find(workorder.WoNumber);
if (targetItem != null)
{
targetItem.AssemblyNumber = workorder.AssemblyNumber;
targetItem.Customer = workorder.Customer;
targetItem.CustomerPO = workorder.CustomerPO;
targetItem.DueDate = workorder.DueDate;
targetItem.QuantityToBuild = workorder.QuantityToBuild;
targetItem.SalesOrder = workorder.SalesOrder;
targetItem.SalesOrderLineItemNo = workorder.SalesOrderLineItemNo;
targetItem.WoStatus = workorder.WoStatus;
targetItem.TimeStamp = DateTime.Now;
}
else
{
throw new Exception("WorkOrder with WoNumber " + workorder.WoNumber + " not found.");
}
context.SaveChanges();
return(targetItem);
}
public WorkOrder Add(WorkOrder workOrder)
{
var context = new CammContext();
var keyViolation = context.WorkOrders.Find(workOrder.WoNumber);
if (keyViolation != null)
{
throw new Exception("Duplicate WoNumber");
}
var WO = context.WorkOrders.Add(workOrder);
try
{
var result = context.SaveChanges();
if (result == 1)
{
return(WO);
}
else
{
throw new Exception("Save failed for an unknown reason.");
};
}
catch (Exception ex)
{
throw new Exception("Save failed. " + ex.InnerException.InnerException);
}
}
public int Remove(string woNumber)
{
var context = new CammContext();
WorkOrder unwanted = context.WorkOrders.Find(woNumber);
try
{
context.WorkOrders.Remove(unwanted);
var result = context.SaveChanges();
return(result);
}
catch (Exception)
{
return(0);
}
}
public IEnumerable <WorkOrder> Find(WorkOrder workOrder)
{
var context = new CammContext();
var query = context.WorkOrders.AsQueryable();
if (workOrder.AssemblyNumber != null)
{
query = query.Where(q => q.AssemblyNumber.Contains(workOrder.AssemblyNumber));
}
if (workOrder.Customer != null)
{
query = query.Where(q => q.AssemblyNumber.Contains(workOrder.Customer));
}
if (workOrder.CustomerPO != null)
{
query = query.Where(q => q.AssemblyNumber.Contains(workOrder.CustomerPO));
}
if (workOrder.SalesOrder != null)
{
query = query.Where(q => q.AssemblyNumber.Contains(workOrder.SalesOrder));
}
if (workOrder.SalesOrderLineItemNo != null)
{
query = query.Where(q => q.AssemblyNumber.Contains(workOrder.SalesOrderLineItemNo));
}
if (workOrder.WoNumber != null)
{
query = query.Where(q => q.AssemblyNumber.Contains(workOrder.WoNumber));
}
if (workOrder.WoStatus != null)
{
query = query.Where(q => q.AssemblyNumber.Contains(workOrder.WoStatus));
}
return(query.AsEnumerable <WorkOrder>());
}
public static IEnumerable <WorkOrder> Find(string searchString)
{
var context = new CammContext();
var query = context.WorkOrders.AsQueryable();
if (!String.IsNullOrEmpty(searchString))
{
string[] terms = searchString.Split(' ');
DateTime startDate = new DateTime();
DateTime endDate = new DateTime();
foreach (string term in terms)
{
if (startDate == DateTime.MinValue && DateTime.TryParse(term, out startDate))
{
continue;
}
if (startDate != DateTime.MinValue && endDate == DateTime.MinValue && DateTime.TryParse(term, out endDate))
{
query = query.Where(q => q.DueDate >= startDate && q.DueDate <= endDate);
continue;
}
query = query.Where(q => q.AssemblyNumber.Contains(term) ||
q.Customer.Contains(term) ||
q.CustomerPO.Contains(term) ||
q.SalesOrder.Contains(term) ||
q.SalesOrderLineItemNo.Contains(term) ||
q.SalesOrderLineItemNo.Contains(term) ||
q.WoNumber.Contains(term) ||
q.WoStatus.Contains(term));
}
}
return(query.AsEnumerable <WorkOrder>());
}
