/// <summary>
/// Get BoxPackage Table information sorted by BOXNUM
/// </summary>
/// <param name="BoxNumber">String Box Nuber</param>
/// <returns>BoxPackage Object </returns>
public cstBoxPackage GetSelectedByBoxNumber(String BoxNumber)
{
cstBoxPackage _return = new cstBoxPackage();
try
{
BoxPackage _boxitem = entx3v6.BoxPackages.SingleOrDefault(i => i.BOXNUM == BoxNumber);
cstBoxPackage _box = new cstBoxPackage();
_box.BoxID = Guid.NewGuid();
_box.PackingID = _boxitem.PackingID;
_box.BoxType = _boxitem.BoxType;
_box.BoxWeight = Convert.ToDouble(_boxitem.BoxWeight);
_box.BoxLength = Convert.ToDouble(_boxitem.BoxLength);
_box.BoxHeight = Convert.ToDouble(_boxitem.BoxHeight);
_box.BoxWidth = Convert.ToDouble(_boxitem.BoxWidth);
_box.BoxCreatedTime = Convert.ToDateTime(_boxitem.BoxCreatedTime);
_box.BoxMeasurementTime = Convert.ToDateTime(_boxitem.BoxMeasurementTime);
_box.ROWID = _boxitem.ROWID;
_box.BOXNUM = _boxitem.BOXNUM;
_return = _box;
}
catch (Exception)
{ }
return(_return);
}
/// <summary>
/// Save Box information to the database
/// </summary>
/// <param name="lsBoxpackage">list of information of box</param>
/// <returns>Guid of New Box Id</returns>
public Guid SaveBoxPackage(List <cstBoxPackage> lsBoxpackage)
{
Guid _return = Guid.Empty;
try
{
foreach (var _boxitem in lsBoxpackage)
{
BoxPackage _boxPackage = new BoxPackage();
_boxPackage.BoxID = Guid.NewGuid();
_boxPackage.PackingID = _boxitem.PackingID;
_boxPackage.BoxType = _boxitem.BoxType;
_boxPackage.BoxWeight = _boxitem.BoxWeight;
_boxPackage.BoxLength = _boxitem.BoxLength;
_boxPackage.BoxHeight = _boxitem.BoxHeight;
_boxPackage.BoxWidth = _boxitem.BoxWidth;
_boxPackage.BoxCreatedTime = _boxitem.BoxCreatedTime;
if (_boxitem.BoxMeasurementTime.Date != Convert.ToDateTime("01/01/001").Date)
{
_boxPackage.BoxMeasurementTime = _boxitem.BoxMeasurementTime;
}
entx3v6.AddToBoxPackages(_boxPackage);
_return = _boxPackage.BoxID;
}
entx3v6.SaveChanges();
}
catch (Exception)
{}
return(_return);
}
/// <summary>
/// Set the Package information to the Database
/// </summary>
/// <param name="TMeasures">Measurements came from the machin</param>
/// <returns>Tru if save successfully else fail</returns>
public override Boolean setPackageInfo(Measures TMeasures)
{
x3v6Entities x3ent = new x3v6Entities();
Boolean _retutn = false;
try
{
BoxPackage _rPackage = x3ent.BoxPackages.SingleOrDefault(i => i.BOXNUM == TMeasures.BOXNUM);
_rPackage.BoxMeasurementTime = Convert.ToDateTime(TMeasures.BoxDimension);
_rPackage.BoxLength = TMeasures.BoxLength;
_rPackage.BoxWidth = TMeasures.BoxWidth;
_rPackage.BoxHeight = TMeasures.BoxHeight;
_rPackage.BoxWeight = TMeasures.BoxWeight;
x3ent.SaveChanges();
_retutn = true;
}
catch (Exception ex)
{
logFile.Add("Save data Error:", ex.ToString());
}
return(_retutn);
}
