public KeyValuePair <string, List <PageCreationTables> > GetTableDescRecordEdit(string recordID, int page, int pageSize, string whereCondition, string sort) { try { PageCreationTables pageCreationTables = new PageCreationTables(); string searchby = whereCondition.ToString(); //string[] search = searchby.Split(','); //for (int i = 0; i < search.Length; i++) //{ // string tblName = search[i].ToString(); // //} whereCondition = ""; SqlParameter[] Parameters = { new SqlParameter("@SNo", recordID), new SqlParameter("@TableName", searchby.ToString()), new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", whereCondition), new SqlParameter("@AppId", ""), new SqlParameter("@OrderBy", sort) }; DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetTableDescEdit", Parameters); var pageCreationTablesList = ds.Tables[0].AsEnumerable().Select(e => new PageCreationTables { ColumnName = e["ColumnName"].ToString(), Datatype = e["DataType"].ToString(), // Length = e["Max Length"].ToString(), DISPLAY_ORDER = Convert.ToInt16(e["DISPLAY_ORDER"].ToString()), ASSEMBLY_NAME = e["Assembly_Name"].ToString(), LABEL_CELL_TEXT = e["Label_Cell_Text"].ToString(), LABEL_CELL_CSSCLASS = e["Label_Cell_Cssclass"].ToString(), DATA_FIELDNAME = e["Data_Fieldname"].ToString(), DATA_FIELD_CSSCLASS = e["Data_Field_Cssclass"].ToString(), DATA_CELL_CSSCLASS = e["Data_Cell_Cssclass"].ToString(), ONCLICK_HANDLER = "", //POSTBACK_URL=null, //CALLBACK_URL=null, //SKIN_ID=null, TOOLTIP = e["Tooltip"].ToString(), BTN_USESUBMIT_BEHAVIOUR = e["Btn_Usesubmit_Behaviour"].ToString().ToUpper() == "0" ? false : true, VISIBLE = e["Visible"].ToString().ToUpper() == "FALSE" ? false : true, READONLY = e["Readonly"].ToString().ToUpper() == "FALSE" ? false : true, ENABLE_VIEWSTATE = e["Enable_Viewstate"].ToString().ToUpper() == "FALSE" ? false : true, MAXLENGTH = e["Maxlength"].ToString(), MULTILINE = e["Multiline"].ToString().ToUpper() == "FALSE" ? false : true, WIDTH = e["WIDTH"].ToString(), HEIGHT = e["HEIGHT"].ToString(), //Tab_Id=null, //Tab_Name=null, Section_Name = e["Section_Name"].ToString(), ONKEY_HANDLER = e["Onkey_Handler"].ToString(), ONBLUR_HANDLER = e["Onblur_Handler"].ToString(), ENABLE_REQUIREVALIDATION = e["Enable_Requirevalidation"].ToString().ToUpper() == "0" ? false : true, REQUIRED_FIELD_MESSAGE = e["Required_Field_Message"].ToString(), LOOKUP_NAME = e["Lookup_Name"].ToString(), TAB_INDEX = Convert.ToInt32(e["Tab_Index"].ToString()), XmlFolderName = e["XmlFolderName"].ToString(), XmlFileName = e["XmlFileName"].ToString(), }); return(new KeyValuePair <string, List <PageCreationTables> >(ds.Tables[1].Rows[0][0].ToString(), pageCreationTablesList.AsQueryable().ToList())); } catch (Exception ex)// { throw ex; } }
public KeyValuePair <string, List <PageCreationTables> > GetTableDescRecord(string recordID, int page, int pageSize, string whereCondition, string sort) { try { PageCreationTables pageCreationTables = new PageCreationTables(); string searchby = whereCondition.ToString(); //string[] search = searchby.Split(','); //for (int i = 0; i < search.Length; i++) //{ // string tblName = search[i].ToString(); // //} whereCondition = ""; SqlParameter[] Parameters = { new SqlParameter("@SNo", recordID), new SqlParameter("@TableName", searchby.ToString()), new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", whereCondition), new SqlParameter("@OrderBy", sort) }; DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetTableDesc", Parameters); var pageCreationTablesList = ds.Tables[0].AsEnumerable().Select(e => new PageCreationTables { ColumnName = e["Column Name"].ToString(), Datatype = e["Data Type"].ToString(), Length = e["Max Length"].ToString(), DISPLAY_ORDER = Convert.ToInt16(e["DISPLAY_ORDER"].ToString()), ASSEMBLY_NAME = "", LABEL_CELL_TEXT = null, LABEL_CELL_CSSCLASS = "", DATA_FIELDNAME = null, DATA_FIELD_CSSCLASS = null, DATA_CELL_CSSCLASS = null, ONCLICK_HANDLER = null, //POSTBACK_URL=null, //CALLBACK_URL=null, //SKIN_ID=null, TOOLTIP = null, BTN_USESUBMIT_BEHAVIOUR = false, VISIBLE = false, READONLY = false, ENABLE_VIEWSTATE = false, MAXLENGTH = null, MULTILINE = false, WIDTH = null, HEIGHT = null, //Tab_Id=null, //Tab_Name=null, Section_Name = null, ONKEY_HANDLER = null, ONBLUR_HANDLER = null, ENABLE_REQUIREVALIDATION = false, REQUIRED_FIELD_MESSAGE = null, LOOKUP_NAME = null, TAB_INDEX = 0, XmlFolderName = null, XmlFileName = null, }); return(new KeyValuePair <string, List <PageCreationTables> >(ds.Tables[1].Rows[0][0].ToString(), pageCreationTablesList.AsQueryable().ToList())); } catch (Exception ex)// { throw ex; } }