// GET: Technology
public ActionResult Index()
{
tabledbEntities entities = new tabledbEntities();
var technolgyResult = entities.technolgies.ToList();
return(View(technolgyResult));
}
// GET: Country
public ActionResult Index()
{
tabledbEntities entities = new tabledbEntities();
var countryResult = entities.countries.ToList();
return(View(countryResult));
}
public ActionResult Details(int id)
{
tabledbEntities entities = new tabledbEntities();
backend backendObj = entities.backends.First(x => x.backendid == id);
return(View(backendObj));
}
public ActionResult Details(int id)
{
tabledbEntities entities = new tabledbEntities();
country countryObj = entities.countries.First(x => x.countryid == id);
return(View(countryObj));
}
// GET: Latestvideo
public ActionResult Index()
{
tabledbEntities entities = new tabledbEntities();
var videoList = entities.videos.ToList();
return(View(videoList));
}
public ActionResult Details(int id)
{
tabledbEntities entities = new tabledbEntities();
technolgy technolgyObj = entities.technolgies.First(x => x.technologyid == id);
return(View(technolgyObj));
}
public ActionResult Details(int id)
{
tabledbEntities entities = new tabledbEntities();
User userObj = entities.Users.First(x => x.UsersID == id);
return(View(userObj));
}
public ActionResult Index()
{
tabledbEntities entities = new tabledbEntities();
var backendResult = entities.backends.ToList();
return(View(backendResult));
}
public ActionResult Details(int id)
{
tabledbEntities entities = new tabledbEntities();
frontend frontendObj = entities.frontends.First(x => x.frontendid == id);
return(View(frontendObj));
}
// GET: Project
public ActionResult Index()
{
int userid = Convert.ToInt32(Session["userid"]);
tabledbEntities entities = new tabledbEntities();
List <ProjectWithFrontEndBackEnd> ProjectObjList = new List <ProjectWithFrontEndBackEnd>();
var projectlst = entities.Projects
.Join(entities.frontends, p => p.FrontendId, f => f.frontendid,
(p, f) => new { p.Name,
p.Description, p.Projectfile, f.frontendname, p.ProjectID, p })
.Join(entities.backends, p => p.p.BackendId, b => b.backendid,
(p, b) => new { p, b.backendname }).Where(o => o.p.p.UserId == userid).ToList();
foreach (var proj in projectlst)
{
ProjectWithFrontEndBackEnd prj = new ProjectWithFrontEndBackEnd();
prj.ProjectName = proj.p.Name;
prj.ProjectId = proj.p.ProjectID;
prj.ProjectDescription = proj.p.Description;
prj.ProjectFile = proj.p.Projectfile;
prj.FrontEndName = proj.p.frontendname;
prj.BackEndName = proj.backendname;
ProjectObjList.Add(prj);
}
return(View(ProjectObjList));
}
public ActionResult Edit(int id)
{
tabledbEntities entities = new tabledbEntities();
User userObj = entities.Users.Where(x => x.UsersID == id).FirstOrDefault();
return(View(userObj));
}
public ActionResult create(country countryObj)
{
tabledbEntities entities = new tabledbEntities();
entities.countries.Add(countryObj);
entities.SaveChanges();
return(RedirectToAction("index"));
}
public ActionResult Create()
{
tabledbEntities entities = new tabledbEntities();
ViewBag.Technology = entities.technolgies.ToList();
return(View());
}
public ActionResult Edit(frontend frontendObj)
{
tabledbEntities entities = new tabledbEntities();
entities.Entry(frontendObj).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
return(RedirectToAction("index"));
}
public ActionResult create(frontend frontendObj)
{
tabledbEntities entities = new tabledbEntities();
entities.frontends.Add(frontendObj);
entities.SaveChanges();
return(RedirectToAction("index"));
}
public ActionResult delete(country countryObj)
{
tabledbEntities entities = new tabledbEntities();
entities.Entry(countryObj).State = System.Data.Entity.EntityState.Deleted;
entities.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(backend backendObj)
{
tabledbEntities entities = new tabledbEntities();
entities.Entry(backendObj).State = EntityState.Deleted;
entities.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult create(technolgy technolgyObj)
{
tabledbEntities entities = new tabledbEntities();
entities.technolgies.Add(technolgyObj);
entities.SaveChanges();
return(RedirectToAction("index"));
}
public ActionResult Index()
{
tabledbEntities entities = new tabledbEntities();
var userList = entities.Users.ToList();
ViewBag.TotalUsers = entities.Users.Count();
return(View(userList));
}
public ActionResult Create()
{
tabledbEntities entities = new tabledbEntities();
//List<SelectListItem> frontend =
ViewBag.FrontEnd = entities.frontends.ToList();
ViewBag.BackEnd = entities.backends.ToList();
return(View());
}
// GET: Video
public ActionResult Index()
{
int userid = Convert.ToInt32(Session["userid"]);
tabledbEntities entities = new tabledbEntities();
var videolist = entities.videos.Join
(entities.technolgies, r => r.technologyid, p => p.technologyid, (r, p)
=> new VideoWithTechnology {
video = r, technolgy = p
}).Where(t => t.video.userid == userid);
return(View(videolist.ToList()));
}
public ActionResult Create(video videoss, HttpPostedFileBase uploadfile)
{
tabledbEntities entities = new tabledbEntities();
if (uploadfile != null)
{
string file = Guid.NewGuid().ToString().Substring(0, 6) + uploadfile.FileName;
uploadfile.SaveAs(Server.MapPath("~/UploadedImages/") + file);
videoss.uploadfile = file;
}
videoss.userid = Convert.ToInt32(Session["userid"]);
entities.Entry(videoss).State = System.Data.Entity.EntityState.Added;
entities.SaveChanges();
return(RedirectToAction("Create"));
}
public ActionResult Create(Project project, HttpPostedFileBase projectFile)
{
tabledbEntities entities = new tabledbEntities();
if (projectFile != null)
{
string file = Guid.NewGuid().ToString().Substring(0, 6) + projectFile.FileName;
projectFile.SaveAs(Server.MapPath("~/UploadedImages/") + file);
project.Projectfile = file;
}
project.UserId = Convert.ToInt32(Session["userid"]);
entities.Entry(project).State = System.Data.Entity.EntityState.Added;
entities.SaveChanges();
return(RedirectToAction("Create"));
}
