public IActionResult postStore([FromBody] StoreAPIModel param) { bool exist = _context.Store.Any(x => x.Id == param.Id); if (!exist) { try { var data = new Store() { Code = param.Code, Address = param.Address, Address2 = param.Address2, Address3 = param.Address3, Address4 = param.Address4, City = param.City, DateOpen = param.DateOpen, Name = param.Name, Location = param.Location, Regional = param.Regional, StoreTypeId = param.StoreTypeId, TargetQty = param.TargetQty, WarehouseId = param.WarehouseId, TargetValue = param.TargetValue }; _context.Store.Add(data); _context.SaveChanges(); response.code = "1"; response.message = "Data has been successfully saved"; } catch (Exception ex) { response.code = "0"; response.message = ex.ToString(); } } else { response.code = "5"; response.message = "Data already exists"; } return(Ok(response)); }
public IActionResult getStoreById(int Id) { var param = _context.Store.Where(x => x.Id == Id).FirstOrDefault(); var model = new StoreAPIModel { Id = param.Id, Code = param.Code, Address = param.Address, Address2 = param.Address2, Address3 = param.Address3, Address4 = param.Address4, City = param.City, DateOpen = param.DateOpen, Name = param.Name, Location = param.Location, Regional = param.Regional, StoreTypeId = param.StoreTypeId, TargetQty = param.TargetQty, WarehouseId = param.WarehouseId, TargetValue = param.TargetValue }; return(Ok(model)); }
public IActionResult putStore(int id, [FromBody] StoreAPIModel param) { var dataObject = _context.Store.Where(x => x.Id == param.Id).First(); if (dataObject.Id != 0) { try { if (param.Address != null) { dataObject.Address = param.Address; } if (param.Address2 != null) { dataObject.Address2 = param.Address2; } if (param.Address3 != null) { dataObject.Address3 = param.Address3; } if (param.Address4 != null) { dataObject.Address4 = param.Address4; } if (param.Address != null) { dataObject.Address = param.Address; } if (param.City != null) { dataObject.City = param.City; } if (param.DateOpen != null) { dataObject.DateOpen = param.DateOpen; } if (param.Name != null) { dataObject.Name = param.Name; } if (param.Location != null) { dataObject.Location = param.Location; } if (param.Regional != null) { dataObject.Regional = param.Regional; } if (param.StoreTypeId != null) { dataObject.StoreTypeId = param.StoreTypeId; } if (param.TargetQty != null) { dataObject.TargetQty = param.TargetQty; } if (param.WarehouseId != null) { dataObject.WarehouseId = param.WarehouseId; } if (param.TargetValue != null) { dataObject.TargetValue = param.TargetValue; } _context.Store.Update(dataObject); _context.SaveChanges(); response.code = "1"; response.message = "Data has been successfully updated"; } catch (Exception ex) { response.code = "0"; response.message = ex.ToString(); } } else { response.code = "5"; response.message = "Data does not exists"; } return(Ok(response)); }