public ShowProduct(Products selectedProducts)
{
InitializeComponent();
productCRUD = new ProductCRUD();
selproducts = selectedProducts;
BindingContext = selproducts;
}
public static string PriceOfSelectedHoney(string selectedHoney)
{
if (selectedHoney != "--Вибрати мед--")
{
ProductCRUD productCrud = new ProductCRUD();
Product product = productCrud.GetList()
.Where(x => x.Name == selectedHoney)
.FirstOrDefault();
if (product.Discount != 0)
{
product.Cost = product.Cost - (product.Cost * product.Discount / 100);
}
//if (product.Remains < 0.5)
//{
// product.Remains = 0;
//}
string jsonProduct = new JavaScriptSerializer().Serialize(product);
return jsonProduct;
}
else
{
Product defaultProduct = new Product();
defaultProduct.Name = "--Вибрати мед--";
string jsonDefaultProduct = new JavaScriptSerializer().Serialize(defaultProduct);
return jsonDefaultProduct;
}
}
public JsonResult Edit(ProductCRUD model)
{
rs r;
using (var trans = new TransactionScope())
{
try
{
List <BangGiaCT> gias = new List <BangGiaCT>();
foreach (var item in model.BangGiaCT)
{
if (item.Price.HasValue && item.Price > 0)
{
gias.Add(new BangGiaCT()
{
ProductId = model.Id,
Ten = item.Ten,
Price = item.Price ?? 0,
});
}
}
var entity = __db.Product.Find(model.Id);
entity.ProductCatId = model.ProductCatId;
//entity.ProductCatId2 = model.ProductCatId2 == -1 ? null : model.ProductCatId2;
entity.ProductName = model.ProductName;
entity.Price = model.Price;
if (string.IsNullOrWhiteSpace(model.ThumbnailImage))
{
entity.ThumbnailImage = "/Content/images/sample/product.png";
}
else
{
entity.ThumbnailImage = model.ThumbnailImage;
}
entity.Infomation = model.Infomation;
entity.IsGiamGia = model.IsGiamGia;
entity.Hot = model.Hot;
entity.New = model.New;
entity.SoLuongGia = gias.Count;
__db.SaveChanges();
var remove_child = entity.BangGiaCT;
__db.BangGiaCT.RemoveRange(remove_child.ToList());
__db.SaveChanges();
__db.BangGiaCT.AddRange(gias);
__db.SaveChanges();
trans.Complete();
r = rs.T("Okay");
}
catch (Exception ex)
{
r = rs.F("Lỗi: " + ex.Message);
}
}
return(Json(r, JsonRequestBehavior.DenyGet));
}
// GET: Admin/Products/Edit/5
public ActionResult Edit(int id)
{
Product entity = _ProductServ.GetEntry(id);
ProductCRUD vm = new ProductCRUD();
vm.Id = entity.Id;
vm.MaSP = entity.MaSP;
vm.ProductName = entity.ProductName;
vm.ThumbnailImage = entity.ThumbnailImage;
vm.Price = entity.Price ?? 0;
vm.Infomation = entity.Infomation;
vm.ProductCatId = entity.ProductCatId;
vm.MainProduct = entity.MainProduct;
vm.ConHang = entity.ConHang;
vm.IsBanChay = entity.IsBanChay;
if (entity.ImgTmpId == null)
{
vm.ImgTmpId = _imgTmpServ.Create();
}
else
{
vm.ImgTmpId = entity.ImgTmpId;
}
return(View(vm));
}
public void btnReserve_Click(object sender, EventArgs e)
{
ProductCRUD productCrud = new ProductCRUD();
CustomCRUD customCrud = new CustomCRUD();
customCrud.Add(new Custom
{
Name = txtName.Text,
Amount = Convert.ToDouble(txtAmount.Text),
Email = txtEmail.Text,
HoneyType = drpHoney.SelectedItem.Text,
Number = Convert.ToInt64(txtNumber.Text),
PurchaseDate = DateTime.Now
});
bool result = productCrud.UpdateByName(new Custom
{
HoneyType = drpHoney.SelectedItem.Text,
Amount = Convert.ToDouble(txtAmount.Text)
});
if (result == true)
{
Response.Redirect("~/Default.aspx?IsSuccess=SuccessPurchase");
}
else
{
Response.Redirect("~/Default.aspx?IsSuccess=ErrorPurchase");
}
}
public EditProduct(Products SelectedProduct)
{
InitializeComponent();
productCRUD = new ProductCRUD();
SelProduct = SelectedProduct;
BindingContext = SelProduct;
}
static async Task Main(string[] args)
{
var productRepo = new ProductCRUD();
var customerRepo = new CustomerCRUD();
var orderRepo = new OrderCRUD();
var userModels = db.Get();
}
// GET: Admin/Products/Create
public ActionResult Create(int catid, int quanid)
{
ProductCRUD vm = new ProductCRUD();
vm.ProductCatId = catid;
vm.ProductCat = __db.ProductCat.Find(catid);
return(View(vm));
}
// GET: Admin/Products/Create
public ActionResult Create()
{
ProductCRUD vm = new ProductCRUD();
vm.ImgTmpId = this._imgTmpServ.Create();
vm.ConHang = true;
return(View(vm));
}
public JsonResult Create(ProductCRUD model)
{
rs r;
try
{
Product entity = new Product();
entity.ProductName = model.ProductName;
entity.Price = model.Price;
entity.Infomation = model.Infomation;
entity.ProductCatId = model.ProductCatId;
// entity.ProductCatId2 = model.ProductCatId2 == -1 ? null : model.ProductCatId2;
entity.IsGiamGia = model.IsGiamGia;
entity.Hot = model.Hot;
entity.New = model.New;
if (string.IsNullOrWhiteSpace(model.ThumbnailImage))
{
entity.ThumbnailImage = "/Content/images/sample/product.png";
}
else
{
entity.ThumbnailImage = model.ThumbnailImage;
}
List <BangGiaCT> gias = new List <BangGiaCT>();
foreach (var item in model.BangGiaCT)
{
if (item.Price.HasValue && item.Price > 0)
{
gias.Add(new BangGiaCT()
{
Ten = item.Ten,
Price = item.Price ?? 0,
});
}
}
if (gias.Any())
{
entity.BangGiaCT = gias;
}
entity.SoLuongGia = gias.Count;
__db.Product.Add(entity);
__db.SaveChanges();
r = rs.T("Okay");
}
catch (Exception ex)
{
r = rs.F("Lỗi: " + ex.Message);
}
return(Json(r, JsonRequestBehavior.DenyGet));
}
// GET: Admin/Products/Edit/5
public ActionResult Edit(int id)
{
Product entity = _ProductServ.GetEntry(id);
ProductCRUD vm = new ProductCRUD();
vm.Id = entity.Id;
vm.ProductName = entity.ProductName;
vm.Price = entity.Price;
vm.Infomation = entity.Infomation;
vm.ProductCatId = entity.ProductCatId;
//vm.ProductCatId2 = entity.ProductCatId2 == -1 ? null : entity.ProductCatId2;
vm.IsGiamGia = entity.IsGiamGia;
vm.Hot = entity.Hot;
vm.New = entity.New;
if (string.IsNullOrWhiteSpace(entity.ThumbnailImage))
{
vm.ThumbnailImage = "/Content/images/sample/product.png";
}
else
{
vm.ThumbnailImage = entity.ThumbnailImage;
}
vm.BangGiaCT = new List <BangGiaCTCRUD>();
var BangGiaCT_entity = entity.BangGiaCT.ToList();
vm.SoLuongEdit = BangGiaCT_entity.Count;
for (var i = 0; i < 10; i++)
{
if (i + 1 <= BangGiaCT_entity.Count)
{
vm.BangGiaCT.Add(new BangGiaCTCRUD()
{
Id = BangGiaCT_entity[i].Id,
Ten = BangGiaCT_entity[i].Ten,
Price = BangGiaCT_entity[i].Price
});
}
else
{
vm.BangGiaCT.Add(new BangGiaCTCRUD()
{
Id = -1,
Ten = "",
Price = null
});
}
}
return(View(vm));
}
public JsonResult Create(ProductCRUD model)
{
rs r;
try
{
var findThumbs = __db.ImgTmp.Find(model.ImgTmpId);
Product entity = new Product();
entity.MaSP = model.MaSP;
entity.ProductName = model.ProductName;
entity.ThumbnailImage = model.ThumbnailImage;
entity.Price = model.Price;
entity.Infomation = model.Infomation;
entity.ProductCatId = model.ProductCatId;
entity.MainProduct = model.MainProduct;
entity.ImgTmpId = model.ImgTmpId;
entity.ConHang = model.ConHang;
entity.IsBanChay = model.IsBanChay;
//first thumbs
if (findThumbs.ImgTmpDetails.Any())
{
var firstOrDefault = findThumbs.ImgTmpDetails.FirstOrDefault(f => f.IsMain);
if (firstOrDefault == null)
{
firstOrDefault = findThumbs.ImgTmpDetails.FirstOrDefault();
if (firstOrDefault != null)
{
entity.ThumbnailImage = firstOrDefault.Thumbnail;
}
else
{
entity.ThumbnailImage = "http://file.qdnd.vn/image/images/noimages.png";
}
}
else
{
entity.ThumbnailImage = firstOrDefault.Thumbnail;
}
}
__db.Product.Add(entity);
__db.SaveChanges();
r = rs.T("Okay");
}
catch (Exception ex)
{
r = rs.F("Lỗi: " + ex.Message);
}
return(Json(r, JsonRequestBehavior.DenyGet));
}
public Stocks()
{
InitializeComponent();
productCRUD = new ProductCRUD();
products = new Products();
var productlist = productCRUD.GetProductList();
ProductlistView.ItemsSource = productlist;
}
public EditSales(Model.Sales Selectedsales)
{
InitializeComponent();
salesCRUD = new SalesCRUD();
productCRUD = new ProductCRUD();
SelSales = Selectedsales;
var productlist = productCRUD.GetProductNameList();
picker_product.ItemsSource = productlist;
BindingContext = SelSales;
}
public JsonResult Edit(ProductCRUD model)
{
rs r;
using (var trans = new TransactionScope())
{
try
{
var findThumbs = __db.ImgTmp.Find(model.ImgTmpId);
var entity = _ProductServ.SingleOrDefault(s => s.Id == model.Id);
entity.MaSP = model.MaSP;
entity.ProductCatId = model.ProductCatId;
entity.ProductName = model.ProductName;
entity.Price = model.Price;
entity.ImgTmpId = model.ImgTmpId;
entity.Infomation = model.Infomation;
entity.MainProduct = model.MainProduct;
entity.ConHang = model.ConHang;
entity.IsBanChay = model.IsBanChay;
//first thumbs
if (findThumbs.ImgTmpDetails.Any())
{
var firstOrDefault = findThumbs.ImgTmpDetails.FirstOrDefault(f => f.IsMain);
if (firstOrDefault == null)
{
firstOrDefault = findThumbs.ImgTmpDetails.FirstOrDefault();
if (firstOrDefault != null)
{
entity.ThumbnailImage = firstOrDefault.Thumbnail;
}
else
{
entity.ThumbnailImage = "http://file.qdnd.vn/image/images/noimages.png";
}
}
else
{
entity.ThumbnailImage = firstOrDefault.Thumbnail;
}
}
_ProductServ.Save();
trans.Complete();
r = rs.T("Okay");
}
catch (Exception ex)
{
r = rs.F("Lỗi: " + ex.Message);
}
}
return(Json(r, JsonRequestBehavior.DenyGet));
}
//=============================================
// Reference A3: externally sourced algorithm
// Purpose: get Product list in picker in sales tab
// Date: 22 Sep 2018
// Source: Microsoft docs
// Author: unknown
// url: https://docs.microsoft.com/en-us/xamarin/xamarin-forms/user-interface/picker/populating-itemssource
// Adaptation required: changed variable name //
public Sales()
{
InitializeComponent();
productCRUD = new ProductCRUD();
products = new Products();
sales = new Model.Sales();
salesCRUD = new SalesCRUD();
var productlist = productCRUD.GetProductNameList();
picker_product.ItemsSource = productlist;
}
protected void Page_Load(object sender, EventArgs e)
{
ProductCRUD productCRUD = new ProductCRUD();
products = productCrud.GetList();
if (!IsPostBack)
{
for (int i = 0; i < products.Count; i++)
{
ListItem listItemName = new ListItem(products[i].Name, products[i].Id.ToString());
drpHoney.Items.Add(listItemName);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
ProductCRUD priceCrud = new ProductCRUD();
List<Product> prices = priceCrud.GetList()
.Where(x => x.IsDefault == false)
.ToList();
Product IsDefault = priceCrud.GetList()
.Where(x => x.IsDefault == true)
.FirstOrDefault();
if (IsDefault != null)
{
prices.Add(IsDefault);
prices.Reverse();
}
rptPrices.DataSource = prices;
rptPrices.DataBind();
}
public void btnSubmit_Click(object sender, EventArgs e)
{
ProductCRUD productCRUD = new ProductCRUD();
DateTime.TryParse(txtDataTime.Text, out dataTime);
if (PageID == 0)
{
int result = productCRUD.Add(new Product
{
Cost = Convert.ToInt32(txtbxPrice.Text),
Id = new ProductCRUD().GetNextNumber(),
Name = txtbxName.Text,
ProductedDate=dataTime,
Recived = Convert.ToDouble(txtbxRecived.Text),
Remains = Convert.ToDouble(txtbxRemains.Text),
Discount = Convert.ToInt32(listDiscount.SelectedValue),
IsDefault = chckDefault.Checked
});
Response.Redirect("~/Products.aspx");
}
else
{
productCRUD.Update(new Product
{
Cost = Convert.ToInt32(txtbxPrice.Text),
Id = PageID,
Name = txtbxName.Text,
Recived = Convert.ToDouble(txtbxRecived.Text),
ProductedDate=dataTime,
Remains = Convert.ToDouble(txtbxRemains.Text),
Discount = Convert.ToInt32(listDiscount.SelectedValue),
IsDefault = chckDefault.Checked
});
Response.Redirect("~/Products.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
ProductCRUD productCrud = new ProductCRUD();
if (!IsPostBack && PageID != 0)
{
Product product = productCrud.GetList()
.Where(x => x.Id == PageID)
.FirstOrDefault();
txtbxName.Text = product.Name;
txtbxPrice.Text = product.Cost.ToString();
txtbxRecived.Text = product.Recived.ToString();
txtDataTime.Text = product.ProductedDate.ToShortDateString();
txtbxRemains.Text = product.Remains.ToString();
listDiscount.SelectedValue = product.Discount.ToString();
chckDefault.Checked = product.IsDefault;
}
else if (!IsPostBack && PageID == 0)
{
txtDataTime.Text = DateTime.Now.ToShortDateString();
}
if (DeleteID != 0)
{
productCrud.Delete(DeleteID);
Response.Redirect("~/Products.aspx");
}
}
public Product()
{
InitializeComponent();
productCRUD = new ProductCRUD();
products = new Products();
}
