/// <summary>
/// Get Tracking Table information by Tracking Number
/// </summary>
/// <param name="TrackingNumber">
/// String Tracking Number.
/// </param>
/// <returns>
/// CstTrackingTbl information Object.
/// </returns>
public cstTrackingTbl GetTrackingTblByTrackingNumber(String TrackingNumber)
{
cmdTracking Command = new cmdTracking();
return(Command.GetTrackingByTrackingNumber(TrackingNumber));
}
/// <summary>
/// get the information from tracking Table about Box number.
/// </summary>
/// <param name="BoxNumber">
/// String Box Number.
/// </param>
/// <returns>
/// list Of cstTrackingTbl filtered by Box number.
/// </returns>
public List <cstTrackingTbl> GetTrackingTbl(String BoxNumber)
{
cmdTracking command = new cmdTracking();
return(command.GetTrackTbl(BoxNumber));
}
/// <summary>
/// Tracking Table information With filter Packing ID and Shipping ID
/// </summary>
/// <param name="PackingID">Guid Packing Table ID</param>
/// <param name="ShippingID">Guid Shipping Tabel ID</param>
/// <returns> List<cstTrackingTbl> Information</returns>
public List <cstTrackingTbl> GetTrackingTbl(Guid PackingID, Guid ShipppingID)
{
cmdTracking command = new cmdTracking();
return(command.GetTrackTbl(PackingID, ShipppingID));
}
/// <summary>
/// All Table Withaout any filter
/// </summary>
/// <returns>List<cstTrackingTbl> Inforamtion</returns>
public List <cstTrackingTbl> GetTrackingTbl()
{
cmdTracking command = new cmdTracking();
return(command.GetTrackTbl());
}
/// <summary>
/// Update Table Tracking For Ready to export flag.
/// </summary>
/// <param name="TrackingNumber"></param>
/// <param name="BoxNumber"></param>
/// <param name="Flag_ReadyTOExport">
/// Booelan Value
/// </param>
/// <returns></returns>
public Boolean UpdateTrackingReadyTOExport(String TrackingNumber, String BoxNumber, Boolean Flag_ReadyTOExport)
{
cmdTracking command = new cmdTracking();
return(command.UpdateReadyTOExport(TrackingNumber, BoxNumber, Flag_ReadyTOExport));
}
/// <summary>
/// Tracking Table information With filter Packing ID and Shipping ID
/// </summary>
/// <param name="ShippingID"> Shipping Table Guid</param>
/// <returns> List<cstTrackingTbl> Information</returns>
public List <cstTrackingTbl> GetTrackingTblShippingID(Guid ShippingID)
{
cmdTracking command = new cmdTracking();
return(command.GetTrackTblShippingIDOnly(ShippingID));
}
/// <summary>
/// Check that box has tracking number or not
/// </summary>
/// <param name="BoxNum"></param>
/// <returns></returns>
public String IsTrackingNum(string BoxNum)
{
cmdTracking _tracking = new cmdTracking();
return(_tracking.IschecckTrackingNumberPresent(BoxNum));
}
/// <summary>
/// Shipment number serch for information of packing status
/// </summary>
/// <param name="ShippingNumber">String Shipping Number</param>
/// <returns>List<cstShipmentNumStatus> depending on location retuersn shipping number information</returns>
public List <cstShipmentNumStatus> GetStaus(String ShippingNumber)
{
List <cstShipmentNumStatus> _lsStatus = new List <cstShipmentNumStatus>();
try
{
var frmPackage = from pac in ent.Packages
where pac.ShippingNum == ShippingNumber
select pac;
foreach (var item in frmPackage)
{
cstShipmentNumStatus Statusnumber = new cstShipmentNumStatus();
String PackingStatus = "UnderPacking";
int PackingStatusInt = 4;
if (item.PackingStatus == 0)
{
PackingStatus = "Packed";
PackingStatusInt = 5;
}
try
{
cmdBox _box = new cmdBox();
cmdTracking tracking = new cmdTracking();
string trackingNO = "";
List <cstBoxPackage> lsBoxpackage = _box.GetSelectedByPackingID(item.PackingId);
foreach (cstBoxPackage Boxitem in lsBoxpackage)
{
if (tracking.IschecckTrackingNumberPresent(Boxitem.BOXNUM) == "")
{
trackingNO = "";
break;
}
else
{
trackingNO = tracking.IschecckTrackingNumberPresent(Boxitem.BOXNUM);
}
}
if (trackingNO != "" && trackingNO != null)
{
PackingStatus = "Traking";
PackingStatusInt = 6;
}
}
catch (Exception)
{
}
Statusnumber.PackageID = item.PackingId;
Statusnumber.ShippingNum = item.ShippingNum;
Statusnumber.ShippinStatus = PackingStatus;
Statusnumber.ShippingCompletedInt = PackingStatusInt;
Statusnumber.Location = item.ShipmentLocation;
int indexofls = _lsStatus.FindLastIndex(i => i.ShippingNum == ShippingNumber && i.Location == item.ShipmentLocation);
if (indexofls.ToString() != "-1")
{
if (_lsStatus[indexofls].ShippingCompletedInt <= PackingStatusInt)
{
_lsStatus[indexofls].ShippinStatus = PackingStatus;
_lsStatus[indexofls].ShippingCompletedInt = PackingStatusInt;
}
}
else
{
_lsStatus.Add(Statusnumber);
}
}
}
catch (Exception)
{ }
return(_lsStatus);
}
