/// <summary>
/// This method enables user to log into the system
/// </summary>
protected void btnLogIn_Click1(object sender, EventArgs e)
{
IAdminBLL objBLL = AdminBLLFactory.CreateAdminBLLObject();
ILogin objLogin = LoginBOFactory.CreateLoginObject();
try
{
objLogin.EmployeeId = Convert.ToInt32(txtUserName.Text);
objLogin.Password = Convert.ToString(txtPassword.Text);
int roleID = objBLL.ChkLogInCredentials(objLogin);
if (roleID != 0)
{
lblMessage.Text = "Role Id is " + roleID;
objLogin.Role = roleID;
Session["userID"] = objLogin.EmployeeId;
ILogon user = LogonBOFactory.CreateLogonObject();
user = objBLL.GetUserMenu(objLogin);
Session["ObjUserInfo"] = user;
Response.Redirect("HomePage.aspx");
}
else
{
lblMessage.Text = "Incorrect Id or password.";
}
}
catch (Exception ex)
{
lblMessage.Text = "Incorrect User Id or password";
}
}
public ILogon GetUserMenu(ILogin loginDetails)
{
SqlConnection objSQLConn = null;
SqlCommand objSQLCommand = null;
ILogon objLogOn = LogonBOFactory.CreateLogonObject();
try
{
objSQLConn = new SqlConnection(strConnectionString);
objSQLConn.Open();
objSQLCommand = new SqlCommand("usp_GetUserName", objSQLConn);
objSQLCommand.CommandType = System.Data.CommandType.StoredProcedure;
objSQLCommand.Parameters.AddWithValue("@EmployeeID", loginDetails.EmployeeId);
SqlDataReader objSQLReader = objSQLCommand.ExecuteReader();
while (objSQLReader.Read())
{
//objLogOn.EmployeeId = Convert.ToInt32(objSQLReader["EmployeeID"]);
objLogOn.EmployeeName = Convert.ToString(objSQLReader["EmployeeFirstName"]) + " " + Convert.ToString(objSQLReader["EmployeeLastName"]);
objLogOn.RoleName = Convert.ToString(objSQLReader["RoleName"]);
objLogOn.EmployeeId = Convert.ToInt32(objSQLReader["EmployeeID"]);
}
objSQLReader.Close();
objSQLCommand = new SqlCommand("usp_GetMenuItems", objSQLConn);
objSQLCommand.CommandType = System.Data.CommandType.StoredProcedure;
objSQLCommand.Parameters.AddWithValue("@RoleID", loginDetails.Role);
SqlDataReader objSQLReader1 = objSQLCommand.ExecuteReader();
List <IMenu> menuList = new List <IMenu>();
while (objSQLReader1.Read())
{
IMenu menuItem = MenuBOFactory.CreateMenuObject();
menuItem.MenuId = Convert.ToInt32(objSQLReader1["MenuID"]);
menuItem.MenuName = Convert.ToString(objSQLReader1["Title"]);
menuItem.ToolTip = Convert.ToString(objSQLReader1["ToolTip"]);
menuItem.NavigationUrl = Convert.ToString(objSQLReader1["NavigationURL"]);
menuItem.ParentMenuId = Convert.ToInt32(objSQLReader1["RoleID"]);
menuList.Add(menuItem);
}
objLogOn.MenoBo = menuList;
objSQLReader1.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (objSQLConn != null && objSQLConn.State != System.Data.ConnectionState.Closed)
{
objSQLConn.Close();
}
}
return(objLogOn);
}
