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