public ActionResult Delete([FromBody] ICRUDModel <HistorySaleView> entity) { if (entity.key != null) { if (User.IsInRole("admin")) { int result = data.SqlExecuteProc("SP_DeleteProductSale", new { Id = Convert.ToInt32(entity.key) }); return(Json(entity.value)); } else { var result = data.SqlQuery <HistorySaleView>("select * from HistorySaleView where Id = @myId", new { myId = entity.key }).FirstOrDefault(); if (result != null) { if (result.RegDt.Value.Date == DateTime.Now.Date) { data.SqlExecuteProc("SP_DeleteProductSale", new { Id = Convert.ToInt32(entity.key) }); return(Json(entity.value)); } } return(StatusCode(406, "Вы не можете удалить вчерашний запись")); } } else { return(StatusCode(406, "Вы передаете пустую значению!")); } }
public ActionResult BatchSave([FromBody] ICRUDModel <GanttData> data) { List <GanttData> uAdded = new List <GanttData>(); List <GanttData> uChanged = new List <GanttData>(); List <GanttData> uDeleted = new List <GanttData>(); //Performing insert operation if (data.added != null && data.added.Count() > 0) { foreach (var rec in data.added) { uAdded.Add(this.Create(rec)); } } //Performing update operation if (data.changed != null && data.changed.Count() > 0) { foreach (var rec in data.changed) { uChanged.Add(this.Edit(rec)); } } //Performing delete operation if (data.deleted != null && data.deleted.Count() > 0) { foreach (var rec in data.deleted) { uDeleted.Add(this.Delete(rec.TaskId)); } } return(Json(new { addedRecords = uAdded, changedRecords = uChanged, deletedRecords = uDeleted })); }
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)); }
public ActionResult Delete([FromBody] ICRUDModel <Units> entity) { if (!ModelState.IsValid) // если проверка не удалась { var message = string.Join(" | ", ModelState.Values.SelectMany(v => v.Errors).Select(e => e.ErrorMessage)); return(new BadRequestObjectResult(HttpStatusCode.BadRequest));//message returns the exception content } int result = data.Remove <Units>(Convert.ToInt32(entity.key)); return(Json(entity.value)); }
public ActionResult Insert([FromBody] ICRUDModel <Units> value) { if (!ModelState.IsValid) // если проверка не удалась { var message = string.Join(" | ", ModelState.Values.SelectMany(v => v.Errors).Select(e => e.ErrorMessage)); BadRequestObjectResult badRequest = new BadRequestObjectResult(HttpStatusCode.BadRequest); badRequest.Value = "Ошибка добавление"; } int result = data.Add <Units>(value.value); return(Json(value.value)); }
public ActionResult Delete([FromBody] ICRUDModel <ProductIncoms> entity) { try { int result = data.SqlExecuteProc("SP_DeleteProductIncome", new { Id = Convert.ToInt32(entity.key) }); return(Json(entity.value)); } catch (Exception ex) { return(StatusCode(400, ex.Message)); } }
public ActionResult Update([FromBody] ICRUDModel <OrdersDetails> value) { var ord = value.value; OrdersDetails val = OrdersDetails.GetAllRecords().Where(or => or.OrderID == ord.OrderID).FirstOrDefault(); val.OrderID = ord.OrderID; val.EmployeeID = ord.EmployeeID; val.CustomerID = ord.CustomerID; val.Freight = ord.Freight; val.OrderDate = ord.OrderDate; val.ShipCity = ord.ShipCity; return(Json(value.value)); }
public ActionResult Update([FromBody] ICRUDModel <Products> entity) { if (!ModelState.IsValid) // если проверка не удалась { var message = string.Join(" | ", ModelState.Values.SelectMany(v => v.Errors).Select(e => e.ErrorMessage)); BadRequestObjectResult badRequest = new BadRequestObjectResult(HttpStatusCode.BadRequest); badRequest.Value = "Ошибка изменение модели"; } double?Amount = entity.value.Amount; entity.value.Amount = null; int result = data.Update <Products>(entity.value); entity.value.Amount = Amount; return(Json(entity.value)); }
public ActionResult Update([FromBody] ICRUDModel <ProductIncoms> entity) { data.Update <ProductIncoms>(entity.value); return(Json(entity.value)); }
public ActionResult Delete([FromBody] ICRUDModel <Customers> entity) { int result = data.Remove <Customers>(Convert.ToInt32(entity.key)); return(Json(entity.value)); }
public ActionResult Update([FromBody] ICRUDModel <Customers> entity) { int result = data.Update <Customers>(entity.value); return(Json(entity.value)); }
public ActionResult Insert([FromBody] ICRUDModel <Customers> value) { int result = data.Add <Customers>(value.value); return(Json(value.value)); }
public ActionResult Delete([FromBody] ICRUDModel <OrdersDetails> value) { OrdersDetails.GetAllRecords().Remove(OrdersDetails.GetAllRecords().Where(or => or.OrderID == int.Parse(value.key.ToString())).FirstOrDefault()); return(Json(value)); }
public ActionResult Insert([FromBody] ICRUDModel <OrdersDetails> value) { OrdersDetails.GetAllRecords().Insert(0, value.value); return(Json(value.value)); }
public ActionResult Delete([FromBody] ICRUDModel <ProductSales> entity) { int result = data.SqlExecuteProc("SP_DeleteProductSale", new { Id = Convert.ToInt32(entity.key) }); return(Json(entity.value)); }
public ActionResult Update([FromBody] ICRUDModel <ProductTypes> entity) { int result = data.Update <ProductTypes>(entity.value); return(Json(entity.value)); }
public ActionResult Insert([FromBody] ICRUDModel <ProductTypes> value) { int result = data.Add <ProductTypes>(value.value); return(Json(value.value)); }