public IEnumerable <ProductQuantityModel> GetQuantities(int?ProductID)
{
List <ProductQuantityModel> productQuantites = new List <ProductQuantityModel>();
if (ProductID == null)
{
command = new SqlCommand("SELECT * FROM [ViewProductQuantities]", connection);
}
else
{
command = new SqlCommand("SELECT * FROM [ViewProductQuantities] WHERE ProductID = '" + ProductID + "'", connection);
}
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
ProductQuantityModel productQuantityModel = new ProductQuantityModel((int)Convert.ToInt64(reader["ProductID"]),
(int)Convert.ToInt64(reader["ProductQuantity"]));
productQuantites.Add(productQuantityModel);
}
}
connection.Close();
return(productQuantites);
}
public ActionResult SendProduct(ProductQuantityModel model)
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Login"));
}
if (model == null)
{
return(View());
}
using (var context = new WareHouseEntities())
{
var userID = Session["UserID"];
var user = context.Users.Find(userID);
if (user != null)
{
user.Quantity += model.Quantity;
context.SaveChanges();
ViewBag.Message = "Quantity " + model.Quantity + " was added successfully. Total quantity now is: " + user.Quantity;
return(Json(new { Error = false, Message = "Quantity " + model.Quantity + " was added successfully. Total quantity now is: " + user.Quantity }, JsonRequestBehavior.AllowGet));
}
return(Json(new { Error = true, Message = "Error in adding quantity." }, JsonRequestBehavior.AllowGet));
}
}
public IHttpActionResult AddOrUpdateProductQuantity(ProductQuantityModel request)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
request.CreatedBy = userId;
return(Ok(_product.AddOrUpdateProductQuantity(request)));
}
public ResultModel <ProductModel> AddOrUpdateProductQuantity(ProductQuantityModel Qty)
{
var result = new ResultModel <ProductModel>();
try
{
using (var context = new TitchyCottageEntities())
{
Qty.DateCode = DateTime.Now.ToString("MMddyyyy");
context.AddOrUpdateProductQuantity(Qty.ID, Qty.ProductID, Qty.Lot, Qty.DateCode, Qty.TotalQuantity, Qty.ExpiredDate, Qty.ManufacturerDate, Qty.CreatedBy);
result.Message = string.Concat(Qty.TotalQuantity.ToString(), " ", "Quantity has been added successfully.");
result.success = true;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.success = false;
logger.Error(ex.Message);
}
return(result);
}
public static ProductQuantity ToProductQuantity(this ProductQuantityModel entity)
{
return(entity.MapTo <ProductQuantityModel, ProductQuantity>());
}
