public List <sp_GetAdgiverFnameLnamePhnResult> GetAdGiverNamePhnByEmail(string userEmailId) { try { OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext(); List <AdGiver> adgiveraccNmaePhn = new List <AdGiver>(); var adGiveraccNamePhn = dbContext.sp_GetAdgiverFnameLnamePhn(userEmailId).ToList(); return(adGiveraccNamePhn); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }