public long SetImage(long HumanID, ImageForTransfer Image)//IMAGE image)//long HumanID , byte[] Image) { try { using (KARYABDBEntities db = new KARYABDBEntities()) { var _Image = db.IMAGES.Where(q => q.HUMANID == HumanID).FirstOrDefault(); if (_Image != null) { _Image.IMAGE1 = Convert.FromBase64String(Image.Bitmap); db.SaveChanges(); return(_Image.ID); } else { IMAGE image = new IMAGE(); image.HUMANID = HumanID; image.IMAGE1 = Convert.FromBase64String(Image.Bitmap); db.IMAGES.Add(image); db.SaveChanges(); return(image.ID); } } } catch (Exception e) { return(0); } }
public bool DeleteSkill(SKILL Entity) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { db.Configuration.ProxyCreationEnabled = false; //var employer = new Employ { Id = 1 }; //ctx.Employ.Attach(employer); //ctx.Employ.Remove(employer); //ctx.SaveChanges(); SKILL entity = db.SKILLS.FirstOrDefault(q => q.ID == Entity.ID); OWNERSSKILL Owner = db.OWNERSSKILLS.FirstOrDefault(q => q.SKILLID == Entity.ID); db.OWNERSSKILLS.Attach(Owner); db.OWNERSSKILLS.Remove(Owner); db.SaveChanges(); db.SKILLS.Attach(entity); db.SKILLS.Remove(entity); db.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
public long SetEducation(EDUCATON Education, long HumanID) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { //long HumanID = 60111; //EDUCATON Education = new EDUCATON(); //Education.EDUCATIONBRANCH = "asd"; //Education.EDUCATIONDIPLOMA = "asd"; //Education.EDUCATIONDURATION = 12; //Education.EDUCATIONLOCATION = "asd"; //Education.FINALGRADE = 12; db.Configuration.ProxyCreationEnabled = false; db.EDUCATONS.Add(Education); db.SaveChanges(); OWNERSEDUCATION owenersEducation = new OWNERSEDUCATION(); owenersEducation.EDUCATIONID = Education.ID; owenersEducation.EDUCATIONOWNERID = HumanID; db.OWNERSEDUCATIONS.Add(owenersEducation); db.SaveChanges(); return(Education.ID); } catch { return(0); } } }
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)); }
public long SetEmail(MAILADRESS Adress, long HumanID) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { db.Configuration.ProxyCreationEnabled = false; db.MAILADRESSES.Add(Adress); db.SaveChanges(); OWNERSMAIL owenersAdress = new OWNERSMAIL(); owenersAdress.MAILADRESSID = Adress.ID; owenersAdress.MAILOWNERID = HumanID; db.OWNERSMAILS.Add(owenersAdress); db.SaveChanges(); return(Adress.ID); } catch { return(0); } } }
public long SetCellPhone(CELLPHONE CellPhone, long HumanID) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { db.Configuration.ProxyCreationEnabled = false; db.CELLPHONES.Add(CellPhone); db.SaveChanges(); OWNERSCELLPHONE owenersCellPhone = new OWNERSCELLPHONE(); owenersCellPhone.CELLPHONEID = CellPhone.ID; owenersCellPhone.CELLPHONEOWNERID = HumanID; db.OWNERSCELLPHONES.Add(owenersCellPhone); db.SaveChanges(); return(CellPhone.ID); } catch { return(0); } } }
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 long SetSkill(SKILL Skill, long HumanID) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { db.Configuration.ProxyCreationEnabled = false; db.SKILLS.Add(Skill); db.SaveChanges(); OWNERSSKILL owenersSkill = new OWNERSSKILL(); owenersSkill.SKILLID = Skill.ID; owenersSkill.SKILLOWNERID = HumanID; db.OWNERSSKILLS.Add(owenersSkill); db.SaveChanges(); return(Skill.ID); } catch { return(0); } } }
public long SetPhone(PHONE Phone, long HumanID) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { db.Configuration.ProxyCreationEnabled = false; db.PHONES.Add(Phone); db.SaveChanges(); OWNERSPHO owenersPhone = new OWNERSPHO(); owenersPhone.PHONENUMBERID = Phone.ID; owenersPhone.PHONEOWNERID = HumanID; db.OWNERSPHOES.Add(owenersPhone); db.SaveChanges(); return(Phone.ID); } catch { return(0); } } }
public bool DeleteEmail(MAILADRESS Entity) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { db.Configuration.ProxyCreationEnabled = false; MAILADRESS entity = db.MAILADRESSES.FirstOrDefault(q => q.ID == Entity.ID); OWNERSMAIL Owner = db.OWNERSMAILS.FirstOrDefault(q => q.MAILADRESSID == Entity.ID); db.OWNERSMAILS.Attach(Owner); db.OWNERSMAILS.Remove(Owner); db.SaveChanges(); db.MAILADRESSES.Attach(entity); db.MAILADRESSES.Remove(entity); db.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
public bool DeleteCellPhone(CELLPHONE Entity) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { db.Configuration.ProxyCreationEnabled = false; CELLPHONE entity = db.CELLPHONES.FirstOrDefault(q => q.ID == Entity.ID); OWNERSCELLPHONE Owner = db.OWNERSCELLPHONES.FirstOrDefault(q => q.CELLPHONEID == Entity.ID); db.OWNERSCELLPHONES.Attach(Owner); db.OWNERSCELLPHONES.Remove(Owner); db.SaveChanges(); db.CELLPHONES.Attach(entity); db.CELLPHONES.Remove(entity); db.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
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); } } }
public bool DeleteEducation(EDUCATON Entity) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { db.Configuration.ProxyCreationEnabled = false; EDUCATON entity = db.EDUCATONS.FirstOrDefault(q => q.ID == Entity.ID); OWNERSEDUCATION Owner = db.OWNERSEDUCATIONS.FirstOrDefault(q => q.EDUCATIONID == Entity.ID); db.OWNERSEDUCATIONS.Attach(Owner); db.OWNERSEDUCATIONS.Remove(Owner); db.SaveChanges(); db.EDUCATONS.Attach(entity); db.EDUCATONS.Remove(entity); db.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
public long SetPassword(PASSWORD Password)//long HumanID ,string password,string confirmPassword,string email ,string answer) { //PASSWORD Password = new PASSWORD(); //Password.ANSWER = answer; //Password.CONFIRMPASSWORD = confirmPassword; //Password.PASSWORD1 = password; //Password.EMAIL = email; //Password.HUMANID = HumanID; try { using (KARYABDBEntities db = new KARYABDBEntities()) { if (Password.PASSWORD1.Equals(Password.CONFIRMPASSWORD) && Password.ANSWER != null && Password.EMAIL != null && Password.HUMANID != null) { var EmailExist = db.PASSWORDS.Where(q => q.EMAIL == Password.EMAIL).ToList(); if (EmailExist.Any()) { if (EmailExist.Any(q => q.ANSWER == Password.ANSWER)) { return(-2); } else { return(-1); } } else { db.PASSWORDS.Add(Password); db.SaveChanges(); return(Password.ID); } } else { return(0); } } } catch (Exception e) { return(0); } }
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 UpdateEmail(MAILADRESS Entity) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { // var Skill = db.SKILLS.FirstOrDefault(q => q.ID == SkillID); db.MAILADRESSES.Attach(Entity); var Entry = db.Entry(Entity); Entry.State = EntityState.Modified; db.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }