protected void Page_Load(object sender, EventArgs e)
{
HttpCookie clientCookie = Request.Cookies.Get(Constants.COOKIE_UTYPE);
HttpCookie utypeCookie = Request.Cookies[Constants.COOKIE_UID];
if (clientCookie == null || utypeCookie == null)
{
Response.Redirect("../Default");
}
if (!clientCookie.Value.Equals(Constants.REGULAR_TYPE))
{
LogoutButton_Click(sender, e);
}
decimal id = Decimal.Parse(utypeCookie.Value);
using (var db = new ds_assign1Entities())
{
AppUser = db.APPLICATIONUSERs.Find(id);
}
if (AppUser == null)
{
LogoutButton_Click(sender, e);
}
Page.DataBind();
ClientScript.RegisterHiddenField("latitude", AppUser.LATITUDE);
ClientScript.RegisterHiddenField("longitude", AppUser.LONGITUDE);
}
protected void UserDataList_UpdateCommand(object source, DataListCommandEventArgs e)
{//
int productID = Convert.ToInt32(UserDataList.DataKeys[e.Item.ItemIndex]);
using (var db = new ds_assign1Entities())
{
var user = db.APPLICATIONUSERs.Find(productID);
if (user == null)
{
return;
}
user.NAME = ((TextBox)e.Item.FindControl(Constants.TEXTBOX_EDIT_NAME)).Text;
user.LOGINID = ((TextBox)e.Item.FindControl(Constants.TEXTBOX_EDIT_ID)).Text;
user.HOMEADDRESS = ((TextBox)e.Item.FindControl(Constants.TEXTBOX_EDIT_HMADDR)).Text;
user.BIRTHDATE = ((TextBox)e.Item.FindControl(Constants.TEXTBOX_EDIT_BDAY)).Text;
user.LONGITUDE = ((TextBox)e.Item.FindControl(Constants.TEXTBOX_EDIT_LONG)).Text;
user.LATITUDE = ((TextBox)e.Item.FindControl(Constants.TEXTBOX_EDIT_LAT)).Text;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
UserDataList.EditItemIndex = -1;
UserDataList.DataBind();
}
public void InsertUser(object sender, EventArgs e)
{
APPLICATIONUSER user = new APPLICATIONUSER();
user.NAME = TextBox_INSERT_Name.Text;
user.LOGINID = TextBox_INSERT_LoginId.Text;
user.LOGINPW = TextBox_INSERT_LoginPW.Text;
user.HOMEADDRESS = TextBox_INSERT_HomeAddr.Text;
user.BIRTHDATE = TextBox_INSERT_Birthday.Text;
user.LONGITUDE = TextBox_INSERT_Longitude.Text;
user.LATITUDE = TextBox_INSERT_Latitude.Text;
if (CheckBox_INSERT_UType.Checked)
{
user.TYPE = Constants.ADMINISTRATOR_TYPE;
}
else
{
user.TYPE = Constants.REGULAR_TYPE;
}
using (var db = new ds_assign1Entities())
{
db.APPLICATIONUSERs.Add(user);
db.SaveChanges();
}
UserDataList.EditItemIndex = -1;
UserDataList.DataBind();
}
public IQueryable <APPLICATIONUSER> GetUsers()
{
if (db == null)
{
db = new ds_assign1Entities();
}
return(db.APPLICATIONUSERs);
}
protected void UserDataList_DeleteCommand(object source, DataListCommandEventArgs e)
{
int productID = Convert.ToInt32(UserDataList.DataKeys[e.Item.ItemIndex]);
using (var db = new ds_assign1Entities())
{
var user = db.APPLICATIONUSERs.Find(productID);
if (user == null)
{
return;
}
db.APPLICATIONUSERs.Remove(user);
db.SaveChanges();
}
UserDataList.EditItemIndex = -1;
UserDataList.DataBind();
}
protected void LogIn(object sender, EventArgs e)
{
db = new ds_assign1Entities();
var users = db.APPLICATIONUSERs;
var reqId = LoginID.Text;
var reqPw = LoginPW.Text;
try
{
var user = users.First(u => u.LOGINID.Equals(reqId) && u.LOGINPW.Equals(reqPw));
if (user != null)
{
HttpCookie userCookie = new HttpCookie(Constants.COOKIE_UTYPE);
userCookie.Value = user.TYPE;
userCookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(userCookie);
if (user.TYPE.Equals(Constants.ADMINISTRATOR_TYPE))
{
Response.Redirect("secured/AdminPage");
}
else
{
HttpCookie userIdCookie = new HttpCookie(Constants.COOKIE_UID);
userIdCookie.Value = user.ID.ToString();
userIdCookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(userIdCookie);
Response.Redirect("regular/UserPage");
}
}
}
catch (Exception)
{ }
db.Dispose();
}
