public async Task <Warehouse> UpdateAsync(int id, UpdateWarehouseModel item)
{
if (await _warehouseRepository.IsCityUniqueAsync(id, item.City))
{
var warehouse = _mapper.Map <WarehouseModel, Warehouse>(item);
warehouse.Id = id;
await _warehouseRepository.UpdateAsync(warehouse);
return(warehouse);
}
else
{
throw new System.Exception("Warehouse with this city name already exists");
}
}
public async Task <IActionResult> Update([FromRoute] int id, [FromBody] UpdateWarehouseModel item)
{
item.Id = id;
var result = _updateWarehouseValidator.Validate(item);
if (result.IsValid)
{
var updated = await _warehouseService.UpdateAsync(id, item);
return(Ok(updated));
}
else
{
return(BadRequest(result.Errors.Select(t => t.ErrorMessage)));
}
}
internal DataTable SaveUpdWareHouse(UpdateWarehouseModel ObjUpdWarehouseModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPWarehouse";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjUpdWarehouseModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@User", ObjUpdWarehouseModel.User);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjUpdWarehouseModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@GSTINID", ObjUpdWarehouseModel.GSTINID);
ClsCon.cmd.Parameters.AddWithValue("@Address", ObjUpdWarehouseModel.Address);
ClsCon.cmd.Parameters.AddWithValue("@City", ObjUpdWarehouseModel.City);
ClsCon.cmd.Parameters.AddWithValue("@StateID", ObjUpdWarehouseModel.StateID);
ClsCon.cmd.Parameters.AddWithValue("@PinCode", ObjUpdWarehouseModel.PinCode);
ClsCon.cmd.Parameters.AddWithValue("@IP", ObjUpdWarehouseModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", ObjUpdWarehouseModel.WareHouseID);
// ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjWarehouseModel.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdWarehouse = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdWarehouse);
dtUpdWarehouse.TableName = "success";
}
catch (Exception)
{
dtUpdWarehouse = new DataTable();
dtUpdWarehouse.TableName = "error";
return(dtUpdWarehouse);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdWarehouse);
}
internal DataTable SearchItem(UpdateWarehouseModel ObjUpdWarehouseModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPWarehouse";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjUpdWarehouseModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjUpdWarehouseModel.OrgID);
// ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjUpdWarehouseModel.BrID);
// ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjUpdWarehouseModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", ObjUpdWarehouseModel.WareHouseID);
// ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjWarehouseModel.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdWarehouse = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdWarehouse);
dtUpdWarehouse.TableName = "success";
}
catch (Exception)
{
dtUpdWarehouse = new DataTable();
dtUpdWarehouse.TableName = "error";
return(dtUpdWarehouse);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdWarehouse);
}
public DataTable SaveWarehouseData(UpdateWarehouseModel ObjUpdWarehouseModel)
{
DataTable Savinglist = objUpdWDA.SaveUpdWareHouse(ObjUpdWarehouseModel);
return(Savinglist);
}
public DataTable SearchControl(UpdateWarehouseModel ObjUpdWarehouseModel)
{
DataTable Searchitem = objUpdWDA.SearchItem(ObjUpdWarehouseModel);
return(Searchitem);
}
public DataTable StateList(UpdateWarehouseModel ObjUpdWarehouseModel)
{
DataTable fillStateList = objUpdWDA.LoadState(ObjUpdWarehouseModel);
return(fillStateList);
}
public DataTable fillWarehouse(UpdateWarehouseModel ObjUpdWarehouseModel)
{
DataTable fillWareHouseList = objUpdWDA.LoadWareHouse(ObjUpdWarehouseModel);
return(fillWareHouseList);
}
