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