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 Boolean DeleteCartonByShippingNumber(String ShippingNumber)
{
Boolean _return = false;
try
{
var lscartonInfo = (from ls in entx3v6.CartonInfoes
where ls.ShipmentNumber == ShippingNumber
select ls).ToList();
foreach (var item in lscartonInfo)
{
CartonInfo crton = (CartonInfo)item;
entx3v6.DeleteObject(crton);
}
entx3v6.SaveChanges();
}
catch (Exception)
{
}
return(_return);
}
