public void DeleteNews(News news) { using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext))) { var newsEntity = from item in context.News where item.NewsID == news.NewsID select item; News entity = newsEntity.SingleOrDefault(); if (entity != null) { context.DeleteObject(entity); context.SaveChanges(); } } }
protected void btnSave_Click(object sender, EventArgs e) { Entities.News entity = new Entities.News(); try { entity.NewsID = base.GetInt32("ID"); entity.Title = txtNewsTitle.Text; entity.Text = txtNewsText.Text; entity.IsEnabled = chkUserIsEnabled.Checked; switch (base.Operation) { case "I": entity = SaveFile(); if (entity != null) { entity.Title = txtNewsTitle.Text; entity.Text = txtNewsText.Text; entity.IsEnabled = chkUserIsEnabled.Checked; ServiceFactory.CreateConfigurationService.InsertNews(entity); } break; case "U": ServiceFactory.CreateConfigurationService.UpdateNews(entity); break; case "D": ServiceFactory.CreateConfigurationService.DeleteNews(entity); break; } Response.Redirect("NewsList.aspx", false); } catch { base.SetMessage(lblMessage, MessageType.Error, ResourceMessages.UnexpectedErrorMessage); } }
public Entities.News SaveFile() { if (FileUploadControl.HasFile) { Entities.News result = new Entities.News(); string extension = Path.GetExtension(FileUploadControl.FileName); string filename = Path.GetFileName(FileUploadControl.FileName); string aux = filename.Replace(extension, ""); try { string saveName = aux + DateTime.Now.ToString("_ddMMyyyy") + extension; FileUploadControl.SaveAs(Server.MapPath(Param.NewsDocumentLibrary) + saveName); result.FilePath = Param.NewsDocumentLibrary + saveName; } catch (Exception ex) { throw ex; } return result; } return null; }
public void UpdateNews(News news) { using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext))) { var newsList = from item in context.News where item.NewsID == news.NewsID select item; News entity = newsList.SingleOrDefault(); if (entity != null) { entity.Title = news.Title; entity.Text = news.Text; entity.IsEnabled = news.IsEnabled; context.SaveChanges(); } } }
public void InsertNews(News news) { using (ConfigurationDataContext context = new ConfigurationDataContext(Utility.GetConnectionString(configurationDataContext))) { news.CreateDate = DateTime.Now; context.AddToNews(news); context.SaveChanges(); } }
/// <summary> /// Create a new News object. /// </summary> /// <param name="newsID">Initial value of the NewsID property.</param> /// <param name="title">Initial value of the Title property.</param> /// <param name="text">Initial value of the Text property.</param> /// <param name="filePath">Initial value of the FilePath property.</param> /// <param name="createDate">Initial value of the CreateDate property.</param> /// <param name="isEnabled">Initial value of the IsEnabled property.</param> public static News CreateNews(global::System.Int32 newsID, global::System.String title, global::System.String text, global::System.String filePath, global::System.DateTime createDate, global::System.Boolean isEnabled) { News news = new News(); news.NewsID = newsID; news.Title = title; news.Text = text; news.FilePath = filePath; news.CreateDate = createDate; news.IsEnabled = isEnabled; return news; }
/// <summary> /// Deprecated Method for adding a new object to the News EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToNews(News news) { base.AddObject("News", news); }