public ActionResult AddProduct(ProductCollectionModel collection)
{
try
{
// TODO: Add insert logic here
if (Request.Form.Files.Count > 0)
{
var file = Request.Form.Files[0];
byte[] buffer = new byte[file.Length];
file.OpenReadStream().Read(buffer, 0, (int)file.Length);
collection.FileName = file.FileName;
collection.ProductImage = buffer;
azureBlobStorage.UploadToBlobAsync(collection);
}
else
{
collection.FileName = "NoImage.png";
}
productoInventRepository.AddNewProduct(collection);
sendEmailLogic.SendMail(collection);
return(RedirectToAction(nameof(Index)));
}
catch (Exception ex)
{
return(View());
}
}
public List <ProductCollectionModel> GetProductCollections()
{
SqlConnection sqlConnection = new SqlConnection(AdoSqlConnection.ConnectionString);
sqlConnection.Open();
var productCollections = new List <ProductCollectionModel>();
using (var command = new SqlCommand("select top 50 ProductId,name,standardcost,ModifiedDate,productNumber from SalesLt.Product where discontinueddate is null order by 1 desc", sqlConnection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ProductCollectionModel productCollection = new ProductCollectionModel();
productCollection.ProductId = reader.GetInt32(0);
productCollection.ProductName = reader.GetString(1);
productCollection.Price = reader.GetDecimal(2);
productCollection.ModifiedDateTime = reader.GetDateTime(3);
productCollection.ProductNumber = reader.GetString(4);
productCollections.Add(productCollection);
}
}
}
sqlConnection.Close();
return(productCollections);
}
public ProductCollectionModel GetProductDetails(int productId)
{
SqlConnection sqlConnection = new SqlConnection(AdoSqlConnection.ConnectionString);
sqlConnection.Open();
var productCollection = new ProductCollectionModel();
using (var command = new SqlCommand("select ProductId,name,standardcost,sellstartdate,ModifiedDate,productnumber from SalesLt.Product where discontinueddate is null and Productid=" + productId + "order by 1 desc", sqlConnection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
productCollection.ProductId = reader.GetInt32(0);
productCollection.ProductName = reader.GetString(1);
productCollection.CreatedDateTime = reader.GetDateTime(3);
productCollection.ProductNumber = reader.GetString(5);
productCollection.Price = reader.GetDecimal(2);
productCollection.ModifiedDateTime = reader.GetDateTime(4);
}
}
}
sqlConnection.Close();
return(productCollection);
}
public ActionResult DeleteProduct(int id, ProductCollectionModel collection)
{
try
{
productoInventRepository.DeleteProduct(collection.ProductId);
return(RedirectToAction(nameof(Index)));
}
catch (Exception ex)
{
return(View());
}
}
public ActionResult Edit(int id, ProductCollectionModel collection)
{
try
{
// TODO: Add update logic here
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public ActionResult AddProduct(ProductCollectionModel collection)
{
try
{
// TODO: Add insert logic here
productoInventRepository.AddNewProduct(collection);
return(RedirectToAction(nameof(Index)));
}
catch (Exception ex)
{
return(View());
}
}
public async Task <int> UploadToBlobAsync(ProductCollectionModel productCollectionModel)
{
try
{
blob = _container.GetBlockBlobReference(blobPath + productCollectionModel.FileName);
await blob.UploadFromByteArrayAsync(productCollectionModel.ProductImage, 0, productCollectionModel.ProductImage.Length);
return(1);
}
catch (Exception)
{
return(0);
}
}
public int AddNewProduct(ProductCollectionModel productCollectionModel)
{
int rowsAffected = 0;
SqlConnection sqlConnection = new SqlConnection(AdoSqlConnection.ConnectionString);
sqlConnection.Open();
using (var command = new SqlCommand("insert into salesLt.Product (Name,ProductNumber,standardcost,ListPrice,sellStartdate,ModifiedDate) values('" + productCollectionModel.ProductName + "','" + productCollectionModel.ProductNumber + "'," + productCollectionModel.Price + "," + productCollectionModel.Price + ",'" + productCollectionModel.CreatedDateTime.ToString("yyyy-MM-dd hh:mm") + "','" + DateTime.Now.ToString("yyyy-MM-dd hh: mm") + "')", sqlConnection))
{
rowsAffected = command.ExecuteNonQuery();
}
sqlConnection.Close();
return(rowsAffected);
}
public int EditProduct(ProductCollectionModel productCollectionModel)
{
int rowsAffected = 0;
SqlConnection sqlConnection = new SqlConnection(AdoSqlConnection.ConnectionString);
sqlConnection.Open();
using (var command = new SqlCommand("update SalesLt.Product set Name = '" + productCollectionModel.ProductName
+ "', ProductNumber = '" + productCollectionModel.ProductNumber
+ "', standardCost =" + productCollectionModel.Price
+ ", sellStartdate = '" + productCollectionModel.CreatedDateTime
+ "', Thumbnailphotofilename = '" + productCollectionModel.FileName
+ "'where ProductId = " + productCollectionModel.ProductId, sqlConnection))
{
rowsAffected = command.ExecuteNonQuery();
}
sqlConnection.Close();
return(rowsAffected);
}
public ActionResult EditProduct(ProductCollectionModel collection)
{
try
{
if (Request.Form.Files.Count > 0)
{
var file = Request.Form.Files[0];
byte[] buffer = new byte[file.Length];
file.OpenReadStream().Read(buffer, 0, (int)file.Length);
collection.FileName = file.FileName;
collection.ProductImage = buffer;
azureBlobStorage.UploadToBlobAsync(collection);
}
productoInventRepository.EditProduct(collection);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public async Task SendMail(ProductCollectionModel collection)
{
//var proxy = new WebProxy()
//{
// Address = new Uri($"http://gbips-i-ss50.int.dir.willis.com:8080"),
// BypassProxyOnLocal = false,
// UseDefaultCredentials = true,
// Credentials = new NetworkCredential("BMSri", "June2018&", "INT")
//};
//var client = new SendGridClient(proxy, apiKey);
var client = new SendGridClient(apiKey);
var msg = new SendGridMessage()
{
From = new EmailAddress("*****@*****.**", "Products Admin Team"),
Subject = "Product Inventory - New Product",
PlainTextContent = "Congratulations!!!!!!!!!!!" + "You have succesfully added" + " " + collection.ProductName + ":)"
};
msg.AddTo(new EmailAddress(collection.CustomerEmail, "Customer"));
var response = await client.SendEmailAsync(msg).ConfigureAwait(false);
}
public List <ProductCollectionModel> GetProductCollectionsWithImage()
{
SqlConnection sqlConnection = new SqlConnection(AdoSqlConnection.ConnectionString);
sqlConnection.Open();
var productCollections = new List <ProductCollectionModel>();
using (var command = new SqlCommand("select distinct ProductModelId,thumbnailphoto from salesLt.Product where ProductModelid in (5, 11, 12, 123)", sqlConnection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ProductCollectionModel productCollection = new ProductCollectionModel();
productCollection.ProductImage = (byte[])reader[1];
productCollections.Add(productCollection);
}
}
}
sqlConnection.Close();
productCollections.ElementAt(0).ActiveClass = "active";
return(productCollections);
}
public List <ProductCollectionModel> GetProductCollectionsWithImage()
{
SqlConnection sqlConnection = new SqlConnection(AdoSqlConnection.ConnectionString);
sqlConnection.Open();
var productCollections = new List <ProductCollectionModel>();
using (var command = new SqlCommand("select top 4 ProductId,thumbnailphotofileName from salesLt.Product Order by ProductId desc", sqlConnection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ProductCollectionModel productCollection = new ProductCollectionModel();
productCollection.FileName = reader.GetString(1);
productCollections.Add(productCollection);
}
}
}
sqlConnection.Close();
productCollections.ElementAt(0).ActiveClass = "active";
return(productCollections);
}
public List <ProductCollectionModel> EditProduct(ProductCollectionModel productCollectionModel)
{
throw new NotImplementedException();
}
