public IEnumerable <LibMember> GetMembers()
{
try
{
String commandText = ProjectConstants.MemberGetMembers;
Dictionary <string, object> parameters = new Dictionary <string, object>();
List <Dictionary <string, string> > members = database.Query(commandText, parameters);
List <LibMember> Memberdetails = new List <LibMember>();
foreach (var member in members)
{
LibMember libmember = new LibMember();
libmember.MemberID = Convert.ToInt32(member["Member_ID"]);
libmember.Firstname = member["First_Name"];
libmember.Lastname = member["Last_Name"];
libmember.Email = member["Email_id"];
libmember.Phone = member["Phone_no"];
libmember.Address = member["Address"];
libmember.Dob = member["DOB"];
Memberdetails.Add(libmember);
}
return(Memberdetails);
}
catch (Exception)
{
throw;
}
}
public LibMember GetMemberById(string memberid)
{
try
{
string commandText = ProjectConstants.MemberGetMemberById;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@memberid", memberid);
var member = database.Query(commandText, parameters).FirstOrDefault();
if (member == null)
{
return(null);
}
LibMember libmember = new LibMember();
libmember.MemberID = Convert.ToInt32(member["Member_ID"]);
libmember.Firstname = member["First_Name"];
libmember.Lastname = member["Last_Name"];
libmember.Email = member["Email_id"];
libmember.Phone = member["Phone_no"];
libmember.Address = member["Address"];
libmember.Dob = member["DOB"];
return(libmember);
}
catch (Exception)
{
throw;
}
}
//DateTime dateoutput;
public Boolean ValidateMember(LibMember member)
{
MemberTable membertable = new MemberTable(new MySQLDatabase());
IEnumerable <LibMember> Listofmembers = membertable.GetMembers();
// for validating email members
foreach (var singlemember in Listofmembers)
{
if (singlemember.Email == member.Email)
{
return(false);
}
}
// for validating the first name
if (member.Firstname.Any(char.IsDigit) || member.Firstname.Any(char.IsSymbol) || string.IsNullOrEmpty(member.Firstname))
{
return(false);
}
// to check whether the Last name
if (member.Lastname.Any(char.IsDigit) || member.Lastname.Any(char.IsSymbol) || string.IsNullOrEmpty(member.Lastname))
{
return(false);
}
// to validate the email address
var emailaddress = new System.Net.Mail.MailAddress(member.Email);
if (!emailaddress.Equals(member.Email) && String.IsNullOrEmpty(member.Email))
{
return(false);
}
// to validate Phone address
if (member.Phone == null)
{
return(false);
}
if (String.IsNullOrEmpty(member.Address))
{
return(false);
}
//parsing Date format and validating
if (!DateTime.TryParse(member.Dob, out DateTime dateoutput))
{
return(false);
}
return(true);
}
public ActionResult Edit(string id)
{
// Get the Specific Book by Id
MemberTable memberTable = new MemberTable(db);
LibMember EditMember = memberTable.GetMemberById(id);
return(View(EditMember));
}
public ActionResult EditMember(LibMember member)
{
// Get the Specific Book by Id
MemberTable memberTable = new MemberTable(db);
memberTable.Update(member);
return(RedirectToActionPermanent(ProjectConstants.ListMember));
}
public void GetMemberbyId_ExpectedException()
{
Mock <IDatabase> mock = new Mock <IDatabase>();
MemberTable membertable = new MemberTable(mock.Object);
Dictionary <string, string> parameter = new Dictionary <string, string>();
List <Dictionary <string, string> > result = new List <Dictionary <string, string> >();
parameter.Add("test", "case");
result.Add(parameter);
mock.Setup(x => x.Query(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(result);
LibMember member = new LibMember();
Assert.IsInstanceOfType(membertable.GetMemberById("1"), typeof(LibMember));
}
public int Update(LibMember member)
{
string commandText = ProjectConstants.MemberUpdate;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@memberid", member.MemberID);
parameters.Add("@firstname", member.Firstname);
parameters.Add("@lastname", member.Lastname);
parameters.Add("@emailid", member.Email);
parameters.Add("@phoneno", member.Phone);
parameters.Add("@address", member.Address);
parameters.Add("@dob", member.Dob);
return(database.Execute(commandText, parameters));
}
public void Update()
{
Mock <IDatabase> mock = new Mock <IDatabase>();
mock.Setup(x => x.Execute(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(1);
MemberTable membertable = new MemberTable(mock.Object);
LibMember member = new LibMember();
member.SetFirstname("Renu");
member.SetLastname("Damodaran");
member.SetEmail("*****@*****.**");
member.SetPhone("9024012836");
member.SetAddress("1144 Quingate Street");
member.SetDob("20-05-1992");
int result = membertable.Update(member);
Assert.AreEqual(1, result);
}
public void GetUsersbyId_Valid()
{
Mock <IDatabase> mock = new Mock <IDatabase>();
UserTable usertable = new UserTable(mock.Object);
Dictionary <string, string> parameter = new Dictionary <string, string>();
List <Dictionary <string, string> > result = new List <Dictionary <string, string> >();
parameter.Add("ID", "10");
parameter.Add("First_Name", "new");
parameter.Add("Last_Name", "new");
parameter.Add("Email_id", "new");
parameter.Add("Password", "new");
parameter.Add("Is_admin", "false");
result.Add(parameter);
mock.Setup(x => x.Query(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(result);
LibMember member = new LibMember();
Assert.IsInstanceOfType(usertable.GetUsersById("1"), typeof(UserAccount));
}
public ActionResult Issue(BookTransactionViewModel transactionViewModel)
{
try
{
if (transactionViewModel == null)
{
throw new ArgumentException(ProjectConstants.InvalidTransactionMsg);
}
MemberTable memberTable = new MemberTable(db);
LibMember member = memberTable.GetMemberById(Convert.ToString(transactionViewModel.MemberID));
if (member == null)
{
ModelState.AddModelError(string.Empty, ProjectConstants.MemberIdNotExistMsg);
return(View(transactionViewModel));
}
BookTable bookTable = new BookTable(db);
Book book = bookTable.GetBookById(Convert.ToString(transactionViewModel.BookID));
BookTranscationTable bookTranscationTable = new BookTranscationTable(db);
BookTranscation bookTranscation = new BookTranscation()
{
BookID = transactionViewModel.BookID, BookStatus = transactionViewModel.BookStatus, MemberID = transactionViewModel.MemberID,
DateofIssue = transactionViewModel.DateofIssue, DueDate = transactionViewModel.DueDate
};
bookTranscationTable.Insert(bookTranscation);
int existingBookTransactionCount = bookTranscationTable.GetBookTransactionCountByBookId(bookTranscation.BookID);
if (existingBookTransactionCount >= book.Count)
{
// update the book status as Not Available
book.Status = BookStatus.NotAvailable.ToString();
bookTable.Update(book);
}
}
catch (Exception)
{
throw;
}
return(RedirectToAction(ProjectConstants.ListBookTranscation));
}
public void GetMemberbyId_Valid()
{
Mock <IDatabase> mock = new Mock <IDatabase>();
MemberTable membertable = new MemberTable(mock.Object);
Dictionary <string, string> parameter = new Dictionary <string, string>();
List <Dictionary <string, string> > result = new List <Dictionary <string, string> >();
parameter.Add("Member_ID", "90");
parameter.Add("First_Name", "case");
parameter.Add("Last_Name", "case");
parameter.Add("Email_id", "case");
parameter.Add("Phone_no", "case");
parameter.Add("Address", "case");
parameter.Add("DOB", "case");
result.Add(parameter);
mock.Setup(x => x.Query(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(result);
LibMember member = new LibMember();
Assert.IsInstanceOfType(membertable.GetMemberById("1"), typeof(LibMember));
}
public void InValid_DeleteMember()
{
Mock <IDatabase> mock = new Mock <IDatabase>();
mock.Setup(x => x.Execute(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(1);
MemberController membercontroller = new MemberController(mock.Object);
LibMember lib = new LibMember();
//var mock = new Mock<LibMember>();
//member.AddMember(mock.Object);
lib.SetFirstname("Anitt");
lib.SetLastname("123");
lib.SetEmail("*****@*****.**");
lib.SetPhone("123456");
lib.SetDob("08-08-1993");
lib.SetAddress("");
var result = membercontroller.DeleteMember("-1") as RedirectToRouteResult;
Assert.IsNotNull(result);
}
public void AddMemberTest_InValidEmail()
{
Mock <IDatabase> mock = new Mock <IDatabase>();
mock.Setup(x => x.Execute(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(1);
MemberController membercontroller = new MemberController(mock.Object);
MemberController member = new MemberController();
LibMember lib = new LibMember();
//var mock = new Mock<LibMember>();
//member.AddMember(mock.Object);
lib.SetFirstname("Priyanka");
lib.SetLastname("123");
lib.SetEmail("");
lib.SetPhone("123456");
lib.SetDob("08-08-1993");
lib.SetAddress("145 Edward Street");
var result = member.AddMember(lib) as ViewResult;
Assert.AreEqual("AddMember", result.ViewName);
}
public ActionResult AddMember(LibMember newmember)
{
if (ModelState.IsValid)
{
//MemberValidation membervalidation = new MemberValidation();
AbstractFactory abstractfactory = FactoryProducer.GetFactory("IMemberValidation");
IMemberValidation membervalidation = abstractfactory.getmembervalidation("MemberValidation");
if (membervalidation.ValidateMember(newmember))
{
MemberTable memberTable = new MemberTable(db);
memberTable.Insert(newmember);
ModelState.Clear();
ViewBag.Message = newmember.Firstname + ProjectConstants.SuccessMsg;
}
else
{
ViewBag.Message1 = ProjectConstants.MemberExistingMsg;
}
}
return(View(ProjectConstants.AddMember));
}
public int Delete(LibMember member)
{
return(DeleteById(member.MemberID.ToString()));
}
