//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); } }
public Media_Topics GetDetailById(int idx) { using (MediaEntities dbContext = new MediaEntities()) { dbContext.CommandTimeout = Settings.CommandTimeout; Media_Topics topic_obj = dbContext.Media_Topics.Where(x => x.TopicId == idx).FirstOrDefault(); return(topic_obj); } }
public int UpdateStatus(string UserId, int TopicId, string Status) { 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.Status = Status; topic_obj.LastModifiedByUserId = new Guid(UserId); topic_obj.LastModifiedDate = System.DateTime.Now; int i = dbContext.SaveChanges(); return(i); } }
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); } }
private void LoadData() { MediaTopics media_topic_obj = new MediaTopics(); Media_Topics topic_obj = media_topic_obj.GetDetailById(_idx); txtTopicName.Text = topic_obj.Name; txtDescription.Text = topic_obj.Description; string Status = topic_obj.Status; string ParentId = topic_obj.ParentId.ToString(); PopulateMediaTypeList2DDL(topic_obj.TypeId.ToString()); PopulateMediaTopicList2DDL(ParentId); PopulateStatus2DDL(Status); string Photo = topic_obj.Photo; imgPhoto.ImageUrl = upload_front_image_dir + "/" + Photo; imgPhoto.Height = 70; imgPhoto.Width = 50; ViewState["Photo"] = Photo; }
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); } }