public void MaptoModel(tblSellerNote note, tblSellerNotesAttachement attachment)
{
note.Title = Title;
note.Category = Category;
note.DisplayPicture = DisplayPicture;
note.NoteType = NoteType;
note.NumberofPages = NumberofPages;
note.Description = Description;
note.UniversityName = UniversityName;
note.Country = Country;
note.Course = Course;
note.CourseCode = CourseCode;
note.Professor = Professor;
note.SellingPrice = SellingPrice;
note.NotesPreview = NotePreview;
attachment.FileName = UploadNotes;
}
public ActionResult Add_Notes(tblSellerNote model)
{
NotesMarketPlaceEntities entities = new NotesMarketPlaceEntities();
var NoteCategory = entities.tblNoteCategories.ToList();
SelectList list = new SelectList(NoteCategory, "ID", "Name");
ViewBag.NoteCategory = list;
var NoteType = entities.tblNoteTypes.ToList();
SelectList NoteTypelist = new SelectList(NoteType, "ID", "Name");
ViewBag.NoteType = NoteTypelist;
var CountryName = entities.tblCountries.ToList();
SelectList CountryList = new SelectList(CountryName, "ID", "Name");
ViewBag.Country = CountryList;
string name = User.Identity.Name;
int access = (from user in dbobject.tblUsers where user.EmailID == name select user.ID).Single();
string book_title = model.Title;
string notename_fullpath = null;
string picname_fullpath = null;
string previewname_fullpath = null;
tblSellerNote obj = new tblSellerNote();
int lastid = (from row in dbobject.tblSellerNotes orderby row.ID descending select row.ID).FirstOrDefault();
lastid += 1;
string defaultpath = Server.MapPath(string.Format("~/Content/Files/{0}", lastid));
if (!Directory.Exists(defaultpath))
{
Directory.CreateDirectory(defaultpath);
}
if (model.uploadNote != null)
{
string notename = Path.GetFileName(model.uploadNote.FileName);
notename_fullpath = Path.Combine(defaultpath, notename);
model.uploadNote.SaveAs(notename_fullpath);
}
else
{
ViewBag.Message = "Please upload note";
return(View());
}
if (model.displayPic != null)
{
string picname = Path.GetFileName(model.displayPic.FileName);
picname_fullpath = Path.Combine(defaultpath, picname);
model.displayPic.SaveAs(picname_fullpath);
obj.DisplayPicture = picname_fullpath;
}
if (model.notePreview != null)
{
string previewname = Path.GetFileName(model.notePreview.FileName);
previewname_fullpath = Path.Combine(defaultpath, previewname);
model.notePreview.SaveAs(previewname_fullpath);
obj.NotesPreview = previewname_fullpath;
}
obj.SellerID = access;
obj.Title = model.Title;
obj.Category = model.Category;
obj.NoteType = model.NoteType;
obj.NumberofPages = model.NumberofPages;
obj.Description = model.Description;
obj.UniversityName = model.UniversityName;
obj.Country = model.Country;
obj.Course = model.Course;
obj.CourseCode = model.CourseCode;
obj.Professor = model.Professor;
obj.Status = 7;
obj.CreatedDate = DateTime.Now;
obj.CreatedBy = access;
obj.IsActive = true;
obj.IsPaid = model.IsPaid;
if (obj.IsPaid)
{
obj.SellingPrice = model.SellingPrice;
}
else
{
obj.SellingPrice = 0;
}
dbobject.tblSellerNotes.Add(obj);
dbobject.SaveChanges();
//try
//{
// dbobject.SaveChanges();
//}
//catch (DbEntityValidationException e)
//{
// foreach (var eve in e.EntityValidationErrors)
// {
// Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
// eve.Entry.Entity.GetType().Name, eve.Entry.State);
// foreach (var ve in eve.ValidationErrors)
// {
// Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
// ve.PropertyName, ve.ErrorMessage);
// }
// }
//}
int book_id = (from record in dbobject.tblSellerNotes where record.SellerID == access && record.Title == book_title orderby record.ID descending select record.ID).First();
tblSellerNotesAttachement sellerattachment = new tblSellerNotesAttachement();
sellerattachment.NoteID = book_id;
sellerattachment.FilePath = notename_fullpath;
sellerattachment.FileName = book_title;
sellerattachment.CreatedBy = access;
sellerattachment.CreatedDate = DateTime.Now;
sellerattachment.IsActive = true;
dbobject.tblSellerNotesAttachements.Add(sellerattachment);
dbobject.SaveChanges();
ModelState.Clear();
return(View());
}
public ActionResult addnote(tblSellerNote model)
{
NotesMarketPlaceEntities entities = new NotesMarketPlaceEntities();
var NoteCategory = entities.tblNoteCategories.ToList();
SelectList list = new SelectList(NoteCategory, "ID", "Name");
ViewBag.NoteCategory = list;
var NoteType = entities.tblNoteTypes.ToList();
SelectList NoteTypelist = new SelectList(NoteType, "ID", "Name");
ViewBag.NoteType = NoteTypelist;
var CountryName = entities.tblCountries.ToList();
SelectList CountryList = new SelectList(CountryName, "ID", "Name");
ViewBag.Country = CountryList;
string name = User.Identity.Name;
int u = (from user in dbobj.tblUsers where user.EmailID == name select user.ID).Single();
string book_title = model.Title;
string notename_fullpath = null;
string picname_fullpath = null;
string previewname_fullpath = null;
tblSellerNote obj = new tblSellerNote();
if (model.uploadNote != null)
{
string notepath = Server.MapPath("~/App_Data/Files");
string notename = Path.GetFileName(model.uploadNote.FileName);
notename_fullpath = Path.Combine(notepath, notename);
model.uploadNote.SaveAs(notename_fullpath);
}
else
{
ViewBag.Message = "Please Upload You File";
return(View());
}
if (model.displayPic != null)
{
string picpath = Server.MapPath("~/App_Data/Files");
string picname = Path.GetFileName(model.displayPic.FileName);
picname_fullpath = Path.Combine(picpath, picname);
model.displayPic.SaveAs(picname_fullpath);
obj.DisplayPicture = picname_fullpath;
}
if (model.notePreview != null)
{
string previewpath = Server.MapPath("~/App_Data/Files");
string previewname = Path.GetFileName(model.notePreview.FileName);
previewname_fullpath = Path.Combine(previewpath, previewname);
model.notePreview.SaveAs(previewname_fullpath);
obj.NotesPreview = previewname_fullpath;
}
try
{
obj.SellerID = u;
obj.Title = model.Title;
obj.Category = model.Category;
obj.NoteType = model.NoteType;
obj.NumberofPages = model.NumberofPages;
obj.Description = model.Description;
obj.UniversityName = model.UniversityName;
obj.Country = model.Country;
obj.Course = model.Course;
obj.CourseCode = model.CourseCode;
obj.Professor = model.Professor;
obj.Status = 7;
obj.IsActive = true;
obj.SellingPrice = model.SellingPrice;
obj.IsPaid = model.IsPaid;
dbobj.tblSellerNotes.Add(obj);
dbobj.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
}
int book_id = (from record in dbobj.tblSellerNotes where record.SellerID == u && record.Title == book_title select record.ID).First();
try
{
tblSellerNotesAttachement sellerattachment = new tblSellerNotesAttachement();
sellerattachment.NoteID = book_id;
sellerattachment.FilePath = notename_fullpath;
sellerattachment.FileName = book_title;
sellerattachment.CreatedBy = u;
sellerattachment.CreatedDate = DateTime.Now;
sellerattachment.IsActive = true;
dbobj.tblSellerNotesAttachements.Add(sellerattachment);
dbobj.SaveChanges();
}
catch
{
}
return(View());
}
