/// <summary>
/// GetForPrint
/// Calls [usp_select_SupplierRMA_for_Print]
/// </summary>
public static SupplierRma GetForPrint(System.Int32?supplierRmaId, bool IsHUBsupplierRmaId)
{
Rebound.GlobalTrader.DAL.SupplierRmaDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierRma.GetForPrint(supplierRmaId, IsHUBsupplierRmaId);
if (objDetails == null)
{
return(null);
}
else
{
SupplierRma obj = new SupplierRma();
obj.SupplierRMAId = objDetails.SupplierRMAId;
obj.ClientNo = objDetails.ClientNo;
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
obj.PurchaseOrderNo = objDetails.PurchaseOrderNo;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.AuthorisedBy = objDetails.AuthorisedBy;
obj.AuthoriserName = objDetails.AuthoriserName;
obj.SupplierRMADate = objDetails.SupplierRMADate;
obj.Notes = objDetails.Notes;
obj.Instructions = objDetails.Instructions;
obj.ShipViaNo = objDetails.ShipViaNo;
obj.ShipViaName = objDetails.ShipViaName;
obj.Account = objDetails.Account;
obj.ShipToAddressNo = objDetails.ShipToAddressNo;
obj.Reference = objDetails.Reference;
obj.CompanyNo = objDetails.CompanyNo;
obj.CompanyName = objDetails.CompanyName;
obj.FullCompanyName = objDetails.FullCompanyName;
obj.ContactNo = objDetails.ContactNo;
obj.ContactName = objDetails.ContactName;
obj.DivisionNo = objDetails.DivisionNo;
obj.DivisionName = objDetails.DivisionName;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.TeamNo = objDetails.TeamNo;
obj.CustomerCode = objDetails.CustomerCode;
obj.TaxNo = objDetails.TaxNo;
obj.TaxName = objDetails.TaxName;
obj.Buyer = objDetails.Buyer;
obj.Quantity = objDetails.Quantity;
obj.QuantityShipped = objDetails.QuantityShipped;
obj.IncotermNo = objDetails.IncotermNo;
obj.IncotermName = objDetails.IncotermName;
obj.CompanyTelephone = objDetails.CompanyTelephone;
obj.CompanyFax = objDetails.CompanyFax;
obj.TermsName = objDetails.TermsName;
obj.ShipViaName = objDetails.ShipViaName;
obj.ContactEmail = objDetails.ContactEmail;
obj.IncotermName = objDetails.IncotermName;
obj.POHubCompanyNo = objDetails.POHubCompanyNo;
obj.POHubCompanyName = objDetails.POHubCompanyName;
obj.ClientRefNo = objDetails.ClientRefNo;
obj.HubShipToAddressNo = objDetails.HubShipToAddressNo;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetForPage
/// Calls [usp_select_SupplierRMA_for_Page]
/// </summary>
public static SupplierRma GetForPage(System.Int32?supplierRmaId)
{
Rebound.GlobalTrader.DAL.SupplierRmaDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierRma.GetForPage(supplierRmaId);
if (objDetails == null)
{
return(null);
}
else
{
SupplierRma obj = new SupplierRma();
obj.SupplierRMAId = objDetails.SupplierRMAId;
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
obj.ClientNo = objDetails.ClientNo;
obj.CompanyNo = objDetails.CompanyNo;
obj.CompanyName = objDetails.CompanyName;
// [001] code start
obj.IsPDFAvailable = objDetails.IsPDFAvailable;
// [001] code end
obj.TeamNo = objDetails.TeamNo;
obj.DivisionNo = objDetails.DivisionNo;
obj.Buyer = objDetails.Buyer;
obj.IPOCompanyNo = objDetails.IPOCompanyNo;
obj.IPOCompanyName = objDetails.IPOCompanyName;
obj.InternalPurchaseOrderId = objDetails.InternalPurchaseOrderId;
obj.ClientName = objDetails.ClientName;
objDetails = null;
return(obj);
}
}
/// <summary>
/// ItemSearch
/// Calls [usp_itemsearch_SupplierRMA]
/// </summary>
public static List <SupplierRma> ItemSearch(System.Int32?clientId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.String contactSearch, System.String cmSearch, System.Int32?buyerSearch, System.String srmaNotesSearch, System.Int32?purchaseOrderNoLo, System.Int32?purchaseOrderNoHi, System.Int32?supplierRmaNoLo, System.Int32?supplierRmaNoHi, System.DateTime?supplierRmaDateFrom, System.DateTime?supplierRmaDateTo)
{
List <SupplierRmaDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierRma.ItemSearch(clientId, orderBy, sortDir, pageIndex, pageSize, contactSearch, cmSearch, buyerSearch, srmaNotesSearch, purchaseOrderNoLo, purchaseOrderNoHi, supplierRmaNoLo, supplierRmaNoHi, supplierRmaDateFrom, supplierRmaDateTo);
if (lstDetails == null)
{
return(new List <SupplierRma>());
}
else
{
List <SupplierRma> lst = new List <SupplierRma>();
foreach (SupplierRmaDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.SupplierRma obj = new Rebound.GlobalTrader.BLL.SupplierRma();
obj.SupplierRMAId = objDetails.SupplierRMAId;
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
obj.CompanyNo = objDetails.CompanyNo;
obj.CompanyName = objDetails.CompanyName;
obj.SupplierRMADate = objDetails.SupplierRMADate;
obj.BuyerName = objDetails.BuyerName;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.RowNum = objDetails.RowNum;
obj.RowCnt = objDetails.RowCnt;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
/// <summary>
/// GetListForCompany
/// Calls [usp_selectAll_SupplierRMA_for_Company]
/// </summary>
public static List <SupplierRma> GetListForCompany(System.Int32?companyId, System.Boolean?includeComplete)
{
List <SupplierRmaDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierRma.GetListForCompany(companyId, includeComplete);
if (lstDetails == null)
{
return(new List <SupplierRma>());
}
else
{
List <SupplierRma> lst = new List <SupplierRma>();
foreach (SupplierRmaDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.SupplierRma obj = new Rebound.GlobalTrader.BLL.SupplierRma();
obj.SupplierRMAId = objDetails.SupplierRMAId;
obj.ClientNo = objDetails.ClientNo;
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
obj.PurchaseOrderNo = objDetails.PurchaseOrderNo;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.AuthorisedBy = objDetails.AuthorisedBy;
obj.AuthoriserName = objDetails.AuthoriserName;
obj.SupplierRMADate = objDetails.SupplierRMADate;
obj.Notes = objDetails.Notes;
obj.Instructions = objDetails.Instructions;
obj.ShipViaNo = objDetails.ShipViaNo;
obj.ShipViaName = objDetails.ShipViaName;
obj.Account = objDetails.Account;
obj.ShipToAddressNo = objDetails.ShipToAddressNo;
obj.Reference = objDetails.Reference;
obj.CompanyNo = objDetails.CompanyNo;
obj.CompanyName = objDetails.CompanyName;
obj.FullCompanyName = objDetails.FullCompanyName;
obj.ContactNo = objDetails.ContactNo;
obj.ContactName = objDetails.ContactName;
obj.DivisionNo = objDetails.DivisionNo;
obj.DivisionName = objDetails.DivisionName;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.TeamNo = objDetails.TeamNo;
obj.CustomerCode = objDetails.CustomerCode;
obj.TaxNo = objDetails.TaxNo;
obj.TaxName = objDetails.TaxName;
obj.Buyer = objDetails.Buyer;
obj.Quantity = objDetails.Quantity;
obj.QuantityShipped = objDetails.QuantityShipped;
obj.IncotermNo = objDetails.IncotermNo;
obj.IncotermName = objDetails.IncotermName;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
private static SupplierRma PopulateFromDBDetailsObject(SupplierRmaDetails obj)
{
SupplierRma objNew = new SupplierRma();
objNew.SupplierRMAId = obj.SupplierRMAId;
objNew.ClientNo = obj.ClientNo;
objNew.SupplierRMANumber = obj.SupplierRMANumber;
objNew.PurchaseOrderNo = obj.PurchaseOrderNo;
objNew.AuthorisedBy = obj.AuthorisedBy;
objNew.SupplierRMADate = obj.SupplierRMADate;
objNew.Notes = obj.Notes;
objNew.Instructions = obj.Instructions;
objNew.ShipViaNo = obj.ShipViaNo;
objNew.Account = obj.Account;
objNew.ShipToAddressNo = obj.ShipToAddressNo;
objNew.Reference = obj.Reference;
objNew.CompanyNo = obj.CompanyNo;
objNew.ContactNo = obj.ContactNo;
objNew.DivisionNo = obj.DivisionNo;
objNew.UpdatedBy = obj.UpdatedBy;
objNew.DLUP = obj.DLUP;
objNew.IncotermNo = obj.IncotermNo;
objNew.CompanyName = obj.CompanyName;
objNew.BuyerName = obj.BuyerName;
objNew.PurchaseOrderNumber = obj.PurchaseOrderNumber;
objNew.RowNum = obj.RowNum;
objNew.RowCnt = obj.RowCnt;
objNew.AuthoriserName = obj.AuthoriserName;
objNew.ShipViaName = obj.ShipViaName;
objNew.FullCompanyName = obj.FullCompanyName;
objNew.ContactName = obj.ContactName;
objNew.DivisionName = obj.DivisionName;
objNew.CurrencyNo = obj.CurrencyNo;
objNew.CurrencyCode = obj.CurrencyCode;
objNew.CurrencyDescription = obj.CurrencyDescription;
objNew.TeamNo = obj.TeamNo;
objNew.CustomerCode = obj.CustomerCode;
objNew.TaxNo = obj.TaxNo;
objNew.TaxName = obj.TaxName;
objNew.Buyer = obj.Buyer;
objNew.Quantity = obj.Quantity;
objNew.QuantityShipped = obj.QuantityShipped;
objNew.IncotermName = obj.IncotermName;
objNew.CompanyTelephone = obj.CompanyTelephone;
objNew.CompanyFax = obj.CompanyFax;
objNew.TermsName = obj.TermsName;
objNew.ContactEmail = obj.ContactEmail;
return(objNew);
}
/// <summary>
/// GetNextNumber
/// Calls [usp_select_SupplierRMA_NextNumber]
/// </summary>
public static SupplierRma GetNextNumber(System.Int32?clientNo, System.Int32?updatedBy)
{
Rebound.GlobalTrader.DAL.SupplierRmaDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierRma.GetNextNumber(clientNo, updatedBy);
if (objDetails == null)
{
return(null);
}
else
{
SupplierRma obj = new SupplierRma();
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
objDetails = null;
return(obj);
}
}
public static List <SupplierRma> GetSRMAInternalLog(System.Int32 supplierRmaNumber)
{
List <Rebound.GlobalTrader.DAL.SupplierRmaDetails> objDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierRma.GetSRMAInternalLog(supplierRmaNumber);
List <SupplierRma> lstSRMA = new List <SupplierRma>();
foreach (SupplierRmaDetails srmad in objDetails)
{
SupplierRma crma = new SupplierRma();
crma.SRMAExpediteNotesId = srmad.SRMAExpediteNotesId;
crma.Notes = srmad.Notes;
crma.EmployeeName = srmad.EmployeeName;
crma.DLUP = srmad.DLUP;
lstSRMA.Add(crma);
}
return(lstSRMA);
}
/// <summary>
/// GetIDByNumber
/// Calls [usp_select_SupplierRMA_ID_by_Number]
/// </summary>
public static List <SupplierRma> GetIDByNumber(System.Int32?supplierRmaNumber, System.Int32?clientNo, System.Int32?isGlobalUser)
{
//[002] start
List <Rebound.GlobalTrader.DAL.SupplierRmaDetails> lstSRMAD = Rebound.GlobalTrader.DAL.SiteProvider.SupplierRma.GetIDByNumber(supplierRmaNumber, clientNo, isGlobalUser);
List <SupplierRma> lstSRMA = new List <SupplierRma>();
foreach (SupplierRmaDetails srmad in lstSRMAD)
{
SupplierRma srma = new SupplierRma();
srma.SupplierRMAId = srmad.SupplierRMAId;
srma.SRMANumberDetail = srmad.SRMANumberDetail;
lstSRMA.Add(srma);
}
return(lstSRMA);
//[002] end
}
