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);
}
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);
}
public Enumerator(PURPurchaseLineCollection t)
{
this.t = t;
}
