private void UpdateDatabase() { DB.Open(); DB.BeginTransaction(); try { int companyId = Int32.Parse(hdfCompanyId.Value); DateTime creationDate = DateTime.Now; SupportTicketAddBasicInformation supportTicketAddBasicInformation = new SupportTicketAddBasicInformation(supportTicketAddTDS); hdfSupportTicketId.Value = supportTicketAddBasicInformation.Save(creationDate, companyId).ToString(); // Send mail SendMailForNewTicket(); DB.CommitTransaction(); // Store datasets supportTicketAddTDS.AcceptChanges(); Session["supportTicketAddTDS"] = supportTicketAddTDS; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private void PostPageChanges() { int companyId = Int32.Parse(hdfCompanyId.Value); string subject = hdfSubject.Value; string comments = hdfComments.Value; DateTime? dueDate = null; if (hdfDueDate.Value != "") dueDate = DateTime.Parse(hdfDueDate.Value); int assignTeamMemberId = Int32.Parse(hdfTeamMemberId.Value); string state = "New"; string type_ = "AssignUser"; int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); hdfTeamMemberId.Value = employeeGateway.GetEmployeIdByLoginId(loginId).ToString(); int employeeId = Int32.Parse(hdfTeamMemberId.Value); int categoryId = Int32.Parse(hdfCategoriesSelected.Value); SupportTicketCategoryGateway supportTicketCategoryGateway = new SupportTicketCategoryGateway(); supportTicketCategoryGateway.LoadByCategoryId(categoryId, companyId); string categoryName = supportTicketCategoryGateway.GetName(categoryId); // Insert to dataset SupportTicketAddBasicInformation supportTicketAddBasicInformation = new SupportTicketAddBasicInformation(supportTicketAddTDS); supportTicketAddBasicInformation.Insert(categoryId, subject, comments, dueDate, assignTeamMemberId, false, companyId, state, employeeId, type_, categoryName); // Store session Session["supportTicketAddTDS"] = supportTicketAddTDS; }