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