public int ChangeCommodityUnit(CommodityUnit commodityUnit)
{
_logger.Info($"DAL.{nameof(CommodityUnitDao)}.{nameof(ChangeCommodityUnit)}: Commodity unit change");
int id = commodityUnit.Id ?? -1;
if (id == -1)
{
_logger.Error($"DAL.{nameof(CommodityUnitDao)}.{nameof(ChangeCommodityUnit)}: commodityUnit.Id cannot be null");
throw new ArgumentNullException("commodityUnit.Id cannot be null");
}
try
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
SqlCommand command = new SqlCommand("dbo.Product_Store_Vendor_Status_ChangeCommodityUnit", connection)
{
CommandType = System.Data.CommandType.StoredProcedure
};
object ProductID, StatusID, StoreID, VendorID = null;
ProductID = commodityUnit?.Product?.Id;
StatusID = commodityUnit?.Status?.Id;
StoreID = commodityUnit?.Store?.Id;
VendorID = commodityUnit?.Vendor?.Id;
command.Parameters.AddWithValue("@Id", commodityUnit.Id);
command.Parameters.AddWithValue("@ProductID", ProductID ?? DBNull.Value);
command.Parameters.AddWithValue("@StatusID", StatusID ?? DBNull.Value);
command.Parameters.AddWithValue("@StoreID", StoreID ?? DBNull.Value);
command.Parameters.AddWithValue("@VendorID", VendorID ?? DBNull.Value);
command.Parameters.AddWithValue("@Price", commodityUnit.Price);
connection.Open();
_logger.Info($"DAL.{nameof(CommodityUnitDao)}.{nameof(ChangeCommodityUnit)}: Connected to database");
command.ExecuteScalar();
}
}
catch (InvalidOperationException ex)
{
_logger.Error($"DAL.{nameof(CommodityUnitDao)}.{nameof(ChangeCommodityUnit)}: Not connected to database: " + ex.Message);
throw new SystemException("Connection error", ex);
}
_logger.Info($"DAL.{nameof(CommodityUnitDao)}.{nameof(ChangeCommodityUnit)}: Commodity unit id = {id} changed");
return(id);
}
public int AddCommodityUnit(CommodityUnit commodityUnit)
{
_logger.Info($"DAL.{nameof(CommodityUnitDao)}.{nameof(AddCommodityUnit)}: Adding a commodity unit");
int id;
try
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
SqlCommand command = new SqlCommand("dbo.Product_Store_Vendor_Status_AddCommodityUnit", connection)
{
CommandType = System.Data.CommandType.StoredProcedure
};
object ProductID, StatusID, StoreID, VendorID = null;
ProductID = commodityUnit?.Product?.Id;
StatusID = commodityUnit?.Status?.Id;
StoreID = commodityUnit?.Store?.Id;
VendorID = commodityUnit?.Vendor?.Id;
command.Parameters.AddWithValue("@ProductID", ProductID ?? DBNull.Value);
command.Parameters.AddWithValue("@StatusID", StatusID ?? DBNull.Value);
command.Parameters.AddWithValue("@StoreID", StoreID ?? DBNull.Value);
command.Parameters.AddWithValue("@VendorID", VendorID ?? DBNull.Value);
command.Parameters.AddWithValue("@Price", commodityUnit.Price);
connection.Open();
_logger.Info($"DAL.{nameof(CommodityUnitDao)}.{nameof(AddCommodityUnit)}: Connected to database");
int.TryParse(command.ExecuteScalar().ToString(), out id);
}
}
catch (InvalidOperationException ex)
{
_logger.Error($"DAL.{nameof(CommodityUnitDao)}.{nameof(AddCommodityUnit)}: Not connected to database: " + ex.Message);
throw new SystemException("Connection error", ex);
}
_logger.Info($"DAL.{nameof(CommodityUnitDao)}.{nameof(AddCommodityUnit)}: Commodity unit id = {id} added");
return(id);
}
public async Task <IActionResult> GetCommodityUnitById(int commodityUnitId)
{
try
{
var _serviceEndPoint = new ServicesEndPoint(_unitOfWork, _emailService);
CommodityUnit res = await _serviceEndPoint.GetCommodityUnitById(commodityUnitId);
CommodityUnitViewModel results = _Mapper.Map <CommodityUnitViewModel>(res);
if (results == null)
{
return(NotFound(results));
}
return(Ok(results));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <IActionResult> SelectCommodityUnit([FromBody] CommodityUnitViewModel commodityUnitViewModel)
{
try
{
var _serviceEndPoint = new ServicesEndPoint(_unitOfWork, _emailService);
var commodityUnit = _Mapper.Map <CommodityUnit>(commodityUnitViewModel);
CommodityUnit result = await _serviceEndPoint.SelectCommodityUnit(commodityUnit);
if (result == null)
{
return(NotFound(commodityUnitViewModel));
}
return(Ok(new { message = "Succesfully Selected!", result = result }));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public JsonResult Edit(CommodityUnit model)
{
var apiResult = new APIResult();
try
{
CommodityUnitBll.AddOrUpdate(model, UserContext.CurrentUser.Name, UserContext.CurrentUser.HotelId);
}
catch (Exception ex)
{
apiResult.Ret = -1;
apiResult.Msg = ex.Message;
if (!(ex is OperationExceptionFacade))
{
LogFactory.GetLogger().Log(LogLevel.Error, ex);
}
}
return(Json(apiResult));
}
public int SetCommodityUnit(CommodityUnit commodityUnit)
{
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Retention of commodity unit");
if (commodityUnit.Product != null)
{
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Product discovered");
commodityUnit.Product.Id = _productBll.SetProduct(commodityUnit.Product);
if (commodityUnit.Product.Category != null)
{
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Category discovered");
commodityUnit.Product.Category.Id = _categoryBll.SetCategory(commodityUnit.Product.Category);
}
else
{
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Category not discovered");
}
}
else
{
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Product not discovered");
}
if (commodityUnit.Status != null)
{
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Status discovered");
commodityUnit.Status.Id = _statusBll.SetStatus(commodityUnit.Status);
}
else
{
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Status not discovered");
}
if (commodityUnit.Store != null)
{
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Store discovered");
commodityUnit.Store.Id = _storeBll.SetStore(commodityUnit.Store);
}
else
{
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Store not discovered");
}
if (commodityUnit.Vendor != null)
{
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Vendor discovered");
commodityUnit.Vendor.Id = _vendorBll.SetVendor(commodityUnit.Vendor);
}
else
{
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Vendor not discovered");
}
if (commodityUnit.Id != null)
{
int id = _commodityUnitDao.ChangeCommodityUnit(commodityUnit);
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Commodity unit id = {id} changed");
return(id);
}
else
{
int id = _commodityUnitDao.AddCommodityUnit(commodityUnit);
_logger.Info($"BLL.{nameof(CommodityUnitBll)}.{nameof(SetCommodityUnit)}: Commodity unit id = {id} added");
return(id);
}
}
