public IHttpActionResult GetDatHangs(int idStore, int idUser, string address, int tongTien, string jonListProduct)
{
// taiKhoan = "*****@*****.**"
// pass = "******"
var listProducts = JsonConvert.DeserializeObject <List <ModelProducts> >(jonListProduct);
int lenListProduct = listProducts.Count();
var exProc = db.Database.SqlQuery <int>("exec DonHang_Insert @idStore, @idUser, @ThoiGian, @DiaChi, @TongTien",
new SqlParameter("idStore", idStore),
new SqlParameter("idUser", idUser),
new SqlParameter("ThoiGian", DateTime.Now),
new SqlParameter("DiaChi", address),
new SqlParameter("TongTien", tongTien)
)
.ToArray();
//IEnumerable<string> result = res;
int idDonHang = exProc[0];
int i;
for (i = 0; i < lenListProduct; i++)
{
ModelProducts item = listProducts[i];
db.Database.ExecuteSqlCommand("exec DatHang_Insert @iddonhang, @idMonAn, @count",
new SqlParameter("iddonhang", idDonHang),
new SqlParameter("idMonAn", item.id),
new SqlParameter("count", item.count));
}
string json = "{\"status\": 0}";
return(Ok(json));
}
public List <ModelProducts> Map(List <DataProducts> allProducts)
{
List <ModelProducts> returnProducts = new List <ModelProducts>();
foreach (DataProducts dProduct in allProducts)
{
ModelProducts product = new ModelProducts();
product.ProductID = dProduct.ProductID;
product.SupplierID = dProduct.SupplierID;
product.CategoryID = dProduct.CategoryID;
product.BrandID = dProduct.BrandID;
product.ProductName = dProduct.ProductName;
product.RetailPrice = dProduct.RetailPrice;
product.WholeSalePrice = dProduct.WholeSalePrice;
product.OnSale = dProduct.OnSale;
product.Quantity = dProduct.Quantity;
product.Color = dProduct.Color;
product.Description = dProduct.Description;
product.ProductCreateDate = dProduct.ProductCreateDate;
product.ProductPhotoURL = dProduct.ProductPhotoURL;
//
returnProducts.Add(product);
}
return(returnProducts);
}
public ProductsViewModel()
{
SingleProduct = new ModelProducts();
AllProducts = new List <ModelProducts>();
CategoryProducts = new List <ModelProducts>();
BrandProducts = new List <ModelProducts>();
OnSaleProducts = new List <ModelProducts>();
FeedProducts = new List <ModelProducts>();
AllSuppliers = new List <ModelSuppliers>();
AllBrands = new List <ModelBrands>();
AllCategories = new List <ModelCategories>();
}
public ActionResult Home()
{
List <HighestStarproduct> modelHighestStar = new List <HighestStarproduct>();
List <BestDiscountedProduct> modelBestDiscounteds = new List <BestDiscountedProduct>();
List <NewProduct> modelNewProducts = new List <NewProduct>();
List <ProductWithBestSelling> modelproductWithBestSellings = new List <ProductWithBestSelling>();
modelHighestStar = db.HighestStarproduct.ToList();
modelBestDiscounteds = db.BestDiscountedProduct.ToList();
modelNewProducts = db.NewProduct.ToList();
modelproductWithBestSellings = db.ProductWithBestSelling.ToList();
ModelProducts modelProducts = new ModelProducts();
modelProducts.modelHighestStar = modelHighestStar;
modelProducts.modelNewProducts = modelNewProducts;
modelProducts.modelDiscounteds = modelBestDiscounteds;
modelProducts.modelProductWithBestSelling = modelproductWithBestSellings;
return(View(modelProducts));
}
public string getProduct(string id)
{
ModelProducts obj = new ModelProducts();
DataTable dt = obj.getProductDetails(!string.IsNullOrEmpty(id) ? Convert.ToInt32(Cryptography.Decrypt(id, true)) : 0);
dt.Columns.Add("encryptedID", typeof(string));
dt.Columns.Add("encryptedID_Category", typeof(string));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["encryptedID"] = Cryptography.Encrypt(dt.Rows[i]["productID"].ToString(), true);
dt.Rows[i]["encryptedID_Category"] = Cryptography.Encrypt(dt.Rows[i]["categoryID"].ToString(), true);
}
dt.AcceptChanges();
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
jsSerializer.MaxJsonLength = Int32.MaxValue;
var lst = dt.AsEnumerable().Select(r => r.Table.Columns.Cast <DataColumn>().Select(c => new KeyValuePair <string, object>(c.ColumnName, r[c.Ordinal])).ToDictionary(z => z.Key, z => z.Value)).ToList();
return(jsSerializer.Serialize(lst));
}
public void add(Product product)
{
if (product == null)
{
throw new ArgumentNullException();
}
ListViewItem item = new ListViewItem("");
item.SubItems.Add(listView.Items.Count.ToString());
if (product.getImage() != "")
{
imageList.Images.Add(Image.FromFile(product.getImage()));
item.ImageIndex = imageList.Images.Count - 1;
}
item.SubItems.Add(product.getName());
item.SubItems.Add(product.getDescription());
item.SubItems.Add(product.getPrice());
listView.Items.Add(item);
ModelProducts.Instance().addProduct(product);
}
public IHttpActionResult GetDatHangs([FromBody] ModelOrder order)
{
// taiKhoan = "*****@*****.**"
// pass = "******"
////JObject json = JObject.Parse(order.products);
//JArray ps = (JArray)json.GetValue("products");
//int total = (int)json.GetValue("total");]
List <InforOrder> listOrder = order.products;
int tong = order.total;
var exProc = db.Database.SqlQuery <int>("exec DonHang_Insert @idStore, @idUser, @ThoiGian, @DiaChi, @TongTien",
new SqlParameter("idStore", order.idStore),
new SqlParameter("idUser", order.idUser),
new SqlParameter("ThoiGian", DateTime.Now),
new SqlParameter("DiaChi", order.address),
new SqlParameter("TongTien", tong)
)
.ToArray();
//IEnumerable<string> result = res;
int idDonHang = exProc[0];
foreach (InforOrder item in listOrder)
{
ModelProducts model = new ModelProducts();
model.id = item.id;
model.count = item.count;
db.Database.ExecuteSqlCommand("exec DatHang_Insert @iddonhang, @idMonAn, @count",
new SqlParameter("iddonhang", idDonHang),
new SqlParameter("idMonAn", model.id),
new SqlParameter("count", model.count));
}
JObject res = new JObject();
res["status"] = 0;
return(Ok(res.ToString()));
}
public ListProductsView(ListView list)
{
ModelProducts.Instance();
listView = list;
comNumber = new ColumnHeader();
ComImage = new ColumnHeader();
ComName = new ColumnHeader();
ComDescription = new ColumnHeader();
ComPrice = new ColumnHeader();
imageList = new ImageList();
imageList.ImageSize = new Size(50, 50);
listView.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
comNumber,
ComImage,
ComName,
ComDescription,
ComPrice
});
comNumber.Text = "Obraz";
comNumber.TextAlign = HorizontalAlignment.Center;
comNumber.Width = 75;
ComImage.Text = "Nr.";
ComImage.TextAlign = HorizontalAlignment.Center;
comNumber.Width = 50;
ComName.Text = "Nazwa";
ComName.TextAlign = HorizontalAlignment.Center;
ComDescription.Text = "Opis";
ComDescription.TextAlign = HorizontalAlignment.Center;
ComPrice.Text = "Cena";
ComPrice.TextAlign = HorizontalAlignment.Center;
comNumber.Width = 50;
listView.SmallImageList = imageList;
}
public ActionResult deleteProduct(string productID)
{
ModelProducts obj = new ModelProducts();
string message = string.Empty;
try
{
int result = obj.deleteProductDetails(Convert.ToInt32(Cryptography.Decrypt(productID, true)));
if (result != -1)
{
message = "SUCCESS";
}
else
{
message = "ERROR: Error occurred while deleting record!";
}
}
catch (Exception ex)
{
message = "ERROR: " + ex.Message + " --> " + ex.InnerException;
}
return(Json(new { Message = message, JsonRequestBehavior.AllowGet }));
}
public DataProducts Map(ModelProducts mProduct)
{
DataProducts returnProduct = new DataProducts();
returnProduct.ProductID = mProduct.ProductID;
returnProduct.ProductName = mProduct.ProductName;
returnProduct.SupplierID = mProduct.SupplierID;
returnProduct.SupplierName = mProduct.SupplierName;
returnProduct.CategoryID = mProduct.CategoryID;
returnProduct.CategoryName = mProduct.CategoryName;
returnProduct.BrandID = mProduct.BrandID;
returnProduct.BrandName = mProduct.BrandName;
returnProduct.RetailPrice = mProduct.RetailPrice;
returnProduct.WholeSalePrice = mProduct.WholeSalePrice;
returnProduct.OnSale = mProduct.OnSale;
returnProduct.Quantity = mProduct.Quantity;
returnProduct.Color = mProduct.Color;
returnProduct.Description = mProduct.Description;
returnProduct.ProductCreateDate = mProduct.ProductCreateDate;
returnProduct.ProductPhotoURL = mProduct.ProductPhotoURL;
returnProduct.BrandPhotoURL = mProduct.BrandPhotoURL;
return(returnProduct);
}
internal void Clear()
{
ModelProducts.Instance().Clear();
listView.Items.Clear();
imageList.Images.Clear();
}
