public ActionResult UpdateAdminStatus(int uid, int status)
{
var emailid = User.Identity.Name.ToString();
Users superadmin = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault();
Users obj = dbobj.Users.Where(x => x.ID == uid).FirstOrDefault();
Admin adobj = dbobj.Admin.Where(x => x.UserID == uid).FirstOrDefault();
if (status == 0) // Deactivate Admin
{
obj.IsActive = false;
obj.ModifiedDate = DateTime.Now;
obj.ModifiedBy = superadmin.ID;
adobj.IsActive = false;
adobj.ModifiedDate = DateTime.Now;
adobj.ModifiedBy = superadmin.ID;
}
else // Activate Admin
{
obj.IsActive = true;
obj.ModifiedDate = DateTime.Now;
obj.ModifiedBy = superadmin.ID;
adobj.IsActive = true;
adobj.ModifiedDate = DateTime.Now;
adobj.ModifiedBy = superadmin.ID;
}
dbobj.Entry(obj).State = System.Data.Entity.EntityState.Modified;
dbobj.Entry(adobj).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
return(RedirectToAction("ManageAdmin"));
}
public ActionResult Deactivate(int uid)
{
var emailid = User.Identity.Name.ToString();
Users obj = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault();
Users userobj = dbobj.Users.Where(x => x.ID == uid).FirstOrDefault();
UserProfile upobj = dbobj.UserProfile.Where(x => x.UserID == uid).FirstOrDefault();
userobj.IsActive = false;
upobj.IsActive = false;
var usernotes = dbobj.SellerNotes.Where(x => x.SellerID == uid);
foreach (var item in usernotes)
{
item.IsActive = false;
dbobj.Entry(item).State = System.Data.Entity.EntityState.Modified;
}
/*var user_notes_attachments = dbobj.NoteTable.Where(x => x.UID == uid);
*
* foreach (var item in user_notes_attachments)
* {
* item.IsActive = false;
* }*/
dbobj.Entry(userobj).State = System.Data.Entity.EntityState.Modified;
dbobj.Entry(upobj).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
return(RedirectToAction("AllMembers"));
}
public ActionResult SignUp(Models.UsersModel model)
{
if (ModelState.IsValid)
{
var isExist = IsEmailExist(model.EmailID);
if (isExist)
{
ModelState.AddModelError("Email", "Email already exist");
return(View(model));
}
Users obj = new Users();
obj.RoleID = 3;
obj.FirstName = model.FirstName;
obj.LastName = model.LastName;
obj.EmailID = model.EmailID;
obj.Password = model.Password;
obj.IsEmailVerified = model.IsEmailVerified;
obj.IsActive = model.IsActive;
obj.SecretCode = Guid.NewGuid();
dbobj.Users.Add(obj);
dbobj.SaveChanges();
SendVerificationLinkEmail(model.EmailID, model.FirstName, obj.SecretCode.ToString());
TempData["Success"] = "Your account has been successfully created.";
}
ModelState.Clear();
return(RedirectToAction("SignUp"));
}
public ActionResult addType(NoteType model)
{
int id = (int)Session["UserID"];
if (ModelState.IsValid)
{
using (NotesMarketplaceEntities DBobj = new NotesMarketplaceEntities())
{
NoteType notetype = new NoteType();
notetype.TypeName = model.TypeName;
notetype.Description = model.Description;
notetype.IsActive = true;
notetype.ModifiedBy = id;
notetype.ModifiedDate = DateTime.Now;
notetype.CreatedDate = DateTime.Now;
notetype.CreatedBy = id;
DBobj.NoteType.Add(notetype);
DBobj.SaveChanges();
ModelState.Clear();
ViewBag.typeSuccess = "<p><span><i class='fas fa-check-circle'></i></span> Type added successfully.</p>";
}
}
return(View());
}
public ActionResult UpdatePassword(User user)
{
if (Session["userId"] == null)
{
return(RedirectToAction("Login", "Auth"));
}
else
{
int userId = (int)Session["userID"];
User currentUser = data.Users.Find(user.UserID);
if (user.Password.Equals(currentUser.Password))
{
currentUser.Password = user.NewPassword;
currentUser.ConfirmPassword = user.NewPassword;
currentUser.NewPassword = user.NewPassword;
currentUser.ConfirmNewPassword = user.NewPassword;
data.Entry(currentUser).State = System.Data.Entity.EntityState.Modified;
data.SaveChanges();
return(RedirectToAction("Login", "Auth"));
}
else
{
return(Content("The Old Password Not Matched !!!"));
//return RedirectToAction("ChangePassword", "Auth");
}
}
}
public ActionResult addAdministrator(adminSignUp model)
{
if (ModelState.IsValid)
{
using (NotesMarketplaceEntities DBobj = new NotesMarketplaceEntities())
{
Users u = new Users();
u.FirstName = model.FirstName;
u.LastName = model.LastName;
u.EmailID = model.EmailID;
u.UserRoleID = 2;
u.IsActive = true;
u.CreatedDate = DateTime.Now;
u.Password = "******";
u.IsEmailVerified = true;
DBobj.Users.Add(u);
DBobj.SaveChanges();
if (u.UserID > 0)
{
UserProfile up = new UserProfile();
up.UserID = u.UserID;
up.CountryCode = model.CountryCode;
up.PhoneNumber = model.PhoneNumber;
up.AddressLine1 = "null";
up.City = "null";
up.State = "null";
up.ZipCode = "null";
up.CountryID = 1;
up.CreatedDate = DateTime.Now;
up.IsActive = true;
DBobj.UserProfile.Add(up);
DBobj.SaveChanges();
ModelState.Clear();
var countrycode = DBobj.Countries.ToList();
ViewBag.countryCode = new SelectList(countrycode, "CountryCode", "CountryCode");
ViewBag.IsSuccess = "<p><span><i class='fas fa-check-circle'></i></span> Admin added successfully.</p>";
}
}
}
return(View());
}
//GET: DeleteType
public ActionResult deleteType(int id)
{
NotesMarketplaceEntities DBobj = new NotesMarketplaceEntities();
var typedetail = DBobj.NoteType.Where(x => x.NoteTypeID == id).FirstOrDefault();
typedetail.IsActive = false;
DBobj.SaveChanges();
return(RedirectToAction("manageType", "Admin"));
}
//GET: DeleteAdmin
public ActionResult deleteAdmin(int id)
{
NotesMarketplaceEntities DBobj = new NotesMarketplaceEntities();
var admindetail = DBobj.Users.Where(x => x.UserID == id).FirstOrDefault();
admindetail.IsActive = false;
DBobj.SaveChanges();
return(RedirectToAction("manageAdministrator", "Admin"));
}
//GET: DeleteCountry
public ActionResult deleteCountry(int id)
{
NotesMarketplaceEntities DBobj = new NotesMarketplaceEntities();
var countrydetail = DBobj.Countries.Where(x => x.CountryID == id).FirstOrDefault();
countrydetail.IsActive = false;
DBobj.SaveChanges();
return(RedirectToAction("manageCountry", "Admin"));
}
public ActionResult DeleteSpamReports(int sid)
{
SpamTable report = dbobj.SpamTable.Where(x => x.ID == sid).FirstOrDefault();
int nid = report.NoteID;
dbobj.SpamTable.Remove(report);
dbobj.SaveChanges();
var book = dbobj.SellerNotes.Where(x => x.ID == nid).FirstOrDefault();
int total_spams = dbobj.SpamTable.Where(x => x.NoteID == nid).Count();
book.TotalSpams = total_spams;
dbobj.Entry(book).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
return(RedirectToAction("SpamReports"));
}
public ActionResult AddCountry(AddCountry model)
{
var emailid = User.Identity.Name.ToString();
Users admin = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault();
if (ModelState.IsValid)
{
Countries obj = new Countries();
obj.Name = model.CountryName;
obj.CountryCode = model.CountryCode;
obj.CreatedDate = DateTime.Now;
obj.CreatedBy = admin.ID;
obj.IsActive = true;
dbobj.Countries.Add(obj);
dbobj.SaveChanges();
return(RedirectToAction("ManageCountries"));
}
return(View());
}
public ActionResult AddCategory(AddCategory model)
{
var emailid = User.Identity.Name.ToString();
Users admin = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault();
if (ModelState.IsValid)
{
NoteCategories obj = new NoteCategories();
obj.Name = model.CategoryName;
obj.Description = model.Description;
obj.CreatedDate = DateTime.Now;
obj.CreatedBy = admin.ID;
obj.IsActive = true;
dbobj.NoteCategories.Add(obj);
dbobj.SaveChanges();
return(RedirectToAction("ManageCategory"));
}
ViewBag.ProfilePicture = dbobj.Admin.Where(x => x.UserID == admin.ID).Select(x => x.ProfilePicture).FirstOrDefault();
return(View());
}
public ActionResult AllowDownload(int tid)
{
var emailid = User.Identity.Name.ToString();
Users obj = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault();
Transection deal = dbobj.Transection.Where(x => x.ID == tid).FirstOrDefault();
deal.IsAllowed = true;
dbobj.Entry(deal).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
NotifyBuyer(deal.Users.EmailID, deal.Users.FirstName, obj.FirstName);
return(RedirectToAction("BuyerRequest"));
}
public ActionResult DeleteBook(int noteid)
{
SellerNotesAttachements attachment = dbobj.SellerNotesAttachements.Where(x => x.NoteID == noteid).FirstOrDefault();
SellerNotes noteobj = dbobj.SellerNotes.Where(x => x.ID == noteid).FirstOrDefault();
string mappedPath = Server.MapPath("/Members/" + noteobj.SellerID + "/" + noteid);
Directory.Delete(mappedPath, true);
dbobj.SellerNotesAttachements.Remove(attachment);
dbobj.SellerNotes.Remove(noteobj);
dbobj.SaveChanges();
return(RedirectToAction("Dashboard"));
}
public ActionResult changePassword(ChangePass cp)
{
using (NotesMarketplaceEntities DBobj = new NotesMarketplaceEntities())
{
int id = (int)Session["UserID"];
Users u = DBobj.Users.Where(x => x.UserID == id).FirstOrDefault();
if (u.Password == cp.Password)
{
u.Password = cp.NewPassword;
DBobj.SaveChanges();
ViewBag.PassMessage = "<p><span><i class='fas fa-check-circle'></i></span> Your Password has been Changed successfully</p>";
}
}
return(View());
}
public ActionResult ContactUs(Models.ContactUsModel model)
{
if (ModelState.IsValid)
{
ContactUs obj = new ContactUs();
obj.FullName = model.FullName;
obj.EmailID = model.EmailID;
obj.Subjects = model.Subject;
obj.Comments = model.Comments;
dbobj.ContactUs.Add(obj);
dbobj.SaveChanges();
SendEmailToAdmin(obj);
}
ModelState.Clear();
return(RedirectToAction("ContactUs"));
}
//GET: InReviewNotes
public ActionResult inReviewNotes(int id)
{
using (NotesMarketplaceEntities DBobj = new NotesMarketplaceEntities())
{
NoteDetails note = DBobj.NoteDetails.FirstOrDefault(x => x.NoteID == id);
if (note != null)
{
note.Status = 5;
note.PublishedDate = DateTime.Now;
note.ActionBy = (int)Session["UserID"];
note.ModifiedBy = (int)Session["UserID"];
note.ModifiedDate = DateTime.Now;
DBobj.SaveChanges();
}
return(RedirectToAction("notesUnderReview", "Admin"));
}
}
public ActionResult AddAdmin(Models.AddAdmin model)
{
var emailid = User.Identity.Name.ToString();
Users admin = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault();
if (ModelState.IsValid)
{
var isExist = IsEmailExist(model.Email);
if (isExist)
{
ModelState.AddModelError("Email", "Email already exist");
ViewBag.CountryCode = new SelectList(dbobj.Countries, "CountryCode", "CountryCode");
return(View(model));
}
Users obj = new Users();
obj.RoleID = 2;
obj.FirstName = model.FirstName;
obj.LastName = model.LastName;
obj.EmailID = model.Email;
string pwd = Membership.GeneratePassword(6, 2);
obj.Password = pwd;
obj.IsEmailVerified = true;
obj.CreatedData = DateTime.Now;
obj.CreatedBy = admin.ID;
obj.IsActive = true;
Admin adobj = new Admin();
adobj.UserID = obj.ID;
adobj.CountryCode = model.CountryCode;
adobj.PhoneNumber = model.PhoneNumber;
adobj.CreatedDate = DateTime.Now;
adobj.CreatedBy = admin.ID;
adobj.IsActive = true;
dbobj.Users.Add(obj);
dbobj.Admin.Add(adobj);
dbobj.SaveChanges();
SendPasswordToAdmin(model.Email, pwd);
return(RedirectToAction("ManageAdmin", "Admin"));
}
return(View());
}
public ActionResult deactivateUser(int uid)
{
using (NotesMarketplaceEntities DBobj = new NotesMarketplaceEntities())
{
Users udetail = DBobj.Users.Where(x => x.UserID == uid).FirstOrDefault();
IQueryable <NoteDetails> ndetail = DBobj.NoteDetails.Where(x => x.SellerID == uid);
foreach (var i in ndetail)
{
i.IsActive = false;
SellerNoteAttachment nddetails = DBobj.SellerNoteAttachment.Where(x => x.NoteID == i.NoteID).FirstOrDefault();
nddetails.IsActive = false;
}
udetail.IsActive = false;
DBobj.SaveChanges();
return(View("members", "Admin"));
}
}
public ActionResult AdminProfile(NotesMarketplace.Models.AdminProfile model)
{
var emailid = User.Identity.Name.ToString();
Users obj = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault();
var apobj = dbobj.Admin.Where(x => x.UserID == obj.ID).FirstOrDefault();
obj.FirstName = model.FirstName;
obj.LastName = model.LastName;
obj.EmailID = model.Email;
apobj.SecondaryEmail = model.SecondaryEmail;
apobj.CountryCode = model.CountryCode;
apobj.PhoneNumber = model.PhoneNumber;
string path = Path.Combine(Server.MapPath("~/Members"), obj.ID.ToString());
//Checking for directory
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
//Saving Profile Picture
if (model.ProfilePicture != null && model.ProfilePicture.ContentLength > 0)
{
var ProfilePicture = DateTime.Now.ToString().Replace(':', '-').Replace(' ', '_') + Path.GetExtension(model.ProfilePicture.FileName);
var ImageSavePath = Path.Combine(Server.MapPath("~/Members/" + obj.ID + "/") + "DP_" + ProfilePicture);
model.ProfilePicture.SaveAs(ImageSavePath);
apobj.ProfilePicture = Path.Combine(("Members/" + obj.ID + "/"), "DP_" + ProfilePicture);
}
else
{
apobj.ProfilePicture = dbobj.SystemConfigurations.Where(x => x.Key == "DefaultProfilePicture").Select(x => x.Value).ToString();
}
dbobj.Entry(obj).State = System.Data.Entity.EntityState.Modified;
dbobj.Entry(apobj).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
return(RedirectToAction("AdminDashboard", "Admin"));
}
//GET: Unpublish Note
public ActionResult unPublishNote(int id, string adminRemarks)
{
using (NotesMarketplaceEntities DBobj = new NotesMarketplaceEntities())
{
NoteDetails note = DBobj.NoteDetails.FirstOrDefault(x => x.NoteID == id);
Users u = DBobj.Users.Where(x => x.UserID == note.SellerID).FirstOrDefault();
if (note != null)
{
note.Status = 6;
note.AdminRemarks = adminRemarks;
note.PublishedDate = DateTime.Now;
note.ActionBy = (int)Session["UserID"];
note.ModifiedBy = (int)Session["UserID"];
note.ModifiedDate = DateTime.Now;
DBobj.SaveChanges();
unPublishNoteToUser.unpublishNote(u.FirstName, u.EmailID, adminRemarks);
}
return(RedirectToAction("dashboard", "Admin"));
}
}
public ActionResult addCountry(Countries model)
{
if (ModelState.IsValid)
{
using (NotesMarketplaceEntities DBobj = new NotesMarketplaceEntities())
{
Countries cr = new Countries();
cr.CountryCode = model.CountryCode;
cr.CountryName = model.CountryName;
cr.IsActive = true;
cr.CreatedDate = DateTime.Now;
DBobj.Countries.Add(cr);
DBobj.SaveChanges();
ModelState.Clear();
ViewBag.countrySuccess = "<p><span><i class='fas fa-check-circle'></i></span> Country added successfully.</p>";
}
}
return(View());
}
public ActionResult addCategory(NoteCategories model)
{
if (ModelState.IsValid)
{
using (NotesMarketplaceEntities DBobj = new NotesMarketplaceEntities())
{
NoteCategories nc = new NoteCategories();
nc.CategoryName = model.CategoryName;
nc.Description = model.Description;
nc.IsActive = true;
nc.CreatedDate = DateTime.Now;
DBobj.NoteCategories.Add(nc);
DBobj.SaveChanges();
ModelState.Clear();
ViewBag.categorySuccess = "<p><span><i class='fas fa-check-circle'></i></span> Category added successfully.</p>";
}
}
return(View());
}
public ActionResult AddReview(int nid, int rate, string Comments)
{
var emailid = User.Identity.Name.ToString();
Users obj = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault();
var oldreview = dbobj.SellerNotesReviews.Where(x => x.NoteID == nid && x.ReviewedByID == obj.ID).FirstOrDefault();
if (oldreview == null) //New Review
{
SellerNotesReviews review = new SellerNotesReviews();
review.NoteID = nid;
review.ReviewedByID = obj.ID;
review.Ratings = rate;
review.Comments = Comments;
review.CreatedDate = DateTime.Now;
dbobj.SellerNotesReviews.Add(review);
dbobj.SaveChanges();
// Adding Ratings in note table
var book = dbobj.SellerNotes.Where(x => x.ID == nid).FirstOrDefault();
int total_reviews = dbobj.SellerNotesReviews.Where(x => x.NoteID == nid).Count();
decimal total_stars = dbobj.SellerNotesReviews.Where(x => x.NoteID == nid).Select(x => x.Ratings).Sum();
book.TotalReviews = total_reviews;
book.Rating = ((double)total_stars / total_reviews) * 20;
dbobj.Entry(book).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
// ------------------------------------------------------------
return(RedirectToAction("MyDownloads"));
}
else //Update Review
{
oldreview.Ratings = rate;
oldreview.Comments = Comments;
dbobj.Entry(oldreview).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
// Adding Ratings in note table
var book = dbobj.SellerNotes.Where(x => x.ID == nid).FirstOrDefault();
int total_reviews = dbobj.SellerNotesReviews.Where(x => x.NoteID == nid).Count();
decimal total_stars = dbobj.SellerNotesReviews.Where(x => x.NoteID == nid).Select(x => x.Ratings).Sum();
book.TotalReviews = total_reviews;
book.Rating = ((double)total_stars / total_reviews) * 20;
dbobj.Entry(book).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
// ------------------------------------------------------------
return(RedirectToAction("MyDownloads"));
}
}
public ActionResult AddNotes(NotesDetail notesDetail)
{
if (userid != 0)
{
List <ManageCTC> manageCTCs = db.ManageCTCs.ToList();
ViewBag.MyCTC = manageCTCs;
if (notesDetail != null)
{
if (notesDetail.Category.Equals("Select Your category"))
{
ViewBag.category = "Select category of note";
notesDetail.SellPrice = 0;
return(View(notesDetail));
}
if (notesDetail.NoteType.Equals("Select your mode type"))
{
notesDetail.NoteType = null;
}
if (notesDetail.Country.Equals("Select your country"))
{
notesDetail.Country = null;
}
if (notesDetail.Note_Attachment == null && notesDetail.NoteAttachment == null)
{
ViewBag.Note_Attachmen = "Please attach your notes here...";
notesDetail.SellPrice = 0;
return(View(notesDetail));
}
notesDetail.F_K_User = userid;
notesDetail.IsActive = true;
notesDetail.CreatedDate = DateTime.Now;
if (notesDetail.Book_Picture != null && (notesDetail.BookPicture == null))
{
if (notesDetail.Book_Picture.ContentLength > 1024 * 1024 * 10)
{
ViewBag.Book_Picture = "File size should be less then 10 MB!";
notesDetail.SellPrice = 0;
return(View(notesDetail));
}
string path = Server.MapPath("~/Uploads/BookPicture/");
String extension = Path.GetExtension(notesDetail.Book_Picture.FileName);
var supportedTypes = new[] { ".jpg", ".jpeg", ".png" };
if (supportedTypes.Contains(extension.ToUpper()) || supportedTypes.Contains(extension.ToLower()))
{
string fileName = userid.ToString() + DateTime.Now.ToString("G").Replace(" ", String.Empty).Replace("-", String.Empty).Replace(":", String.Empty) + extension;
notesDetail.Book_Picture.SaveAs(Path.Combine(path, fileName));
notesDetail.BookPicture = fileName;
}
else
{
ViewBag.Book_Picture = "Choose images only";
notesDetail.SellPrice = 0;
return(View(notesDetail));
}
}
if (notesDetail.Note_Attachment != null && notesDetail.NoteAttachment == null)
{
string path = Server.MapPath("~/Uploads/Books/");
String extension = Path.GetExtension(notesDetail.Note_Attachment.FileName);
var supportedTypes = new[] { ".pdf" };
if (supportedTypes.Contains(extension.ToUpper()) || supportedTypes.Contains(extension.ToLower()))
{
string fileName = userid.ToString() + DateTime.Now.ToString("G").Replace(" ", String.Empty).Replace("-", String.Empty).Replace(":", String.Empty) + extension;
notesDetail.Note_Attachment.SaveAs(Path.Combine(path, fileName));
notesDetail.NoteAttachment = fileName;
notesDetail.NoteSize = notesDetail.Note_Attachment.ContentLength;
}
else
{
ViewBag.Note_Attachment = "Choose pdf file only";
notesDetail.SellPrice = 0;
return(View(notesDetail));
}
}
if (notesDetail.SellPrice != 0 && notesDetail.Note_Preview == null)
{
ViewBag.Note_Preview = "Pleasse add note preview here...";
notesDetail.SellPrice = 0;
return(View(notesDetail));
}
if (notesDetail.Note_Preview != null && notesDetail.Note_Preview == null)
{
if (notesDetail.Note_Preview.ContentLength > 1024 * 1024 * 10)
{
ViewBag.Note_Preview = "File size should be less then 10 MB!";
notesDetail.SellPrice = 0;
return(View(notesDetail));
}
string path = Server.MapPath("~/Uploads/BookPreview/");
String extension = Path.GetExtension(notesDetail.Note_Preview.FileName);
var supportedTypes = new[] { ".pdf" };
if (supportedTypes.Contains(extension.ToUpper()) || supportedTypes.Contains(extension.ToLower()))
{
string fileName = userid.ToString() + DateTime.Now.ToString("G").Replace(" ", String.Empty).Replace("-", String.Empty).Replace(":", String.Empty) + extension;
notesDetail.Note_Preview.SaveAs(Path.Combine(path, fileName));
notesDetail.NotePreview = fileName;
}
else
{
ViewBag.Note_Preview = "Choose pdf only";
notesDetail.SellPrice = 0;
return(View(notesDetail));
}
}
try
{
if (notesDetail.F_K_NoteStatus == 3 && notesDetail.P_K_Note == 0)
{
User user = db.Users.FirstOrDefault(m => m.P_K_User == userid);
MailMessage mail = new MailMessage("*****@*****.**", user.EmailId.ToString());
mail.Subject = user.FirstName + " " + user.LastName + " sent his note for review";
string Body = "Hello Admins, \n\nWe want to inform you that, " + user.FirstName + " " + user.LastName + " sent his note " + notesDetail.Title + " for review.Please look at the notes and take required actions.\n\nRegards,\nNotes Marketplace";
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
NetworkCredential nc = new NetworkCredential("*****@*****.**", "12345678finalpatel");
smtp.EnableSsl = true;
smtp.Credentials = nc;
smtp.Send(mail);
}
}
catch
{
}
if (notesDetail.P_K_Note == 0)
{
db.NotesDetails.Add(notesDetail);
db.SaveChanges();
}
else
{
NotesDetail notesDetail1 = db.NotesDetails.FirstOrDefault(m => m.P_K_Note == notesDetail.P_K_Note);
if (notesDetail1 != null)
{
notesDetail1.F_K_NoteStatus = notesDetail.F_K_NoteStatus;
notesDetail1.F_K_User = notesDetail.F_K_User;
notesDetail1.BookPicture = notesDetail.BookPicture;
notesDetail1.Category = notesDetail.Category;
notesDetail1.Country = notesDetail.Country;
notesDetail1.Course = notesDetail.Course;
notesDetail1.CourseCode = notesDetail.CourseCode;
notesDetail1.InstitutionName = notesDetail.InstitutionName;
notesDetail1.ModifiedDate = DateTime.Now;
notesDetail1.NoteAttachment = notesDetail.NoteAttachment;
notesDetail1.NotePreview = notesDetail.NotePreview;
notesDetail1.NotesDescription = notesDetail1.NotesDescription;
notesDetail1.NoteSize = notesDetail.Note_Attachment.ContentLength;
notesDetail1.NoteType = notesDetail.NoteType;
notesDetail1.NumberOfPages = notesDetail.NumberOfPages;
notesDetail1.Professor = notesDetail.Professor;
notesDetail1.SellPrice = notesDetail.SellPrice;
notesDetail1.Title = notesDetail.Title;
db.SaveChanges();
}
}
}
else
{
return(View());
}
return(RedirectToAction("Dashboard", "Home"));
}
else
{
return(HttpNotFound());
}
}
public ActionResult AddNotes(Models.AddNotes model, string submitButton)
{
var emailID = User.Identity.Name.ToString();
Users obj = dbobj.Users.Where(x => x.EmailID == emailID).FirstOrDefault();
if (ModelState.IsValid)
{
if (model.ID == null)
{
if ((model.File[0] == null) || ((model.IsPaid == true) && (model.PreviewAttachment == null)))
{
if (model.File[0] == null)
{
ModelState.AddModelError("File", "File Required");
}
if (model.PreviewAttachment == null)
{
ModelState.AddModelError("PreviewAttachment", "PreviewAttachment Required");
}
ViewBag.Category = new SelectList(dbobj.NoteCategories, "ID", "Name");
ViewBag.Type = new SelectList(dbobj.NoteTypes, "ID", "Name");
ViewBag.Country = new SelectList(dbobj.Countries, "ID", "Name");
ViewBag.ProfilePicture = dbobj.UserProfile.Where(x => x.UserID == obj.RoleID).Select(x => x.ProfilePicture).FirstOrDefault();
return(View(model));
}
string path = Path.Combine(Server.MapPath("~/Members"), obj.ID.ToString());
//Checking for directory
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
SellerNotes noteobj = new SellerNotes();
noteobj.SellerID = obj.ID;
noteobj.Title = model.Title;
noteobj.Category = model.CategoryID;
noteobj.NoteType = model.TypeID;
noteobj.NumberofPages = model.NumberOfPages;
noteobj.Description = model.Description;
noteobj.Country = model.CountryID == null ? 8 : model.CountryID; //if null then country id = 8
noteobj.UniversityName = model.InstituteName;
noteobj.Course = model.CourseName == null ? "Other" : model.CourseName;
noteobj.CourseCode = model.CourseCode;
noteobj.Professor = model.Professor;
noteobj.IsPaid = model.IsPaid;
noteobj.SellingPrice = model.Price;
if (submitButton == "1")
{
noteobj.Status = 1;
}
else
{
noteobj.Status = 2;
}
noteobj.ActionedBy = obj.ID;
noteobj.CreatedDate = DateTime.Now;
noteobj.IsActive = true;
dbobj.SellerNotes.Add(noteobj);
dbobj.SaveChanges();
var NoteID = noteobj.ID;
string finalpath = Path.Combine(Server.MapPath("~/Members/" + obj.ID), NoteID.ToString());
if (!Directory.Exists(finalpath))
{
Directory.CreateDirectory(finalpath);
}
if (model.DisplayPicture != null && model.DisplayPicture.ContentLength > 0)
{
var displayimagename = DateTime.Now.ToString().Replace(':', '-').Replace(' ', '_') + Path.GetExtension(model.DisplayPicture.FileName);
var ImageSavePath = Path.Combine(Server.MapPath("~/Members/" + obj.ID + "/" + noteobj.ID + "/") + "DP_" + displayimagename);
model.DisplayPicture.SaveAs(ImageSavePath);
noteobj.DisplayPicture = Path.Combine(("Members/" + obj.ID + "/" + noteobj.ID + "/"), "DP_" + displayimagename);
dbobj.SaveChanges();
}
else
{
noteobj.DisplayPicture = "Default/Book.jpg";
dbobj.SaveChanges();
}
if (model.PreviewAttachment != null && model.PreviewAttachment.ContentLength > 0)
{
var notespreviewname = "Preview_" + DateTime.Now.ToString().Replace(':', '-').Replace(' ', '_') + "_" + Path.GetFileName(model.PreviewAttachment.FileName);
var PreviewSavePath = Path.Combine(Server.MapPath("~/Members/" + obj.ID + "/" + noteobj.ID + "/") + notespreviewname);
model.PreviewAttachment.SaveAs(PreviewSavePath);
noteobj.NotesPreview = Path.Combine(("Members/" + obj.ID + "/" + noteobj.ID + "/") + notespreviewname);
dbobj.SaveChanges();
}
SellerNotesAttachements natobj = new SellerNotesAttachements();
natobj.NoteID = NoteID; //nat stands for note attachment table
natobj.IsActive = true;
natobj.CreatedBy = obj.ID;
natobj.CreatedDate = DateTime.Now;
string AttachmentPath = Path.Combine(Server.MapPath("~/Members/" + obj.ID + "/" + noteobj.ID), "Attachment");
if (!Directory.Exists(AttachmentPath))
{
Directory.CreateDirectory(AttachmentPath);
}
int counter = 1;
var uploadfilepath = "";
var uploadfilename = "";
foreach (HttpPostedFileBase file in model.File)
{
//Checking file is available to save.
if (file != null)
{
var InputFileName = DateTime.Now.ToString().Replace(':', '-').Replace(' ', '_') + "_" + Path.GetFileName(file.FileName);
var ServerSavePath = Path.Combine(Server.MapPath("~/Members/" + obj.ID + "/" + noteobj.ID + "/Attachment/") + "Attachment_" + counter + "_" + InputFileName);
counter++;
//Save file to server folder
file.SaveAs(ServerSavePath);
uploadfilepath += Path.Combine(("Members/" + obj.ID + "/" + noteobj.ID + "/Attachment/") + "Attachment_" + counter + "_" + InputFileName) + ";";
uploadfilename += Path.GetFileName(file.FileName) + ";";
}
}
natobj.FileName = uploadfilename;
natobj.FilePath = uploadfilepath;
dbobj.SellerNotesAttachements.Add(natobj);
dbobj.SaveChanges();
}
else //for edit note
{
//saving into database
SellerNotes oldnote = dbobj.SellerNotes.Where(x => x.ID == model.ID).FirstOrDefault();
oldnote.Title = model.Title;
oldnote.Category = model.CategoryID;
oldnote.NoteType = model.TypeID;
oldnote.NumberofPages = model.NumberOfPages;
oldnote.Description = model.Description;
oldnote.Country = model.CountryID == null ? 8 : model.CountryID; //if null then country id = 8
oldnote.UniversityName = model.InstituteName;
oldnote.Course = model.CourseName == null ? "Other" : model.CourseName;
oldnote.CourseCode = model.CourseCode;
oldnote.Professor = model.Professor;
oldnote.IsPaid = model.IsPaid;
oldnote.SellingPrice = model.Price;
if (submitButton == "1")
{
oldnote.Status = 1;
}
else
{
oldnote.Status = 2;
}
oldnote.ActionedBy = obj.ID;
oldnote.ModifiedDate = DateTime.Now;
oldnote.IsActive = true;
dbobj.Entry(oldnote).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
var NoteID = oldnote.ID;
string finalpath = Path.Combine(Server.MapPath("~/Members/" + obj.ID), NoteID.ToString());
// For New Display Picture
if (model.DisplayPicture != null && model.DisplayPicture.ContentLength > 0)
{
var OldDisplayPicture = Server.MapPath(oldnote.DisplayPicture);
FileInfo file = new FileInfo(OldDisplayPicture);
if (file.Exists)
{
file.Delete();
}
var displayimagename = DateTime.Now.ToString().Replace(':', '-').Replace(' ', '_') + Path.GetExtension(model.DisplayPicture.FileName);
var ImageSavePath = Path.Combine(Server.MapPath("~/Members/" + obj.ID + "/" + oldnote.ID + "/") + "DP_" + displayimagename);
model.DisplayPicture.SaveAs(ImageSavePath);
oldnote.DisplayPicture = Path.Combine(("Members/" + obj.ID + "/" + oldnote.ID + "/"), "DP_" + displayimagename);
dbobj.SaveChanges();
}
// For New PreviewAttachment
if (model.PreviewAttachment != null && model.PreviewAttachment.ContentLength > 0)
{
var OldPreviewAttachment = Server.MapPath(oldnote.NotesPreview);
FileInfo file = new FileInfo(OldPreviewAttachment);
if (file.Exists)
{
file.Delete();
}
var notespreviewname = "Preview_" + DateTime.Now.ToString().Replace(':', '-').Replace(' ', '_') + "_" + Path.GetFileName(model.PreviewAttachment.FileName);
var PreviewSavePath = Path.Combine(Server.MapPath("~/Members/" + obj.ID + "/" + oldnote.ID + "/") + notespreviewname);
model.PreviewAttachment.SaveAs(PreviewSavePath);
oldnote.NotesPreview = Path.Combine(("Members/" + obj.ID + "/" + oldnote.ID + "/") + notespreviewname);
dbobj.SaveChanges();
}
if (model.File[0] != null) // New file Uploaded
{
SellerNotesAttachements oldnatobj = dbobj.SellerNotesAttachements.Where(x => x.NoteID == NoteID).FirstOrDefault();
oldnatobj.ModifiedDate = DateTime.Now;
string AttachmentPath = Path.Combine(Server.MapPath("~/Members/" + obj.ID + "/" + oldnote.ID), "Attachment");
Directory.Delete(AttachmentPath, true);
Directory.CreateDirectory(AttachmentPath);
int counter = 1;
var uploadfilepath = "";
var uploadfilename = "";
foreach (HttpPostedFileBase file in model.File)
{
//Checking file is available to save.
if (file != null)
{
var InputFileName = DateTime.Now.ToString().Replace(':', '-').Replace(' ', '_') + "_" + Path.GetFileName(file.FileName);
var ServerSavePath = Path.Combine(Server.MapPath("Members/" + obj.ID + "/" + oldnote.ID + "/Attachment/") + "Attachment_" + counter + "_" + InputFileName);
counter++;
//Save file to server folder
file.SaveAs(ServerSavePath);
uploadfilepath += Path.Combine(("Members/" + obj.ID + "/" + oldnote.ID + "/Attachment/") + "Attachment_" + counter + "_" + InputFileName) + ";";
uploadfilename += Path.GetFileName(file.FileName) + ";";
}
}
oldnatobj.FileName = uploadfilename;
oldnatobj.FilePath = uploadfilepath;
dbobj.Entry(oldnatobj).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
}
}
return(RedirectToAction("Dashboard", "Dashboard"));
}
ViewBag.Category = new SelectList(dbobj.NoteCategories, "ID", "Name");
ViewBag.Type = new SelectList(dbobj.NoteTypes, "ID", "Name");
ViewBag.Country = new SelectList(dbobj.Countries, "ID", "Name");
ViewBag.ProfilePicture = dbobj.UserProfile.Where(x => x.UserID == obj.ID).Select(x => x.ProfilePicture).FirstOrDefault();
return(View());
}
public ActionResult UserProfile(Models.UserProfile model)
{
var emailid = User.Identity.Name.ToString();
Users obj = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault();
if (ModelState.IsValid)
{
var isnew = dbobj.UserProfile.Where(x => x.UserID == obj.ID).FirstOrDefault();
if (isnew == null) // For new user
{
UserProfile upobj = new UserProfile();
upobj.UserID = obj.ID;
upobj.DOB = model.DateOfBirth;
upobj.Gender = model.Gender;
upobj.PhoneNumberCountryCode = model.CountryCode;
upobj.PhoneNumber = model.PhoneNumber;
upobj.AddressLine1 = model.AddressLine1;
upobj.AddressLine2 = model.AddressLine2;
upobj.City = model.City;
upobj.State = model.State;
upobj.ZipCode = model.ZipCode;
upobj.Country = model.CountryID;
upobj.University = model.University;
upobj.College = model.College;
upobj.CreatedDate = DateTime.Now;
upobj.CreatedBy = obj.ID;
upobj.IsActive = true;
string path = Path.Combine(Server.MapPath("~/Members"), obj.ID.ToString());
//Checking for directory
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
//Saving Profile Picture
if (model.ProfilePicture != null && model.ProfilePicture.ContentLength > 0)
{
var ProfilePicture = DateTime.Now.ToString().Replace(':', '-').Replace(' ', '_') + Path.GetExtension(model.ProfilePicture.FileName);
var ImageSavePath = Path.Combine(Server.MapPath("~/Members/" + obj.ID + "/") + "DP_" + ProfilePicture);
model.ProfilePicture.SaveAs(ImageSavePath);
upobj.ProfilePicture = Path.Combine(("Members/" + obj.ID + "/"), "DP_" + ProfilePicture);
dbobj.SaveChanges();
}
else
{
/*upobj.ProfilePicture = "Default/User.jpg";*/
upobj.ProfilePicture = dbobj.SystemConfigurations.Where(x => x.Key == "DefaultProfilePicture").Select(x => x.Value).ToString();
dbobj.SaveChanges();
}
dbobj.UserProfile.Add(upobj);
dbobj.SaveChanges();
return(RedirectToAction("SearchNotes", "SearchNotes"));
}
else
{
UserProfile oldupobj = dbobj.UserProfile.Where(x => x.UserID == obj.ID).FirstOrDefault();
Users olduserobj = dbobj.Users.Where(x => x.ID == obj.ID).FirstOrDefault();
olduserobj.FirstName = model.FirstName;
olduserobj.LastName = model.LastName;
olduserobj.EmailID = model.EmailID;
olduserobj.ModifiedDate = DateTime.Now;
olduserobj.ModifiedBy = olduserobj.ID;
oldupobj.DOB = model.DateOfBirth;
oldupobj.Gender = model.Gender;
oldupobj.PhoneNumberCountryCode = model.CountryCode;
oldupobj.PhoneNumber = model.PhoneNumber;
oldupobj.AddressLine1 = model.AddressLine1;
oldupobj.AddressLine2 = model.AddressLine2;
oldupobj.City = model.City;
oldupobj.State = model.State;
oldupobj.ZipCode = model.ZipCode;
oldupobj.Country = model.CountryID;
oldupobj.University = model.University;
oldupobj.College = model.College;
oldupobj.ModifiedDate = DateTime.Now;
oldupobj.ModifiedBy = obj.ID;
string path = Path.Combine(Server.MapPath("~/Members"), obj.ID.ToString());
//Saving Profile Picture
if (model.ProfilePicture != null && model.ProfilePicture.ContentLength > 0)
{
var OldProfilePicture = Server.MapPath(oldupobj.ProfilePicture);
FileInfo file = new FileInfo(OldProfilePicture);
if (file.Exists)
{
file.Delete();
}
var ProfilePicture = DateTime.Now.ToString().Replace(':', '-').Replace(' ', '_') + Path.GetExtension(model.ProfilePicture.FileName);
var ImageSavePath = Path.Combine(Server.MapPath("~/Members/" + obj.ID + "/") + "DP_" + ProfilePicture);
model.ProfilePicture.SaveAs(ImageSavePath);
oldupobj.ProfilePicture = Path.Combine(("Members/" + obj.ID + "/"), "DP_" + ProfilePicture);
dbobj.SaveChanges();
}
dbobj.Entry(olduserobj).State = System.Data.Entity.EntityState.Modified;
dbobj.Entry(oldupobj).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
return(RedirectToAction("SearchNotes", "SearchNotes"));
}
}
ViewBag.ProfilePicture = dbobj.UserProfile.Where(x => x.UserID == obj.ID).Select(x => x.ProfilePicture).FirstOrDefault();
return(View(model));
}
public ActionResult Download(int nid)
{
var emailid = User.Identity.Name.ToString();
Users obj = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault();
SellerNotes noteobj = dbobj.SellerNotes.Where(x => x.ID == nid).FirstOrDefault();
Users sellerobj = dbobj.Users.Where(x => x.ID == noteobj.SellerID).FirstOrDefault();
Transection deal = dbobj.Transection.Where(x => x.NoteID == nid && x.BuyerID == obj.ID).FirstOrDefault();
if (obj.ID == noteobj.SellerID) // Users own book
{
using (ZipFile zip = new ZipFile())
{
zip.AddDirectory(Server.MapPath("~/Members/" + noteobj.SellerID + "/" + nid + "/" + "Attachment"));
MemoryStream output = new MemoryStream();
zip.Save(output);
return(File(output.ToArray(), "Attachment/zip", noteobj.Title + ".zip"));
}
}
else
{
if (deal == null) // New Transection
{
if (noteobj.IsPaid == false) // Download Free Notes
{
Transection tobj = new Transection();
tobj.NoteID = nid;
tobj.Title = noteobj.Title;
tobj.Category = noteobj.NoteCategories.Name;
tobj.IsPaid = false;
tobj.Price = noteobj.SellingPrice;
tobj.BuyerID = obj.ID;
tobj.SellerID = noteobj.SellerID;
tobj.IsAllowed = true;
tobj.IsDownloaded = true;
tobj.DownloadDate = DateTime.Now;
tobj.Status = noteobj.ReferenceData.Value;
tobj.CreatedDate = DateTime.Now;
dbobj.Transection.Add(tobj);
dbobj.SaveChanges();
using (ZipFile zip = new ZipFile())
{
zip.AddDirectory(Server.MapPath("~/Members/" + noteobj.SellerID + "/" + nid + "/" + "Attachment"));
MemoryStream output = new MemoryStream();
zip.Save(output);
return(File(output.ToArray(), "Attachment/zip", noteobj.Title + ".zip"));
}
}
else // Download Paid Notes
{
Transection tobj = new Transection();
tobj.NoteID = nid;
tobj.Title = noteobj.Title;
tobj.Category = noteobj.NoteCategories.Name;
tobj.IsPaid = true;
tobj.Price = noteobj.SellingPrice;
tobj.BuyerID = obj.ID;
tobj.SellerID = noteobj.SellerID;
tobj.IsAllowed = false;
tobj.IsDownloaded = false;
tobj.DownloadDate = null;
tobj.Status = noteobj.ReferenceData.Value;
tobj.CreatedDate = DateTime.Now;
dbobj.Transection.Add(tobj);
dbobj.SaveChanges();
NotifySeller(sellerobj.EmailID, obj.FirstName, sellerobj.FirstName);
//return RedirectToAction("NoteDetails", new { nid });
ViewBag.CurrentUserName = obj.FirstName;
return(RedirectToAction("NoteDetails", new { nid }));
//return PartialView("ThanksPopup", noteobj);
}
}
else // Old Transection Available
{
if (noteobj.IsPaid == false) // Download Free Notes
{
using (ZipFile zip = new ZipFile())
{
zip.AddDirectory(Server.MapPath("~/Members/" + noteobj.SellerID + "/" + nid + "/" + "Attachment"));
MemoryStream output = new MemoryStream();
zip.Save(output);
return(File(output.ToArray(), "Attachment/zip", noteobj.Title + ".zip"));
}
}
else // Download Paid Notes
{
if ((bool)deal.IsAllowed)
{
deal.IsDownloaded = true;
deal.DownloadDate = DateTime.Now;
dbobj.Entry(deal).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
using (ZipFile zip = new ZipFile())
{
zip.AddDirectory(Server.MapPath("~/Members/" + noteobj.SellerID + "/" + nid + "/" + "Attachment"));
MemoryStream output = new MemoryStream();
zip.Save(output);
return(File(output.ToArray(), "Attachment/zip", noteobj.Title + ".zip"));
}
}
else
{
return(RedirectToAction("NoteDetails", nid));
}
}
}
}
}