public ActionResult Page_2(string code)
{
var email = Session["UserEmail"] as string;
if (email == null)
{
return(Content("Can not find user email. Please login to continue"));
}
using (InterviewTest001.Models.Context.AppDataContext db = new Models.Context.AppDataContext())
{
var files = db.UserDocuments.Where(f => f.CreatedBy == email && f.TransactionNo == code).ToList();
if (!String.IsNullOrEmpty(email))
{
files = files.Where(s => s.CreatedBy.Contains(email)).ToList();
}
if (files.Count >= 1)
{
return(View(files));
}
else
{
List <UserDocument> doc = new List <UserDocument>();
return(View(doc));
}
}
}
private ActionResult DeleteFile(string id)
{
using (InterviewTest001.Models.Context.AppDataContext db = new Models.Context.AppDataContext())
{
//Code to Delete From Database and folder here
}
return(View());
}
public ActionResult UploadFiles(string email, string fullname)
{
Random rd = new Random();
var uniqueCode = "TN/" + rd.Next(1111, 9999) + "/" + rd.Next(0, 1000);
using (InterviewTest001.Models.Context.AppDataContext db = new Models.Context.AppDataContext())
{
var chkEmail = db.UserInformations.Where(f => f.Email == email).FirstOrDefault();
if (chkEmail.Equals(email))
{
return(Content("Email already exists"));
}
else
{
UserInformation newUser = new UserInformation
{
Email = email,
FullName = fullname,
TransactionNo = uniqueCode,
UserId = Guid.NewGuid()
};
db.UserInformations.Add(newUser);
db.SaveChanges();
Session["UserEmail"] = email;
}
}
try
{
string FileName = "";
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
string fname;
fname = file.FileName;
FileName = file.FileName;
// Get the complete folder path and store the file inside it.
fname = Path.Combine(Server.MapPath("~/Content/Documents/"), fname);
file.SaveAs(fname);
//Code to save inside database
using (InterviewTest001.Models.Context.AppDataContext db = new Models.Context.AppDataContext())
{
UserDocument newDoc = new UserDocument
{
DocumentId = Guid.NewGuid(),
DocumentTitle = FileName,
DocumentPath = "/Content/Documents/" + fname,
DocumentSize = file.ContentLength,
DateCreated = DateTime.Now,
CreatedBy = email,
TransactionNo = uniqueCode
};
db.UserDocuments.Add(newDoc);
db.SaveChanges();
SendEmail(email, uniqueCode);
}
}
return(Json(uniqueCode, JsonRequestBehavior.AllowGet));
}
catch (Exception err)
{
return(Json(err.Message, JsonRequestBehavior.AllowGet));
}
}
