public static void InsertNewSkill(String name, String description, int level, Guid userId)
{
bindedinEntities bie = SingletonEntities.Instance;
var existing = from c in bie.competences
where c.description.Equals(description)
where c.name.Equals(name)
select c;
if (existing.Count() == 0)
{
competence comp = new competence
{
name = name,
description = description
};
bie.competences.AddObject(comp);
bie.SaveChanges();
}
var idComp = from c in bie.competences
where c.name.Equals(name)
where c.description.Equals(description)
select c.id;
user_competence uc = new user_competence
{
user = userId,
competence = idComp.First(),
level = level,
};
bie.user_competence.AddObject(uc);
bie.SaveChanges();
}
public static int InsertCompany(String name, String adresse, String tel)
{
bindedinEntities bie = SingletonEntities.Instance;
var existingCompany = from s in bie.companies
where s.nom.Equals(name)
where s.adresse.Equals(adresse)
where s.telephone.Equals(tel)
select s;
if (existingCompany.Count() == 0)
{
company sc = new company
{
nom = name,
adresse = adresse,
telephone = tel,
};
bie.companies.AddObject(sc);
bie.SaveChanges();
}
var id = from s in bie.companies
where s.nom.Equals(name)
where s.adresse.Equals(adresse)
where s.telephone.Equals(tel)
select s.id;
return(id.First());
}
//efface le message correspondant à l'id passé en parametre
//mode=1 ->reception
//mode=2 ->envoie
public static void deleteMessage(int messageId, int mode)
{
bindedinEntities bie = SingletonEntities.Instance;
//on recupere le messge à effacer
var deleteMessages = from m in bie.messages where m.id.Equals(messageId) select m;
if (mode == 1)
{
foreach (var me in deleteMessages)
{
me.isRemovedRecipient = 1;
}
}
else
{
foreach (var me in deleteMessages)
{
me.isRemovedSender = 1;
}
}
try
{
//on sauvergarde les modifs
bie.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static int InsertSchool(String name, String description)
{
bindedinEntities bie = SingletonEntities.Instance;
var existingSchool = from s in bie.schools
where s.name.Equals(name)
where s.description.Equals(description)
select s;
if (existingSchool.Count() == 0)
{
school sc = new school
{
name = name,
description = description
};
bie.AddToschools(sc);
bie.SaveChanges();
}
var id = from s in bie.schools
where s.name.Equals(name)
where s.description.Equals(description)
select s.id;
return(id.First());
}
public static void InsertNewProfessionalExp(String name, String description, String dateDebut, String dateFin,
String companyName, String companyAdresse, String companyTel, Guid userId)
{
bindedinEntities bie = SingletonEntities.Instance;
var existingProfExp = from pe in bie.professional_experience
from c in bie.companies
where pe.name.Equals(name)
where pe.company.Equals(c.id)
where c.nom.Equals(companyName)
select pe;
if (existingProfExp.Count() == 0)
{
professional_experience profExp = new professional_experience
{
name = name,
description = description,
company = Business.CompanyService.InsertCompany(companyName, companyAdresse, companyTel)
};
bie.professional_experience.AddObject(profExp);
bie.SaveChanges();
}
var idExpPro = from pe in bie.professional_experience from c in bie.companies
where pe.name.Equals(name)
where pe.company.Equals(c.id)
where c.nom.Equals(companyName)
select pe.id;
user_experienceprofessional uf = new user_experienceprofessional
{
user = userId,
experience_professional = idExpPro.First(),
beginning_date = DateTime.Parse(dateDebut, CultureInfo.CreateSpecificCulture("en-US")),
end_date = DateTime.Parse(dateFin, CultureInfo.CreateSpecificCulture("en-US")),
};
bie.user_experienceprofessional.AddObject(uf);
bie.SaveChanges();
}
//passe un message à "lu"
public static void ReadMessage(int idMessage)
{
bindedinEntities bie = SingletonEntities.Instance;
message m = GetMessageById(idMessage);
if (m != null)
{
//modele pas encore mise a jour
m.isRead = 1;
bie.SaveChanges();
}
}
public static void InsertNewFormation(String nom,
String description, String dateDebut, String dateFin, String etablissement, Guid userId)
{
bindedinEntities bie = SingletonEntities.Instance;
var existingFormation = from f in bie.formations from s in bie.schools
where f.name.Equals(nom)
where f.school.Equals(s.id)
where s.name.Equals(etablissement)
select f;
if (existingFormation.Count() == 0)
{
formation ord = new formation
{
name = nom,
description = description,
school = Business.SchoolsService.InsertSchool(etablissement, ""),
};
bie.formations.AddObject(ord);
bie.SaveChanges();
}
var idFormation = from f in bie.formations
where f.name.Equals(nom)
where f.description.Equals(description)
select f.id;
user_formation uf = new user_formation
{
user = userId,
formation = idFormation.First(),
beginning_date = DateTime.Parse(dateDebut, CultureInfo.CreateSpecificCulture("en-US")),
end_date = DateTime.Parse(dateFin, CultureInfo.CreateSpecificCulture("en-US")),
};
bie.user_formation.AddObject(uf);
bie.SaveChanges();
}
public static void deleteImage(int idImg, Guid userId)
{
bindedinEntities bie = SingletonEntities.Instance;
var retour = from i in bie.Images
where i.id.Equals(idImg) &&
i.UserId.Equals(userId)
select i;
foreach (Image img in retour)
{
bie.Images.DeleteObject(img);
}
bie.SaveChanges();
}
//envoit une recommandations
public static void SendRecommandation(Guid sender, Guid recipient, string me)
{
bindedinEntities bie = SingletonEntities.Instance;
//on creait une nouvelle recommandation
recommandation r = new recommandation();
r.sender = sender;
r.recipient = recipient;
r.message = me;
//on sauvegarde le message dans la base
bie.recommandations.AddObject(r);
bie.SaveChanges();
}
public static void Remove(string p, Guid userid)
{
bindedinEntities bie = SingletonEntities.Instance;
int id = Int32.Parse(p);
var retour = from i in bie.user_competence
where i.competence.Equals(id) &&
i.user.Equals(userid)
select i;
foreach (user_competence exp in retour)
{
bie.user_competence.DeleteObject(exp);
}
bie.SaveChanges();
}
public static int addNewImage(Guid userId, Byte[] image)
{
bindedinEntities bie = SingletonEntities.Instance;
Image newImg = new Image
{
UserId = userId,
Image1 = image,
Date = DateTime.Now,
};
bie.AddToImages(newImg);
bie.SaveChanges();
setImageAsCurrent(newImg.id, userId);
return(newImg.id);
}
public static Boolean deleteRelation(Guid user1, Guid user2)
{
bindedinEntities bie = SingletonEntities.Instance;
bie.Refresh(System.Data.Objects.RefreshMode.StoreWins, bie.relation_status);
var relation = from r in bie.relation_status
where (r.asked_user == user1 && r.asking_user == user2) ||
(r.asked_user == user2 && r.asking_user == user1)
select r;
relation_status relationTrouve = relation.First();
relationTrouve.status = 4;
bie.SaveChanges();
return(true);
}
public static Boolean updateRelation(Guid askedUser, Guid askingUser)
{
bindedinEntities bie = SingletonEntities.Instance;
bie.Refresh(System.Data.Objects.RefreshMode.StoreWins, bie.relation_status);
var relation = from r in bie.relation_status
where r.asking_user == askingUser
where r.asked_user == askedUser
select r;
relation_status relationTrouve = relation.First();
relationTrouve.status = 3;
bie.SaveChanges();
return(true);
}
//envoit un message
public static void SendMessage(Guid sender, Guid recipient, string obj, string me)
{
bindedinEntities bie = SingletonEntities.Instance;
//on creait un nouveau message
message m = new message();
m.sender = sender;
m.recipient = recipient;
m.@object = obj;
m.message1 = me;
m.isRead = 0;
m.isRemovedSender = 0;
m.isRemovedRecipient = 0;
m.date = DateTime.Now;
//on sauvegarde le message dans la base
bie.messages.AddObject(m);
bie.SaveChanges();
}
public static Boolean SendInvitation(String asking_userName, String asked_username, String message)
{
UserProfile loggedInProfile = UserProfile.GetUserProfile(asking_userName);
String obj = String.Format("{0} {1} veut vous inviter dans son réseau !", loggedInProfile.FirstName, loggedInProfile.LastName);
String messageToSend = message;
messageToSend += "\n";
Uri uri = HttpContext.Current.Request.Url;
String host = uri.Scheme + Uri.SchemeDelimiter + uri.Host + ":" + uri.Port;
String linkForInvitation = host + String.Format("/AcceptedInvitation.aspx?id_asking={0}&id_asked={1}", (Guid)(Membership.GetUser(asking_userName, false).ProviderUserKey), (Guid)(Membership.GetUser(asked_username, false).ProviderUserKey));
messageToSend += "<br />Voici le lien pour accepter cette invitation : <br /> <a href=\"" + linkForInvitation + " \" class=\"btn\">Accepter la demande</a>";
messageToSend += "\n";
messageToSend += "<br />Sinon ignorez tout simplement ce message";
messageToSend += "<br />Cordialement,";
messageToSend += "<br />Votre équipe BindedIn";
Business.MessageService.SendMessage((Guid)(Membership.GetUser(asking_userName, false).ProviderUserKey), (Guid)(Membership.GetUser(asked_username, false).ProviderUserKey), obj, messageToSend);
bindedinEntities bie = SingletonEntities.Instance;
relation_status newRelation = new relation_status();
newRelation.status = 1;
newRelation.asked_date = DateTime.Now;
newRelation.asked_user = (Guid)(Membership.GetUser(asked_username, false).ProviderUserKey);
newRelation.asking_user = (Guid)(Membership.GetUser(asking_userName, false).ProviderUserKey);
bie.relation_status.AddObject(newRelation);
bie.SaveChanges();
return(true);
}