public List <cstPackageTbl> ExecuteNoLocation(String ShippingNum) { List <cstPackageTbl> _lsPacking = new List <cstPackageTbl>(); try { local_x3v6Entities _Localx3v6 = new local_x3v6Entities(); // Package _Packing = _Localx3v6.Packages.SingleOrDefault(i => i.ShippingNum == ShippingNum); var _packinglist = from _Pack in _Localx3v6.Packages where _Pack.ShippingNum == ShippingNum select _Pack; foreach (var _Packing in _packinglist) { cstPackageTbl _PC = new cstPackageTbl(); _PC.PackingId = _Packing.PackingId; _PC.ShippingID = (Guid)_Packing.ShippingID; _PC.ShippingNum = _Packing.ShippingNum; _PC.UserID = _Packing.UserId; _PC.StartTime = Convert.ToDateTime(_Packing.StartTime); _PC.EndTime = Convert.ToDateTime(_Packing.EndTime); _PC.StationID = (Guid)_Packing.StationID; _PC.PackingStatus = Convert.ToInt32(_Packing.PackingStatus); _PC.ShipmentLocation = _Packing.ShipmentLocation; _PC.MangerOverride = Convert.ToInt32(_Packing.ManagerOverride); _PC.PCKROWID = _Packing.PCKROWID; _lsPacking.Add(_PC); } } catch (Exception Ex) { Error_Loger.elAction.save("GetPackingListSelcted.ExecuteNoLocation()", Ex.Message.ToString()); } return(_lsPacking); }
public cstPackageTbl ExecutePacking(Guid PackingID) { cstPackageTbl _PC = new cstPackageTbl(); try { local_x3v6Entities _Localx3v6 = new local_x3v6Entities(); Package _Packing = _Localx3v6.Packages.SingleOrDefault(i => i.PackingId == PackingID); _PC.PackingId = _Packing.PackingId; _PC.ShippingID = (Guid)_Packing.ShippingID; _PC.ShippingNum = _Packing.ShippingNum; _PC.UserID = _Packing.UserId; _PC.StartTime = Convert.ToDateTime(_Packing.StartTime); _PC.EndTime = Convert.ToDateTime(_Packing.EndTime); _PC.StationID = (Guid)_Packing.StationID; _PC.PackingStatus = Convert.ToInt32(_Packing.PackingStatus); _PC.ShipmentLocation = _Packing.ShipmentLocation; _PC.MangerOverride = Convert.ToInt32(_Packing.ManagerOverride); _PC.PCKROWID = _Packing.PCKROWID; } catch (Exception Ex) { Error_Loger.elAction.save("GetPackingListSelcted.Execute()", Ex.Message.ToString()); } return(_PC); }
public override List <KeyValuePair <string, float> > Execute() { List <KeyValuePair <string, float> > list = new List <KeyValuePair <string, float> >(); DateTime currentDate = DateTime.UtcNow; local_x3v6Entities entities = new local_x3v6Entities(); var result = from pd in entities.PackageDetails join p in entities.Packages on pd.PackingId equals p.PackingId join u in entities.Users on p.UserId equals u.UserID where p.UserId == _userId && EntityFunctions.TruncateTime(p.StartTime) == (EntityFunctions.TruncateTime(currentDate)) select new { difference = SqlFunctions.DateDiff("s", p.StartTime, p.EndTime) }; int total = 0; foreach (var data in result) { int diff = (int)data.difference; total = total + diff; } if (total > 0) { float averageTime = (total / result.Count()); list.Add(new KeyValuePair <string, float>("Average Time", averageTime)); } else { list.Add(new KeyValuePair <string, float>("Average Time", 0)); } return(list); }
public static cstViewExtraColumns GetExtraColumns(String ShippingNumber, String SKUName) { local_x3v6Entities entlocal = new local_x3v6Entities(); cstViewExtraColumns _return = new cstViewExtraColumns(); try { var Columns = from view in entlocal.Get_Shipping_Data where view.SKU == SKUName && view.ShipmentID == ShippingNumber select new { view.TarrifCode, view.TCLCOD_0, view.ItemName, view.UnitOfMeasure, view.CountryOfOrigin, view.MAP_Price }; foreach (var _viewitem in Columns) { _return.TarrifCode = _viewitem.TarrifCode; _return.TCLCOD_0 = _viewitem.TCLCOD_0; _return.ItemName = _viewitem.ItemName; _return.UnitOfMeasure = _viewitem.UnitOfMeasure; _return.CountryOfOrigin = _viewitem.CountryOfOrigin; _return.MAP_Price = _viewitem.MAP_Price; } } catch (Exception) { } return(_return); }
/// <summary> /// get information from packag table /// </summary> /// <param name="PackingID">Guid PackingID</param> /// <returns>String ShippingNum</returns> public static String GetShippingNum(Guid PackingID) { local_x3v6Entities ent = new local_x3v6Entities(); string lsShippingNumbers = "0"; try { lsShippingNumbers = ent.Packages.SingleOrDefault(i => i.PackingId == PackingID).ShippingNum; } catch (Exception) { } return(lsShippingNumbers); }
/// <summary> /// Get Infromation from Package table /// </summary> /// <param name="ShippingNumber">String Shipment Number</param> /// <param name="OverrideMode">int manager Override</param> /// <param name="Location">String Location</param> /// <returns>Guid as a packing</returns> public static Guid GetPackageDI(String ShippingNumber, int OverrideMode, String Location) { local_x3v6Entities ent = new local_x3v6Entities(); Guid _PackingID = Guid.Empty; try { _PackingID = ent.Packages.SingleOrDefault(i => i.ShippingNum == ShippingNumber && i.ManagerOverride == OverrideMode && i.ShipmentLocation == Location).PackingId; } catch (Exception) { } return(_PackingID); }
public override List <cstRoleTbl> Execute() { List <cstRoleTbl> roleList = new List <cstRoleTbl>(); local_x3v6Entities context = new local_x3v6Entities(); switch (_action) { case csteActionenum.New: Role role = new Role(); role.RoleId = Guid.NewGuid(); role.Name = _role.Name; role.Action = _role.Action; role.CreatedBy = GlobalClasses.ClGlobal.UserID; role.CreatedDateTime = DateTime.UtcNow; context.AddToRoles(role); context.SaveChanges(); break; case csteActionenum.Update: Role roleTypeUpdate = context.Roles.First(i => i.RoleId == _role.RoleId); roleTypeUpdate.Name = _role.Name; roleTypeUpdate.Action = _role.Action; roleTypeUpdate.Updatedby = GlobalClasses.ClGlobal.UserID; roleTypeUpdate.UpdatedDateTime = DateTime.UtcNow; context.SaveChanges(); break; case csteActionenum.Delete: break; case csteActionenum.Get: var result = from r in context.Roles where r.RoleId == _id select r; foreach (var varRole in result) { cstRoleTbl objRole = new cstRoleTbl(); objRole.RoleId = varRole.RoleId; objRole.Name = varRole.Name; objRole.Action = varRole.Action; roleList.Add(objRole); } break; } return(roleList); }
public override List <cstRoleTbl> Execute() { local_x3v6Entities entiites = new local_x3v6Entities(); var result = from r in entiites.Roles select r; List <cstRoleTbl> list = new List <cstRoleTbl>(); foreach (var role in result) { cstRoleTbl item = new cstRoleTbl(); item.Name = role.Name; item.RoleId = role.RoleId; item.Action = role.Action; list.Add(item); } return(list); }
/// <summary> /// get information from packag table /// </summary> /// <param name="ShippingNumber">String Shippingn Number</param> /// <returns>List of Guid That indicates the PackingID</returns> public static List <Guid> GetPackingNum(String ShippingNumber) { local_x3v6Entities ent = new local_x3v6Entities(); List <Guid> _PackingID = new List <Guid>(); try { var PackingNum = from Id in ent.Packages where Id.ShippingNum == ShippingNumber select Id; foreach (var PakingNumItem in PackingNum) { Guid _PackingNum = new Guid(); _PackingNum = PakingNumItem.PackingId; _PackingID.Add(_PackingNum); } } catch (Exception) { } return(_PackingID); }
public static Boolean Getbolforsku(string _skuName) { local_x3v6Entities ent = new local_x3v6Entities(); Boolean flag = false; try { var detail = from id in ent.PackageDetails where id.SKUNumber == _skuName select id; if (detail.Count() > 0) { flag = true; } } catch (Exception) { } return(flag); }
public static string GetQuantityfrompackagedetail(string _skuName, string Boxnumber) { local_x3v6Entities ent = new local_x3v6Entities(); string flag = ""; try { var detail = from id in ent.PackageDetails where id.SKUNumber == _skuName && id.BoxNumber == Boxnumber select id.SKUQuantity; foreach (var item in detail) { flag = item.ToString(); } } catch (Exception) { } return(flag); }