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