public static DataTable GetCodeAvailablePOList(eSolutionDataContext db, string customerCode, string pOType, string pOStatus, Boolean allFlag) { //EMSdb = new eSolutionDataContext(); DataTable dt = new DataTable(); DataColumn colValue = new DataColumn(); DataColumn colText = new DataColumn(); DataRow newRow; try { colText.ColumnName = HelperClass.DisplayName; colValue.ColumnName = HelperClass.CodeName; colText.DataType = typeof(System.String); colValue.DataType = typeof(System.String); dt.Columns.Add(colText); dt.Columns.Add(colValue); if (string.IsNullOrEmpty(customerCode)) { customerCode = "%"; } if (string.IsNullOrEmpty(pOType)) { pOType = "%"; } if (string.IsNullOrEmpty(pOStatus)) { pOStatus = "%"; } var sqlQuery = db.stp_GetPOListByCustomer(customerCode, pOType, pOStatus).ToList(); //var sqlQuery = from obj in db.POHeaders // from cst in db.Customers // where obj.CustomerID == cst.CustomerID // && obj.POType == pOType // && (obj.Status.ToString()).ToUpper().Contains(pOStatus) // && cst.CustomerCode == customerCode // orderby obj.PONumber // select new // { // POID = obj.POHeaderID, // PONO = obj.PONumber // }; if (allFlag == true) { newRow = dt.NewRow(); newRow[HelperClass.DisplayName] = "ALL"; newRow[HelperClass.CodeName] = ""; dt.Rows.Add(newRow); } foreach (var row in sqlQuery) { newRow = dt.NewRow(); newRow[HelperClass.DisplayName] = row.PONumber; newRow[HelperClass.CodeName] = row.PONumber; dt.Rows.Add(newRow); } } catch { dt = null; } finally { } return(dt); }