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>()); }