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