public IHttpActionResult VadifyGroupMemeber(string MemberId, string Code, string UserId) { Domain.Socioboard.Domain.Groupmembers grpMember = groupMembersRepository.GetGroupMember(Guid.Parse(MemberId)); Domain.Socioboard.Domain.User user = userrepo.getUsersById(Guid.Parse(UserId)); if (grpMember == null) { return(Ok("Member Not Exist")); } if (grpMember != null && user.EmailId == grpMember.Emailid) { if (grpMember.Membercode.Equals(Code)) { grpMember.Status = Domain.Socioboard.Domain.GroupUserStatus.Accepted; grpMember.Userid = user.Id.ToString(); groupMembersRepository.updateBoard(grpMember); return(Ok("added")); } else { return(Ok("Wrong Code")); } } else { return(Ok("Email Doesn't match")); } }
public bool updateBoard(Domain.Socioboard.Domain.Groupmembers grpMember) { bool isUpdate = false; //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { // Proceed action to Update Data. // And Set the reuired paremeters to find the specific values. session.CreateQuery("Update Groupmembers set Emailid=:Emailid,Groupid=:Groupid,IsAdmin=:IsAdmin,Membercode=:Membercode,Status=:Status,Userid=:Userid where Id = :Id") .SetParameter("Emailid", grpMember.Emailid) .SetParameter("Groupid", grpMember.Groupid) .SetParameter("IsAdmin", grpMember.IsAdmin) .SetParameter("Membercode", grpMember.Membercode) .SetParameter("Status", grpMember.Status) .SetParameter("Userid", grpMember.Userid) .SetParameter("Id", grpMember.Id) .ExecuteUpdate(); transaction.Commit(); isUpdate = true; return(isUpdate); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(isUpdate); } } //End Transaction } //End session }
/// <AddGroup> /// Add a new group /// </summary> /// <param name="group">Set Values in a Groups Class Property and Pass the same Object of Groups Class.(Domain.Groups)</param> public void AddGroupMemeber(Domain.Socioboard.Domain.Groupmembers groupMember) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action to save data. session.Save(groupMember); transaction.Commit(); } //End Transaction } //End Session }
public Domain.Socioboard.Domain.Groupmembers GetGroupMember(Guid Id) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { // proceed action, to get all Facebook Account of User by UserId(Guid) and FbUserId(string). NHibernate.IQuery query = session.CreateQuery("from Groupmembers where Id = :Id"); query.SetParameter("Id", Id); Domain.Socioboard.Domain.Groupmembers result = (Domain.Socioboard.Domain.Groupmembers)query.UniqueResult(); return(result); } //End Transaction } //End session }
public bool GrpMem(Domain.Socioboard.Domain.User user) { GroupsRepository grpRep = new GroupsRepository(); GroupMembersRepository grpMemRep = new GroupMembersRepository(); UserRepository userRepo = new UserRepository(); // Domain.Socioboard.Domain.User user = userRepo.getUserInfoByEmail(Email); //foreach (var user in lstUser) //{ try { List <Domain.Socioboard.Domain.Groups> lstGroups = grpRep.getAlluserGroups(user.Id); foreach (var item in lstGroups) { try { if (user != null) { Domain.Socioboard.Domain.Groupmembers grpMember = new Domain.Socioboard.Domain.Groupmembers(); grpMember.Id = Guid.NewGuid(); grpMember.Emailid = user.EmailId; grpMember.Groupid = item.Id.ToString(); grpMember.IsAdmin = true; grpMember.Status = Domain.Socioboard.Domain.GroupUserStatus.Accepted; grpMember.Userid = item.UserId.ToString(); if (!grpMemRep.checkMemberExistsingroup(grpMember.Groupid, grpMember.Userid)) { grpMemRep.AddGroupMemeber(grpMember); } } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } } } catch (Exception e) { } //} return(true); }
public bool GrpMem(Domain.Socioboard.Domain.User user) { GroupsRepository grpRep = new GroupsRepository(); GroupMembersRepository grpMemRep = new GroupMembersRepository(); UserRepository userRepo = new UserRepository(); // Domain.Socioboard.Domain.User user = userRepo.getUserInfoByEmail(Email); //foreach (var user in lstUser) //{ try { List<Domain.Socioboard.Domain.Groups> lstGroups = grpRep.getAlluserGroups(user.Id); foreach (var item in lstGroups) { try { if (user != null) { Domain.Socioboard.Domain.Groupmembers grpMember = new Domain.Socioboard.Domain.Groupmembers(); grpMember.Id = Guid.NewGuid(); grpMember.Emailid = user.EmailId; grpMember.Groupid = item.Id.ToString(); grpMember.IsAdmin = true; grpMember.Status = Domain.Socioboard.Domain.GroupUserStatus.Accepted; grpMember.Userid = item.UserId.ToString(); if (!grpMemRep.checkMemberExistsingroup(grpMember.Groupid, grpMember.Userid)) { grpMemRep.AddGroupMemeber(grpMember); } } } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } } } catch (Exception e) { } //} return true; }
public IHttpActionResult AddGroupMembers(string Emails, string GroupId, string UserId) { Domain.Socioboard.Domain.Groups group = groupRepo.getGroupDetailsbyId(Guid.Parse(UserId), Guid.Parse(GroupId)); string ret = string.Empty; string SentMails = string.Empty; try { List<string> arr = new List<string>(); string[] arr1 = new string[] { }; string NotSentMails = string.Empty; string selectedgroupid = string.Empty; if (Emails.Contains(',')) { arr = Emails.Split(',').ToList(); } else { //arr[0] = email; arr.Add(Emails); } foreach (var item in arr) { if (item.Contains(':')) { arr1 = item.Split(':'); } //string res = ""; Domain.Socioboard.Domain.User objuserinfo = userrepo.getUserInfoByEmail(arr1[0]); if (objuserinfo != null) { string[] name = objuserinfo.UserName.Split(' '); string fname = name[0]; string lname = string.Empty; for (int i = 1; i < name.Length; i++) { lname += name[i]; } // res = ApiobjTeam.AddTeam(objuserinfo.Id.ToString(), "0", fname, lname, arr1[0], "", selectedgroupid, objUser.EmailId, objUser.UserName); Domain.Socioboard.Domain.Groupmembers groupMemeber = new Domain.Socioboard.Domain.Groupmembers(); groupMemeber.Id = Guid.NewGuid(); groupMemeber.Emailid = objuserinfo.EmailId; groupMemeber.Groupid = GroupId; groupMemeber.Status = Domain.Socioboard.Domain.GroupUserStatus.Pending; groupMemeber.Userid = objuserinfo.Id.ToString(); groupMemeber.Membercode = Api.Socioboard.Helper.Utility.GenerateRandomUniqueString(); groupMembersRepository.AddGroupMemeber(groupMemeber); string mailpath = HttpContext.Current.Server.MapPath("~/Layouts/Mails/GroupInvitation.html"); string html = File.ReadAllText(mailpath); html = html.Replace("[group_name]", group.GroupName); html = html.Replace("[join link]", "Home/GroupMember?MemberId=" + groupMemeber.Id + "&code=" + groupMemeber.Membercode); MailSender objMailSender = new MailSender(); ret = objMailSender.SendChangePasswordMail(objuserinfo.EmailId, html, "Group Invitation"); } else { //res = ApiobjTeam.AddTeam(objUser.Id.ToString(), "0", arr1[1], arr1[2], arr1[0], "", selectedgroupid, objUser.EmailId, objUser.UserName); Domain.Socioboard.Domain.Groupmembers groupMemeber = new Domain.Socioboard.Domain.Groupmembers(); groupMemeber.Id = Guid.NewGuid(); groupMemeber.Emailid = arr1[0]; groupMemeber.Groupid = GroupId; groupMemeber.Status = Domain.Socioboard.Domain.GroupUserStatus.Pending; groupMemeber.Membercode = Api.Socioboard.Helper.Utility.GenerateRandomUniqueString(); // groupMemeber.Userid = objuserinfo.Id.ToString(); groupMembersRepository.AddGroupMemeber(groupMemeber); string mailpath = HttpContext.Current.Server.MapPath("~/Layouts/Mails/GroupInvitation.html"); string html = File.ReadAllText(mailpath); html = html.Replace("[group_name]", group.GroupName); html = html.Replace("[join link]", "Home/GroupMember?MemberId=" + groupMemeber.Id + "&code=" + groupMemeber.Membercode); MailSender objMailSender = new MailSender(); ret = objMailSender.SendChangePasswordMail(arr1[0], html, "Group Invitation"); } } SentMails = "{\"SentMails\":" + "\"" + SentMails + "\",\"NotSentMails\":" + "\"" + NotSentMails + "\"}"; return Ok(SentMails); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); return BadRequest(); } }
public IHttpActionResult AddGroupMembers(string Emails, string GroupId, string UserId) { Domain.Socioboard.Domain.Groups group = groupRepo.getGroupDetailsbyId(Guid.Parse(UserId), Guid.Parse(GroupId)); string ret = string.Empty; string SentMails = string.Empty; try { List <string> arr = new List <string>(); string[] arr1 = new string[] { }; string NotSentMails = string.Empty; string selectedgroupid = string.Empty; if (Emails.Contains(',')) { arr = Emails.Split(',').ToList(); } else { //arr[0] = email; arr.Add(Emails); } foreach (var item in arr) { if (item.Contains(':')) { arr1 = item.Split(':'); } //string res = ""; Domain.Socioboard.Domain.User objuserinfo = userrepo.getUserInfoByEmail(arr1[0]); if (objuserinfo != null) { string[] name = objuserinfo.UserName.Split(' '); string fname = name[0]; string lname = string.Empty; for (int i = 1; i < name.Length; i++) { lname += name[i]; } // res = ApiobjTeam.AddTeam(objuserinfo.Id.ToString(), "0", fname, lname, arr1[0], "", selectedgroupid, objUser.EmailId, objUser.UserName); Domain.Socioboard.Domain.Groupmembers groupMemeber = new Domain.Socioboard.Domain.Groupmembers(); groupMemeber.Id = Guid.NewGuid(); groupMemeber.Emailid = objuserinfo.EmailId; groupMemeber.Groupid = GroupId; groupMemeber.Status = Domain.Socioboard.Domain.GroupUserStatus.Pending; groupMemeber.Userid = objuserinfo.Id.ToString(); groupMemeber.Membercode = Api.Socioboard.Helper.Utility.GenerateRandomUniqueString(); groupMembersRepository.AddGroupMemeber(groupMemeber); string mailpath = HttpContext.Current.Server.MapPath("~/Layouts/Mails/GroupInvitation.html"); string html = File.ReadAllText(mailpath); html = html.Replace("[group_name]", group.GroupName); html = html.Replace("[join link]", "Home/GroupMember?MemberId=" + groupMemeber.Id + "&code=" + groupMemeber.Membercode); MailSender objMailSender = new MailSender(); ret = objMailSender.SendChangePasswordMail(objuserinfo.EmailId, html, "Group Invitation"); } else { //res = ApiobjTeam.AddTeam(objUser.Id.ToString(), "0", arr1[1], arr1[2], arr1[0], "", selectedgroupid, objUser.EmailId, objUser.UserName); Domain.Socioboard.Domain.Groupmembers groupMemeber = new Domain.Socioboard.Domain.Groupmembers(); groupMemeber.Id = Guid.NewGuid(); groupMemeber.Emailid = arr1[0]; groupMemeber.Groupid = GroupId; groupMemeber.Status = Domain.Socioboard.Domain.GroupUserStatus.Pending; groupMemeber.Membercode = Api.Socioboard.Helper.Utility.GenerateRandomUniqueString(); // groupMemeber.Userid = objuserinfo.Id.ToString(); groupMembersRepository.AddGroupMemeber(groupMemeber); string mailpath = HttpContext.Current.Server.MapPath("~/Layouts/Mails/GroupInvitation.html"); string html = File.ReadAllText(mailpath); html = html.Replace("[group_name]", group.GroupName); html = html.Replace("[join link]", "Home/GroupMember?MemberId=" + groupMemeber.Id + "&code=" + groupMemeber.Membercode); MailSender objMailSender = new MailSender(); ret = objMailSender.SendChangePasswordMail(arr1[0], html, "Group Invitation"); } } SentMails = "{\"SentMails\":" + "\"" + SentMails + "\",\"NotSentMails\":" + "\"" + NotSentMails + "\"}"; return(Ok(SentMails)); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); return(BadRequest()); } }