public override void DeleteComments(Gallery gallery)
{
if (gallery == null)
throw new ArgumentNullException("gallery");
GalleryDataContext db = new GalleryDataContext(ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString);
Table<Comment> comments = db.GetTable<Comment>();
Gallery g = SelectGallery(gallery.ID, true);
if (g == null)
return;
comments.AttachAll<Comment>(g.Comments);
comments.DeleteAllOnSubmit<Comment>(g.Comments);
try
{
db.SubmitChanges(ConflictMode.ContinueOnConflict);
}
catch (ChangeConflictException ex)
{
Trace.TraceError(ex.Message);
// All database values overwrite current values.
foreach (ObjectChangeConflict occ in db.ChangeConflicts)
occ.Resolve(RefreshMode.OverwriteCurrentValues);
}
catch (DbException ex)
{
Trace.TraceError(ex.Message);
}
}
public List<CustomCollectionFiles> GetCollectionListForMaster(int TopicId, char status)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.CommandTimeout = Settings.CommandTimeout;
var query = from gtf in context.Gallery_Topics
join cl in context.Gallery_Collections
on gtf.Gallery_TopicId equals cl.TopicId
where gtf.Status == status && gtf.Gallery_TopicId == TopicId
select new { gtf, cl };
List<CustomCollectionFiles> list = new List<CustomCollectionFiles>();
foreach (var c in query)
{
CustomCollectionFiles file_obj = new CustomCollectionFiles();
file_obj.TopicId = c.gtf.Gallery_TopicId;
file_obj.CollectionId = c.cl.CollectionId;
file_obj.Title = c.cl.Title;
file_obj.IconFile = c.cl.IconFile;
file_obj.Description = c.cl.Description;
file_obj.ListOrder = Convert.ToInt32(c.cl.ListOrder);
file_obj.Tags = c.cl.Tags;
file_obj.Url = c.cl.Url;
file_obj.CreatedOnDate = Convert.ToDateTime(c.cl.CreatedOnDate);
file_obj.LastModifieddDate = Convert.ToDateTime(c.cl.LastModifieddDate);
file_obj.UserLog = c.cl.UserLog.ToString();
file_obj.UserLastUpdate = c.cl.UserLastUpdate.ToString();
file_obj.IPLog = c.cl.IPLog;
file_obj.IPLastUpdate = c.cl.IPLastUpdate;
file_obj.Status = c.cl.Status;
list.Add(file_obj);
}
return list;
}
}
public static Gallery_Topic GetDetails(int Idx)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.CommandTimeout = Settings.CommandTimeout;
context.DeferredLoadingEnabled = false;
return (from g in context.Gallery_Topics
where g.Gallery_TopicId == Idx
select g).FirstOrDefault();
}
}
//================================================================================
public List<Gallery_Collection> GetList(int topicid, char status)
{
using(GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString)){
context.CommandTimeout = Settings.CommandTimeout;
var query = from g in context.Gallery_Collections
where g.Status == status && g.TopicId == topicid
select g;
List<Gallery_Collection> lst = query.ToList();
return lst;
}
}
public void Delete(int Idx)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.CommandTimeout = Settings.CommandTimeout;
context.DeferredLoadingEnabled = false;
Gallery_Topic topic_obj = context.Gallery_Topics.Single(p => p.Gallery_TopicId == Idx);
context.Gallery_Topics.DeleteOnSubmit(topic_obj);
context.SubmitChanges();
}
}
public static int? UpdateData(Gallery_Topic entity)
{
int? o_return = 0;
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
string UserLog = Convert.ToString(entity.UserLog);
var q = context.Gallery_Topics_Update(UserLog, IP, entity.Gallery_TopicId, entity.Gallery_TopicName,
entity.Alias, entity.ParentId, entity.Description, entity.Status, ref o_return);
context.SubmitChanges();
return o_return;
}
}
public static List<Gallery_Topic> GetList(char status)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.CommandTimeout = Settings.CommandTimeout;
var query = from g in context.Gallery_Topics
where g.Status == status
select g;
List<Gallery_Topic> lst = query.ToList();
return lst;
}
}
public static List<Gallery_File> GetActiveList(int CollectionId)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
//context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, context.Gallery_Files);
context.CommandTimeout = Settings.CommandTimeout;
var list = (from f in context.Gallery_Files
join gcf in context.Gallery_Collection_Files
on f.FileId equals gcf.FileId
where f.Status == '1' && gcf.CollectionId == CollectionId
select f).ToList();
return list;
}
}
//================================================================================
public static List<Gallery_Collection> GetActiveListByFixedNum(int iTotalItemCount, int topicId)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.CommandTimeout = Settings.CommandTimeout;
var query = from x in context.Gallery_Collections where x.TopicId == topicId && x.Status.Equals("1") orderby x.CollectionId descending select x;
int TotalItemCount = 0;
if (query.Count() > 0)
{
if (iTotalItemCount <= query.Count())
TotalItemCount = iTotalItemCount;
else
TotalItemCount = query.Count();
}
return query.Take(TotalItemCount).ToList();
}
}
public void UpdateStatus(string userid, int topicid, char status)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
var query = from x in context.Gallery_Topics
where x.Gallery_TopicId == topicid
select x;
foreach (Gallery_Topic topic in query)
{
topic.Status = status;
topic.IPLastUpdate = IP;
topic.UserLastUpdate = Guid.Parse(userid);
topic.LastUpdatedDate = System.DateTime.Now;
}
context.SubmitChanges();
}
}
public static List<CustomGalleryFiles> GetList(int CollectionId, char status)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.CommandTimeout = Settings.CommandTimeout;
var query = from f in context.Gallery_Files
join gcf in context.Gallery_Collection_Files
on f.FileId equals gcf.FileId
join cl in context.Gallery_Collections
on gcf.CollectionId equals cl.CollectionId
where f.Status == status && gcf.CollectionId == CollectionId
select new { f, gcf, cl };
List<CustomGalleryFiles> list = new List<CustomGalleryFiles>();
foreach (var c in query)
{
CustomGalleryFiles file_obj = new CustomGalleryFiles();
file_obj.Gallery_TopicId = c.cl.TopicId;
file_obj.FileId = c.f.FileId;
file_obj.FileName = c.f.FileName;
file_obj.FileUrl = c.f.FileUrl;
file_obj.Description = c.f.Description;
file_obj.ListOrder = Convert.ToInt32(c.f.ListOrder);
file_obj.Tags = c.f.Tags;
file_obj.CreatedOnDate = Convert.ToDateTime(c.f.CreatedOnDate);
file_obj.LastModifieddDate = Convert.ToDateTime(c.f.LastModifieddDate);
file_obj.UserLog = c.f.UserLog.ToString();
file_obj.UserLastUpdate = c.f.UserLastUpdate.ToString();
file_obj.IPLog = c.f.IPLog;
file_obj.IPLastUpdate = c.f.IPLastUpdate;
file_obj.Status = c.f.Status;
file_obj.CollectionId = Convert.ToInt32(c.gcf.CollectionId);
list.Add(file_obj);
}
return list;
}
}
public void UpdateStatus(string userid, int topicid, char status)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
var query = from x in context.Gallery_Collections
where x.CollectionId == topicid
select x;
foreach (Gallery_Collection cllection in query)
{
cllection.Status = status;
cllection.IPLastUpdate = IP;
cllection.UserLastUpdate = Guid.Parse(userid);
cllection.LastModifieddDate = System.DateTime.Now;
}
context.SubmitChanges();
}
}
public override void GetComments(Gallery gallery)
{
if (gallery == null)
throw new ArgumentNullException("gallery");
GalleryDataContext db = new GalleryDataContext(
ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString);
Table<Comment> comments = db.GetTable<Comment>();
var query =
from comment in comments
where comment.ParentID == gallery.ID
orderby comment.DateCreated descending
select comment;
foreach (var row in query)
{
gallery.AddComment(new Comment(row.ID)
{
Author = row.Author,
Content = row.Content,
DateCreated = row.DateCreated,
IPAddress = row.IPAddress,
Title = row.Title
});
}
}
public override List<Guid> GetGalleryList(
Guid? id,
string author,
DateTime? initialDateCreated,
DateTime? finalDateCreated,
string description,
bool? isVisible,
string keywords,
DateTime? initialLastUpdated,
DateTime? finalLastUpdated,
string lastUpdatedBy,
string slug,
string title,
GalleryStatus? status,
int pageSize,
int pageIndex,
out int totalCount)
{
totalCount = 0;
List<Guid> list = new List<Guid>();
int? _totalCount = null;
GalleryDataContext db = new GalleryDataContext(ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString);
var query =
db.GetGalleries(this.ApplicationName, id, author, initialDateCreated, finalDateCreated, description, isVisible, keywords,
initialLastUpdated, finalLastUpdated, lastUpdatedBy, slug, title, status.HasValue ? status.ToString() : null,
pageIndex * pageSize, (pageIndex * pageSize) + pageSize, ref _totalCount);
foreach (GetGalleriesResult item in query)
list.Add(item.ID);
if (_totalCount.HasValue)
totalCount = _totalCount.Value;
return list;
}
public static CustomGalleryFiles GetDetails(int Idx)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.CommandTimeout = Settings.CommandTimeout;
context.DeferredLoadingEnabled = false;
var query = (from f in context.Gallery_Files
join gcf in context.Gallery_Collection_Files
on f.FileId equals gcf.FileId
join cl in context.Gallery_Collections
on gcf.CollectionId equals cl.CollectionId
join gt in context.Gallery_Topics
on cl.TopicId equals gt.Gallery_TopicId
where f.FileId == Idx
select new CustomGalleryFiles
{
FileId = f.FileId,
FileName = f.FileName,
FileUrl = f.FileUrl,
Description = f.Description,
ListOrder = Convert.ToInt32(f.ListOrder),
Tags = f.Tags,
CreatedOnDate = Convert.ToDateTime(f.CreatedOnDate),
LastModifieddDate = Convert.ToDateTime(f.LastModifieddDate),
UserLog = f.UserLog.ToString(),
UserLastUpdate = f.UserLastUpdate.ToString(),
IPLog = f.IPLog,
IPLastUpdate = f.IPLastUpdate,
Status = f.Status,
CollectionId = Convert.ToInt32(gcf.CollectionId),
CollectionFileId = Convert.ToInt32(gcf.CollectionFileId),
Gallery_TopicId = Convert.ToInt32(cl.TopicId)
}).SingleOrDefault();
return query;
}
}
public override void GetUsers(Gallery gallery)
{
if (gallery == null)
throw new ArgumentNullException("gallery");
GalleryDataContext db = new GalleryDataContext(ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString);
Table<GalleryUser> users = db.GetTable<GalleryUser>();
var query =
from user in users
where user.GalleryID == gallery.ID
orderby user.UserID ascending
select user;
foreach (var row in query)
{
gallery.AddUser(row.UserID);
}
}
public bool UpdateData(int Idx, int CollectionFileId, int CollectionId, string FileName, string FileUrl,
int ListOrder, string Description, string Tags, string Status, DateTime CreatedOnDate, string IPLog,string UserLog, string UserLastUpdate)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.DeferredLoadingEnabled = false;
Gallery_File file = new Gallery_File();
file.FileId = Idx;
file.FileName = FileName;
file.FileUrl = FileUrl;
file.Description = Description;
file.ListOrder = ListOrder;
file.UserLog = Guid.Parse(UserLog);
file.UserLastUpdate = Guid.Parse(UserLastUpdate);
file.CreatedOnDate = CreatedOnDate;
file.LastModifieddDate = System.DateTime.Now;
file.Status = Convert.ToChar(Status);
file.Tags = Tags;
file.IPLog = IPLog;
file.IPLastUpdate = IP;
ChangeSet changeSet = null;
int changeCount = 0;
context.Gallery_Files.Attach(file);
context.Refresh(RefreshMode.KeepCurrentValues, file);
changeSet = context.GetChangeSet();
changeCount = changeSet.Updates.Count;
context.SubmitChanges();
bool result = false;
if (changeCount > 0)
{
Gallery_Collection_File collection_file = new Gallery_Collection_File();
collection_file.CollectionFileId = CollectionFileId;
collection_file.CollectionId = CollectionId;
collection_file.FileId = Idx;
context.Gallery_Collection_Files.Attach(collection_file);
context.Refresh(RefreshMode.KeepCurrentValues, collection_file);
context.SubmitChanges();
result = true;
}
return result;
}
}
public override Gallery SelectGallery(Guid id, bool includeComments, bool includeFiles)
{
Gallery gallery = null;
GalleryDataContext db = new GalleryDataContext(
ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString);
Table<LinqGallery> galleries = db.GetTable<LinqGallery>();
LinqGallery row = galleries.SingleOrDefault<LinqGallery>(
g => g.ApplicationName == this.ApplicationName && g.ID == id);
if (row == null)
return null;
gallery = new Gallery(row.ID)
{
ApplicationName = this.ApplicationName,
Author = row.Author,
Content = row.Content,
DateCreated = row.DateCreated,
Description = row.Description,
IsVisible = row.IsVisible,
Keywords = row.Keywords,
LastUpdated = row.LastUpdated,
LastUpdatedBy = row.LastUpdatedBy,
Slug = row.Slug,
Status = row.Status,
Title = row.Title
};
if (gallery == null)
return null;
if (includeComments)
GetComments(gallery);
if (includeFiles)
{
foreach (UploadedFile file in UploadStorageService.GetFiles(gallery.ID))
{
gallery.AddFile(file);
}
}
GetUsers(gallery);
return gallery;
}
public void Delete(int Idx)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.CommandTimeout = Settings.CommandTimeout;
context.DeferredLoadingEnabled = false;
Gallery_File gallery_obj = context.Gallery_Files.Single(p => p.FileId == Idx);
context.Gallery_Files.DeleteOnSubmit(gallery_obj);
Gallery_Collection_File collection_file_obj = context.Gallery_Collection_Files.Single(p => p.FileId == Idx);
context.Gallery_Collection_Files.DeleteOnSubmit(collection_file_obj);
context.SubmitChanges();
}
}
public bool InsertData(int CollectionId, string FileName,string FileUrl,
string Description, string UserLog, string Status, string Tags)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
int? ListOrder = (int?)context.Gallery_Collections.Max(x => (int?)x.CollectionId) ?? 0;
Gallery_File file = new Gallery_File();
file.FileName = FileName;
file.FileUrl = FileUrl;
file.ListOrder = ListOrder + 1;
file.Description = Description;
file.UserLog = Guid.Parse(UserLog);
file.CreatedOnDate = System.DateTime.Now;
file.Status = Convert.ToChar(Status);
file.Tags = Tags;
file.IPLog = IP;
bool result = false;
context.DeferredLoadingEnabled = false;
context.Gallery_Files.InsertOnSubmit(file);
context.SubmitChanges();
int FileId = file.FileId;
if (FileId > 0)
{
Gallery_Collection_File collection_file = new Gallery_Collection_File();
collection_file.CollectionId = CollectionId;
collection_file.FileId = FileId;
context.Gallery_Collection_Files.InsertOnSubmit(collection_file);
context.SubmitChanges();
result = true;
}
return result;
}
}
public override void UpdateUsers(Gallery gallery)
{
if (gallery == null)
throw new ArgumentNullException("gallery");
DeleteUsers(gallery);
GalleryDataContext db = new GalleryDataContext(ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString);
Table<GalleryUser> users = db.GetTable<GalleryUser>();
users.InsertAllOnSubmit<GalleryUser>(CreateGalleryUserCollection(gallery));
try
{
db.SubmitChanges(ConflictMode.ContinueOnConflict);
}
catch (ChangeConflictException ex)
{
Trace.TraceError(ex.Message);
// All database values overwrite current values.
foreach (ObjectChangeConflict occ in db.ChangeConflicts)
occ.Resolve(RefreshMode.OverwriteCurrentValues);
}
catch (DbException ex)
{
Trace.TraceError(ex.Message);
}
}
public bool InsertData(int TopicId, string Title, string IconFile, string Description, string Tags, string Url,
string UserLog, string Status)
{
using(GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
System.Nullable<Int32> ListOrder = (int?)context.Gallery_Collections.Max(x => (int?)x.CollectionId) ?? 0;
Gallery_Collection collection = new Gallery_Collection();
collection.TopicId = TopicId;
collection.Title = Title;
collection.IconFile = IconFile;
collection.Description = Description;
collection.ListOrder = ListOrder + 1;
collection.UserLog = Guid.Parse(UserLog);
collection.UserLastUpdate = Guid.Parse(UserLog);
collection.CreatedOnDate = System.DateTime.Now;
collection.LastModifieddDate = System.DateTime.Now;
collection.Status = Convert.ToChar(Status);
collection.Tags = Tags;
collection.Url = Url;
collection.IPLog = IP;
collection.IPLastUpdate = IP;
context.Gallery_Collections.InsertOnSubmit(collection);
context.SubmitChanges();
int newCollectionId = collection.CollectionId;
if (newCollectionId > 0) { return true; }
else { return false; }
}
}
public override void UpdateGallery(Gallery gallery, bool updateComments, bool updateUsers, bool updateFiles)
{
if (gallery == null)
throw new ArgumentNullException("gallery");
// TODO: Verificar el contexto de la transacción. Si se puede expandir a otros métodos, como es el caso de esta función.
GalleryDataContext db = new GalleryDataContext(
ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString);
Table<LinqGallery> galleries = db.GetTable<LinqGallery>();
// BusinessBase inherited clases will have a downside effect with a ChangeConflictException
// as it has changed LastUpdated row version in the call stack.
Gallery g = SelectGallery(gallery.ID, false, false);
if (g != null)
gallery.LastUpdated = g.LastUpdated;
// Assume that "gallery" has been sent by client.
// Attach with "true" to the change tracker to consider the entity modified
// and it can be checked for optimistic concurrency because
// it has a column that is marked with "RowVersion" attribute
galleries.Attach(new LinqGallery(gallery), true);
try
{
db.SubmitChanges(ConflictMode.ContinueOnConflict);
}
catch (ChangeConflictException)
{
// All database values overwrite current values.
foreach (ObjectChangeConflict occ in db.ChangeConflicts)
occ.Resolve(RefreshMode.OverwriteCurrentValues);
}
catch (DbException ex)
{
Trace.TraceError(ex.Message);
}
if (updateComments)
UpdateComments(gallery);
if (updateUsers)
UpdateUsers(gallery);
if (updateFiles)
foreach (UploadedFile file in gallery.Files)
file.Save();
}
public bool UpdateData(int Idx, int TopicId, string Title, string IconFile, string Description, int ListOrder, string Tags, string Url,
string UserLog, string UserLastUpdate, DateTime CreatedOnDate, string IPLog, string Status)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
context.Connection.Open();
Gallery_Collection collection_obj = new Gallery_Collection();
collection_obj.CollectionId = Idx;
collection_obj.TopicId = TopicId;
collection_obj.Title = Title;
collection_obj.IconFile = IconFile;
collection_obj.Description = Description;
collection_obj.ListOrder = ListOrder;
collection_obj.UserLog = Guid.Parse(UserLog);
collection_obj.UserLastUpdate = Guid.Parse(UserLastUpdate);
collection_obj.CreatedOnDate = CreatedOnDate;
collection_obj.LastModifieddDate = DateTime.Now;
collection_obj.Status = Convert.ToChar(Status);
collection_obj.Tags = Tags;
collection_obj.Url = Url;
collection_obj.IPLog = IPLog;
collection_obj.IPLastUpdate = IP;
ChangeSet changeSet = null;
int changeCount = 0;
DbTransaction trans = context.Connection.BeginTransaction();
try
{
context.Transaction = trans;
context.Gallery_Collections.Attach(collection_obj);
context.Refresh(RefreshMode.KeepCurrentValues, collection_obj);
changeSet = context.GetChangeSet();
changeCount = changeSet.Updates.Count;
context.SubmitChanges();
trans.Commit();
}
catch (Exception ex)
{
if (trans != null)
{
trans.Rollback();
}
throw ex;
}
finally
{
if (context.Connection != null && context.Connection.State == System.Data.ConnectionState.Open)
{
context.Connection.Close();
}
}
if (changeCount > 0) { return true; }
else { return false; }
}
}
public void UpdateStatus(string userid, int fileid, char status)
{
using (GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString))
{
var query = from x in context.Gallery_Files
where x.FileId == fileid
select x;
foreach (Gallery_File file in query)
{
file.Status = status;
file.UserLastUpdate = Guid.Parse(userid);
file.IPLastUpdate = IP;
file.LastModifieddDate = System.DateTime.Now;
}
context.SubmitChanges();
}
}
public Gallery_Collection GetDetails(int Idx)
{
using(GalleryDataContext context = new GalleryDataContext(Settings.ConnectionString)){
context.CommandTimeout = Settings.CommandTimeout;
Gallery_Collection collection = context.Gallery_Collections.Where(p => p.CollectionId == Idx).SingleOrDefault();
return collection;
}
}
public override void InsertGallery(Gallery gallery)
{
if (gallery == null)
throw new ArgumentNullException("gallery");
GalleryDataContext db = new GalleryDataContext(
ConfigurationManager.ConnectionStrings[this.ConnectionStringName].ConnectionString);
Table<LinqGallery> galleries = db.GetTable<LinqGallery>();
gallery.ApplicationName = this.ApplicationName;
galleries.InsertOnSubmit(new LinqGallery(gallery));
try
{
db.SubmitChanges(ConflictMode.ContinueOnConflict);
}
catch (ChangeConflictException ex)
{
Trace.TraceError(ex.Message);
// All database values overwrite current values.
foreach (ObjectChangeConflict occ in db.ChangeConflicts)
occ.Resolve(RefreshMode.OverwriteCurrentValues);
}
catch (DbException ex)
{
Trace.TraceError(ex.Message);
}
UpdateComments(gallery);
UpdateUsers(gallery);
foreach (UploadedFile file in gallery.Files)
file.Save();
}
