public ActionResult Insert([FromBody] ProductSales[] entity) { if (entity == null) { return(Json("null")); } int customerid; int lastorder = data.SqlQuery <int>("select * from LastOrderView").FirstOrDefault(); if (lastorder <= 0) { lastorder = 1; } foreach (var item in entity) { if (User.FindFirstValue("UserId") != null) { item.UserId = Convert.ToInt32(User.FindFirstValue("UserId")); } var dataa = data.GetById <Products>(item.Id); dataa.costs = data.SqlQuery <AvCurrentCosts>("select * from AvCurrentCosts where ProductId = @prodId", new { prodId = item.Id }).FirstOrDefault(); if (dataa.costs != null) { item.IncomeCost = dataa.costs.IncomeCost; } item.ProductId = item.Id; if (item.CustomerId == null || item.CustomerId <= 0) { customerid = data.SqlQuery <int>("select TOP 1 Id from Customers").FirstOrDefault(); if (customerid > 0) { item.CustomerId = customerid; } } item.OrderNumber = lastorder; } List <object> idi = new List <object> (); foreach (var item in entity) { int result = data.SqlExecuteProc("SP_AddProductSale", item); if (result < 0) { string Name = ""; Name = data.GetById <Products>(item.Id).Name; idi.Add(new { Id = item.Id, Name }); } } if (idi.Count == 0) { return(Json("Успешно сохранено!")); } else { return(Json(idi)); } }
[HttpPost] // Для История прихода (старый) на гриде диалоговое окно public ActionResult InsertCosts(ProductIncomeCostModel entity) { try { int result = data.SqlExecuteProc("SP_AddCostByProductType", entity); return(Ok("Успешно изменено!")); } catch (Exception ex) { return(StatusCode(123, ex.Message)); } }
[HttpPost] // возвращаем товар public ActionResult Insert(HistorySaleView entity) { try { double sales = data.SqlQuery <double>("select SaleCost from ProductSales where Id = @id", new { id = entity.Id }).FirstOrDefault(); if (sales != 0) { if (entity.SaleCost > sales) { return(Ok("-1")); } } else { return(Ok("-1")); } int usrid = 0; if (User.FindFirstValue("UserId") != null) { usrid = Convert.ToInt32(User.FindFirstValue("UserId")); } int result = data.SqlExecuteProc("SP_AddProductReturn", new { Id = 0, Amount = entity.Amount, Comments = entity.Comments, ProductSaleId = entity.Id, UserId = usrid, RegDT = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("Central Asia Standard Time")) }); if (result > 0) { return(Ok("1")); } else { return(Ok("-1")); } } catch (Exception e) { return(Ok(e.Message)); } }
public ActionResult Delete([FromBody] ICRUDModel <ReturnView> entity) { if (!ModelState.IsValid) // если проверка не удалась { return(new BadRequestObjectResult(HttpStatusCode.BadRequest)); //message returns the exception content } int result = data.SqlExecuteProc("SP_DeleteProductReturn", new { Id = entity.key }); return(Json(entity.value)); }