public String GetCarton(String BoxNumber)
{
String _return = "";
int total = 0;
int outOf = 1;
List <cstCartonInfo> _CartonByShipmentNumber = _carton.GetCartonByShipmentNumber(Global.ShippingNumber);
cstCartonInfo _cartonBox = _CartonByShipmentNumber.SingleOrDefault(i => i.BOXNumber == BoxNumber);
foreach (var item in _CartonByShipmentNumber)
{
if (item.CartonNumber == _cartonBox.CartonNumber)
{
total = total + 1;
if (item.Printed != 0)
{
outOf = outOf + 1;
}
}
}
if (total < outOf)
{
outOf = total - 1;
}
_return = outOf.ToString() + " of " + total.ToString();
return(_return);
}
public List <cstCartonInfo> GetCartonByShipmentNumber(string ShipmentNumber)
{
List <cstCartonInfo> lsreturn = new List <cstCartonInfo>();
try
{
var allBoxInfo = from b in entx3v6.CartonInfoes
where b.ShipmentNumber == ShipmentNumber
select b;
foreach (var _caritem in allBoxInfo)
{
cstCartonInfo _carton = new cstCartonInfo();
_carton.CartonID = _caritem.CartonID;
_carton.BOXNumber = _caritem.BOXNumber;
_carton.CartonNumber = _caritem.CartonNumber;
_carton.ShipmentNumber = _caritem.ShipmentNumber;
_carton.Printed = _caritem.Printed;
lsreturn.Add(_carton);
}
}
catch (Exception)
{ }
return(lsreturn);
}
public void SavePrinted(String BoxNumber)
{
try
{
cmdCartonInfo car = new cmdCartonInfo();
cstCartonInfo _cartonBox = Global.controller.GetAllCartonInfoByBoxNumber(BoxNumber).FirstOrDefault();
_cartonBox.Printed = 1;
car.UpdateCartonInfo(_cartonBox);
}
catch (Exception Ex)
{
ErrorLoger.save("wndBoxInfo - SavePrinted", "[" + DateTime.UtcNow.ToString() + "]" + Ex.ToString(), DateTime.UtcNow, Global.LoggedUserId);
}
}
public Guid UpdateCartonInfo(cstCartonInfo lscartonInfo)
{
Guid _return = Guid.Empty;
try
{
CartonInfo _caton = entx3v6.CartonInfoes.SingleOrDefault(i => i.BOXNumber == lscartonInfo.BOXNumber);
_caton.Printed = lscartonInfo.Printed;
entx3v6.SaveChanges();
_return = _caton.CartonID;
}
catch (Exception)
{ }
return(_return);
}
public cstCartonInfo GetByCaronID(Guid CartonID)
{
cstCartonInfo lsreturn = new cstCartonInfo();
try
{
CartonInfo allBoxInfo = entx3v6.CartonInfoes.FirstOrDefault(i => i.CartonID == CartonID);
lsreturn.CartonID = allBoxInfo.CartonID;
lsreturn.BOXNumber = allBoxInfo.BOXNumber;
lsreturn.CartonNumber = allBoxInfo.CartonNumber;
lsreturn.ShipmentNumber = allBoxInfo.ShipmentNumber;
lsreturn.Printed = allBoxInfo.Printed;
}
catch (Exception)
{ }
return(lsreturn);
}
/// <summary>
/// Save Box information to the database
/// </summary>
/// <param name="lscartonInfo">list of information of box</param>
/// <returns>Guid of New Box Id</returns>
public Guid SaveCartonInfo(cstCartonInfo lscartonInfo)
{
Guid _return = Guid.Empty;
try
{
CartonInfo _caton = new CartonInfo();
_caton.CartonID = lscartonInfo.CartonID;
_caton.BOXNumber = lscartonInfo.BOXNumber;
_caton.CartonNumber = lscartonInfo.CartonNumber;
_caton.ShipmentNumber = lscartonInfo.ShipmentNumber;
_caton.Printed = lscartonInfo.Printed;
entx3v6.AddToCartonInfoes(_caton);
entx3v6.SaveChanges();
_return = _caton.CartonID;
}
catch (Exception)
{ }
return(_return);
}
public Guid SaveCartonInfo(cstCartonInfo _CatonInfo)
{
cmdCartonInfo cmd = new cmdCartonInfo();
return(cmd.SaveCartonInfo(_CatonInfo));
}
