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(); } }