public ActionResult AddProduct(ClassProduct a, Image imageModel, HttpPostedFileBase ImageFile)
{
ComputerShopEntities data = new ComputerShopEntities();
InfoProduct b = new InfoProduct();
b.Name = a.Name;
b.Price = a.price;
b.Description = a.description;
b.idProductType = a.idProduct;
data.InfoProducts.Add(b);
data.SaveChanges();
imageModel.idProduct = b.Id;
imageModel.Title = b.Name;
string fileName = Path.GetFileNameWithoutExtension(ImageFile.FileName);
string extension = Path.GetExtension(ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
imageModel.ImagePath = fileName;
fileName = Path.Combine(Server.MapPath("~/img/"), fileName);
ImageFile.SaveAs(fileName);
using (ComputerShopEntities db = new ComputerShopEntities())
{
db.Images.Add(imageModel);
db.SaveChanges();
ViewBag.a = "Thêm sản phẩm thành cống";
}
ModelState.Clear();
return(View());
}
public IEnumerator GetData(GameObject Product)
{
ClassProduct CP = Product.GetComponent <ClassProduct> ();
WWW www = new WWW("http://mmahgoub-001-site1.htempurl.com/WebService.asmx/GetProductXml?ProductID=" + CP.PID.ToString());
yield return(www);
string text = www.text;
XmlDocument Doc = new XmlDocument();
try {
Doc.LoadXml(text);
XmlNodeList node = Doc.GetElementsByTagName("Product");
CP.Quantity_In_Stock = node [0].ChildNodes.Item(0).InnerText.Trim();
CP.Name = node [0].ChildNodes.Item(1).InnerText.Trim();
CP.shop = node [0].ChildNodes.Item(2).InnerText.Trim();
CP.Description = node [0].ChildNodes.Item(3).InnerText.Trim();
CP.Unit_Price = node [0].ChildNodes.Item(4).InnerText.Trim();
} catch (XmlException e) {
print(e.Message);
}
Canv.transform.GetChild(0).GetChild(0).GetComponent <Text> ().text = CP.Name;
Canv.transform.GetChild(0).GetChild(1).GetComponent <Text> ().text = CP.Description;
Canv.transform.GetChild(0).GetChild(2).GetComponent <Text> ().text = CP.Unit_Price;
Canv.transform.GetChild(0).GetChild(3).GetComponent <Image> ().sprite = CP.PSprite;
}
void SendSelectedProduct()
{
if (LastProductClicked != null)
{
ClassProduct CP = LastProductClicked.GetComponent <ClassProduct> ();
WWW www = new WWW("http://mmahgoub-001-site1.htempurl.com/WebService.asmx/SelectedProduct?userID=" + UserID + "&productID=" + CP.PID.ToString());
}
}
public async Task <IActionResult> Add([Bind("ClassId,Name,BusinessEntityId")] ClassProduct classProduct, bool continueAdd)
{
if (ModelState.IsValid)
{
await _classProductServices.AddAsync(classProduct);
return(continueAdd ? RedirectToAction(nameof(Add)) : RedirectToAction(nameof(List)));
}
return(View(classProduct));
}
public Provider MyProvider; // Структура описывающая поставщика товара
public Product(int count, decimal idProd, double cost, ClassProduct typePr, char value, Provider provider)
{
Count = count;
IdProduct = idProd;
Cost = cost;
Presence = Count > 0 ? true : false;
TypeClassProduct = typePr;
Value = value;
MyProvider = provider;
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtIMGid.Text.Equals("") && picImage.Image != null)
{
int addIMG = ClassProduct.insertIMG(arr, int.Parse(ProID));
dt = ClassManagmentReport.displayAllIMGForPro(int.Parse(ProID));
MessageBox.Show("Done . .");
numOfImag = dt.Rows.Count;
btnFirstIMG_Click(null, null);
}
}
catch (Exception) { }
}
public ActionResult Edit(ClassProduct a, Image imageModel, HttpPostedFileBase ImageFile)
{
ComputerShopEntities data = new ComputerShopEntities();
var u = data.InfoProducts.Where(x => x.Id == a.id).FirstOrDefault();
var y = data.Images.Where(k => k.idProduct == a.id).FirstOrDefault();
if (u != null)
{
if (y != null)
{
data.Images.Remove(y);
}
data.InfoProducts.Remove(u);
data.SaveChanges();
}
InfoProduct b = new InfoProduct();
b.Name = a.Name;
b.Price = a.price;
b.Description = a.description;
b.idProductType = a.idProduct;
data.InfoProducts.Add(b);
data.SaveChanges();
imageModel.idProduct = b.Id;
imageModel.Title = b.Name;
string fileName = Path.GetFileNameWithoutExtension(ImageFile.FileName);
string extension = Path.GetExtension(ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
imageModel.ImagePath = fileName;
fileName = Path.Combine(Server.MapPath("~/img/"), fileName);
ImageFile.SaveAs(fileName);
using (ComputerShopEntities db = new ComputerShopEntities())
{
db.Images.Add(imageModel);
db.SaveChanges();
ViewBag.a = "Sửa thành công";
}
ModelState.Clear();
return(View());
}
public async Task <IActionResult> Edit(int id, [Bind("ClassId,Name,BusinessEntityId")] ClassProduct classProduct, bool continueAdd)
{
if (id != classProduct.ClassId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
await _classProductServices.UpdateAsync(classProduct);
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(continueAdd ? RedirectToAction(nameof(Edit), new { id = classProduct.ClassId }) : RedirectToAction(nameof(List)));
}
return(View(classProduct));
}
public ActionResult Product(ClassProduct b)
{
if (Session["SignIn"] == null)
{
return(RedirectToAction("SignUp", "MainProcess"));
}
else
{
User kq = (User)Session["SignIn"];
if (kq.role == "admin")
{
ComputerShopEntities data = new ComputerShopEntities();
var a = from x in data.InfoProducts select x;
return(View(a));
}
else
{
return(RedirectToAction("ThongBao", new { tenaction = "Contact" }));
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
int found = 0;
if (txtname.Text.Equals(""))
{
MessageBox.Show("Please insert product name .");
}
else
{
DataTable ProName = ClassProduct.selectOnePro(txtbarcode.Text);
if (ProName.Rows.Count > 0 && !ProName.Rows[0][0].ToString().Equals(ProID.ToString()))
{
found = 1; MessageBox.Show("This Product or Barcode Already Exist . .");
}
}
if (found == 0)
{
int i = ClassManagmentReport.updatePro(ProID, txtname.Text, txtbarcode.Text, txtCategory.Text, txtCountry.Text, txtcity.Text, txtCompany.Text, "0", "0", "0", rtxtdiscrp.Text, rtxtnote.Text);
txtname.Text = txtbarcode.Text = txtCategory.Text = txtCountry.Text = txtcity.Text = txtCompany.Text = rtxtdiscrp.Text = rtxtnote.Text = "";
MessageBox.Show("Done. .");
}
this.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
btnSave.Enabled = false;
int found = 0;
if (txtname.Text.Equals(""))
{
MessageBox.Show("Please Insert Product Name ! ");
}
else
{
DataTable ProName = ClassProduct.selectOnePro(txtbarcode.Text);
if (ProName.Rows.Count > 0)
{
found = 1; MessageBox.Show("This Product or Barcode Already Exist . .");
}
if (found == 0)
{
int product = ClassProduct.insertPro(txtname.Text, txtbarcode.Text, txtCategory.Text, txtCountry.Text, txtcity.Text, txtCompany.Text, "0", "0", "0", rtxtdiscrp.Text, rtxtnote.Text);
if (NumOfImage > 0)
{
DataTable LastOne = ClassProduct.LastPro();
for (int i = 0; i < images.Count; i++)
{
int AddImg = ClassProduct.insertIMG(images[i], int.Parse(LastOne.Rows[0][0].ToString()));
}
}
txtname.Text = txtbarcode.Text = txtCategory.Text = txtCountry.Text = txtcity.Text = txtCompany.Text = rtxtdiscrp.Text = rtxtnote.Text = "";
lbNumIMG.Text = "0";
NumOfImage = 0;
images.Clear();
MessageBox.Show("Done. .");
}
}
btnSave.Enabled = true;
}
public IActionResult Add()
{
var data = new ClassProduct();
return(View(data));
}
public async Task <IActionResult> Delete(ClassProduct classProduct)
{
await _classProductServices.DeleteAsync(classProduct);
return(RedirectToAction(nameof(List)));
}
public List <SqlParameter> SetParameters(ClassProduct datos)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@p1", SqlDbType = SqlDbType.NVarChar, Value = datos.Product_id
},
new SqlParameter()
{
ParameterName = "@p2", SqlDbType = SqlDbType.NVarChar, Value = datos.ProductName
},
new SqlParameter()
{
ParameterName = "@p3", SqlDbType = SqlDbType.NVarChar, Value = datos.Descripcion
},
new SqlParameter()
{
ParameterName = "@p4", SqlDbType = SqlDbType.NVarChar, Value = datos.Referencia
},
new SqlParameter()
{
ParameterName = "@p5", SqlDbType = SqlDbType.NVarChar, Value = datos.Codebar
},
new SqlParameter()
{
ParameterName = "@p6", SqlDbType = SqlDbType.NVarChar, Value = datos.Categoria
},
new SqlParameter()
{
ParameterName = "@p7", SqlDbType = SqlDbType.Bit, Value = datos.MasterRolls
},
new SqlParameter()
{
ParameterName = "@p8", SqlDbType = SqlDbType.Bit, Value = datos.Rollo_Cortado
},
new SqlParameter()
{
ParameterName = "@p9", SqlDbType = SqlDbType.Bit, Value = datos.Resmas
},
new SqlParameter()
{
ParameterName = "@p10", SqlDbType = SqlDbType.Bit, Value = datos.Graphics
},
new SqlParameter()
{
ParameterName = "@p11", SqlDbType = SqlDbType.Bit, Value = datos.Anulado
},
new SqlParameter()
{
ParameterName = "@p12", SqlDbType = SqlDbType.Decimal, Value = datos.Precio
},
new SqlParameter()
{
ParameterName = "@p13", SqlDbType = SqlDbType.NVarChar, Value = datos.Code_RC
},
new SqlParameter()
{
ParameterName = "@p14", SqlDbType = SqlDbType.Decimal, Value = datos.Ratio
}
};
return(sp);
}
public void Update(ClassProduct datos)
{
CommandSqlGeneric(R.SQL.DATABASE.NAME, R.SQL.QUERY_SQL.PRODUCTS.SQL_QUERY_UPDATE_PRODUCTS,
SetParameters(datos), true, R.ERROR_MESSAGES.MODULO_PRODUCTOS.MESSAGE_UPDATE_PRODUCTS_ERROR);
}
public void Add(ClassProduct datos, Boolean mensajeok)
{
CommandSqlGeneric(R.SQL.DATABASE.NAME, R.SQL.QUERY_SQL.PRODUCTS.SQL_QUERY_INSERT_PRODUCT,
SetParameters(datos), mensajeok, R.ERROR_MESSAGES.MODULO_PRODUCTOS.MESSAGE_ADD_PRODUCTS_ERROR);
}
