public void SendMailForCompletedToDo()
{
// Get mail information
string mailTo = "";
string nameTo = "";
string subject = "A to do list was completed.";
string body = "";
// MailtTo, nameTo
int createdBy = Int32.Parse(hdfCreatedById.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 to do list was completed. \n";
body = body + "\n Subject: "+ lblTitleSubjectName.Text;
body = body + "\n Created By: " + tbxCreatedBy.Text;
body = body + "\n Creation Date: " + tbxCreationDate.Text;
body = body + "\n Assigned User: "******"\n Due Date: " + tbxDueDate.Text;
body = body + "\n Unit / Equipment: " + tbxUnit.Text;
//Send Mail
SendMail(mailTo, subject, body);
}
public void SendMailTeamMember()
{
// Get mail information
string mailTo = "";
string nameTo = "";
string subject = "This proposal is promoted to project.";
string body = "";
foreach (ListItem lst in cbxlEmployee.Items)
{
int employeeId = int.Parse(lst.Value);
EmployeeGateway employeesGateway = new EmployeeGateway();
employeesGateway.LoadForMailsByEmployeeId(employeeId);
if (employeesGateway.Table.Rows.Count > 0)
{
// Assigned TeamMember
mailTo = employeesGateway.GetEMail(employeeId);
nameTo = employeesGateway.GetFirstName(employeeId) + " " + employeesGateway.GetLastName(employeeId);
}
}
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following project was promoted to active state. \n";
// ... for client and project
body = body + "\n " + lblTitleClientName.Text;
body = body + "\n Project: " + lblTitleProjectName.Text;
//Send Mail
SendMail(mailTo, subject, body);
}
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);
}
public void SendMailTeamMember()
{
// Get mail information
string mailTo = "";
string nameTo = "";
string subject = "You have assigned service requests.";
string body = "";
if (hdfAssignToTeamMember.Value == "True")
{
int employeeId = Int32.Parse(hdfTeamMemberId.Value);
EmployeeGateway employeesGateway = new EmployeeGateway();
employeesGateway.LoadForMailsByEmployeeId(employeeId);
if (employeesGateway.Table.Rows.Count > 0)
{
// Assigned TeamMember
mailTo = employeesGateway.GetEMail(employeeId);
nameTo = employeesGateway.GetFirstName(employeeId) + " " + employeesGateway.GetLastName(employeeId);
}
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following service request has been assigned to you. \n";
body = body + "\n Service Number: " + hdfServiceNumber.Value;
body = body + "\n Service Description: " + hdfServiceDescription.Value;
if (hdfDeadlineDate.Value != "")
{
DateTime deadlineDate = DateTime.Parse(hdfDeadlineDate.Value);
string deadlineDateText = deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString();
body = body + "\n Deadline date: " + deadlineDateText;
}
else
{
body = body + "\n Deadline date: ";
}
int registeredByLoginId = Convert.ToInt32(Session["loginID"]);
employeesGateway.LoadByLoginId(registeredByLoginId);
int registeredByEmployeeId = employeesGateway.GetEmployeIdByLoginId(registeredByLoginId);
if (employeesGateway.Table.Rows.Count > 0)
{
body = body + "\n Assigned By: " + employeesGateway.GetFirstName(registeredByEmployeeId) + " " + employeesGateway.GetLastName(registeredByEmployeeId);
}
//Send Mail
SendMail(mailTo, subject, body);
}
}
private void UpdateDatabase()
{
// Get ids
int companyId = Int32.Parse(hdfCompanyId.Value);
DB.Open();
DB.BeginTransaction();
try
{
// ... Update general todo list state
SupportTicketInformationBasicInformation supportTicketInformationBasicInformation = new SupportTicketInformationBasicInformation(supportTicketInformationTDS);
supportTicketInformationBasicInformation.Save(companyId);
// ... Save to do list details
SupportTicketInformationActivityInformation supportTicketInformationActivityInformation = new SupportTicketInformationActivityInformation(supportTicketInformationTDS);
supportTicketInformationActivityInformation.Save(companyId);
// ... Send mails
int createdBy = Int32.Parse(hdfCreatedById.Value);
string mailTo = "";
string nameTo = "";
// ... ... MailtTo, nameTo
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(createdBy);
mailTo = employeeGateway.GetEMail(createdBy);
nameTo = employeeGateway.GetFullName(createdBy);
SupportTicketInformationActivityInformation supportTicketInformationActivityInformationForMails = new SupportTicketInformationActivityInformation(supportTicketInformationTDS);
foreach (GridViewRow row in grdSupportTicket.Rows)
{
bool sendMail = bool.Parse(((Label)row.FindControl("lblSendMail")).Text);
if (sendMail)
{
string subject = "";
string body = "";
string comment = "";
string type_ = ((Label)row.FindControl("lblType")).Text;
switch (type_)
{
case "AssignUser":
// Get mail information
subject = "A usser was assigned to the following ticket.";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nA usser was assigned to the following ticket. \n";
body = body + "\n Subject: " + lblTitleSubjectName.Text;
body = body + "\n Created By: " + tbxCreatedBy.Text;
body = body + "\n Creation Date: " + tbxCreationDate.Text;
body = body + "\n Category: " + tbxCategoryName.Text;
string assignedUser = ((TextBox)row.FindControl("tbxUser")).Text;
body = body + "\n Assigned User: "******"\n Due Date: " + tbxDueDate.Text;
comment = ((TextBox)row.FindControl("tbxComments")).Text;
body = body + "\n New comment: " + comment;
//Send Mail
SendMail(mailTo, subject, body);
break;
case "AssignToOwner":
// Get mail information
subject = "The following ticket was assigned to it's owner.";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following ticket was assigned to it's owner. \n";
body = body + "\n Subject: " + lblTitleSubjectName.Text;
body = body + "\n Owner: " + tbxCreatedBy.Text;
body = body + "\n Creation Date: " + tbxCreationDate.Text;
body = body + "\n Category: " + tbxCategoryName.Text;
string assignedOwer = ((TextBox)row.FindControl("tbxUser")).Text;
body = body + "\n Assigned To Owner: " + assignedOwer;
body = body + "\n Due Date: " + tbxDueDate.Text;
comment = ((TextBox)row.FindControl("tbxComments")).Text;
body = body + "\n New comment: " + comment;
//Send Mail
SendMail(mailTo, subject, body);
break;
case "AddComment":
// Get mail information
subject = "A comment was added to the following ticket.";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nA comment was added to the following ticket. \n";
body = body + "\n Subject: " + lblTitleSubjectName.Text;
body = body + "\n Created By: " + tbxCreatedBy.Text;
body = body + "\n Creation Date: " + tbxCreationDate.Text;
body = body + "\n Category: " + tbxCategoryName.Text;
body = body + "\n Assigned User: "******"\n Due Date: " + tbxDueDate.Text;
string commentAddedBy = ((TextBox)row.FindControl("tbxUser")).Text;
body = body + "\n Comment added by: " + commentAddedBy;
comment = ((TextBox)row.FindControl("tbxComments")).Text;
body = body + "\n New comment: " + comment;
//Send Mail
SendMail(mailTo, subject, body);
break;
case "CloseTicket":
// Get mail information
subject = "A support ticket was completed.";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following support ticket was completed. \n";
body = body + "\n Subject: " + lblTitleSubjectName.Text;
body = body + "\n Created By: " + tbxCreatedBy.Text;
body = body + "\n Creation Date: " + tbxCreationDate.Text;
body = body + "\n Category: " + tbxCategoryName.Text;
body = body + "\n Assigned User: "******"\n Due Date: " + tbxDueDate.Text;
string completedBy = ((TextBox)row.FindControl("tbxUser")).Text;
body = body + "\n Completed by: " + completedBy;
comment = ((TextBox)row.FindControl("tbxComments")).Text;
body = body + "\n New comment: " + comment;
//Send Mail
SendMail(mailTo, subject, body);
break;
case "OnHold":
// Get mail information
subject = "The following ticket was put on hold.";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following ticket was put on hold. \n";
body = body + "\n Subject: " + lblTitleSubjectName.Text;
body = body + "\n Created By: " + tbxCreatedBy.Text;
body = body + "\n Creation Date: " + tbxCreationDate.Text;
body = body + "\n Category: " + tbxCategoryName.Text;
body = body + "\n Assigned User: "******"\n Due Date: " + tbxDueDate.Text;
string onHoldBy = ((TextBox)row.FindControl("tbxUser")).Text;
body = body + "\n On hold by: " + onHoldBy;
comment = ((TextBox)row.FindControl("tbxComments")).Text;
body = body + "\n New comment: " + comment;
//Send Mail
SendMail(mailTo, subject, body);
break;
}
}
}
DB.CommitTransaction();
// Store datasets
supportTicketInformationTDS.AcceptChanges();
Session["supportTicketInformationTDS"] = supportTicketInformationTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private void SendMailEmployee(string newState)
{
if (newState == "Rejected")
{
// Update grid rows
foreach (GridViewRow row in grdVacations.Rows)
{
int requestId = Int32.Parse(grdVacations.DataKeys[row.RowIndex].Values["RequestID"].ToString());
if (((CheckBox)row.FindControl("cbxSelected")).Checked)
{
string rejectReason = ((TextBox)row.FindControl("tbxRejectReason")).Text;
// Get mail information
string mailTo = "";
string nameTo = "";
string body = "";
string subject = "";
VacationsInformationRequestsInformationGateway vacationsInformationRequestsInformationGateway = new VacationsInformationRequestsInformationGateway(vacationsInformationTDS);
int employeeId = vacationsInformationRequestsInformationGateway.GetEmployeeID(requestId);
int rejectedById = (int)ViewState["rejected_by_id"];
EmployeeGateway employeesGateway = new EmployeeGateway();
employeesGateway.LoadByEmployeeId(employeeId);
if (employeesGateway.Table.Rows.Count > 0)
{
// Assigned TeamMember
mailTo = employeesGateway.GetEMail(employeeId);
nameTo = employeesGateway.GetFirstName(employeeId) + " " + employeesGateway.GetLastName(employeeId);
}
subject = "Vacation request from " + vacationsInformationRequestsInformationGateway.GetStartDate(requestId).ToShortDateString() + " to " + vacationsInformationRequestsInformationGateway.GetEndDate(requestId).ToShortDateString();
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following vacation request has been rejected: \n\n";
body = body + "\t - Vacation request from " + vacationsInformationRequestsInformationGateway.GetStartDate(requestId).ToShortDateString() + " to " + vacationsInformationRequestsInformationGateway.GetEndDate(requestId).ToShortDateString() + "\n";
body = body + "\t - Detail: " + vacationsInformationRequestsInformationGateway.GetDetails(requestId) + "\n";
body = body + "\t - Comment: " + rejectReason;
EmployeeGateway employeeRejected = new EmployeeGateway();
employeeRejected.LoadByEmployeeId(rejectedById);
if (employeeRejected.Table.Rows.Count > 0)
{
body = body + "\n" + "\t - Rejected by: " + employeeRejected.GetFirstName(rejectedById) + " " + employeeRejected.GetLastName(rejectedById);
}
//Send Mail
SendMail(mailTo, subject, body);
}
}
}
}
private void SendMailTeamMember()
{
// Get mail information
string mailTo = "";
string nameTo = "";
string subject = "You have assigned service requests.";
string body = "";
int employeeId = Int32.Parse(ddlPnlAssignAssignToTeamMember.SelectedValue);
EmployeeGateway employeesGateway = new EmployeeGateway();
employeesGateway.LoadForMailsByEmployeeId(employeeId);
if (employeesGateway.Table.Rows.Count > 0)
{
// Assigned TeamMember
mailTo = employeesGateway.GetEMail(employeeId);
nameTo = employeesGateway.GetFirstName(employeeId) + " " + employeesGateway.GetLastName(employeeId);
}
int serviceId = Int32.Parse(hdfServiceId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
int companyLevel = Int32.Parse(hdfCompanyLevel.Value);
ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway(serviceInformationTDS);
serviceInformationBasicInformationGateway.LoadByServiceId(serviceId, companyId);
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe following service request has been assigned to you. \n";
body = body + "\n Unit: " + serviceInformationBasicInformationGateway.GetUnitCode(serviceId) + " - " + serviceInformationBasicInformationGateway.GetUnitDescription(serviceId) + "\n";
body = body + "\n Fixed Date: ";
if (serviceInformationBasicInformationGateway.GetMtoDto(serviceId)) body = body + "Yes "; else body = body + "No ";
string unitType = hdfUnitType.Value;
if (unitType == "Vehicle")
{
body = body + "\n Mileage: " + serviceInformationBasicInformationGateway.GetMileage(serviceId) + " " + hdfMileageUnitOfMeasurement.Value;
}
body = body + "\n Problem Description: " + serviceInformationBasicInformationGateway.GetServiceDescription(serviceId);
if (tkrdpPnlAssignDeadlineDate.SelectedDate.HasValue)
{
DateTime deadlineDate = tkrdpPnlAssignDeadlineDate.SelectedDate.Value;
string deadlineDateText = deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString();
body = body + " \n Deadline date: " + deadlineDateText;
}
else
{
body = body + " \n Deadline date: ";
}
int registeredByLoginId = Convert.ToInt32(Session["loginID"]);
employeesGateway.LoadByLoginId(registeredByLoginId);
int registeredByEmployeeId = employeesGateway.GetEmployeIdByLoginId(registeredByLoginId);
if (employeesGateway.Table.Rows.Count > 0)
{
body = body + "\n Assigned By: " + employeesGateway.GetFirstName(registeredByEmployeeId) + " " + employeesGateway.GetLastName(registeredByEmployeeId);
}
//Send Mail
SendMail(mailTo, subject, body);
}
private void SendMailEmployees(DataRow[] drEmployees)
{
// Get mail information
string mailTo = "";
string nameTo = "";
string body = "";
string subject = "";
List<int> employeeIds = new List<int>();
int lastEmployeeId = 0;
int lastApprovedById = 0;
foreach (DataRow row in drEmployees)
{
lastEmployeeId = ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).EmployeeID;
lastApprovedById = ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).ApprovedByID;
if (!employeeIds.Contains(lastEmployeeId))
{
employeeIds.Add(lastEmployeeId);
if (body.Length > 0)
{
EmployeeGateway employeeApproved = new EmployeeGateway();
employeeApproved.LoadByEmployeeId(lastApprovedById);
if (employeeApproved.Table.Rows.Count > 0)
{
body = body + "\n\nApproved by " + employeeApproved.GetFirstName(lastApprovedById) + " " + employeeApproved.GetLastName(lastApprovedById);
}
//Send Mail
SendMail(mailTo, subject, body);
mailTo = "";
nameTo = "";
subject = "";
body = "";
}
EmployeeGateway employeesGateway = new EmployeeGateway();
employeesGateway.LoadByEmployeeId(lastEmployeeId);
if (employeesGateway.Table.Rows.Count > 0)
{
// Assigned TeamMember
mailTo = employeesGateway.GetEMail(lastEmployeeId);
nameTo = employeesGateway.GetFirstName(lastEmployeeId) + " " + employeesGateway.GetLastName(lastEmployeeId);
subject = "Project Times Approved";
// Mails body
body = body + "\nHi " + nameTo + ",\n\nThe followings project time has been approved: \n\n";
if (!((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).IsStartTimeNull() && !((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).IsEndTimeNull())
{
body = body + "\t - Project Time for " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).Date_.ToShortDateString() + ", Start Time: " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).StartTime.ToShortTimeString() + ", End Time: " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).EndTime.ToShortTimeString() + "\n";
}
else
{
body = body + "\t - Project Time for " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).Date_.ToShortDateString() + ", " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).WorkingDetails;
}
}
}
else
{
if (!((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).IsStartTimeNull() && !((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).IsEndTimeNull())
{
body = body + "\t - Project Time for " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).Date_.ToShortDateString() + ", Start Time: " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).StartTime.ToShortTimeString() + ", End Time: " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).EndTime.ToShortTimeString() + "\n";
}
else
{
body = body + "\t - Project Time for " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).Date_.ToShortDateString() + ", " + ((ProjectTimeTDS.LFS_PROJECT_TIMERow)row).WorkingDetails;
}
}
}
if (body.Length > 0)
{
EmployeeGateway employeeApproved = new EmployeeGateway();
employeeApproved.LoadByEmployeeId(lastApprovedById);
if (employeeApproved.Table.Rows.Count > 0)
{
body = body + "\n\nApproved by " + employeeApproved.GetFirstName(lastApprovedById) + " " + employeeApproved.GetLastName(lastApprovedById);
}
//Send Mail
SendMail(mailTo, subject, body);
mailTo = "";
nameTo = "";
subject = "";
body = "";
}
}