public IEnumerable <Project> Get()
{
string userName = HttpContext.Current.User.Identity.Name;
// Using LINQ to SQL
using (var fpContext = new OCPSQLEntities())
{
var user = fpContext.SYSTEM_USER
.Where(u => u.USER_NAME == userName)
.SingleOrDefault();
if (user == null)
{
user = new SYSTEM_USER {
USER_NAME = userName
};
fpContext.SYSTEM_USER.Add(user);
fpContext.SaveChanges();
}
var userId = user.USER_ID;
// Retrieve project list from database
var existProjects = fpContext.FPTOOLS_PROJECT
.Where(i => i.USER_ID == userId)
.Select(p => new Project
{
Id = p.PROJECT_ID,
ProjectName = p.PROJECT_NAME,
FileName = p.FILE_NAME,
PlotNumbers = p.IPORTAL_FP.Count(k => k.PROJECT_ID == p.PROJECT_ID)
}).ToList();
return(existProjects);
}
}
private async Task SignInAsync(SYSTEM_USER user, bool isPersistent)
{
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ExternalCookie);
var identity = await UserManager.CreateIdentityAsync(user, DefaultAuthenticationTypes.ApplicationCookie);
AuthenticationManager.SignIn(new AuthenticationProperties()
{
IsPersistent = isPersistent
}, identity);
}
