protected void ButtonLogin_Click(object sender, EventArgs e)
{
try
{
string path = Server.MapPath("./");
string dataSource = Path.Combine(path, "WebApp.db");
using (SQLiteUtility util = new SQLiteUtility(dataSource))
{
util.Connect();
string sql = "SELECT * FROM userinfo WHERE userid = @userid";
string userid = TextBoxId.Text;
Dictionary <string, dynamic> parameters = new Dictionary <string, dynamic>
{
{ "userid", userid },
};
DataTable dataTable = util.Fill(sql, parameters);
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["password"].ToString().Equals(TextBoxPw.Text))
{
LabelMessage.Text = "認証に成功しました。";
SessionManager.UserInfo userInfo = new SessionManager.UserInfo(Session)
{
UserId = userid,
};
Server.Transfer("~/Menu.aspx", true);
}
else
{
LabelMessage.Text = "パスワードが違います。";
}
}
else
{
LabelMessage.Text = "ユーザーが未登録です。";
}
}
}
catch (Exception ex)
{
LabelMessage.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
SessionManager.UserInfo userInfo = new SessionManager.UserInfo(Page.Session);
if (userInfo.UserId != null)
{
// Success
}
else
{
Response.Redirect("~/Login.aspx", false);
}
}
protected void cmdShow_Click(object sender, EventArgs e)
{
DataTable dt = (DataTable)MeisaiData.DataSource;
try
{
string path = Server.MapPath("./sqlite/");
string dataSource = Path.Combine(path, "Kotsuhi.db");
using (SQLiteUtility util = new SQLiteUtility(dataSource))
{
util.Connect();
string usr = new SessionManager.UserInfo(Page.Session).UserId;
string sql = "SELECT " +
" data_id" +
", target_date" +
", transport " +
", station_from" +
", station_to " +
", oneway_cost" +
", ido_kbn " +
", case when ido_kbn = '片道' then oneway_cost else oneway_cost*2 end as cost" +
" FROM kotsuhi WHERE userid = '" + usr + "' ORDER BY userid , data_id";
DataTable dataTable = util.Fill(sql, null);
dataTable.Columns.Add("day");
dataTable.Columns.Add("station_nyoro");
//dataTable.Columns.Add("cost");
if (dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
dr["day"] = "";
dr["station_nyoro"] = "～";
//if (dr["ido_kbn"] == "0")
//{
// dr["ido_kbn"] = "片道";
// dr["cost"] = dr["oneway_cost"];
//}
//else
//{
// dr["ido_kbn"] = "往復";
// dr["cost"] = (int.Parse(dr["oneway_cost"].ToString()) * 2).ToString();
//}
//dt.Rows.Add(dr);
}
//dataTable.Rows[0][];
// this.MeisaiData.DataSource = dataTable;
//this.MeisaiData.DataBind();
dataTable.AcceptChanges();
this.MeisaiData.DataSource = dataTable;
this.MeisaiData.DataBind();
}
else
{
}
}
}
catch (Exception ex)
{
}
}
protected void ButtonLogin_Click(object sender, EventArgs e)
{
bool isLogin = false;
try
{
//string path = Server.MapPath("./sqlite/");
//string dataSource = Path.Combine(path, "WebApp.db");
//using (SQLiteUtility util = new SQLiteUtility(dataSource))
//{
// util.Connect();
// string sql = "SELECT * FROM userinfo WHERE userid = @userid";
// string userid = TextBoxId.Text;
// Dictionary<string, dynamic> parameters = new Dictionary<string, dynamic>
// {
// { "userid", userid },
// };
// DataTable dataTable = util.Fill(sql, parameters);
// if (dataTable.Rows.Count > 0)
// {
// if (dataTable.Rows[0]["password"].ToString().Equals(TextBoxPw.Text))
// {
// LabelMessage.Text = "認証に成功しました。";
// SessionManager.UserInfo userInfo = new SessionManager.UserInfo(Session)
// {
// UserId = userid,
// };
// Server.Transfer("~/Menu.aspx", false);
// }
// else
// {
// LabelMessage.Text = "パスワードが違います。";
// }
// }
// else
// {
// LabelMessage.Text = "ユーザーが未登録です。";
// }
//}
using (ISQLManager manager = SQLManager.GetInterface("WebApp.db"))
{
string sql = "SELECT * FROM userinfo WHERE userid = @userid";
string userid = TextBoxId.Text;
Dictionary <string, dynamic> parameters = new Dictionary <string, dynamic>
{
{ "userid", userid },
};
DataTable dataTable = manager.Select(sql, parameters);
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["password"].ToString().Equals(TextBoxPw.Text))
{
LabelMessage.Text = "認証に成功しました。";
SessionManager.UserInfo userInfo = new SessionManager.UserInfo(Session)
{
UserId = userid,
};
isLogin = true;
}
else
{
LabelMessage.Text = "パスワードが違います。";
}
}
else
{
LabelMessage.Text = "ユーザーが未登録です。";
}
}
}
catch (Exception ex)
{
LabelMessage.Text = ex.Message;
Logger.GetInstance(GetType().Name).WriteException(MethodBase.GetCurrentMethod().Name, ex);
}
if (isLogin)
{
Server.Transfer("~/Menu.aspx", false);
}
}
