public ActionResult Create([Bind(Include = "freelancer_id,firstname,lastname,address,city,zipcode,phonenumber,email,birthdate,birthcity,nationality,username,password")] freelancer freelancer) { //Lista av valbara länder var countries = GetCountries(); freelancer fr = new freelancer(); freelancer.country = GetSelectListItems(countries); if (ModelState.IsValid) { db.freelancer.Add(freelancer); resume r = new resume(); r.profile = " "; r.driving_license = " "; r.freelancer_id = freelancer.freelancer_id; db.resume.Add(r); db.SaveChanges(); var savedid = freelancer.freelancer_id; return(RedirectToAction("Details", new { id = savedid })); } return(View(freelancer)); }
public ActionResult DeleteConfirmed(int id) { freelancer freelancer = db.freelancer.Find(id); db.freelancer.Remove(freelancer); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: freelancers/Create public ActionResult Create() { // Johan testar var country = GetCountries(); var f = new freelancer(); f.country = GetSelectListItems(country); return(View(f)); }
public ActionResult Edit([Bind(Include = "freelancer_id,firstname,lastname,address,city,zipcode,phonenumber,email,birthdate,birthcity,nationality,username,password")] freelancer freelancer) { if (ModelState.IsValid) { db.Entry(freelancer).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Details", new { id = freelancer.freelancer_id })); } return(View(freelancer)); }
// GET: FreelancerProfiles public ActionResult Index() { int id = 3; freelancer freelancer = db.freelancer.Find(id); FreelancerProfileOperations fpop = new FreelancerProfileOperations(); //return View(fpop.GetProfileDetails()); //return View(fpop.GetProfile(id)); return(View(fpop.GetFreelancerProfileById(id))); }
public ActionResult Edit([Bind(Include = "cv_id,freelancer_id,firstname,lastname,adress,phonenumber,email,PersonalLetter")] freelancer freelancer) { if (ModelState.IsValid) { db.Entry(freelancer).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Start")); } ViewBag.cv_id = new SelectList(db.cv, "cv_id", "nationality", freelancer.cv_id); return(View(freelancer)); }
public ActionResult Create([Bind(Include = "freelancer_id,firstname,lastname,adress,phonenumber,email,cv_id")] freelancer freelancer) { if (ModelState.IsValid) { db.freelancer.Add(freelancer); db.SaveChanges(); return(RedirectToAction("Create")); } //ViewBag.cv_id = new SelectList(db.cv, "cv_id", "nationality", freelancer.cv_id); return(View(freelancer)); }
public ActionResult CreateFreelancer([Bind(Include = "freelancer_id,firstname,lastname,adress,phonenumber,email,cv_id")] freelancer fe) { if (ModelState.IsValid) { fe.cv_id = fc.GetCvID(10); db.freelancer.Add(fe); db.SaveChanges(); return(RedirectToAction("Start", "freelancers")); } return(View()); }
// GET: freelancers/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } freelancer freelancer = db.freelancer.Find(id); if (freelancer == null) { return(HttpNotFound()); } return(View(freelancer)); }
// GET: freelancers/Details/5 public ActionResult Start(int?id = 9) { //ViewBag.skill = new SelectList(db.skill, "skill_id", "name"); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } freelancer freelancer = db.freelancer.Find(id); if (freelancer == null) { return(HttpNotFound()); } return(View(freelancer)); }
// GET: freelancers/Edit/5 public ActionResult Edit(int?id = 9) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } freelancer freelancer = db.freelancer.Find(id); if (freelancer == null) { return(HttpNotFound()); } ViewBag.cv_id = new SelectList(db.cv, "cv_id", "nationality", freelancer.cv_id); return(View(freelancer)); }
// GET: freelancers/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } freelancer freelancer = db.freelancer.Find(id); //FreelancerProfileOperations fpop = new FreelancerProfileOperations(); freelancer.FreelancerProfileResume = fpop.GetFreelancerProfileById(id); if (freelancer == null) { return(HttpNotFound()); } return(View(freelancer)); }
public freelancer GetFreelancerById(int?id) // Denna används inte längre. Ta bort? { freelancer freelanc = new freelancer(); FreelancerProfileOperations fpop = new FreelancerProfileOperations(); string sql = "SELECT freelancer_id, firstname, lastname, address, city, zipcode, phonenumber, email, birthdate, birthcity, nationality, username, password from freelancer WHERE freelancer_id = @freelancer_id"; using (SqlConnection conn = new SqlConnection(GetBuilder().ConnectionString)) { conn.Open(); using (SqlCommand command = new SqlCommand(sql, conn)) { command.Parameters.AddWithValue("freelancer_id", id); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { freelanc.freelancer_id = (int)reader["freelancer_id"]; freelanc.firstname = (string)reader["firstname"]; freelanc.lastname = (string)reader["lastname"]; freelanc.address = (string)reader["address"]; freelanc.city = (string)reader["city"]; freelanc.zipcode = (string)reader["zipcode"]; freelanc.phonenumber = (string)reader["phonenumber"]; freelanc.email = (string)reader["email"]; freelanc.birthdate = (DateTime)reader["birthdate"]; freelanc.birthcity = (string)reader["birthcity"]; freelanc.nationality = (string)reader["nationality"]; freelanc.username = (string)reader["username"]; freelanc.password = (string)reader["password"]; } } } freelanc.FreelancerProfileResume = fpop.GetFreelancerProfileById(id); } return(freelanc); }