public void OpenPage(pages pages)
{
if (pages == pages.CaesarCipher)
{
frame.Navigate(new CaesarCipher(this));
}
else if (pages == pages.TrithemiusCipher)
{
frame.Navigate(new TrithemiusCipher(this));
}
else if (pages == pages.TrithemiusCipher2)
{
frame.Navigate(new TrithemiusCipher2(this));
}
else if (pages == pages.XORCipher)
{
frame.Navigate(new XORCipher(this));
}
else if (pages == pages.VigenereCipher)
{
frame.Navigate(new VigenereCipher(this));
}
else if (pages == pages.RSACipher)
{
frame.Navigate(new RSACipher(this));
}
else if (pages == pages.DiffieHellmanCipher)
{
frame.Navigate(new DiffieHellmanCipher(this));
}
}
public void OpenPage(pages pages)
{
if (pages == pages.signIn)
{
frame.Navigate(new SignInPage(this));
}
else if (pages == pages.signUp)
{
frame.Navigate(new SignUpPage(this));
}
else if (pages == pages.home)
{
frame.Navigate(new HomePage(this));
}
else if (pages == pages.expense)
{
//frame.Navigate(new ExpensePage(this));
}
else if (pages == pages.dream)
{
frame.Navigate(new DreamPage(this));
}
else
{
frame.Navigate(new StartPage(this));
}
}
/// <summary>
/// 根据表,获取一个OleDbParameter数组
/// </summary>
/// <returns>OleDbParameter[]</returns>
public static OleDbParameter[] GetOleDbParameter(pages pagesExample)
{
List <OleDbParameter> list_param = new List <OleDbParameter>();
if (!string.IsNullOrEmpty(pagesExample.pcontext))
{
list_param.Add(new OleDbParameter("@pcontext", pagesExample.pcontext));
}
else
{
list_param.Add(new OleDbParameter("@pcontext", DBNull.Value));
}
if (!string.IsNullOrEmpty(pagesExample.pname))
{
list_param.Add(new OleDbParameter("@pname", pagesExample.pname));
}
else
{
list_param.Add(new OleDbParameter("@pname", DBNull.Value));
}
if (pagesExample.psort != 0)
{
list_param.Add(new OleDbParameter("@psort", pagesExample.psort));
}
else
{
list_param.Add(new OleDbParameter("@psort", DBNull.Value));
}
if (!string.IsNullOrEmpty(pagesExample.pstate))
{
list_param.Add(new OleDbParameter("@pstate", pagesExample.pstate));
}
else
{
list_param.Add(new OleDbParameter("@pstate", DBNull.Value));
}
if (pagesExample.ptid != 0)
{
list_param.Add(new OleDbParameter("@ptid", pagesExample.ptid));
}
else
{
list_param.Add(new OleDbParameter("@ptid", DBNull.Value));
}
OleDbParameter[] param = new OleDbParameter[list_param.Count];
int index = 0;
foreach (OleDbParameter p in list_param)
{
param[index] = p;
index++;
}
return(param);
}
private void OpenPages(pages page)
{
if (page == pages.login)
{
mainFrame.Navigate(new login(this));
}
else
{
mainFrame.Navigate(pages.main);
}
}
public void OpenPage(pages pages)
{
if (pages == pages.login)
{
frame.Navigate(new login(this));
}
else if (pages == pages.signup)
{
frame.Navigate(new signup(this));
}
}
void OpenPage(pages pages)
{
if (pages == pages.login)
{
frame.Navigate(new login(this));
}
else if (pages == pages.regin)
{
frame.Navigate(new regin(this));
}
}
public void OpenPage(pages pages)
{
if (pages == pages.LoginPage)
{
frame.Navigate(new LoginPage(this));
}
else
if (pages == pages.RegPage)
{
frame.Navigate(new RegPage(this));
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
string name = txt_name.Text.Trim();
string context = txt_context.Value;
string state = ddl_state.SelectedValue.ToString();
string sort = txt_sort.Text.Trim();
string ptid = ddl_pagestype.SelectedValue;
int _ptid = string.IsNullOrEmpty(ptid) ? 0 : Convert.ToInt32(ptid);
pages dp = new pages();
if (!string.IsNullOrEmpty(id))
{
dp = BLL.pagesManager.SearchByID(Convert.ToInt32(id));
}
else
{
dp.pdate = DateTime.Now;
}
dp.pname = name;
dp.pcontext = context;
dp.psort = Convert.ToInt32(sort);
dp.pstate = state;
dp.ptid = _ptid;
int res;
if (string.IsNullOrEmpty(id))
{
res = BLL.pagesManager.Insert(dp);
}
else
{
res = BLL.pagesManager.Update(dp);
}
if (res == 1)
{
Manager.Alert("保存成功", Page);
}
else
{
Manager.Alert("保存失败", Page);
}
}
catch (Exception ex)
{
Manager.Alert(ex.ToString(), Page);
}
Manager.page_href_reload(Page);
}
/// <summary>
/// 从一个OleDbDataReader里读数据
/// </summary>
/// <param name="Reader">OleDbDataReader</param>
/// <returns>pagesExample</returns>
public static pages GetByReader(OleDbDataReader Reader)
{
pages pagesExample = new pages();
pagesExample.pcontext = Reader["pcontext"] == DBNull.Value ? null : Reader["pcontext"].ToString();
pagesExample.pdate = Reader["pdate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["pdate"]);
pagesExample.pid = Reader["pid"] == DBNull.Value ? 0 : (int)Reader["pid"];
pagesExample.pname = Reader["pname"] == DBNull.Value ? null : Reader["pname"].ToString();
pagesExample.psort = Reader["psort"] == DBNull.Value ? 0 : (int)Reader["psort"];
pagesExample.pstate = Reader["pstate"] == DBNull.Value ? null : Reader["pstate"].ToString();
pagesExample.ptid = Reader["ptid"] == DBNull.Value ? 0 : (int)Reader["ptid"];
return(pagesExample);
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <returns>IList</returns>
/*查看是否为视图*/
public IList <pages> SearchAll()
{
Access.DBHelper.sqlstr = "select * from pages order by psort asc ";
List <pages> list = new List <pages>();
OleDbDataReader reader = Access.DBHelper.ExecuteReader();
while (reader.Read())
{
pages Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Path.ToLower().Contains("New-Patient-Tracking"))
currentPage = pages.newPatTracking;
switch (currentPage)
{
case pages.ndcLookup: pageTitle = "NDC Lookup"; break;
case pages.sfsLookup: pageTitle = "Sliding Fee Scale"; break;
case pages.newPatTracking: pageTitle = "ACA Patient Tracking"; break;
default: pageTitle = ""; break;
}
this.lblPageTitle.Text = pageTitle;
}
public void OpenPage(pages p)
{
if (p == pages.login)
{
frame.Navigate(new login(this));
}
else if (p == pages.admin)
{
frame.Navigate(new admin(this));
}
else if (p == pages.manager)
{
frame.Navigate(new manager(this));
}
}
public void OpenPage(pages pages)
{
switch (pages)
{
case pages.login:
frame.Navigate(new Login(this));
break;
case pages.register:
frame.Navigate(new Register(this));
break;
case pages.cars:
frame.Navigate(new Cars(this));
break;
case pages.add:
frame.Navigate(new Add(this));
break;
case pages.garage:
frame.Navigate(new Garage(this));
break;
case pages.balance:
frame.Navigate(new Balance(this));
break;
case pages.tech:
frame.Navigate(new Sell(this));
break;
case pages.deals:
frame.Navigate(new Deals(this));
break;
case pages.image:
frame.Navigate(new Images(this));
break;
case pages.counts:
frame.Navigate(new Count(this));
break;
default:
break;
}
}
/// <summary>
/// 根据pid,查询一条数据
/// </summary>
/// <param name="pid">页面编号</param>
/// <returns></returns>
public pages SearchByID(int pid)
{
Access.DBHelper.sqlstr = "select * from pages where pid = @pid";
OleDbParameter[] param = new OleDbParameter[] {
new OleDbParameter("@pid", pid)
};
OleDbDataReader reader = Access.DBHelper.ExecuteReader(param);
pages Obj = null;
if (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
public static void CreateWatchEmail(pages.ForumPage basePage,object messageID)
{
using(DataTable dt = DB.message_list(messageID))
{
foreach(DataRow row in dt.Rows)
{
// Send track mails
string subject = String.Format("Topic Subscription New Post Notification (From {0})",basePage.BoardSettings.Name);
string body = Utils.ReadTemplate("topicpost.txt");
body = body.Replace("{forumname}",basePage.BoardSettings.Name);
body = body.Replace("{topic}",row["Topic"].ToString());
body = body.Replace("{link}",String.Format("{0}{1}",basePage.ServerURL,Forum.GetLink(Pages.posts,"m={0}#{0}",messageID)));
DB.mail_createwatch(row["TopicID"],basePage.BoardSettings.ForumEmail,subject,body,row["UserID"]);
}
}
}
protected void BtnOk_Click(object sender, EventArgs e)
{
using (var db = new SiewebEntities())
{
string str = Server.HtmlDecode(editor.InnerHtml);
var page = new pages();
page.title = TxtTitle.Text.Trim();
page.body = str;
Response.Write("<script>alert('" + str + "');</script>");
page.createtime = DateTime.Now;
page.updatetime = DateTime.Now;
int belo = Convert.ToInt32(DdlSelect.SelectedValue);
page.belong = belo;
db.pages.Add(page);
db.SaveChanges();
Response.Write("<script>alert('添加成功');</script>");
}
}
void bind()
{
if (!string.IsNullOrEmpty(id))
{
int temp = 0;
if (int.TryParse(id, out temp))
{
pages dp = pagesManager.SearchByID(temp);
if (dp != null)
{
try
{
lbl_name.Text = dp.pname;
lbl_date.Text = dp.pdate.ToString();
liter_context.Text = dp.pcontext;
}
catch { }
}
}
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txt_name = GridView1.Rows[e.RowIndex].FindControl("txt_name") as TextBox;
TextBox txt_sort = GridView1.Rows[e.RowIndex].FindControl("txt_sort") as TextBox;
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["pid"]);
pages dp = BLL.pagesManager.SearchByID(id);
dp.pname = string.IsNullOrEmpty(txt_name.Text) ? "" : txt_name.Text.Trim();
dp.psort = string.IsNullOrEmpty(txt_sort.Text) ? 0 : Convert.ToInt32(txt_sort.Text.Trim());
if (BLL.pagesManager.Update(dp) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
GridView1.EditIndex = -1;
bind();
}
}
/// <summary>
/// 根据条件查询全部数据
/// </summary>
/// <param name="s">起始位置</param>
/// <param name="e">结束位置</param>
/// <param name="key">关键词</param>
/// <param name="state">状态</param>
/// <param name="date1">起始时间</param>
/// <param name="date2">结束时间</param>
/// <returns>IList<pages></returns>
public IList <pages> Search(int s, int e, string key, string state, int ptid, DateTime date1, DateTime date2)
{
string sql1 = "select top " + e.ToString() + " * from pages where ";
string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( pname like '%" + key + "%' or pcontext like '%" + key + "%' ) ";
string sql3 = string.IsNullOrEmpty(state) ? "" : " and pstate= '" + state + "' ";
string sql4 = ptid == 0 ? "" : " and ptid= " + ptid + " ";
string sql5 = date1 == new DateTime() ? "" : " and datediff('d','" + date1.ToString() + "',pdate)>=0 ";
string sql6 = date2 == new DateTime() ? "" : " and datediff('d','" + date2.ToString() + "',pdate)<=0 ";
string sql7 = " order by psort desc,pdate asc ";//排序两个字段,否则数据容易错误
DBHelper.sqlstr = "select * from(select top " + (e - s + 1).ToString() + " * from ( " + sql1 + sql2 + sql3 + sql4 + sql5 + sql6 + " order by psort asc,pdate desc ) " + sql7 + ") order by psort asc,pdate desc ";
List <pages> list = new List <pages>();
OleDbDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
pages Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
string state = e.CommandName;
if (state == "state")
{
int id = Convert.ToInt32(GridView1.DataKeys[((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex].Values["pid"].ToString());
if (id != 0)
{
pages dp = BLL.pagesManager.SearchByID(id);
dp.pstate = dp.pstate == "1" ? "2" : "1";
if (BLL.pagesManager.Update(dp) != 1)
{
AJAXManager.Alert(this.UpdatePanel1, "修改失败");
}
else
{
bind();
}
}
}
}
//Used to reposition grids and make them visible to make switching easy
private void GoToPage(pages page)
{
//bad coding
resetDeposit();
resetTransfer();
TransactionForWithdraw.Visibility = Visibility.Hidden;
withdrawPageReset();
Thickness margHide = new Thickness();
margHide.Left = -9999;
margHide.Right = 9999;
margHide.Top = 0;
margHide.Bottom = 46;
Thickness margShow = new Thickness();
margShow.Left = 0;
margShow.Right = 0;
margShow.Top = 0;
margShow.Bottom = 46;
//Hide all pages
for (int i = 0; i < pageNames.Length; ++i)
{
Grid hideThis = (Grid)this.FindName(pageNames[i]);
hideThis.Visibility = Visibility.Hidden;
hideThis.Margin = margHide;
}
//Show the page requested
Grid nextPage = (Grid)this.FindName(pageNames[(int)page]);
nextPage.Visibility = Visibility.Visible;
nextPage.Margin = margShow;
currentPage = page;
}
public XmlTextWriter WriteRSSPrologue(XmlTextWriter writer, pages.ForumPage page)
{
/*
writer.WriteStartDocument();
writer.WriteStartElement("rss");
writer.WriteAttributeString("version", "2.0");
writer.WriteStartElement("channel");
writer.WriteElementString("title", "RSS File for " + page.ForumURL);
writer.WriteElementString("link", page.ForumURL);
writer.WriteElementString("description", "Yet Another Forum Web Application");
writer.WriteElementString("copyright", "Copyright 2002-2004 Bjørnar Henden");
*/
writer.WriteRaw("<?xml version=\"1.0\" encoding=\"utf-8\" ?>" + en);
writer.WriteRaw("<rss version=\"2.0\">" + en);
writer.WriteRaw("\t<channel>" + en);
writer.WriteRaw("\t\t<title>RSS Feed for " + page.ServerURL + "</title>" + en);
writer.WriteRaw("\t\t<link>" + Encode(page.ForumURL) + "</link>" + en);
writer.WriteRaw("\t\t<description>Yet Another Forum Web Application RSS Feed</description>" + en);
writer.WriteRaw("\t\t<copyright>Copyright 2002 - 2004 Bjørnar Henden</copyright>" + en);
return writer;
}
public void OpenPage(pages pages)
{
if (pages == pages.login)
{
frame.Navigate(new login(this));
}
else if (pages == pages.regin)
{
frame.Navigate(new regin(this));
}
else if (pages == pages.Menu)
{
frame.Navigate(new Menu(this));
}
else if (pages == pages.AdminMenu)
{
frame.Navigate(new AdminMenu(this));
}
else if (pages == pages.InsertPage)
{
frame.Navigate(new InsertPage(this));
}
}
void bind()
{
if (!string.IsNullOrEmpty(id))
{
int temp = 0;
if (int.TryParse(id, out temp))
{
pages dp = pagesManager.SearchByID(temp);
if (dp != null)
{
try
{
txt_name.Text = dp.pname;
txt_context.Value = dp.pcontext;
txt_sort.Text = dp.psort.ToString();
ddl_state.SelectedValue = dp.pstate;
liter_date.Text = dp.pdate.ToString();
ddl_pagestype.SelectedValue = dp.ptid.ToString();
}
catch { }
}
}
}
}
public void OpenPage(pages pages)
{
if (access_level == "Юзер")
{
if (pages == pages.login)
{
access_level = "Юзер";
menu.Navigate(new frame_clear(this));
content.Navigate(new frame_clear(this));
frame.Navigate(new login(this));
}
else if (pages == pages.directory)
{
frame.Navigate(new frame_clear(this));
content.Navigate(new directory(this));
menu.Navigate(new menu(this));
}
else if (pages == pages.Request)
{
frame.Navigate(new frame_clear(this));
content.Navigate(new Request(this));
menu.Navigate(new menu(this));
}
else if (pages == pages.Otchet)
{
frame.Navigate(new frame_clear(this));
content.Navigate(new Otchet(this));
menu.Navigate(new menu(this));
}
}
else if (access_level == "Админ")
{
if (pages == pages.login)
{
access_level = "Юзер";
menu.Navigate(new frame_clear(this));
content.Navigate(new frame_clear(this));
frame.Navigate(new login(this));
}
else if (pages == pages.Request)
{
frame.Navigate(new frame_clear(this));
content.Navigate(new Request(this));
menu.Navigate(new menu(this));
}
else if (pages == pages.directory)
{
frame.Navigate(new frame_clear(this));
content.Navigate(new directory_admin(this));
menu.Navigate(new menu(this));
}
else if (pages == pages.new_user)
{
frame.Navigate(new frame_clear(this));
content.Navigate(new new_user(this));
menu.Navigate(new menu(this));
}
else if (pages == pages.change)
{
frame.Navigate(new frame_clear(this));
content.Navigate(new change(this));
menu.Navigate(new menu(this));
}
else if (pages == pages.append)
{
frame.Navigate(new frame_clear(this));
content.Navigate(new append(this));
menu.Navigate(new menu(this));
}
else if (pages == pages.Otchet)
{
frame.Navigate(new frame_clear(this));
content.Navigate(new Otchet(this));
menu.Navigate(new menu(this));
}
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pages">pages表实例</param>
/// <returns>int</returns>
public static int Update(pages pagesExample)
{
return(Service.Update(pagesExample));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pages">pages表实例</param>
/// <returns>int</returns>
public int Update(pages pagesExample)
{
Access.DBHelper.sqlstr = "update pages set pcontext=@pcontext,pdate='" + pagesExample.pdate.ToString() + "',pname=@pname,psort=@psort,pstate=@pstate,ptid=@ptid where pid=" + pagesExample.pid;
return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(pagesExample)));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="pages">pages表实例</param>
/// <returns>int</returns>
public int Insert(pages pagesExample)
{
Access.DBHelper.sqlstr = "insert into pages (pcontext,pdate,pname,psort,pstate,ptid)values(@pcontext,'" + pagesExample.pdate.ToString() + "',@pname,@psort,@pstate,@ptid)";
return(Access.DBHelper.ExecuteNonQuery(GetOleDbParameter(pagesExample)));
}
Book(title, author, pages, owner)
{
read = 0;
}
public static void SendMail(pages.ForumPage basePage,string from,string to,string subject,string body)
{
SendMail(basePage, from, null, to, null, subject, body);
}
public static void CreateWatchEmail( pages.ForumPage basePage, object messageID )
{
using ( DataTable dt = DB.message_list( messageID ) )
{
foreach ( DataRow row in dt.Rows )
{
// Send track mails
string subject = String.Format( basePage.GetText("COMMON","TOPIC_NOTIFICATION_SUBJECT"), basePage.BoardSettings.Name );
StringDictionary emailParams = new StringDictionary();
emailParams["{forumname}"] = basePage.BoardSettings.Name;
emailParams["{topic}"] = row ["Topic"].ToString();
emailParams["{link}"] = String.Format( "{0}{1}", basePage.ServerURL, Forum.GetLink( Pages.posts, "m={0}#{0}", messageID ) );
string body = Utils.CreateEmailFromTemplate( "topicpost.txt", ref emailParams );
DB.mail_createwatch( row ["TopicID"], basePage.BoardSettings.ForumEmail, subject, body, row ["UserID"] );
}
}
}
public static void SendMail( pages.ForumPage basePage, string fromEmail, string fromName, string toEmail, string toName, string subject, string body )
{
SendMail( basePage, new System.Net.Mail.MailAddress( fromEmail, fromName ), new System.Net.Mail.MailAddress( toEmail, toName ), subject, body );
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="pages">pages表实例</param>
/// <returns>int</returns>
public static int Insert(pages pagesExample)
{
return(Service.Insert(pagesExample));
}
public static void SendMail( pages.ForumPage basePage, System.Net.Mail.MailAddress fromAddress, System.Net.Mail.MailAddress toAddress, string subject, string body )
{
System.Net.Mail.SmtpClient smtpSend = new System.Net.Mail.SmtpClient( basePage.BoardSettings.SmtpServer );
if ( basePage.BoardSettings.SmtpUserName != null && basePage.BoardSettings.SmtpUserPass != null )
{
smtpSend.Credentials = new System.Net.NetworkCredential( basePage.BoardSettings.SmtpUserName, basePage.BoardSettings.SmtpUserPass );
}
using ( System.Net.Mail.MailMessage emailMessage = new System.Net.Mail.MailMessage() )
{
emailMessage.To.Add( toAddress );
emailMessage.From = fromAddress;
emailMessage.Subject = subject;
emailMessage.Body = body;
if ( !Regex.IsMatch( emailMessage.Body, @"^([0-9a-z!@#\$\%\^&\*\(\)\-=_\+])", RegexOptions.IgnoreCase ) ||
!Regex.IsMatch( emailMessage.Subject, @"^([0-9a-z!@#\$\%\^&\*\(\)\-=_\+])", RegexOptions.IgnoreCase ) )
{
emailMessage.BodyEncoding = Encoding.Unicode;
}
smtpSend.Send( emailMessage );
}
}
protected string CurrentPageCSS(pages thisPage)
{
return (currentPage == thisPage) ? "current" : "";
}
public static void SendMail(pages.ForumPage basePage,string from,string fromName,string to,string toName,string subject,string body)
{
if (toName != null && toName.Length > 0) to = "\"" + toName + "\" <" + to + ">";
if (fromName != null && fromName.Length > 0) from = "\"" + fromName + "\" <" + from + ">";
System.Web.Mail.MailMessage Mail = new System.Web.Mail.MailMessage();
Mail.Fields["http://schemas.microsoft.com/cdo/configuration/smtpserver"] = basePage.BoardSettings.SmtpServer;
Mail.Fields["http://schemas.microsoft.com/cdo/configuration/smtpserverport"] = 25;
Mail.Fields["http://schemas.microsoft.com/cdo/configuration/sendusing"] = 2;
if (basePage.BoardSettings.SmtpUserName != null && basePage.BoardSettings.SmtpUserPass != null)
{
Mail.Fields["http://schemas.microsoft.com/cdo/configuration/smtpauthenticate"] = 1;
Mail.Fields["http://schemas.microsoft.com/cdo/configuration/sendusername"] = basePage.BoardSettings.SmtpUserName;
Mail.Fields["http://schemas.microsoft.com/cdo/configuration/sendpassword"] = basePage.BoardSettings.SmtpUserPass;
}
Mail.To = to;
Mail.From = from;
Mail.Subject = subject;
Mail.Body = body;
System.Web.Mail.SmtpMail.SmtpServer = basePage.BoardSettings.SmtpServer;
System.Web.Mail.SmtpMail.Send(Mail);
}
public static bool user_register( pages.ForumPage page, object boardID, object userName, object password, object email, object location, object homePage, object timeZone, bool emailVerification )
{
string hashinput = DateTime.Now.ToString() + email.ToString() + pages.register.CreatePassword( 20 );
string hash = FormsAuthentication.HashPasswordForStoringInConfigFile( hashinput, "md5" );
using ( SqlConnection conn = GetConnection() )
{
using ( SqlTransaction trans = conn.BeginTransaction( m_isoLevel ) )
{
try
{
using ( SqlCommand cmd = new SqlCommand( "yaf_user_save", conn ) )
{
cmd.Transaction = trans;
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
int UserID = 0;
cmd.Parameters.AddWithValue( "@UserID", UserID );
cmd.Parameters.AddWithValue( "@BoardID", boardID );
cmd.Parameters.AddWithValue( "@UserName", userName );
cmd.Parameters.AddWithValue( "@Password", FormsAuthentication.HashPasswordForStoringInConfigFile( password.ToString(), "md5" ) );
cmd.Parameters.AddWithValue( "@Email", email );
cmd.Parameters.AddWithValue( "@Hash", hash );
cmd.Parameters.AddWithValue( "@Location", location );
cmd.Parameters.AddWithValue( "@HomePage", homePage );
cmd.Parameters.AddWithValue( "@TimeZone", timeZone );
cmd.Parameters.AddWithValue( "@Approved", !emailVerification );
cmd.Parameters.AddWithValue( "@PMNotification", 1 );
cmd.ExecuteNonQuery();
}
if ( emailVerification )
{
// Build a MailMessage
string body = Utils.ReadTemplate( "verifyemail.txt" );
body = body.Replace( "{link}", String.Format( "{1}{0}", Forum.GetLink( Pages.approve, "k={0}", hash ), page.ServerURL ) );
body = body.Replace( "{key}", hash );
body = body.Replace( "{forumname}", page.BoardSettings.Name );
body = body.Replace( "{forumlink}", String.Format( "{0}", page.ForumURL ) );
Utils.SendMail( page, page.BoardSettings.ForumEmail, email.ToString(), String.Format( "{0} email verification", page.BoardSettings.Name ), body );
//ABOT DELETED 16.04.04
//page.AddLoadMessage(page.GetText("REGMAIL_SENT"));
//END ABOT DELETED 16.04.04
trans.Commit();
}
else
{
trans.Commit();
}
}
catch ( Exception x )
{
trans.Rollback();
DB.eventlog_create( null, "user_register in DB.cs", x, EventLogTypes.Error );
//page.AddLoadMessage(x.Message);
return false;
}
}
}
return true;
}
