public SALSalesHeaderCollection HeaderSearch(string CustomerName, string InvoiceNumber)
{
SALSalesHeaderCollection sALSalesHeaderCollection = new SALSalesHeaderCollection();
foreach (POS.DataLayer.SALSalesHeader _sALSalesHeader in POS.DataLayer.SALSalesHeader.HeaderSearch(CustomerName, InvoiceNumber))
{
SALSalesHeader _sALSalesHeaderWCF = new SALSalesHeader();
_sALSalesHeaderWCF.SalesHeaderID = _sALSalesHeader.SalesHeaderID;
_sALSalesHeaderWCF.SalesDate = _sALSalesHeader.SalesDate;
_sALSalesHeaderWCF.CustomerID = _sALSalesHeader.CustomerID;
_sALSalesHeaderWCF.CustomerName = _sALSalesHeader.CustomerName;
_sALSalesHeaderWCF.InvoiceNumber = _sALSalesHeader.InvoiceNumber;
_sALSalesHeaderWCF.InvoiceDate = _sALSalesHeader.InvoiceDate;
_sALSalesHeaderWCF.SellerID = _sALSalesHeader.SellerID;
_sALSalesHeaderWCF.PaymentTypeID = _sALSalesHeader.PaymentTypeID;
_sALSalesHeaderWCF.TotalPrice = _sALSalesHeader.TotalPrice;
_sALSalesHeaderWCF.PaidAmount = _sALSalesHeader.PaidAmount;
_sALSalesHeaderWCF.RemainingAmount = _sALSalesHeader.RemainingAmount;
_sALSalesHeaderWCF.LastDayToPay = _sALSalesHeader.LastDayToPay;
_sALSalesHeaderWCF.TotalDiscountAmount = _sALSalesHeader.TotalDiscountAmount;
_sALSalesHeaderWCF.TotalDiscountRatio = _sALSalesHeader.TotalDiscountRatio;
_sALSalesHeaderWCF.IsClosed = _sALSalesHeader.IsClosed;
_sALSalesHeaderWCF.IsVoid = _sALSalesHeader.IsVoid;
_sALSalesHeaderWCF.IsPrinted = _sALSalesHeader.IsPrinted;
_sALSalesHeaderWCF.ServicePrice = _sALSalesHeader.ServicePrice;
_sALSalesHeaderWCF.TaxTypeID = _sALSalesHeader.TaxTypeID;
_sALSalesHeaderWCF.RefuseReasonID = _sALSalesHeader.RefuseReasonID;
_sALSalesHeaderWCF.CreatedBy = _sALSalesHeader.CreatedBy;
_sALSalesHeaderWCF.CreateDate = _sALSalesHeader.CreateDate;
_sALSalesHeaderWCF.UpdatedBy = _sALSalesHeader.UpdatedBy;
_sALSalesHeaderWCF.UpdateDate = _sALSalesHeader.UpdateDate;
_sALSalesHeaderWCF.IsDeleted = _sALSalesHeader.IsDeleted;
_sALSalesHeaderWCF.DeletedBy = _sALSalesHeader.DeletedBy;
_sALSalesHeaderWCF.DeletDate = _sALSalesHeader.DeletDate;
sALSalesHeaderCollection.Add(_sALSalesHeaderWCF);
}
return(sALSalesHeaderCollection);
}
public SALSalesHeaderCollection HeaderSearch(string CustomerName, string InvoiceNumber)
{
SALSalesHeaderCollection sALSalesHeaderCollection = new SALSalesHeaderCollection();
foreach (POS.DataLayer.SALSalesHeader _sALSalesHeader in POS.DataLayer.SALSalesHeader.HeaderSearch(CustomerName, InvoiceNumber))
{
SALSalesHeader _sALSalesHeaderWCF = new SALSalesHeader();
_sALSalesHeaderWCF.SalesHeaderID = _sALSalesHeader.SalesHeaderID;
_sALSalesHeaderWCF.SalesDate = _sALSalesHeader.SalesDate;
_sALSalesHeaderWCF.CustomerID = _sALSalesHeader.CustomerID;
_sALSalesHeaderWCF.CustomerName = _sALSalesHeader.CustomerName;
_sALSalesHeaderWCF.InvoiceNumber = _sALSalesHeader.InvoiceNumber;
_sALSalesHeaderWCF.InvoiceDate = _sALSalesHeader.InvoiceDate;
_sALSalesHeaderWCF.SellerID = _sALSalesHeader.SellerID;
_sALSalesHeaderWCF.PaymentTypeID = _sALSalesHeader.PaymentTypeID;
_sALSalesHeaderWCF.TotalPrice = _sALSalesHeader.TotalPrice;
_sALSalesHeaderWCF.PaidAmount = _sALSalesHeader.PaidAmount;
_sALSalesHeaderWCF.RemainingAmount = _sALSalesHeader.RemainingAmount;
_sALSalesHeaderWCF.LastDayToPay = _sALSalesHeader.LastDayToPay;
_sALSalesHeaderWCF.TotalDiscountAmount = _sALSalesHeader.TotalDiscountAmount;
_sALSalesHeaderWCF.TotalDiscountRatio = _sALSalesHeader.TotalDiscountRatio;
_sALSalesHeaderWCF.IsClosed = _sALSalesHeader.IsClosed;
_sALSalesHeaderWCF.IsVoid = _sALSalesHeader.IsVoid;
_sALSalesHeaderWCF.IsPrinted = _sALSalesHeader.IsPrinted;
_sALSalesHeaderWCF.ServicePrice = _sALSalesHeader.ServicePrice;
_sALSalesHeaderWCF.TaxTypeID = _sALSalesHeader.TaxTypeID;
_sALSalesHeaderWCF.RefuseReasonID = _sALSalesHeader.RefuseReasonID;
_sALSalesHeaderWCF.CreatedBy = _sALSalesHeader.CreatedBy;
_sALSalesHeaderWCF.CreateDate = _sALSalesHeader.CreateDate;
_sALSalesHeaderWCF.UpdatedBy = _sALSalesHeader.UpdatedBy;
_sALSalesHeaderWCF.UpdateDate = _sALSalesHeader.UpdateDate;
_sALSalesHeaderWCF.IsDeleted = _sALSalesHeader.IsDeleted;
_sALSalesHeaderWCF.DeletedBy = _sALSalesHeader.DeletedBy;
_sALSalesHeaderWCF.DeletDate = _sALSalesHeader.DeletDate;
sALSalesHeaderCollection.Add(_sALSalesHeaderWCF);
}
return sALSalesHeaderCollection;
}
private static SALSalesHeaderCollection PopulateFromReader(IDataReader rdr)
{
SALSalesHeaderCollection sALSalesHeaderCollection = new SALSalesHeaderCollection();
while (rdr.Read())
{
SALSalesHeader obj = new SALSalesHeader();
obj.SalesHeaderID = rdr.GetInt32(rdr.GetOrdinal(SALSalesHeaderFields.SalesHeaderID));
obj.SalesDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesHeaderFields.SalesDate));
obj.CustomerID = rdr.GetInt32(rdr.GetOrdinal(SALSalesHeaderFields.CustomerID));
if (!rdr.IsDBNull(rdr.GetOrdinal("CustomerName")))
{
obj.CustomerName = rdr.GetString(rdr.GetOrdinal("CustomerName"));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.InvoiceNumber)))
{
obj.InvoiceNumber = rdr.GetString(rdr.GetOrdinal(SALSalesHeaderFields.InvoiceNumber));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.InvoiceDate)))
{
obj.InvoiceDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesHeaderFields.InvoiceDate));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.SellerID)))
{
obj.SellerID = rdr.GetInt32(rdr.GetOrdinal(SALSalesHeaderFields.SellerID));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.PaymentTypeID)))
{
obj.PaymentTypeID = rdr.GetInt32(rdr.GetOrdinal(SALSalesHeaderFields.PaymentTypeID));
}
obj.TotalPrice = rdr.GetDecimal(rdr.GetOrdinal(SALSalesHeaderFields.TotalPrice));
obj.PaidAmount = rdr.GetDecimal(rdr.GetOrdinal(SALSalesHeaderFields.PaidAmount));
obj.RemainingAmount = rdr.GetDecimal(rdr.GetOrdinal(SALSalesHeaderFields.RemainingAmount));
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.LastDayToPay)))
{
obj.LastDayToPay = rdr.GetDateTime(rdr.GetOrdinal(SALSalesHeaderFields.LastDayToPay));
}
obj.TotalDiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(SALSalesHeaderFields.TotalDiscountAmount));
obj.TotalDiscountRatio = rdr.GetDouble(rdr.GetOrdinal(SALSalesHeaderFields.TotalDiscountRatio));
obj.IsClosed = rdr.GetBoolean(rdr.GetOrdinal(SALSalesHeaderFields.IsClosed));
obj.IsVoid = rdr.GetBoolean(rdr.GetOrdinal(SALSalesHeaderFields.IsVoid));
obj.IsPrinted = rdr.GetBoolean(rdr.GetOrdinal(SALSalesHeaderFields.IsPrinted));
obj.ServicePrice = rdr.GetDecimal(rdr.GetOrdinal(SALSalesHeaderFields.ServicePrice));
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.TaxTypeID)))
{
obj.TaxTypeID = rdr.GetInt32(rdr.GetOrdinal(SALSalesHeaderFields.TaxTypeID));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.RefuseReasonID)))
{
obj.RefuseReasonID = rdr.GetInt32(rdr.GetOrdinal(SALSalesHeaderFields.RefuseReasonID));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.CreatedBy)))
{
obj.CreatedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesHeaderFields.CreatedBy));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.CreateDate)))
{
obj.CreateDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesHeaderFields.CreateDate));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.UpdatedBy)))
{
obj.UpdatedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesHeaderFields.UpdatedBy));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.UpdateDate)))
{
obj.UpdateDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesHeaderFields.UpdateDate));
}
obj.IsDeleted = rdr.GetBoolean(rdr.GetOrdinal(SALSalesHeaderFields.IsDeleted));
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.DeletedBy)))
{
obj.DeletedBy = rdr.GetInt32(rdr.GetOrdinal(SALSalesHeaderFields.DeletedBy));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(SALSalesHeaderFields.DeletDate)))
{
obj.DeletDate = rdr.GetDateTime(rdr.GetOrdinal(SALSalesHeaderFields.DeletDate));
}
sALSalesHeaderCollection.Add(obj);
}
return sALSalesHeaderCollection;
}
/// <summary>
/// This method will return a list of objects representing the specified number of entries from the specified record number in the table
/// using the value of the field specified
/// </summary>
///
/// <param name="field" type="string">Field of the class SALSalesHeader</param>
/// <param name="fieldValue" type="object">Value for the field specified.</param>
/// <param name="fieldValue2" type="object">Value for the field specified.</param>
/// <param name="typeOperation" type="TypeOperation">Operator that is used if fieldValue2=null or fieldValue2="".</param>
/// <param name="orderByStatement" type="string">The field value to number.</param>
/// <param name="pageSize" type="int">Number of records returned.</param>
/// <param name="skipPages" type="int">The number of missing pages.</param>
///
/// <returns>List of object of class SALSalesHeader in the form of an object of class SALSalesHeaderCollection</returns>
public SALSalesHeaderCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
SALSalesHeaderCollection sALSalesHeaderCollection = new SALSalesHeaderCollection();
foreach (POS.DataLayer.SALSalesHeader _sALSalesHeader in POS.DataLayer.SALSalesHeaderBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_sALSalesHeaderWCF = new SALSalesHeader();
_sALSalesHeaderWCF.SalesHeaderID = _sALSalesHeader.SalesHeaderID;
_sALSalesHeaderWCF.SalesDate = _sALSalesHeader.SalesDate;
_sALSalesHeaderWCF.CustomerID = _sALSalesHeader.CustomerID;
_sALSalesHeaderWCF.InvoiceNumber = _sALSalesHeader.InvoiceNumber;
_sALSalesHeaderWCF.InvoiceDate = _sALSalesHeader.InvoiceDate;
_sALSalesHeaderWCF.SellerID = _sALSalesHeader.SellerID;
_sALSalesHeaderWCF.PaymentTypeID = _sALSalesHeader.PaymentTypeID;
_sALSalesHeaderWCF.TotalPrice = _sALSalesHeader.TotalPrice;
_sALSalesHeaderWCF.PaidAmount = _sALSalesHeader.PaidAmount;
_sALSalesHeaderWCF.RemainingAmount = _sALSalesHeader.RemainingAmount;
_sALSalesHeaderWCF.LastDayToPay = _sALSalesHeader.LastDayToPay;
_sALSalesHeaderWCF.TotalDiscountAmount = _sALSalesHeader.TotalDiscountAmount;
_sALSalesHeaderWCF.TotalDiscountRatio = _sALSalesHeader.TotalDiscountRatio;
_sALSalesHeaderWCF.IsClosed = _sALSalesHeader.IsClosed;
_sALSalesHeaderWCF.IsVoid = _sALSalesHeader.IsVoid;
_sALSalesHeaderWCF.IsPrinted = _sALSalesHeader.IsPrinted;
_sALSalesHeaderWCF.ServicePrice = _sALSalesHeader.ServicePrice;
_sALSalesHeaderWCF.TaxTypeID = _sALSalesHeader.TaxTypeID;
_sALSalesHeaderWCF.RefuseReasonID = _sALSalesHeader.RefuseReasonID;
_sALSalesHeaderWCF.CreatedBy = _sALSalesHeader.CreatedBy;
_sALSalesHeaderWCF.CreateDate = _sALSalesHeader.CreateDate;
_sALSalesHeaderWCF.UpdatedBy = _sALSalesHeader.UpdatedBy;
_sALSalesHeaderWCF.UpdateDate = _sALSalesHeader.UpdateDate;
_sALSalesHeaderWCF.IsDeleted = _sALSalesHeader.IsDeleted;
_sALSalesHeaderWCF.DeletedBy = _sALSalesHeader.DeletedBy;
_sALSalesHeaderWCF.DeletDate = _sALSalesHeader.DeletDate;
_sALSalesHeaderWCF.InventoryID = _sALSalesHeader.InventoryID;
_sALSalesHeaderWCF.FinalPrice = _sALSalesHeader.FinalPrice;
_sALSalesHeaderWCF.ChequeNumber = _sALSalesHeader.ChequeNumber;
sALSalesHeaderCollection.Add(_sALSalesHeaderWCF);
}
return sALSalesHeaderCollection;
}
/// <summary>
/// This method will get row(s) from the database using the value of the field specified
/// along with the details of the child table.
/// </summary>
///
/// <param name="pk" type="PaymentTypePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class SALSalesHeaderCollection</returns>
public SALSalesHeaderCollection SelectAllByForeignKeyPaymentTypeID(PaymentTypePrimaryKey pk)
{
SALSalesHeaderCollection sALSalesHeaderCollection=new SALSalesHeaderCollection();
foreach (POS.DataLayer.SALSalesHeader _sALSalesHeader in POS.DataLayer.SALSalesHeaderBase.SelectAllByForeignKeyPaymentTypeID(new POS.DataLayer.PaymentTypePrimaryKey(pk.PaymentTypeID)))
{
_sALSalesHeaderWCF = new SALSalesHeader();
_sALSalesHeaderWCF.SalesHeaderID = _sALSalesHeader.SalesHeaderID;
_sALSalesHeaderWCF.SalesDate = _sALSalesHeader.SalesDate;
_sALSalesHeaderWCF.CustomerID = _sALSalesHeader.CustomerID;
_sALSalesHeaderWCF.InvoiceNumber = _sALSalesHeader.InvoiceNumber;
_sALSalesHeaderWCF.InvoiceDate = _sALSalesHeader.InvoiceDate;
_sALSalesHeaderWCF.SellerID = _sALSalesHeader.SellerID;
_sALSalesHeaderWCF.PaymentTypeID = _sALSalesHeader.PaymentTypeID;
_sALSalesHeaderWCF.TotalPrice = _sALSalesHeader.TotalPrice;
_sALSalesHeaderWCF.PaidAmount = _sALSalesHeader.PaidAmount;
_sALSalesHeaderWCF.RemainingAmount = _sALSalesHeader.RemainingAmount;
_sALSalesHeaderWCF.LastDayToPay = _sALSalesHeader.LastDayToPay;
_sALSalesHeaderWCF.TotalDiscountAmount = _sALSalesHeader.TotalDiscountAmount;
_sALSalesHeaderWCF.TotalDiscountRatio = _sALSalesHeader.TotalDiscountRatio;
_sALSalesHeaderWCF.IsClosed = _sALSalesHeader.IsClosed;
_sALSalesHeaderWCF.IsVoid = _sALSalesHeader.IsVoid;
_sALSalesHeaderWCF.IsPrinted = _sALSalesHeader.IsPrinted;
_sALSalesHeaderWCF.ServicePrice = _sALSalesHeader.ServicePrice;
_sALSalesHeaderWCF.TaxTypeID = _sALSalesHeader.TaxTypeID;
_sALSalesHeaderWCF.RefuseReasonID = _sALSalesHeader.RefuseReasonID;
_sALSalesHeaderWCF.CreatedBy = _sALSalesHeader.CreatedBy;
_sALSalesHeaderWCF.CreateDate = _sALSalesHeader.CreateDate;
_sALSalesHeaderWCF.UpdatedBy = _sALSalesHeader.UpdatedBy;
_sALSalesHeaderWCF.UpdateDate = _sALSalesHeader.UpdateDate;
_sALSalesHeaderWCF.IsDeleted = _sALSalesHeader.IsDeleted;
_sALSalesHeaderWCF.DeletedBy = _sALSalesHeader.DeletedBy;
_sALSalesHeaderWCF.DeletDate = _sALSalesHeader.DeletDate;
_sALSalesHeaderWCF.InventoryID = _sALSalesHeader.InventoryID;
_sALSalesHeaderWCF.FinalPrice = _sALSalesHeader.FinalPrice;
_sALSalesHeaderWCF.ChequeNumber = _sALSalesHeader.ChequeNumber;
sALSalesHeaderCollection.Add(_sALSalesHeaderWCF);
}
return sALSalesHeaderCollection;
}
/// <summary>
/// Populates the fields for multiple objects from the columns found in an open reader.
/// </summary>
///
/// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
///
/// <returns>Object of SALSalesHeaderCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 10:40:24 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static SALSalesHeaderCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper)
{
SALSalesHeaderCollection list = new SALSalesHeaderCollection();
if (rdr.Read())
{
SALSalesHeader obj = new SALSalesHeader();
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
while (rdr.Read())
{
obj = new SALSalesHeader();
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
}
oDatabaseHelper.Dispose();
return list;
}
else
{
oDatabaseHelper.Dispose();
return null;
}
}
/// <summary>
/// Populates the fields for multiple objects from the columns found in an open reader.
/// </summary>
///
/// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param>
///
/// <returns>Object of SALSalesHeaderCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 10:40:24 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static SALSalesHeaderCollection PopulateObjectsFromReader(IDataReader rdr)
{
SALSalesHeaderCollection list = new SALSalesHeaderCollection();
while (rdr.Read())
{
SALSalesHeader obj = new SALSalesHeader();
PopulateObjectFromReader(obj,rdr);
list.Add(obj);
}
return list;
}
/// <summary>
/// This method will get row(s) from the database using the value of the field specified
/// along with the details of the child table.
/// </summary>
///
/// <param name="pk" type="PaymentTypePrimaryKey">Primary Key information based on which data is to be fetched.</param>
/// <param name="pageSize" type="int">Number of records returned.</param>
/// <param name="skipPages" type="int">The number of missing pages.</param>
/// <param name="orderByStatement" type="string">The field value to number</param>
///
/// <returns>object of class SALSalesHeaderCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 3/7/2015 10:40:24 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public static SALSalesHeaderCollection SelectAllByForeignKeyPaymentTypeIDPaged(PaymentTypePrimaryKey pk, int pageSize, int skipPages, string orderByStatement)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
SALSalesHeaderCollection obj = null;
// Pass the values of all key parameters to the stored procedure.
System.Collections.Specialized.NameValueCollection nvc = pk.GetKeysAndValues();
foreach (string key in nvc.Keys)
{
oDatabaseHelper.AddParameter("@" + key,nvc[key] );
}
oDatabaseHelper.AddParameter("@PageSize",pageSize);
oDatabaseHelper.AddParameter("@SkipPages", skipPages);
oDatabaseHelper.AddParameter("@OrderByStatement", orderByStatement );
// The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure.
oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);
IDataReader dr=oDatabaseHelper.ExecuteReader("gsp_SALSalesHeader_SelectAllByForeignKeyPaymentTypeIDPaged", ref ExecutionState);
obj = new SALSalesHeaderCollection();
obj = SALSalesHeader.PopulateObjectsFromReaderWithCheckingReader(dr, oDatabaseHelper);
dr.Close();
oDatabaseHelper.Dispose();
return obj;
}
