public static IEnumerable <tblTimeExpensesSummary> GetUserById(int in_id)
{
TNEDataContext tb = new TNEDataContext();
tb.tblTimeExpensesSummaries.Single(p => p.Id == in_id);
return(tb.tblTimeExpensesSummaries);
}
public static void Update(int id)
{
TNEDataContext t = new TNEDataContext();
var item = t.tblTimeExpensesSummaries.Single(p => p.Id == id);
item.LastUpdated = DateTime.Now;
t.SubmitChanges();
}
protected void SendExcelInfo()
{
if (!string.IsNullOrEmpty(txtEndDateExcel.Text) && !string.IsNullOrEmpty(txtStartDateExcel.Text))
{
if (Convert.ToDateTime(txtStartDateExcel.Text) <= Convert.ToDateTime(txtEndDateExcel.Text))
{
string datetime = DateTime.Now.ToShortDateString();
TNEDataContext t = new TNEDataContext();
var xl = from g in t.tblTimeExpensesSummaries
where g.Date >= Convert.ToDateTime(txtStartDateExcel.Text) &&
g.Date <= Convert.ToDateTime(txtEndDateExcel.Text) &&
g.NewId.ToString() == userId.ToString()
orderby g.Date descending
select new
{
Day = g.Date,
Description = g.WorkDescription,
Hours = g.WorkHrs,
Comments = g.Comments,
PaymentReceived = g.PaymentReceived
};
GridView newGrid = new GridView();
newGrid.DataSource = xl;
newGrid.DataBind();
try
{
bl.Export(String.Format("TNE_{0}.xls", datetime), newGrid);
}
catch (Exception)
{
}
}
}
}
public static IEnumerable <tblTimeExpensesSummary> Select()
{
TNEDataContext t = new TNEDataContext();
return(t.tblTimeExpensesSummaries);
}
