public ActionResult DeleteConfirmed(long id)
{
EXPERIENCE eXPERIENCE = db.EXPERIENCEs.Find(id);
db.EXPERIENCEs.Remove(eXPERIENCE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "experienceid,userid,experience1")] EXPERIENCE eXPERIENCE)
{
if (ModelState.IsValid)
{
db.Entry(eXPERIENCE).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.userid = new SelectList(db.PROFILES, "userid", "firstname", eXPERIENCE.userid);
return(View(eXPERIENCE));
}
// GET: Experiences/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EXPERIENCE eXPERIENCE = db.EXPERIENCEs.Find(id);
if (eXPERIENCE == null)
{
return(HttpNotFound());
}
return(View(eXPERIENCE));
}
// GET: Experiences/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EXPERIENCE eXPERIENCE = db.EXPERIENCEs.Find(id);
if (eXPERIENCE == null)
{
return(HttpNotFound());
}
ViewBag.userid = new SelectList(db.PROFILES, "userid", "firstname", eXPERIENCE.userid);
return(View(eXPERIENCE));
}
public bool UpdateExperience(EXPERIENCE Entity)
{
using (KARYABDBEntities db = new KARYABDBEntities())
{
try
{
// var Skill = db.SKILLS.FirstOrDefault(q => q.ID == SkillID);
db.EXPERIENCES.Attach(Entity);
var Entry = db.Entry(Entity);
Entry.State = EntityState.Modified;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public long SetExperience(EXPERIENCE Experience, long HumanID)
{
using (KARYABDBEntities db = new KARYABDBEntities())
{
try
{
db.Configuration.ProxyCreationEnabled = false;
db.EXPERIENCES.Add(Experience);
db.SaveChanges();
OWNERSEXPERIENCE owenersExperience = new OWNERSEXPERIENCE();
owenersExperience.EXPERIENCEID = Experience.ID;
owenersExperience.EXPERIENCEOWNERID = HumanID;
db.OWNERSEXPERIENCES.Add(owenersExperience);
db.SaveChanges();
return(Experience.ID);
}
catch
{
return(0);
}
}
}
public bool DeleteExperience(EXPERIENCE Entity)
{
using (KARYABDBEntities db = new KARYABDBEntities())
{
try
{
db.Configuration.ProxyCreationEnabled = false;
EXPERIENCE entity = db.EXPERIENCES.FirstOrDefault(q => q.ID == Entity.ID);
OWNERSEXPERIENCE Owner = db.OWNERSEXPERIENCES.FirstOrDefault(q => q.EXPERIENCEID == Entity.ID);
db.OWNERSEXPERIENCES.Attach(Owner);
db.OWNERSEXPERIENCES.Remove(Owner);
db.SaveChanges();
db.EXPERIENCES.Attach(entity);
db.EXPERIENCES.Remove(entity);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
