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