public void sendotp(FormCollection col)
{
// sqlconn.Open();
long adno = Convert.ToInt64(col["adno"].ToString());
string token = "";
citizen cz = db.citizens.Find(adno);
if (cz != null)
{
Session["ano"] = adno;
Session.Timeout = 30;
if (Session.Mode.ToString() == "off")
{
Redirect("~/Views/Citizen/portal");
}
c = cz;
token = generateotp();
Session["otp"] = token.ToString(); //Session stores the otp for
Sendmail(cz, token);
}
else
{
RedirectToAction("anotfound");
}
}
//Send e-mail to the registered email address
public void Sendmail(citizen p, string token)
{
SmtpClient smtpClient = new SmtpClient("smtp.live.com", 587);
smtpClient.UseDefaultCredentials = true;
smtpClient.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Stern1988", "outlook.com");
smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpClient.EnableSsl = true;
MailMessage mail = new MailMessage();
mail.Body = "The Code for Authentication is " + token.ToString() + ". Use it to verify yourself.";
//Setting From and To
mail.Subject = "e-Sign Authorization";
mail.From = new MailAddress("*****@*****.**");
// mail.To.Clear();
mail.To.Add(new MailAddress(p.email.ToString()));
smtpClient.Send(mail);
Response.Write("<script>alert('hi')</script>");
}
//返回html table格式的内容字符串
public string get(string name, string id)
{
MysqlTOOLS mt = new MysqlTOOLS();
string sql1 =
"SELECT citizen_name,citizen_gender, \n" +
"\tuser_phone,user_avtarlink,user_email,user_note,\n" +
"\t xiaoqu_name,buliding,unit,room,area_name,area_city,area_province,citizen.citizenID\n" +
"FROM `user` , citizen , link ,xiaoqu,area\n" +
"WHERE link.citizenid = user_citizenID \n" +
"and xiaoqu_area_id=areaID\n" +
"AND user_citizenID = citizen.citizenID AND link.xiaoquid = xiaoqu.xiaoquID " +
$"and citizen.citizenID like '{id}%'\n" +
$"and citizen_name like '%{name}%'";
var rdr = mt.sqlToReader(sql1);
while (rdr.Read())
{
var dumdum = new citizen();
dumdum.name = rdr[0].ToString();
dumdum.gender = rdr[1].ToString();
dumdum.phone = rdr[2].ToString();
dumdum.avtarlink = rdr[3].ToString();
dumdum.email = rdr[4].ToString();
dumdum.note = rdr[5].ToString();
dumdum.livIn.xiaoquname = rdr[6].ToString();
dumdum.livIn.building = rdr[7].ToString();
dumdum.livIn.unit = rdr[8].ToString();
dumdum.livIn.room = rdr[9].ToString();
dumdum.livarea.name = rdr[10].ToString();
dumdum.livarea.city = rdr[11].ToString();
dumdum.livarea.province = rdr[12].ToString();
dumdum.citizenid = rdr[13].ToString();
// 下面信息的计算和获取需要上述信息先存在
dumdum.age = getAgeById(dumdum.citizenid);
if (do_getisworker)
{
dumdum.isworker = getIsworker(dumdum.citizenid);
}
ctznlist.AddLast(dumdum);
}
rdr.Close();
mt.closeconnection();
string contentstr = "";
foreach (var item in ctznlist)
{
string addstr =
" <tr data-toggle=\"collapse\" data-target=\"#_" + item.citizenid + "\">\n" +
$" <td>{item.name}</td>\n" +
$" <td>{item.gender}</td>\n" +
$" <td>{item.citizenid}</td>\n" +
" </tr>\n" +
" <tr>\n" +
" <td class=\"table-active\" colspan=\"3\" style=\"padding:0; border: none;\">\n" +
$" <div id=\"_{item.citizenid}\" class=\"collapse\">\n" +
" <div class=\"row\">\n" +
" <div class=\"col-3\">\n" +
" <img style=\"border: 5px solid whitesmoke;\n" +
" margin-left: 9px;\n" +
" height: 185px;\n" +
$" box-shadow: 0 0 3px #000000ab;\" src=\"{item.avtarlink}\" alt=\"照片\">\n" +
" </div>\n" +
" <div class=\"col-9\">\n" +
" <table class=\" bg-light ml-auto\">\n" +
" <tr>\n" +
$" <td>居住区域</td>\n" +
$" <td>{item.livarea.province}省 {item.livarea.city}市 {item.livarea.name}</td>\n" +
$" <td>年龄</td>\n" +
$" <td>{item.age}</td>\n" +
" </tr>\n" +
" <tr>\n" +
$" <td>具体住址</td>\n" +
$" <td>{item.livIn.xiaoquname} {item.livIn.building}号楼 {item.livIn.room}室 </td>\n" +
$" <td>手机</td>\n" +
$" <td>{item.phone}</td>\n" +
" </tr>\n" +
" <tr>\n" +
" <td>工作人员</td>\n" +
$" <td>{item.isworker}</td>\n" +
" <td rowspan=\"2\">备注</td>\n" +
$" <td rowspan=\"2\">{item.note}</td>\n" +
" </tr>\n" +
" <tr>\n" +
" <td>email</td>\n" +
$" <td>{item.email}</td>\n" +
" </tr>\n" +
" </table>\n" +
" </div>\n" +
" </div>\n" +
" </div>\n" +
" </td>\n" +
" </tr>";
contentstr += addstr;
}
return(contentstr);
}
