public JsonResult DeleteFile(long?id)
{
if (id == null)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json(new { Result = "Error" }));
}
try
{
// Guid guid = new Guid(id);
attachments_info fileDetail = db.attachment.Find(id);
if (fileDetail == null)
{
Response.StatusCode = (int)HttpStatusCode.NotFound;
return(Json(new { Result = "Error" }));
}
//Remove from database
db.attachment.Remove(fileDetail);
db.SaveChanges();
//Delete file from the file system
var path = Path.Combine(Server.MapPath("~/App_Data/Upload/"), fileDetail.fileName);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
return(Json(new { Result = "OK" }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public ActionResult Edit(enquiry_info enquiry_info)
{
if (ModelState.IsValid)
{
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
var fileName = Guid.NewGuid() + Path.GetFileName(file.FileName);
attachments_info attachment_info = new attachments_info()
{
fileName = fileName,
cid = enquiry_info.Id
};
var extension = Path.GetExtension(file.FileName);
var path = Path.Combine(Server.MapPath("~/App_Data/Upload/"), attachment_info.fileName);
file.SaveAs(path);
db.Entry(attachment_info).State = EntityState.Added;
}
}
db.Entry(enquiry_info).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid);
return(View(enquiry_info));
}
public ActionResult Create(enquiry_info enquiry_info, string search)
{
var userexist = db.client_info.Where(m => m.email_id == search).SingleOrDefault();
if (ModelState.IsValid)
{
if (userexist != null)
{
List <attachments_info> attachment = new List <attachments_info>();
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
var fileName = Guid.NewGuid() + Path.GetFileName(file.FileName);
attachments_info attachment_info = new attachments_info()
{
fileName = fileName
};
attachment.Add(attachment_info);
var extension = Path.GetExtension(file.FileName);
var path = Path.Combine(Server.MapPath("~/App_Data/Upload/"), attachment_info.fileName);
file.SaveAs(path);
}
}
var q = from c in db.client_info where c.email_id == search select c;
foreach (var cust in q)
{
enquiry_info.cid = cust.id;
}
db.enquiry.Add(enquiry_info);
enquiry_info.attachments = attachment;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Email does not exists");
return(View(enquiry_info));
}
}
ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid);
return(View(enquiry_info));
}
