public virtual customers Get(int id)
{
using (BikeStoresEntities entities = new BikeStoresEntities())
{
return(entities.customers.FirstOrDefault(e => e.customer_id == id));
}
}
public virtual IEnumerable <customers> Get()
{
using (BikeStoresEntities entities = new BikeStoresEntities())
{
return(entities.customers.ToList());
}
}
public IHttpActionResult AddProduct([FromBody]product prod)
{
if (!ModelState.IsValid)
{
return BadRequest("Form your request properly please!");
}
using (BikeStoresEntities entities = new BikeStoresEntities())
{
product product = entities.products.Where(e => e.product_id == prod.product_id).FirstOrDefault<product>();
if (product != null)
{
product.product_id = prod.product_id;
entities.SaveChanges();
}
else
{
entities.products.Add(new product()
{
product_id = prod.product_id
});
entities.SaveChanges();
}
}
return Ok();
}
public static void AddCustomers(customers customers)
{
using (BikeStoresEntities db = new BikeStoresEntities())
{
db.customers.Add(customers);
db.SaveChanges();
}
}
/*Metodo para retornar una lista*/
public static List <customers> GetCustomers()
{
using (BikeStoresEntities db = new BikeStoresEntities())
{
return(db.customers.Take(500).ToList());
//return db.customers.ToList();
}
}
public static void UpdateCustomers(customers customers)
{
using (BikeStoresEntities db = new BikeStoresEntities())
{
db.customers.Add(customers);
db.Entry(customers).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public product GetProduct(int id)
{
using (BikeStoresEntities entities = new BikeStoresEntities())
{
return entities.products
.Include(x => x.stocks)
.Include(x => x.order_items)
.FirstOrDefault(e => e.product_id == id);
}
}
public static void DeleteCustomers(int customer_id)
{
using (BikeStoresEntities db = new BikeStoresEntities())
{
var customers = new DataAccess.customers {
customer_id = customer_id
};
db.customers.Attach(customers);
//db.customers.Remove(customers);
db.Entry(customers).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
//public IEnumerable<product> Get()
public IHttpActionResult Get()
{
//List<product> prods = new List<product>();
//product p = new product();
//p.brand_id = 1;
//prods.Add(p);
//return prods;
using (BikeStoresEntities entities = new BikeStoresEntities())
{
//return entities.products
// .Include(x => x.stocks)
// .Include(x => x.order_items)
// .ToList();
}
HttpClient client = new HttpClient();
HttpResponseMessage res = client.GetAsync("https://jsonplaceholder.typicode.com/posts").Result;
IEnumerable<Book> books = null;
if (res.IsSuccessStatusCode)
{
books = res.Content.ReadAsAsync<IEnumerable<Book>>().Result;
}
string filename = "tester.txt";
if (books != null)
{
List<string> bookdetails = new List<string>();
foreach (Book b in books)
{
bookdetails.Add($"{b.Id} {b.Title}");
}
File.WriteAllText(Path.GetTempPath() + filename, String.Join("\n", bookdetails));
}
string text = File.ReadAllText(Path.GetTempPath() + $"{filename}");
List<product> prods = new List<product>();
prods.Add(new product());
return Ok(prods);
}
