public PurchaseInvoiceDetailCollection GetAllPurchaseInvoiceDetailCollection()
{
IDBManager dbm = new DBManager();
PurchaseInvoiceDetailCollection cols = new PurchaseInvoiceDetailCollection();
try
{
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPurchaseInvoiceDetailsAll");
while (reader.Read())
{
PurchaseInvoiceDetail PID = new PurchaseInvoiceDetail();
PID.InvoiceID = Int32.Parse(reader["InvoiceID"].ToString());
PID.InvoiceDetailID = Int32.Parse(reader["InvoiceDetailID"].ToString());
PID.ProductID = Int32.Parse(reader["ProductID"].ToString());
PID.UnitPrice = Decimal.Parse(reader["UnitPrice"].ToString());
PID.Quantity = Int64.Parse(reader["Quantity"].ToString());
PID.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(PID);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "PurchaseInvoiceDetailCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}
public bool DeletePurchaseInvoiceDetail(PurchaseInvoiceDetailCollection col)
{
try
{
foreach (PurchaseInvoiceDetail PID in col)
{
DeletePurchaseInvoiceDetail(PID.InvoiceDetailID);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "DeletePurchaseInvoiceDetail");
throw (ex);
}
return(true);
}
public PurchaseInvoiceDetailCollection GetAllPurchaseInvoiceDetailDynamicCollection(string whereExpression, string orderBy)
{
IDBManager dbm = new DBManager();
PurchaseInvoiceDetailCollection cols = new PurchaseInvoiceDetailCollection();
try
{
dbm.CreateParameters(2);
dbm.AddParameters(0, "@WhereCondition", whereExpression);
dbm.AddParameters(1, "@OrderByExpression", orderBy);
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPurchaseInvoiceDetailsDynamic");
while (reader.Read())
{
PurchaseInvoiceDetail PID = new PurchaseInvoiceDetail();
PID.InvoiceID = Int32.Parse(reader["InvoiceID"].ToString());
PID.InvoiceDetailID = Int32.Parse(reader["InvoiceDetailID"].ToString());
PID.ProductID = Int32.Parse(reader["ProductID"].ToString());
PID.UnitPrice = Decimal.Parse(reader["UnitPrice"].ToString());
PID.Quantity = Int64.Parse(reader["Quantity"].ToString());
PID.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(PID);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllPurchaseInvoiceDetailDynamicCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}
