///<summary> /// This method will update one new row into the database using the property Information /// </summary> /// /// <param name="pURPurchaseLine" type="PURPurchaseLine">This PURPurchaseLine will be updated in the database.</param> /// /// <returns>True if succeeded</returns> public bool Update(PURPurchaseLine pURPurchaseLine) { _pURPurchaseLine = POS.DataLayer.PURPurchaseLine.SelectOne(new POS.DataLayer.PURPurchaseLinePrimaryKey(pURPurchaseLine.PurchaseLineID)); _pURPurchaseLine.PurchaseHeaderID = pURPurchaseLine.PurchaseHeaderID; _pURPurchaseLine.ProductID = pURPurchaseLine.ProductID; _pURPurchaseLine.TotalQty = pURPurchaseLine.TotalQty; _pURPurchaseLine.BonusQty = pURPurchaseLine.BonusQty; _pURPurchaseLine.DiscountRatio = pURPurchaseLine.DiscountRatio; _pURPurchaseLine.DiscountAmount = pURPurchaseLine.DiscountAmount; _pURPurchaseLine.Unitprice = pURPurchaseLine.Unitprice; _pURPurchaseLine.CreatedDate = pURPurchaseLine.CreatedDate; _pURPurchaseLine.CreatedBy = pURPurchaseLine.CreatedBy; _pURPurchaseLine.UpdateDate = pURPurchaseLine.UpdateDate; _pURPurchaseLine.UpdatedBy = pURPurchaseLine.UpdatedBy; _pURPurchaseLine.IsDeleted = pURPurchaseLine.IsDeleted; _pURPurchaseLine.DeleteDate = pURPurchaseLine.DeleteDate; _pURPurchaseLine.DeletedBy = pURPurchaseLine.DeletedBy; return(_pURPurchaseLine.Update()); }
public PURPurchaseLineCollection SelectByHeaderID(int HeaderID) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper.AddParameter("@HeaderID", HeaderID); oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader rdr = oDatabaseHelper.ExecuteReader("usp_PURPurchaseLine_SelectByHeaderID", ref ExecutionState); PURPurchaseLineCollection lines = new PURPurchaseLineCollection(); while (rdr.Read()) { PURPurchaseLine obj = new PURPurchaseLine(); obj.PurchaseLineID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseLineID)); //obj.PurchaseHeaderID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseHeaderID)); obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.ProductID)); obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.TotalQty)); obj.BonusQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.BonusQty)); obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountRatio)); obj.IsAcceptBatch = rdr.GetBoolean(rdr.GetOrdinal("IsAcceptBatch")); //obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountAmount)); obj.Unitprice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.Unitprice)); if (rdr.GetOrdinal("PurchaseLineBatchID") != null && rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID")) != 0) { obj.PurchaseLineBatchID = rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID")); } if (rdr.GetOrdinal("BatchID") != null && rdr.GetInt32(rdr.GetOrdinal("BatchID")) != 0) { obj.BatchID = rdr.GetInt32(rdr.GetOrdinal("BatchID")); obj.BatchNumber = rdr.GetString(rdr.GetOrdinal("BatchNumber")); obj.ExpiryDate = rdr.GetDateTime(rdr.GetOrdinal("ExpiryDate")); } lines.Add(obj); } rdr.Close(); return(lines); }
internal static PURPurchaseLineCollection FillCollection(IDataReader rdr) { PURPurchaseLineCollection list = new PURPurchaseLineCollection(); while (rdr.Read()) { PURPurchaseLine obj = new PURPurchaseLine(); obj.PurchaseLineID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseLineID)); //obj.PurchaseHeaderID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseHeaderID)); obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.ProductID)); obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.TotalQty)); obj.BonusQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.BonusQty)); obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountRatio)); //obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountAmount)); obj.Unitprice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.Unitprice)); if (rdr.GetOrdinal("PurchaseLineBatchID") != null) { obj.PurchaseLineBatchID = rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID")); } if (rdr.GetOrdinal("BatchID") != null) { obj.BatchID = rdr.GetInt32(rdr.GetOrdinal("BatchID")); } if (rdr.GetOrdinal("BatchNumber") != null) { obj.BatchNumber = rdr.GetString(rdr.GetOrdinal("BatchNumber")); } if (rdr.GetOrdinal("ExpiryDate") != null) { obj.ExpiryDate = rdr.GetDateTime(rdr.GetOrdinal("ExpiryDate")); } list.Add(obj); } return(list); }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="PURPurchaseLinePrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class PURPurchaseLine</returns> public PURPurchaseLine SelectOne(PURPurchaseLinePrimaryKey pk) { _pURPurchaseLineWCF = new PURPurchaseLine(); _pURPurchaseLine = POS.DataLayer.PURPurchaseLineBase.SelectOne(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID)); _pURPurchaseLineWCF.PurchaseLineID = _pURPurchaseLine.PurchaseLineID; _pURPurchaseLineWCF.PurchaseHeaderID = _pURPurchaseLine.PurchaseHeaderID; _pURPurchaseLineWCF.ProductID = _pURPurchaseLine.ProductID; _pURPurchaseLineWCF.TotalQty = _pURPurchaseLine.TotalQty; _pURPurchaseLineWCF.BonusQty = _pURPurchaseLine.BonusQty; _pURPurchaseLineWCF.DiscountRatio = _pURPurchaseLine.DiscountRatio; _pURPurchaseLineWCF.DiscountAmount = _pURPurchaseLine.DiscountAmount; _pURPurchaseLineWCF.Unitprice = _pURPurchaseLine.Unitprice; _pURPurchaseLineWCF.CreatedDate = _pURPurchaseLine.CreatedDate; _pURPurchaseLineWCF.CreatedBy = _pURPurchaseLine.CreatedBy; _pURPurchaseLineWCF.UpdateDate = _pURPurchaseLine.UpdateDate; _pURPurchaseLineWCF.UpdatedBy = _pURPurchaseLine.UpdatedBy; _pURPurchaseLineWCF.IsDeleted = _pURPurchaseLine.IsDeleted; _pURPurchaseLineWCF.DeleteDate = _pURPurchaseLine.DeleteDate; _pURPurchaseLineWCF.DeletedBy = _pURPurchaseLine.DeletedBy; return _pURPurchaseLineWCF; }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="PURPurchaseLinePrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class PURPurchaseLine</returns> public PURPurchaseLine SelectOne(PURPurchaseLinePrimaryKey pk) { _pURPurchaseLineWCF = new PURPurchaseLine(); _pURPurchaseLine = POS.DataLayer.PURPurchaseLineBase.SelectOne(new POS.DataLayer.PURPurchaseLinePrimaryKey(pk.PurchaseLineID)); _pURPurchaseLineWCF.PurchaseLineID = _pURPurchaseLine.PurchaseLineID; _pURPurchaseLineWCF.PurchaseHeaderID = _pURPurchaseLine.PurchaseHeaderID; _pURPurchaseLineWCF.ProductID = _pURPurchaseLine.ProductID; _pURPurchaseLineWCF.TotalQty = _pURPurchaseLine.TotalQty; _pURPurchaseLineWCF.BonusQty = _pURPurchaseLine.BonusQty; _pURPurchaseLineWCF.DiscountRatio = _pURPurchaseLine.DiscountRatio; _pURPurchaseLineWCF.DiscountAmount = _pURPurchaseLine.DiscountAmount; _pURPurchaseLineWCF.Unitprice = _pURPurchaseLine.Unitprice; _pURPurchaseLineWCF.CreatedDate = _pURPurchaseLine.CreatedDate; _pURPurchaseLineWCF.CreatedBy = _pURPurchaseLine.CreatedBy; _pURPurchaseLineWCF.UpdateDate = _pURPurchaseLine.UpdateDate; _pURPurchaseLineWCF.UpdatedBy = _pURPurchaseLine.UpdatedBy; _pURPurchaseLineWCF.IsDeleted = _pURPurchaseLine.IsDeleted; _pURPurchaseLineWCF.DeleteDate = _pURPurchaseLine.DeleteDate; _pURPurchaseLineWCF.DeletedBy = _pURPurchaseLine.DeletedBy; return(_pURPurchaseLineWCF); }
private bool InsertDetails(DatabaseHelper oDatabaseHelper, PURPurchaseLine sALPurchaseLine, int salesHeaderID) { bool ExecutionState = false; // Pass the value of '_salesHeaderID' as parameter 'PurchaseHeaderID' of the stored procedure. if (salesHeaderID != null) { oDatabaseHelper.AddParameter("@PurchaseHeaderID", salesHeaderID); } else { oDatabaseHelper.AddParameter("@PurchaseHeaderID", DBNull.Value); } // Pass the value of '_productID' as parameter 'ProductID' of the stored procedure. if (sALPurchaseLine.ProductID != null) { oDatabaseHelper.AddParameter("@ProductID", sALPurchaseLine.ProductID); } else { oDatabaseHelper.AddParameter("@ProductID", DBNull.Value); } // Pass the value of '_totalQty' as parameter 'TotalQty' of the stored procedure. if (sALPurchaseLine.TotalQty != null) { oDatabaseHelper.AddParameter("@BatchQty", sALPurchaseLine.TotalQty); } else { oDatabaseHelper.AddParameter("@BatchQty", DBNull.Value); } // Pass the value of '_totalBonus' as parameter 'TotalBonus' of the stored procedure. if (sALPurchaseLine.BonusQty != null) { oDatabaseHelper.AddParameter("@BonusQty", sALPurchaseLine.BonusQty); } else { oDatabaseHelper.AddParameter("@BonusQty", DBNull.Value); } // Pass the value of '_discountAmount' as parameter 'DiscountAmount' of the stored procedure. if (sALPurchaseLine.DiscountAmount != null) { oDatabaseHelper.AddParameter("@DiscountAmount", sALPurchaseLine.DiscountAmount); } else { oDatabaseHelper.AddParameter("@DiscountAmount", DBNull.Value); } // Pass the value of '_discountRatio' as parameter 'DiscountRatio' of the stored procedure. if (sALPurchaseLine.DiscountRatio != null) { oDatabaseHelper.AddParameter("@DiscountRatio", sALPurchaseLine.DiscountRatio); } else { oDatabaseHelper.AddParameter("@DiscountRatio", DBNull.Value); } // Pass the value of '_unitPrice' as parameter 'UnitPrice' of the stored procedure. if (sALPurchaseLine.Unitprice != null) { oDatabaseHelper.AddParameter("@UnitPrice", sALPurchaseLine.Unitprice); } else { oDatabaseHelper.AddParameter("@UnitPrice", DBNull.Value); } if (sALPurchaseLine.BatchNumber != null || sALPurchaseLine.BatchNumber != "") { oDatabaseHelper.AddParameter("@BatchNumber", sALPurchaseLine.BatchNumber); } if (sALPurchaseLine.ExpiryDate != null || sALPurchaseLine.ExpiryDate != null) { oDatabaseHelper.AddParameter("@ExpiryDate", sALPurchaseLine.ExpiryDate); } // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (sALPurchaseLine.CreatedBy != null) { oDatabaseHelper.AddParameter("@CreatedBy", sALPurchaseLine.CreatedBy); } else { oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); } // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. if (sALPurchaseLine.CreatedDate != null) { oDatabaseHelper.AddParameter("@CreateDate", sALPurchaseLine.CreatedDate); } else { oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value); } // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); try { oDatabaseHelper.ExecuteScalar("usp_PURPurchaseLine_SaveLine", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState); } catch (Exception ex) { } return(ExecutionState); }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="PURPurchaseLinePrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class PURPurchaseLine</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:18 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static PURPurchaseLine SelectOne(PURPurchaseLinePrimaryKey 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_PURPurchaseLine_SelectbyPrimaryKey", ref ExecutionState); if (dr.Read()) { PURPurchaseLine obj=new PURPurchaseLine(); 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 PURPurchaseLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:18 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static PURPurchaseLineCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper) { PURPurchaseLineCollection list = new PURPurchaseLineCollection(); if (rdr.Read()) { PURPurchaseLine obj = new PURPurchaseLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new PURPurchaseLine(); 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 PURPurchaseLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:18 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static PURPurchaseLineCollection PopulateObjectsFromReader(IDataReader rdr) { PURPurchaseLineCollection list = new PURPurchaseLineCollection(); while (rdr.Read()) { PURPurchaseLine obj = new PURPurchaseLine(); 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="pURPurchaseLine" type="PURPurchaseLine">This PURPurchaseLine will be updated in the database.</param> /// /// <returns>True if succeeded</returns> public bool Update(PURPurchaseLine pURPurchaseLine) { _pURPurchaseLine=POS.DataLayer.PURPurchaseLine.SelectOne(new POS.DataLayer.PURPurchaseLinePrimaryKey(pURPurchaseLine.PurchaseLineID)); _pURPurchaseLine.PurchaseHeaderID=pURPurchaseLine.PurchaseHeaderID; _pURPurchaseLine.ProductID=pURPurchaseLine.ProductID; _pURPurchaseLine.TotalQty=pURPurchaseLine.TotalQty; _pURPurchaseLine.BonusQty=pURPurchaseLine.BonusQty; _pURPurchaseLine.DiscountRatio=pURPurchaseLine.DiscountRatio; _pURPurchaseLine.DiscountAmount=pURPurchaseLine.DiscountAmount; _pURPurchaseLine.Unitprice=pURPurchaseLine.Unitprice; _pURPurchaseLine.CreatedDate=pURPurchaseLine.CreatedDate; _pURPurchaseLine.CreatedBy=pURPurchaseLine.CreatedBy; _pURPurchaseLine.UpdateDate=pURPurchaseLine.UpdateDate; _pURPurchaseLine.UpdatedBy=pURPurchaseLine.UpdatedBy; _pURPurchaseLine.IsDeleted=pURPurchaseLine.IsDeleted; _pURPurchaseLine.DeleteDate=pURPurchaseLine.DeleteDate; _pURPurchaseLine.DeletedBy=pURPurchaseLine.DeletedBy; return _pURPurchaseLine.Update(); }
internal static PURPurchaseLineCollection FillCollection( IDataReader rdr) { PURPurchaseLineCollection list = new PURPurchaseLineCollection(); while (rdr.Read()) { PURPurchaseLine obj = new PURPurchaseLine(); obj.PurchaseLineID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseLineID)); //obj.PurchaseHeaderID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseHeaderID)); obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.ProductID)); obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.TotalQty)); obj.BonusQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.BonusQty)); obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountRatio)); //obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountAmount)); obj.Unitprice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.Unitprice)); if (rdr.GetOrdinal("PurchaseLineBatchID") != null) { obj.PurchaseLineBatchID = rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID")); } if (rdr.GetOrdinal("BatchID") != null) { obj.BatchID = rdr.GetInt32(rdr.GetOrdinal("BatchID")); } if (rdr.GetOrdinal("BatchNumber") != null) { obj.BatchNumber = rdr.GetString(rdr.GetOrdinal("BatchNumber")); } if (rdr.GetOrdinal("ExpiryDate") != null) { obj.ExpiryDate = rdr.GetDateTime(rdr.GetOrdinal("ExpiryDate")); } list.Add(obj); } return list; }
private bool InsertDetails(DatabaseHelper oDatabaseHelper, PURPurchaseLine sALPurchaseLine, int salesHeaderID) { bool ExecutionState = false; // Pass the value of '_salesHeaderID' as parameter 'PurchaseHeaderID' of the stored procedure. if (salesHeaderID != null) oDatabaseHelper.AddParameter("@PurchaseHeaderID", salesHeaderID); else oDatabaseHelper.AddParameter("@PurchaseHeaderID", DBNull.Value); // Pass the value of '_productID' as parameter 'ProductID' of the stored procedure. if (sALPurchaseLine.ProductID != null) oDatabaseHelper.AddParameter("@ProductID", sALPurchaseLine.ProductID); else oDatabaseHelper.AddParameter("@ProductID", DBNull.Value); // Pass the value of '_totalQty' as parameter 'TotalQty' of the stored procedure. if (sALPurchaseLine.TotalQty != null) oDatabaseHelper.AddParameter("@BatchQty", sALPurchaseLine.TotalQty); else oDatabaseHelper.AddParameter("@BatchQty", DBNull.Value); // Pass the value of '_totalBonus' as parameter 'TotalBonus' of the stored procedure. if (sALPurchaseLine.BonusQty != null) oDatabaseHelper.AddParameter("@BonusQty", sALPurchaseLine.BonusQty); else oDatabaseHelper.AddParameter("@BonusQty", DBNull.Value); // Pass the value of '_discountAmount' as parameter 'DiscountAmount' of the stored procedure. if (sALPurchaseLine.DiscountAmount != null) oDatabaseHelper.AddParameter("@DiscountAmount", sALPurchaseLine.DiscountAmount); else oDatabaseHelper.AddParameter("@DiscountAmount", DBNull.Value); // Pass the value of '_discountRatio' as parameter 'DiscountRatio' of the stored procedure. if (sALPurchaseLine.DiscountRatio != null) oDatabaseHelper.AddParameter("@DiscountRatio", sALPurchaseLine.DiscountRatio); else oDatabaseHelper.AddParameter("@DiscountRatio", DBNull.Value); // Pass the value of '_unitPrice' as parameter 'UnitPrice' of the stored procedure. if (sALPurchaseLine.Unitprice != null) oDatabaseHelper.AddParameter("@UnitPrice", sALPurchaseLine.Unitprice); else oDatabaseHelper.AddParameter("@UnitPrice", DBNull.Value); if (sALPurchaseLine.BatchNumber != null || sALPurchaseLine.BatchNumber !="") oDatabaseHelper .AddParameter ("@BatchNumber",sALPurchaseLine.BatchNumber); if (sALPurchaseLine.ExpiryDate != null || sALPurchaseLine.ExpiryDate != null ) oDatabaseHelper.AddParameter("@ExpiryDate", sALPurchaseLine.ExpiryDate); // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure. if (sALPurchaseLine.CreatedBy != null) oDatabaseHelper.AddParameter("@CreatedBy", sALPurchaseLine.CreatedBy); else oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value); // Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure. if (sALPurchaseLine.CreatedDate != null) oDatabaseHelper.AddParameter("@CreateDate", sALPurchaseLine.CreatedDate); else oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value); // The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); try { oDatabaseHelper.ExecuteScalar("usp_PURPurchaseLine_SaveLine", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState); } catch (Exception ex) { } return ExecutionState; }
public PURPurchaseLineCollection SelectByHeaderID(int HeaderID) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper.AddParameter("@HeaderID", HeaderID); oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader rdr = oDatabaseHelper.ExecuteReader("usp_PURPurchaseLine_SelectByHeaderID", ref ExecutionState); PURPurchaseLineCollection lines = new PURPurchaseLineCollection(); while(rdr.Read()) { PURPurchaseLine obj = new PURPurchaseLine(); obj.PurchaseLineID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseLineID)); //obj.PurchaseHeaderID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseHeaderID)); obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.ProductID)); obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.TotalQty)); obj.BonusQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.BonusQty)); obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountRatio)); obj.IsAcceptBatch = rdr.GetBoolean(rdr.GetOrdinal("IsAcceptBatch")); //obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountAmount)); obj.Unitprice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.Unitprice)); if (rdr.GetOrdinal("PurchaseLineBatchID") != null && rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID")) !=0) obj.PurchaseLineBatchID = rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID")); if (rdr.GetOrdinal("BatchID") != null && rdr.GetInt32(rdr.GetOrdinal("BatchID")) != 0) { obj.BatchID = rdr.GetInt32(rdr.GetOrdinal("BatchID")); obj.BatchNumber = rdr.GetString(rdr.GetOrdinal("BatchNumber")); obj.ExpiryDate = rdr.GetDateTime(rdr.GetOrdinal("ExpiryDate")); } lines.Add(obj); } rdr.Close(); return lines; }