protected void HashData()
{
var loadData = (from t in tne.tblTimeExpensesSummaries
where t.UserId == int.Parse(Loaduser) && t.Id == int.Parse(row)
select t).Single();
loadData.Date = DateTime.Parse(txtDate.Text);
loadData.WorkHrs = Decimal.Parse(txtHours.Text);
loadData.Location = txtClient.Text;
loadData.WorkDescription = txtWorkDesc.Text;
loadData.Comments = txtComments.Text;
loadData.PaymentReceived = cbPayment.Checked;
loadData.LastUpdated = DateTime.Now;
tne.SubmitChanges();
//Update History table
var loadHistData = (from t in tne.tblTimeExpensesSummary_histories
where t.UserId == int.Parse(Loaduser) && t.Id == int.Parse(row)
select t).Single();
loadHistData.Date = DateTime.Parse(txtDate.Text);
loadHistData.WorkHrs = Decimal.Parse(txtHours.Text);
loadHistData.Location = txtClient.Text;
loadHistData.WorkDescription = txtWorkDesc.Text;
loadHistData.Comments = txtComments.Text;
loadHistData.PaymentReceived = cbPayment.Checked;
loadHistData.LastUpdated = DateTime.Now;
tne.SubmitChanges();
}
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();
}
