/// <summary>
/// Get Single record by his ID
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public List <LoginDetails_VM> GetAccessDetails(LoginDetails_VM Model)
{
List <LoginDetails_VM> Data = new List <LoginDetails_VM>();
try
{
Data = ConnectGetAccessDetailsDataProcedure(Model);
}
catch (Exception ex)
{
logger.Error("UserRepository_GetAccessDetails", ex);
}
return(Data);
}
private List <LoginDetails_VM> ConnectGetAccessDetailsDataProcedure(LoginDetails_VM VM)
{
List <LoginDetails_VM> query = new List <LoginDetails_VM>();
using (var db = new WebPortalEntities())
{
//Get User Role of string type
query = db.Database.SqlQuery <LoginDetails_VM>("exec UserLoginDetails @p_EndUserID",
new SqlParameter[] {
new SqlParameter("p_EndUserID", GetDBNULL(VM.EndUserID, true))
}).ToList();
}
return(query);
}
