public static void CreateNewExternalWebsite(ExternalWebsite website) { try { website.DateAdded = DateTime.Now; website.Department = int.Parse(website.SelectedDepartment); if (website.Url.StartsWith("http://") || website.Url.StartsWith("https://")) { } else { website.Url = website.Url.Insert(0, "http://"); } } catch { return; } using (FreeMarketEntities db = new FreeMarketEntities()) { db.ExternalWebsites.Add(website); db.SaveChanges(); } }
public static ExternalWebsite GetNewWebsite() { ExternalWebsite website = new ExternalWebsite(); website.DateAdded = DateTime.Now; using (FreeMarketEntities db = new FreeMarketEntities()) { website.Departments = db.Departments .Select(c => new SelectListItem { Text = "(" + c.DepartmentNumber + ")" + c.DepartmentName, Value = c.DepartmentNumber.ToString() }) .ToList(); } return(website); }
public static ExternalWebsite GetWebsite(int websiteNumber) { ExternalWebsite website = new ExternalWebsite(); using (FreeMarketEntities db = new FreeMarketEntities()) { var websiteInfo = db.ExternalWebsites.Find(websiteNumber); if (websiteInfo == null) { return(website); } else { website = websiteInfo; } website.MainImageNumber = db.ExternalWebsitePictures .Where(c => c.WebsiteNumber == website.LinkId && c.Dimensions == PictureSize.Medium.ToString()) .Select(c => c.PictureNumber) .FirstOrDefault(); website.AdditionalImageNumber = db.ExternalWebsitePictures .Where(c => c.WebsiteNumber == website.LinkId && c.Dimensions == PictureSize.Large.ToString()) .Select(c => c.PictureNumber) .FirstOrDefault(); website.Departments = db.Departments .Select(c => new SelectListItem { Text = "(" + c.DepartmentNumber + ") " + c.DepartmentName, Value = c.DepartmentNumber.ToString(), Selected = c.DepartmentNumber == website.Department ? true : false }) .ToList(); } return(website); }
public static void SaveExternalWebsite(ExternalWebsite website) { using (FreeMarketEntities db = new FreeMarketEntities()) { try { if (website.Url.StartsWith("http://") || website.Url.StartsWith("https://")) { } else { website.Url = website.Url.Insert(0, "http://"); } website.Department = int.Parse(website.SelectedDepartment); db.Entry(website).State = EntityState.Modified; db.SaveChanges(); } catch (Exception e) { ExceptionLogging.LogException(e); } } }