protected void Button1_Click(object sender, EventArgs e)
{
//Session["PhotoID"] = "";
InsertProduct NewProduct = new InsertProduct();
NewProduct.description = txtDescription.Text;
NewProduct.address = txtAddress.Text;
NewProduct.dealername = txtDealerName.Text;
NewProduct.productcompany = txtProductCompany.Text;
NewProduct.type = ddlType.Text;
if (ProductPhoto.HasFile)
{
int imagesize = ProductPhoto.PostedFile.ContentLength;
byte[] bytesImage = new byte[imagesize];
ProductPhoto.PostedFile.InputStream.Read(bytesImage, 0, imagesize);
NewProduct.photo = bytesImage;
}
NewProduct.InsertData();
txtDescription.Text = "";
txtProductCompany.Text = "";
txtAddress.Text = "";
string connectionString = WebConfigurationManager.ConnectionStrings["Admin"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
con.Open();
string sql = "Select Max(ID) from Advertisment";
SqlDataAdapter adp = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
adp.Fill(ds, "Advertisment");
Session["AdvID"] = ds.Tables["Advertisment"].Rows[0][0].ToString();
}
public ActionResult them(FormCollection form, Sanpham sp)
{
//int ma = int.Parse(form["Brand"]);
//ViewBag.Brand= new SelectList(lt.Nhanhieux.ToList(), "Mahieu", "Tenhieu",ma);
//sp.Mahieu = int.Parse(form["Brand"]);
int ma = int.Parse(form["Maloai"]);
var chilCat = lt.ChildCategories.FirstOrDefault(x => x.ID == ma);
int?cat = chilCat.Maloai;
sp.Maloai = cat;
if (ModelState.IsValid)
{
try
{
var dao = new InsertProduct();
//ViewBag.Brand = new SelectList(lt.Nhanhieux.ToList(), "Mahieu", "Tenhieu", ma);
// var ht = lt.ChildCategories.ToList();
int id = dao.insert(sp);
ViewBag.gia = sp.Giaban;
ViewBag.gkm = sp.Giakhuyenmai;
if (id > 0)
{
SetAlert("Thêm sản phẩm thành công", "success");
return(RedirectToAction("hiensp"));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", "Thêm không thành công");
}
}
return(View());
}
public async Task <bool> InsertOneProductAsync(InsertProduct entity, string userId)
{
try
{
FilterDefinition <BsonDocument> filter = Builders <BsonDocument> .Filter.Eq("name", entity.name);
BsonDocument product = await mCollection.Find(filter).FirstOrDefaultAsync();
if (product != null)
{
return(false);
}
BsonDocument newProduct = new BsonDocument
{
{ "name", entity.name },
{ "price", entity.price },
{ "userId", userId },
{ "createAt", DateTime.Now },
{ "updateAt", DateTime.Now }
};
await mCollection.InsertOneAsync(newProduct);
return(true);
}
catch
{
return(false);
}
}
public async Task <object> InsertOneProduct([FromBody] InsertProduct entity)
{
try
{
string token = HttpContext.Request.Headers["token"];
List <Claim> claims = authService.GetTokenClaims(token).ToList();
string username = claims.Find(x => x.Type == ClaimTypes.Name).Value;
Result data = await userService.GetUserByUserNameAsync(username, new string[] { "username" });
User user = (User)data.data;
Result result = await productService.InsertOneProductAsync(entity, user.id);
if (result.status == 200)
{
return(Ok(Responder.Success(result.data)));
}
else
{
return(StatusCode(result.status, Responder.Fail(result.data)));
}
}
catch (Exception error)
{
return(BadRequest(Responder.Fail(error.Message)));
}
}
public async Task <IActionResult> Put(Guid id, [FromBody] InsertProduct data)
{
var product = await _unitOfWork.Products.GetById(id);
product.Name = data.Name;
product.Price = data.Price;
product.Status = (int)Status.Active;
product.ModifiedBy = data.ModifiedBy;
product.DateModified = DateTime.Now;
if (data.FileData == null)
{
product.ProductImage = "default.jpg";
}
else
{
if (product.ProductImage != "default.jpg")
{
SaveFile.DeteFile(product.ProductImage);
}
product.ProductImage = SaveFile.SaveB64File(data.FileData);
}
product = _unitOfWork.Products.CreateNewAddReturnObject(product);
if (_unitOfWork.Commit())
{
return(Created(Url.Action("Get"), _mapper.Map <ProductMv>(product)));
}
return(BadRequest());
}
public void Put([FromBody] InsertProduct adddproduct)
{
using (SalesForceEntities entities = new SalesForceEntities())
{
entities.UpdateProduct(adddproduct.Id, adddproduct.Name, adddproduct.Brand, adddproduct.Category, adddproduct.ManufacturePrice, adddproduct.RetailPrice, adddproduct.Quantity, adddproduct.DiscountType);
entities.SaveChanges();
}
}
private static InsertProduct CreateProductDetailInAMZCoupon(InsertProduct product, IHostingEnvironment env)
{
var collection = db.GetCollection <BsonDocument>("AMZCoupon");
product.StarID = ObjectId.GenerateNewId();
product.PictureID = ObjectId.GenerateNewId();
product.VideoID = ObjectId.GenerateNewId();
product.CommandID = ObjectId.GenerateNewId();
var Coupons = new BsonArray();
string[] CouponArray = product.Coupons.Split('\n');
foreach (var item in CouponArray)
{
Coupons.Add(new BsonDocument {
{ "Used", "n" }, { "Coupon", item }
});
}
string ImgUrl = "";
if (product.Picture != null)
{
ImgUrl = SaveImage(product.Picture, product.Account, env);
}
product.Shelf = "y";
product.Valid = "y";
product.OwnerID = FindUserIdByAccount(product.Account);
product.Discount = product.Discount / 100;
var document = new BsonDocument
{
{ "ProductName", product.ProductName },
{ "Price", product.Price },
{ "StarID", product.StarID },
{ "Picture", ImgUrl },
{ "VideoID", product.VideoID },
{ "CommandID", product.CommandID },
{ "Coupons", Coupons },
{ "Shelf", product.Shelf },
{ "Valid", product.Valid },
{ "AddedTime", DateTime.Now },
{ "OwnerID", product.OwnerID },
{ "Discount", product.Discount },
{ "StartTime", product.StartTime },
{ "EndTime", product.EndTime }
};
try
{
collection.InsertOne(document);
return(product);
}
catch
{
return(null);
}
}
public void InsertAndFetchNewId()
{
using (IDbConnection dbConnection = new SqliteConnectionFactory().Create())
{
var insertProduct = new InsertProduct();
var product = new ProductDto {Name = "New Product"};
product.Id = (int) dbConnection.Query<Int64>(insertProduct.Query(product)).Single();
Assert.AreNotEqual(0, product.Id);
}
}
private void buttonSelectInsert_Click(object sender, EventArgs e)
{
if (isCategorySelected)
{
InsertCategory insertCategory = new InsertCategory();
insertCategory.Show();
}
else
{
InsertProduct insertProduct = new InsertProduct();
insertProduct.Show();
}
}
public void InsertAndFetchNewId()
{
using (IDbConnection dbConnection = new SqliteConnectionFactory().Create())
{
var insertProduct = new InsertProduct();
var product = new ProductDto {
Name = "New Product"
};
product.Id = (int)dbConnection.Query <Int64>(insertProduct.Query(product)).Single();
Assert.AreNotEqual(0, product.Id);
}
}
public static bool InsertCouponDetail(InsertProduct product, IHostingEnvironment env)
{
db = GetMongoDatabase();
var result = true;
product = CreateProductDetailInAMZCoupon(product, env);
if (result)
{
return(true);
}
else
{
return(false);
}
}
public void UpdateProductName()
{
using (IDbConnection dbConnection = new SqliteConnectionFactory().Create())
{
var insertProduct = new InsertProduct();
var product = new ProductDto {Name = "Product Name"};
product.Id = (int) dbConnection.Query<Int64>(insertProduct.Query(product)).Single();
var updateProduct = new UpdateProduct();
dbConnection.Execute(updateProduct.NameForAllProducts("new name"));
var selectProduct = new SelectProduct();
ProductDto result = dbConnection.Query<ProductDto>(selectProduct.ById(product.Id)).Single();
StringAssert.AreEqualIgnoringCase("new name", result.Name);
}
}
public void UpdateProductName()
{
using (IDbConnection dbConnection = new SqliteConnectionFactory().Create())
{
var insertProduct = new InsertProduct();
var product = new ProductDto {
Name = "Product Name"
};
product.Id = (int)dbConnection.Query <Int64>(insertProduct.Query(product)).Single();
var updateProduct = new UpdateProduct();
dbConnection.Execute(updateProduct.NameForAllProducts("new name"));
var selectProduct = new SelectProduct();
ProductDto result = dbConnection.Query <ProductDto>(selectProduct.ById(product.Id)).Single();
StringAssert.AreEqualIgnoringCase("new name", result.Name);
}
}
public async Task <Result> InsertOneProductAsync(InsertProduct insertProduct, string userId)
{
bool result = await service.InsertOneProductAsync(insertProduct, userId);
if (result)
{
return new Result
{
status = Status.Created,
data = Messages.OK
}
}
;
return(new Result
{
status = Status.BadRequest,
data = Messages.BadRequest
});
}
public Result InsertOneProduct(InsertProduct insertProduct, string userId)
{
bool result = service.InsertOneProduct(insertProduct, userId);
if (result)
{
return new Result
{
status = Status.Created,
data = Messages.OK
}
}
;
return(new Result
{
status = Status.BadRequest,
data = Messages.BadRequest
});
}
public IActionResult Post([FromBody] InsertProduct data)
{
var product = new Product();
product.Name = data.Name;
product.Price = data.Price;
product.Status = (int)Status.Active;
product.CreateBy = data.CreateBy;
product.DateCreate = DateTime.Now;
if (data.FileData == null)
{
product.ProductImage = "default.jpg";
}
else
{
product.ProductImage = SaveFile.SaveB64File(data.FileData);
}
product = _unitOfWork.Products.CreateNewAddReturnObject(product);
if (_unitOfWork.Commit())
{
return(Created(Url.Action("Get"), _mapper.Map <ProductMv>(product)));
}
return(BadRequest());
}
//Uploading Files
//public List<HttpPostedFileBase> PostedPhotos = new List<HttpPostedFileBase>();
public JsonResult UploadingFiles(InsertProduct FormData)
{
InsertProduct data = new InsertProduct();
DashboardCloth dashboard = new DashboardCloth();
data = FormData;
bool result = false;
try
{
if (data.Files != null && data.Files.ContentLength > 0)
{
var fileName = Path.GetFileName(data.Files.FileName);
//string filename = System.IO.Path.GetFileName(file.FileName);
//file.SaveAs(Server.MapPath(@"E:UsersProfiles\skadi\Documents\Visual Studio 2012\Projects\CodeFirstDemoApplication\Fileuploads" + filename));
string path = @"E:/UsersProfiles/skadi/Documents/Visual Studio 2012/Projects/CodeFirstDemoApplication/CodeFirstDemoApplication/Images/Clothing/Men";
string folderpath = "http://*****:*****@"E:\UsersProfiles\skadi\UploadProducts\Cloths\Men\";
//string vPath = pPath.Replace(@"q:\quotewerks", "~").Replace(@"\", "/");
//int GivenDiscount = data.DiscountPercent;
//float OldPrice = data.ProductCost;
//string ISDiscount = data.IsDiscountAvail;
//float NewPrice = 0;
//GivenDiscount = Convert.ToInt32(GivenDiscount / 100);
//NewPrice = Convert.ToInt32(OldPrice - (OldPrice * GivenDiscount));
data.Files.SaveAs(Path.Combine(path, fileName));
dashboard.Brand = data.Brand;
dashboard.CategoryId = data.CategoryId;
dashboard.Color = data.Color;
dashboard.FileName = data.Files.FileName;
dashboard.FilePath = folderpath;
dashboard.Fit = data.Fit;
dashboard.Material = data.Material;
dashboard.NeckType = data.NeckType;
dashboard.Occasion = data.Occasion;
dashboard.ProdId = data.ProdId;
dashboard.Size = data.Size;
dashboard.Sleeves = data.Sleeves;
dashboard.Status = data.Status;
dashboard.ProductCost = data.ProductCost;
dashboard.IsDiscountAvail = data.IsDiscountAvail;
dashboard.DiscountPercent = data.DiscountPercent;
dashboard.ProductCount = data.ProductCount;
dashboard.AfterDiscountCost = data.AfterDiscountCost;
dashboard.ProductDescription = data.ProductDescription;
_clothCategoryBo.NewDashBoardProduct(dashboard);
//DBcontext.SaveChanges();
}
else
{
result = true;
}
//file.SaveAs(s);
//string filepathtosave = "Images/" + filename;
//file.SaveAs(filename);
}
//PostedPhotos.Add(FormData.Files);
}
catch (Exception ex)
{
}
return Json(null, JsonRequestBehavior.AllowGet);
}
public void Insert([FromBody] InsertProduct command)
{
this.productInserter.Execute(command);
}