private void SaveHeader_Click(object sender, EventArgs e)
{
if (HeaderTitleText.Text.Length <= 0)
{
MessageBox.Show("Please fill in the title");
return;
}
_header.Title = HeaderTitleText.Text;
_header.Desc = HeaderDescText.Text;
MySql sql = new MySql();
sql.OpenConnection();
if (sql.SaveHeader(_header))
{
MessageBox.Show("Header Successfully Saved");
this.DialogResult = DialogResult.OK;
sql.CloseConnection();
Close();
}
sql.CloseConnection();
}
public GenerateFeedback()
{
InitializeComponent();
SectionTable.VerticalScroll.Enabled = false;
ContentTable.VerticalScroll.Enabled = true;
SectionTable.HorizontalScroll.Enabled = false;
AddSectionBtn.Visible = false;
SetTemplateBtn.Enabled = false;
SaveTemplateBtn.Enabled = false;
ContentTable.Padding = new Padding(0, 0, SystemInformation.VerticalScrollBarWidth, 0);
MySql sql = new MySql();
sql.OpenConnection();
ApplicantList.ValueMember = "Name";
//get the list of position from the database
List <Position> positions = sql.GetPositions();
foreach (Position p in positions)
{
PositionList.Items.Add(p);
}
PositionList.ValueMember = "_positionName";
sql.CloseConnection();
}
public HeaderItemDisplay(string id)
{
InitializeComponent();
MySql sql = new MySql();
sql.OpenConnection();
_header = sql.GetHeader(id);
_header.HeaderItems.Clear();
List <HeaderItem> items = sql.GetHeaderItems(id);
foreach (HeaderItem item in items)
{
_header.addHeaderItem(item);
}
HeaderTitleText.Text = _header.Title;
HeaderDescText.Text = _header.Desc;
ItemDVG.DataSource = _header.HeaderItems;
for (int a = 0; a < ItemDVG.ColumnCount - 2; a++)
{
ItemDVG.Columns[a].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
ItemDVG.Columns[ItemDVG.ColumnCount - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
sql.CloseConnection();
SaveHeader.Click -= SaveHeader_Click;
SaveHeader.Click += UpdateHeader_Click;
SaveHeader.Text = "Update Header";
}
//constructor used to initialise the template with the passed in id
public TemplateCreator(string id)
{
InitializeComponent();
MySql sql = new MySql();
sql.OpenConnection();
_currentTemplate = sql.GetTemplate(id);
TitleText.Text = _currentTemplate.Title;
DescText.Text = _currentTemplate.Desc;
//place in the header
HeaderPlacement place = new HeaderPlacement();
HeaderPanel.Controls.Clear();
foreach (HeaderItem item in _currentTemplate.Header.HeaderItems)
{
place.AddItem(item);
}
HeaderPanel.Controls.Add(place);
ChangeHeader.Enabled = true;
HorizontalLine.Visible = true;
TextLabel.Visible = true;
Sections.UpdateSelectedSections(_currentTemplate.Sections);
sql.CloseConnection();
SaveTemplate.Text = "Update Template";
isUpdate = true;
}
private void UpdateBtn_Click(object sender, EventArgs e)
{
string id = Dgv.SelectedRows[0].Cells[0].Value.ToString();
if (!String.IsNullOrEmpty(RowTitleText.Text))
{
MySql sql = new MySql();
sql.OpenConnection();
if (sql.EditComponent(ControlType, id, RowTitleText.Text, RowDescText.Text))
{
MessageBox.Show("Successfully Updated!\n For advanced updates please click the Edit " + ControlType + " button. ");
}
else
{
MessageBox.Show("No updates detected!\n For advanced updates please click the Edit " + ControlType + " button. ");
}
sql.CloseConnection();
}
else
{
MessageBox.Show(ControlType + " Title must not be empty!", "Missing attributes");
return;
}
setDgv();
RowTitleText.Clear();
RowDescText.Clear();
UpdateBtn.Visible = false;
}
private void setHeader()
{
using (SelectControl form = new SelectControl("Header"))
{
var result = form.ShowDialog();
if (result == DialogResult.OK)
{
MySql sql = new MySql();
sql.OpenConnection();
_currentFeed.Header = sql.GetHeader(form._ids[0]);
_currentFeed.Header.HeaderItems = sql.GetHeaderItems(_currentFeed.Header.HeaderId);
FillHeader();
sql.CloseConnection();
}
else
{
/*
* To prevent the continuation of the method calls to setSection in setTemplate
* when the user did not select any header (direct close window)
*/
throw new Exception();
}
}
}
private void PositionList_SelectedIndexChanged(object sender, EventArgs e)
{
if (PositionList.SelectedIndex != -1)
{
ChangeHeader.Visible = false;
AddSectionBtn.Visible = false;
SetTemplateBtn.Enabled = false;
SaveTemplateBtn.Enabled = false;
MySql sql = new MySql();
sql.OpenConnection();
Position pos = (Position)PositionList.SelectedItem;
_currentFeed.Position = pos;
List <Applicant> app = sql.GetAppByPosition(pos._positionId);
ApplicantList.Items.Clear();
foreach (Applicant p in app)
{
ApplicantList.Items.Add(p);
}
sql.CloseConnection();
_currentFeed.Applicant = null;
_currentFeed.Header = null;
_currentFeed.Sections.Clear();
ContentTable.Controls.Remove(ContentTable.GetControlFromPosition(0, 0));
SectionTable.Controls.Clear();
PDFDisplay.DocumentText = "";
SaveFeedbackBtn.Text = "Save Feedback";
}
}
private void SaveBtn_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(CodeBox.Text) || String.IsNullOrEmpty(SectionTitleText.Text))
{
MessageBox.Show(@"Title or Codes cannot be empty.");
}
else
{
MySql sql = new MySql();
sql.OpenConnection();
List <string> codes = new List <string>(CodeBox.Lines);
codes.RemoveAll(item => item.Length == 0);
_section.Title = SectionTitleText.Text;
_section.Desc = SectionDescText.Text;
_section.Codes = new List <string>();
_section.Codes.Clear();
_section.Codes.AddRange(codes);
if (!_update)
{
if (!sql.SaveSection(new Section(SectionTitleText.Text, SectionDescText.Text, codes)))
{
return;
}
MessageBox.Show("Section succesfully saved");
sql.CloseConnection();
//after the saving is done, go back to the home page showing the list of available sections
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
//This part updates the section
if (sql.UpdateSection(_section))
{
MessageBox.Show("Section successfully saved");
sql.CloseConnection();
DialogResult = DialogResult.OK;
Close();
}
}
}
} //end save button
private void SaveTemplateBtn_Click(object sender, EventArgs e)
{
if (TitleText.Text.Length <= 0)
{
MessageBox.Show("Please insert the title", "Missing Field");
return;
}
if (object.ReferenceEquals(_currentTemplate.Header, null))
{
MessageBox.Show("Please choose the header to be included in the template.", "Missing Header");
return;
}
_currentTemplate.Sections = Sections.SelectedSections;
if (_currentTemplate.Sections.Count <= 0)
{
MessageBox.Show("Please choose the sections to be included in the template.", "Missing Sections");
return;
}
//end of field checkers
MySql sql = new MySql();
sql.OpenConnection();
try
{
if (!isUpdate)
{
if (sql.SaveTemplate(_currentTemplate.Header, _currentTemplate.Sections, TitleText.Text, DescText.Text))
{
MessageBox.Show("Template successfully saved!");
}
}
else
{
if (sql.UpdateTemplate(_currentTemplate.Header, _currentTemplate.Sections, TitleText.Text, DescText.Text, _currentTemplate.Id))
{
MessageBox.Show("Template successfully updated!");
}
}
this.DialogResult = DialogResult.OK;
Close();
}
catch (Exception exc)
{
MessageBox.Show(exc.ToString(), "Ops! Error occured!");
}
finally
{
sql.CloseConnection();
}
}
public void Dispose()
{
if (!disposed)
{
if (database != null)
{
database.CloseConnection();
}
disposed = true;
}
}
private void SetDgv()
{
MySql sql = new MySql();
sql.OpenConnection();
DataTable Dt = new DataTable();
try
{
switch (ControlType)
{
case "Header":
Dt = sql.GetDataSet("SELECT header.HeaderID, header.Name, header.Desc, " +
"group_concat(headeritem.Title order by headercontains.PositionIndex ASC SEPARATOR \' | \') as Items " +
"FROM header, headeritem, headercontains " +
"WHERE header.Archived = 0 and header.HeaderID = headercontains.HeaderID AND headeritem.HeaderItemID = headercontains.HeaderItemID " +
"GROUP BY header.HeaderID ORDER BY header.HeaderID");
Dt.Columns["HeaderId"].ColumnName = "Header ID";
Dt.Columns["Desc"].ColumnName = "Description";
break;
case "Template":
Dt = sql.GetDataSet("SELECT template.TemplateID AS 'Template ID', template.TemplateTitle AS 'Template Title', " +
"template.TemplateDesc AS 'Template Description', header.Name as 'Header Name', " +
"GROUP_CONCAT(section.Title order by section.SectionID SEPARATOR ' | ') as Sections , " +
"CONCAT(reviewer.FirstName,' ', reviewer.LastName) AS 'Author Name' " +
"FROM template, template_section, reviewer, header, section " +
"WHERE template.Archived = 0 and template.TemplateID = template_section.TemplateID " +
"AND template_section.SectionID = section.SectionID " +
"AND template.HeaderID = header.HeaderID " +
"AND template.TemplateAuthor = reviewer.ReviewerID " +
"GROUP BY template.TemplateID " +
"ORDER BY template.TemplateID; ");
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Dgv.DataSource = Dt;
sql.CloseConnection();
for (int a = 0; a < Dgv.ColumnCount - 2; a++)
{
Dgv.Columns[a].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
Dgv.Columns[Dgv.ColumnCount - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void ConectarDataBaseBtn_Click(object sender, EventArgs e)
{
string connectionString = "Server=localhost;Database=mydb;Uid=root;Pwd=sebas1995;";
MySql mySql = new MySql();
mySql.ConnectionString = connectionString;
mySql.OpenConnection();
mySql.BeginTransaction();
dataGridView1.DataSource = mySql.QuerySQL("Select * from Clientes");
mySql.CommitTransaction();
mySql.CloseConnection();
MessageBox.Show("Conexión exitosa");
}
private void AddUserBtn_Click(object sender, EventArgs e)
{
try
{
if (FirstName.Text.Length <= 0)
{
throw new Exception();
}
if (LastName.Text.Length <= 0)
{
throw new Exception();
}
if (Password.Text.Length <= 0)
{
throw new Exception();
}
if (AdminPrivilege.SelectedIndex == -1)
{
throw new Exception();
}
if (EmailText.Text.Length <= 0)
{
throw new Exception();
}
}
catch (Exception)
{
MessageBox.Show("Please Complete all the information");
return;
}
bool admin = AdminPrivilege.SelectedItem.ToString().Equals("Yes");
MySql sql = new MySql();
sql.OpenConnection();
if (sql.AddUser(FirstName.Text, LastName.Text, Password.Text, admin, EmailText.Text))
{
MessageBox.Show("User Successfully Added");
sql.CloseConnection();
DialogResult = DialogResult.OK;
Close();
}
}
private void loginBtn_Click(object sender, EventArgs e)
{
MySql sql = new MySql();
sql.OpenConnection();
if (sql.VerifyPassword(username.Text, password.Text))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show(@"Invalid Username/Password", @"An Error has Occur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
sql.CloseConnection();
}
private void UpdateUserList()
{
MySql sql = new MySql();
sql.OpenConnection();
DataTable users =
sql.GetDataSet(
"SELECT ReviewerID, FirstName, LastName, Email, IF(AdminAccess = 1, \'yes\', \'no\') as AdminAccess FROM feedbacksystem.reviewer where Archived = 0;");
UserDGV.DataSource = users;
for (int a = 0; a < UserDGV.ColumnCount - 2; a++)
{
UserDGV.Columns[a].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
UserDGV.Columns[UserDGV.ColumnCount - 2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
sql.CloseConnection();
}
private void SaveTemplateBtn_Click(object sender, EventArgs e)
{
using (SaveBox save = new SaveBox())
{
var result = save.ShowDialog();
if (result == DialogResult.OK)
{
MySql sql = new MySql();
sql.OpenConnection();
if (sql.SaveTemplate(_currentFeed.Header, _currentFeed.Sections, save.Title, save.Desc))
{
MessageBox.Show("Template successfully saved");
}
sql.CloseConnection();
}
}
}
public SectionCreator(string id)
{
_update = true;
InitializeComponent();
MySql sql = new MySql();
sql.OpenConnection();
_section = sql.GetSection(id);
SectionTitleText.Text = _section.Title;
SectionDescText.Text = _section.Desc;
foreach (string c in _section.Codes)
{
CodeBox.AppendText(c + Environment.NewLine);
}
sql.CloseConnection();
}
private void AddHeaderBtn_Click(object sender, EventArgs e)
{
using (SelectControl form = new SelectControl("Header"))
{
var result = form.ShowDialog();
if (result == DialogResult.OK)
{
MySql sql = new MySql();
sql.OpenConnection();
Header selectedHeader = sql.GetHeader(form._ids[0]);
selectedHeader.HeaderItems.Clear();
foreach (HeaderItem i in sql.GetHeaderItems(selectedHeader.HeaderId))
{
selectedHeader.addHeaderItem(i);
}
sql.CloseConnection();
HeaderPlacement place = new HeaderPlacement();
HeaderPanel.Controls.Clear();
foreach (HeaderItem item in selectedHeader.HeaderItems)
{
place.AddItem(item);
}
HeaderPanel.Controls.Add(place);
ChangeHeader.Enabled = true;
HorizontalLine.Visible = true;
TextLabel.Visible = true;
_currentTemplate.Header = selectedHeader;
}
}
}
public SectionSelection()
{
InitializeComponent();
MySql sql = new MySql();
sql.OpenConnection();
AvailableSections = sql.GetSectionsList();
AvailableSectionDGV.DataSource = AvailableSections;
for (int a = 0; a < AvailableSectionDGV.ColumnCount - 2; a++)
{
AvailableSectionDGV.Columns[a].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
SelectedSectionDGV.Columns[a].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
AvailableSectionDGV.Columns[AvailableSectionDGV.ColumnCount - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
SelectedSectionDGV.Columns[AvailableSectionDGV.ColumnCount - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
sql.CloseConnection();
}
private void SaveUserBtn_Click(object sender, EventArgs e)
{
bool changePass = false;
try
{
if (FirstName.Text.Length <= 0)
{
throw new Exception();
}
if (LastName.Text.Length <= 0)
{
throw new Exception();
}
if (Password.Text.Length > 0)
{
changePass = true;
}
if (AdminPrivilege.SelectedIndex == -1)
{
throw new Exception();
}
}
catch (Exception)
{
MessageBox.Show("Please Complete all the information");
return;
}
bool admin = AdminPrivilege.SelectedItem.ToString().Equals("Yes");
MySql sql = new MySql();
sql.OpenConnection();
if (changePass)
{
if (!sql.EditUser(id, FirstName.Text, LastName.Text, admin, Password.Text))
{
return;
}
MessageBox.Show("User Information Successfully Changed");
sql.CloseConnection();
DialogResult = DialogResult.OK;
Close();
}
else
{
if (!sql.EditUser(id, FirstName.Text, LastName.Text, admin))
{
return;
}
MessageBox.Show("User Information Successfully Changed");
sql.CloseConnection();
DialogResult = DialogResult.OK;
Close();
}
}
protected void Page_Unload(object sender, EventArgs e)
{
mysqlconnection.CloseConnection();
}
private void SetTemplateBtn_Click(object sender, EventArgs e)
{
var result = MessageBox.Show("[Yes] To load template.\n[No] To select header and sections separately."
, "Choose Loading Method", MessageBoxButtons.YesNoCancel);
if (result == DialogResult.Cancel)
{
return;
}
else
{
if (result == DialogResult.Yes)
{
ChangeHeader.Visible = false;
AddSectionBtn.Visible = false;
SaveTemplateBtn.Enabled = false;
using (SelectControl form = new SelectControl("Template"))
{
var selectResult = form.ShowDialog();
if (selectResult == DialogResult.OK)
{
MySql sql = new MySql();
sql.OpenConnection();
string sqlStatement = "select * from template where TemplateID = @id";
MySqlCommand cmd = new MySqlCommand(sqlStatement);
cmd.Parameters.AddWithValue("@id", form._ids[0]);
DataTable template = sql.GetDataSetCmd(cmd);
_currentFeed.Header = sql.GetHeader(template.Rows[0][1].ToString());
_currentFeed.Header.HeaderItems = sql.GetHeaderItems(_currentFeed.Header.HeaderId);
_currentFeed.Template = sql.GetTemplate(form._ids[0]);
FillHeader();
_currentFeed.Sections.Clear();
cmd.Parameters.Clear();
sqlStatement = "SELECT * FROM template_section WHERE TemplateID = @id";
cmd = new MySqlCommand(sqlStatement);
cmd.Parameters.AddWithValue("@id", form._ids[0]);
DataTable templateSections = sql.GetDataSetCmd(cmd);
foreach (DataRow row in templateSections.Rows)
{
_currentFeed.Sections.Add(sql.GetSection(row["SectionID"].ToString()));
}
FillSection();
sql.CloseConnection();
}
}
}
else //Will default to select header and sections
{
try
{
setHeader();
ChangeHeader.Visible = true;
setSection();
AddSectionBtn.Visible = true;
AddSectionBtn.Text = "Change Section";
SaveTemplateBtn.Enabled = true;
} catch (Exception ex)
{
return;
}
}
}
}
private void ApplicantList_SelectedIndexChanged(object sender, EventArgs e)
{
SaveTemplateBtn.Enabled = false;
ChangeHeader.Visible = false;
AddSectionBtn.Visible = false;
if (ApplicantList.SelectedIndex != -1)
{
PDFDisplay.DocumentText = "<HTML><CENTER>Loading...</CENTER></HTML>";
Applicant app = (Applicant)ApplicantList.SelectedItem;
_currentFeed.Applicant = app;
if (app.Pdf != null)
{
string tempFile = TempFileHandler.MakeTempFile(app.Pdf);
PDFDisplay.Navigate(tempFile);
}
else
{
PDFDisplay.DocumentText = "<HTML><CENTER>No PDF found</CENTER></HTML>";
}
MySql sql = new MySql();
sql.OpenConnection();
DataTable Dt = sql.GetDataSet("SELECT * FROM feedbacksystem.feedback WHERE feedback.PositionID = " + _currentFeed.Position._positionId + " AND feedback.AppID = " + _currentFeed.Applicant.Id);
if (Dt != null && Dt.Rows.Count > 0)
{
Feedback tmpFeedback = sql.GetFeedback(Dt.Rows[0]["FeedbackID"].ToString());
_currentFeed.FeedbackID = Dt.Rows[0]["FeedbackID"].ToString();
_currentFeed.Header = tmpFeedback.Header;
_currentFeed.Sections = tmpFeedback.Sections;
FillHeader();
FillSection();
ChangeHeader.Visible = !CheckPositionIsCompleted();
AddSectionBtn.Visible = !CheckPositionIsCompleted();
SaveFeedbackBtn.Text = "Update Feedback";
}
else
{
SaveFeedbackBtn.Text = "Save Feedback";
_currentFeed.FeedbackID = "";
if (_currentFeed.Header != null)
{
_currentFeed.Header.HeaderItems.Clear();
//in order to reset the header items value for the cascading
_currentFeed.Header.HeaderItems = sql.GetHeaderItems(_currentFeed.Header.HeaderId);
ChangeHeader.Visible = true;
FillHeader();
}
if (_currentFeed.Sections.Count > 0)
{
foreach (Section sec in _currentFeed.Sections)
{
sec.Comment = null;
sec.CodeChosen = null;
sec.IsChecked = false;
}
AddSectionBtn.Visible = true;
FillSection();
}
}
sql.CloseConnection();
SetTemplateBtn.Enabled = !CheckPositionIsCompleted();
}
}
private void SaveFeedbackBtn_Click(object sender, EventArgs e)
{
if (PositionList.SelectedIndex == -1)
{
MessageBox.Show("Select a position", "Missing attributes!");
return;
}
if (ApplicantList.SelectedIndex == -1)
{
MessageBox.Show("Select an applicant", "Missing attributes!");
return;
}
if (_currentFeed.Header == null)
{
MessageBox.Show("Please select the header before proceeding", "Missing component!");
return;
}
if (_currentFeed.Sections.Count <= 0)
{
MessageBox.Show("Please select the sections before proceeding", "Missing component!");
return;
}
_currentFeed.ReviewerId = Reviewer.Id.ToString();
//check if there are null values in the header
foreach (HeaderItem item in _currentFeed.Header.HeaderItems)
{
Control control = Controls.Find("header" + item.Id, true)[0];
try
{
switch (control.GetType().Name)
{
case "TextBox":
case "Label":
item.ValueChosen = ((TextBox)control).Text;
break;
case "ComboBox":
item.ValueChosen = ((ComboBox)control).SelectedItem.ToString();
break;
case "DateTimePicker":
item.ValueChosen = ((DateTimePicker)control).Value.ToString("dd/MM/yyyy");
break;
}
if (item.ValueChosen.Length <= 0)
{
throw new NullReferenceException();
}
}
catch (NullReferenceException)
{
MessageBox.Show("Please complete the header before proceeding", "Missing attributes!");
return;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error!");
return;
}
}
bool sectionChecked = false;
//check if there is null values in the sections
foreach (Section s in _currentFeed.Sections)
{
RichTextBox text = (RichTextBox)Controls.Find("comment" + s.SectionId, true)[0];
ComboBox codes = (ComboBox)Controls.Find("codes" + s.SectionId, true)[0];
CheckBox checker = (CheckBox)Controls.Find("checker" + s.SectionId, true)[0];
if (codes.SelectedIndex == -1)
{
MessageBox.Show("Please complete the sections before proceeding -> Codes", "Missing attributes!");
return;
}
//Assign values to section object
s.Comment = text.Text;
s.CodeChosen = codes.SelectedItem.ToString();
s.IsChecked = checker.Checked;
if (s.Comment.Length <= 0)
{
MessageBox.Show("Please complete the sections before proceeding -> Comment", "Missing attributes!");
return;
}
if (s.IsChecked)
{
sectionChecked = true;
}
}
if (!sectionChecked)
{
MessageBox.Show("Please check at least one section!", "Missing attributes!");
return;
}
//end of field checkers
MySql sql = new MySql();
sql.OpenConnection();
try
{
//update or insert the feedback
if (String.IsNullOrEmpty(_currentFeed.FeedbackID))
{
if (sql.SaveFeedback(_currentFeed))
{
MessageBox.Show("Feedback successfully saved.");
}
}
else
{
if (sql.UpdateFeedback(_currentFeed))
{
MessageBox.Show("Feedback successfully updated.");
}
}
//checks whether is all the applications for the position is completed
if (CheckPositionIsCompleted()) //means all of the applications have generated the feedback
{
var result = MessageBox.Show("All the feedbacks for this current position: " + _currentFeed.Position._positionName + " is completed. \n Please choose the file name of the attachehment to be send to the applicants. \n Yes for Applicant name or No for Applicant code"
, "Select file name", MessageBoxButtons.YesNo);
//true for name false for code
bool filename = (result == DialogResult.Yes ? true : false);
try
{
int count = 0;
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
foreach (Applicant app in sql.GetEmailList(_currentFeed.Position._positionId))
{
string currentFilename = (filename ? app.Name : app.Id);
MailMessage mail = new MailMessage(new MailAddress("*****@*****.**"), new MailAddress(app.Email));
mail.Subject = "Application feedback for " + _currentFeed.Position._positionName + " in HappyTech.";
mail.Body = "Hi " + app.Name + ",\nPlease find the attached file as the feedback from us regarding your application at HappyTech. \n\nRegards,\nHappy Tech HR";
System.Net.Mail.Attachment attachment;
attachment = new System.Net.Mail.Attachment(TempFileHandler.MakeTempFilePdf(app.Pdf, currentFilename));
mail.Attachments.Add(attachment);
SmtpServer.Port = 587;
SmtpServer.DeliveryMethod = SmtpDeliveryMethod.Network;
SmtpServer.UseDefaultCredentials = false;
SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "happytech123");
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);
count++;
}
MessageBox.Show("Total of " + count + " emails are sent.");
} catch (Exception exc)
{
throw exc;
}
}
}
catch (Exception exc)
{
MessageBox.Show(exc.ToString(), "Ops! Error occured!");
}
finally
{
sql.CloseConnection();
}
}
