// // GET: /رزومه/ public ActionResult مشاهده(long HumanId) { ViewBag.HumanID = HumanId; ResumeViewModel Resume = new ResumeViewModel(); using (KARYABDBEntities db = new KARYABDBEntities()) { HUMAN human = db.HUMen.FirstOrDefault(q => q.ID == HumanId); Resume.NAME = human.NAME; Resume.GENDER = human.GENDER; Resume.USAGE = human.USAGE; //Resume.Image = db.IMAGES.FirstOrDefault(q => q.HUMANID == HumanId).IMAGE1; List <long> ExperiencesIds = db.OWNERSEXPERIENCES.Where(q => q.EXPERIENCEOWNERID == HumanId).Select(q => q.EXPERIENCEID).ToList(); Resume.Experiences = db.EXPERIENCES.Where(q => ExperiencesIds.Contains(q.ID)).ToList(); List <long> EducationIds = db.OWNERSEDUCATIONS.Where(q => q.EDUCATIONOWNERID == HumanId).Select(q => q.EDUCATIONID).ToList(); Resume.Educations = db.EDUCATONS.Where(q => EducationIds.Contains(q.ID)).ToList(); List <long> SkillIlds = db.OWNERSSKILLS.Where(q => q.SKILLOWNERID == HumanId).Select(q => q.SKILLID).ToList(); Resume.Skills = db.SKILLS.Where(q => SkillIlds.Contains(q.ID)).ToList(); List <long> AdressIds = db.OWNERSADRESES.Where(q => q.ADRESSOWNERID == HumanId).Select(q => q.ADRESSID).ToList(); Resume.Adresses = db.ADRESSES.Where(q => AdressIds.Contains(q.ID)).ToList(); List <long> PhoneIds = db.OWNERSPHOES.Where(q => q.PHONEOWNERID == HumanId).Select(q => q.PHONENUMBERID).ToList(); Resume.Phones = db.PHONES.Where(q => PhoneIds.Contains(q.ID)).ToList(); List <long> CellPhoneIds = db.OWNERSCELLPHONES.Where(q => q.CELLPHONEOWNERID == HumanId).Select(q => q.CELLPHONEID).ToList(); Resume.Cellphones = db.CELLPHONES.Where(q => CellPhoneIds.Contains(q.ID)).ToList(); List <long> EmailIds = db.OWNERSMAILS.Where(q => q.MAILOWNERID == HumanId).Select(q => q.MAILADRESSID).ToList(); Resume.Emails = db.MAILADRESSES.Where(q => EmailIds.Contains(q.ID)).ToList(); } return(View(Resume)); }
public ActionResult DeleteConfirmed(long id) { HUMAN hUMAN = db.HUMen.Find(id); db.HUMen.Remove(hUMAN); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ID,NAME,GENDER,USAGE")] HUMAN hUMAN) { if (ModelState.IsValid) { db.Entry(hUMAN).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hUMAN)); }
public ActionResult Create([Bind(Include = "ID,NAME,GENDER,USAGE")] HUMAN hUMAN) { if (ModelState.IsValid) { db.HUMen.Add(hUMAN); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hUMAN)); }
// GET: HUMen/Delete/5 public ActionResult Delete(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HUMAN hUMAN = db.HUMen.Find(id); if (hUMAN == null) { return(HttpNotFound()); } return(View(hUMAN)); }
public long SetHuman(HUMAN human) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { db.Configuration.ProxyCreationEnabled = false; db.HUMen.Add(human); db.SaveChanges(); return(human.ID); } catch { return(0); } } }
public bool UpdateHuman(HUMAN Entity) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { // var Skill = db.SKILLS.FirstOrDefault(q => q.ID == SkillID); db.HUMen.Attach(Entity); var Entry = db.Entry(Entity); Entry.State = EntityState.Modified; db.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }