public void GetDocumentDetails() { //Now get the details System.Data.DataSet ds = new SandlerRepositories.DocumentsRepository().GetDetailsById(Convert.ToInt32(hidDocumentID.Value)); DocumentDW.DataSource = ds; //Find the company ID for this Document and store in the Hidden field hidCompanyID.Value = ds.Tables[0].Rows[0]["COMPANIESID"].ToString(); hidDocumentName.Value = ds.Tables[0].Rows[0]["DOCNAME"].ToString(); hdnDocFullName.Value = ds.Tables[0].Rows[0]["docFullName"].ToString(); DocumentDW.DataBind(); }
private IEnumerable<TBL_DOCS> GetDocuments(UserModel user) { IEnumerable<TBL_DOCS> documents = null; DocumentsRepository documentsSource = new DocumentsRepository(); try { if (user.Role == SandlerRoles.FranchiseeUser) documents = documentsSource.GetAll().Where(record => record.IsActive == true && record.CreatedBy.ToLower() == user.UserId.ToString().ToLower()).AsEnumerable(); else if (user.Role == SandlerRoles.FranchiseeOwner) { documents = from document in documentsSource.GetAll().Where(record => record.IsActive == true && record.TBL_COMPANIES.FranchiseeId == user.FranchiseeID) select document; } else if (user.Role == SandlerRoles.Coach) { FranchiseeRepository franchiseeSource = new FranchiseeRepository(); CoachRepository coachSource = new CoachRepository(); //documents = from opportunity in opportunitiesSource.GetAll().Where(record => record.IsActive == true) // from company in companies.Where(record => record.COMPANIESID == opportunity.COMPANYID) // from franchisee in franchisees.Where(record => record.ID == company.FranchiseeId) // select opportunity; documents = from document in documentsSource.GetAll().Where(record => record.IsActive == true && record.TBL_COMPANIES.TBL_FRANCHISEE.CoachID == user.CoachID) select document; } else if (user.Role == SandlerRoles.Corporate) { documents = documentsSource.GetAll().Where(record => record.IsActive == true).AsEnumerable(); } } catch (Exception ex) { throw new Exception("exception in UserEntities.Getopportunities: " + ex.Message); } return documents; }