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); }