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);
}
