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