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