protected void Page_Load(object sender, EventArgs e)
{
//Only vantagedata users should have access to full list of users
if (Request.IsAuthenticated)
{
//Only vantagedata users should have access to full list of users
c_helpdesk hd = new c_helpdesk();
string userid = HttpContext.Current.User.Identity.GetUserId();
string user_email = hd.GetEmailByUserID(userid);
//if (user_email.ToUpper().Contains("VANTAGEDATA"))
//{
// Response.Redirect("~/Pages/hd/IssueList.aspx");
//}
//else
//{
// //Redirect to Capture New Request Page
// Response.Redirect("~/Pages/hd/Main.aspx");
//}
Response.Redirect("~/Pages/hd/IssueList.aspx");
}
else
{
Response.Redirect("~/Account/Login.aspx");
}
}
private void LoadTeamsByCompanyID(int companyid)
{
c_helpdesk hd = new c_helpdesk();
DataSet dsTeams = hd.GetTeamsByCompanyID(companyid);
ddlTeam.DataSource = dsTeams.Tables[0];
ddlTeam.DataBind();
}
private void LoadUsers()
{
c_helpdesk hd = new c_helpdesk();
DataSet dsUsers = hd.GetAllUsers();
ddlUser.DataSource = dsUsers.Tables[0];
ddlUser.DataBind();
}
protected void butUpdate_Click(object sender, EventArgs e)
{
c_helpdesk hd = new c_helpdesk();
hd.AddIssueHistory(Convert.ToInt32(hidIssueID.Value), txtDesc.Text, Convert.ToInt32(ddlSite.SelectedValue), Convert.ToInt32(ddlCompany.SelectedValue),
ddlAccountManager.SelectedValue, ddlCurrentOwner.SelectedValue, txtComments.Text, Convert.ToInt32(ddlStatus.SelectedValue), User.Identity.GetUserId(), ddlPriority.SelectedItem.Text);
//Get Account Manager's email
string account_manager = "";
if (ddlAccountManager.SelectedIndex > 0)
{
account_manager = ddlAccountManager.SelectedValue;
}
string account_manager_email = "";
if (account_manager != "")
{
account_manager_email = hd.GetEmailByUserID(account_manager);
}
//Send email to assigned user
//Only send an email to assigned user if the user has changed. We track this through Viewstate
string current_owner = ViewState["currentowner"].ToString();
if (ddlCurrentOwner.SelectedValue != current_owner)
{
string new_owner = ddlCurrentOwner.SelectedValue;
//get email by userid
string owner_email = hd.GetEmailByUserID(new_owner);
string status = ddlStatus.SelectedItem.Text;
if (owner_email != "")
{
//Send email
SendMailHelpdesk("", Convert.ToInt32(hidIssueID.Value), "issue", txtComments.Text, 0, owner_email, "Vantage Helpdesk", ddlCurrentOwner.SelectedItem.Text, status, account_manager_email);
}
}
else if (ddlStatus.SelectedItem.Text.ToUpper() == "COMPLETED")
{
//Get email of user who created the issue
string userid = ViewState["userid"].ToString();
string user_email = hd.GetEmailByUserID(userid);
//Send Completion Email
if (user_email != "")
{
SendMailHelpdesk("", Convert.ToInt32(hidIssueID.Value), "issue", txtComments.Text, 0, user_email, "Vantage Helpdesk", ddlCurrentOwner.SelectedItem.Text, "COMPLETED", account_manager_email);
}
}
txtComments.Text = "";
gvIssues.DataBind();
}
protected void butUpdate_Click(object sender, EventArgs e)
{
c_helpdesk hd = new c_helpdesk();
hd.AddFeedbackHistory(Convert.ToInt32(hidFeedbackID.Value), txtDesc.Text, Convert.ToInt32(ddlSite.SelectedValue),
ddlAccountManager.SelectedValue, ddlCurrentOwner.SelectedValue, txtComments.Text, Convert.ToInt32(ddlStatus.SelectedValue), User.Identity.GetUserId(), ddlPriority.SelectedItem.Text);
txtComments.Text = "";
gvFeedback.DataBind();
}
private void SaveUserTeamMapping()
{
c_helpdesk hd = new c_helpdesk();
if (ddlUser.SelectedIndex > -1 && ddlTeam.SelectedIndex > -1)
{
string user_id = ddlUser.SelectedItem.Value.ToString();
int team_id = Convert.ToInt32(ddlTeam.SelectedItem.Value);
hd.AddUserMapping(user_id, team_id);
}
}
private void LoadUserMappings()
{
try
{
c_helpdesk hd = new c_helpdesk();
DataView dvUserMappings = hd.GetUserMapping();
gvUserMapping.DataSource = dvUserMappings;
gvUserMapping.DataBind();
}
catch (Exception ex)
{
throw(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.IsAuthenticated)
{
//Only vantagedata users should have access to full list of users
c_helpdesk hd = new c_helpdesk();
string userid = HttpContext.Current.User.Identity.GetUserId();
string user_email = hd.GetEmailByUserID(userid);
if (user_email.ToUpper().Contains("VANTAGEDATA") && !user_email.ToUpper().Contains("DEMO"))
{
mnuAdmin.Visible = true;
}
else
{
mnuAdmin.Visible = false;
}
//if (user_email.ToUpper().Contains("VANTAGEDATA"))
//{
// mnuIssue.Visible = true;
// mnuFeedback.Visible = true;
//}
//else
//{
// mnuIssue.Visible = false;
// mnuFeedback.Visible = false;
//}
mnuCapture.Visible = true;
}
else
{
mnuIssue.Visible = false;
mnuFeedback.Visible = false;
mnuCapture.Visible = false;
mnuAdmin.Visible = false;
}
string url = System.Web.HttpContext.Current.Request.Url.AbsoluteUri;
if (url.ToLower().Contains("/login"))
{
imgLogo.Visible = false;
}
else
{
imgLogo.Visible = true;
}
}
private void LoadCompanies()
{
c_helpdesk hd = new c_helpdesk();
DataSet dsCompanies = hd.GetAllCompanies();
ddlCompany.DataSource = dsCompanies.Tables[0];
ddlCompany.DataBind();
//Load Teams based on company id
if (ddlCompany.SelectedIndex > -1)
{
int companyid = Convert.ToInt32(ddlCompany.SelectedItem.Value);
LoadTeamsByCompanyID(companyid);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Request.IsAuthenticated)
{
Response.Redirect("~/Account/Login.aspx");
}
if (!Page.IsPostBack)
{
c_helpdesk hd = new c_helpdesk();
string userid = HttpContext.Current.User.Identity.GetUserId();
string user_email = hd.GetEmailByUserID(userid);
//Get user details
DataView dv = new DataView();
dv = hd.GetUserDetails(userid);
if (dv.Table.Rows.Count > 0)
{
string team_ids = "";
foreach (DataRow row in dv.Table.Rows)
{
if (!user_email.ToUpper().Contains("VANTAGEDATA") || user_email.ToUpper().Contains("DEMO"))
{
Session["team_id"] = row["team_id"].ToString();
team_ids = team_ids + row["team_id"].ToString() + ",";
}
else
{
Session["team_id"] = null;
}
//Get user id of user who created the issue
ViewState["teamid"] = dv.Table.Rows[0]["team_id"].ToString();
ViewState["companyid"] = dv.Table.Rows[0]["company_id"].ToString();
}
}
if (user_email.ToUpper().Contains("VANTAGEDATA") && !user_email.ToUpper().Contains("DEMO"))
{
ViewState["vantageuser"] = "******";
}
else
{
ViewState["vantageuser"] = "******";
}
LoadInit();
}
}
private void SendHelpdeskRequest()
{
try
{
c_helpdesk hd = new c_helpdesk();
string user_id = User.Identity.GetUserId();
string user_name = User.Identity.Name;
var manager = Context.GetOwinContext().GetUserManager <ApplicationUserManager>();
var user = manager.FindById(user_id);
string email_to = user.Email;
string hd_type = "";
int hd_id = 0;
string hd_comment = txtComments.Text.Trim();
int hd_site_id = Convert.ToInt32(ddlSite.SelectedItem.Value);
if (ddlFeedbackIssue.SelectedItem.Value == "feedback")
{
hd_type = ddlFeedbackIssue.SelectedItem.Value;
hd_id = hd.GetNextFeedbackID();
hd.AddFeedback(hd_comment, user_id, user_name, hd_site_id);
}
else if (ddlFeedbackIssue.SelectedItem.Value == "issue")
{
hd_type = ddlFeedbackIssue.SelectedItem.Value;
hd_id = hd.GetNextIssueID();
hd.AddIsse(hd_comment, 1, user_id, user_name, hd_site_id);
}
SendMailHelpdesk(user_id, hd_id, hd_type, hd_comment, hd_site_id, email_to, ddlSite.SelectedItem.Text, user_name);
Response.Redirect("Thankyou.aspx");
}
catch (Exception ex)
{
throw(ex);
}
}
private void BindData()
{
c_helpdesk hd = new c_helpdesk();
string userId = User.Identity.GetUserId();
string user_email = hd.GetEmailByUserID(userId);
//Get user details
DataView dv = new DataView();
dv = hd.GetUserDetails(userId);
if (dv.Table.Rows.Count > 0)
{
if (!user_email.ToUpper().Contains("DEMO"))
{
DataView dvSiteList = hd.SiteList(userId);
ddlSite.DataSource = dvSiteList;
ddlSite.DataBind();
}
}
}
protected void gvFeedback_RowCommand(object sender, GridViewCommandEventArgs e)
{
int index = 0;
int status_id = 0;
int site_id = 0;
string account_manager = "";
string current_owner = "";
string priority = "";
c_helpdesk hd = new c_helpdesk();
if (e.CommandName.Equals("updateRecord"))
{
//if (gvFeedback.PageIndex > 0)
//{
// index = Convert.ToInt32(e.CommandArgument) - (gvFeedback.PageIndex * gvFeedback.PageSize);
//}
//else { index = Convert.ToInt32(e.CommandArgument); }
int feedback_id = Convert.ToInt32(gvFeedback.DataKeys[Convert.ToInt32(e.CommandArgument)]["feedback_id"]);
hidFeedbackID.Value = feedback_id.ToString();
DataView dv = new DataView();
dv = hd.ListFeedback(feedback_id);
if (dv.Table.Rows.Count > 0)
{
for (int i = 0; i < dv.Table.Rows.Count; i++)
{
lblFeedbackID.Text = Convert.ToInt32(dv.Table.Rows[i]["id"]).ToString("#000000");
txtDesc.Text = dv.Table.Rows[i]["description"].ToString();
status_id = Convert.ToInt32(dv.Table.Rows[i]["status_id"]);
site_id = Convert.ToInt32(dv.Table.Rows[i]["site_id"]);
ddlStatus.SelectedValue = status_id.ToString();
ddlSite.SelectedValue = site_id.ToString();
if (dv.Table.Rows[i]["priority"] != DBNull.Value)
{
ddlPriority.SelectedValue = dv.Table.Rows[i]["priority"].ToString();
}
else
{
ddlPriority.SelectedValue = "Normal";
}
}
}
// Get latest entries
DataView dv1 = new DataView();
dv1 = hd.GetLatestFeedbackHistory(feedback_id);
if (dv1.Table.Rows.Count > 0)
{
for (int i = 0; i < dv1.Table.Rows.Count; i++)
{
account_manager = dv1.Table.Rows[i]["assigned_to_account_manager"].ToString();
current_owner = dv1.Table.Rows[i]["assigned_to_current_owner"].ToString();
}
}
ddlAccountManager.SelectedValue = account_manager.ToString();
ddlCurrentOwner.SelectedValue = current_owner.ToString();
//gvFeedback.DataBind();
//aw.Delete(ArtistPieceID, Session["FV_Username"].ToString());
//LoadGridView();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "ShowPopup();", true);
}
else if (e.CommandName.Equals("viewHistory"))
{
//if (gvFeedback.PageIndex > 0)
//{
// index = Convert.ToInt32(e.CommandArgument) - (gvFeedback.PageIndex * gvFeedback.PageSize);
//}
//else { index = Convert.ToInt32(e.CommandArgument); }
int feedback_id = Convert.ToInt32(gvFeedback.DataKeys[Convert.ToInt32(e.CommandArgument)]["feedback_id"]);
hidFeedbackID.Value = feedback_id.ToString();
DataView dv = new DataView();
dv = hd.GetLatestFeedbackHistory(feedback_id);
if (dv.Table.Rows.Count > 0)
{
for (int i = 0; i < dv.Table.Rows.Count; i++)
{
lblHist_feedback_id.Text = Convert.ToInt32(dv.Table.Rows[i]["id"]).ToString("#000000");
lblHist_Desc.Text = dv.Table.Rows[i]["comments"].ToString();
lblHist_AccountManager.Text = dv.Table.Rows[i]["AccountManager"].ToString();
lblHist_CurrentOwner.Text = dv.Table.Rows[i]["CurrentOwner"].ToString();
lblHist_Status.Text = dv.Table.Rows[i]["Status_Desc"].ToString();
lblHist_Site.Text = dv.Table.Rows[i]["Site_Desc"].ToString();
}
}
gvFeedback.DataBind();
gvFeedbackHistory.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "ShowPopupHistory();", true);
}
}
public bool SendMailHelpdesk(string user_id, int hd_id, string hd_type, string hd_comment, int hd_site_id, string email_to, string site_name, string user_name)
{
try
{
string MailFrom = "";
string MailSMTPServer = "";
string MailSMTPUserName = "";
string MailSMTPPassword = "";
string MailSMTPPort = "";
string MailSMTPEnableSSL = "";
c_helpdesk hd = new c_helpdesk();
DataSet dsSiteSettings = hd.GetMailSettings();
if (dsSiteSettings.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsSiteSettings.Tables[0].Rows)
{
if (dr["setting_key"].ToString() == "MailFrom")
{
MailFrom = dr["setting_value"].ToString();
}
else if (dr["setting_key"].ToString() == "MailSMTPServer")
{
MailSMTPServer = dr["setting_value"].ToString();
}
else if (dr["setting_key"].ToString() == "MailSMTPUserName")
{
MailSMTPUserName = dr["setting_value"].ToString();
}
else if (dr["setting_key"].ToString() == "MailSMTPPassword")
{
MailSMTPPassword = dr["setting_value"].ToString();
}
else if (dr["setting_key"].ToString() == "MailSMTPPort")
{
MailSMTPPort = dr["setting_value"].ToString();
}
else if (dr["setting_key"].ToString() == "MailSMTPEnableSSL")
{
MailSMTPEnableSSL = dr["setting_value"].ToString();
}
}
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
int iMailSMTPPort = 25;
int.TryParse(MailSMTPPort, out iMailSMTPPort);
if (email_to != null)
{
var message = new MailMessage();
message.From = new MailAddress(MailFrom);
message.To.Add(email_to);
if (user_name == null)
{
user_name = "-";
}
if (site_name == null)
{
site_name = "-";
}
if (hd_type == "feedback")
{
message.Subject = "New: Vantage Helpdesk Feedback - #" + hd_id.ToString("#00000");
sb.AppendLine("<p><b>Feedback #" + hd_id.ToString("#00000") + "</b><br>Please see details below:</p><hr>");
sb.AppendLine("<p>");
sb.AppendLine("<table width='100%'>");
sb.AppendLine("<tr><th align='left' style='width:25%'>User:</td><td style='width:75%'>" + user_name + "</td></tr>");
sb.AppendLine("<tr><th align='left' style='width:25%'>Email Address:</td><td style='width:75%'>" + email_to + "</td></tr>");
sb.AppendLine("<tr><th align='left' style='width:25%'>Site:</td><td style='width:75%'>" + site_name + "</td></tr>");
sb.AppendLine("<tr><th align='left' style='width:25%'>Feedback:</td><td style='width:75%'>" + hd_comment + "</td></tr>");
sb.AppendLine("</table>");
sb.AppendLine("</p><hr>");
sb.AppendLine("<p>");
sb.AppendLine("Sincerely<br>Your Vantage Data Team");
sb.AppendLine("</p>");
}
else if (hd_type == "issue")
{
message.Subject = "New: Vantage Helpdesk Issue - #" + hd_id.ToString("#00000");
sb.AppendLine("<p><b>Issue #" + hd_id.ToString("#00000") + "</b><br>Please see details below:</p><hr>");
sb.AppendLine("<p>");
sb.AppendLine("<table width='100%'>");
sb.AppendLine("<tr><th align='left' style='width:25%'>User:</td><td style='width:75%'>" + user_name + "</td></tr>");
sb.AppendLine("<tr><th align='left' style='width:25%'>Email Address:</td><td style='width:75%'>" + email_to + "</td></tr>");
sb.AppendLine("<tr><th align='left' style='width:25%'>Site:</td><td style='width:75%'>" + site_name + "</td></tr>");
sb.AppendLine("<tr><th align='left' style='width:25%'>Status:</td><td style='width:75%'>Opened</td></tr>");
sb.AppendLine("<tr><th align='left' style='width:25%'>Issue:</td><td style='width:75%'>" + hd_comment + "</td></tr>");
sb.AppendLine("</table>");
sb.AppendLine("</p><hr>");
sb.AppendLine("<p>");
sb.AppendLine("Sincerely<br>Your Vantage Data Team");
sb.AppendLine("</p>");
}
message.Body = sb.ToString();
message.IsBodyHtml = true;
using (var smtp = new SmtpClient())
{
var credential = new NetworkCredential
{
UserName = MailSMTPUserName,
Password = MailSMTPPassword
};
smtp.Credentials = credential;
smtp.Host = MailSMTPServer;
smtp.Port = iMailSMTPPort;
smtp.Timeout = 15000;
if (MailSMTPEnableSSL == "true")
{
smtp.EnableSsl = true;
}
else
{
smtp.EnableSsl = false;
}
smtp.Send(message);
// send a copy to helpdesk
var message_helpdesk = new MailMessage();
message_helpdesk.To.Add(MailFrom);
message_helpdesk.From = new MailAddress(MailFrom);
message_helpdesk.Body = sb.ToString();
message_helpdesk.IsBodyHtml = true;
if (hd_type == "feedback")
{
message_helpdesk.Subject = "New: Vantage Helpdesk Feedback - #" + hd_id.ToString("#00000");
}
else if (hd_type == "issue")
{
message_helpdesk.Subject = "New: Vantage Helpdesk Issue - #" + hd_id.ToString("#00000");
}
smtp.Send(message_helpdesk);
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
