public JsonResult SaveDp(Context.SalesOrderPickupDp model)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPickup(model.SalesOrderPickupId);
if (model.Id == 0)
{
dbitem.SalesOrderPickup.SalesOrderPickupDp.Add(model);
var query = "INSERT INTO \"dbo\".\"SalesOrderPickupDp\" (\"SalesOrderPickupId\", \"Tanggal\", \"Penerima\", \"Jenis\", \"RekeningId\", \"Jumlah\") VALUES (" + model.SalesOrderPickupId +
", " + model.Tanggal + ", " + model.Penerima + ", " + model.Jenis + ", " + model.RekeningId + ", " + model.Jumlah + ");";
RepoAuditrail.SetAuditTrail(query, "Input DP", "List Order", UserPrincipal.id);
}
else
{
Context.SalesOrderPickupDp dbdp = dbitem.SalesOrderPickup.SalesOrderPickupDp.Where(d => d.Id == model.Id).FirstOrDefault();
dbdp.Tanggal = model.Tanggal;
dbdp.Penerima = model.Penerima;
dbdp.RekeningId = model.RekeningId;
dbdp.Jenis = model.Jenis;
dbdp.Jumlah = model.Jumlah;
var query = "UPDATE \"dbo\".\"SalesOrderPickupDp\" SET \"Tanggal\" = " + dbdp.Tanggal + ", \"Penerima\" = " + dbdp.Penerima + ", \"Jenis\" = \" = " + dbdp.Jenis +
", \"RekeningId\" = " + dbdp.RekeningId + "\"Jumlah\" = " + dbdp.Jumlah + " WHERE \"Id\" = " + dbdp.Id + ";";
RepoAuditrail.SetAuditTrail(query, "Input DP", "List Order", UserPrincipal.id);
}
RepoSalesOrder.save(dbitem);
ResponeModel response = new ResponeModel(true);
return(Json(response));
}
public JsonResult DeleteDp(int IdSo, int id)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPickup(IdSo);
Context.SalesOrderPickupDp dbdp = dbitem.SalesOrderPickup.SalesOrderPickupDp.Where(d => d.Id == id).FirstOrDefault();
dbitem.SalesOrderPickup.SalesOrderPickupDp.Remove(dbdp);
ResponeModel response = new ResponeModel(true);
var query = "DELETE FROM \"dbo\".\"SalesOrderPickupDp\" WHERE \"Id\"= " + id + ";";
RepoSalesOrder.save(dbitem);
RepoAuditrail.SetAuditTrail(query, "Input DP", "Delete SO Pickup", UserPrincipal.id);
return(Json(response));
}
