public void SendMailForNewTicket() { int companyId = Int32.Parse(hdfCompanyId.Value); // Get mail information string mailTo = ""; string nameTo = ""; string subject = "A support ticket was created."; string body = ""; // MailtTo, nameTo int createdBy = Int32.Parse(hdfTeamMemberId.Value); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(createdBy); mailTo = employeeGateway.GetEMail(createdBy); nameTo = employeeGateway.GetFullName(createdBy); // Mails body body = body + "\nHi " + nameTo + ",\n\nThe following support ticket was created. \n"; body = body + "\n Subject: " + hdfSubject.Value; body = body + "\n Comment: " + hdfComments.Value; body = body + "\n Created By: " + employeeGateway.GetFullName(createdBy); if (hdfDueDate.Value != "") { DateTime dueDate = DateTime.Parse(hdfDueDate.Value); string dueDateText = dueDate.Month.ToString() + "/" + dueDate.Day.ToString() + "/" + dueDate.Year.ToString(); body = body + "\n Due Date: " + dueDateText; } int categoryId = Int32.Parse(hdfCategoriesSelected.Value); SupportTicketCategoryGateway supportTicketCategoryGateway = new SupportTicketCategoryGateway(); supportTicketCategoryGateway.LoadByCategoryId(categoryId, companyId); body = body + "\n Category: " + supportTicketCategoryGateway.GetName(categoryId); //int assignTeamMemberId = Int32.Parse(hdfTeamMemberId.Value); //EmployeeGateway employeeGatewayForAssignment = new EmployeeGateway(); //employeeGatewayForAssignment.LoadByEmployeeId(assignTeamMemberId); //body = body + "\n Assigned team member: " + employeeGatewayForAssignment.GetFullName(assignTeamMemberId) + "\n"; body = body + "\n Assigned team member: Anzovino Dan \n"; //Send Mail SendMail(mailTo, subject, body); }
/// <summary> /// Save /// </summary> public void Save() { foreach (SupportTicketCategoriesAddTDS.CategoriesAddNewRow row in (SupportTicketCategoriesAddTDS.CategoriesAddNewDataTable)Data.Tables["CategoriesAddNew"]) { // Insert category if ((!row.Deleted) && (!row.InDatabase)) { int? parentId = null; if (!row.IsParentIDNull()) parentId = row.ParentID; SupportTicketCategory categories = new SupportTicketCategory(null); categories.InsertDirect(row.Name, parentId, row.Deleted, row.COMPANY_ID); } // Update category if ((!row.Deleted) && (row.InDatabase)) { int companyId = row.COMPANY_ID; SupportTicketCategoryGateway supportTicketcategoryGateway = new SupportTicketCategoryGateway(); supportTicketcategoryGateway.LoadByCategoryId(row.CategoryID, companyId); int categoryId = row.CategoryID; string originalName = supportTicketcategoryGateway.GetName(categoryId); int? originalParentId = null; if (supportTicketcategoryGateway.GetParentId(categoryId).HasValue) originalParentId = (int)supportTicketcategoryGateway.GetParentId(categoryId); SupportTicketCategory category = new SupportTicketCategory(null); category.UpdateDirect(categoryId, originalName, originalParentId, row.Deleted, companyId, row.CategoryID, row.Name, originalParentId, row.Deleted, companyId); } // Delete category if ((row.Deleted) && (row.InDatabase)) { int categoryId = row.CategoryID; int? newCategoryId = null; if (!row.IsNewCategoryIDNull()) newCategoryId = row.NewCategoryID; int companyId = row.COMPANY_ID; SupportTicketCategory category = new SupportTicketCategory(null); category.DeletedDirect(categoryId, companyId); } } }
/// <summary> /// UpdateDirect /// </summary> /// <param name="originalSupportTicketCategoryId">originalSupportTicketCategoryId</param> /// <param name="originalName">originalName</param> /// <param name="originalParentId">originalParentId</param> /// <param name="originalDeleted">originalDeleted</param> /// <param name="originalCompanyId">originalCompanyId</param> /// <param name="newSupportTicketCategoryId">newSupportTicketCategoryId</param> /// <param name="newName">newName</param> /// <param name="newParentId">newParentId</param> /// <param name="newDeleted">newDeleted</param> /// <param name="newCompanyId">newCompanyId</param> public void UpdateDirect(int originalSupportTicketCategoryId, string originalName, int? originalParentId, bool originalDeleted, int originalCompanyId, int newSupportTicketCategoryId, string newName, int? newParentId, bool newDeleted, int newCompanyId) { SupportTicketCategoryGateway categoryGateway = new SupportTicketCategoryGateway(null); categoryGateway.Update(originalSupportTicketCategoryId, originalName, originalParentId, originalDeleted, originalCompanyId, newSupportTicketCategoryId, newName, newParentId, newDeleted, newCompanyId); }
// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS // /// <summary> /// Load /// </summary> /// <param name="companyId">companyId</param> public void Load(int companyId) { SupportTicketCategoryGateway supportTicketCategoryGateway = new SupportTicketCategoryGateway(Data); supportTicketCategoryGateway.Load(companyId); UpdateData(); }
/// <summary> /// InsertDirect /// </summary> /// <param name="name">name</param> /// <param name="parentId">parentId</param> /// <param name="deleted">deleted</param> /// <param name="companyId">companyId</param> public void InsertDirect(string name, int? parentId, bool deleted, int companyId) { SupportTicketCategoryGateway categoryGateway = new SupportTicketCategoryGateway(null); categoryGateway.Insert(name, parentId, deleted, companyId); }
/// <summary> /// DeletedDirect /// </summary> /// <param name="categoryId">categoryId</param> /// <param name="companyId">companyId</param> public void DeletedDirect(int categoryId, int companyId) { SupportTicketCategoryGateway categoryGateway = new SupportTicketCategoryGateway(null); categoryGateway.Delete(categoryId, companyId); }
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; }
private string GetSummary() { int companyId = Int32.Parse(hdfCompanyId.Value); string summary = "GENERAL INFORMATION \n"; summary = summary + "\n Subject: " + hdfSubject.Value + "\n"; summary = summary + "\n Commnet: " + hdfComments.Value + "\n"; if (hdfDueDate.Value != "") { DateTime dueDate = DateTime.Parse(hdfDueDate.Value); string dueDateText = dueDate.Month.ToString() + "/" + dueDate.Day.ToString() + "/" + dueDate.Year.ToString(); summary = summary + "\n Due Date: " + dueDateText + "\n"; } int categoryId = Int32.Parse(hdfCategoriesSelected.Value); SupportTicketCategoryGateway supportTicketCategoryGateway = new SupportTicketCategoryGateway(); supportTicketCategoryGateway.LoadByCategoryId(categoryId, companyId); summary = summary + "\n Category: " + supportTicketCategoryGateway.GetName(categoryId) + "\n"; // Assign Dan Anzovino summary = summary + "\nASSIGMENT INFORMATION \n"; summary = summary + "\n Assigned team member: Dan Anzovino \n"; // ... Assignation information //if ((rbtnAssignToMyself.Checked) || (rbtnAssignToTeamMember.Checked)) //{ // summary = summary + "\nASSIGMENT INFORMATION \n"; // // ... ... Assigned Personal // if (hdfAssignToTeamMember.Value == "True") // { // summary = summary + "\n Assigned team member: " + hdfTeamMemberFullName.Value + "\n"; // } // // ... ... Asssigned to myself // if (hdfAssignToMyself.Value == "True") // { // summary = summary + "\n Assigned to myself: YES \n"; // } //} return summary; }
private void GetNodeForCategories(TreeNodeCollection nodes, int parentId) { Int32 thisId; String thisName; SupportTicketCategoryGateway supportTicketCategoryGateway = new SupportTicketCategoryGateway(null); DataRow[] children = supportTicketCategoriesTDS.Tables["LFS_ITTST_CATEGORY"].Select("ParentID='" + parentId + "'"); //no child nodes, exit function if (children.Length == 0) return; foreach (DataRow child in children) { // step 1 thisId = Convert.ToInt32(child.ItemArray[0]); // step 2 thisName = Convert.ToString(child.ItemArray[1]); // step 3 TreeNode newNode = new TreeNode(thisName, thisId.ToString()); newNode.ShowCheckBox = true; newNode.SelectAction = TreeNodeSelectAction.None; //step 4 //if (supportTicketCategoryGateway.IsUsedInUnitCategory(Int32.Parse(hdfUnitId.Value), thisId)) //{ // newNode.Checked = true; //} // step 5 nodes.Add(newNode); newNode.ToggleExpandState(); // step 6 GetNodeForCategories(newNode.ChildNodes, thisId); } }
// ///////////////////////////////////////////////////////////////////////////////////////////////////// // // STEP5 - SUMMARY // // //////////////////////////////////////////////////////////////////////// // STEP5 - SUMMARY - METHODS // private void StepSummaryIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = "Summary"; hdfUpdate.Value = "yes"; if (rbtnAddCategory.Checked) tbxSummary.Text = "Operation: Add category"; if (rbtnDeleteCategory.Checked) tbxSummary.Text = "Operation: Delete category"; if (rbtnEditCategory.Checked) tbxSummary.Text = "Operation: Edit category"; if (!rbtnDeleteCategory.Checked) { if (arrayCategoriesSelected.Count > 0) { foreach (int categoryIdInArray in arrayCategoriesSelected) { SupportTicketCategoryGateway supportTicketcategoryGateway = new SupportTicketCategoryGateway(); supportTicketcategoryGateway.LoadByCategoryId(categoryIdInArray, int.Parse(hdfCompanyId.Value)); tbxSummary.Text += "\nParent category: " + supportTicketcategoryGateway.GetName(categoryIdInArray); } } else { tbxSummary.Text += "\nParent category: (Empty)"; } } if (!rbtnDeleteCategory.Checked) { tbxSummary.Text += "\nName: " + tbxName.Text; } else { foreach (int categoryIdInArray in arrayCategoriesSelected) { SupportTicketCategoryGateway supportTicketCategoryGateway = new SupportTicketCategoryGateway(); supportTicketCategoryGateway.LoadByCategoryId(categoryIdInArray, int.Parse(hdfCompanyId.Value)); tbxSummary.Text += "\nName: " + supportTicketCategoryGateway.GetName(categoryIdInArray); } } }