public ActionResult ViewNote(int noteId) { DBEntities _db = new DBEntities(); Models.SellerNote note = _db.SellerNotes.FirstOrDefault(x => x.ID == noteId); return(View(note)); }
public ActionResult SearchNotes() { DBEntities _db = new DBEntities(); var typeList = _db.NoteTypes.ToList(); var categoryList = _db.NoteCategories.ToList(); var countryList = _db.Countries.ToList(); List <string> universityList = new List <string>(); foreach (InitialNotesMarketplace.Models.SellerNote row in _db.SellerNotes) { if (!universityList.Contains(row.UniversityName)) { universityList.Add(row.UniversityName); } } List <string> courseList = new List <string>(); foreach (InitialNotesMarketplace.Models.SellerNote row in _db.SellerNotes) { if (!courseList.Contains(row.Course)) { courseList.Add(row.Course); } } SearchNote searchNote = new SearchNote() { ListCategories = categoryList, ListCountries = countryList, ListTypes = typeList, ListUniversities = universityList, ListCourses = courseList }; Session["searchNote"] = searchNote; Models.SellerNote snote = new Models.SellerNote(); return(View(snote)); }
public ActionResult AddNote(Note model, FormCollection collection) { bool isPaid = false; if (collection["sell-for"] == "paid") { isPaid = true; } User loggedInUser = (User)Session["user"]; using (var context = new DBEntities()) { Models.Extended.SellerNote newNote = model.sellerNote; Models.SellerNote note1 = new Models.SellerNote() { SellerID = loggedInUser.ID, Title = newNote.Title, Status = 7, Category = newNote.Category, NoteType = newNote.NoteType, NumberOfPages = newNote.NumberOfPages, Description = newNote.Description, Country = newNote.Country, UniversityName = newNote.UniversityName, Course = newNote.Course, CourseCode = newNote.CourseCode, Professor = newNote.Professor, IsPaid = isPaid, SellingPrice = newNote.SellingPrice, IsActive = true, CreatedDate = DateTime.Now, CreatedBy = loggedInUser.ID, ModifiedDate = DateTime.Now, ModifiedBy = loggedInUser.ID }; context.SellerNotes.Add(note1); try { context.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { System.Diagnostics.Debug.WriteLine("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } string previewPath = Server.MapPath("~/Members/" + note1.SellerID + "/" + note1.ID); if (!Directory.Exists(previewPath)) { Directory.CreateDirectory(previewPath); } string previewFileName = "Preview_" + DateTime.Now.ToString("dd/MM/yyyy") + ".pdf"; string fullPreviewFilePath = Path.Combine(previewPath, previewFileName); string relativePreviewFilePath = Path.Combine("~/Members/" + note1.SellerID + "/" + note1.ID, previewFileName); model.sellerNote.NotesPreview.SaveAs(fullPreviewFilePath); var fNote = context.SellerNotes.FirstOrDefault(x => x.ID == note1.ID); fNote.NotesPreview = relativePreviewFilePath; string displayPicPath = Server.MapPath("~/Members/" + note1.SellerID + "/" + note1.ID); string displayPicName = "DisplayPicture" + DateTime.Now.ToString("dd/MM/yyyy") + ".jpg"; string fulldisplayPicPath = Path.Combine(displayPicPath, displayPicName); string relativeDisplayPicPath = Path.Combine("~/Members/" + note1.SellerID + "/" + note1.ID, displayPicName); model.sellerNotesAttachment.FilePath.SaveAs(fulldisplayPicPath); fNote.DisplayPicture = relativeDisplayPicPath; try { context.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { System.Diagnostics.Debug.WriteLine("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } string filePath = Server.MapPath("~/Members/" + note1.SellerID + "/" + note1.ID + "/Attachments"); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } string fileName = "Attachment_" + DateTime.Now.ToString("dd/MM/yyyy") + ".pdf"; string fullFilePath = Path.Combine(filePath, fileName); string relativeFilePath = Path.Combine("~/Members/" + note1.SellerID + "/" + note1.ID + "/Attachments", fileName); model.sellerNotesAttachment.FilePath.SaveAs(fullFilePath); var requiredNoteId = context.SellerNotes.Max(x => x.ID); Models.SellerNotesAttachment notesAttachment = new Models.SellerNotesAttachment() { NoteID = requiredNoteId, FileName = fileName, FilePath = relativeFilePath, CreatedDate = DateTime.Now, CreatedBy = note1.SellerID, ModifiedDate = DateTime.Now, ModifiedBy = note1.SellerID, IsActive = true }; context.SellerNotesAttachments.Add(notesAttachment); try { context.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { System.Diagnostics.Debug.WriteLine("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } return(View()); }