public IEnumerable <getLines1_Result> Get()
{
using (BudgetCHEntities1 entities = new BudgetCHEntities1())
{
return(entities.getLines1().ToArray());
}
}
public IEnumerable <Employees> Get()
{
using (BudgetCHEntities1 entities = new BudgetCHEntities1())
{
return(entities.Employees.ToList());
}
}
public IEnumerable <Budget> Get()
{
using (BudgetCHEntities1 entities = new BudgetCHEntities1())
{
return(entities.Budget.ToList());
//var budget = new Budget {basis_id = result.basis_id, period = result.period };
}
}
public IEnumerable <invoicesByCustomer_Result> Get(int startedBy)
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.invoicesByCustomer(startedBy);
var result = response.ToArray();
return(result);
}
}
public IEnumerable <showACC_Result> Get()
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.showACC();
var result = response.ToList();
return(result);
}
}
public IEnumerable <pentingDirector_Result> GetPentingDirector(int reqID)
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.pentingDirector(reqID);
var result = response.ToArray();
return(result);
}
}
public IEnumerable <rejectedOwner_Result> GetRejectedOwner(int reqID)
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.rejectedOwner(reqID);
var result = response.ToArray();
return(result);
}
}
public IEnumerable <rejectedDirectorRegional_Result> GetRejectedReg(int reqID)
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.rejectedDirectorRegional(reqID);
var result = response.ToArray();
return(result);
}
}
public IEnumerable <GetProjects_Result> Get()
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.GetProjects();
var result = response.ToArray();
return(result);
}
}
public IEnumerable <getBudgetsNotStarted_Result> GetBudgetNotStarted()
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.getBudgetsNotStarted();
var result = response.ToArray();
return(result);
}
}
public IEnumerable <getBudgetIdToProcess_Result> Get(int ownerID)
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.getBudgetIdToProcess(ownerID);
var result = response.ToArray();
return(result);
}
}
public IEnumerable <empDirectorReg1_Result> getDirectorsReg()
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.empDirectorReg1();
var result = response.ToList();
return(result);
}
}
public IEnumerable <empOwner1_Result> getOwners()
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.empOwner1();
var result = response.ToList();
return(result);
}
}
public IEnumerable <getAllInvoicesACC_Result> Get()
{
using (BudgetCHEntities1 entities = new BudgetCHEntities1())
{
var response = entities.getAllInvoicesACC();
var result = response.ToArray();
return(result);
}
}
public IEnumerable <string> Get(int position)
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.userByPosition(position);
var result = response.ToArray();
return(result);
}
}
public IEnumerable <budgetLinesID_Result> Get(int BudgetID)
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.budgetLinesID(BudgetID);
var result = response.ToArray();
return(result);
}
}
public decimal?[] Get(int budgetID)
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.getTotalBudget(budgetID);
var result = response.ToArray();
return(result);
}
}
public IEnumerable <LinesbyBudget2_Result> Get(int reqID)
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.LinesbyBudget2(reqID);
var result = response.ToArray();
return(result);
}
}
public string Get(int budgetID)
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.setBudgetNotStarted1(budgetID);
var result = response.ToString();
return(result);
}
}
public HttpResponseMessage Post([FromBody] Processes proc)
{
try
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.nextStep(proc.process_id, proc.actionDate, proc.step_id, proc.requestor, proc.asignedTo);
var message = Request.CreateResponse(HttpStatusCode.Created, proc);
message.Headers.Location = new Uri(Request.RequestUri + proc.process_id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Post([FromBody] Budget_line bl)
{
try
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.budgetLine(bl.line_id, bl.budget_id, bl.amount);
var message = Request.CreateResponse(HttpStatusCode.Created, bl);
message.Headers.Location = new Uri(Request.RequestUri + bl.bline_id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Post([FromBody] Invoices invoice)
{
try
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.newInvoice(invoice.invoice_number, invoice.invoice_date, invoice.customer, invoice.item_name, invoice.budget_ID, invoice.amount, invoice.line_id, invoice.dueDate, invoice.comment);
var message = Request.CreateResponse(HttpStatusCode.Created, invoice);
message.Headers.Location = new Uri(Request.RequestUri + invoice.invoice_id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Post([FromBody] Invoices i)
{
try
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.registerByACC(i.invoice_id);
var message = Request.CreateResponse(HttpStatusCode.Created, i);
message.Headers.Location = new Uri(Request.RequestUri + i.invoice_id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Post([FromBody] Budget budget)
{
try
{
using (var entities = new BudgetCHEntities1())
{
var response = entities.createBudget(budget.period, budget.basis_id, budget.owner_id, budget.comment, budget.project_id, budget.status);
var message = Request.CreateResponse(HttpStatusCode.Created, budget);
message.Headers.Location = new Uri(Request.RequestUri + budget.budget_id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
