// GET: Options/CoAccount public ActionResult Index() { int siteCoID = base.siteusercompanyid; ViewBag.CoSiteUsers = db.GetSiteUsersBySiteCoID(siteCoID); ViewBag.CoPayTypes = db.GetPayTypesBySiteCoID(siteCoID); ViewBag.CoProfiles = db.GetProfilesBySiteCoID(siteCoID); //ViewBag.CoProfileInfo = db.GetProfileInfoByCoProfileID(siteCoID); ViewBag.CoLicenses = db.GetLicensesBySiteCoID(siteCoID); ViewBag.CoCalendar = db.GetCalendarsBySiteCoID(siteCoID).ToList(); var q = db.GetPayrollBySiteCoID(siteCoID).FirstOrDefault(); ViewBag.CoPayroll = q; ViewBag.Frequency = new SelectList(db.PayrollFrequencies.ToList(), "PayrollFrequencyID", "Frequency"); if (q != null) { if (q.FrequencyID != null) { ViewBag.Frequency = new SelectList(db.PayrollFrequencies.ToList(), "PayrollFrequencyID", "Frequency", q.FrequencyID); } } var siteco = db.SiteCompanies.Where(p => p.SiteCoID == (siteCoID)).FirstOrDefault(); ViewBag.SiteCoInfo = siteco; if (siteco.Logo != null) { string imageBase64Data = Convert.ToBase64String(siteco.Logo); string imageDataURL = string.Format("data:image/png;base64,{0}", imageBase64Data); ViewBag.ImageData = imageDataURL; } return(View()); }