public string add(string pn, string url, string des, decimal p)
{
try
{
product = new tblProduct();
product.price = p;
product.proname = pn;
product.descr = des;
product.url_img = url;
dbhandller.tblProducts.InsertOnSubmit(product);
dbhandller.SubmitChanges();
return "Save Record";
}
catch (Exception e)
{
return e.Message;
}
}
public ActionResult Edit([Bind(Include = "productId,name,quantity,price,sale,detail,categoryId")] tblProduct tblProduct, HttpPostedFileBase img)
{
if (ModelState.IsValid)
{
var fileName = "";
var path = "";
if (img != null)
{
fileName = img.FileName;
path = Path.Combine(Server.MapPath("~/Content/image"), fileName);
img.SaveAs(path);
tblProduct.img = "/Content/image/" + fileName;
}
db.Entry(tblProduct).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.categoryId = new SelectList(db.tblCategories, "categoryId", "name", tblProduct.categoryId);
return(View(tblProduct));
}
/// <summary>
/// Return Product By Specific ID
/// </summary>
/// <param name="id">Product ID</param>
/// <returns>Product By Specific ID Or null If Exist Error</returns>
public static Tuple <ErrorObject, tblProduct> GetProduct(int id)
{
tblProduct data = new tblProduct();
erros = new ErrorObject();
try
{
using (HSCMEntities db = new HSCMEntities())
{
data = db.tblProduct.Find(id);
}
erros.Error = false;
return(new Tuple <ErrorObject, tblProduct>(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, tblProduct>(erros, data));
}
}
//prijs opvragen
public double getPrijs(tblProduct product)
{
using (var db = new scriptEntities())
{
if (isHotel(product)) //check hotel of traject
{
return(db.tblHotel.Where(a => a.HotelID == product.HotelID).FirstOrDefault().PrijsPerOvernachting); //Prijs per overnachting
}
else
{
if (product.Treinklasse == 1)
{
return(db.tblTraject.Where(b => b.TrajectID == product.TrajectID).FirstOrDefault().BusinessPrijs);//businessprijs
}
else
{
return(db.tblTraject.Where(b => b.TrajectID == product.TrajectID).FirstOrDefault().EconomicPrijs);//economicprijs
}
}
}
}
public bool ProcessProductAddedDocument(tblProduct product)
{
string url = product.Url;
bool urlExists = _urlFileService.URLExists(url);
if (urlExists)
{
byte[] urlFileData = _urlFileService.ReadUrlFileData(url);
tblProductDocument productDocument = new tblProductDocument
{
tblProduct = product,
DocumentContent = urlFileData,
LastModifiedDate = DateTime.Today
};
_productDocumentRepository.Add(productDocument);
}
return(urlExists);
}
//void Combo()
//{
// cbSehir.DataSource = _db.tblCities;
// cbSehir.ValueMember = "ID";
// cbSehir.DisplayMember = "City";
// cbSehir.SelectedIndex = 33;
//}
void YeniKaydet()
{
try
{
tblProduct pro = new tblProduct();
pro.CategoryID = _db.tblCategories.First(x => x.CategoryName == txtKategori.Text).ID;
pro.ProNo = int.Parse(txtUsiraNo.Text);
pro.Name = txtUadi.Text;
pro.Note = txtNot.Text;
pro.UnitPrice = decimal.Parse(txtBirimFiyat.Text);
_db.tblProducts.InsertOnSubmit(pro);
_db.SubmitChanges();
_m.YeniKayit("Kayıt başarıyla gerçekleşti.");
Temizle();
}
catch (Exception e)
{
_m.Hata(e);
}
}
/// <summary>
/// Method for add or edit products in database
/// </summary>
/// <param name="product"></param>
/// <returns>new or edited product</returns>
public tblProduct AddEditProduct(tblProduct product)
{
try
{
using (WarehouseDBEntities context = new WarehouseDBEntities())
{
if (product.ID == 0)
{
tblProduct newProduct = new tblProduct();
newProduct.ProductName = product.ProductName;
newProduct.ProductCode = product.ProductCode;
newProduct.Quantity = product.Quantity;
newProduct.Price = product.Price;
newProduct.Stored = "no";
context.tblProducts.Add(newProduct);
context.SaveChanges();
product.ID = newProduct.ID;
action = "added";
return(product);
}
else
{
tblProduct productForEdit = (from x in context.tblProducts where x.ID == product.ID select x).FirstOrDefault();
productForEdit.ProductName = product.ProductName;
productForEdit.ProductCode = product.ProductCode;
productForEdit.Quantity = product.Quantity;
productForEdit.Price = product.Price;
productForEdit.Stored = product.Stored;
context.SaveChanges();
action = "edited";
return(product);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
public ActionResult EditProduct(Guid?productID)
{
List <SelectListItem> categories = new List <SelectListItem>();
List <tblCategory> listCategory = new List <tblCategory>();
if (Request.Cookies["Culture"] != null && Request.Cookies["Culture"].Value == "en-US")
{
listCategory = Service.GetAllCategory(Languages.EN);
}
else
{
listCategory = Service.GetAllCategory(Languages.VN);
}
foreach (tblCategory cat in listCategory)
{
categories.Add(new SelectListItem {
Text = cat.CategoryName, Value = cat.ID.ToString()
});
}
ViewData["Categories"] = categories;
if (productID != null)
{
tblProduct tblproduct = new tblProduct();
tblproduct = Service.GetProductByID((Guid)productID);
if (tblproduct != null && !string.IsNullOrEmpty(tblproduct.Description))
{
ViewData["Description"] = tblproduct.Description;
}
return(View("Admin/EditProduct", tblproduct));
}
else
{
ViewData["AddProduct"] = true;
tblProduct tblproduct = new tblProduct();
return(View("Admin/EditProduct", tblproduct));
}
}
public async Task <ActionResult> Create([Bind(Include = "ProdId,ProdNombre,CatId,Precio,ProdObservacion")] tblProduct tblProduct)
{
try
{
if (ModelState.IsValid)
{
db.tblProduct.Add(tblProduct);
await db.SaveChangesAsync();
Success(string.Format("<b>{0}</b> fue exitosamente agregado.", tblProduct.ProdNombre), true);
return(RedirectToAction("Index"));
}
ViewBag.CatId = new SelectList(db.tblProductCategory, "CatId", "CatNombre", tblProduct.CatId);
return(View(tblProduct));
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage ProductUpload()
{
string imageName = null;
var httpRequest = HttpContext.Current.Request;
//Upload Image
var postedFile = httpRequest.Files["Image"];
//var postedFile = fileToUpload;
//Create custom filename
imageName = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()).Replace(" ", "-");
imageName = imageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName);
var filePath = HttpContext.Current.Server.MapPath("~/Image/" + imageName);
postedFile.SaveAs(filePath);
var retaileremail = httpRequest["RetailerEmail"].ToString();
int retailerid = entities.tblRetailers.Where(r => r.retaileremail == retaileremail).Select(r => r.retailerid).FirstOrDefault();
using (dbGladiatorEntities entities = new dbGladiatorEntities())
{
tblProduct tblProduct = new tblProduct();
tblProduct.retailerid = retailerid;
tblProduct.productname = httpRequest["ProductName"].ToString();
tblProduct.productdescription = httpRequest["ProductDescription"].ToString();
tblProduct.productbrand = httpRequest["ProductBrand"].ToString();
tblProduct.productquantity = Convert.ToInt32(httpRequest["ProductQuantity"].ToString());
tblProduct.productprice = Convert.ToInt32(httpRequest["ProductPrice"].ToString());
tblProduct.categoryid = Convert.ToInt32(httpRequest["CategoryId"].ToString());
tblProduct.productnotification = "add";
tblProduct.productstatus = "pending";
tblProduct.productimage1 = imageName.ToString();
entities.tblProducts.Add(tblProduct);
entities.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
}
/// <summary>
/// Save Products
/// </summary>
/// <param name="customer"></param>
public bool SaveProducts(ProductViewModel customerViewModel)
{
bool status = false;
tblProduct customers = new tblProduct();
Mapper.Map(customerViewModel, customers);
customers.IsActive = true;
customers.CreatedDate = DateTime.Now;
customers.ModifiedDate = DateTime.Now;
customers.CreatedBy = "101";
customers.ModifiedBy = "101";
_Context.tblProducts.Add(customers);
_Context.Configuration.ValidateOnSaveEnabled = true;
_Context.SaveChanges();
status = true;
return(status);
// for new users
}
public ActionResult Create([Bind(Include = "ProductID,ProductCategoryID,ProductSubCategoryID,ProductName,ProductDescription,Make,TaxID,SizeID,RatePerUnit,Discount,Remark,IsActive,CreatedOn,UpdatedOn,CreatedBy,UpdatedBy,UnitID,SGST,CGST")] tblProduct tblProduct)
{
if (ModelState.IsValid)
{
tblUser objSource = (tblUser)Session["UserDetails"];
tblProduct.IsActive = true;
tblProduct.CreatedOn = DateTime.Now;
tblProduct.CreatedBy = objSource.Id;
db.tblProducts.Add(tblProduct);
db.SaveChanges();
TempData["Success"] = "Product created successfuly.";
ViewBag.Product = new tblProduct();
return(RedirectToAction("Index"));
}
FillDropdownProductCategory(tblProduct.ProductCategoryID);
FillDropdownProductSubCategory(Convert.ToInt32(tblProduct.ProductCategoryID), tblProduct.ProductSubCategoryID);
FillUnit(tblProduct.UnitID);
FillSize(tblProduct.UnitID, tblProduct.SizeID);
FillTax(tblProduct.TaxID);
return(View(tblProduct));
}
public void AddProduct(tblProduct product)
{
try
{
using (StoreDBEntities context = new StoreDBEntities())
{
tblProduct newProduct = new tblProduct();
newProduct.ProductName = product.ProductName;
newProduct.Price = product.Price;
newProduct.Amount = product.Amount;
newProduct.Code = product.Code;
newProduct.Stored = product.Stored;
context.tblProducts.Add(newProduct);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
//Array is [ManufacturerName, Series, Model, ModelYear]
public string[] getDescription(int productID) //WIP
{
List <tblProduct> products = getProducts().ToList();
Dictionary <int, string> manufacturersDict = getManufacturers().ToDictionary(x => x.ManufacturerID, x => x.ManufacturerName);
tblProduct product = new tblProduct();
for (int i = 0; i < products.Count(); i++)
{
if (products[i].ProductID.Equals(productID))
{
product = products[i];
}
}
string[] description = new string[]
{
manufacturersDict[product.ManufacturerID.Value],
product.Series,
product.Model,
product.ModelYear
};
return(description);
}
public static string LoadNutritionData(Guid id)
{
try
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblProduct tblProduct = dc.tblProducts.FirstOrDefault(c => c.Id == id);
if (tblProduct != null)
{
return(tblProduct.Title);
}
else
{
throw new Exception("Row was not found.");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public tblProduct GetProductByID(Guid newID, bool isEN)
{
if (isEN)
{
var query = _dataContext.tblProducts.Where("ID.ToString()=@0 and ProductNameEN != null", newID.ToString());
if (query.ToList().Count() > 0)
{
tblProduct tblnew = query.ToList().First();
return(tblnew);
}
}
else
{
var query = _dataContext.tblProducts.Where("ID.ToString()=@0 and ProductNameVN != null", newID.ToString());
if (query.ToList().Count() > 0)
{
tblProduct tblnew = query.ToList().First();
return(tblnew);
}
}
return(null);
}
public bool ProcessProductUpdatedDocument(tblProduct product)
{
string url = product.Url;
bool urlExists = _urlFileService.URLExists(url);
byte[] urlFileData = new byte[] { };
if (urlExists)
{
urlFileData = _urlFileService.ReadUrlFileData(url);
}
tblProductDocument productDocument = _productDocumentRepository.GetById(a => a.ProductId == product.Id);
productDocument.DocumentContent = urlFileData;
productDocument.LastModifiedDate = DateTime.Today;
productDocument.tblProduct = null;
_productDocumentRepository.Update(a => a.ProductId == productDocument.ProductId, productDocument);
return(urlExists);
}
protected void btnDeliver_Click(object sender, EventArgs e)
{
PurchaseOrderDetail repository = new PurchaseOrderDetail();
PurchaseOrder rep_po = new PurchaseOrder();
int id = Convert.ToInt32(DropDownList1.SelectedValue);
var result = repository.GetAll().Where(r => r.POId == id).ToArray();
var pp = rep_po.Get(id);
pp.Deleted = true;
rep_po.Update(pp);
Product rep = new Product();
tblProduct prod = new tblProduct();
foreach (var item in result)
{
var p = rep.Get(item.ProductId);
p.Quantity += item.Quantity;
rep.Update(p);
}
this.ShowSuccessfulNotification("Products Delivered");
gridProduct.Visible = false;
}
/// <summary>
/// Return Affected Row Or Error If Exist
/// </summary>
/// <param name="request">Producto Information</param>
/// <returns>Affected Row Or Error If Exist</returns>
public static GetProductResponse Product(GetProductResponse request)
{
GetProductResponse response = new GetProductResponse();
response.Error = new Handler.ErrorObject();
try
{
tblProduct bussines = new tblProduct()
{
id = request.Product.id,
code = request.Product.code,
name = request.Product.name,
unit = request.Product.unit,
detail = request.Product.detail,
idProductType = request.Product.idProductType,
createDate = DateTime.Now,
upDateDate = null,
deleteDate = null,
state = "Active"
};
var result = ProductData.Insert.product(bussines);
if (result.Item1.Error)
{
response.Error.InfoError(result.Item1);
}
else
{
response.Message = result.Item2.ToString();
}
}
catch (Exception ex)
{
response.Error.InfoError(ex);
}
return(response);
}
private tblProduct SyncAdditiveProduct(Product product)
{
var additiveProduct = UnitOfWork.AdditiveProductRepository.FindByKey(product.ToProductKey());
tblProduct oldProduct;
int prodId;
if (int.TryParse(product.ProductCode, out prodId))
{
oldProduct = OldContext.tblProducts.FirstOrDefault(p => p.ProdID == prodId);
}
else
{
throw new Exception("OldContextSync - ProductCode must be numeric.");
}
if (oldProduct == null)
{
oldProduct = new tblProduct
{
ProdID = prodId,
ProdGrpID = 99,
PTypeID = 4,
EmployeeID = 100,
EntryDate = DateTime.Now,
TrtmtID = StaticInventoryTreatments.NoTreatment.Id,
s_GUID = Guid.NewGuid()
};
OldContext.tblProducts.AddObject(oldProduct);
}
oldProduct.Product = product.Name;
oldProduct.InActive = !product.IsActive;
oldProduct.IngrID = additiveProduct.AdditiveTypeId;
return(oldProduct);
}
public ProductModel GetProductById(int id) // get all records from database
{
tblProduct oneTblProducts = objWITSProjectEntities.tblProduct.Where(x => x.ID == id).FirstOrDefault();
ProductModel listOfProduct = new ProductModel()
{
Id = oneTblProducts.ID,
Name = oneTblProducts.Name,
Brand = oneTblProducts.Brand,
ModelNo = oneTblProducts.ModelNo,
Category = oneTblProducts.Category,
Condition = oneTblProducts.Condition,
BuyNowPrice = (int)oneTblProducts.BuyNowPrice,
BidPrice = (int)oneTblProducts.BidPrice,
Quantity = oneTblProducts.Quantity,
//AddressId = oneTblProducts.AddressID,
BidDateTime = oneTblProducts.BidEndDateTime.ToString("yyy/MM/dd"),
ImagePath = oneTblProducts.ImagePath,
AddedByUserId = oneTblProducts.AddedByUserId,
AddressId = oneTblProducts.AddressID
};
return(listOfProduct); // gives list of the products
}
public ActionResult AddToCart(tblProduct tbl)
{
if (Session["cart"] == null)
{
List <tblProduct> li = new List <tblProduct>();
li.Add(tbl);
Session["cart"] = li;
ViewBag.cart = li.Count();
Session["count"] = 1;
}
else
{
List <tblProduct> li = (List <tblProduct>)Session["cart"];
li.Add(tbl);
Session["cart"] = li;
ViewBag.cart = li.Count();
Session["count"] = Convert.ToInt32(Session["count"]) + 1;
}
return(View());
}
public ProductViewModel(int id)
{
Service s = new Service();
tblProduct product = s.getProductService(id);
/*
* pvList = s.GetTblPropertyValueByProductID(id);
*
*
* techSpecList = init_TechSpecList();
*
*/
techSpecList = init_TechSpecList();
productID = Int32.Parse(product.Product_ID.ToString());
Manufacture = s.GetManufNameByID(Int32.Parse(product.Manufacturer_ID.ToString()));
Series = product.Series.ToString();
Model = product.Model.ToString();
UseType = "Commercial";
Application = "Indoor";
MountingLoaction = "";
Accessories = "With Lignt";
ModelYear = product.Model_Year.Year.ToString();
}
public string UpdateLaptop(int id, tblProduct product)
{
try
{
db_1430757_co5027_naftechEntities db = new db_1430757_co5027_naftechEntities();
//get the table from db
tblProduct pro = db.tblProducts.Find(id);
pro.Type_ID = product.Type_ID;
pro.LP_name = product.LP_name;
pro.LP_price = product.LP_price;
pro.LP_desc = product.LP_desc;
pro.LP_image = product.LP_image;
db.SaveChanges();
return(product.LP_name + "-Succesfully updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public static string LoadProductCount(string strCategory, string strSubCategory, string strProperty, string strColor, string strSize, string strOrderBy, string strProduct, string strPrice)
{
string strMinPrice = "";
string strMaxPrice = "";
if (strPrice != "")
{
string[] strvalue = strPrice.Split(';');
strMinPrice = strvalue[0];
strMaxPrice = strvalue[1];
}
string strRate = "1";
//if (HttpContext.Current.Session[appFunctions.Session.CurrencyInRupee.ToString()] != null)
//{
// if (HttpContext.Current.Session[appFunctions.Session.CurrencyInRupee.ToString()].ToString() != "")
// {
// strRate = HttpContext.Current.Session[appFunctions.Session.CurrencyInRupee.ToString()].ToString();
// }
//}
tblProduct objProduct = new tblProduct();
return(objProduct.LoadAllProductCount(strCategory, strSubCategory, strProperty, strColor, strSize, strOrderBy, strMinPrice, strMaxPrice, strRate, strProduct));
}
private void FillPage()
{
//get selected product's data
if (!String.IsNullOrWhiteSpace(Request.QueryString["id"]))
{
int id = Convert.ToInt32(Request.QueryString["id"]);
ProductModel productModel = new ProductModel();
tblProduct product = productModel.GetProduct(id);
//fill page with data
lblPrice.Text = "Price per kg: <br/>€ " + product.Price;
lblTitle.Text = product.Name;
lblDescription.Text = product.Description;
lblItemNr.Text = id.ToString();
imgProduct.ImageUrl = "~/Images/Products/" + product.Image;
//Fill amount dropdownlist with number 1 - 10
int[] amount = Enumerable.Range(1, 10).ToArray();
ddlAmount.DataSource = amount;
ddlAmount.AppendDataBoundItems = true;
ddlAmount.DataBind();
}
}
public string UpdateProduct(int id, tblProduct product)
{
try
{
OnlineKitchenDBEntities db = new OnlineKitchenDBEntities();
//Fetch object from db
tblProduct p = db.tblProducts.Find(id);
p.Name = product.Name;
p.Price = product.Price;
p.TypeId = product.TypeId;
p.Description = product.Description;
p.Image = product.Image;
db.SaveChanges();
return(product.Name + " was successfully updated");
}
catch (Exception e)
{
return("Error: " + e);
}
}
/// <summary>
/// Adds new product to the table or updates one if product with same ID already exists.
/// </summary>
/// <param name="product"></param>
public void AddProduct(tblProduct product)
{
using (StorageEntities context = new StorageEntities())
{
if (product.ID == 0)
{
context.tblProducts.Add(product);
context.SaveChanges();
OnProductAdded();
}
else
{
tblProduct productToEdit = (from p in context.tblProducts where p.ID == product.ID select p).First();
productToEdit.ProductName = product.ProductName;
productToEdit.Code = product.Code;
productToEdit.Price = product.Price;
productToEdit.Amount = product.Amount;
productToEdit.ID = product.ID;
context.SaveChanges();
OnProductEdited();
}
}
}
private void fPage()
{
//select laptop data
if (!string.IsNullOrWhiteSpace(Request.QueryString["ID"]))
{
int ID = Convert.ToInt32(Request.QueryString["ID"]);
LPModel model = new LPModel();
tblProduct product = model.GetProduct(ID);
//Fill page with data
lblTitle.Text = product.LP_name;
lblDesc.Text = product.LP_desc;
lblPrice.Text = "Price per Item: $ " + product.LP_price;
imgLaptop.ImageUrl = "~/Images/" + product.LP_image;
lblProNo.Text = product.ID.ToString();
//Fill quantity with numbers 1-20
int[] amount = Enumerable.Range(1, 20).ToArray();
ddlQuantity.DataSource = amount;
ddlQuantity.AppendDataBoundItems = true;
ddlQuantity.DataBind();
}
}
public bool SaveChangesProduct(tblProduct model)
{
using (var dbContextTransaction = _db.Database.BeginTransaction())
{
try
{
tblProduct item = _db.Products.Where(x => x.id == model.id).FirstOrDefault();
item.name = model.name;
item.number = model.number;
item.idunit = model.idunit;
item.description = model.description;
item.status = model.status;
_db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(false);
}
}
}
/// <summary>
/// Method delets product from database if product is not stored
/// </summary>
/// <param name="productID">product id</param>
public void DeleteProduct(int productID)
{
try
{
using (WarehouseDBEntities context = new WarehouseDBEntities())
{
tblProduct productToDelete = (from p in context.tblProducts where p.ID == productID select p).First();
if (productToDelete.Stored == "no")
{
context.tblProducts.Remove(productToDelete);
context.SaveChanges();
}
else
{
MessageBox.Show("Stored products cannot be deleted.");
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public ActionResult ProductEdit(tblProduct tblProduct)
{
if (ModelState.IsValid)
{
db.Entry(tblProduct).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("ProductList");
}
return View(tblProduct);
}
public ActionResult ProductAddDo(int cat)
{
//Get a list of specIds related to the category they would like to add a product to
var speclist = (from c in db.tblCategorySpecificSpecs where c.CategoryId == cat select c).ToList();
//Add the product record
tblProduct prod = new tblProduct();
prod.CategoryId = cat;
prod.Active = false;
db.tblProducts.Add(prod);
//Create a record for each specid
foreach (var item in speclist)
{
tblProductSpec prodSpec = new tblProductSpec();
prodSpec.CatSpecId = item.CSpecId;
prodSpec.ProductId = prod.ProductId;
prodSpec.SpecValue1 = "1";
prodSpec.SpecValue2 = "2";
db.tblProductSpecs.Add(prodSpec);
}
//Save
db.SaveChanges();
return RedirectToAction("ProductEdit", null, new { id = prod.ProductId });
//return View("ProductEdit", prod.ProductId);
}
partial void DeletetblProduct(tblProduct instance);
partial void UpdatetblProduct(tblProduct instance);
partial void InserttblProduct(tblProduct instance);
public void Save(ProductItem item)
{
var errors = item.GetValidationErrors();
errors.ThrowIfHasErrors();
var product = new tblProduct();
if (item.Id != 0)
{
product = Db.Set<tblProduct>().Single(x => x.Id == item.Id);
}
else
{
product = Db.Set<tblProduct>().Create();
Db.Set<tblProduct>().Add(product);
}
product.Descripton = item.Descripton;
product.Name = item.Name;
product.YandexUrl = item.YandexUrl;
product.Specs = item.Specs;
product.CategoryId = item.CategoryId;
Db.SaveChanges();
item.Id = product.Id;
}
