public XmlDocument GetAllTemplates(string UserID, string Password)
{
XmlDocument doc = new System.Xml.XmlDocument();
StringBuilder str = new StringBuilder();
str.Append("<TemplateInfo>");
string ConnectionString = GetConnectionString(UserID, Password);
if (ConnectionString.Trim().Length != 0)
{
TemplateMaster templateMasters = new TemplateMaster(ConnectionString);
DataTable templateMasterDt = new DataTable();
templateMasterDt = templateMasters.SelectAll(ConnectionString, "CreatedDate", "asc");
if (templateMasters != null)
{
for (int i = 0; i < templateMasterDt.Rows.Count; i++)//templateMasterDt.Rows.Count
{
str.Append("<Template Row=\"" + i.ToString() + "\">");
str.Append("<TemplateId>" + templateMasterDt.Rows[i]["TemplateId"].ToString() + "</TemplateId>");
str.Append("<TemplateName>" + Server.HtmlEncode(templateMasterDt.Rows[i]["TemplateName"].ToString()) + "</TemplateName>");
str.Append("<TemplateDescription>" + Server.HtmlEncode(templateMasterDt.Rows[i]["TemplateDescription"].ToString()) + "</TemplateDescription>");
str.Append("<TemplateCreatedDatetime>" + Convert.ToDateTime(templateMasterDt.Rows[i]["CreatedDate"]).ToString() + "</TemplateCreatedDatetime>");
str.Append("<Errormessage></Errormessage>");
str.Append("</Template>");
string ss = str.ToString();
}
}
else
{
str.Append("<Message> Please Enter Valid Inputs</Message>");
}
}
str.Append("</TemplateInfo>");
doc.LoadXml(str.ToString());
return doc;
}
public void bindGrid(string fillflag, DataTable searchResult)
{
try
{
if (searchResult.Rows.Count != 0)
{
if (searchResult.Rows.Count > 0)
{
fillflag = "sort";
string sortdir = (fillflag == "sort" ? GetSortDirection() : GridViewSortDirection);
DataView searchDataView = new DataView(searchResult);
searchDataView.Sort = GridSortExpression + " " + sortdir;
grdCreatives.DataSource = searchDataView;
grdCreatives.DataBind();
GridPrevSortExpression = GridSortExpression;
}
}
else
{
string sortdir = (fillflag == "sort" ? GetSortDirection() : GridViewSortDirection);
if (flagreset == true)
{
sortdir = "DESC";//"ASC";
GridSortExpression = "CreatedDate"; //"TemplateName";
}
TemplateMaster templateMasters = new TemplateMaster(ConnectionString);
DataTable templateMasterDt = new DataTable();
templateMasterDt = templateMasters.SelectAll(ConnectionString, GridSortExpression, sortdir);
grdCreatives.DataSource = templateMasterDt;
grdCreatives.DataBind();
GridPrevSortExpression = GridSortExpression;
}
}
catch (Exception ex)
{
throw ex;
}
}
