public IActionResult UpdateOutlet([FromBody] OutletViewModel outlet)
{
try
{
_outletService.Update(outlet);
return(Ok("Successfull"));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public void Update(OutletViewModel outletVM)
{
var outlet = _context.Outlets.FirstOrDefault(p => p.Id == outletVM.Id);
outlet.Name = outletVM.Name;
outlet.Phone = outletVM.Phone;
outlet.Address = outletVM.Address;
outlet.Latitude = outletVM.Latitude;
outlet.Longitude = outletVM.Longitude;
outlet.UpdatedEntity();
_context.Outlets.Update(outlet);
_context.SaveChanges();
}
public void Add(OutletViewModel outletVM)
{
Outlet outlet = new Outlet
{
Address = outletVM.Address,
Name = outletVM.Name,
Phone = outletVM.Phone,
Longitude = outletVM.Longitude,
Latitude = outletVM.Latitude
};
outlet.AddEntity();
_context.Add(outlet);
_context.SaveChanges();
}
public void Update(OutletViewModel outlet)
{
_outletRepository.Update(outlet);
}
public void Open(OutletViewModel outlet)
{
_outletRepository.Add(outlet);
}
public static ListPurchaseOrderViewModel GetDataByIdPO(int id)
{
ListPurchaseOrderViewModel result = new ListPurchaseOrderViewModel();
using (POSContext context = new POSContext())
{
result = (from op in context.TPurchaseOrder
where op.ID == id
select new ListPurchaseOrderViewModel()
{
ID = op.ID,
SupplierID = op.SupplierID,
StatusID = op.StatusID,
Notes = op.Notes,
OrderNo = op.OrderNo,
OutletID = op.OutletID,
CreatedBy = op.CreatedBy,
CreatedOn = op.CreatedOn,
}).FirstOrDefault();
PurchaseOrderViewModel employee = new PurchaseOrderViewModel();
employee = (from op in context.TPurchaseOrder
join us in context.TUser on op.CreatedBy equals us.Id
join ep in context.TEmployee on us.Email equals ep.Email
where op.ID == id
select new PurchaseOrderViewModel()
{
fullname = ep.FirstName + " " + ep.LastName,
email = ep.Email
}).FirstOrDefault();
result.PurchaseOrder = employee;
SuppliersViewModel supplier = new SuppliersViewModel();
supplier = (from op in context.TPurchaseOrder
join sp in context.TSuppliers on op.SupplierID equals sp.ID
join p in context.TProvince on sp.ProvinceID equals p.ID
join r in context.TRegion on sp.RegionID equals r.ID
join d in context.TDistrict on sp.DistrictID equals d.ID
where op.ID == id
select new SuppliersViewModel()
{
ID = sp.ID,
Address = sp.Address,
RegionName = r.RegionName,
RegionID = sp.RegionID,
ProvinceName = p.ProvinceName,
ProvinceID = sp.ProvinceID,
Phone = sp.Phone,
PostalCode = sp.PostalCode,
DistrictName = d.DistrictName,
DistrictID = sp.DistrictID,
Email = sp.Email,
Name = sp.Name
}).FirstOrDefault();
result.Supplier = supplier;
OutletViewModel outlet = new OutletViewModel();
outlet = (from op in context.TPurchaseOrder
join ot in context.TOutlet on op.OutletID equals ot.ID
join p in context.TProvince on ot.ProvinceID equals p.ID
join r in context.TRegion on ot.RegionID equals r.ID
where op.ID == id
select new OutletViewModel()
{
ID = ot.ID,
OutletName = ot.OutletName,
Phone = ot.Phone,
FullAddress = ot.Address + ", " + p.ProvinceName + ", " + r.RegionName + ", " + ot.PostalCode
}).FirstOrDefault();
result.Outlet = outlet;
List <PurchaseOrderDetailsViewModel> purchaseorderdetail = new List <PurchaseOrderDetailsViewModel>();
purchaseorderdetail = (from pod in context.TPurchaseOrderDetail
join ii in context.TItemsIventory on pod.VariantID equals ii.VariantID
join iv in context.TItemsVariant on pod.VariantID equals iv.ID
where pod.HeaderID == id
select new PurchaseOrderDetailsViewModel
{
ID = pod.ID,
VariantID = pod.VariantID,
VarianName = iv.VariantName,
InStok = ii.Beginning,
Quantity = pod.Quantity,
HeaderID = pod.HeaderID,
UnitCost = pod.UnitCost,
SubTotal = pod.SubTotal,
CreatedBy = pod.CreatedBy,
CreatedOn = pod.CreatedOn,
ModifiedBy = pod.ModifiedBy,
ModifiedOn = pod.ModifiedOn
}).ToList();
result.PurchaseOrderDetail = purchaseorderdetail;
}
return(result);
}
