/// <summary> /// Returns the qunatity in lot size. /// </summary> /// <param name="NetWeight">Weight after Tare is deducted</param> /// <param name="CommodityGrade">To Get the one lot size</param> /// <returns></returns> public static float CalculateGRNQuantity(float NetWeight, int NoBags, Guid CommodityGradeId) { float tolerance = -1; Nullable <float> lotSizeKg = null; int OneLotNumberBags = -1; float GRNQty = 0; // get Lot size for the qty. Guid CoffeeId = new Guid(Utility.GetCommodityId("Coffee").ToString()); Guid CommodityID = CommodityGradeBLL.GetCommodityGrade(CommodityGradeId).CommodityId; string t = CommodityGradeBLL.GetCommodityGrade(CommodityGradeId).Commodity; if (CoffeeId != CommodityID) { NetWeight = NetWeight * 100; } lotSizeKg = CommodityGradeBLL.GetCommodityGradeLotSizeById(CommodityGradeId); OneLotNumberBags = CommodityGradeBLL.GetCommodityGradeLotSizeInBagsById(CommodityGradeId); tolerance = Utility.WeightTolerance(); if (lotSizeKg == null) { throw new InvalidLotSizeException("Invalid lot Size."); } else { GRNQty = (float)ECXLotCalclulate((float)NetWeight, NoBags, OneLotNumberBags, (float)lotSizeKg, tolerance); GRNQty = (float)(Math.Round(GRNQty * 10000) / 10000); } return(GRNQty); }
private static List <CommodityGradeBLL> getAllCommodities() { List <CommodityGradeBLL> myList = new List <CommodityGradeBLL>(); myList = CommodityGradeBLL.GetAllCommodity(); return(myList); }
public List <GradingResultBLL> Search(string trackingNo, string gradingCode) { List <GradingResultBLL> list; try { list = new List <GradingResultBLL>(); list = GradingResultDAL.GetGradingResultSearch(trackingNo, gradingCode); if (list != null) { if (list.Count > 0) { foreach (GradingResultBLL i in list) { i.CommodityGradeName = CommodityGradeBLL.GetCommodityGradeNameById(i.CommodityGradeId); } } } return(list); } catch (Exception ex) { throw new Exception("An error has occured please try again.If the error persists contact the administrator.", ex); } }
private static List <CommodityDepositeRequestBLL> MergeWithCommodity(List <CommodityDepositeRequestBLL> myList) { List <CommodityDepositeRequestBLL> CDList = new List <CommodityDepositeRequestBLL>(); List <CommodityGradeBLL> CList = new List <CommodityGradeBLL>(); CList = CommodityGradeBLL.GetAllCommodity(); var q = from CD in myList join c in CList on CD.CommodityId equals c.CommodityId select new { CD.Id, CD.TrackingNo, CD.VoucherNo, CD.ClientId, CD.ClientName, CD.CommodityId, CD.DateTimeRecived, c.Commodity }; foreach (var i in q) { CommodityDepositeRequestBLL obj = new CommodityDepositeRequestBLL(); obj.Id = i.Id; obj.TrackingNo = i.TrackingNo; obj.VoucherNo = i.VoucherNo; obj.ClientName = i.ClientName; obj.ClientId = i.ClientId; obj.CommodityId = i.CommodityId; obj.DateTimeRecived = i.DateTimeRecived; obj.CommodityName = i.Commodity; CDList.Add(obj); } return(CDList); }
public static List <CommodityGradeBLL> GetAllCommodityDetail() { List <CommodityGradeBLL> list = new List <CommodityGradeBLL>(); ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); // Get All Commodities ECXLookUp.CCommodity[] objCommodity = objEcxLookUp.GetAllCommodities(Utility.GetWorkinglanguage()); foreach (ECXLookUp.CCommodity i in objCommodity) { ECXLookUp.CCommodityClass[] objCommodityClass = objEcxLookUp.GetAllCommodityClasses(Utility.GetWorkinglanguage(), i.UniqueIdentifier); foreach (ECXLookUp.CCommodityClass o in objCommodityClass) { ECXLookUp.CCommodityGrade[] objGrade = objEcxLookUp.GetAllCommodityGrades(Utility.GetWorkinglanguage(), o.UniqueIdentifier); foreach (ECXLookUp.CCommodityGrade c in objGrade) { CommodityGradeBLL objCG = new CommodityGradeBLL(); objCG.CommodityId = i.UniqueIdentifier; objCG.Commodity = i.Name; objCG.CommodityClassId = o.UniqueIdentifier; objCG.ClassName = o.Name; objCG.CommodityGradeId = c.UniqueIdentifier; objCG.GradeName = c.Name; objCG.Symbol = c.Symbol; list.Add(objCG); } } } string cgs = string.Empty; list.ForEach(cg => cgs += string.Format("id - {0}, name - {1}{2}", cg.CommodityGradeId, cg.GradeName, Environment.NewLine)); Utility.LogException(new Exception(cgs)); return(list); }
private List <GRNListBLL> MergeWithClient(List <GRNBLL> list) { //Get Client list. List <GRNListBLL> grnList = new List <GRNListBLL>(); List <ClientBLL> ClientList = new List <ClientBLL>(); ClientList = ClientBLL.GetAllClient(); if (ClientList == null) { throw new ClientInformationException("Can not get Clinet Information"); } else { var q = from GRN in list join client in ClientList on GRN.ClientId equals client.ClientUniqueIdentifier select new { GRN.Id, GRN.GRN_Number, GRN.CommodityId, GRN.CommodityClassId, GRN.CommodityGradeId, GRN.Status, GRN.OriginalQuantity, GRN.DateDeposited, client.ClientName }; foreach (var i in q) { GRNListBLL obj = new GRNListBLL(); obj.Id = i.Id; obj.GRN = i.GRN_Number; obj.CommodityId = i.CommodityId; obj.CommodityClassId = i.CommodityClassId; obj.CommodityGradeId = i.CommodityGradeId; obj.Status = (GRNStatus)i.Status; obj.ClinetName = i.ClientName; obj.OriginalQuantity = i.OriginalQuantity; obj.DateDeposited = Convert.ToDateTime(i.DateDeposited.ToShortDateString()); obj.CommodityGrade = CommodityGradeBLL.GetCommodityGradeNameById(i.CommodityGradeId); grnList.Add(obj); } return(grnList); } }
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 static CommodityGradeBLL GetCommodityGrade(Guid Id) { try { CommodityGradeBLL comGrade = commodityGradeCache.GetAllItems().SelectMany(gs => (from g in gs where g.CommodityGradeId == Id select g)).SingleOrDefault(); if (comGrade == null) { ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CCommodityGrade oGrade = objEcxLookUp.GetCommodityGrade(Utility.GetWorkinglanguage(), Id); comGrade = (from grade in commodityGradeCache.GetItem(oGrade.CommodityClassUniqueIdentifier.ToString()) where grade.CommodityGradeId == Id select grade).SingleOrDefault(); } return(comGrade); } catch (Exception ex) { throw ex; } }
/// <summary> /// Search Commodity deposite by TransqactionId /// </summary> /// <param name="trackingNo">The Transaction Id assiged and used by Traking no.</param> /// <returns></returns> public List <CommodityDepositeRequestBLL> SearchCommodityDeposite(string trackingNo, string VoucherNo, Nullable <Guid> Clientid, Nullable <Guid> CommodityId, Nullable <DateTime> from, Nullable <DateTime> to) { List <CommodityDepositeRequestBLL> list = new List <CommodityDepositeRequestBLL>(); list = CommodityDepositRequest.SearchCommodityDeposite(trackingNo, VoucherNo, Clientid, CommodityId, from, to); if (list != null) { List <CommodityDepositeRequestBLL> listMerged = new List <CommodityDepositeRequestBLL>(); for (int x = 0; x < list.Count; x++) { list[x].ClientName = ClientBLL.GetClinetNameById(list[x].ClientId); list[x].CommodityName = CommodityGradeBLL.GetCommodityById(list[x].CommodityId).Commodity; } return(list); } else { return(null); } }
public Nullable <float> CalculateNetWeight(float GrossWeight, Guid BagTypeId, int NoBags, Guid CommodityGradeId) { //Get Commodity Id Guid CommodityID = CommodityGradeBLL.GetCommodityGrade(CommodityGradeId).CommodityId; Guid CoffeeId = new Guid(Utility.GetCommodityId("Coffee").ToString()); float Tare, netWeight; BagTypeBLL objbagType = new BagTypeBLL(); objbagType.GetBagTypeById(BagTypeId); if (objbagType != null) { Tare = objbagType.Tare; if (Tare == -1) { throw new InvalidTareException("Tare for the bag type is not provided"); } // Utility.LogException(new Exception("CC : CoffeeId=" + CoffeeId.ToString() + ", CommodityID=" + CommodityID.ToString())); if (CoffeeId != CommodityID) { Tare = Tare / 100; // change to quintals } netWeight = GrossWeight - (Tare * NoBags); // Utility.LogException(new Exception("Tare:" + Tare.ToString() + ", NoBags=" + NoBags + ", GrossWeight=" + GrossWeight.ToString() + ", netWeight=" + netWeight.ToString())); if (netWeight <= 0) { throw new Exception("Net weight can not be below 0."); } netWeight = (float)(Math.Round(netWeight * 100) / 100); return((float)(Math.Round(netWeight * 100, 0)) / 100); } else { throw new InvalidTareException("Tare for the bag type is not provided."); } }
public static string GetCommodityGradeNameById(Guid Id) { try { ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CCommodityGrade objCommodity = objEcxLookUp.GetCommodityGrade(Utility.GetWorkinglanguage(), Id); if (objCommodity != null) { CommodityGradeBLL obj = new CommodityGradeBLL(); obj.GradeName = objCommodity.Name; obj.CommodityClassId = objCommodity.CommodityClassUniqueIdentifier; return(obj.GradeName); } else { return(""); } } catch (Exception ex) { throw ex; } }