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