public ContentResult DeleteMaterialsData(MaterialsExpense materials)
{
var materialsExpenses = db.MaterialsExpenses.Include(m => m.Job);
MaterialsExpense removeMaterials = db.MaterialsExpenses.Find(materials.MaterialsExpenseID);
var isValid = true; //Work around to resolve error
if (isValid)
{
db.MaterialsExpenses.Remove(removeMaterials);
db.SaveChanges();
}
else
{
string error = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError err in modelState.Errors)
{
error = error + err;
}
}
}
JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
string output = jsonSerializer.Serialize(materials);
return Content(output, "application/json");
}
public ContentResult InsertMaterialsData(MaterialsExpense materials)
{
var materialsExpenses = db.MaterialsExpenses.Include(m => m.Job);
var job = db.Jobs;
ModelState.Clear();
TryValidateModel(materials); //Hack to ignore empty job fields
bool isValid = true;
if (isValid)
{
db.MaterialsExpenses.Add(materials);
db.SaveChanges();
}
else
{
string error = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError err in modelState.Errors)
{
error = error + " \n" + err.ErrorMessage;
}
}
return Content("", "application/json");
}
var materialsData = (from mat in materialsExpenses
where mat.MaterialsExpenseID == materials.MaterialsExpenseID
select new
{
mat.MaterialsExpenseID,
mat.Expense,
JobID = mat.Job.JobID,
ExpenseDate = SqlFunctions.DateName("mm", mat.ExpenseDate) + " " + SqlFunctions.DateName("day", mat.ExpenseDate) + ", " + SqlFunctions.DateName("year", mat.ExpenseDate),
mat.ItemNumber,
mat.ExpenseDescription,
mat.PONumber,
mat.InvoiceNumber,
mat.TaxIncluded,
mat.InvoiceReceived,
mat.TaxPercentage,
mat.MarkupPercentage
}).SingleOrDefault();
JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
string output = jsonSerializer.Serialize(materialsData);
return Content(output, "application/json");
}
// GET: /Materials/MaterialsData
public ContentResult MaterialsData(MaterialsExpense filter)
{
var materialsExpenses = db.MaterialsExpenses.Include(m => m.Job);
var materialsData = (from mat in materialsExpenses
where (mat.ExpenseDescription.Contains(filter.ExpenseDescription) || string.IsNullOrEmpty(filter.ExpenseDescription))
&& (mat.Expense == filter.Expense || filter.Expense == 0)
&& (mat.Job.JobID == filter.JobID || filter.JobID == 0)
&& (mat.ItemNumber == filter.ItemNumber || (filter.ItemNumber == 0))
&& (mat.PONumber.Contains(filter.PONumber) || string.IsNullOrEmpty(filter.PONumber))
&& (mat.InvoiceNumber.Contains(filter.InvoiceNumber) || string.IsNullOrEmpty(filter.InvoiceNumber))
&& (mat.TaxPercentage == filter.TaxPercentage || filter.TaxPercentage == null)
&& (mat.MarkupPercentage == filter.MarkupPercentage || filter.MarkupPercentage == null)
select new
{
mat.MaterialsExpenseID,
mat.Expense,
JobID = mat.Job.JobID,
ExpenseDate = SqlFunctions.DateName("mm", mat.ExpenseDate) + " " + SqlFunctions.DateName("day", mat.ExpenseDate) + ", " + SqlFunctions.DateName("year", mat.ExpenseDate),
mat.ItemNumber,
mat.ExpenseDescription,
mat.PONumber,
mat.InvoiceNumber,
mat.TaxIncluded,
mat.InvoiceReceived,
mat.TaxPercentage,
mat.MarkupPercentage
}).ToList();
JavaScriptSerializer jsonSerializer = new JavaScriptSerializer();
string output = jsonSerializer.Serialize(materialsData);
return Content(output, "application/json");
}