public int AddDocument(String Name, String Description, String Thumbnails, String Link, int FileSize, int UserID, int CategoryID, Nullable <int> CollectionID) { ConvertLetter cvLetter = new ConvertLetter(); String Alias = cvLetter.ClearAccent(Name).ToTitleCase().Replace(" ", ""); DocumentModel documentToInsert = new DocumentModel(); documentToInsert.UserID = UserID; if (CollectionID == 0) { documentToInsert.CollectionID = null; } else { documentToInsert.CollectionID = CollectionID; } documentToInsert.CategoryID = CategoryID; documentToInsert.Name = Name; documentToInsert.Alias = Alias; documentToInsert.Description = Description; documentToInsert.Thumbnails = Thumbnails; documentToInsert.TotalView = 0; documentToInsert.TotalDownload = 0; documentToInsert.UploadDate = DateTime.Now; documentToInsert.Link = Link; documentToInsert.FileSize = FileSize; documentToInsert.IsError = false; documentToInsert.ErrorReportCount = 0; LinqAdapter.GetTable <DocumentModel>().InsertOnSubmit(documentToInsert); LinqAdapter.SubmitChanges(); return(documentToInsert.DocumentID); }
public void AddTag(String TagName, Nullable <int> DocumentID, Nullable <int> CollectionID) { ConvertLetter cv = new ConvertLetter(); String Alias = cv.ClearAccent(TagName); TagsModel tagToInsert = new TagsModel(); if (DocumentID == 0) { tagToInsert.DocumentID = null; } else { tagToInsert.DocumentID = DocumentID; } if (CollectionID == 0) { tagToInsert.CollectionID = null; } else { tagToInsert.CollectionID = CollectionID; } tagToInsert.TagName = TagName; tagToInsert.Alias = Alias; LinqAdapter.GetTable <TagsModel>().InsertOnSubmit(tagToInsert); LinqAdapter.SubmitChanges(); }
public bool UpdateCategory(String Name, int CategoryID) { ConvertLetter cvLetter = new ConvertLetter(); String alias = cvLetter.ClearAccent(Name).ToTitleCase().Replace(" ", ""); int rowAffected = DAL.CallUpdateProcedure("UpdateCategory", "@name=" + Name, "@alias=" + alias, "@categoryid=" + CategoryID); return(rowAffected == 1); }
public bool UpdateCollection(String Name, String Description, bool IsError, int CollectionID) { ConvertLetter cvLetter = new ConvertLetter(); String alias = cvLetter.ClearAccent(Name).ToTitleCase().Replace(" ", ""); int rowAffected = DAL.CallUpdateProcedure("UpdateCollection", "@name=" + Name, "@alias=" + alias, "@description=" + Description, "@iserror=" + IsError, "@collectionid=" + CollectionID); return(rowAffected == 1); }
public int AddCollection(String Name, String Description, int UserID) { ConvertLetter cvLetter = new ConvertLetter(); String alias = cvLetter.ClearAccent(Name).ToTitleCase().Replace(" ", ""); int rowAffected = DAL.CallUpdateProcedure("AddCollection", "@name=" + Name, "@alias=" + alias, "@description=" + Description, "@userid=" + UserID); int tmpCollectionID = SearchCollectionByName(Name, true)[0].CollectionID; return(tmpCollectionID); }
public void UpdateCategory(String Name, int CategoryID) { ConvertLetter cvLetter = new ConvertLetter(); String Alias = cvLetter.ClearAccent(Name).ToTitleCase().Replace(" ", ""); CategoryModel categoryToUpdate = GetCategoryById(CategoryID); categoryToUpdate.Name = Name; categoryToUpdate.Alias = Alias; LinqAdapter.SubmitChanges(); }
public void AddCategory(String Name) { ConvertLetter cvLetter = new ConvertLetter(); String Alias = cvLetter.ClearAccent(Name).ToTitleCase().Replace(" ", ""); CategoryModel categoryToInsert = new CategoryModel(); categoryToInsert.Name = Name; categoryToInsert.Alias = Alias; LinqAdapter.GetTable <CategoryModel>().InsertOnSubmit(categoryToInsert); LinqAdapter.SubmitChanges(); }
public void UpdateCollection(String Name, String Description, bool IsError, int CollectionID) { ConvertLetter cvLetter = new ConvertLetter(); String Alias = cvLetter.ClearAccent(Name).ToTitleCase().Replace(" ", "_"); CollectionModel collection = GetCollectionById(CollectionID); collection.Name = Name; collection.Alias = Alias; collection.Description = Description; collection.IsError = IsError; LinqAdapter.SubmitChanges(); }
public int AddCollection(String Name, String Description, int UserID) { ConvertLetter cvLetter = new ConvertLetter(); String Alias = cvLetter.ClearAccent(Name).ToTitleCase().Replace(" ", "_"); CollectionModel collectionToInsert = new CollectionModel(); collectionToInsert.UserID = UserID; collectionToInsert.Name = Name; collectionToInsert.Alias = Alias; collectionToInsert.Description = Description; collectionToInsert.TotalView = 0; collectionToInsert.CreatedDate = DateTime.Now; collectionToInsert.IsError = false; LinqAdapter.GetTable <CollectionModel>().InsertOnSubmit(collectionToInsert); LinqAdapter.SubmitChanges(); return(collectionToInsert.CollectionID); }
protected void btnUpload_Click(object sender, EventArgs e) { try { if (Page.IsValid) { if (fileUpload.HasFile && IsPDFFile(fileUpload.FileName)) { prefencesLogic = new PreferencesModel(); cvLetter = new ConvertLetter(); FileName = cvLetter.ClearAccent(fileUpload.FileName).ToLower().Replace(' ', '_'); FilePath = prefencesLogic.GetPreferencesByName("FileServer").Value; FileSize = fileUpload.PostedFile.ContentLength; MaxFileSize = 50 * 1024 * 1024; //Upload Thumbnails if (thumbUpload.HasFile) { String FileExtension = System.IO.Path.GetExtension(thumbUpload.FileName).ToLower(); ThumbnailFileName = System.IO.Path.GetRandomFileName(); ThumbnailPath = prefencesLogic.GetPreferencesByName("ThumbnailPath").Value; thumbUpload.SaveAs(MapPath(new Uri(ThumbnailPath).AbsolutePath + "/" + ThumbnailFileName + FileExtension)); } //Upload Document if (FileSize < MaxFileSize) { fileUpload.SaveAs(MapPath(new Uri(FilePath + @"/" + FileName).AbsolutePath)); docLogic = new DocumentModel(); collectionLogic = new CollectionModel(); tagsLogic = new TagsModel(); int addedCollectionID = 0; int addedDocumentID = 0; //Add Document if (String.IsNullOrEmpty(txtCollectionName.Text)) { addedDocumentID = docLogic.AddDocument( txtDocumentName.Text, txtDescription.Text, ThumbnailFileName, FileName, FileSize, UserID, Int32.Parse(ddlCategory.SelectedValue), ddlCollection.Items.Count != 0 ? Int32.Parse(ddlCollection.SelectedValue) : 0 ); } else { addedCollectionID = collectionLogic.AddCollection(txtCollectionName.Text, String.Empty, UserID); addedDocumentID = docLogic.AddDocument(txtDocumentName.Text, txtDescription.Text, ThumbnailFileName, FileName, FileSize, UserID, Int32.Parse(ddlCategory.SelectedValue), addedCollectionID); } //Add Tags if (!String.IsNullOrEmpty(txtTags.Text)) { tagsLogic.AddTag(txtTags.Text, addedDocumentID, null); } else { String tmpTags = txtDocumentName.Text.Replace(" ", ","); tagsLogic.AddTag(tmpTags, addedDocumentID, null); } blInfo.Items.Add("Thêm tài liệu thành công"); } else { blInfo.Items.Add("Dung lượng file cho phép không quá 50MB"); } } else { blInfo.Items.Add("Sai định dạng file. Chỉ cho phép định dạng PDF"); } } } catch (ApplicationException ex) { blInfo.Items.Clear(); blInfo.Items.Add(ex.Message); } }