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