/// <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="INVInventoryPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class INVInventory</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 5/3/2015 10:23:04 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public static INVInventory SelectOneWithPURPurchaseHeaderUsingInventoryID(INVInventoryPrimaryKey pk)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
INVInventory 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]);
}
// 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_INVInventory_SelectOneWithPURPurchaseHeaderUsingInventoryID", ref ExecutionState);
if (dr.Read())
{
obj = new INVInventory();
PopulateObjectFromReader(obj, dr);
dr.NextResult();
//Get the child records.
obj.PURPurchaseHeaderCollectionUsingInventoryID = PURPurchaseHeader.PopulateObjectsFromReader(dr);
}
dr.Close();
oDatabaseHelper.Dispose();
return(obj);
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="PURPurchaseHeaderPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class PURPurchaseHeader</returns>
public PURPurchaseHeader SelectOne(PURPurchaseHeaderPrimaryKey pk)
{
_pURPurchaseHeaderWCF = new PURPurchaseHeader();
_pURPurchaseHeader = POS.DataLayer.PURPurchaseHeaderBase.SelectOne(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pk.PurcaseHeaderID));
_pURPurchaseHeaderWCF.PurcaseHeaderID = _pURPurchaseHeader.PurcaseHeaderID;
_pURPurchaseHeaderWCF.PurchaseDate = _pURPurchaseHeader.PurchaseDate;
_pURPurchaseHeaderWCF.PaymentTypeID = _pURPurchaseHeader.PaymentTypeID;
_pURPurchaseHeaderWCF.SupplierID = _pURPurchaseHeader.SupplierID;
_pURPurchaseHeaderWCF.InvoiceNumber = _pURPurchaseHeader.InvoiceNumber;
_pURPurchaseHeaderWCF.CreateDate = _pURPurchaseHeader.CreateDate;
_pURPurchaseHeaderWCF.CreatedBy = _pURPurchaseHeader.CreatedBy;
_pURPurchaseHeaderWCF.updateDate = _pURPurchaseHeader.updateDate;
_pURPurchaseHeaderWCF.UpdatedBy = _pURPurchaseHeader.UpdatedBy;
_pURPurchaseHeaderWCF.IsDeleted = _pURPurchaseHeader.IsDeleted;
_pURPurchaseHeaderWCF.DeleteDate = _pURPurchaseHeader.DeleteDate;
_pURPurchaseHeaderWCF.TotalPrice = _pURPurchaseHeader.TotalPrice;
_pURPurchaseHeaderWCF.ServicePrice = _pURPurchaseHeader.ServicePrice;
_pURPurchaseHeaderWCF.PaidAmount = _pURPurchaseHeader.PaidAmount;
_pURPurchaseHeaderWCF.IsClosed = _pURPurchaseHeader.IsClosed;
_pURPurchaseHeaderWCF.IsVoid = _pURPurchaseHeader.IsVoid;
_pURPurchaseHeaderWCF.IsPrinted = _pURPurchaseHeader.IsPrinted;
_pURPurchaseHeaderWCF.RefuseReasonID = _pURPurchaseHeader.RefuseReasonID;
_pURPurchaseHeaderWCF.TotalDiscountAmount = _pURPurchaseHeader.TotalDiscountAmount;
_pURPurchaseHeaderWCF.TotalDiscountRatio = _pURPurchaseHeader.TotalDiscountRatio;
_pURPurchaseHeaderWCF.TaxTypeID = _pURPurchaseHeader.TaxTypeID;
_pURPurchaseHeaderWCF.RemainingAmount = _pURPurchaseHeader.RemainingAmount;
_pURPurchaseHeaderWCF.LastDayToPay = _pURPurchaseHeader.LastDayToPay;
_pURPurchaseHeaderWCF.DeletedBy = _pURPurchaseHeader.DeletedBy;
_pURPurchaseHeaderWCF.Notes = _pURPurchaseHeader.Notes;
_pURPurchaseHeaderWCF.InventoryID = _pURPurchaseHeader.InventoryID;
_pURPurchaseHeaderWCF.InvoiceDate = _pURPurchaseHeader.InvoiceDate;
return(_pURPurchaseHeaderWCF);
}
public bool SaveAccountUpdates(PURPurchaseHeader purchaseHeader, BDSupplierAccount supplierAccount)
{
oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
oDatabaseHelper.BeginTransaction();
ExecutionState = UpdateSupplierAccount(oDatabaseHelper, supplierAccount, ExecutionState);
if (!UpdatePurchaseHeader(oDatabaseHelper, purchaseHeader))
{
ExecutionState = false;
}
else
{
ExecutionState = true;
}
if (ExecutionState)
{
oDatabaseHelper.CommitTransaction();
}
else
{
oDatabaseHelper.RollbackTransaction();
}
oDatabaseHelper.Dispose();
return(ExecutionState);
}
///<summary>
/// This method will update one new row into the database using the property Information
/// </summary>
///
/// <param name="pURPurchaseHeader" type="PURPurchaseHeader">This PURPurchaseHeader will be updated in the database.</param>
///
/// <returns>True if succeeded</returns>
public bool Update(PURPurchaseHeader pURPurchaseHeader)
{
_pURPurchaseHeader = POS.DataLayer.PURPurchaseHeader.SelectOne(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pURPurchaseHeader.PurcaseHeaderID));
_pURPurchaseHeader.PurchaseDate = pURPurchaseHeader.PurchaseDate;
_pURPurchaseHeader.PaymentTypeID = pURPurchaseHeader.PaymentTypeID;
_pURPurchaseHeader.SupplierID = pURPurchaseHeader.SupplierID;
_pURPurchaseHeader.InvoiceNumber = pURPurchaseHeader.InvoiceNumber;
_pURPurchaseHeader.CreateDate = pURPurchaseHeader.CreateDate;
_pURPurchaseHeader.CreatedBy = pURPurchaseHeader.CreatedBy;
_pURPurchaseHeader.updateDate = pURPurchaseHeader.updateDate;
_pURPurchaseHeader.UpdatedBy = pURPurchaseHeader.UpdatedBy;
_pURPurchaseHeader.IsDeleted = pURPurchaseHeader.IsDeleted;
_pURPurchaseHeader.DeleteDate = pURPurchaseHeader.DeleteDate;
_pURPurchaseHeader.TotalPrice = pURPurchaseHeader.TotalPrice;
_pURPurchaseHeader.ServicePrice = pURPurchaseHeader.ServicePrice;
_pURPurchaseHeader.PaidAmount = pURPurchaseHeader.PaidAmount;
_pURPurchaseHeader.IsClosed = pURPurchaseHeader.IsClosed;
_pURPurchaseHeader.IsVoid = pURPurchaseHeader.IsVoid;
_pURPurchaseHeader.IsPrinted = pURPurchaseHeader.IsPrinted;
_pURPurchaseHeader.RefuseReasonID = pURPurchaseHeader.RefuseReasonID;
_pURPurchaseHeader.TotalDiscountAmount = pURPurchaseHeader.TotalDiscountAmount;
_pURPurchaseHeader.TotalDiscountRatio = pURPurchaseHeader.TotalDiscountRatio;
_pURPurchaseHeader.TaxTypeID = pURPurchaseHeader.TaxTypeID;
_pURPurchaseHeader.RemainingAmount = pURPurchaseHeader.RemainingAmount;
_pURPurchaseHeader.LastDayToPay = pURPurchaseHeader.LastDayToPay;
_pURPurchaseHeader.DeletedBy = pURPurchaseHeader.DeletedBy;
_pURPurchaseHeader.Notes = pURPurchaseHeader.Notes;
_pURPurchaseHeader.InventoryID = pURPurchaseHeader.InventoryID;
_pURPurchaseHeader.InvoiceDate = pURPurchaseHeader.InvoiceDate;
return(_pURPurchaseHeader.Update());
}
public int SaveTransaction(PURPurchaseHeader pURPurchaseHeader, PURPurchaseLineCollection sALPurchaseLineCollection)
{
oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
int salesHeaderID;
oDatabaseHelper.BeginTransaction();
if (InsertHeader(oDatabaseHelper, pURPurchaseHeader, out salesHeaderID))
{
foreach (PURPurchaseLine sALPurchaseLine in sALPurchaseLineCollection)
{
if (!InsertDetails(oDatabaseHelper, sALPurchaseLine, salesHeaderID))
{
ExecutionState = false;
break;
}
else
{
ExecutionState = true;
}
}
if (ExecutionState)
{
oDatabaseHelper.CommitTransaction();
}
else
{
oDatabaseHelper.RollbackTransaction();
}
}
return(salesHeaderID);
}
public bool SaveAccountUpdates(PURPurchaseHeader purchaseHeader, BDSupplierAccount supplierAccount)
{
oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
oDatabaseHelper.BeginTransaction();
ExecutionState = UpdateSupplierAccount(oDatabaseHelper, supplierAccount, ExecutionState);
if (!UpdatePurchaseHeader(oDatabaseHelper, purchaseHeader))
{
ExecutionState = false;
}
else
ExecutionState = true;
if (ExecutionState)
oDatabaseHelper.CommitTransaction();
else
oDatabaseHelper.RollbackTransaction();
oDatabaseHelper.Dispose();
return ExecutionState;
}
public bool UpdateTransaction(PURPurchaseHeader pURPurchaseHeader, PURPurchaseLineCollection sALPurchaseLineCollection)
{
oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
oDatabaseHelper.BeginTransaction();
if (UpdateHeader(oDatabaseHelper, pURPurchaseHeader))
{
if (DeleteDetails(oDatabaseHelper, (int)pURPurchaseHeader.PurcaseHeaderID, (int)pURPurchaseHeader.CreatedBy))
{
foreach (PURPurchaseLine sALPurchaseLine in sALPurchaseLineCollection)
{
if (!InsertDetails(oDatabaseHelper, sALPurchaseLine, (int)pURPurchaseHeader.PurcaseHeaderID))
{
ExecutionState = false;
break;
}
else
{
ExecutionState = true;
}
}
if (ExecutionState)
{
oDatabaseHelper.CommitTransaction();
}
else
{
oDatabaseHelper.RollbackTransaction();
}
}
else
{
ExecutionState = false;
}
}
else
{
ExecutionState = false;
}
return(ExecutionState);
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="PURPurchaseHeaderPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class PURPurchaseHeader</returns>
public PURPurchaseHeader SelectOne(PURPurchaseHeaderPrimaryKey pk)
{
_pURPurchaseHeaderWCF = new PURPurchaseHeader();
_pURPurchaseHeader = POS.DataLayer.PURPurchaseHeaderBase.SelectOne(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pk.PurcaseHeaderID));
_pURPurchaseHeaderWCF.PurcaseHeaderID = _pURPurchaseHeader.PurcaseHeaderID;
_pURPurchaseHeaderWCF.PurchaseDate = _pURPurchaseHeader.PurchaseDate;
_pURPurchaseHeaderWCF.PaymentTypeID = _pURPurchaseHeader.PaymentTypeID;
_pURPurchaseHeaderWCF.SupplierID = _pURPurchaseHeader.SupplierID;
_pURPurchaseHeaderWCF.InvoiceNumber = _pURPurchaseHeader.InvoiceNumber;
_pURPurchaseHeaderWCF.CreateDate = _pURPurchaseHeader.CreateDate;
_pURPurchaseHeaderWCF.CreatedBy = _pURPurchaseHeader.CreatedBy;
_pURPurchaseHeaderWCF.updateDate = _pURPurchaseHeader.updateDate;
_pURPurchaseHeaderWCF.UpdatedBy = _pURPurchaseHeader.UpdatedBy;
_pURPurchaseHeaderWCF.IsDeleted = _pURPurchaseHeader.IsDeleted;
_pURPurchaseHeaderWCF.DeleteDate = _pURPurchaseHeader.DeleteDate;
_pURPurchaseHeaderWCF.TotalPrice = _pURPurchaseHeader.TotalPrice;
_pURPurchaseHeaderWCF.ServicePrice = _pURPurchaseHeader.ServicePrice;
_pURPurchaseHeaderWCF.PaidAmount = _pURPurchaseHeader.PaidAmount;
_pURPurchaseHeaderWCF.IsClosed = _pURPurchaseHeader.IsClosed;
_pURPurchaseHeaderWCF.IsVoid = _pURPurchaseHeader.IsVoid;
_pURPurchaseHeaderWCF.IsPrinted = _pURPurchaseHeader.IsPrinted;
_pURPurchaseHeaderWCF.RefuseReasonID = _pURPurchaseHeader.RefuseReasonID;
_pURPurchaseHeaderWCF.TotalDiscountAmount = _pURPurchaseHeader.TotalDiscountAmount;
_pURPurchaseHeaderWCF.TotalDiscountRatio = _pURPurchaseHeader.TotalDiscountRatio;
_pURPurchaseHeaderWCF.TaxTypeID = _pURPurchaseHeader.TaxTypeID;
_pURPurchaseHeaderWCF.RemainingAmount = _pURPurchaseHeader.RemainingAmount;
_pURPurchaseHeaderWCF.LastDayToPay = _pURPurchaseHeader.LastDayToPay;
_pURPurchaseHeaderWCF.DeletedBy = _pURPurchaseHeader.DeletedBy;
_pURPurchaseHeaderWCF.Notes = _pURPurchaseHeader.Notes;
_pURPurchaseHeaderWCF.InventoryID = _pURPurchaseHeader.InventoryID;
_pURPurchaseHeaderWCF.InvoiceDate = _pURPurchaseHeader.InvoiceDate;
_pURPurchaseHeaderWCF.ChequeNumber = _pURPurchaseHeader.ChequeNumber;
return _pURPurchaseHeaderWCF;
}
/// <summary>
/// This method will insert one new row into the database using the property Information
/// </summary>
///
/// <param name="pURPurchaseHeader" type="PURPurchaseHeader">This PURPurchaseHeader will be inserted in the database.</param>
///
/// <returns>True if succeeded</returns>
public bool Insert(PURPurchaseHeader pURPurchaseHeader)
{
_pURPurchaseHeader = new POS.DataLayer.PURPurchaseHeader();
_pURPurchaseHeader.PurcaseHeaderID=pURPurchaseHeader.PurcaseHeaderID;
_pURPurchaseHeader.PurchaseDate=pURPurchaseHeader.PurchaseDate;
_pURPurchaseHeader.PaymentTypeID=pURPurchaseHeader.PaymentTypeID;
_pURPurchaseHeader.SupplierID=pURPurchaseHeader.SupplierID;
_pURPurchaseHeader.InvoiceNumber=pURPurchaseHeader.InvoiceNumber;
_pURPurchaseHeader.CreateDate=pURPurchaseHeader.CreateDate;
_pURPurchaseHeader.CreatedBy=pURPurchaseHeader.CreatedBy;
_pURPurchaseHeader.updateDate=pURPurchaseHeader.updateDate;
_pURPurchaseHeader.UpdatedBy=pURPurchaseHeader.UpdatedBy;
_pURPurchaseHeader.IsDeleted=pURPurchaseHeader.IsDeleted;
_pURPurchaseHeader.DeleteDate=pURPurchaseHeader.DeleteDate;
_pURPurchaseHeader.TotalPrice=pURPurchaseHeader.TotalPrice;
_pURPurchaseHeader.ServicePrice=pURPurchaseHeader.ServicePrice;
_pURPurchaseHeader.PaidAmount=pURPurchaseHeader.PaidAmount;
_pURPurchaseHeader.IsClosed=pURPurchaseHeader.IsClosed;
_pURPurchaseHeader.IsVoid=pURPurchaseHeader.IsVoid;
_pURPurchaseHeader.IsPrinted=pURPurchaseHeader.IsPrinted;
_pURPurchaseHeader.RefuseReasonID=pURPurchaseHeader.RefuseReasonID;
_pURPurchaseHeader.TotalDiscountAmount=pURPurchaseHeader.TotalDiscountAmount;
_pURPurchaseHeader.TotalDiscountRatio=pURPurchaseHeader.TotalDiscountRatio;
_pURPurchaseHeader.TaxTypeID=pURPurchaseHeader.TaxTypeID;
_pURPurchaseHeader.RemainingAmount=pURPurchaseHeader.RemainingAmount;
_pURPurchaseHeader.LastDayToPay=pURPurchaseHeader.LastDayToPay;
_pURPurchaseHeader.DeletedBy=pURPurchaseHeader.DeletedBy;
_pURPurchaseHeader.Notes=pURPurchaseHeader.Notes;
_pURPurchaseHeader.InventoryID=pURPurchaseHeader.InventoryID;
_pURPurchaseHeader.InvoiceDate=pURPurchaseHeader.InvoiceDate;
_pURPurchaseHeader.ChequeNumber=pURPurchaseHeader.ChequeNumber;
return _pURPurchaseHeader.Insert();
}
private static PURPurchaseHeaderCollection PopulateFromReader(IDataReader rdr)
{
PURPurchaseHeaderCollection pURPurchaseHeaderCollection = new PURPurchaseHeaderCollection();
while (rdr.Read())
{
PURPurchaseHeader obj = new PURPurchaseHeader();
obj.PurcaseHeaderID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.PurcaseHeaderID));
obj.PurchaseDate = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.PurchaseDate));
obj.SupplierID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.SupplierID));
if (!rdr.IsDBNull(rdr.GetOrdinal("SupplierName")))
{
obj.SupplierName = rdr.GetString(rdr.GetOrdinal("SupplierName"));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.InvoiceNumber)))
{
obj.InvoiceNumber = rdr.GetString(rdr.GetOrdinal(PURPurchaseHeaderFields.InvoiceNumber));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.InvoiceDate)))
{
obj.InvoiceDate = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.InvoiceDate));
}
// if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.SellerID)))
// {
// obj.SellerID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.SellerID));
// }
//if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.PaymentTypeID)))
//{
// obj.PaymentTypeID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.PaymentTypeID));
//}
obj.TotalPrice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseHeaderFields.TotalPrice));
obj.PaidAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseHeaderFields.PaidAmount));
obj.RemainingAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseHeaderFields.RemainingAmount));
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.LastDayToPay)))
{
obj.LastDayToPay = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.LastDayToPay));
}
obj.TotalDiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseHeaderFields.TotalDiscountAmount));
obj.TotalDiscountRatio = rdr.GetDouble(rdr.GetOrdinal(PURPurchaseHeaderFields.TotalDiscountRatio));
obj.IsClosed = rdr.GetBoolean(rdr.GetOrdinal(PURPurchaseHeaderFields.IsClosed));
obj.IsVoid = rdr.GetBoolean(rdr.GetOrdinal(PURPurchaseHeaderFields.IsVoid));
obj.IsPrinted = rdr.GetBoolean(rdr.GetOrdinal(PURPurchaseHeaderFields.IsPrinted));
obj.ServicePrice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseHeaderFields.ServicePrice));
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.TaxTypeID)))
{
obj.TaxTypeID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.TaxTypeID));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.RefuseReasonID)))
{
obj.RefuseReasonID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.RefuseReasonID));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.CreatedBy)))
{
obj.CreatedBy = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.CreatedBy));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.CreateDate)))
{
obj.CreateDate = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.CreateDate));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.UpdatedBy)))
{
obj.UpdatedBy = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.UpdatedBy));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.updateDate)))
{
obj.updateDate = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.updateDate));
}
obj.IsDeleted = rdr.GetBoolean(rdr.GetOrdinal(PURPurchaseHeaderFields.IsDeleted));
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.DeletedBy)))
{
obj.DeletedBy = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.DeletedBy));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.DeleteDate)))
{
obj.DeleteDate = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.DeleteDate));
}
pURPurchaseHeaderCollection.Add(obj);
}
return(pURPurchaseHeaderCollection);
}
private bool UpdatePurchaseHeader(DatabaseHelper oDatabaseHelper, PURPurchaseHeader purchaseHeader)
{
bool ExecutionState = false;
// Pass the value of '_salesHeaderID' as parameter 'PurchaseHeaderID' of the stored procedure.
oDatabaseHelper.AddParameter("@PurcaseHeaderID", purchaseHeader.PurcaseHeaderID);
oDatabaseHelper.AddParameter("@PurchaseDate", purchaseHeader.PurchaseDate);
// Pass the value of '_customerID' as parameter 'SupplierID' of the stored procedure.
if (purchaseHeader.SupplierID != null)
oDatabaseHelper.AddParameter("@SupplierID", purchaseHeader.SupplierID);
else
oDatabaseHelper.AddParameter("@SupplierID", DBNull.Value);
// Pass the value of '_invoiceNumber' as parameter 'InvoiceNumber' of the stored procedure.
oDatabaseHelper.AddParameter("@InvoiceNumber", purchaseHeader.InvoiceNumber);
// Pass the value of '_invoiceDate' as parameter 'Notes' of the stored procedure.
if (purchaseHeader.Notes != null)
oDatabaseHelper.AddParameter("@Notes", purchaseHeader.Notes);
else
oDatabaseHelper.AddParameter("@Notes", DBNull.Value);
// Pass the value of '_invoiceDate' as parameter 'InventoryID' of the stored procedure.
if (purchaseHeader.InventoryID != null)
oDatabaseHelper.AddParameter("@InventoryID", purchaseHeader.InventoryID);
else
oDatabaseHelper.AddParameter("@InventoryID", DBNull.Value);
// Pass the value of '_invoiceDate' as parameter 'InvoiceDate' of the stored procedure.
if (purchaseHeader.InvoiceDate != null)
oDatabaseHelper.AddParameter("@InvoiceDate", purchaseHeader.InvoiceDate);
else
oDatabaseHelper.AddParameter("@InvoiceDate", DBNull.Value);
// Pass the value of '_paymentTypeID' as parameter 'PaymentTypeID' of the stored procedure.
if (purchaseHeader.PaymentTypeID != null)
oDatabaseHelper.AddParameter("@PaymentTypeID", purchaseHeader.PaymentTypeID);
else
oDatabaseHelper.AddParameter("@PaymentTypeID", DBNull.Value);
// Pass the value of '_totalPrice' as parameter 'TotalPrice' of the stored procedure.
if (purchaseHeader.TotalPrice != null)
oDatabaseHelper.AddParameter("@TotalPrice", purchaseHeader.TotalPrice);
else
oDatabaseHelper.AddParameter("@TotalPrice", DBNull.Value);
// Pass the value of '_paidAmount' as parameter 'PaidAmount' of the stored procedure.
if (purchaseHeader.PaidAmount != null)
oDatabaseHelper.AddParameter("@PaidAmount", purchaseHeader.PaidAmount);
else
oDatabaseHelper.AddParameter("@PaidAmount", DBNull.Value);
// Pass the value of '_remainingAmount' as parameter 'RemainingAmount' of the stored procedure.
if (purchaseHeader.RemainingAmount != null)
oDatabaseHelper.AddParameter("@RemainingAmount", purchaseHeader.RemainingAmount);
else
oDatabaseHelper.AddParameter("@RemainingAmount", DBNull.Value);
// Pass the value of '_lastDayToPay' as parameter 'LastDayToPay' of the stored procedure.
if (purchaseHeader.LastDayToPay != null)
oDatabaseHelper.AddParameter("@LastDayToPay", purchaseHeader.LastDayToPay);
else
oDatabaseHelper.AddParameter("@LastDayToPay", DBNull.Value);
// Pass the value of '_totalDiscountAmount' as parameter 'TotalDiscountAmount' of the stored procedure.
if (purchaseHeader.TotalDiscountAmount != null)
oDatabaseHelper.AddParameter("@TotalDiscountAmount", purchaseHeader.TotalDiscountAmount);
else
oDatabaseHelper.AddParameter("@TotalDiscountAmount", DBNull.Value);
// Pass the value of '_totalDiscountRatio' as parameter 'TotalDiscountRatio' of the stored procedure.
if (purchaseHeader.TotalDiscountRatio != null)
oDatabaseHelper.AddParameter("@TotalDiscountRatio", purchaseHeader.TotalDiscountRatio);
else
oDatabaseHelper.AddParameter("@TotalDiscountRatio", DBNull.Value);
// Pass the value of '_isClosed' as parameter 'IsClosed' of the stored procedure.
if (purchaseHeader.IsClosed != null)
oDatabaseHelper.AddParameter("@IsClosed", purchaseHeader.IsClosed);
else
oDatabaseHelper.AddParameter("@IsClosed", DBNull.Value);
// Pass the value of '_isVoid' as parameter 'IsVoid' of the stored procedure.
if (purchaseHeader.IsVoid != null)
oDatabaseHelper.AddParameter("@IsVoid", purchaseHeader.IsVoid);
else
oDatabaseHelper.AddParameter("@IsVoid", DBNull.Value);
// Pass the value of '_isPrinted' as parameter 'IsPrinted' of the stored procedure.
if (purchaseHeader.IsPrinted != null)
oDatabaseHelper.AddParameter("@IsPrinted", purchaseHeader.IsPrinted);
else
oDatabaseHelper.AddParameter("@IsPrinted", DBNull.Value);
// Pass the value of '_servicePrice' as parameter 'ServicePrice' of the stored procedure.
if (purchaseHeader.ServicePrice != null)
oDatabaseHelper.AddParameter("@ServicePrice", purchaseHeader.ServicePrice);
else
oDatabaseHelper.AddParameter("@ServicePrice", DBNull.Value);
// Pass the value of '_taxTypeID' as parameter 'TaxTypeID' of the stored procedure.
if (purchaseHeader.TaxTypeID != null)
oDatabaseHelper.AddParameter("@TaxTypeID", purchaseHeader.TaxTypeID);
else
oDatabaseHelper.AddParameter("@TaxTypeID", DBNull.Value);
// Pass the value of '_refuseReasonID' as parameter 'RefuseReasonID' of the stored procedure.
if (purchaseHeader.RefuseReasonID != null)
oDatabaseHelper.AddParameter("@RefuseReasonID", purchaseHeader.RefuseReasonID);
else
oDatabaseHelper.AddParameter("@RefuseReasonID", DBNull.Value);
// Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure.
if (purchaseHeader.CreatedBy != null)
oDatabaseHelper.AddParameter("@CreatedBy", purchaseHeader.CreatedBy);
else
oDatabaseHelper.AddParameter("@CreatedBy", DBNull.Value);
// Pass the value of '_createDate' as parameter 'CreateDate' of the stored procedure.
if (purchaseHeader.CreateDate != null)
oDatabaseHelper.AddParameter("@CreateDate", purchaseHeader.CreateDate);
else
oDatabaseHelper.AddParameter("@CreateDate", DBNull.Value);
// Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure.
if (purchaseHeader.UpdatedBy != null)
oDatabaseHelper.AddParameter("@UpdatedBy", purchaseHeader.UpdatedBy);
else
oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value);
// Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure.
if (purchaseHeader.updateDate != null)
oDatabaseHelper.AddParameter("@UpdateDate", purchaseHeader.updateDate);
else
oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value);
// Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure.
if (purchaseHeader.IsDeleted != null)
oDatabaseHelper.AddParameter("@IsDeleted", purchaseHeader.IsDeleted);
else
oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value);
// Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure.
if (purchaseHeader.DeletedBy != null)
oDatabaseHelper.AddParameter("@DeletedBy", purchaseHeader.DeletedBy);
else
oDatabaseHelper.AddParameter("@DeletedBy", DBNull.Value);
// Pass the value of '_deletDate' as parameter 'DeletDate' of the stored procedure.
if (purchaseHeader.DeleteDate != null)
oDatabaseHelper.AddParameter("@DeletDate", purchaseHeader.DeleteDate);
else
oDatabaseHelper.AddParameter("@DeletDate", 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("gsp_PURPurchaseHeader_Update", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState);
return ExecutionState;
}
private bool UpdateHeader(DatabaseHelper oDatabaseHelper, PURPurchaseHeader pURPurchaseHeader)
{
bool ExecutionState = false;
// Pass the value of '_salesDate' as parameter 'PurchaseDate' of the stored procedure.
oDatabaseHelper.AddParameter("@PurcaseHeaderID", pURPurchaseHeader.PurcaseHeaderID);
oDatabaseHelper.AddParameter("@PurchaseDate", pURPurchaseHeader.PurchaseDate);
// Pass the value of '_customerID' as parameter 'SupplierID' of the stored procedure.
if (pURPurchaseHeader.SupplierID != null)
{
oDatabaseHelper.AddParameter("@SupplierID", pURPurchaseHeader.SupplierID);
}
else
{
oDatabaseHelper.AddParameter("@SupplierID", DBNull.Value);
}
// Pass the value of '_invoiceNumber' as parameter 'InvoiceNumber' of the stored procedure.
oDatabaseHelper.AddParameter("@InvoiceNumber", DBNull.Value);
// Pass the value of '_invoiceDate' as parameter 'InvoiceDate' of the stored procedure.
if (pURPurchaseHeader.InvoiceDate != null)
{
oDatabaseHelper.AddParameter("@InvoiceDate", pURPurchaseHeader.InvoiceDate);
}
else
{
oDatabaseHelper.AddParameter("@InvoiceDate", DBNull.Value);
}
// Pass the value of '_sellerID' as parameter 'SellerID' of the stored procedure.
//if (pURPurchaseHeader.SellerID != null)
// oDatabaseHelper.AddParameter("@SellerID", pURPurchaseHeader.SellerID);
//else
// oDatabaseHelper.AddParameter("@SellerID", DBNull.Value);
// Pass the value of '_paymentTypeID' as parameter 'PaymentTypeID' of the stored procedure.
if (pURPurchaseHeader.PaymentTypeID != null)
{
oDatabaseHelper.AddParameter("@PaymentTypeID", pURPurchaseHeader.PaymentTypeID);
}
else
{
oDatabaseHelper.AddParameter("@PaymentTypeID", DBNull.Value);
}
if (pURPurchaseHeader.InventoryID != null)
{
oDatabaseHelper.AddParameter("@InventoryID", pURPurchaseHeader.InventoryID);
}
else
{
oDatabaseHelper.AddParameter("@InventoryID", DBNull.Value);
}
// Pass the value of '_totalPrice' as parameter 'TotalPrice' of the stored procedure.
if (pURPurchaseHeader.TotalPrice != null)
{
oDatabaseHelper.AddParameter("@TotalPrice", pURPurchaseHeader.TotalPrice);
}
else
{
oDatabaseHelper.AddParameter("@TotalPrice", DBNull.Value);
}
// Pass the value of '_paidAmount' as parameter 'PaidAmount' of the stored procedure.
if (pURPurchaseHeader.PaidAmount != null)
{
oDatabaseHelper.AddParameter("@PaidAmount", pURPurchaseHeader.PaidAmount);
}
else
{
oDatabaseHelper.AddParameter("@PaidAmount", DBNull.Value);
}
// Pass the value of '_remainingAmount' as parameter 'RemainingAmount' of the stored procedure.
if (pURPurchaseHeader.RemainingAmount != null)
{
oDatabaseHelper.AddParameter("@RemainingAmount", pURPurchaseHeader.RemainingAmount);
}
else
{
oDatabaseHelper.AddParameter("@RemainingAmount", DBNull.Value);
}
// Pass the value of '_lastDayToPay' as parameter 'LastDayToPay' of the stored procedure.
if (pURPurchaseHeader.LastDayToPay != null)
{
oDatabaseHelper.AddParameter("@LastDayToPay", pURPurchaseHeader.LastDayToPay);
}
else
{
oDatabaseHelper.AddParameter("@LastDayToPay", DBNull.Value);
}
if (pURPurchaseHeader.ChequeNumber != null)
{
oDatabaseHelper.AddParameter("@ChequeNumber", pURPurchaseHeader.ChequeNumber);
}
else
{
oDatabaseHelper.AddParameter("@ChequeNumber", DBNull.Value);
}
// Pass the value of '_totalDiscountAmount' as parameter 'TotalDiscountAmount' of the stored procedure.
if (pURPurchaseHeader.TotalDiscountAmount != null)
{
oDatabaseHelper.AddParameter("@TotalDiscountAmount", pURPurchaseHeader.TotalDiscountAmount);
}
else
{
oDatabaseHelper.AddParameter("@TotalDiscountAmount", DBNull.Value);
}
// Pass the value of '_totalDiscountRatio' as parameter 'TotalDiscountRatio' of the stored procedure.
if (pURPurchaseHeader.TotalDiscountRatio != null)
{
oDatabaseHelper.AddParameter("@TotalDiscountRatio", pURPurchaseHeader.TotalDiscountRatio);
}
else
{
oDatabaseHelper.AddParameter("@TotalDiscountRatio", DBNull.Value);
}
// Pass the value of '_isClosed' as parameter 'IsClosed' of the stored procedure.
if (pURPurchaseHeader.IsClosed != null)
{
oDatabaseHelper.AddParameter("@IsClosed", pURPurchaseHeader.IsClosed);
}
else
{
oDatabaseHelper.AddParameter("@IsClosed", DBNull.Value);
}
// Pass the value of '_isVoid' as parameter 'IsVoid' of the stored procedure.
if (pURPurchaseHeader.IsVoid != null)
{
oDatabaseHelper.AddParameter("@IsVoid", pURPurchaseHeader.IsVoid);
}
else
{
oDatabaseHelper.AddParameter("@IsVoid", DBNull.Value);
}
// Pass the value of '_isPrinted' as parameter 'IsPrinted' of the stored procedure.
if (pURPurchaseHeader.IsPrinted != null)
{
oDatabaseHelper.AddParameter("@IsPrinted", pURPurchaseHeader.IsPrinted);
}
else
{
oDatabaseHelper.AddParameter("@IsPrinted", DBNull.Value);
}
// Pass the value of '_servicePrice' as parameter 'ServicePrice' of the stored procedure.
if (pURPurchaseHeader.ServicePrice != null)
{
oDatabaseHelper.AddParameter("@ServicePrice", pURPurchaseHeader.ServicePrice);
}
else
{
oDatabaseHelper.AddParameter("@ServicePrice", DBNull.Value);
}
// Pass the value of '_taxTypeID' as parameter 'TaxTypeID' of the stored procedure.
if (pURPurchaseHeader.TaxTypeID != null)
{
oDatabaseHelper.AddParameter("@TaxTypeID", pURPurchaseHeader.TaxTypeID);
}
else
{
oDatabaseHelper.AddParameter("@TaxTypeID", DBNull.Value);
}
// Pass the value of '_refuseReasonID' as parameter 'RefuseReasonID' of the stored procedure.
if (pURPurchaseHeader.RefuseReasonID != null)
{
oDatabaseHelper.AddParameter("@RefuseReasonID", pURPurchaseHeader.RefuseReasonID);
}
else
{
oDatabaseHelper.AddParameter("@RefuseReasonID", DBNull.Value);
}
// Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure.
// Pass the value of '_updatedBy' as parameter 'UpdatedBy' of the stored procedure.
if (pURPurchaseHeader.UpdatedBy != null)
{
oDatabaseHelper.AddParameter("@UpdatedBy", pURPurchaseHeader.UpdatedBy);
}
else
{
oDatabaseHelper.AddParameter("@UpdatedBy", DBNull.Value);
}
// Pass the value of '_updateDate' as parameter 'UpdateDate' of the stored procedure.
if (pURPurchaseHeader.updateDate != null)
{
oDatabaseHelper.AddParameter("@UpdateDate", pURPurchaseHeader.updateDate);
}
else
{
oDatabaseHelper.AddParameter("@UpdateDate", DBNull.Value);
}
// Pass the value of '_isDeleted' as parameter 'IsDeleted' of the stored procedure.
if (pURPurchaseHeader.IsDeleted != null)
{
oDatabaseHelper.AddParameter("@IsDeleted", pURPurchaseHeader.IsDeleted);
}
else
{
oDatabaseHelper.AddParameter("@IsDeleted", DBNull.Value);
}
// Pass the value of '_deletedBy' as parameter 'DeletedBy' of the stored procedure.
// The parameter '@dlgErrorCode' will contain the status after execution of the stored procedure.
oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output);
oDatabaseHelper.ExecuteScalar("usp_PURPurchaseHeader_Update", CommandType.StoredProcedure, ConnectionState.KeepOpen, ref ExecutionState);
return(ExecutionState);
}
public int SaveTransaction(PURPurchaseHeader pURPurchaseHeader, PURPurchaseLineCollection sALPurchaseLineCollection)
{
oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
int salesHeaderID;
oDatabaseHelper.BeginTransaction();
if (InsertHeader(oDatabaseHelper, pURPurchaseHeader, out salesHeaderID))
{
foreach (PURPurchaseLine sALPurchaseLine in sALPurchaseLineCollection)
{
if (!InsertDetails(oDatabaseHelper, sALPurchaseLine, salesHeaderID))
{
ExecutionState = false;
break;
}
else
ExecutionState = true;
}
if (ExecutionState)
oDatabaseHelper.CommitTransaction();
else
oDatabaseHelper.RollbackTransaction();
}
return salesHeaderID;
}
public bool UpdateTransaction(PURPurchaseHeader pURPurchaseHeader, PURPurchaseLineCollection sALPurchaseLineCollection)
{
oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
oDatabaseHelper.BeginTransaction();
if (UpdateHeader(oDatabaseHelper, pURPurchaseHeader))
{
if (DeleteDetails(oDatabaseHelper, (int)pURPurchaseHeader.PurcaseHeaderID, (int)pURPurchaseHeader.CreatedBy))
{
foreach (PURPurchaseLine sALPurchaseLine in sALPurchaseLineCollection)
{
if (!InsertDetails(oDatabaseHelper, sALPurchaseLine, (int)pURPurchaseHeader.PurcaseHeaderID))
{
ExecutionState = false;
break;
}
else
ExecutionState = true;
}
if (ExecutionState)
oDatabaseHelper.CommitTransaction();
else
oDatabaseHelper.RollbackTransaction();
}
else
ExecutionState = false;
}
else
ExecutionState = false;
return ExecutionState;
}
private static PURPurchaseHeaderCollection PopulateFromReader(IDataReader rdr)
{
PURPurchaseHeaderCollection pURPurchaseHeaderCollection = new PURPurchaseHeaderCollection();
while (rdr.Read())
{
PURPurchaseHeader obj = new PURPurchaseHeader();
obj.PurcaseHeaderID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.PurcaseHeaderID));
obj.PurchaseDate = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.PurchaseDate));
obj.SupplierID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.SupplierID));
if (!rdr.IsDBNull(rdr.GetOrdinal("SupplierName")))
{
obj.SupplierName = rdr.GetString(rdr.GetOrdinal("SupplierName"));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.InvoiceNumber)))
{
obj.InvoiceNumber = rdr.GetString(rdr.GetOrdinal(PURPurchaseHeaderFields.InvoiceNumber));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.InvoiceDate)))
{
obj.InvoiceDate = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.InvoiceDate));
}
// if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.SellerID)))
// {
// obj.SellerID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.SellerID));
// }
//if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.PaymentTypeID)))
//{
// obj.PaymentTypeID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.PaymentTypeID));
//}
obj.TotalPrice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseHeaderFields.TotalPrice));
obj.PaidAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseHeaderFields.PaidAmount));
obj.RemainingAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseHeaderFields.RemainingAmount));
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.LastDayToPay)))
{
obj.LastDayToPay = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.LastDayToPay));
}
obj.TotalDiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseHeaderFields.TotalDiscountAmount));
obj.TotalDiscountRatio = rdr.GetDouble(rdr.GetOrdinal(PURPurchaseHeaderFields.TotalDiscountRatio));
obj.IsClosed = rdr.GetBoolean(rdr.GetOrdinal(PURPurchaseHeaderFields.IsClosed));
obj.IsVoid = rdr.GetBoolean(rdr.GetOrdinal(PURPurchaseHeaderFields.IsVoid));
obj.IsPrinted = rdr.GetBoolean(rdr.GetOrdinal(PURPurchaseHeaderFields.IsPrinted));
obj.ServicePrice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseHeaderFields.ServicePrice));
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.TaxTypeID)))
{
obj.TaxTypeID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.TaxTypeID));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.RefuseReasonID)))
{
obj.RefuseReasonID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.RefuseReasonID));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.CreatedBy)))
{
obj.CreatedBy = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.CreatedBy));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.CreateDate)))
{
obj.CreateDate = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.CreateDate));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.UpdatedBy)))
{
obj.UpdatedBy = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.UpdatedBy));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.updateDate)))
{
obj.updateDate = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.updateDate));
}
obj.IsDeleted = rdr.GetBoolean(rdr.GetOrdinal(PURPurchaseHeaderFields.IsDeleted));
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.DeletedBy)))
{
obj.DeletedBy = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseHeaderFields.DeletedBy));
}
if (!rdr.IsDBNull(rdr.GetOrdinal(PURPurchaseHeaderFields.DeleteDate)))
{
obj.DeleteDate = rdr.GetDateTime(rdr.GetOrdinal(PURPurchaseHeaderFields.DeleteDate));
}
pURPurchaseHeaderCollection.Add(obj);
}
return pURPurchaseHeaderCollection;
}
/// <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 PURPurchaseHeaderCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 31/5/2015 10:35:27 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static PURPurchaseHeaderCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper)
{
PURPurchaseHeaderCollection list = new PURPurchaseHeaderCollection();
if (rdr.Read())
{
PURPurchaseHeader obj = new PURPurchaseHeader();
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
while (rdr.Read())
{
obj = new PURPurchaseHeader();
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 PURPurchaseHeaderCollection</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 31/5/2015 10:35:27 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static PURPurchaseHeaderCollection PopulateObjectsFromReader(IDataReader rdr)
{
PURPurchaseHeaderCollection list = new PURPurchaseHeaderCollection();
while (rdr.Read())
{
PURPurchaseHeader obj = new PURPurchaseHeader();
PopulateObjectFromReader(obj,rdr);
list.Add(obj);
}
return list;
}
/// <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="PURPurchaseHeaderPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class PURPurchaseHeader</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 31/5/2015 10:35:27 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public static PURPurchaseHeader SelectOneWithPURPurchaseReturnHeaderUsingOriginalHeaderID(PURPurchaseHeaderPrimaryKey pk)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
PURPurchaseHeader 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] );
}
// 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_PURPurchaseHeader_SelectOneWithPURPurchaseReturnHeaderUsingOriginalHeaderID", ref ExecutionState);
if (dr.Read())
{
obj= new PURPurchaseHeader();
PopulateObjectFromReader(obj,dr);
dr.NextResult();
//Get the child records.
obj.PURPurchaseReturnHeaderCollectionUsingOriginalHeaderID=PURPurchaseReturnHeader.PopulateObjectsFromReader(dr);
}
dr.Close();
oDatabaseHelper.Dispose();
return obj;
}
