public static List <WarehouseTrackingNoBLL> getWarehouseForTrackingNos(string trackingNos) { List <WarehouseTrackingNoBLL> list = null; list = WarehouseTrackingNoDAL.GetWarehouseForTrackingNos(trackingNos); return(list); }
public static bool Save(string TrackingNo, SqlTransaction tran) { bool isSaved = false; Guid Id = Guid.NewGuid(); Guid WarehouseId = UserBLL.GetCurrentWarehouse(); isSaved = WarehouseTrackingNoDAL.Insert(Id, TrackingNo, WarehouseId, tran); return(isSaved); }
public static bool IsForWarehouse(Guid warehouseId, string TrackingNo) { bool isTrue = false; List <string> list = WarehouseTrackingNoDAL.GetWarehouseTracking(TrackingNo, warehouseId); if (list != null) { if (list.Count > 0) { return(true); } else { return(false); } } return(isTrue); }
public static string[] GetOpentransaction(string transactionTypeCode, string taskName, string step) { string[] transaction; List <string> lstTran = null; ECXWF.ECXEngine eng = new WarehouseApplication.ECXWF.ECXEngine(); transaction = eng.GetTransactionsByTaskName(transactionTypeCode, taskName, step); if (transaction.Count() > 0) { lstTran = new List <string>(); lstTran = transaction.ToList <string>(); if (lstTran != null) { if (lstTran.Count > 0) { string str = ""; foreach (string s in lstTran) { str += "'" + s + "' , "; } int x = str.LastIndexOf(','); str = str.Remove(x); lstTran = WarehouseTrackingNoDAL.GetWarehouseTracking(str, UserBLL.GetCurrentWarehouse()); if (lstTran != null) { if (lstTran.Count > 0) { return(lstTran.ToArray <string>()); } } } } } else { return(null); } //Check the transaction Numbers are in the current WH from DB. //Get the count of the new Transaction array after current WH from DB return(null); }
public static int GetOpentransactionCount(string transactionTypeCode, string taskName, string step) { int count = 0; string[] transaction; List <string> lsttransaction; ECXWF.ECXEngine eng = new WarehouseApplication.ECXWF.ECXEngine(); //try //{ //transaction = eng.GetTransactionsByTaskName(transactionTypeCode, taskName, step); transaction = null; lsttransaction = new List <string>(); // lsttransaction = transaction.ToList<string>(); string str = ""; if (lsttransaction != null) { if (lsttransaction.Count > 0) { foreach (string s in lsttransaction) { if (s != null) { str += "'" + s + "' , "; } } int x = str.LastIndexOf(','); str = str.Remove(x); lsttransaction = WarehouseTrackingNoDAL.GetWarehouseTracking(str, UserBLL.GetCurrentWarehouse()); } else { return(0); } } else { return(0); } // } // catch (Exception ex) // { // throw new Exception("Unable to Get Workflow Data", ex); // } if (lsttransaction != null) { count = lsttransaction.Count; } else { return(0); } //Check the transaction Numbers are in the current WH from DB. //Get the count of the new Transaction array after current WH from DB return(count); }