private void InsertProduct(Product product) { IDbConnection con = null; try { con = openConnection(); var cmd = con.CreateCommand(); cmd.CommandText = string.Format("insert into products values ('{0}','{1}',{2})", product.Name, product.Category, product.Price); cmd.ExecuteNonQuery(); cmd.CommandText = "select @@identity"; var id = cmd.ExecuteScalar(); product.Id = Convert.ToInt32(id); } catch (Exception) { throw; } finally { if (con != null) con.Close(); } }
public HttpResponseMessage PostProduct(Product product) { InsertProduct(product); string apiName = WebApiConfig.DefaultRouteName; var response = Request.CreateResponse<Product>(HttpStatusCode.Created, product); var uri = Url.Link(apiName, new { id = product.Id }); response.Headers.Location = new Uri(uri); return response; }
public static List<Product> getProducts() { List<Product> lstProd = new List<Product>(); Product lt = new Product(); productKey = productKey + 1; lt.ID = productKey; lt.Make = "Apple"; lt.Model = "I Phone 5"; lt.Color = "Black"; lt.Specs = "2 GB RAM"; lt.ImgPath = "images/I6_Black.jpeg"; lt.Price = "$200.0"; lt.OfferPrice = "$190.0"; lt.Views = 100; lt.Description = "SUper Nateral Phone ...................... Random text................."; lt.TotalNoOfPurchases = 40; lstProd.Add(lt); Product lt1 = new Product(); productKey = productKey + 1; lt1.ID = productKey; lt1.Make = "Apple"; lt1.Model = "I Phone 5"; lt1.Color = "White"; lt1.Specs = "2 GB RAM"; lt1.ImgPath = "images/I6_White.jpeg"; lt1.Price = "$200.0"; lt1.OfferPrice = "$190.0"; lt1.Views = 120; lt1.TotalNoOfPurchases = 20; lt1.Description = "SUper Nateral Phone ...................... Random text................."; lstProd.Add(lt1); Product lt2 = new Product(); productKey = productKey + 1; lt2.ID = productKey; lt2.Make = "Apple"; lt2.Model = "I Phone 5"; lt2.Color = "Gold"; lt2.Specs = "2 GB RAM"; lt2.ImgPath = "images/I6_Gold.jpg"; lt2.Price = "$200.0"; lt2.OfferPrice = "$190.0"; lt2.Views = 80; lt2.TotalNoOfPurchases = 10; lt2.Description = "SUper Nateral Phone ...................... Random text................."; lstProd.Add(lt2); return lstProd; }
public string IncrementCounter(Product value) { var Product = InitData.lstProducts.Where(kvp => kvp.ID == value.ID && kvp.Promo == value.Promo).Select(x => x).ToArray(); if (Product != null && Product.Length == 1) { Product[0].Views = Product[0].Views + 1; } return "OK"; }
public bool PutProduct(Product product) { throw new NotImplementedException(); }