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