/// <summary>
/// GetForPage
/// Calls [usp_select_RecieveCustomerRMA_for_Page]
/// </summary>
public static CustomerRma GetForRecievePage(System.Int32?customerRmaId)
{
Rebound.GlobalTrader.DAL.CustomerRmaDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRma.GetForRecievePage(customerRmaId);
if (objDetails == null)
{
return(null);
}
else
{
CustomerRma obj = new CustomerRma();
obj.CustomerRMAId = objDetails.CustomerRMAId;
obj.CustomerRMANumber = objDetails.CustomerRMANumber;
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.Salesman = objDetails.Salesman;
obj.ClientName = objDetails.ClientName;
obj.ClientBaseCurrencyCode = objDetails.ClientBaseCurrencyCode;
obj.ClientBaseCurrencyID = objDetails.ClientBaseCurrencyID;
objDetails = null;
return(obj);
}
}
/// <summary>
/// ItemSearch
/// Calls [usp_itemsearch_CustomerRMA]
/// </summary>
public static List <CustomerRma> ItemSearch(System.Int32?clientId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.String contactSearch, System.String cmSearch, System.Int32?salesmanSearch, System.String crmaNotesSearch, System.Int32?invoiceNoLo, System.Int32?invoiceNoHi, System.Int32?customerRmaNoLo, System.Int32?customerRmaNoHi, System.DateTime?customerRmaDateFrom, System.DateTime?customerRmaDateTo)
{
List <CustomerRmaDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRma.ItemSearch(clientId, orderBy, sortDir, pageIndex, pageSize, contactSearch, cmSearch, salesmanSearch, crmaNotesSearch, invoiceNoLo, invoiceNoHi, customerRmaNoLo, customerRmaNoHi, customerRmaDateFrom, customerRmaDateTo);
if (lstDetails == null)
{
return(new List <CustomerRma>());
}
else
{
List <CustomerRma> lst = new List <CustomerRma>();
foreach (CustomerRmaDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.CustomerRma obj = new Rebound.GlobalTrader.BLL.CustomerRma();
obj.CustomerRMAId = objDetails.CustomerRMAId;
obj.CustomerRMANumber = objDetails.CustomerRMANumber;
obj.CompanyName = objDetails.CompanyName;
obj.CustomerRMADate = objDetails.CustomerRMADate;
obj.SalesmanName = objDetails.SalesmanName;
obj.AuthoriserName = objDetails.AuthoriserName;
obj.InvoiceNo = objDetails.InvoiceNo;
obj.InvoiceNumber = objDetails.InvoiceNumber;
obj.RowNum = objDetails.RowNum;
obj.RowCnt = objDetails.RowCnt;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
/// <summary>
/// GetForPrint
/// Calls [usp_select_CustomerRMA_for_Print]
/// </summary>
public static CustomerRma GetForPrint(System.Int32?customerRmaId)
{
Rebound.GlobalTrader.DAL.CustomerRmaDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRma.GetForPrint(customerRmaId);
if (objDetails == null)
{
return(null);
}
else
{
CustomerRma obj = new CustomerRma();
obj.CustomerRMAId = objDetails.CustomerRMAId;
obj.ClientNo = objDetails.ClientNo;
obj.CustomerRMANumber = objDetails.CustomerRMANumber;
obj.InvoiceNo = objDetails.InvoiceNo;
obj.AuthorisedBy = objDetails.AuthorisedBy;
obj.CustomerRMADate = objDetails.CustomerRMADate;
obj.Notes = objDetails.Notes;
obj.Instructions = objDetails.Instructions;
obj.ShipViaNo = objDetails.ShipViaNo;
obj.Account = objDetails.Account;
obj.WarehouseNo = objDetails.WarehouseNo;
obj.CompanyNo = objDetails.CompanyNo;
obj.ContactNo = objDetails.ContactNo;
obj.DivisionNo = objDetails.DivisionNo;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.InvoiceNumber = objDetails.InvoiceNumber;
obj.AuthoriserName = objDetails.AuthoriserName;
obj.WarehouseName = objDetails.WarehouseName;
obj.CompanyName = objDetails.CompanyName;
obj.ContactName = objDetails.ContactName;
obj.DivisionName = objDetails.DivisionName;
obj.SalesOrderNo = objDetails.SalesOrderNo;
obj.SalesOrderNumber = objDetails.SalesOrderNumber;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.Salesman = objDetails.Salesman;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.ShipViaName = objDetails.ShipViaName;
obj.SalesmanName = objDetails.SalesmanName;
obj.TaxNo = objDetails.TaxNo;
obj.TaxName = objDetails.TaxName;
obj.InvoiceDate = objDetails.InvoiceDate;
obj.Quantity = objDetails.Quantity;
obj.QuantityReceived = objDetails.QuantityReceived;
obj.IncotermNo = objDetails.IncotermNo;
obj.IncotermName = objDetails.IncotermName;
obj.CompanyTelephone = objDetails.CompanyTelephone;
obj.CompanyFax = objDetails.CompanyFax;
obj.ShipViaName = objDetails.ShipViaName;
obj.CustomerPO = objDetails.CustomerPO;
obj.TermsName = objDetails.TermsName;
obj.ContactEmail = objDetails.ContactEmail;
obj.IncotermName = objDetails.IncotermName;
obj.CustomerRejectionNo = objDetails.CustomerRejectionNo;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetListForCompany
/// Calls [usp_selectAll_CustomerRMA_for_Company]
/// </summary>
public static List <CustomerRma> GetListForCompany(System.Int32?companyId, System.Boolean?includeComplete)
{
List <CustomerRmaDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRma.GetListForCompany(companyId, includeComplete);
if (lstDetails == null)
{
return(new List <CustomerRma>());
}
else
{
List <CustomerRma> lst = new List <CustomerRma>();
foreach (CustomerRmaDetails objDetails in lstDetails)
{
Rebound.GlobalTrader.BLL.CustomerRma obj = new Rebound.GlobalTrader.BLL.CustomerRma();
obj.CustomerRMAId = objDetails.CustomerRMAId;
obj.ClientNo = objDetails.ClientNo;
obj.CustomerRMANumber = objDetails.CustomerRMANumber;
obj.InvoiceNo = objDetails.InvoiceNo;
obj.AuthorisedBy = objDetails.AuthorisedBy;
obj.CustomerRMADate = objDetails.CustomerRMADate;
obj.Notes = objDetails.Notes;
obj.Instructions = objDetails.Instructions;
obj.ShipViaNo = objDetails.ShipViaNo;
obj.Account = objDetails.Account;
obj.WarehouseNo = objDetails.WarehouseNo;
obj.CompanyNo = objDetails.CompanyNo;
obj.ContactNo = objDetails.ContactNo;
obj.DivisionNo = objDetails.DivisionNo;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.InvoiceNumber = objDetails.InvoiceNumber;
obj.AuthoriserName = objDetails.AuthoriserName;
obj.WarehouseName = objDetails.WarehouseName;
obj.CompanyName = objDetails.CompanyName;
obj.ContactName = objDetails.ContactName;
obj.DivisionName = objDetails.DivisionName;
obj.SalesOrderNo = objDetails.SalesOrderNo;
obj.SalesOrderNumber = objDetails.SalesOrderNumber;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.Salesman = objDetails.Salesman;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.ShipViaName = objDetails.ShipViaName;
obj.SalesmanName = objDetails.SalesmanName;
obj.TaxNo = objDetails.TaxNo;
obj.TaxName = objDetails.TaxName;
obj.InvoiceDate = objDetails.InvoiceDate;
obj.Quantity = objDetails.Quantity;
obj.QuantityReceived = objDetails.QuantityReceived;
obj.IncotermNo = objDetails.IncotermNo;
obj.IncotermName = objDetails.IncotermName;
lst.Add(obj);
obj = null;
}
lstDetails = null;
return(lst);
}
}
/// <summary>
/// GetForNewCreditNote
/// Calls [usp_select_CustomerRMA_for_NewCreditNote]
/// </summary>
public static CustomerRma GetForNewCreditNote(System.Int32?customerRmaId)
{
Rebound.GlobalTrader.DAL.CustomerRmaDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRma.GetForNewCreditNote(customerRmaId);
if (objDetails == null)
{
return(null);
}
else
{
CustomerRma obj = new CustomerRma();
obj.CustomerRMAId = objDetails.CustomerRMAId;
obj.ClientNo = objDetails.ClientNo;
obj.CustomerRMANumber = objDetails.CustomerRMANumber;
obj.InvoiceNo = objDetails.InvoiceNo;
obj.AuthorisedBy = objDetails.AuthorisedBy;
obj.CustomerRMADate = objDetails.CustomerRMADate;
obj.Instructions = objDetails.Instructions;
obj.WarehouseNo = objDetails.WarehouseNo;
obj.CompanyNo = objDetails.CompanyNo;
obj.ContactNo = objDetails.ContactNo;
obj.DivisionNo = objDetails.DivisionNo;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.InvoiceNumber = objDetails.InvoiceNumber;
obj.AuthoriserName = objDetails.AuthoriserName;
obj.WarehouseName = objDetails.WarehouseName;
obj.CompanyName = objDetails.CompanyName;
obj.ContactName = objDetails.ContactName;
obj.DivisionName = objDetails.DivisionName;
obj.SalesOrderNo = objDetails.SalesOrderNo;
obj.SalesOrderNumber = objDetails.SalesOrderNumber;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.Salesman = objDetails.Salesman;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.SalesmanName = objDetails.SalesmanName;
obj.TaxNo = objDetails.TaxNo;
obj.TaxName = objDetails.TaxName;
obj.InvoiceDate = objDetails.InvoiceDate;
obj.Quantity = objDetails.Quantity;
obj.QuantityReceived = objDetails.QuantityReceived;
obj.ShipViaNo = objDetails.ShipViaNo;
obj.ShipViaName = objDetails.ShipViaName;
obj.Account = objDetails.Account;
obj.InvoiceCustomerPO = objDetails.InvoiceCustomerPO;
obj.InvoiceShippingCost = objDetails.InvoiceShippingCost;
obj.InvoiceFreight = objDetails.InvoiceFreight;
obj.Salesman2 = objDetails.Salesman2;
obj.Salesman2Percent = objDetails.Salesman2Percent;
//[002] code start
obj.IncotermNo = objDetails.IncotermNo;
//[002] code end
objDetails = null;
return(obj);
}
}
private static CustomerRma PopulateFromDBDetailsObject(CustomerRmaDetails obj)
{
CustomerRma objNew = new CustomerRma();
objNew.CustomerRMAId = obj.CustomerRMAId;
objNew.ClientNo = obj.ClientNo;
objNew.CustomerRMANumber = obj.CustomerRMANumber;
objNew.InvoiceNo = obj.InvoiceNo;
objNew.AuthorisedBy = obj.AuthorisedBy;
objNew.CustomerRMADate = obj.CustomerRMADate;
objNew.Notes = obj.Notes;
objNew.Instructions = obj.Instructions;
objNew.ShipViaNo = obj.ShipViaNo;
objNew.Account = obj.Account;
objNew.WarehouseNo = obj.WarehouseNo;
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.SalesmanName = obj.SalesmanName;
objNew.AuthoriserName = obj.AuthoriserName;
objNew.InvoiceNumber = obj.InvoiceNumber;
objNew.RowNum = obj.RowNum;
objNew.RowCnt = obj.RowCnt;
objNew.WarehouseName = obj.WarehouseName;
objNew.ContactName = obj.ContactName;
objNew.DivisionName = obj.DivisionName;
objNew.SalesOrderNo = obj.SalesOrderNo;
objNew.SalesOrderNumber = obj.SalesOrderNumber;
objNew.CurrencyNo = obj.CurrencyNo;
objNew.Salesman = obj.Salesman;
objNew.CurrencyCode = obj.CurrencyCode;
objNew.CurrencyDescription = obj.CurrencyDescription;
objNew.ShipViaName = obj.ShipViaName;
objNew.TaxNo = obj.TaxNo;
objNew.TaxName = obj.TaxName;
objNew.InvoiceDate = obj.InvoiceDate;
objNew.Quantity = obj.Quantity;
objNew.QuantityReceived = obj.QuantityReceived;
objNew.IncotermName = obj.IncotermName;
objNew.InvoiceCustomerPO = obj.InvoiceCustomerPO;
objNew.InvoiceShippingCost = obj.InvoiceShippingCost;
objNew.InvoiceFreight = obj.InvoiceFreight;
objNew.Salesman2 = obj.Salesman2;
objNew.Salesman2Percent = obj.Salesman2Percent;
objNew.CompanyTelephone = obj.CompanyTelephone;
objNew.CompanyFax = obj.CompanyFax;
objNew.CustomerPO = obj.CustomerPO;
objNew.TermsName = obj.TermsName;
objNew.ContactEmail = obj.ContactEmail;
return(objNew);
}
/// <summary>
/// GetNextNumber
/// Calls [usp_select_CustomerRMA_NextNumber]
/// </summary>
public static CustomerRma GetNextNumber(System.Int32?clientNo, System.Int32?updatedBy)
{
Rebound.GlobalTrader.DAL.CustomerRmaDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRma.GetNextNumber(clientNo, updatedBy);
if (objDetails == null)
{
return(null);
}
else
{
CustomerRma obj = new CustomerRma();
obj.CustomerRMANumber = objDetails.CustomerRMANumber;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetIDByNumber
/// Calls [usp_select_CustomerRMA_ID_by_Number]
/// </summary>
public static List <CustomerRma> GetIDByNumber(System.Int32?customerRmaNumber, System.Int32?clientNo, System.Int32?isGlobalUser)
{
//[003] start
List <Rebound.GlobalTrader.DAL.CustomerRmaDetails> objDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRma.GetIDByNumber(customerRmaNumber, clientNo, isGlobalUser);
List <CustomerRma> lstCRMA = new List <CustomerRma>();
foreach (CustomerRmaDetails crmad in objDetails)
{
CustomerRma crma = new CustomerRma();
crma.CustomerRMAId = crmad.CustomerRMAId;
crma.CRMANumberDetail = crmad.CRMANumberDetail;
lstCRMA.Add(crma);
}
return(lstCRMA);
//[003] end
}
public static List <CustomerRma> GetCRMAInternalLog(System.Int32 customerRmaNumber)
{
//[004] start
List <Rebound.GlobalTrader.DAL.CustomerRmaDetails> objDetails = Rebound.GlobalTrader.DAL.SiteProvider.CustomerRma.GetCRMAInternalLog(customerRmaNumber);
List <CustomerRma> lstCRMA = new List <CustomerRma>();
foreach (CustomerRmaDetails crmad in objDetails)
{
CustomerRma crma = new CustomerRma();
crma.CRMAExpediteNotesId = crmad.CRMAExpediteNotesId;
crma.Notes = crmad.Notes;
crma.EmployeeName = crmad.EmployeeName;
crma.DLUP = crmad.DLUP;
lstCRMA.Add(crma);
}
return(lstCRMA);
//[004] end
}