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); } }