protected void LogIn(object sender, EventArgs e)
{
var id = 0;
var name = "";
var role = 0;
var loginFrom = new DbConnection();
loginFrom.ConnectDatabase();
var loginCommand = new SqlCommand("dbo.loginForm", loginFrom.DbConnect)
{
CommandType = CommandType.StoredProcedure
};
loginCommand.Parameters.AddWithValue("email", Email.Text);
loginCommand.Parameters.AddWithValue("password", Password.Text);
var reader = loginCommand.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
id = Convert.ToInt32(reader["UserID"]);
name = (Convert.ToString(reader["Name"])).Trim();
role = Convert.ToInt32(reader["RoleID"]);
}
Session["UserID"] = id;
Session["Name"] = name;
Session["Role"] = role;
Session["Email"] = Email.Text;
Response.Redirect("~/Default.aspx");
}
else
{
Response.Redirect("~/Default.aspx");
}
}
/// <summary>
/// View User Name for Dropdown list
/// </summary>
public void ViewUserNameDropdownList()
{
var listUserName = new DbConnection();
listUserName.ConnectDatabase();
var viewCommand = new SqlCommand("dbo.selectUser", listUserName.DbConnect)
{
CommandType = CommandType.StoredProcedure
};
var dataAdapter = new SqlDataAdapter(viewCommand);
var dataSet = new DataSet();
dataAdapter.Fill(dataSet);
ddlUserName.DataSource = dataSet;
ddlUserName.DataTextField = "Name";
ddlUserName.DataValueField = "UserID";
ddlUserName.DataBind();
ddlUserName.Items.Insert(0, new ListItem("-- select --", "none"));
}
/// <summary>
/// View infomation for UserTask managerment
/// </summary>
public void BindDataToGridView()
{
try
{
var dataManager = new DbConnection();
dataManager.ConnectDatabase();
var viewCommand = new SqlCommand("dbo.selectUserTask", dataManager.DbConnect)
{
CommandType = CommandType.StoredProcedure
};
var dataAdapter = new SqlDataAdapter(viewCommand);
var dataSet = new DataSet();
dataAdapter.Fill(dataSet);
gvUserTask.DataSource = dataSet;
gvUserTask.DataBind();
ltMessage.Text = "View data compate !";
}
catch (Exception ex)
{
ltMessage.Text = ex.Message;
}
}
/// <summary>
/// View userID, TaskID over Dropdownlist
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gvUserTask_OnRowDataBound(object sender, GridViewRowEventArgs e)
{
var dataUser = new DbConnection();
dataUser.ConnectDatabase();
if (e.Row.RowType == DataControlRowType.DataRow && gvUserTask.EditIndex == e.Row.RowIndex)
{
var ddlUserId = (DropDownList)e.Row.FindControl("ddlUser_ID");
var viewUser = new SqlCommand("select distinct UserID from Users", dataUser.DbConnect);
var dataAdapterUser = new SqlDataAdapter(viewUser);
var dataSetUser = new DataSet();
dataAdapterUser.Fill(dataSetUser);
ddlUserId.DataSource = dataSetUser;
ddlUserId.DataTextField = "UserID";
ddlUserId.DataValueField = "UserID";
ddlUserId.DataBind();
var ddlTaskId = (DropDownList)e.Row.FindControl("ddlTask_ID");
var viewTask = new SqlCommand("select distinct TaskID from Tasks", dataUser.DbConnect);
var dataAdapterTask = new SqlDataAdapter(viewTask);
var dataSetTask = new DataSet();
dataAdapterTask.Fill(dataSetTask);
ddlTaskId.DataSource = dataSetTask;
ddlTaskId.DataTextField = "TaskID";
ddlTaskId.DataValueField = "TaskID";
ddlTaskId.DataBind();
}
}