// 130501
//public static string csExportSelected(this GridControl grid, string DirectoryPath, string _filename)
//{
// try
// {
// string filename = MyLib.GetSaveFileName(DirectoryPath, "xls", "Excel | *.xls", "Save Grid To Excel",
// _filename);
// if (filename != string.Empty)
// {
// if (File.Exists(filename))
// {
// File.Delete(filename);
// }
// // string.Format("Got Here {0}", filename).csTell();
// grid.ExportToXls(filename);
// return Path.GetDirectoryName(filename);
// }
// }
// catch (Exception ex)
// {
// string msg = "valid";
// if (grid == null) msg = "null";
// msg = string.Format("Message: {0} Directory: {1} FileName: {2}", ex.Message, msg, DirectoryPath,
// _filename);
// msg.csTell();
// }
// "File Not Saved".csTell();
// return DirectoryPath;
//}
public static string csExport(this GridControl grid, string DirectoryPath, string _filename)
{
try
{
string filename = MyLib.GetSaveFileName(DirectoryPath, "xls", "Excel | *.xls", "Save Grid To Excel",
_filename);
if (filename != string.Empty)
{
if (File.Exists(filename))
{
File.Delete(filename);
}
// string.Format("Got Here {0}", filename).csTell();
grid.ExportToXls(filename);
return(Path.GetDirectoryName(filename));
}
}
catch (Exception ex)
{
string msg = "valid";
if (grid == null)
{
msg = "null";
}
msg = string.Format("Message: {0} Directory: {1} FileName: {2}", ex.Message, msg, DirectoryPath,
_filename);
msg.csTell();
}
"File Not Saved".csTell();
return(DirectoryPath);
}
public static string csGridToXLS(this GridControl grid, string folder, string fileName)
{
var temp = MyLib.GetSaveFileName(folder
, "xls"
, "xls"
, "Save Grid"
, fileName);
grid.ExportToXls(temp);
return(Path.GetDirectoryName(temp));
}
public static string csSaveChartImageToFile(this ChartControl c, string path, string chartName = null)
{
if (string.IsNullOrEmpty(chartName))
{
ChartElement[] t = c.Titles.ToArray();
if (t.Length > 0)
{
foreach (ChartElement chartElement in t)
{
chartName += (chartElement + " ");
}
}
}
chartName = chartName.Replace("\r\n", " ").Replace("/", "-").Replace(":", "_").Trim();
// strip out the html
int loc = chartName.IndexOf('<');
while (loc > -1)
{
// find closing angle bracket
int floc = chartName.IndexOf('>');
if (floc > loc)
{
chartName = chartName.Substring(0, loc) + " " + chartName.Substring(floc + 1);
loc = chartName.IndexOf('<');
}
else
{
break;
}
}
chartName = chartName.Replace('<', '-').Replace('>', '-');
var temp = MyLib.GetSaveFileName(path
, "png"
, "png"
, "Save Chart Image"
, chartName);
if (string.IsNullOrEmpty(temp))
{
return(path);
}
c.ExportToImage(temp, ImageFormat.Png);
return(Path.GetDirectoryName(temp));
}
