public static List <ReportNPR> GetNPRLog(System.Int32?nprId)
{
List <ReportNPRDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.ReportNPR.GetNPRLog(nprId);
if (lstDetails == null)
{
return(null);
}
else
{
List <ReportNPR> lst = new List <ReportNPR>();
foreach (ReportNPRDetails objDetails in lstDetails)
{
ReportNPR obj = new ReportNPR();
obj.NPRLogId = objDetails.NPRLogId;
obj.NPRId = objDetails.NPRId;
obj.NPRNo = objDetails.NPRNo;
obj.Details = objDetails.Details;
obj.UpdatedByName = objDetails.UpdatedByName;
obj.DLUP = objDetails.DLUP;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
public static ReportNPR GetGoodsInLineById(System.Int32 goodsInLineId)
{
Rebound.GlobalTrader.DAL.ReportNPRDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.ReportNPR.GetGoodsInLineById(goodsInLineId);
if (objDetails == null)
{
return(null);
}
else
{
Rebound.GlobalTrader.BLL.ReportNPR obj = new Rebound.GlobalTrader.BLL.ReportNPR();
obj.GoodsInNo = objDetails.GoodsInNo;
obj.GoodsInLineId = objDetails.GoodsInLineId;
obj.CurrentDate = objDetails.CurrentDate;
obj.QLocation = objDetails.QLocation;
obj.NPRNo = objDetails.NPRNo;
obj.ReceiverName = objDetails.ReceiverName;
obj.PartNo = objDetails.PartNo;
obj.RejectedQty = objDetails.RejectedQty;
obj.UnitCost = objDetails.UnitCost;
obj.Supplier = objDetails.Supplier;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.AdviceNote = objDetails.AdviceNote;
obj.TotalRejectedValue = objDetails.TotalRejectedValue;
obj.CustomerName = objDetails.CustomerName;
obj.CompanyNo = objDetails.CompanyNo;
obj.SalesOrderNo = objDetails.SalesOrderNo;
obj.RaisedBy = objDetails.RaisedBy;
//[0001] start
obj.CurrencyCode = objDetails.CurrencyCode;
//[0001] end
// obj.CustomerRMANo = objDetails.CustomerRMANo;
// obj.SupplierRMANo = objDetails.SupplierRMANo;
obj.RejectionReason = objDetails.RejectionReason;
//[0002] start
obj.Reason1 = objDetails.Reason1;
obj.Reason1 = objDetails.Reason1;
obj.NPRComment = objDetails.NPRComment;
//[0002] end
objDetails = null;
return(obj);
}
}
public static List <ReportNPR> DataListNugget(System.Int32?clientId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.String nprSearch, System.String cmSearch, System.String action, System.Int32?isCompleted, System.Int32?purchaseOrderNoLo, System.Int32?purchaseOrderNoHi, System.Int32?goodsInNoLo, System.Int32?goodsInNoHi, System.DateTime?nprRaisedDateFrom, System.DateTime?nprRaisedDateTo, System.Int32?isAuthorised)
{
List <ReportNPRDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.ReportNPR.DataListNugget(clientId, orderBy, sortDir, pageIndex, pageSize, nprSearch, cmSearch, action, isCompleted, purchaseOrderNoLo, purchaseOrderNoHi, goodsInNoLo, goodsInNoHi, nprRaisedDateFrom, nprRaisedDateTo, isAuthorised);
if (lstDetails == null)
{
return(new List <ReportNPR>());
}
else
{
List <ReportNPR> lst = new List <ReportNPR>();
foreach (ReportNPRDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.ReportNPR obj = new Rebound.GlobalTrader.BLL.ReportNPR();
obj.NprId = objDetails.NprId;
obj.NprNo = objDetails.NprNo;
obj.Part = objDetails.Part;
obj.Location = objDetails.Location;
obj.Quantity = objDetails.Quantity;
obj.UnitCost = objDetails.UnitCost;
obj.CompanyName = objDetails.CompanyName;
obj.AuthorisedBy = objDetails.AuthorisedBy;
obj.CompletedBy = objDetails.CompletedBy;
obj.NprRaisedDate = objDetails.NprRaisedDate;
obj.Action = objDetails.Action;
obj.CompanyName = objDetails.CompanyName;
obj.RowNum = objDetails.RowNum;
obj.RowCnt = objDetails.RowCnt;
obj.CompanyNo = objDetails.CompanyNo;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.POId = objDetails.POId;
obj.GoodsInLineId = objDetails.GoodsInLineId;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
/// <summary>
/// Get NPR by NPRId
/// calls [usp_select_NPRbyId]
/// </summary>
/// <param name="nprId"></param>
/// <returns></returns>
public static ReportNPR Get(System.Int32 nprId, System.Int32?clientNo)
{
Rebound.GlobalTrader.DAL.ReportNPRDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.ReportNPR.Get(nprId, clientNo);
if (objDetails == null)
{
return(null);
}
else
{
Rebound.GlobalTrader.BLL.ReportNPR obj = new Rebound.GlobalTrader.BLL.ReportNPR();
obj.NPRId = objDetails.NPRId;
obj.NPRNo = objDetails.NPRNo;
obj.RaisedBy = objDetails.RaisedBy;
obj.NPRdate = objDetails.NPRdate;
obj.QLocation = objDetails.QLocation;
obj.GoodsInLineId = objDetails.GoodsInLineId;
obj.GoodsInNo = objDetails.GoodsInNo;
obj.SalesOrderNo = objDetails.SalesOrderNo;
obj.TotalRejectedValue = objDetails.TotalRejectedValue;
obj.RejectionReason = objDetails.RejectionReason;
obj.SupplierRMANo = objDetails.SupplierRMANo;
obj.CorrectiveActionReport = objDetails.CorrectiveActionReport;
obj.SupplierShipVia = objDetails.SupplierShipVia;
obj.SupplierShipAccount = objDetails.SupplierShipAccount;
obj.SupplierToCredit = objDetails.SupplierToCredit;
obj.SupplierRef = objDetails.SupplierRef;
obj.IncurredCostToSales_Scrap = objDetails.IncurredCostToSales_Scrap;
obj.Comments = objDetails.Comments;
obj.StockLocation = objDetails.StockLocation;
obj.IncurredCostToSales_Stock = objDetails.IncurredCostToSales_Stock;
obj.OutworkerName = objDetails.OutworkerName;
obj.OutworkerPONo = objDetails.OutworkerPONo;
obj.SalesPersonNo = objDetails.SalesPersonNo;
obj.SalesAuthorisePersonNo = objDetails.SalesAuthorisePersonNo;
obj.SalesAuthoriseDate = objDetails.SalesAuthoriseDate;
obj.LogisticSRMANo = objDetails.LogisticSRMANo;
obj.LogisticSRMADate = objDetails.LogisticSRMADate;
obj.DebitNoteNo = objDetails.DebitNoteNo;
obj.DebitNoteDate = objDetails.DebitNoteDate;
obj.NPRCompletedByNo = objDetails.NPRCompletedByNo;
obj.NPRCompletedDate = objDetails.NPRCompletedDate;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.ReceiverName = objDetails.ReceiverName;
obj.RejectedQty = objDetails.RejectedQty;
obj.CompanyNo = objDetails.CompanyNo;
obj.AdviceNote = objDetails.AdviceNote;
obj.Supplier = objDetails.Supplier;
obj.PartNo = objDetails.PartNo;
obj.CustomerName = objDetails.CustomerName;
obj.CompletedByName = objDetails.CompletedByName;
obj.ShipViaName = objDetails.ShipViaName;
obj.BuyerId = objDetails.BuyerId;
obj.BuyerName = objDetails.BuyerName;
obj.GoodsInNumber = objDetails.GoodsInNumber;
obj.UnitCost = objDetails.UnitCost;
obj.SalesAuthoriseBy = objDetails.SalesAuthoriseBy;
obj.SalesAuthoriseName = objDetails.SalesAuthoriseName;
obj.IsAuthorise = objDetails.IsAuthorise;
obj.SalesPerson = objDetails.SalesPerson;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.QtyAdvised = objDetails.QtyAdvised;
//[0001] start
obj.CurrencyCode = objDetails.CurrencyCode;
//[0001] end
//[0002] start
obj.Reason1 = objDetails.Reason1;
obj.Reason2 = objDetails.Reason2;
obj.Reason1Val = objDetails.Reason1Val;
obj.Reason2Val = objDetails.Reason2Val;
obj.NPRComment = objDetails.NPRComment;
obj.SalesAction = objDetails.SalesAction;
obj.ClientNo = objDetails.ClientNo;
obj.ClientName = objDetails.ClientName;
//[0002] end
objDetails = null;
return(obj);
}
}