public bool AuthenticateUser(string password)
{
SSODBDataContext db = new SSODBDataContext();
var psw = (from c in db.MainAppCredentials
where c.Userid == _userId
select c.Password).ToList();
string strPsw = psw[0].ToString();
return(strPsw == password ? true : false);
}
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
SSODBDataContext db = new SSODBDataContext();
if (!db.DatabaseExists())
{
db.CreateDatabase();
}
}
public DataTable GetAppAccessDetails()
{
SSODBDataContext db = new SSODBDataContext();
var results = (from a in db.Apps
join ua in db.UserAppMaps on a.AppId equals ua.AppId
where ua.MUserId == _userId
select a).ToList();
DataTable dtRes = new DataTable();
dtRes.Columns.Add("ApplicationName");
dtRes.Columns.Add("ApplicationURL");
foreach (var c in results)
{
DataRow dr = dtRes.NewRow();
dr[0] = c.AppName;
dr[1] = c.AppUrl;
dtRes.Rows.Add(dr);
}
return(dtRes);
}
