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