/// <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; }
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); }
/// <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; }
///<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 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; }