/// <summary>
/// Binds the purchase list.
/// </summary>
private void BindPurchaseList()
{
DataTable dt = new DataTable();
dt.Columns.Add("OrderHeaderId");
dt.Columns.Add("Records");
dt.Columns.Add("PONumber");
dt.Columns.Add("Type");
int iCount = 1;
string objPOnumber = (this.txtPONumber.Text.Trim() == "*") ? string.Empty : PurchasingUtils.GenSafeChars(this.txtPONumber.Text.Trim());
string objType = (this.txtType.Text.Trim() == "*") ? string.Empty : PurchasingUtils.GenSafeChars(this.txtType.Text.Trim());
string sql = "Status = 1 AND PostedBy <> '" + System.Guid.Empty + "' AND OrderNumber LIKE '%" + objPOnumber + "%' AND OrderType LIKE '%" + objType + "%'";
string[] objOrderBy = { "OrderNumber" };
PurchaseOrderHeaderCollection objHeaders = PurchaseOrderHeader.LoadCollection(sql, objOrderBy, true);
foreach (PurchaseOrderHeader objHeader in objHeaders)
{
string orderType = string.Empty;
switch (objHeader.OrderType)
{
case 0:
orderType = DAL.Common.Enums.POType.FPO.ToString();
break;
case 1:
orderType = DAL.Common.Enums.POType.LPO.ToString();
break;
case 2:
orderType = DAL.Common.Enums.POType.OPO.ToString();
break;
}
DataRow row = dt.NewRow();
row["OrderHeaderId"] = objHeader.OrderHeaderId.ToString(); //// OrderHeaderId
row["Records"] = iCount.ToString(); //// Line Number
row["PONumber"] = objHeader.OrderNumber;
row["Type"] = orderType;
dt.Rows.Add(row);
iCount++;
}
dgvReceivingFindList.DataSource = dt;
}
public PurchaseOrderHeaderCollection GetAllPurchaseOrderHeaderDynamicCollection(string whereExpression, string orderBy)
{
IDBManager dbm = new DBManager();
PurchaseOrderHeaderCollection cols = new PurchaseOrderHeaderCollection();
try
{
dbm.CreateParameters(2);
dbm.AddParameters(0, "@WhereCondition", whereExpression);
dbm.AddParameters(1, "@OrderByExpression", orderBy);
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPurchaseOrderHeadersDynamic");
while (reader.Read())
{
PurchaseOrderHeader purchaseOrderHeader = new PurchaseOrderHeader();
purchaseOrderHeader.PurchaseOrderID = Int32.Parse(reader["PurchaseOrderID"].ToString());
purchaseOrderHeader.RevisionNumber = reader["RevisionNumber"].ToString();
purchaseOrderHeader.Status = Byte.Parse(reader["Status"].ToString());
purchaseOrderHeader.EmployeeID = Int32.Parse(reader["EmployeeID"].ToString());
purchaseOrderHeader.VendorID = Int32.Parse(reader["VendorID"].ToString());
purchaseOrderHeader.ShipMethodID = Int32.Parse(reader["ShipMethodID"].ToString());
purchaseOrderHeader.OrderDate = DateTime.Parse(reader["OrderDate"].ToString());
purchaseOrderHeader.ShipDate = DateTime.Parse(reader["ShipDate"].ToString());
purchaseOrderHeader.SubTotal = Decimal.Parse(reader["SubTotal"].ToString());
purchaseOrderHeader.TaxAmt = Decimal.Parse(reader["TaxAmt"].ToString());
purchaseOrderHeader.Freight = Decimal.Parse(reader["Freight"].ToString());
purchaseOrderHeader.TotalDue = Decimal.Parse(reader["TotalDue"].ToString());
purchaseOrderHeader.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(purchaseOrderHeader);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllPurchaseOrderHeaderDynamicCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}
