internal static void SaveToCsvFile(string fileName, DataTable data)
{
var lines = new List <string>();
string[] columnNames = data.Columns.Cast <DataColumn>().
Select(column => column.ColumnName).
ToArray();
var header = String.Join(",", columnNames);
lines.Add(header);
var valueLines = EnumerableRowCollectionExtensions.Select(
data.AsEnumerable(),
row => String.Join(",", EscapeQuotes(row.ItemArray)));
lines.AddRange(valueLines);
File.WriteAllLines(fileName, lines);
}
public DataTable getLigsPick()
{
DataTable dt1;
try
{
DataTable dt = (DataTable)this.Session[this._nameSessionData];
if (dt == null || dt.Rows.Count == 0)
{
return(new DataTable());
}
dt1 = DataTableExtensions.CopyToDataTable <DataRow>((IEnumerable <DataRow>)EnumerableRowCollectionExtensions.Where <DataRow>(DataTableExtensions.AsEnumerable(dt), (Func <DataRow, bool>)(x => DataRowExtensions.Field <string>(x, "liq_estid").Equals("PM") || DataRowExtensions.Field <string>(x, "liq_estid").Equals("PF"))));
return(dt1);
//return DataTableExtensions.CopyToDataTable<DataRow>((IEnumerable<DataRow>)EnumerableRowCollectionExtensions.Where<DataRow>(DataTableExtensions.AsEnumerable(dt), (Func<DataRow, bool>)(x => DataRowExtensions.Field<string>(x, "liq_estid").Equals("PF"))));
}
catch
{
return(new DataTable());
}
}
public DataTable getLiqsHalls()
{
try
{
DataTable dt = (DataTable)this.Session[this._nameSessionData];
if (dt == null || dt.Rows.Count == 0)
{
return(new DataTable());
}
return(DataTableExtensions.CopyToDataTable <DataRow>((IEnumerable <DataRow>)EnumerableRowCollectionExtensions.Where <DataRow>(DataTableExtensions.AsEnumerable(dt), (Func <DataRow, bool>)(x => !DataRowExtensions.Field <string>(x, "lhv_status").Equals("PM")))));
}
catch
{
return(new DataTable());
}
}
