/// <summary>
/// This method will return a list of objects representing all records in the table.
/// </summary>
///
/// <returns>list of objects of class SALSalesLine in the form of object of SALSalesLineCollection </returns>
public SALSalesLineCollection SelectAll()
{
SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection();
foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectAll())
{
_sALSalesLineWCF = new SALSalesLine();
_sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID;
_sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID;
_sALSalesLineWCF.ProductID = _sALSalesLine.ProductID;
_sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty;
_sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus;
_sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount;
_sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio;
_sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice;
_sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy;
_sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate;
_sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy;
_sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate;
_sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted;
_sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy;
_sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate;
sALSalesLineCollection.Add(_sALSalesLineWCF);
}
return(sALSalesLineCollection);
}
/// <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 SALSalesLine</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 SALSalesLine in the form of an object of class SALSalesLineCollection</returns>
public SALSalesLineCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection();
foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_sALSalesLineWCF = new SALSalesLine();
_sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID;
_sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID;
_sALSalesLineWCF.ProductID = _sALSalesLine.ProductID;
_sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty;
_sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus;
_sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount;
_sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio;
_sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice;
_sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy;
_sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate;
_sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy;
_sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate;
_sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted;
_sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy;
_sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate;
sALSalesLineCollection.Add(_sALSalesLineWCF);
}
return(sALSalesLineCollection);
}
/// <summary>
/// This method will return a list of objects representing the specified number of entries from the specified record number in the table.
/// </summary>
///
/// <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>list of objects of class SALSalesLine in the form of an object of class SALSalesLineCollection </returns>
public SALSalesLineCollection SelectAllPaged(int?pageSize, int?skipPages, string orderByStatement)
{
SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection();
foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectAllPaged(pageSize, skipPages, orderByStatement))
{
_sALSalesLineWCF = new SALSalesLine();
_sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID;
_sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID;
_sALSalesLineWCF.ProductID = _sALSalesLine.ProductID;
_sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty;
_sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus;
_sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount;
_sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio;
_sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice;
_sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy;
_sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate;
_sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy;
_sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate;
_sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted;
_sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy;
_sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate;
sALSalesLineCollection.Add(_sALSalesLineWCF);
}
return(sALSalesLineCollection);
}
///<summary>
/// This method will update one new row into the database using the property Information
/// </summary>
///
/// <param name="sALSalesLine" type="SALSalesLine">This SALSalesLine will be updated in the database.</param>
///
/// <returns>True if succeeded</returns>
public bool Update(SALSalesLine sALSalesLine)
{
_sALSalesLine = POS.DataLayer.SALSalesLine.SelectOne(new POS.DataLayer.SALSalesLinePrimaryKey(sALSalesLine.SalesLineID));
_sALSalesLine.SalesHeaderID = sALSalesLine.SalesHeaderID;
_sALSalesLine.ProductID = sALSalesLine.ProductID;
_sALSalesLine.TotalQty = sALSalesLine.TotalQty;
_sALSalesLine.TotalBonus = sALSalesLine.TotalBonus;
_sALSalesLine.DiscountAmount = sALSalesLine.DiscountAmount;
_sALSalesLine.DiscountRatio = sALSalesLine.DiscountRatio;
_sALSalesLine.UnitPrice = sALSalesLine.UnitPrice;
_sALSalesLine.CreatedBy = sALSalesLine.CreatedBy;
_sALSalesLine.CreateDate = sALSalesLine.CreateDate;
_sALSalesLine.UpdatedBy = sALSalesLine.UpdatedBy;
_sALSalesLine.UpdateDate = sALSalesLine.UpdateDate;
_sALSalesLine.IsDeleted = sALSalesLine.IsDeleted;
_sALSalesLine.DeletedBy = sALSalesLine.DeletedBy;
_sALSalesLine.DeleteDate = sALSalesLine.DeleteDate;
return(_sALSalesLine.Update());
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="SALSalesLinePrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class SALSalesLine</returns>
public SALSalesLine SelectOne(SALSalesLinePrimaryKey pk)
{
_sALSalesLineWCF = new SALSalesLine();
_sALSalesLine = POS.DataLayer.SALSalesLineBase.SelectOne(new POS.DataLayer.SALSalesLinePrimaryKey(pk.SalesLineID));
_sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID;
_sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID;
_sALSalesLineWCF.ProductID = _sALSalesLine.ProductID;
_sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty;
_sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus;
_sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount;
_sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio;
_sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice;
_sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy;
_sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate;
_sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy;
_sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate;
_sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted;
_sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy;
_sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate;
return(_sALSalesLineWCF);
}
private SALSalesLine CollectScreenData()
{
sALSalesLine = new SALSalesLine();
sALSalesLine.DiscountAmount = 0;//(decimal)((float.Parse(tbx_Discount.Text.Trim(new char[] { '%' })) / 100) * float.Parse(tbx_Price.Text));
sALSalesLine.DiscountRatio = 0;//Convert.ToDecimal(float.Parse(tbx_Discount.Text.Trim(new char[] { '%' })) / 100);
sALSalesLine.ProductID = Convert.ToInt32(cbx_Product.SelectedValue);
sALSalesLine.ProductName = cbx_Product.Text;
sALSalesLine.TotalBonus = 0;
sALSalesLine.TotalQty = Convert.ToInt32(num_Quantity.Text);
sALSalesLine.UnitPrice = Convert.ToDecimal(tbx_Price.Text);
sALSalesLine.CreatedBy = GlobalVariables.CurrentUser.UserID;
return sALSalesLine;
}