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();
}
