private static Warehouse PopulateFromDBDetailsObject(WarehouseDetails obj)
{
Warehouse objNew = new Warehouse();
objNew.WarehouseId = obj.WarehouseId;
objNew.ClientNo = obj.ClientNo;
objNew.WarehouseName = obj.WarehouseName;
objNew.Inactive = obj.Inactive;
objNew.AddressNo = obj.AddressNo;
objNew.UpdatedBy = obj.UpdatedBy;
objNew.DLUP = obj.DLUP;
objNew.VirtualWarehouse = obj.VirtualWarehouse;
objNew.DefaultWarehouse = obj.DefaultWarehouse;
objNew.AddressName = obj.AddressName;
objNew.Line1 = obj.Line1;
objNew.Line2 = obj.Line2;
objNew.Line3 = obj.Line3;
objNew.County = obj.County;
objNew.City = obj.City;
objNew.State = obj.State;
objNew.ZIP = obj.ZIP;
objNew.CountryName = obj.CountryName;
objNew.CountryNo = obj.CountryNo;
return(objNew);
}
/// <summary>
/// Get
/// Calls [usp_select_Warehouse]
/// </summary>
public override WarehouseDetails Get(System.Int32?warehouseId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Warehouse", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@WarehouseId", SqlDbType.Int).Value = warehouseId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetWarehouseFromReader(reader);
WarehouseDetails obj = new WarehouseDetails();
obj.WarehouseId = GetReaderValue_Int32(reader, "WarehouseId", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.WarehouseName = GetReaderValue_String(reader, "WarehouseName", "");
obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false);
obj.AddressNo = GetReaderValue_NullableInt32(reader, "AddressNo", null);
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
obj.VirtualWarehouse = GetReaderValue_Boolean(reader, "VirtualWarehouse", false);
obj.DefaultWarehouse = GetReaderValue_Boolean(reader, "DefaultWarehouse", false);
obj.AddressName = GetReaderValue_String(reader, "AddressName", "");
obj.Line1 = GetReaderValue_String(reader, "Line1", "");
obj.Line2 = GetReaderValue_String(reader, "Line2", "");
obj.Line3 = GetReaderValue_String(reader, "Line3", "");
obj.County = GetReaderValue_String(reader, "County", "");
obj.City = GetReaderValue_String(reader, "City", "");
obj.State = GetReaderValue_String(reader, "State", "");
obj.ZIP = GetReaderValue_String(reader, "ZIP", "");
obj.CountryName = GetReaderValue_String(reader, "CountryName", "");
obj.CountryNo = GetReaderValue_NullableInt32(reader, "CountryNo", null);
return(obj);
}
else
{
return(null);
}
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get Warehouse", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// GetListForClient
/// Calls [usp_selectAll_Warehouse_for_Client]
/// </summary>
public override List <WarehouseDetails> GetListForClient(System.Int32?clientId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_selectAll_Warehouse_for_Client", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <WarehouseDetails> lst = new List <WarehouseDetails>();
while (reader.Read())
{
WarehouseDetails obj = new WarehouseDetails();
obj.WarehouseId = GetReaderValue_Int32(reader, "WarehouseId", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.WarehouseName = GetReaderValue_String(reader, "WarehouseName", "");
obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false);
obj.AddressNo = GetReaderValue_NullableInt32(reader, "AddressNo", null);
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
obj.VirtualWarehouse = GetReaderValue_Boolean(reader, "VirtualWarehouse", false);
obj.DefaultWarehouse = GetReaderValue_Boolean(reader, "DefaultWarehouse", false);
obj.AddressName = GetReaderValue_String(reader, "AddressName", "");
obj.Line1 = GetReaderValue_String(reader, "Line1", "");
obj.Line2 = GetReaderValue_String(reader, "Line2", "");
obj.Line3 = GetReaderValue_String(reader, "Line3", "");
obj.County = GetReaderValue_String(reader, "County", "");
obj.City = GetReaderValue_String(reader, "City", "");
obj.State = GetReaderValue_String(reader, "State", "");
obj.ZIP = GetReaderValue_String(reader, "ZIP", "");
obj.CountryName = GetReaderValue_String(reader, "CountryName", "");
obj.CountryNo = GetReaderValue_NullableInt32(reader, "CountryNo", null);
lst.Add(obj);
obj = null;
}
return(lst);
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get Warehouses", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
public async Task <IActionResult> AcceptDetailsToWarehouse([FromBody] ConfirmOrderDto confirmOrderDto)
{
var order = await _context.DetailOrders
.Include(o => o.DetailOrderRows)
.FirstOrDefaultAsync(o => o.DetailOrderId == confirmOrderDto.DetailOrderId);
if (order == null)
{
return(BadRequest());
}
var warehouseDetails = await _context.WarehouseDetails.Where(wd => wd.WarehouseId == confirmOrderDto.WarehouseId).ToListAsync();
foreach (var row in order.DetailOrderRows)
{
var warehouseDetail = warehouseDetails.FirstOrDefault(wd => wd.DetailId == row.DetailId);
if (warehouseDetail == null)
{
warehouseDetail = new WarehouseDetails()
{
WarehouseId = confirmOrderDto.WarehouseId,
DetailId = row.DetailId.Value,
Count = row.Count
};
}
else
{
warehouseDetail.Count += row.Count;
}
await _context.Comings.AddAsync(new Comings
{
Date = DateTime.UtcNow,
DetailOrderRowId = row.DetailOrderRowId,
WarehouseDetail = warehouseDetail,
WorkerId = confirmOrderDto.WorkerId
});
}
await _context.SaveChangesAsync();
return(NoContent());
}
public async Task <IActionResult> PutWarehouseDetails([FromBody] MovementDto[] movementDtos)
{
foreach (var movementDto in movementDtos)
{
var fromWarehouseDetail = await _context.WarehouseDetails.FirstOrDefaultAsync(wd => wd.WarehouseDetailId == movementDto.FromWarehouseDetailId);
fromWarehouseDetail.Count -= movementDto.Count;
var toWarehouseDetail = await _context.WarehouseDetails
.Where(wd => wd.WarehouseId == movementDto.ToWarehouseId)
.FirstOrDefaultAsync(wd => wd.DetailId == movementDto.DetailId);
if (toWarehouseDetail == null)
{
toWarehouseDetail = new WarehouseDetails()
{
DetailId = movementDto.DetailId,
WarehouseId = movementDto.ToWarehouseId,
Count = movementDto.Count
};
}
else
{
toWarehouseDetail.Count += movementDto.Count;
}
await _context.WarehouseMovements.AddAsync(new WarehouseMovements()
{
FromWarehouseDetailId = fromWarehouseDetail.WarehouseDetailId,
ToWarehouseDetail = toWarehouseDetail,
Date = DateTime.UtcNow,
WorkerId = movementDto.WorkerId,
Count = movementDto.Count
});
}
await _context.SaveChangesAsync();
return(NoContent());
}
/// <summary>
/// DropDownForClient
/// Calls [usp_dropdown_Warehouse_for_Client]
/// </summary>
public override List <WarehouseDetails> DropDownForClient(System.Int32?clientId, System.Boolean?includeVirtual)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_dropdown_Warehouse_for_Client", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cmd.Parameters.Add("@IncludeVirtual", SqlDbType.Bit).Value = includeVirtual;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <WarehouseDetails> lst = new List <WarehouseDetails>();
while (reader.Read())
{
WarehouseDetails obj = new WarehouseDetails();
obj.WarehouseId = GetReaderValue_Int32(reader, "WarehouseId", 0);
obj.WarehouseName = GetReaderValue_String(reader, "WarehouseName", "");
lst.Add(obj);
obj = null;
}
return(lst);
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get Warehouses", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// GetDefault
/// Calls [usp_select_Warehouse_Default]
/// </summary>
public override WarehouseDetails GetDefault(System.Int32?clientId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Warehouse_Default", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetWarehouseFromReader(reader);
WarehouseDetails obj = new WarehouseDetails();
obj.WarehouseId = GetReaderValue_Int32(reader, "WarehouseId", 0);
return(obj);
}
else
{
return(null);
}
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get Warehouse", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
