public ActionResult Create([Bind(Include = "projectid,projectname,description,startdate,enddate,documentupload,estimatedhours,actualhours,projectstatus,activitystatus,createdby,createddate,modifiedby,modifieddate")] tbl_ManageProjects tbl_ManageProjects, HttpPostedFileBase[] documentupload)
{
if (ModelState.IsValid)
{
var createdby = Convert.ToString(Session["useremail"]);
tbl_ManageProjects.createdby = createdby;
tbl_ManageProjects.createddate = DateTime.Now;
string allfl = "";
foreach (HttpPostedFileBase file in documentupload)
{
//Checking file is available to save.
if (file != null)
{
var InputFileName = Path.GetFileName(file.FileName);
var ServerSavePath = Path.Combine(Server.MapPath("~/Content/Admin/UploadedFiles/") + InputFileName);
//Save file to server folder
file.SaveAs(ServerSavePath);
//assigning file uploaded status to ViewBag for showing message to user.
ViewBag.UploadStatus = documentupload.Count().ToString() + " files uploaded successfully.";
allfl += InputFileName + ",";
}
}
tbl_ManageProjects.documentupload = allfl.Remove(allfl.Length - 1, 1);
db.tbl_ManageProjects.Add(tbl_ManageProjects);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_ManageProjects));
}
public ActionResult DeleteConfirmed(int id)
{
tbl_ManageProjects tbl_ManageProjects = db.tbl_ManageProjects.Find(id);
db.tbl_ManageProjects.Remove(tbl_ManageProjects);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ViewTasks(int id)
{
tbl_ManageProjects projects = new tbl_ManageProjects();
//ViewBag.projectdetail = db.tbl_ManageProjects.Where(a => a.projectid == id);
var taskdata = db.tbl_ManageTask.Where(a => a.FKprojectid == id);
return(View(taskdata));
}
// GET: Admin/ProjectManage/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_ManageProjects tbl_ManageProjects = db.tbl_ManageProjects.Find(id);
if (tbl_ManageProjects == null)
{
return(HttpNotFound());
}
return(View(tbl_ManageProjects));
}
public ActionResult Edit([Bind(Include = "projectid,projectname,description,startdate,enddate,documentupload,estimatedhours,actualhours,projectstatus,activitystatus,createdby,createddate,modifiedby,modifieddate")] tbl_ManageProjects tbl_ManageProjects)
{
if (ModelState.IsValid)
{
var modifiedby = Convert.ToString(Session["useremail"]);
tbl_ManageProjects.modifiedby = modifiedby;
tbl_ManageProjects.modifieddate = DateTime.Now;
db.Entry(tbl_ManageProjects).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_ManageProjects));
}
