public int Update(int AlbumId, string UserId, int TypeId, string AlbumName, string FrontImage, string MainImage, string Description, string Status) { int i = 0; using (MediaEntities dbContext = new MediaEntities()) { using (System.Transactions.TransactionScope transcope = new System.Transactions.TransactionScope()) { //dbContext.CommandTimeout = Settings.CommandTimeout; dbContext.Connection.Open(); string Alias = StringUtils.GenerateFriendlyString(AlbumName); Media_Albums entity = dbContext.Media_Albums.Single(x => x.AlbumId == AlbumId); entity.TypeId = TypeId; entity.AlbumName = AlbumName; entity.Alias = Alias; entity.FrontImage = FrontImage; entity.MainImage = MainImage; entity.Description = Description; entity.IPLastUpdate = IP; entity.LastModifiedByUserId = new Guid(UserId); entity.LastModifiedOnDate = System.DateTime.Now; entity.Status = Status; i = dbContext.SaveChanges(); dbContext.Connection.Close(); transcope.Complete(); } } return(i); }
//INSERT- UPDATE - DELETE public int Insert(string UserId, int TypeId, string AlbumName, string FrontImage, string MainImage, string Description, string Status) { int returnValue = 0; using (MediaEntities dbContext = new MediaEntities()) { using (System.Transactions.TransactionScope transcope = new System.Transactions.TransactionScope()) { string Alias = StringUtils.GenerateFriendlyString(AlbumName); dbContext.CommandTimeout = Settings.CommandTimeout; System.Nullable <Int32> SortKey = (from u in dbContext.Media_Albums select u.SortKey).DefaultIfEmpty(0).Max() + 1; Media_Albums entity = new Media_Albums(); entity.TypeId = TypeId; entity.AlbumName = AlbumName; entity.Alias = Alias; entity.FrontImage = FrontImage; entity.MainImage = MainImage; entity.Description = Description; entity.SortKey = (SortKey == null ? 1 : SortKey); entity.IPLog = IP; entity.CreatedByUserId = new Guid(UserId); entity.CreatedOnDate = System.DateTime.Now; entity.Status = Status; dbContext.AddToMedia_Albums(entity); returnValue = dbContext.SaveChanges(); transcope.Complete(); } } return(returnValue); }
//INSERT- UPDATE - DELETE public int Insert(string UserId, int TypeId, int ParentId, string Name, string Photo, string Description, string Status) { string Alias = module_obj.createTags(Name); using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; System.Nullable <Int32> ListOrder = (from u in dbContext.Media_Types select u.TypeId).DefaultIfEmpty(0).Max() + 1; Media_Topics topic_obj = new Media_Topics(); topic_obj.TypeId = TypeId; topic_obj.Name = Name; topic_obj.Alias = Alias; topic_obj.ParentId = ParentId; topic_obj.ListOrder = (ListOrder == null ? 1 : ListOrder); topic_obj.Photo = Photo; topic_obj.Description = Description; topic_obj.IPLog = IP; topic_obj.CreatedByUserId = new Guid(UserId); topic_obj.CreatedOnDate = System.DateTime.Now; topic_obj.Status = Status; dbContext.AddToMedia_Topics(topic_obj); int i = dbContext.SaveChanges(); return(i); } }
//INSERT- UPDATE - DELETE public int Insert(string UserId, int TypeId, string PlayListName, string FrontImage, string MainImage, string Description, string Status) { using (MediaEntities dbContext = new MediaEntities()) { string Alias = StringUtils.GenerateFriendlyString(PlayListName); dbContext.CommandTimeout = Settings.CommandTimeout; System.Nullable <Int32> SortOrder = (from u in dbContext.Media_PlayLists select u.SortOrder).DefaultIfEmpty(0).Max() + 1; Media_PlayLists entity = new Media_PlayLists(); entity.TypeId = TypeId; entity.PlayListName = PlayListName; entity.Alias = Alias; entity.FrontImage = FrontImage; entity.MainImage = MainImage; entity.Description = Description; entity.SortOrder = (SortOrder == null ? 1 : SortOrder); entity.IPLog = IP; entity.CreatedOnDate = System.DateTime.Now; entity.CreatedByUserId = new Guid(UserId); entity.Status = Status; dbContext.AddToMedia_PlayLists(entity); int i = dbContext.SaveChanges(); return(i); } }
public int Delte(int TypeId) { using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; //Media_Types type_obj = (from x in dbContext.Media_Types where x.TypeId == TypeId select x).First(); Media_Types type_obj = dbContext.Media_Types.Single(x => x.TypeId == TypeId); dbContext.DeleteObject(type_obj); int i = dbContext.SaveChanges(); return(i); } }
public int UpdateSortKey(string UserId, int AlbumId, int SortKey) { using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; Media_Albums album_obj = dbContext.Media_Albums.Single(x => x.AlbumId == AlbumId); album_obj.IPLastUpdate = IP; album_obj.LastModifiedByUserId = new Guid(UserId); album_obj.LastModifiedOnDate = System.DateTime.Now; album_obj.SortKey = SortKey; int i = dbContext.SaveChanges(); return(i); } }
public int UpdateSortKey(string UserId, int ArtistId, int ListOrder) { using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; Media_Artists artists_obj = dbContext.Media_Artists.Single(x => x.ArtistId == ArtistId); artists_obj.IPLastUpdate = IP; artists_obj.LastModifiedByUserId = new Guid(UserId); artists_obj.LastModifiedDate = System.DateTime.Now; artists_obj.ListOrder = ListOrder; int i = dbContext.SaveChanges(); return(i); } }
public int UpdateSortKey(string UserId, int ComposerId, int ListOrder) { using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; Media_Composers composers_obj = dbContext.Media_Composers.Single(x => x.ComposerId == ComposerId); composers_obj.IPModifiedLog = IP; composers_obj.LastModifiedByUserId = new Guid(UserId); composers_obj.LastModifiedOnDate = System.DateTime.Now; composers_obj.ListOrder = ListOrder; int i = dbContext.SaveChanges(); return(i); } }
public int UpdateStatus(string UserId, int TypeId, string Status) { using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; Media_Types type_obj = dbContext.Media_Types.Single(x => x.TypeId == TypeId); type_obj.TypeId = TypeId; type_obj.Status = Status; type_obj.LastModifiedByUserId = new Guid(UserId); type_obj.ModifiedDate = System.DateTime.Now; int i = dbContext.SaveChanges(); return(i); } }
public int UpdateSortKey(string UserId, int PlayListId, int SortOrder) { using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; Media_PlayLists playLists_obj = dbContext.Media_PlayLists.Single(x => x.PlayListId == PlayListId); playLists_obj.IPModifiedLog = IP; playLists_obj.LastModifiedOnDate = System.DateTime.Now; playLists_obj.LastModifiedByUserId = new Guid(UserId); playLists_obj.SortOrder = SortOrder; int i = dbContext.SaveChanges(); return(i); } }
public int UpdateSortKey(string UserId, int TopicId, int ListOrder) { using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; Media_Topics topic_obj = dbContext.Media_Topics.Single(x => x.TopicId == TopicId); topic_obj.TopicId = TopicId; topic_obj.ListOrder = ListOrder; topic_obj.LastModifiedByUserId = new Guid(UserId); topic_obj.LastModifiedDate = System.DateTime.Now; int i = dbContext.SaveChanges(); return(i); } }
public ActionResult Create(Image im) { string fileName = Path.GetFileNameWithoutExtension(im.ImageFile.FileName); string extension = Path.GetExtension(im.ImageFile.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; im.FilePath = "~/Images/" + fileName; fileName = Path.Combine(Server.MapPath("~/Images/") + fileName); im.ImageFile.SaveAs(fileName); using (MediaEntities db = new MediaEntities()) { db.Images.Add(im); db.SaveChanges(); } ModelState.Clear(); return(RedirectToAction("Index")); }
public int Delete(string UserId, int Idx, string Dir_Path) { using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; string filename = (from x in dbContext.Media_Topics where x.TopicId == Idx select x.Photo).SingleOrDefault(); if (filename != null && filename != string.Empty) { module_obj.deleteFile(filename, Dir_Path); } //Media_Topics topic_obj = (from x in dbContext.Media_Topics where x.TopicId == Idx select x).First(); Media_Topics topic_obj = dbContext.Media_Topics.Single(x => x.TopicId == Idx); dbContext.DeleteObject(topic_obj); int i = dbContext.SaveChanges(); return(i); } }
public int Update(int TypeId, string UserId, string TypeName, string TypeExt, string TypePath, string Description, string Status) { using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; //Media_Types type_obj = (from x in dbContext.Media_Types where x.TypeId == TypeId select x).First(); Media_Types type_obj = dbContext.Media_Types.Single(x => x.TypeId == TypeId); type_obj.TypeName = TypeName; type_obj.TypeExt = TypeExt; type_obj.TypePath = TypePath; type_obj.Description = Description; type_obj.IPModifiedLog = IP; type_obj.ModifiedDate = System.DateTime.Now; type_obj.LastModifiedByUserId = new Guid(UserId); type_obj.Status = Status; int i = dbContext.SaveChanges(); return(i); } }
public ActionResult Create(MediaFile mediafile) { string fileName = Path.GetFileNameWithoutExtension(mediafile.upload.FileName); string extension = Path.GetExtension(mediafile.upload.FileName); fileName = fileName + extension; mediafile.FilePath = "~/Music/" + fileName; mediafile.MediaFileType = extension; fileName = Path.Combine(Server.MapPath("~/Music/") + fileName); mediafile.upload.SaveAs(fileName); using (MediaEntities db = new MediaEntities()) { db.MediaFiles.Add(mediafile); db.SaveChanges(); } ModelState.Clear(); return(RedirectToAction("Index")); }
public int Update(int ComposerId, string UserId, string ComposerName, string FrontImage, string MainImage, string Description, string Status) { using (MediaEntities dbContext = new MediaEntities()) { string Alias = StringUtils.GenerateFriendlyString(ComposerName); dbContext.CommandTimeout = Settings.CommandTimeout; Media_Composers composers_obj = dbContext.Media_Composers.Single(x => x.ComposerId == ComposerId); composers_obj.ComposerName = ComposerName; composers_obj.Alias = Alias; composers_obj.FrontImage = FrontImage; composers_obj.MainImage = MainImage; composers_obj.Description = Description; composers_obj.IPModifiedLog = IP; composers_obj.LastModifiedOnDate = System.DateTime.Now; composers_obj.LastModifiedByUserId = new Guid(UserId); composers_obj.Status = Status; int i = dbContext.SaveChanges(); return(i); } }
public int Update(int ArtistId, string UserId, string ArtistName, string FrontImage, string MainImage, string Description, string Status) { using (MediaEntities dbContext = new MediaEntities()) { string Alias = StringUtils.GenerateFriendlyString(ArtistName); dbContext.CommandTimeout = Settings.CommandTimeout; Media_Artists artists_obj = dbContext.Media_Artists.Single(x => x.ArtistId == ArtistId); artists_obj.ArtistName = ArtistName; artists_obj.Alias = Alias; artists_obj.FrontImage = FrontImage; artists_obj.MainImage = MainImage; artists_obj.Description = Description; artists_obj.IPLastUpdate = IP; artists_obj.LastModifiedDate = System.DateTime.Now; artists_obj.LastModifiedByUserId = new Guid(UserId); artists_obj.Status = Status; int i = dbContext.SaveChanges(); return(i); } }
public int Update(int PlayListId, int TypeId, string UserId, string PlayListName, string FrontImage, string MainImage, string Description, string Status) { using (MediaEntities dbContext = new MediaEntities()) { string Alias = StringUtils.GenerateFriendlyString(PlayListName); dbContext.CommandTimeout = Settings.CommandTimeout; Media_PlayLists entity = dbContext.Media_PlayLists.Single(x => x.PlayListId == PlayListId); entity.TypeId = TypeId; entity.PlayListName = PlayListName; entity.Alias = Alias; entity.FrontImage = FrontImage; entity.MainImage = MainImage; entity.Description = Description; entity.IPModifiedLog = IP; entity.LastModifiedOnDate = System.DateTime.Now; entity.LastModifiedByUserId = new Guid(UserId); entity.Status = Status; int i = dbContext.SaveChanges(); return(i); } }
/* ------------------------------------------------------------------------------- */ // Lägg till Customer Rad i tabelen private void AddCustomerToDb() { using (var ctx = new MediaEntities()) { if (!string.IsNullOrEmpty(txtName.Text) && !string.IsNullOrEmpty(txtAddress.Text) && !string.IsNullOrEmpty(txtPhone.Text)) { Customer newCustomer = new Customer(); newCustomer.CustomerName = txtName.Text; newCustomer.CustomerAdress = txtAddress.Text; newCustomer.CustomerPhone = txtPhone.Text; ctx.Customers.Add(newCustomer); ctx.SaveChanges(); } } // Printa ut resultat lblResult.Text = "Customer added successfully"; }
//INSERT- UPDATE - DELETE public int Insert(string UserId, string TypeName, string TypeExt, string TypePath, string Description, string Status) { using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; System.Nullable <Int32> ListOrder = (from u in dbContext.Media_Types select u.TypeId).DefaultIfEmpty(0).Max() + 1; Media_Types type_obj = new Media_Types(); type_obj.TypeName = TypeName; type_obj.TypeExt = TypeExt; type_obj.TypePath = TypePath; type_obj.Description = Description; type_obj.CreatedByUserId = new Guid(UserId); type_obj.CreatedOnDate = System.DateTime.Now; type_obj.IPLog = IP; type_obj.ListOrder = (ListOrder == null ? 1 : ListOrder); type_obj.Status = Status; dbContext.AddToMedia_Types(type_obj); int i = dbContext.SaveChanges(); return(i); } }
/* ------------------------------------------------------------------------------- */ // Lägg till Film Rad i tabelen private void AddMovieToDb() { using (var ctx = new MediaEntities()) { if (!string.IsNullOrEmpty(txtMovieName.Text) && !string.IsNullOrEmpty(txtDirectorName.Text)) { LoadGenres(); Movy NewMovie = new Movy(); NewMovie.MovieName = txtMovieName.Text; NewMovie.DirectorName = txtDirectorName.Text; NewMovie.ReleaseDate = DateTime.Parse(txtReleaseDate.Text); NewMovie.genreID = Convert.ToInt16(Genres.SelectedValue); ctx.Movies.Add(NewMovie); ctx.SaveChanges(); } } // Printa ut resultat lblResult.Text = "Movie added successfully"; }
public int Update(string UserId, int TypeId, int TopicId, int ParentId, string Name, string Photo, string Description, string Status) { string Alias = module_obj.createTags(Name); using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; Media_Topics topic_obj = dbContext.Media_Topics.Single(x => x.TopicId == TopicId); topic_obj.TypeId = TypeId; topic_obj.TopicId = TopicId; topic_obj.Name = Name; topic_obj.Alias = Alias; topic_obj.ParentId = ParentId; topic_obj.Photo = Photo; topic_obj.Description = Description; topic_obj.IPLog = IP; topic_obj.CreatedByUserId = new Guid(UserId); topic_obj.CreatedOnDate = System.DateTime.Now; topic_obj.Status = Status; int i = dbContext.SaveChanges(); return(i); } }
protected void btnRentMovie_Click(object sender, EventArgs e) { using (var ctx = new MediaEntities()) { int ID = Convert.ToInt32(Request.QueryString["MovieID"].ToString()); Movy mov = (from m in ctx.Movies where m.MovieId == ID select m).First(); foreach (Customer C in ctx.Customers) { ListItem newItem = new ListItem(); newItem.Text = C.CustomerName; newItem.Value = C.CustomerID.ToString(); Customers.Items.Add(newItem); } RentedMovy RM = new RentedMovy(); RM.MovieID = mov.MovieId; RM.CustomerID = Convert.ToInt16(Customers.SelectedValue); try { // Try and confirm to date time. If not show error. RM.RentedTo = DateTime.Parse(RentTo.Text); } catch (Exception ex) { lblResult.Text = "Don't recognize the date format"; return; } ctx.RentedMovies.Add(RM); ctx.SaveChanges(); // Show confirmation to user that movie is saved lblResult.Text = "Movie rented successfully"; } }
//INSERT- UPDATE - DELETE public int Insert(string UserId, string ComposerName, string FrontImage, string MainImage, string Description, string Status) { using (MediaEntities dbContext = new MediaEntities()) { string Alias = StringUtils.GenerateFriendlyString(ComposerName); dbContext.CommandTimeout = Settings.CommandTimeout; System.Nullable <Int32> ListOrder = (from u in dbContext.Media_Composers select u.ListOrder).DefaultIfEmpty(0).Max() + 1; Media_Composers composers_obj = new Media_Composers(); composers_obj.ComposerName = ComposerName; composers_obj.Alias = Alias; composers_obj.FrontImage = FrontImage; composers_obj.MainImage = MainImage; composers_obj.Description = Description; composers_obj.ListOrder = (ListOrder == null ? 1 : ListOrder); composers_obj.IPLog = IP; composers_obj.CreatedOnDate = System.DateTime.Now; composers_obj.CreatedByUserId = new Guid(UserId); composers_obj.Status = Status; dbContext.AddToMedia_Composers(composers_obj); int i = dbContext.SaveChanges(); return(i); } }