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