// update public bool UpdateMemberRole(int id, MemberRoleModel memberRole) { using (AttenderEntities ef = new AttenderEntities()) { MemberRole updateMemberRole = ef.MemberRoles.FirstOrDefault(a => a.Id == id); if (updateMemberRole == null) { return(false); } //updateMemberRole.Id = memberRole.Id; updateMemberRole.MemberId = memberRole.MemberId; updateMemberRole.UniversityId = memberRole.UniversityId; updateMemberRole.Role = memberRole.Role; try { ef.Database.ExecuteSqlCommand($"UPDATE [dbo].[MemberRole] SET [MemberId] = {updateMemberRole.MemberId},[UniversityId] = {updateMemberRole.UniversityId},[Role] = { updateMemberRole.Role} WHERE [Id] = {id}"); //ef.SaveChanges(); } catch { return(false); } } return(true); }
// Sending Mail by passportId public void SendMailsByPassportId(string passportId) { System.Net.Mail.MailMessage mailMessage = new System.Net.Mail.MailMessage(); using (AttenderEntities ef = new AttenderEntities()) { Member member = ef.Members.FirstOrDefault(a => a.PassportNumber == passportId); if (member != null) { MemberRole role = ef.MemberRoles.FirstOrDefault(a => a.MemberId == member.Id); if (role != null) { memberRole = new MemberRoleModel() { Id = role.Id, MemberId = role.MemberId, UniversityId = role.UniversityId, Role = role.Role }; } if (role.Role == "s") { Random rnd = new Random(); int num = rnd.Next(); string res = num.ToString(); string hashedData = ComputeSha256Hash(res); // updating password in the database with hashed password UpdatePassword(member.Id, member, hashedData); mailMessage.To.Add(member.Mail); mailMessage.Subject = "Attender Registration"; mailMessage.Body = "Dear " + member.FirstName + " " + member.LastName + "," + Environment.NewLine + "Please follow the instructions and enter your credentials in the website bellow:" + Environment.NewLine + "Your disposable password is: " + res + Environment.NewLine + "http://*****:*****@gmail.com", "Attender App"); mailMessage.Attachments.Add(new System.Net.Mail.Attachment("C:\\Users\\barpi\\Desktop\\Attender\\Instrutions Finding Mac address.pdf")); SmtpClient stmpMail = new SmtpClient(); stmpMail.Host = "smtp.gmail.com"; stmpMail.Credentials = new NetworkCredential("*****@*****.**", "Attender"); stmpMail.EnableSsl = true; stmpMail.Port = 587; try { stmpMail.Send(mailMessage); } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); } } } } }
public IHttpActionResult Get([FromUri] int id) { MemberRoleModel memberRole = memberRoleBll.GetMemberRoleById(id); if (memberRole != null) { return(Ok(memberRole)); } return(NotFound()); }
public IHttpActionResult Put([FromUri] int id, [FromBody] MemberRoleModel value) { if (ModelState.IsValid) { bool succsess = memberRoleBll.UpdateMemberRole(id, value); if (succsess) { return(Ok()); } } return(BadRequest()); }
public IHttpActionResult post([FromBody] MemberRoleModel value) { if (ModelState.IsValid) { bool succsess = memberRoleBll.AddMemberRole(value); if (succsess) { return(Ok("OK")); } return(BadRequest()); } else { return(BadRequest(ModelState)); } }
public MemberRoleModel GetMemberRoleById(int id) { MemberRoleModel memberRole = null; using (AttenderEntities ef = new AttenderEntities()) { MemberRole item = ef.MemberRoles.FirstOrDefault(a => a.Id == id); if (item != null) { memberRole = new MemberRoleModel() { Id = item.Id, MemberId = item.MemberId, UniversityId = item.UniversityId, Role = item.Role }; } } return(memberRole); }
/// <summary> /// To the domain object for member role. /// </summary> /// <param name="roleContracts">member role contracts.</param> /// <returns></returns> public static List <MemberRoleModel> ToDomainObject(this MemberRoleContract[] roleContracts) { var toReturn = new List <MemberRoleModel>() { }; if (roleContracts != null) { foreach (var item in roleContracts) { var model = new MemberRoleModel() { }; model.RoleId = item.RefMemberRole.RefMemberRoleID.ToString(); model.RoleName = item.RefMemberRole.RoleName; model.RoleDescription = item.RefMemberRole.RoleDescription; model.IsMemberRoleActive = item.IsMemberRoleActive; toReturn.Add(model); } } return(toReturn); }
// Checking validation of Mail & password public string CheckValidation(string Email, string Password) { using (AttenderEntities ef = new AttenderEntities()) { Member item = ef.Members.FirstOrDefault(a => a.Mail == Email && a.Password == Password); if (item != null) { member = new MemberModel() { Id = item.Id, PassportNumber = item.PassportNumber, FirstName = item.FirstName, LastName = item.LastName, Password = item.Password, PhoneNumber = item.PhoneNumber, MacAddress = item.MacAddress, Mail = item.Mail }; } if (item != null) { MemberRole item1 = ef.MemberRoles.FirstOrDefault(a => a.MemberId == member.Id); if (item1 != null) { memberRole = new MemberRoleModel() { Id = item1.Id, MemberId = item1.MemberId, UniversityId = item1.UniversityId, Role = item1.Role }; } return(memberRole.Role); } } return(null); }
// Create; public bool AddMemberRole(MemberRoleModel newMemberRole) { using (AttenderEntities ef = new AttenderEntities()) { MemberRole memberRole = new MemberRole() { //Id = newMemberRole.Id, MemberId = newMemberRole.MemberId, UniversityId = newMemberRole.UniversityId, Role = newMemberRole.Role }; //ef.MemberRoles.Add(memberRole); try { ef.Database.ExecuteSqlCommand($"INSERT INTO [dbo].[MemberRole] ([MemberId],[UniversityId],[Role]) VALUES ({memberRole.MemberId} , {memberRole.UniversityId} , '{memberRole.Role}')"); //ef.SaveChanges(); } catch (Exception ex) { return(false); } } return(true); }