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