private void UpdateDatabase()
{
// Get ids
int companyId = Int32.Parse(hdfCompanyId.Value);
DB.Open();
DB.BeginTransaction();
try
{
// ... Update general todo list state
ToDoListInformationBasicInformation toDoListInformationBasicInformation = new ToDoListInformationBasicInformation(toDoListInformationTDS);
toDoListInformationBasicInformation.Save(companyId);
// ... Save to do list details
ToDoListInformationActivityInformation toDoListInformationActivityInformation = new ToDoListInformationActivityInformation(toDoListInformationTDS);
toDoListInformationActivityInformation.Save(companyId);
// ... Send mails
if (hdfCompleted.Value == "True")
{
SendMailForCompletedToDo();
}
DB.CommitTransaction();
// Store datasets
toDoListInformationTDS.AcceptChanges();
Session["toDoListInformationTDS"] = toDoListInformationTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private void UpdateDatabase()
{
// Get ids & location
//string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value);
int toDoId = Int32.Parse(hdfToDoId.Value);
DB.Open();
DB.BeginTransaction();
try
{
// Save toDo details
ToDoListInformationBasicInformation toDoListInformationBasicInformation = new ToDoListInformationBasicInformation(toDoListInformationTDS);
toDoListInformationBasicInformation.Save(companyId);
//// Save work details
//PointToDoWorkDetails pointToDoWorkDetails = new PointToDoWorkDetails(toDoListInformationTDS);
//pointToDoWorkDetails.Save(countryId, provinceId, countyId, cityId, projectId, sectionAssetId, companyId);
DB.CommitTransaction();
// Store datasets
toDoListInformationTDS.AcceptChanges();
Session["toDoListInformationTDS"] = toDoListInformationTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}