public void sendemailalerts(string username) { qry = "SELECT FIRSTNAME,USERS.EMAIL,USERS.USER_NAME,PASSWORD FROM USERS WHERE USER_NAME='" + username + "'"; foreach (DataRow drow in con.SqlDs(qry, 1).Tables[0].Rows) { firstname = drow[0].ToString(); email = drow[1].ToString(); username = drow[2].ToString(); password = Users.Users.Decrypt(drow[3].ToString(), true); MailMessage mail = new MailMessage(); username = "******"; password = "******"; mail.To.Add(email); mail.From = new MailAddress("*****@*****.**"); mail.Subject = "Your RiskMgr.Net Password"; bodi = "<html><head></head><body><Table><tr><td width = '1000'>Dear " + firstname + ",</td></tr></table> <td rowspan = '6'><tr><td>Your RiskMgr.net password is " + password + ".For technical issues kindly contact [email protected].<br />Please click on <a href='http://localhost/RiskMgr.Net/'>Risk Manager.Net </a> to log on and submit your reports if you have not done so.<br /> Regards,<br /> Risk & Compliance Mgmt Dept<br /></body></html>"; bodi = string.Format(bodi); mail.Body = bodi; mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; //Or Your SMTP Server Address smtp.Port = 587; smtp.Credentials = new System.Net.NetworkCredential(username, password); smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.EnableSsl = true; try { smtp.Send(mail); Lblmsg.Text = "Password sent sucessfully to your email " + email; } catch (Exception exp) { Utility.insertError(exp.Message); Lblmsg.Text = exp.Message; msgBox1.alert(exp.Message); } } }
void bindprofmenu() { try { SqlConnection Cn = new SqlConnection(constsql1); SQL = "SELECT PROFILEMENUITEMS.MENUID, MENUS.ATTACHTO, PROFILEMENUITEMS.ITEMTYPE, PROFILEMENUITEMS.IDS, MENUS.STYLE, MENUS.ID, PROFILEMENUITEMS.HTML, PROFILEMENUITEMS.ICON,PROFILEMENUITEMS.URL, PROFILEMENUITEMS.URLTARGET, PROFILEMENUITEMS.ONCLIENTCLICK FROM PROFILEMENUITEMS INNER JOIN MENUS ON PROFILEMENUITEMS.MENUID = MENUS.ID ORDER BY ID, ATTACHTO, ORDERS"; SqlCommand Com = new SqlCommand(SQL, Cn); Cn.Open(); oReader = Com.ExecuteReader(); string lastMenuId = ""; EasyMenu oem = null; while (oReader.Read()) { if (oReader.GetString(oReader.GetOrdinal("menuID")) != lastMenuId) { oem = new EasyMenu(); oem.ID = oReader.GetString(oReader.GetOrdinal("menuid")); oem.Position = MenuPosition.Horizontal; oem.Width = "60"; oem.UseIcons = true; oem.Align = OboutInc.EasyMenu_Pro.MenuAlign.Under; oem.IconsFolder = "Icons"; oem.CSSMenu = "ParentMenu"; oem.CSSMenuItemContainer = "ParentItemContainer"; CSSClasses MenuItemCssClasses = oem.CSSClassesCollection[oem.CSSClassesCollection.Add(new CSSClasses(typeof(OboutInc.EasyMenu_Pro.MenuItem)))]; MenuItemCssClasses.ComponentSubMenuCellOver = "ParentItemSubMenuCellOver"; MenuItemCssClasses.ComponentContentCell = "ParentItemContentCell"; MenuItemCssClasses.Component = "ParentItem"; MenuItemCssClasses.ComponentSubMenuCell = "ParentItemSubMenuCell"; MenuItemCssClasses.ComponentIconCellOver = "ParentItemIconCellOver"; MenuItemCssClasses.ComponentIconCell = "ParentItemIconCell"; MenuItemCssClasses.ComponentOver = "ParentItemOver"; MenuItemCssClasses.ComponentContentCellOver = "ParentItemContentCellOver"; oem.CSSClassesCollection.Add(MenuItemCssClasses); CSSClasses MenuSeparatorCssClasses = oem.CSSClassesCollection[oem.CSSClassesCollection.Add(new CSSClasses(typeof(MenuSeparator)))]; MenuSeparatorCssClasses.ComponentSubMenuCellOver = "ParentSeparatorSubMenuCellOver"; MenuSeparatorCssClasses.ComponentContentCell = "ParentSeparatorContentCell"; MenuSeparatorCssClasses.Component = "ParentSeparator"; MenuSeparatorCssClasses.ComponentSubMenuCell = "ParentSeparatorSubMenuCell"; MenuSeparatorCssClasses.ComponentIconCellOver = "ParentSeparatorIconCellOver"; MenuSeparatorCssClasses.ComponentIconCell = "ParentSeparatorIconCell"; MenuSeparatorCssClasses.ComponentOver = "ParentSeparatorOver"; MenuSeparatorCssClasses.ComponentContentCellOver = "ParentSeparatorContentCellOver"; oem.CSSClassesCollection.Add(MenuSeparatorCssClasses); oem.StyleFolder = oReader.GetString(oReader.GetOrdinal("style")); if (!oReader.IsDBNull(oReader.GetOrdinal("attachto"))) { oem.AttachTo = oReader.GetString(oReader.GetOrdinal("attachto")); oem.ShowEvent = MenuShowEvent.MouseOver; oem.Align = MenuAlign.Under; oem.UseIcons = true; oem.IconsFolder = "Icons"; placeHolder1.Controls.Add(oem); } else { oem.UseIcons = true; oem.IconsFolder = "Icons"; oem.ShowEvent = MenuShowEvent.Always; oem.Align = MenuAlign.Under; placeHolder1.Controls.Add(oem); } } if (oReader.GetString(oReader.GetOrdinal("ITEMTYPE")) == "S") { oem.AddSeparator(oReader.GetString(oReader.GetOrdinal("b.ID")), oReader.IsDBNull(oReader.GetOrdinal("HTML")) ? "" : oReader.GetString(oReader.GetOrdinal("HTML"))); } else if (oReader.GetString(oReader.GetOrdinal("ITEMTYPE")) == "I") { oem.AddMenuItem(oReader.GetString(oReader.GetOrdinal("IDS")), oReader.IsDBNull(oReader.GetOrdinal("HTML")) ? "" : oReader.GetString(oReader.GetOrdinal("HTML")), oReader.IsDBNull(oReader.GetOrdinal("ICON")) ? "" : oReader.GetString(oReader.GetOrdinal("ICON")), oReader.IsDBNull(oReader.GetOrdinal("URL")) ? "" : oReader.GetString(oReader.GetOrdinal("URL")), oReader.IsDBNull(oReader.GetOrdinal("URLTARGET")) ? "" : oReader.GetString(oReader.GetOrdinal("URLTARGET")), oReader.IsDBNull(oReader.GetOrdinal("ONCLIENTCLICK")) ? "" : oReader.GetString(oReader.GetOrdinal("ONCLIENTCLICK"))); } lastMenuId = oReader.GetString(oReader.GetOrdinal("menuID")); } oReader.Close(); Cn.Close(); } catch (Exception ex) { Utility.insertError(ex.Message); Response.Write("<script>top.location='logout.aspx'</script>"); } }
public void sendemailalerts() { months = ""; years = ""; //Label1.Text = ""; str = "select DATEPART(mm,CLOSINGDATE) as monthh,DATEPART(yy,CLOSINGDATE) as yearr, DATEDIFF(dd,getdate(),closingdate) as dayclosed,DTENTRYSTATUS from YEARQTR where status=1"; foreach (DataRow drow in con.SqlDs(str, 1).Tables[0].Rows) { months = drow[0].ToString(); years = drow[1].ToString(); dayclosed = Convert.ToInt32(drow[2]); } if (months != "" | months != string.Empty | years != "" | years != string.Empty | dayclosed != 0) { switch (months) { case "1": monthname = "January"; break; case "2": monthname = "February"; break; case "3": monthname = "March"; break; case "4": monthname = "April"; break; case "5": monthname = "May"; break; case "6": monthname = "June"; break; case "7": monthname = "July"; break; case "8": monthname = "August"; break; case "9": monthname = "September"; break; case "10": monthname = "October"; break; case "11": monthname = "November"; break; case "12": monthname = "December"; break; } } if (dayclosed <= 7) { qry = "SELECT FIRSTNAME,USERS.EMAIL,USERS.USER_NAME FROM USERS"; foreach (DataRow drow in con.SqlDs(qry, 1).Tables[0].Rows) { firstname = drow[0].ToString(); email = drow[1].ToString(); username = drow[2].ToString(); MailMessage mail = new MailMessage(); username = "******"; password = "******"; mail.To.Add(email); mail.From = new MailAddress("*****@*****.**"); mail.Subject = "Submission of Risk Report for the month of " + monthname + "," + years; bodi = "<html><head></head><body><Table><tr><td width = '1000'>Dear " + firstname + ",</td></tr></table> <td rowspan = '6'><tr><td>Please note that data entry and report submision for the month of " + monthname + "," + years + " is ending in <font color = 'red'> " + dayclosed + " days!</font> Your username is " + username + " and if you are a first time user your default password is 123456.For technical issues kindly contact [email protected].<br />Please click on <a href='http://localhost/RiskMgr.Net/'>Risk Manager.Net </a> to log on and submit your reports if you have not done so.<br /> Regards,<br /> Risk & Compliance Mgmt Dept<br /></body></html>"; bodi = string.Format(bodi); mail.Body = bodi; mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; //Or Your SMTP Server Address smtp.Port = 587; smtp.Credentials = new System.Net.NetworkCredential (username, password); smtp.DeliveryMethod = SmtpDeliveryMethod.Network; //Or your Smtp Email ID and Password smtp.EnableSsl = true; try { smtp.Send(mail); //Label1.Text = "e-Mail notification sent sucessfully to " + email; } catch (Exception exp) { Utility.insertError(exp.Message); //Label1.Text = exp.Message; msgBox1.alert(exp.Message); } } } }
protected void btnLogin_Click(object sender, EventArgs e) { try { string Key_c = "AutoEnhancerConnectionString"; string name = "AutoEnhancerConnectionString"; string Value_c = RadLocation.SelectedValue; Session["BranchNames"] = RadLocation.SelectedItem.Text; BranchNames = Session["BranchNames"].ToString(); Configuration webConfigApp = WebConfigurationManager.OpenWebConfiguration("~"); webConfigApp.AppSettings.Settings[Key_c].Value = Value_c; webConfigApp.Save(); Configuration webConfigApps = WebConfigurationManager.OpenWebConfiguration("~"); webConfigApps.ConnectionStrings.ConnectionStrings[name].ConnectionString = Value_c; webConfigApps.Save(); switch (BranchNames) { case "KP1": passes = "9SA27052009KP1"; servernames = "10.3.0.15"; //constrings = ""; break; case "KP2": passes = "9SA27052009KP2$"; servernames = "10.100.11.10"; break; case "Abuja": passes = "9SA03082009ABJ$"; servernames = "10.100.15.10"; break; case "PHC": passes = "9SA04112009PHC$"; servernames = "10.100.12.10"; break; case "Kano": passes = "9SA08092009KAN$"; servernames = "10.100.16.9"; break; case "KP2BackUp": passes = "9SA27052009KP2$"; servernames = "10.3.0.15\\KP2_AE"; break; } Configuration webConfigAppss = WebConfigurationManager.OpenWebConfiguration("~"); webConfigAppss.AppSettings.Settings[nameP].Value = passes; webConfigAppss.Save(); Configuration webConfigAppServ = WebConfigurationManager.OpenWebConfiguration("~"); webConfigAppServ.AppSettings.Settings[nameS].Value = servernames; webConfigAppServ.Save(); } catch (Exception ex) { msgBox1.alert(ex.Message); Utility.insertError(ex.Message); } Session["Userid"] = txtUsername.Text; passwords = Users.Users.Encrypt(txtPassword.Text, true); SqlLogin = "******" + txtUsername.Text + "', '" + passwords + "'"; try { passtype = 0; if (passtype != 0) { bool matched = (Regex.IsMatch(txtPassword.Text, "[a-zA-Z]") && Regex.IsMatch(txtPassword.Text, "[0-9]")); if (matched == false) { msgBox1.alert("Please enter an alphanumeric password"); return; } } Count = con.SqlDs(SqlLogin, 1).Tables[0].Rows.Count; if (Count <= 0) { msgBox1.alert("Either your username or password is not correct."); return; } else { foreach (DataRow dr in con.SqlDs(SqlLogin, 1).Tables[0].Rows) { Session["fullname"] = dr[1].ToString(); Session["Userid"] = dr[2].ToString(); locked = dr[4].ToString().Trim(); pass = dr[5].ToString(); Session["DptName"] = dr[6].ToString(); Session["GroupName"] = dr[7].ToString(); Session["ActionOwner"] = dr[8].ToString(); Session["Userids"] = dr[10].ToString(); Session["strUid"] = System.Configuration.ConfigurationManager.AppSettings["dbusername"].ToString(); Session["strPwd"] = System.Configuration.ConfigurationManager.AppSettings["dbpassword"].ToString(); Session["strServer"] = System.Configuration.ConfigurationManager.AppSettings["dbServer"].ToString(); Session["strDatabase"] = System.Configuration.ConfigurationManager.AppSettings["dbDatabase"].ToString(); if (locked == "T") { msgBox1.alert("This account is currently locked please contact your System Adminitrator"); return; } pass = Users.Users.Decrypt(pass.Trim(), true); if (pass == "123456") { Response.Redirect("./Security/changepasword.aspx"); } } Response.Redirect("main.aspx"); } } catch (Exception ex) { msgBox1.alert(ex.Message); Utility.insertError(ex.Message); } }