/**
* Create a new user
**/
public bool CreateUser( User newuser )
{
bool toReturn = false;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "INSERT INTO [dbo].[User] ( Name, ID, Email, Password ) VALUES (@Name,@User,@mail,@pass)";
cmd.Parameters.AddWithValue("@Name", newuser.GetName());
cmd.Parameters.AddWithValue("@User", newuser.GetUserName());
cmd.Parameters.AddWithValue("@mail", newuser.GetEmail());
cmd.Parameters.AddWithValue("@pass", newuser.GetPassword());
cmd.Connection = conn;
conn.Open();
if (cmd.ExecuteNonQuery()!=0)
{
toReturn = true;
}
conn.Close();
}
}
return toReturn;
}
public void UserTest()
{
User user = new User("NewName", "NewUserName", "NewEmail", "password");
Assert.AreEqual("NewName", user.GetName());
Assert.AreEqual("NewUserName", user.GetUserName());
Assert.AreEqual("NewEmail", user.GetEmail());
Assert.AreEqual("password", user.GetPassword());
}
protected void Page_Load(object sender, EventArgs e)
{
mUser = new DB.User((string)Session["username"], (string)Session["password"]);
name.InnerText = mUser.GetUserName() + "'s Roadmaps";
searchtable.Rows.Clear();
searchtable.Visible = false;
createbutton.Enabled = false;
//searchb.Enabled = true;
if (Request.Form["username_ID"] != "" && Request.Form["password_ID"] != "") //FIX: Lets null login. is useful though
{
RocketRoadmap.DB.User user = new RocketRoadmap.DB.User(Request.Form["username_ID"], Request.Form["password_ID"]);
bool flag = user.Login();
if (flag)
{
Session["username"] = user.GetUserName();
Session["password"] = user.GetPassword();
mUser = new DB.User((string)Session["username"], (string)Session["password"]);
name.InnerText = user.GetUserName() + "'s Roadmaps";
}
else if (mUser.Login())
{
}
else
{
Response.Redirect("index.aspx", false);
}
}
else
{
Response.Redirect("index.aspx", false);
return;
}
if (mUser.Login())
{
RoadMaps umaps = new RoadMaps();
try
{
List<List<string>> uall = umaps.GetUserMapsInfo(mUser.GetUserName());
TableHeaderRow uhead = new TableHeaderRow();
TableHeaderCell u1 = new TableHeaderCell();
TableHeaderCell u2 = new TableHeaderCell();
TableHeaderCell u3 = new TableHeaderCell();
TableHeaderCell u4 = new TableHeaderCell();
TableHeaderCell u5 = new TableHeaderCell();
TableHeaderCell u6 = new TableHeaderCell();
u1.Text = "Name";
u1.Width = new Unit(20, UnitType.Percentage);
u2.Text = "Author";
u2.Width = new Unit(15, UnitType.Percentage);
u3.Text = "Description";
u3.Width = new Unit(40, UnitType.Percentage);
u4.Text = "Timestamp";
u4.Width = new Unit(20, UnitType.Percentage);
u5.Width = new Unit(5, UnitType.Percentage);
uhead.Cells.Add(u1);
uhead.Cells.Add(u2);
uhead.Cells.Add(u3);
uhead.Cells.Add(u4);
uhead.Cells.Add(u5);
userroadmaps.Rows.Add(uhead);
foreach (var umap in uall)
{
TableRow urow = new TableRow();
TableCell ucell_1 = new TableCell();
TableCell ucell_2 = new TableCell();
TableCell ucell_3 = new TableCell();
TableCell ucell_4 = new TableCell();
TableCell ucell_5 = new TableCell();
HtmlInputButton deleteButton = new HtmlInputButton();
deleteButton.Value = "X";
deleteButton.Attributes.Add("onclick","AreYouSure(\""+umap[0]+"\");");
HyperLink link = new HyperLink();
link.NavigateUrl = "Roadmap.aspx?n=" + Uri.EscapeUriString(umap[0]);
link.Text = umap[0];
TableCell tCell1 = new TableCell();
ucell_1.Controls.Add(link);
ucell_2.Text = umap[1];
ucell_3.Text = umap[2];
ucell_4.Text = umap[3];
ucell_5.Controls.Add(deleteButton);
urow.Cells.Add(ucell_1);
urow.Cells.Add(ucell_2);
urow.Cells.Add(ucell_3);
urow.Cells.Add(ucell_4);
urow.Cells.Add(ucell_5);
userroadmaps.Rows.Add(urow);
}
}
catch (NullReferenceException nre)
{
}
}
RoadMaps maps = new RoadMaps();
try
{
List<List<string>> all = maps.GetAllMapsInfo();
TableHeaderRow uhead = new TableHeaderRow();
TableHeaderCell u1 = new TableHeaderCell();
TableHeaderCell u2 = new TableHeaderCell();
TableHeaderCell u3 = new TableHeaderCell();
TableHeaderCell u4 = new TableHeaderCell();
TableHeaderCell u5 = new TableHeaderCell();
TableHeaderCell u6 = new TableHeaderCell();
u1.Text = "Name";
u1.Width = new Unit(20, UnitType.Percentage);
u2.Text = "Author";
u2.Width = new Unit(15, UnitType.Percentage);
u3.Text = "Description";
u3.Width = new Unit(40, UnitType.Percentage);
u4.Text = "Timestamp";
u4.Width = new Unit(20, UnitType.Percentage);
u5.Width = new Unit(5, UnitType.Percentage);
uhead.Cells.Add(u1);
uhead.Cells.Add(u2);
uhead.Cells.Add(u3);
uhead.Cells.Add(u4);
uhead.Cells.Add(u5);
allroadmaps.Rows.Add(uhead);
foreach (var map in all)
{
TableRow row = new TableRow();
TableCell cell_1 = new TableCell();
TableCell cell_2 = new TableCell();
TableCell cell_3 = new TableCell();
TableCell cell_4 = new TableCell();
TableCell cell_5 = new TableCell();
TableCell cell_6 = new TableCell();
HyperLink link = new HyperLink();
link.NavigateUrl = "Roadmap.aspx?n=" + map[0];
link.Text = map[0];
TableCell tCell1 = new TableCell();
cell_1.Controls.Add(link);
cell_2.Text = map[1];
cell_3.Text = map[2];
cell_4.Text = map[3];
row.Cells.Add(cell_1);
row.Cells.Add(cell_2);
row.Cells.Add(cell_3);
row.Cells.Add(cell_4);
row.Cells.Add(cell_5);
allroadmaps.Rows.Add(row);
}
}
catch (NullReferenceException nre)
{
}
}
