public List <MediaCollection> GetMediaCollectionsDescriptions(string UserName, MediaType MediaType) { int Id = 0; XmlDocument XMLStore = new XmlDocument(); XMLStore.Load(XMLDescriptionFile); XmlElement root = XMLStore.DocumentElement; List <MediaCollection> mediaCollections = new List <MediaCollection>(); foreach (XmlNode item in root.ChildNodes) { if (item.Attributes["UserName"].Value.ToString() == UserName && item.Attributes["MediaType"].Value.ToString() == ((int)MediaType).ToString()) { MediaCollection mediaCollection = new MediaCollection(); mediaCollection.Id = Id; mediaCollection.UserName = item.Attributes["UserName"].Value.ToString(); mediaCollection.MediaType = MediaType; mediaCollection.ShortTitle = item.Attributes["ShortTitle"].Value.ToString(); mediaCollection.Title = item.Attributes["Title"].Value.ToString(); mediaCollection.Location = item.Attributes["Location"].Value.ToString(); mediaCollection.Description = item.Attributes["Description"].Value.ToString(); mediaCollections.Add(mediaCollection); } ++Id; } return(mediaCollections); }
public void AddMediaCollectionDescription(MediaCollection MediaCollection) { XmlDocument XMLStore = new XmlDocument(); XMLStore.Load(XMLDescriptionFile); XmlElement node_mediaCollection = XMLStore.CreateElement("item" + (GetLastCollectionId() + 2)); XmlAttribute attr_userName = XMLStore.CreateAttribute("UserName"); attr_userName.Value = MediaCollection.UserName; node_mediaCollection.Attributes.Append(attr_userName); XmlAttribute attr_mediaType = XMLStore.CreateAttribute("MediaType"); attr_mediaType.Value = MediaCollection.MediaType.ToString(); node_mediaCollection.Attributes.Append(attr_mediaType); XmlAttribute attr_Location = XMLStore.CreateAttribute("Location"); attr_Location.Value = MediaCollection.Location; node_mediaCollection.Attributes.Append(attr_Location); XmlAttribute attr_ShortTitle = XMLStore.CreateAttribute("ShortTitle"); attr_ShortTitle.Value = MediaCollection.ShortTitle; node_mediaCollection.Attributes.Append(attr_ShortTitle); XmlAttribute attr_Title = XMLStore.CreateAttribute("Title"); attr_Title.Value = MediaCollection.ShortTitle; node_mediaCollection.Attributes.Append(attr_Title); XmlAttribute attr_Description = XMLStore.CreateAttribute("Description"); attr_Description.Value = MediaCollection.Description; node_mediaCollection.Attributes.Append(attr_Description); XMLStore.DocumentElement.InsertAfter(node_mediaCollection, XMLStore.DocumentElement.LastChild); XMLStore.Save(XMLDescriptionFile); }
//SHOW ITEM public ActionResult ShowItem(int CollectionId) { MediaCollection MediaCollection = new MediaCollection(); MediaCollection = repository.GetMediaCollectionDescription(CollectionId); ViewBag.collectionTitle = MediaCollection.ShortTitle.ToString(); return View(repository.TransformToVideoMediaCollection(CollectionId)); }
public List <MediaCollection> GetMediaCollectionsDescriptions(string UserName, MediaType MediaType) { NpgsqlConnection connection = new NpgsqlConnection(connectionString); NpgsqlCommand command = new NpgsqlCommand(@"SELECT * FROM dbo.""MediaCollections"" WHERE UserName = :UserName AND MediaType = :MediaType", connection); command.Parameters.Add(new NpgsqlParameter("UserName", NpgsqlDbType.Varchar)); command.Parameters[0].Value = UserName; command.Parameters.Add(new NpgsqlParameter("MediaType", NpgsqlDbType.Integer)); command.Parameters[1].Value = (int)MediaType; NpgsqlCommand command2 = new NpgsqlCommand(@"SELECT * FROM dbo.""MediaElements"" WHERE CollectionId = :CollectionId", connection); connection.Open(); NpgsqlDataReader reader = command.ExecuteReader(); List <MediaCollection> mediacollections = new List <MediaCollection>(); while (reader.Read()) { MediaCollection mediacollection = new MediaCollection(); mediacollection.Id = (int)reader[0]; mediacollection.UserName = (string)reader[1]; mediacollection.ShortTitle = (string)reader[2]; mediacollection.Title = (string)reader[3]; mediacollection.Description = (string)reader[4]; mediacollection.Location = (string)reader[5]; mediacollection.MediaType = MediaType; mediacollections.Add(mediacollection); } reader.Dispose(); List <MediaElement> mediaelements = new List <MediaElement>(); foreach (MediaCollection mediacollection in mediacollections) { command2.Parameters.Add(new NpgsqlParameter("CollectionId", NpgsqlDbType.Integer)); command2.Parameters[0].Value = mediacollection.Id; NpgsqlDataReader reader2 = command2.ExecuteReader(); while (reader2.Read()) { MediaElement mediaelement = new MediaElement(); mediaelement.Id = (int)reader2[0]; mediaelement.CollectionId = (int)reader2[1]; mediaelement.File = (string)reader2[2]; mediaelements.Add(mediaelement); } reader2.Dispose(); mediacollection.MediaElements = mediaelements; } connection.Close(); return(mediacollections); }
//SHOW ITEM public ActionResult ShowItem(int CollectionId) { MediaCollection MediaCollection = new MediaCollection(); MediaCollection = repository.GetMediaCollectionDescription(CollectionId); ViewBag.collectionTitle = MediaCollection.ShortTitle.ToString(); ViewBag.collectionFolder = MediaCollection.Location.ToString(); return View(MediaCollection.MediaElements.ToList()); }
public void EraseMediaCollection(int CollectionId) { List <MediaElement> Medias = medias.FindAll(x => x.CollectionId == CollectionId).ToList(); foreach (var Media in Medias) { medias.Remove(Media); } MediaCollection MediaCollection = mediacollections.Find(x => x.Id == CollectionId); mediacollections.Remove(MediaCollection); }
public MediaCollection GetMediaCollectionDescription(int CollectionId) { XmlDocument XMLStore = new XmlDocument(); XMLStore.Load(XMLDescriptionFile); XmlNodeList root = XMLStore.DocumentElement.ChildNodes; XmlNode collectionNode = root[CollectionId]; MediaCollection mediaCollection = new MediaCollection(); mediaCollection.Id = CollectionId; mediaCollection.UserName = collectionNode.Attributes["UserName"].Value.ToString(); switch (collectionNode.Attributes["MediaType"].Value.ToString()) { case "Photo": mediaCollection.MediaType = MediaType.Photo; break; case "Graphics": mediaCollection.MediaType = MediaType.Graphic; break; case "Video": mediaCollection.MediaType = MediaType.Video; break; } mediaCollection.ShortTitle = collectionNode.Attributes["ShortTitle"].Value.ToString(); mediaCollection.Title = collectionNode.Attributes["Title"].Value.ToString(); mediaCollection.Location = collectionNode.Attributes["Location"].Value.ToString(); int Id = 1; List <MediaElement> mediaElements = new List <MediaElement>(); foreach (XmlNode elementNode in collectionNode) { MediaElement mediaElement = new MediaElement(); mediaElement.CollectionId = CollectionId; mediaElement.Id = Id++; mediaElement.File = elementNode.Attributes["fileName"].Value.ToString(); mediaElements.Add(mediaElement); } mediaCollection.MediaElements = mediaElements; return(mediaCollection); }
public void EraseMediaCollection(int CollectionId) { List <MediaElement> Medias = db.MediaElements.Where(x => x.CollectionId == CollectionId).ToList(); foreach (var Media in Medias) { string mediafile = AppDomain.CurrentDomain.BaseDirectory + "/Content/MembersFiles/" + Media.File; if (File.Exists(mediafile)) { File.Delete(mediafile); } db.MediaElements.Remove(Media); } MediaCollection MediaCollection = db.MediaCollections.First(x => x.Id == CollectionId); db.MediaCollections.Remove(MediaCollection); db.SaveChanges(); }
public List <MediaCollection> GetAllMediaCollectionsDescriptions() { NpgsqlConnection connection = new NpgsqlConnection(connectionString); NpgsqlCommand command = new NpgsqlCommand(@"SELECT * FROM dbo.""MediaCollections""", connection); connection.Open(); NpgsqlDataReader reader = command.ExecuteReader(); List <MediaCollection> mediacollections = new List <MediaCollection>(); while (reader.Read()) { MediaCollection mediacollection = new MediaCollection(); mediacollection.Id = (int)reader[0]; mediacollection.UserName = (string)reader[1]; mediacollection.ShortTitle = (string)reader[2]; mediacollection.Title = (string)reader[3]; mediacollection.Description = (string)reader[4]; mediacollection.Location = (string)reader[5]; Int16 mediatype = (Int16)reader[6]; switch (mediatype) { case 0: mediacollection.MediaType = MediaType.Photo; break; case 1: mediacollection.MediaType = MediaType.Graphic; break; case 2: mediacollection.MediaType = MediaType.Video; break; } mediacollections.Add(mediacollection); } reader.Dispose(); connection.Close(); return(mediacollections); }
public List <MediaCollection> GetAllMediaCollectionsDescriptions() { int Id = 0; XmlDocument XMLStore = new XmlDocument(); XMLStore.Load(XMLDescriptionFile); List <MediaCollection> mediaCollections = new List <MediaCollection>(); foreach (XmlNode item in XMLStore.DocumentElement.ChildNodes) { MediaCollection mediaCollection = new MediaCollection(); mediaCollection.Id = Id; mediaCollection.UserName = item.Attributes["UserName"].Value.ToString(); switch (item.Attributes["mediaType"].Value.ToString()) { case "Photo": mediaCollection.MediaType = MediaType.Photo; break; case "Graphics": mediaCollection.MediaType = MediaType.Graphic; break; case "Video": mediaCollection.MediaType = MediaType.Video; break; } mediaCollection.ShortTitle = item.Attributes["ShortTitle"].Value.ToString(); mediaCollection.Title = item.Attributes["Title"].Value.ToString(); mediaCollection.Location = item.Attributes["Location"].Value.ToString(); mediaCollections.Add(mediaCollection); ++Id; } return(mediaCollections); }
public void AddMediaCollectionDescription(MediaCollection MediaCollection) { NpgsqlConnection connection = new NpgsqlConnection(connectionString); NpgsqlCommand command = new NpgsqlCommand(@"INSERT INTO dbo.""MediaCollections"" (UserName, ShortTitle, Title, Description, Location, MediaType) VALUES (:UserName, :ShortTitle, :Title, :Description, :Location, :MediaType)", connection); command.Parameters.Add(new NpgsqlParameter("UserName", NpgsqlDbType.Varchar)); command.Parameters[0].Value = MediaCollection.UserName; command.Parameters.Add(new NpgsqlParameter("ShortTitle", NpgsqlDbType.Varchar)); command.Parameters[1].Value = MediaCollection.ShortTitle; command.Parameters.Add(new NpgsqlParameter("Title", NpgsqlDbType.Varchar)); command.Parameters[2].Value = MediaCollection.Title; command.Parameters.Add(new NpgsqlParameter("Description", NpgsqlDbType.Varchar)); command.Parameters[3].Value = MediaCollection.Description; command.Parameters.Add(new NpgsqlParameter("Location", NpgsqlDbType.Varchar)); command.Parameters[4].Value = MediaCollection.Location; command.Parameters.Add(new NpgsqlParameter("MediaType", NpgsqlDbType.Smallint)); command.Parameters[5].Value = (Int16)MediaCollection.MediaType; connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
public List<MediaCollection> GetMediaCollectionsDescriptions(string UserName, MediaType MediaType) { int Id=0; XmlDocument XMLStore = new XmlDocument(); XMLStore.Load(XMLDescriptionFile); XmlElement root = XMLStore.DocumentElement; List<MediaCollection> mediaCollections = new List<MediaCollection>(); foreach (XmlNode item in root.ChildNodes) { if (item.Attributes["UserName"].Value.ToString() == UserName && item.Attributes["MediaType"].Value.ToString() == ((int)MediaType).ToString()) { MediaCollection mediaCollection = new MediaCollection(); mediaCollection.Id = Id; mediaCollection.UserName = item.Attributes["UserName"].Value.ToString(); mediaCollection.MediaType = MediaType; mediaCollection.ShortTitle = item.Attributes["ShortTitle"].Value.ToString(); mediaCollection.Title = item.Attributes["Title"].Value.ToString(); mediaCollection.Location = item.Attributes["Location"].Value.ToString(); mediaCollection.Description = item.Attributes["Description"].Value.ToString(); mediaCollections.Add(mediaCollection); } ++Id; } return mediaCollections; }
public void AddMediaCollectionDescription(MediaCollection MediaCollection) { db.MediaCollections.Add(MediaCollection); db.SaveChanges(); }
public List<MediaCollection> GetMediaCollectionsDescriptions(string UserName, MediaType MediaType) { NpgsqlConnection connection = new NpgsqlConnection(connectionString); NpgsqlCommand command = new NpgsqlCommand(@"SELECT * FROM dbo.""MediaCollections"" WHERE UserName = :UserName AND MediaType = :MediaType", connection); command.Parameters.Add(new NpgsqlParameter ("UserName", NpgsqlDbType.Varchar)); command.Parameters[0].Value = UserName; command.Parameters.Add(new NpgsqlParameter("MediaType", NpgsqlDbType.Integer)); command.Parameters[1].Value = (int)MediaType; NpgsqlCommand command2 = new NpgsqlCommand(@"SELECT * FROM dbo.""MediaElements"" WHERE CollectionId = :CollectionId", connection); connection.Open(); NpgsqlDataReader reader = command.ExecuteReader(); List<MediaCollection> mediacollections = new List<MediaCollection>(); while (reader.Read()) { MediaCollection mediacollection = new MediaCollection(); mediacollection.Id = (int)reader[0]; mediacollection.UserName = (string)reader[1]; mediacollection.ShortTitle =(string)reader[2]; mediacollection.Title = (string)reader[3]; mediacollection.Description = (string)reader[4]; mediacollection.Location = (string)reader[5]; mediacollection.MediaType = MediaType; mediacollections.Add(mediacollection); } reader.Dispose(); List<MediaElement> mediaelements = new List<MediaElement>(); foreach (MediaCollection mediacollection in mediacollections) { command2.Parameters.Add(new NpgsqlParameter("CollectionId", NpgsqlDbType.Integer)); command2.Parameters[0].Value = mediacollection.Id; NpgsqlDataReader reader2 = command2.ExecuteReader(); while (reader2.Read()) { MediaElement mediaelement = new MediaElement(); mediaelement.Id = (int)reader2[0]; mediaelement.CollectionId = (int)reader2[1]; mediaelement.File = (string)reader2[2]; mediaelements.Add(mediaelement); } reader2.Dispose(); mediacollection.MediaElements = mediaelements; } connection.Close(); return mediacollections; }
public void AddMediaCollectionDescription(MediaCollection MediaCollection) { mediacollections.Add(MediaCollection); }
public MediaCollection GetMediaCollectionDescription(int CollectionId) { NpgsqlConnection connection = new NpgsqlConnection(connectionString); NpgsqlCommand command = new NpgsqlCommand(@"SELECT * FROM dbo.""MediaCollections"" WHERE Id = :CollectionId", connection); command.Parameters.Add(new NpgsqlParameter("CollectionId", NpgsqlDbType.Integer)); command.Parameters[0].Value = CollectionId; NpgsqlCommand command2 = new NpgsqlCommand(@"SELECT * FROM dbo.""MediaElements"" WHERE CollectionId = :CollectionId", connection); connection.Open(); NpgsqlDataReader reader = command.ExecuteReader(); MediaCollection mediacollection = new MediaCollection(); reader.Read(); mediacollection.Id = (int)reader[0]; mediacollection.UserName = (string)reader[1]; mediacollection.ShortTitle = (string)reader[2]; mediacollection.Title = (string)reader[3]; mediacollection.Description = (string)reader[4]; mediacollection.Location = (string)reader[5]; Int16 mediatype = (Int16)reader[6]; switch (mediatype) { case 0: mediacollection.MediaType = MediaType.Photo; break; case 1: mediacollection.MediaType = MediaType.Graphic; break; case 2: mediacollection.MediaType = MediaType.Video; break; } reader.Dispose(); List <MediaElement> mediaelements = new List <MediaElement>(); command2.Parameters.Add(new NpgsqlParameter("CollectionId", NpgsqlDbType.Integer)); command2.Parameters[0].Value = mediacollection.Id; NpgsqlDataReader reader2 = command2.ExecuteReader(); while (reader2.Read()) { MediaElement mediaelement = new MediaElement(); mediaelement.Id = (int)reader2[0]; mediaelement.CollectionId = (int)reader2[1]; mediaelement.File = (string)reader2[2]; mediaelements.Add(mediaelement); } reader2.Dispose(); mediacollection.MediaElements = mediaelements; connection.Close(); return(mediacollection); }
public List<MediaCollection> GetAllMediaCollectionsDescriptions() { NpgsqlConnection connection = new NpgsqlConnection(connectionString); NpgsqlCommand command = new NpgsqlCommand(@"SELECT * FROM dbo.""MediaCollections""", connection); connection.Open(); NpgsqlDataReader reader = command.ExecuteReader(); List<MediaCollection> mediacollections = new List<MediaCollection>(); while (reader.Read()) { MediaCollection mediacollection = new MediaCollection(); mediacollection.Id = (int)reader[0]; mediacollection.UserName = (string)reader[1]; mediacollection.ShortTitle = (string)reader[2]; mediacollection.Title = (string)reader[3]; mediacollection.Description = (string)reader[4]; mediacollection.Location = (string)reader[5]; Int16 mediatype = (Int16)reader[6]; switch (mediatype) { case 0: mediacollection.MediaType = MediaType.Photo; break; case 1: mediacollection.MediaType = MediaType.Graphic; break; case 2: mediacollection.MediaType = MediaType.Video; break; } mediacollections.Add(mediacollection); } reader.Dispose(); connection.Close(); return mediacollections; }
//[AcceptVerbs(HttpVerbs.Get)] //public ActionResult CreateUser() //{ // return PartialView("UsersCRUD_partial_createUser"); //} //[AcceptVerbs(HttpVerbs.Post)] //public ActionResult CreateUser(RegisterModel user) //{ // if (ModelState.IsValid) // { // MembershipCreateStatus status; // Membership.CreateUser(username: user.UserName, password: user.Password, email: user.Email, passwordQuestion: null, passwordAnswer: null, isApproved: true, status: out status); // if (status == MembershipCreateStatus.Success) // { // return PartialView("UsersCRUD_partial_table", Membership.GetAllUsers()); // } // else // { // switch (status) // { // case MembershipCreateStatus.DuplicateUserName: // ModelState.AddModelError("UserName", "Пользователь с таким именем уже существует"); // break; // default: // ModelState.AddModelError("", "Неизвестная ошибка"); // break; // } // return PartialView("UsersCRUD_partial_createUser", user); // } // } // else // { // return PartialView("UsersCRUD_partial_createUser", user); // } //} //[AcceptVerbs(HttpVerbs.Get)] //public ActionResult DeleteUser(string username) //{ // Membership.DeleteUser(username, false); // return PartialView("UsersCRUD_partial_table", Membership.GetAllUsers()); //} //[AcceptVerbs(HttpVerbs.Get)] //public ActionResult UpdateUser(string username) //{ // UpdateModel updateuser = new UpdateModel(); // MembershipUser membershipuser = Membership.GetUser(username, false); // updateuser.UserId = (Guid)membershipuser.ProviderUserKey; // updateuser.UserName = membershipuser.UserName; // updateuser.Email = membershipuser.Email; // return PartialView("UsersCRUD_partial_updateUser", updateuser); //} //[AcceptVerbs(HttpVerbs.Post)] //public ActionResult UpdateUser(UpdateModel updateUser) //{ // return PartialView("UsersCRUD_partial_table", Membership.GetAllUsers()); //} //public ActionResult MakeAdminAccount() //{ // List<User> users = new List<User>(); // using (DBMembershipContext db = new DBMembershipContext()) // { // //User newAdminUser = new User(); // //newAdminUser = users.First(x => x.UserName == "admin"); // //newAdminUser.Password = Encoding.UTF8.GetBytes("admin"); // List <User> adminUsers = db.Users.Where(x=>x.UserName=="admin").ToList(); // db.Users.RemoveRange(adminUsers); // db.SaveChanges(); // List<User> otherUsers = db.Users.Where(x => x.UserName == "other1" || x.UserName == "other2").ToList(); // db.Users.RemoveRange(otherUsers); // db.SaveChanges(); // User admin = new User(); // admin = new User { UserId = Guid.NewGuid(), UserName = "******", Email = "someemail", Password = Encoding.UTF8.GetBytes("admin"), PasswordSalt = 1234, CreatedDate = DateTime.Now, IsActivated = true, IsLockedOut = false, LastLockedOutDate = DateTime.Now, LastLoginDate = DateTime.Now }; // db.Users.Add(admin); // db.SaveChanges(); // Guid adminGuid = db.Users.FirstOrDefault(x => x.UserName == "admin").UserId; // UserRole adminRole1 = new UserRole(); // adminRole1.UserId = adminGuid; // adminRole1.RoleId = db.Roles.FirstOrDefault(x => x.RoleName == "Administrator").RoleId; // db.UserRoles.Add(adminRole1); // db.SaveChanges(); // UserRole adminRole2 = new UserRole(); // adminRole2.UserId = adminGuid; // adminRole2.RoleId = db.Roles.FirstOrDefault(x => x.RoleName == "Member").RoleId; // db.UserRoles.Add(adminRole2); // db.SaveChanges(); // User other1 = new User(); // other1 = new User { UserId = Guid.NewGuid(), UserName = "******", Email = "someemail", Password = Encoding.UTF8.GetBytes("other1"), PasswordSalt = 1234, CreatedDate = DateTime.Now, IsActivated = true, IsLockedOut = false, LastLockedOutDate = DateTime.Now, LastLoginDate = DateTime.Now }; // db.Users.Add(other1); // db.SaveChanges(); // Guid other1Guid = db.Users.FirstOrDefault(x => x.UserName == "other1").UserId; // UserRole other1Role = new UserRole(); // other1Role.UserId = other1Guid; // other1Role.RoleId = db.Roles.FirstOrDefault(x => x.RoleName == "Member").RoleId; // db.UserRoles.Add(other1Role); // db.SaveChanges(); // User other2 = new User(); // other2 = new User { UserId = Guid.NewGuid(), UserName = "******", Email = "someemail", Password = Encoding.UTF8.GetBytes("other2"), PasswordSalt = 1234, CreatedDate = DateTime.Now, IsActivated = true, IsLockedOut = false, LastLockedOutDate = DateTime.Now, LastLoginDate = DateTime.Now }; // db.Users.Add(other2); // db.SaveChanges(); // Guid other2Guid = db.Users.FirstOrDefault(x => x.UserName == "other2").UserId; // UserRole other2Role = new UserRole(); // other2Role.UserId = other2Guid; // other2Role.RoleId = db.Roles.FirstOrDefault(x => x.RoleName == "Member").RoleId; // db.UserRoles.Add(other2Role); // db.SaveChanges(); // //db.Users.Add(newAdminUser); // //db.SaveChanges(); // } // return RedirectToAction("UsersCRUD"); //} public ActionResult DataFromXMLFiles() { XmlDocument PhotoXmlFile = new XmlDocument(); PhotoXmlFile.Load(AppDomain.CurrentDomain.BaseDirectory + "/Content/PhotoGalleryDescription.xml"); foreach (XmlNode collection in PhotoXmlFile.DocumentElement.ChildNodes) { MediaCollection MediaCollection = new MediaCollection(); MediaCollection.UserName = "******"; MediaCollection.ShortTitle = collection.Attributes["itemTitle"].Value.ToString(); MediaCollection.Title = "No title"; MediaCollection.Description = "No description"; MediaCollection.Location = "mobile/photo/" + collection.Attributes["itemFolder"].Value.ToString(); MediaCollection.MediaType = MediaType.Photo; repository.AddMediaCollectionDescription(MediaCollection); foreach (XmlNode collectionitem in collection.ChildNodes) { MediaElement Media = new MediaElement(); Media.CollectionId = repository.GetLastCollectionId(); Media.File = collectionitem.Attributes["fileName"].Value.ToString(); repository.AddMedia(Media); } } XmlDocument GraphicsXmlFile = new XmlDocument(); GraphicsXmlFile.Load(AppDomain.CurrentDomain.BaseDirectory + "/Content/GraphicsGalleryDescription.xml"); foreach (XmlNode collection in GraphicsXmlFile.DocumentElement.ChildNodes) { MediaCollection MediaCollection = new MediaCollection(); MediaCollection.UserName = "******"; MediaCollection.ShortTitle = collection.Attributes["itemTitle"].Value.ToString(); MediaCollection.Title = "No title"; MediaCollection.Description = "No description"; MediaCollection.Location = "mobile/graphics/" + collection.Attributes["itemFolder"].Value.ToString(); MediaCollection.MediaType = MediaType.Graphic; repository.AddMediaCollectionDescription(MediaCollection); foreach (XmlNode collectionitem in collection.ChildNodes) { MediaElement Media = new MediaElement(); Media.CollectionId = repository.GetLastCollectionId(); Media.File = collectionitem.Attributes["fileName"].Value.ToString(); repository.AddMedia(Media); } } XmlDocument VideoXmlFile = new XmlDocument(); VideoXmlFile.Load(AppDomain.CurrentDomain.BaseDirectory + "/Content/VideoGalleryDescription.xml"); foreach (XmlNode collection in VideoXmlFile.DocumentElement.ChildNodes) { MediaCollection MediaCollection = new MediaCollection(); MediaCollection.UserName = "******"; MediaCollection.ShortTitle = collection.Attributes["itemTitle"].Value.ToString(); MediaCollection.Title = "No title"; MediaCollection.Description = "No description"; MediaCollection.Location = "mobile/video/" + collection.Attributes["itemFolder"].Value.ToString(); MediaCollection.MediaType = MediaType.Video; repository.AddMediaCollectionDescription(MediaCollection); foreach (XmlNode collectionitem in collection.ChildNodes) { MediaElement Media = new MediaElement(); Media.CollectionId = repository.GetLastCollectionId(); Media.File = collectionitem.Attributes["fileName"].Value.ToString(); repository.AddMedia(Media); } } return RedirectToAction("Index"); }
public List<MediaCollection> GetAllMediaCollectionsDescriptions() { int Id = 0; XmlDocument XMLStore = new XmlDocument(); XMLStore.Load(XMLDescriptionFile); List<MediaCollection> mediaCollections = new List<MediaCollection>(); foreach (XmlNode item in XMLStore.DocumentElement.ChildNodes) { MediaCollection mediaCollection = new MediaCollection(); mediaCollection.Id = Id; mediaCollection.UserName = item.Attributes["UserName"].Value.ToString(); switch (item.Attributes["mediaType"].Value.ToString()) { case "Photo": mediaCollection.MediaType = MediaType.Photo; break; case "Graphics": mediaCollection.MediaType = MediaType.Graphic; break; case "Video": mediaCollection.MediaType = MediaType.Video; break; } mediaCollection.ShortTitle = item.Attributes["ShortTitle"].Value.ToString(); mediaCollection.Title = item.Attributes["Title"].Value.ToString(); mediaCollection.Location = item.Attributes["Location"].Value.ToString(); mediaCollections.Add(mediaCollection); ++Id; } return mediaCollections; }
public MediaCollection GetMediaCollectionDescription(int CollectionId) { NpgsqlConnection connection = new NpgsqlConnection(connectionString); NpgsqlCommand command = new NpgsqlCommand(@"SELECT * FROM dbo.""MediaCollections"" WHERE Id = :CollectionId", connection); command.Parameters.Add(new NpgsqlParameter("CollectionId", NpgsqlDbType.Integer)); command.Parameters[0].Value = CollectionId; NpgsqlCommand command2 = new NpgsqlCommand(@"SELECT * FROM dbo.""MediaElements"" WHERE CollectionId = :CollectionId", connection); connection.Open(); NpgsqlDataReader reader = command.ExecuteReader(); MediaCollection mediacollection = new MediaCollection(); reader.Read(); mediacollection.Id = (int)reader[0]; mediacollection.UserName = (string)reader[1]; mediacollection.ShortTitle = (string)reader[2]; mediacollection.Title = (string)reader[3]; mediacollection.Description = (string)reader[4]; mediacollection.Location = (string)reader[5]; Int16 mediatype = (Int16)reader[6]; switch (mediatype) { case 0: mediacollection.MediaType = MediaType.Photo; break; case 1: mediacollection.MediaType = MediaType.Graphic; break; case 2: mediacollection.MediaType = MediaType.Video; break; } reader.Dispose(); List<MediaElement> mediaelements = new List<MediaElement>(); command2.Parameters.Add(new NpgsqlParameter("CollectionId", NpgsqlDbType.Integer)); command2.Parameters[0].Value = mediacollection.Id; NpgsqlDataReader reader2 = command2.ExecuteReader(); while (reader2.Read()) { MediaElement mediaelement = new MediaElement(); mediaelement.Id = (int)reader2[0]; mediaelement.CollectionId = (int)reader2[1]; mediaelement.File = (string)reader2[2]; mediaelements.Add(mediaelement); } reader2.Dispose(); mediacollection.MediaElements = mediaelements; connection.Close(); return mediacollection; }
public MediaCollection GetMediaCollectionDescription(int CollectionId) { XmlDocument XMLStore = new XmlDocument(); XMLStore.Load(XMLDescriptionFile); XmlNodeList root = XMLStore.DocumentElement.ChildNodes; XmlNode collectionNode = root[CollectionId]; MediaCollection mediaCollection = new MediaCollection(); mediaCollection.Id = CollectionId; mediaCollection.UserName = collectionNode.Attributes["UserName"].Value.ToString(); switch (collectionNode.Attributes["MediaType"].Value.ToString()) { case "Photo": mediaCollection.MediaType = MediaType.Photo; break; case "Graphics": mediaCollection.MediaType = MediaType.Graphic; break; case "Video": mediaCollection.MediaType = MediaType.Video; break; } mediaCollection.ShortTitle = collectionNode.Attributes["ShortTitle"].Value.ToString(); mediaCollection.Title = collectionNode.Attributes["Title"].Value.ToString(); mediaCollection.Location = collectionNode.Attributes["Location"].Value.ToString(); int Id = 1; List<MediaElement> mediaElements = new List<MediaElement>(); foreach (XmlNode elementNode in collectionNode) { MediaElement mediaElement = new MediaElement(); mediaElement.CollectionId = CollectionId; mediaElement.Id = Id++; mediaElement.File = elementNode.Attributes["fileName"].Value.ToString(); mediaElements.Add(mediaElement); } mediaCollection.MediaElements = mediaElements; return mediaCollection; }