/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="SALSalesReturnLinePrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class SALSalesReturnLine</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:04 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static SALSalesReturnLine SelectOne(SALSalesReturnLinePrimaryKey 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_SALSalesReturnLine_SelectbyPrimaryKey", ref ExecutionState); if (dr.Read()) { SALSalesReturnLine obj = new SALSalesReturnLine(); PopulateObjectFromReader(obj, dr); dr.Close(); oDatabaseHelper.Dispose(); return(obj); } else { dr.Close(); oDatabaseHelper.Dispose(); return(null); } }
/// <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="SALSalesReturnHeaderPrimaryKey">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 SALSalesReturnLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 4/4/2015 6:56:38 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static SALSalesReturnLineCollection SelectAllByForeignKeySalesReturnHeaderIDPaged(SALSalesReturnHeaderPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; SALSalesReturnLineCollection 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_SALSalesReturnLine_SelectAllByForeignKeySalesReturnHeaderIDPaged", ref ExecutionState); obj = new SALSalesReturnLineCollection(); obj = SALSalesReturnLine.PopulateObjectsFromReaderWithCheckingReader(dr, oDatabaseHelper); dr.Close(); oDatabaseHelper.Dispose(); return(obj); }
/// <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 SALSalesReturnLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:04 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesReturnLineCollection PopulateObjectsFromReader(IDataReader rdr) { SALSalesReturnLineCollection list = new SALSalesReturnLineCollection(); while (rdr.Read()) { SALSalesReturnLine obj = new SALSalesReturnLine(); 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="sALSalesReturnLine" type="SALSalesReturnLine">This SALSalesReturnLine will be updated in the database.</param> /// /// <returns>True if succeeded</returns> public bool Update(SALSalesReturnLine sALSalesReturnLine) { _sALSalesReturnLine = POS.DataLayer.SALSalesReturnLine.SelectOne(new POS.DataLayer.SALSalesReturnLinePrimaryKey(sALSalesReturnLine.SalesReturnLineID)); _sALSalesReturnLine.Qty = sALSalesReturnLine.Qty; _sALSalesReturnLine.Reason = sALSalesReturnLine.Reason; _sALSalesReturnLine.OriginalSalesLineID = sALSalesReturnLine.OriginalSalesLineID; _sALSalesReturnLine.BatchID = sALSalesReturnLine.BatchID; _sALSalesReturnLine.BatchNumber = sALSalesReturnLine.BatchNumber; _sALSalesReturnLine.ExpiryDate = sALSalesReturnLine.ExpiryDate; return(_sALSalesReturnLine.Update()); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// /// <param name="sALSalesReturnLine" type="SALSalesReturnLine">This SALSalesReturnLine will be inserted in the database.</param> /// /// <returns>True if succeeded</returns> public bool Insert(SALSalesReturnLine sALSalesReturnLine) { _sALSalesReturnLine = new POS.DataLayer.SALSalesReturnLine(); _sALSalesReturnLine.SalesReturnLineID = sALSalesReturnLine.SalesReturnLineID; _sALSalesReturnLine.Qty = sALSalesReturnLine.Qty; _sALSalesReturnLine.Reason = sALSalesReturnLine.Reason; _sALSalesReturnLine.OriginalSalesLineID = sALSalesReturnLine.OriginalSalesLineID; _sALSalesReturnLine.BatchID = sALSalesReturnLine.BatchID; _sALSalesReturnLine.BatchNumber = sALSalesReturnLine.BatchNumber; _sALSalesReturnLine.ExpiryDate = sALSalesReturnLine.ExpiryDate; return(_sALSalesReturnLine.Insert()); }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="SALSalesReturnLinePrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class SALSalesReturnLine</returns> public SALSalesReturnLine SelectOne(SALSalesReturnLinePrimaryKey pk) { _sALSalesReturnLineWCF = new SALSalesReturnLine(); _sALSalesReturnLine = POS.DataLayer.SALSalesReturnLineBase.SelectOne(new POS.DataLayer.SALSalesReturnLinePrimaryKey(pk.SalesReturnLineID)); _sALSalesReturnLineWCF.SalesReturnLineID = _sALSalesReturnLine.SalesReturnLineID; _sALSalesReturnLineWCF.Qty = _sALSalesReturnLine.Qty; _sALSalesReturnLineWCF.Reason = _sALSalesReturnLine.Reason; _sALSalesReturnLineWCF.OriginalSalesLineID = _sALSalesReturnLine.OriginalSalesLineID; _sALSalesReturnLineWCF.BatchID = _sALSalesReturnLine.BatchID; _sALSalesReturnLineWCF.BatchNumber = _sALSalesReturnLine.BatchNumber; _sALSalesReturnLineWCF.ExpiryDate = _sALSalesReturnLine.ExpiryDate; return(_sALSalesReturnLineWCF); }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="SALSalesReturnLinePrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class SALSalesReturnLine</returns> public SALSalesReturnLine SelectOne(SALSalesReturnLinePrimaryKey pk) { _sALSalesReturnLineWCF = new SALSalesReturnLine(); _sALSalesReturnLine = POS.DataLayer.SALSalesReturnLineBase.SelectOne(new POS.DataLayer.SALSalesReturnLinePrimaryKey(pk.SalesReturnLineID)); _sALSalesReturnLineWCF.SalesReturnLineID = _sALSalesReturnLine.SalesReturnLineID; _sALSalesReturnLineWCF.Qty = _sALSalesReturnLine.Qty; _sALSalesReturnLineWCF.Reason = _sALSalesReturnLine.Reason; _sALSalesReturnLineWCF.OriginalSalesLineID = _sALSalesReturnLine.OriginalSalesLineID; _sALSalesReturnLineWCF.BatchID = _sALSalesReturnLine.BatchID; _sALSalesReturnLineWCF.BatchNumber = _sALSalesReturnLine.BatchNumber; _sALSalesReturnLineWCF.ExpiryDate = _sALSalesReturnLine.ExpiryDate; _sALSalesReturnLineWCF.SalesReturnHeaderID = _sALSalesReturnLine.SalesReturnHeaderID; return _sALSalesReturnLineWCF; }
/// <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 SALSalesReturnLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 12/27/2014 6:56:04 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesReturnLineCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper) { SALSalesReturnLineCollection list = new SALSalesReturnLineCollection(); if (rdr.Read()) { SALSalesReturnLine obj = new SALSalesReturnLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new SALSalesReturnLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); } oDatabaseHelper.Dispose(); return(list); } else { oDatabaseHelper.Dispose(); return(null); } }
private bool InsertDetails(DatabaseHelper oDatabaseHelper, SALSalesReturnLine sALSalesReturnLine, int salesReturnHeaderID) { bool ExecutionState = false; // Pass the value of '_qty' as parameter 'Qty' of the stored procedure. if (sALSalesReturnLine.Qty != null) oDatabaseHelper.AddParameter("@Qty", sALSalesReturnLine.Qty); else oDatabaseHelper.AddParameter("@Qty", DBNull.Value); // Pass the value of '_reason' as parameter 'Reason' of the stored procedure. if (sALSalesReturnLine.Reason != null) oDatabaseHelper.AddParameter("@Reason", sALSalesReturnLine.Reason); else oDatabaseHelper.AddParameter("@Reason", DBNull.Value); // Pass the value of '_originalSalesLineID' as parameter 'OriginalSalesLineID' of the stored procedure. if (sALSalesReturnLine.OriginalSalesLineID != null) oDatabaseHelper.AddParameter("@OriginalSalesLineID", sALSalesReturnLine.OriginalSalesLineID); else oDatabaseHelper.AddParameter("@OriginalSalesLineID", DBNull.Value); // Pass the value of '_batchID' as parameter 'BatchID' of the stored procedure. if (sALSalesReturnLine.BatchID != null) oDatabaseHelper.AddParameter("@BatchID", sALSalesReturnLine.BatchID); else oDatabaseHelper.AddParameter("@BatchID", DBNull.Value); // Pass the value of '_batchNumber' as parameter 'BatchNumber' of the stored procedure. if (sALSalesReturnLine.BatchNumber != null) oDatabaseHelper.AddParameter("@BatchNumber", sALSalesReturnLine.BatchNumber); else oDatabaseHelper.AddParameter("@BatchNumber", DBNull.Value); // Pass the value of '_expiryDate' as parameter 'ExpiryDate' of the stored procedure. if (sALSalesReturnLine.ExpiryDate != null) oDatabaseHelper.AddParameter("@ExpiryDate", sALSalesReturnLine.ExpiryDate); else oDatabaseHelper.AddParameter("@ExpiryDate", DBNull.Value); if (sALSalesReturnLine.StockTypeID != null) oDatabaseHelper.AddParameter("@StockType", sALSalesReturnLine.StockTypeID); else oDatabaseHelper.AddParameter("@StockType", DBNull.Value); oDatabaseHelper.AddParameter("@SalesReturnHeaderID", salesReturnHeaderID); oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("usp_SALSalesReturnLine_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="sALSalesReturnLine" type="SALSalesReturnLine">This SALSalesReturnLine will be updated in the database.</param> /// /// <returns>True if succeeded</returns> public bool Update(SALSalesReturnLine sALSalesReturnLine) { _sALSalesReturnLine=POS.DataLayer.SALSalesReturnLine.SelectOne(new POS.DataLayer.SALSalesReturnLinePrimaryKey(sALSalesReturnLine.SalesReturnLineID)); _sALSalesReturnLine.Qty=sALSalesReturnLine.Qty; _sALSalesReturnLine.Reason=sALSalesReturnLine.Reason; _sALSalesReturnLine.OriginalSalesLineID=sALSalesReturnLine.OriginalSalesLineID; _sALSalesReturnLine.BatchID=sALSalesReturnLine.BatchID; _sALSalesReturnLine.BatchNumber=sALSalesReturnLine.BatchNumber; _sALSalesReturnLine.ExpiryDate=sALSalesReturnLine.ExpiryDate; _sALSalesReturnLine.SalesReturnHeaderID=sALSalesReturnLine.SalesReturnHeaderID; return _sALSalesReturnLine.Update(); }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// /// <param name="sALSalesReturnLine" type="SALSalesReturnLine">This SALSalesReturnLine will be inserted in the database.</param> /// /// <returns>True if succeeded</returns> public bool Insert(SALSalesReturnLine sALSalesReturnLine) { _sALSalesReturnLine = new POS.DataLayer.SALSalesReturnLine(); _sALSalesReturnLine.SalesReturnLineID=sALSalesReturnLine.SalesReturnLineID; _sALSalesReturnLine.Qty=sALSalesReturnLine.Qty; _sALSalesReturnLine.Reason=sALSalesReturnLine.Reason; _sALSalesReturnLine.OriginalSalesLineID=sALSalesReturnLine.OriginalSalesLineID; _sALSalesReturnLine.BatchID=sALSalesReturnLine.BatchID; _sALSalesReturnLine.BatchNumber=sALSalesReturnLine.BatchNumber; _sALSalesReturnLine.ExpiryDate=sALSalesReturnLine.ExpiryDate; _sALSalesReturnLine.SalesReturnHeaderID=sALSalesReturnLine.SalesReturnHeaderID; return _sALSalesReturnLine.Insert(); }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="SALSalesReturnLinePrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class SALSalesReturnLine</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 4/4/2015 6:56:37 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static SALSalesReturnLine SelectOne(SALSalesReturnLinePrimaryKey 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_SALSalesReturnLine_SelectbyPrimaryKey", ref ExecutionState); if (dr.Read()) { SALSalesReturnLine obj=new SALSalesReturnLine(); 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 SALSalesReturnLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 4/4/2015 6:56:38 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesReturnLineCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper) { SALSalesReturnLineCollection list = new SALSalesReturnLineCollection(); if (rdr.Read()) { SALSalesReturnLine obj = new SALSalesReturnLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new SALSalesReturnLine(); 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 SALSalesReturnLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 4/4/2015 6:56:38 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesReturnLineCollection PopulateObjectsFromReader(IDataReader rdr) { SALSalesReturnLineCollection list = new SALSalesReturnLineCollection(); while (rdr.Read()) { SALSalesReturnLine obj = new SALSalesReturnLine(); PopulateObjectFromReader(obj,rdr); list.Add(obj); } return list; }
private bool InsertDetails(DatabaseHelper oDatabaseHelper, SALSalesReturnLine sALSalesReturnLine, int salesReturnHeaderID) { bool ExecutionState = false; // Pass the value of '_qty' as parameter 'Qty' of the stored procedure. if (sALSalesReturnLine.Qty != null) { oDatabaseHelper.AddParameter("@Qty", sALSalesReturnLine.Qty); } else { oDatabaseHelper.AddParameter("@Qty", DBNull.Value); } // Pass the value of '_reason' as parameter 'Reason' of the stored procedure. if (sALSalesReturnLine.Reason != null) { oDatabaseHelper.AddParameter("@Reason", sALSalesReturnLine.Reason); } else { oDatabaseHelper.AddParameter("@Reason", DBNull.Value); } // Pass the value of '_originalSalesLineID' as parameter 'OriginalSalesLineID' of the stored procedure. if (sALSalesReturnLine.OriginalSalesLineID != null) { oDatabaseHelper.AddParameter("@OriginalSalesLineID", sALSalesReturnLine.OriginalSalesLineID); } else { oDatabaseHelper.AddParameter("@OriginalSalesLineID", DBNull.Value); } // Pass the value of '_batchID' as parameter 'BatchID' of the stored procedure. if (sALSalesReturnLine.BatchID != null) { oDatabaseHelper.AddParameter("@BatchID", sALSalesReturnLine.BatchID); } else { oDatabaseHelper.AddParameter("@BatchID", DBNull.Value); } // Pass the value of '_batchNumber' as parameter 'BatchNumber' of the stored procedure. if (sALSalesReturnLine.BatchNumber != null) { oDatabaseHelper.AddParameter("@BatchNumber", sALSalesReturnLine.BatchNumber); } else { oDatabaseHelper.AddParameter("@BatchNumber", DBNull.Value); } // Pass the value of '_expiryDate' as parameter 'ExpiryDate' of the stored procedure. if (sALSalesReturnLine.ExpiryDate != null) { oDatabaseHelper.AddParameter("@ExpiryDate", sALSalesReturnLine.ExpiryDate); } else { oDatabaseHelper.AddParameter("@ExpiryDate", DBNull.Value); } if (sALSalesReturnLine.StockTypeID != null) { oDatabaseHelper.AddParameter("@StockType", sALSalesReturnLine.StockTypeID); } else { oDatabaseHelper.AddParameter("@StockType", DBNull.Value); } oDatabaseHelper.AddParameter("@SalesReturnHeaderID", salesReturnHeaderID); oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("usp_SALSalesReturnLine_InsertCommit", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState); return(ExecutionState); }