protected override void Dispose(bool disposing)
{
CERLDBContext db = new CERLDBContext();
db.Dispose();
base.Dispose(disposing);
}
public ActionResult DeleteConfirmed(int id)
{
CERLDBContext db = new CERLDBContext();
LabInformation labinformation = db.LabInformation.Find(id);
db.LabInformation.Remove(labinformation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /LabInformation/Delete/5
public ActionResult Delete(int id = 0)
{
CERLDBContext db = new CERLDBContext();
LabInformation labinformation = db.LabInformation.Find(id);
if (labinformation == null)
{
return(HttpNotFound());
}
return(View(labinformation));
}
//
// GET: /LabInformation/Details/5
public ActionResult Details(int id = 0)
{
CERLDBContext db = new CERLDBContext();
vLabInformation vlabinfo = db.vLabInformation.Find(id);
if (vlabinfo == null)
{
return(HttpNotFound());
}
InitAttachFiles(vlabinfo.fID);
return(View(vlabinfo));
}
//
// GET: /LabInformation/
public ActionResult Home(int?id)
{
CERLDBContext db = new CERLDBContext();
int ItemId = -1;
if (id != null)
{
int.TryParse(id.ToString(), out ItemId);
ViewBag.id = id = ItemId;
}
else
{
ViewBag.id = id = ItemId;
}
IList <vLabInformation> PartialInfoContent = db.vLabInformation.Where(x => x.IsShowMessage == true).ToList();
IList <vLabInfoAttachFile> PartialInfoImage = db.vLabInfoAttachFile.Where(x => x.IsShowPicture == true).ToList();
ViewData["PartialInfoContent"] = PartialInfoContent;
ViewData["PartialInfoImage"] = PartialInfoImage;
return(View());
}
public ActionResult GetFilePath(int fileId, bool record)
{
CERLDBContext db = new CERLDBContext();
if (fileId == 0)
{
return(View());
}
string result = (from f in db.attachFiles.Where(x => x.fileId == fileId)
select f.filePath + f.fileName).FirstOrDefault();
var attachFile = (from f in db.attachFiles.Where(x => x.fileId == fileId)
select f).FirstOrDefault();
//string fullFilePath = Server.MapPath(result);
if (!string.IsNullOrEmpty(result) && System.IO.File.Exists(result))
{
return(File(System.IO.File.ReadAllBytes(result), "application/unknown", HttpUtility.UrlEncode(Path.GetFileName(result))));
}
else
{
return(View("File not exists: " + result));
}
}
public ActionResult Index()
{
CERLDBContext db = new CERLDBContext();
return(View(db.vLabInformation.ToList()));
}
public ActionResult Edit(FormCollection labInfo, LabInformation labinformation)
{
CERLDBContext db = new CERLDBContext();
string UserId = Method.GetLogonUserId(Session, this, User.Identity.Name.ToUpper());
string FolderId = "LabInformation";
if (ModelState.IsValid)
{
labinformation.udt = DateTime.Now;
labinformation.editor = UserId;
labinformation.Width = (labinformation.Width == null || labinformation.Width.Trim() == "") ? "100%" : labinformation.Width;
labinformation.Height = (labinformation.Height == null || labinformation.Height.Trim() == "") ? "100%" : labinformation.Height;
var r = new List <attachFile>();
int i = 0;
foreach (string file in Request.Files)
{
HttpPostedFileBase hpf = Request.Files[i] as HttpPostedFileBase;
if (hpf.ContentLength == 0)
{
continue;
}
string formId = labinformation.fID;
string filePath = Constant.UserFileDirectory + FolderId + @"\" + formId + @"\";
FileInfo newinfo = new FileInfo(hpf.FileName);
string savedFileName = Path.Combine(filePath, Path.GetFileName(newinfo.Name));
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
hpf.SaveAs(savedFileName);
int count = db.attachFiles.Where(x => x.fID == formId && x.fileName == newinfo.Name).Count();
if (count == 0)
{
r.Add(new attachFile()
{
fID = formId,
displayname = newinfo.Name,
fileName = newinfo.Name,
Length = hpf.ContentLength,
Type = hpf.ContentType,
folderId = FolderId,
editor = UserId,
filePath = filePath,
cdt = DateTime.Now,
udt = DateTime.Now
});
}
i++;
}
foreach (attachFile a in r)
{
db.attachFiles.Add(a);
}
db.Entry(labinformation).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(labinformation));
}
public ActionResult Create(FormCollection labInfo, LabInformation labinformation)
{
CERLDBContext db = new CERLDBContext();
string FolderId = "LabInformation";
string Editor = Method.GetLogonUserId(Session, this, User.Identity.Name.ToUpper());
string FormId = System.Guid.NewGuid().ToString().ToUpper();
labinformation.fID = FormId;
labinformation.editor = Editor;
labinformation.cdt = DateTime.Now;
labinformation.udt = DateTime.Now;
if (ModelState.IsValid)
{
var r = new List <attachFile>();
int i = 0;
foreach (string file in Request.Files)
{
HttpPostedFileBase hpf = Request.Files[i] as HttpPostedFileBase;
if (hpf.ContentLength == 0)
{
continue;
}
string formId = FormId;
string filePath = Constant.UserFileDirectory + FolderId + @"\" + formId + @"\";
FileInfo newinfo = new FileInfo(hpf.FileName);
string savedFileName = Path.Combine(filePath, Path.GetFileName(newinfo.Name));
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
hpf.SaveAs(savedFileName);
r.Add(new attachFile()
{
fID = formId,
displayname = newinfo.Name,
fileName = newinfo.Name,
Length = hpf.ContentLength,
Type = hpf.ContentType,
folderId = FolderId,
editor = Editor,
filePath = filePath,
cdt = DateTime.Now,
udt = DateTime.Now
});
i++;
}
foreach (attachFile a in r)
{
db.attachFiles.Add(a);
}
db.LabInformation.Add(labinformation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(labinformation));
}
