public static string GetTransaction(Guid TransactionTypeId) { string TransactionNo; bool isSaved = false; ECXWF.ECXEngine eng = new WarehouseApplication.ECXWF.ECXEngine(); eng.OpenTransaction(TransactionTypeId, UserBLL.GetCurrentUser(), new string[] { "" }, WarehouseBLL.GetWarehouseCode(UserBLL.GetCurrentWarehouse()), out TransactionNo); return(TransactionNo); }
private List <StackBLL> MergeWithCommodityGrade(List <StackBLL> list) { List <StackBLL> mergedListComplete = new List <StackBLL>(); List <CommodityGradeBLL> CommodityGradeList = new List <CommodityGradeBLL>(); CommodityGradeList = CommodityGradeBLL.GetAllCommodityDetail(); List <ShedBLL> listShed = new List <ShedBLL>(); listShed = ShedBLL.GetAllShed(); List <WarehouseBLL> listWarehouse = new List <WarehouseBLL>(); listWarehouse = WarehouseBLL.GetAllActiveWarehouse(); if (CommodityGradeList == null) { throw new Exception("Can not get Commodity Grade list."); } if (listShed == null) { throw new Exception("Can not get Shed list."); } if (listWarehouse == null) { throw new Exception("Can not get Warehouse list."); } var q = from stack in list join CommGrade in CommodityGradeList on stack.CommodityGradeid equals CommGrade.CommodityGradeId join Shed in listShed on stack.ShedId equals Shed.Id join warehouse in listWarehouse on Shed.WarehouseId equals warehouse.WarehouseId select new { stack.Id, stack.ShedId, stack.StackNumber, stack.Status, stack.DateStarted, stack.CommodityGradeid, Shed.ShedNumber, warehouse.WarehouseName, CommGrade.GradeName }; foreach (var i in q) { StackBLL obj = new StackBLL(); obj.Id = i.Id; obj.ShedId = i.ShedId; obj.ShedName = i.ShedNumber; obj.CommodityGradeName = i.GradeName; obj.StackNumber = i.StackNumber; obj.Status = i.Status; obj.DateStarted = DateTime.Parse(i.DateStarted.ToShortDateString()); obj.WarehouseName = i.WarehouseName; mergedListComplete.Add(obj); } return(mergedListComplete); }
public List <GRNSentBLL> getCount(DateTime dataSent, out int totalCount) { totalCount = 0; List <GRNSentBLL> list = null; List <WarehouseBLL> listWH = null; listWH = WarehouseBLL.GetAllActiveWarehouse(); // intailize for all WH. list = new List <GRNSentBLL>(); foreach (WarehouseBLL w in listWH) { GRNSentBLL oSentGRN = new GRNSentBLL(); oSentGRN.warehouseId = w.WarehouseId; oSentGRN.warehousename = w.WarehouseName; oSentGRN.count = 0; oSentGRN.dataSent = dataSent; list.Add(oSentGRN); } List <GRNSentBLL> listTemp = null; listTemp = GRNSentDAL.getCountApprovedGRNSentbyDate(dataSent); if (listTemp != null) { foreach (GRNSentBLL w in list) { foreach (GRNSentBLL s in listTemp) { if (s.warehouseId == w.warehouseId) { totalCount += s.count; w.count = s.count; } } } } return(list); }
public static string GetTransaction(Guid TransactionTypeId, SqlTransaction tran) { string TransactionNo; bool isSaved = false; ECXWF.ECXEngine eng = new WarehouseApplication.ECXWF.ECXEngine(); eng.OpenTransaction(TransactionTypeId, UserBLL.GetCurrentUser(), new string[] { "" }, WarehouseBLL.GetWarehouseCode(UserBLL.GetCurrentWarehouse()), out TransactionNo); isSaved = WarehouseTrackingNoBLL.Save(TransactionNo, tran); if (isSaved == false) { WFTransaction.Remove(TransactionNo); throw new Exception("Unable to get Transaction.WFTransaction."); } else { return(TransactionNo); } }
/// <summary> /// Gets the net weight by deducting the tare /// </summary> /// <param name="GrossWeight"></param> /// <param name="BagTypeId"></param> /// <param name="NoBags"></param> /// <returns></returns> /// public Nullable <Guid> Add(List <GRNServiceBLL> listGRNService) { bool IsSaved = false; bool canCreate = false;; try { canCreate = this.CanCreateGRNforGradingId(this.GradingId); } catch (Exception ex) { throw ex; } if (canCreate == false) { return(null); } Nullable <Guid> id = null; SqlTransaction tran; string warehousecode; warehousecode = WarehouseBLL.GetWarehouseCode(this.WarehouseId); SqlConnection conn = new SqlConnection(); conn = Connection.getConnection(); tran = conn.BeginTransaction(); try { id = GRNDAL.InsertNewGRN(this, warehousecode, tran); if (id != null) { if (listGRNService != null) { GRNServiceBLL objSer = new GRNServiceBLL(); IsSaved = objSer.Save((Guid)id, listGRNService, tran); //Audit Trail Both GRN And GRN Service. int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); this.Id = (Guid)id; at = objAt.saveAuditTrail(this, WFStepsName.AddGRN.ToString(), UserBLL.GetCurrentUser(), "Add New GRN"); if (at == 1) { IsSaved = true; } else { IsSaved = false; } } else { IsSaved = true; } if (IsSaved == true) { WFTransaction.WorkFlowManager(this.TrackingNo); tran.Commit(); } else { tran.Rollback(); } } else { tran.Rollback(); } } catch (Exception ex) { tran.Rollback(); throw new Exception("Unable to update database.", ex); } finally { tran.Dispose(); conn.Close(); } return(id); }