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