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