/// <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> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:03 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static SALSalesLine SelectOne(SALSalesLinePrimaryKey pk) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // 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]); } // 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_SALSalesLine_SelectbyPrimaryKey", ref ExecutionState); if (dr.Read()) { SALSalesLine obj = new SALSalesLine(); PopulateObjectFromReader(obj, dr); dr.Close(); oDatabaseHelper.Dispose(); return(obj); } else { dr.Close(); 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 SALSalesLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:03 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesLineCollection PopulateObjectsFromReader(IDataReader rdr) { SALSalesLineCollection list = new SALSalesLineCollection(); while (rdr.Read()) { SALSalesLine obj = new SALSalesLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); } return(list); }
///<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); }
/// <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> /// 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 SALSalesLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:03 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesLineCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper) { SALSalesLineCollection list = new SALSalesLineCollection(); if (rdr.Read()) { SALSalesLine obj = new SALSalesLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new SALSalesLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); } oDatabaseHelper.Dispose(); return(list); } else { oDatabaseHelper.Dispose(); return(null); } }
/// <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> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:16 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static SALSalesLine SelectOne(SALSalesLinePrimaryKey pk) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // 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] ); } // 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_SALSalesLine_SelectbyPrimaryKey", ref ExecutionState); if (dr.Read()) { SALSalesLine obj=new SALSalesLine(); PopulateObjectFromReader(obj,dr); dr.Close(); oDatabaseHelper.Dispose(); return obj; } else { dr.Close(); 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 SALSalesLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:16 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesLineCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper) { SALSalesLineCollection list = new SALSalesLineCollection(); if (rdr.Read()) { SALSalesLine obj = new SALSalesLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new SALSalesLine(); 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 SALSalesLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:16 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesLineCollection PopulateObjectsFromReader(IDataReader rdr) { SALSalesLineCollection list = new SALSalesLineCollection(); while (rdr.Read()) { SALSalesLine obj = new SALSalesLine(); PopulateObjectFromReader(obj,rdr); list.Add(obj); } return list; }
private bool InsertDetails(DatabaseHelper oDatabaseHelper, SALSalesLine sALSalesLine, int salesHeaderID) { bool ExecutionState = false; // Pass the value of '_salesHeaderID' as parameter 'SalesHeaderID' of the stored procedure. if (salesHeaderID != null) { oDatabaseHelper.AddParameter("@SalesHeaderID", salesHeaderID); } else { oDatabaseHelper.AddParameter("@SalesHeaderID", DBNull.Value); } // Pass the value of '_productID' as parameter 'ProductID' of the stored procedure. if (sALSalesLine.ProductID != null) { oDatabaseHelper.AddParameter("@ProductID", sALSalesLine.ProductID); } else { oDatabaseHelper.AddParameter("@ProductID", DBNull.Value); } // Pass the value of '_totalQty' as parameter 'TotalQty' of the stored procedure. if (sALSalesLine.TotalQty != null) { oDatabaseHelper.AddParameter("@TotalQty", sALSalesLine.TotalQty); } else { oDatabaseHelper.AddParameter("@TotalQty", DBNull.Value); } // Pass the value of '_totalBonus' as parameter 'TotalBonus' of the stored procedure. if (sALSalesLine.TotalBonus != null) { oDatabaseHelper.AddParameter("@TotalBonus", sALSalesLine.TotalBonus); } else { oDatabaseHelper.AddParameter("@TotalBonus", DBNull.Value); } // Pass the value of '_discountAmount' as parameter 'DiscountAmount' of the stored procedure. if (sALSalesLine.DiscountAmount != null) { oDatabaseHelper.AddParameter("@DiscountAmount", sALSalesLine.DiscountAmount); } else { oDatabaseHelper.AddParameter("@DiscountAmount", DBNull.Value); } // Pass the value of '_discountRatio' as parameter 'DiscountRatio' of the stored procedure. if (sALSalesLine.DiscountRatio != null) { oDatabaseHelper.AddParameter("@DiscountRatio", sALSalesLine.DiscountRatio); } else { oDatabaseHelper.AddParameter("@DiscountRatio", DBNull.Value); } // Pass the value of '_unitPrice' as parameter 'UnitPrice' of the stored procedure. if (sALSalesLine.UnitPrice != null) { oDatabaseHelper.AddParameter("@UnitPrice", sALSalesLine.UnitPrice); } else { oDatabaseHelper.AddParameter("@UnitPrice", DBNull.Value); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (sALSalesLine.CreatedBy != null) { oDatabaseHelper.AddParameter("@CreatedBy", sALSalesLine.CreatedBy); } else { oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); } // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. if (sALSalesLine.CreateDate != null) { oDatabaseHelper.AddParameter("@CreateDate", sALSalesLine.CreateDate); } else { oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value); } // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (sALSalesLine.UpdatedBy != null) { oDatabaseHelper.AddParameter("@UpdatedBy", sALSalesLine.UpdatedBy); } else { oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value); } // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (sALSalesLine.UpdateDate != null) { oDatabaseHelper.AddParameter("@UpdateDate", sALSalesLine.UpdateDate); } else { oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value); } // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. if (sALSalesLine.IsDeleted != null) { oDatabaseHelper.AddParameter("@IsDeleted", sALSalesLine.IsDeleted); } else { oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value); } // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure. if (sALSalesLine.DeletedBy != null) { oDatabaseHelper.AddParameter("@DeletedBy", sALSalesLine.DeletedBy); } else { oDatabaseHelper.AddParameter("@DeletedBy", DBNull.Value); } // Pass the value of '_deleteDate' as parameter 'DeleteDate' of the stored procedure. if (sALSalesLine.DeleteDate != null) { oDatabaseHelper.AddParameter("@DeleteDate", sALSalesLine.DeleteDate); } else { oDatabaseHelper.AddParameter("@DeleteDate", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("usp_SALSalesLine_InsertCommit", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState); return(ExecutionState); }
private bool InsertDetails(DatabaseHelper oDatabaseHelper, SALSalesLine sALSalesLine, int salesHeaderID) { bool ExecutionState = false; // Pass the value of '_salesHeaderID' as parameter 'SalesHeaderID' of the stored procedure. if (salesHeaderID != null) oDatabaseHelper.AddParameter("@SalesHeaderID", salesHeaderID); else oDatabaseHelper.AddParameter("@SalesHeaderID", DBNull.Value); // Pass the value of '_productID' as parameter 'ProductID' of the stored procedure. if (sALSalesLine.ProductID != null) oDatabaseHelper.AddParameter("@ProductID", sALSalesLine.ProductID); else oDatabaseHelper.AddParameter("@ProductID", DBNull.Value); // Pass the value of '_totalQty' as parameter 'TotalQty' of the stored procedure. if (sALSalesLine.TotalQty != null) oDatabaseHelper.AddParameter("@TotalQty", sALSalesLine.TotalQty); else oDatabaseHelper.AddParameter("@TotalQty", DBNull.Value); // Pass the value of '_totalBonus' as parameter 'TotalBonus' of the stored procedure. if (sALSalesLine.TotalBonus != null) oDatabaseHelper.AddParameter("@TotalBonus", sALSalesLine.TotalBonus); else oDatabaseHelper.AddParameter("@TotalBonus", DBNull.Value); // Pass the value of '_discountAmount' as parameter 'DiscountAmount' of the stored procedure. if (sALSalesLine.DiscountAmount != null) oDatabaseHelper.AddParameter("@DiscountAmount", sALSalesLine.DiscountAmount); else oDatabaseHelper.AddParameter("@DiscountAmount", DBNull.Value); // Pass the value of '_discountRatio' as parameter 'DiscountRatio' of the stored procedure. if (sALSalesLine.DiscountRatio != null) oDatabaseHelper.AddParameter("@DiscountRatio", sALSalesLine.DiscountRatio); else oDatabaseHelper.AddParameter("@DiscountRatio", DBNull.Value); // Pass the value of '_unitPrice' as parameter 'UnitPrice' of the stored procedure. if (sALSalesLine.UnitPrice != null) oDatabaseHelper.AddParameter("@UnitPrice", sALSalesLine.UnitPrice); else oDatabaseHelper.AddParameter("@UnitPrice", DBNull.Value); // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (sALSalesLine.CreatedBy != null) oDatabaseHelper.AddParameter("@CreatedBy", sALSalesLine.CreatedBy); else oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. if (sALSalesLine.CreateDate != null) oDatabaseHelper.AddParameter("@CreateDate", sALSalesLine.CreateDate); else oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value); // Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure. if (sALSalesLine.UpdatedBy != null) oDatabaseHelper.AddParameter("@UpdatedBy", sALSalesLine.UpdatedBy); else oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value); // Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure. if (sALSalesLine.UpdateDate != null) oDatabaseHelper.AddParameter("@UpdateDate", sALSalesLine.UpdateDate); else oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value); // Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure. if (sALSalesLine.IsDeleted != null) oDatabaseHelper.AddParameter("@IsDeleted", sALSalesLine.IsDeleted); else oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value); // Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure. if (sALSalesLine.DeletedBy != null) oDatabaseHelper.AddParameter("@DeletedBy", sALSalesLine.DeletedBy); else oDatabaseHelper.AddParameter("@DeletedBy", DBNull.Value); // Pass the value of '_deleteDate' as parameter 'DeleteDate' of the stored procedure. if (sALSalesLine.DeleteDate != null) oDatabaseHelper.AddParameter("@DeleteDate", sALSalesLine.DeleteDate); else oDatabaseHelper.AddParameter("@DeleteDate", DBNull.Value); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("usp_SALSalesLine_InsertCommit", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState); return ExecutionState; }
///<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(); }