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