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);
}
}
