public InvoiceInfo GetInvoiceInfo(string id)
{
using (InvoiceDBEntities invoiceDBEntities = new InvoiceDBEntities())
{
invoiceDBEntities.Configuration.ProxyCreationEnabled = false;
return(invoiceDBEntities.InvoiceInfoes.Where(x => x.InvoiceID == id).SingleOrDefault());
}
}
public IEnumerable <InvoiceInfo> GetCompanyInvoice(int id)
{
using (InvoiceDBEntities invoiceDBEntities = new InvoiceDBEntities())
{
invoiceDBEntities.Configuration.ProxyCreationEnabled = false;
return(invoiceDBEntities.InvoiceInfoes.Where(x => x.CompanyID == id).ToList());
}
}
public string CreateInvoice([FromBody] IInvoice invoice)
{
using (InvoiceDBEntities invoiceDBEntities = new InvoiceDBEntities())
{
ObjectParameter outParam = new ObjectParameter("newid", typeof(string));
invoiceDBEntities.CreateInvoice(invoice.companyID, invoice.customerID, invoice.shippingAddress, outParam);
return((string)outParam.Value);
}
}
public int CreateCompany([FromBody] ICompany company)
{
using (InvoiceDBEntities invoiceDBEntities = new InvoiceDBEntities())
{
ObjectParameter outParam = new ObjectParameter("newid", typeof(int));
invoiceDBEntities.CreateCompany(company.companyname, company.companyAddress, outParam);
return((int)outParam.Value);
}
}
public CustomerRepository()
{
objInvoiceDbEntities = new InvoiceDBEntities();
}
public HomeController()
{
objInvoiceDbEntities = new InvoiceDBEntities();
}
public PaymentTypeRepository()
{
objInvoiceDbEntities = new InvoiceDBEntities();
}
public ItemRepository()
{
objInvoiceDbEntities = new InvoiceDBEntities();
}
public OrderRepository()
{
objInvoiceDbEntities = new InvoiceDBEntities();
}