public void GetByCPFTest() { var item = RegisterRepositoryTest.itens[1]; var fromDb = new RegisterRepository().GetByCPF(item.CPF); Assert.IsNotNull(fromDb); Assert.AreNotSame(item, fromDb); Assert.AreEqual(item.Tipo, fromDb.Tipo); Assert.AreEqual(item.Nome, fromDb.Nome); Assert.AreEqual(item.CPF, fromDb.CPF); Assert.AreEqual(item.RG, fromDb.RG); Assert.AreEqual(item.Telefone, fromDb.Telefone); Assert.AreEqual(item.Celular, fromDb.Celular); Assert.AreEqual(item.Tipo, fromDb.Tipo); Assert.AreEqual(item.Nome, fromDb.Nome); Assert.AreEqual(item.RazaoSocial, fromDb.RazaoSocial); Assert.AreEqual(item.Contato, fromDb.Contato); Assert.AreEqual(item.CPF, fromDb.CPF); Assert.AreEqual(item.RG, fromDb.RG); Assert.IsNotNull(fromDb.CorrespCep); Assert.AreEqual(item.CorrespCep.Id, fromDb.CorrespCep.Id); Assert.AreEqual(item.CorrespNumero, fromDb.CorrespNumero); Assert.AreEqual(item.CorrespComplemento, fromDb.CorrespComplemento); Assert.AreEqual(item.Telefone, fromDb.Telefone); Assert.AreEqual(item.Celular, fromDb.Celular); Assert.AreEqual(item.Fax, fromDb.Fax); Assert.AreEqual(item.EMail, fromDb.EMail); Assert.AreEqual(item.DataNascimento, fromDb.DataNascimento); Assert.AreEqual(item.DataInclusao, fromDb.DataInclusao); Assert.AreEqual(item.DataAlteracao, fromDb.DataAlteracao); }
public void SetUpOrganisationTests() { var databaseConnection = new SqlConnection(_databaseService.WebConfiguration.SqlConnectionString); var unitOfWork = new UnitOfWork(databaseConnection); _repository = new RegisterRepository(unitOfWork, new Mock <ILogger <RegisterRepository> >().Object); _validationRepository = new RegisterValidationRepository(unitOfWork); _organisationIdCreated = "EPA0987"; _ukprnCreated = 123321; _org2IdCreated = "EPA0001"; _organisationTypeId = 5; OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel { Id = _organisationTypeId, Status = "new", Type = "organisation type 1" }); _id = Guid.NewGuid(); _organisation = new OrganisationModel { Id = _id, CreatedAt = DateTime.Now, EndPointAssessorName = "name 2", EndPointAssessorOrganisationId = _organisationIdCreated, EndPointAssessorUkprn = _ukprnCreated, PrimaryContact = null, OrganisationTypeId = _organisationTypeId, OrganisationData = null, Status = OrganisationStatus.New }; _organisation2 = new OrganisationModel { Id = Guid.NewGuid(), CreatedAt = DateTime.Now, EndPointAssessorName = "name 1", EndPointAssessorOrganisationId = _org2IdCreated, OrganisationTypeId = null, Status = OrganisationStatus.New }; _username = "******"; OrganisationHandler.InsertRecord(_organisation); OrganisationHandler.InsertRecord(_organisation2); _contactId = Guid.NewGuid(); _contact = new EpaContact { Id = _contactId, EndPointAssessorOrganisationId = _organisationIdCreated, Username = _username, DisplayName = "Joe Cool", Email = "*****@*****.**", PhoneNumber = "555 55555", Status = OrganisationStatus.New, SigninType = "", FirstName = "zzz", LastName = "Ftagn" }; }
public List <RegisterModel> GetAllPatients() { using (var deprepo = new RegisterRepository()) { return(deprepo.GetAll().Where(x => x.Role == "Staff").Select(x => new RegisterModel() { Email = x.Email, FullName = x.FullName, Surname = x.Surname, Title = x.Title, MaritalStatus = x.MaritalStatus, DOB = x.DOB, Age = x.Age, Sex = x.Sex, Address1 = x.Address1, Address2 = x.Address2, Address3 = x.Address3, PostalCode = x.PostalCode, Telephone = x.Telephone, Employer = x.Employer, EmployerTelephone = x.EmployerTelephone, Occupation = x.Occupation, NationalId = x.NationalId, Status = x.Status, MedicalAidName = x.MedicalAidName, MedicalAidNo = x.MedicalAidNo }).ToList()); } }
public ActionResult Employees() { var list = new List <UserViewModel>(); string ErrorMessage = new RegisterRepository().GetEmployees(ref list); return(View(list)); }
public ActionResult GetEmployeeById(string id) { UserViewModel item = new UserViewModel(); var ErrorMessage = new RegisterRepository().GetEmployeeById(id, ref item); return(Json(item)); }
public ActionResult Orders(int status) { var models = new List <OrderViewModel>(); string ErrorMessage = new RegisterRepository().GetOrders(status, ref models); return(View(models)); }
public ActionResult Announcements(int status) { var model = new List <AnnouncementViewModel>(); string ErrorMessage = new RegisterRepository().GetAnnouncements(status, ref model); return(View(model)); }
public ActionResult NewApplication(TestInfo testInfo) { string response = ""; if (ModelState.IsValid) { response = new RegisterRepository().RegisterTest(testInfo); MailMessage message = new MailMessage(); string username = "******"; string password = "******"; string receiverEmail = testInfo.StudentInfo.AddressInfo.Email; ContentType mimeType = new ContentType("text/html"); AlternateView alternate = AlternateView.CreateAlternateViewFromString("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\"> <html><head><META http-equiv=Content-Type content=\"text/html; charset=iso-8859-1\"></head><body><b>Dear " + testInfo.StudentInfo.FirstName + testInfo.StudentInfo.LastName + "</b>, <br /><br /><br />Greetings from IELTS !!! <br/><br/><br/> Your registration was successful. Thank You for registering IELTS Examination. <br/> <br/> <br/> Please see below the registration details <br/> <b> Your Receipt Number :</b> " + testInfo.ReceiptNumber + ".<br /><b> Registered Date Time :</b> " + testInfo.CreatedDate.ToString() + "<br /><br /> <b>Note: </b> Receipt Number and Passport or National Identity Card is mandatory to check your test results. <br /><br /><br /> Thank You,<br/><br/><br/> IELTS Admin</body></html>.", mimeType); message.From = new MailAddress(username); message.To.Add(receiverEmail); message.Subject = "IELTS Registration - Congrats, " + testInfo.StudentInfo.FirstName + " " + testInfo.StudentInfo.LastName + "!"; //message.Body = "<html><head></head><body><b>Dear " + testInfo.StudentInfo.FirstName + testInfo.StudentInfo.LastName + "</b>, <br /><br /><br />Greetings from IELTS !!! <br/> Your registration was successful. Thank You for registering IELTS Examination. <br/> Please see below the registration details <br/> <dd /><b>Your Receipt Number :</b> " + testInfo.ReceiptNumber + ".<br /><dd /><b>Registered Date Time :</b> "+testInfo.CreatedDate.ToString()+"<br /><br /> <b>Note: </b> Receipt Number is mandatory to check your test results. <br /><br /><br /> Thank You, IELTS Admin</body></html>."; message.AlternateViews.Add(alternate); message.IsBodyHtml = true; message.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure; SmtpClient smtpClient = new SmtpClient("smtp.gmail.com", 587); smtpClient.EnableSsl = true; smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network; smtpClient.UseDefaultCredentials = false; smtpClient.Credentials = new NetworkCredential(username, password); smtpClient.Send(message); RedirectToAction("SubmitApplicationForm"); } return View(testInfo); }
/// <summary> /// 查找当前用户报名信息 /// </summary> /// <param name="id">学生编号</param> /// <param name="context">数据库连接上下文对象</param> /// <returns></returns> public async Task <InformationViewModel> GetInformationAsync(long id, ApplicationDbContext context) { var webModel = new InformationViewModel(); try { //Get register Data var register = await RegisterRepository.GetEntityAsync(id, context); if (register != null) { webModel.ArriveTime = register.ArriveTime.ToString("yyyy-MM-dd"); webModel.ExpressId = register.ExpressId; webModel.Id = register.Id.ToString(); webModel.IsExpress = register.IsExpress; webModel.Place = register.Place; webModel.Remark = register.Remark; webModel.Way = register.Way; } var user = await PSURepository.GetUserByIdAsync(CurrentUser.UserId, context); webModel.SId = user.Id.ToString(); webModel.Department = user.Department; webModel.MajorClass = user.MajorClass; webModel.Name = user.Name; } catch (Exception ex) { _logger.LogError("获取用户报名数据失败:{0},\r\n内部错误信息:{1}", ex.Message, ex.InnerException.Message); } return(webModel); }
public RegisterPresenter(IRegisterView view) { _view = view; _registerRepository = new RegisterRepository(); _profileRepository = new MyProfileRepository(); }
public void GetByName() { var item = RegisterRepositoryTest.itens[1]; var fromDb = new RegisterRepository().GetByName(item.Nome); Assert.IsNotNull(fromDb); Assert.IsTrue(fromDb.Count > 0); }
public ActionResult GetUserPermission(string uid) { string permissions = new RegisterRepository().GetUserPermission(uid); return(Json(new { permissions })); }
public ActionResult CheckUser(string iin) { var IsExist = new RegisterRepository().CheckUser(iin); return(Json(new { IsExist })); }
public static void MyClassCleanup() { IRegisterRepository r = new RegisterRepository(); foreach (var item in itens) { r.Remove(item); } }
public JsonResult SaveBank(string userid, string name, string bik, string iik, int?kbe, string accounttype, string opendate, string accountcurrency, string address) { var item = new RegisterRepository().AddBank(userid, name, bik, iik, kbe, accounttype, opendate, accountcurrency, address); ItemResponse result = new ItemResponse(); result.IsError = false; result.ErrorMessage = ""; return(Json(result)); }
public void GetAllSuppliers() { var fromDb = new RegisterRepository().GetAllSuppliers(); Assert.IsNotNull(fromDb); foreach (var c in fromDb) { Assert.IsTrue(c.EhFornecedor()); } }
public void GetAllClients() { var fromDb = new RegisterRepository().GetAllClients(); Assert.IsNotNull(fromDb); foreach (var c in fromDb) { Assert.IsTrue(c.EhCliente()); } }
public void AddTest() { Cadastro item = new Cadastro() { Situacao = ActiveInactiveType.Active, Nome = "Nome03", CPF = "12345678903", RG = "70010013", Telefone = "4499778877", Celular = "4499778855", Fax = "4477884488", DataNascimento = DateTime.Parse("29/01/1970"), EMail = "[email protected]", CorrespCep = cep, Tipo = PersonType.Fisica }; IRegisterRepository target = new RegisterRepository(); target.Add(item); try { // use session to try to load the product using (ISession session = NHibernateHelper.OpenSession()) { var fromDb = session.Get <Cadastro>(item.Id); Assert.IsNotNull(fromDb); Assert.AreNotSame(item, fromDb); Assert.AreEqual(item.Tipo, fromDb.Tipo); Assert.AreEqual(item.Nome, fromDb.Nome); Assert.AreEqual(item.CPF, fromDb.CPF); Assert.AreEqual(item.RG, fromDb.RG); Assert.AreEqual(item.Telefone, fromDb.Telefone); Assert.AreEqual(item.Celular, fromDb.Celular); Assert.AreEqual(item.Tipo, fromDb.Tipo); Assert.AreEqual(item.Nome, fromDb.Nome); Assert.AreEqual(item.RazaoSocial, fromDb.RazaoSocial); Assert.AreEqual(item.Contato, fromDb.Contato); Assert.AreEqual(item.CPF, fromDb.CPF); Assert.AreEqual(item.RG, fromDb.RG); Assert.IsNotNull(fromDb.CorrespCep); Assert.AreEqual(item.CorrespCep.Id, fromDb.CorrespCep.Id); Assert.AreEqual(item.CorrespNumero, fromDb.CorrespNumero); Assert.AreEqual(item.CorrespComplemento, fromDb.CorrespComplemento); Assert.AreEqual(item.Telefone, fromDb.Telefone); Assert.AreEqual(item.Celular, fromDb.Celular); Assert.AreEqual(item.Fax, fromDb.Fax); Assert.AreEqual(item.EMail, fromDb.EMail); Assert.AreEqual(item.DataNascimento, fromDb.DataNascimento); Assert.AreEqual(item.DataInclusao, fromDb.DataInclusao); Assert.AreEqual(item.DataAlteracao, fromDb.DataAlteracao); } } finally { target.Remove(item); } }
public JsonResult SaveExistCompanyUser(string email, string lastname, string firstname, string secondname, string iin, string password, string mobilephone, string extraphone, string workphone, string userposition, int?role, string juridicalname, string bin) { string userId = "-1"; var item = new RegisterRepository().AddExistCompanyUser(email, lastname, firstname, secondname, iin, password, mobilephone, extraphone, workphone, userposition, role, juridicalname, bin, ref userId); ItemResponse result = new ItemResponse(); result.IsError = false; result.ErrorMessage = ""; result.Id = userId; return(Json(result)); }
/// <summary> /// 获取寝室信息 /// </summary> /// <param name="context">数据库连接上下文对象</param> /// <returns></returns> public async Task <DormitoryViewModel> GetDormitoryAsync(ApplicationDbContext context) { DormitoryViewModel webModel = new DormitoryViewModel(); try { //Source Data List var list = await RegisterRepository.GetDormitoryListAsync(context); //Return Data List var dataList = new List <InformationData>(); if (list != null && list.Any()) { foreach (var item in list) { var model = new InformationData { Id = item.Id.ToString(), Name = item.Name, BuildingName = item.BuildingName, Count = item.Count, Floor = item.Floor, SelectedCount = item.SelectedCount, Type = item.BunkName, }; dataList.Add(model); } } webModel.InformationList = dataList; var dorm = await RegisterRepository.GetDormitoryAsync(context); webModel.IsChosen = dorm != null; if (dorm != null) { webModel.DormitoryInfo = new DormitoryInfo { BuildingName = dorm.BuildingName, Floor = (short)dorm.Floor, Id = dorm.Id.ToString(), Name = dorm.DormName, Type = dorm.BunkType, DateTime = dorm.DateTime.ToString("yyyy-MM-dd HH:mm:ss") }; } } catch (Exception ex) { _logger.LogError("获取物品信息列表失败:{0},\r\n内部错误信息:{1}", ex.Message, ex.InnerException.Message); } return(webModel); }
//public UnitOfWork() //{ // UserRegisters = new RegisterRepository(_applicationDbContext); // UserRoles = new RoleRepository(_applicationDbContext); // Appointment = new AppointmentRepository(_applicationDbContext); // Doctors = new DoctorRepository(_applicationDbContext); // Patient = new PatientRepository(_applicationDbContext); // Specialization = new SpecializationRepository(_applicationDbContext); // TimeSlot = new TimeSlotRepository(_applicationDbContext); //} public UnitOfWork(ApplicationDbContext applicationDbContext) { _applicationDbContext = applicationDbContext; UserRegisters = new RegisterRepository(_applicationDbContext); UserRoles = new RoleRepository(_applicationDbContext); Locations = new LocationRepository(_applicationDbContext); States = new StateRepository(_applicationDbContext); Appointment = new AppointmentRepository(_applicationDbContext); Doctors = new DoctorRepository(_applicationDbContext); Patient = new PatientRepository(_applicationDbContext); Specialization = new SpecializationRepository(_applicationDbContext); TimeSlot = new TimeSlotRepository(_applicationDbContext); }
public JsonResult CheckCompany(string bin) { if (new RegisterRepository().CheckCompany(bin)) { var item = new RegisterRepository().GetCompanyByBin(bin); item.IsExist = true; return(Json(item)); } CompanyViewModel item2 = new CompanyViewModel(); item2.IsExist = false; return(Json(item2)); }
public ActionResult AddUserPermission(string uid, string permissions) { bool IsSuccess = true; string ErrorMessage = new RegisterRepository().AddUserPermission(uid, permissions); if (ErrorMessage != "") { IsSuccess = false; } return(Json(new { IsSuccess, ErrorMessage })); }
public void SetUpOrganisationTests() { _repository = new RegisterRepository(_databaseService.WebConfiguration, new Mock <ILogger <RegisterRepository> >().Object); _validationRepository = new RegisterValidationRepository(_databaseService.WebConfiguration); _queryRepository = new RegisterQueryRepository(_databaseService.WebConfiguration); _organisationIdCreated = "EPA0987"; _ukprnCreated = 123321; var org2IdCreated = "EPA0001"; _organisationTypeId = 5; OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel { Id = _organisationTypeId, Status = "new", Type = "organisation type 1" }); _id = Guid.NewGuid(); _organisation = new EpaOrganisation { Id = _id, CreatedAt = DateTime.Now, Name = "name 2", OrganisationId = _organisationIdCreated, Ukprn = _ukprnCreated, PrimaryContact = null, PrimaryContactName = null, Status = OrganisationStatus.New, OrganisationTypeId = _organisationTypeId, OrganisationData = new OrganisationData { LegalName = " legal name", TradingName = "trading name", Address1 = "address 1", Address2 = "address 2", Address3 = "address 3", Address4 = "address 4", Postcode = "postcode" } }; _organisation2 = new EpaOrganisation { Id = Guid.NewGuid(), Name = "name 1", OrganisationId = org2IdCreated, Status = OrganisationStatus.New, OrganisationTypeId = null }; }
public ActionResult EditEmployee(string id, string userposition, string email, string mobilephone, string workphone, bool isactive, string permissions) { string ErrorMessage = new RegisterRepository().EditEmployee(id, userposition, email, mobilephone, workphone, isactive, permissions); ItemResponse result = new ItemResponse(); if (ErrorMessage == "") { result.IsError = false; } else { result.IsError = true; } result.ErrorMessage = ErrorMessage; return(Json(result)); }
public ActionResult SignDoc(string datebidding, decimal startprice, decimal margin, string datedeadline, string goodsname, string composition, string lotssize, int lotscount, int?typedelivery, string datedelivery, string paymenttype, string xmlAuditForm) { int docno = 0; var IsSuccess = true; string ErrorMessage = new RegisterRepository().AddAnnouncements(datebidding, startprice, margin, datedeadline, goodsname, composition, lotssize, lotscount, typedelivery, datedelivery, paymenttype, xmlAuditForm, ref docno); if (ErrorMessage != "") { IsSuccess = false; } return(Json(new { docno, IsSuccess, ErrorMessage }, JsonRequestBehavior.AllowGet)); }
public ActionResult SignApplyDoc(string buyername, string buyerbin, string announcementid, int sellerno, decimal sellerstartprice, string sellerdeliverytype, string bankaccountid, string bankwarranty, string xmlAuditForm) { bool IsSuccess = true; var item = new OrderViewModel(); string ErrorMessage = new RegisterRepository().AddOrder(buyername, buyerbin, announcementid, sellerno, sellerstartprice, sellerdeliverytype, bankaccountid, bankwarranty, xmlAuditForm, ref item); if (ErrorMessage != "") { IsSuccess = false; } return(Json(new { IsSuccess, ErrorMessage, item })); }
public UnitOfWork(ParkingManagementContext parkingManagementContext) { _parkingManagementContext = parkingManagementContext; Registers = new RegisterRepository(_parkingManagementContext); UserRoles = new RoleRepository(_parkingManagementContext); RequestDuationTypes = new RequestDuationTypeRepository(_parkingManagementContext); Tower = new TowerRepository(_parkingManagementContext); ParkingSlot = new ParkingSlotRepository(_parkingManagementContext); RequestDetails = new RequestDetailsRepository(_parkingManagementContext); ParkingAllocation = new ParkingAllocationRepository(_parkingManagementContext); SurrenderHistory = new SurrenderHistoryRepository(_parkingManagementContext); TowerParkingSlot = new TowerParkingSlotRepository(_parkingManagementContext); TowerBlock = new TowerBlockRepository(_parkingManagementContext); TowerBlockSlot = new TowerBlockSlotRepository(_parkingManagementContext); slotRequestDetails = new SlotRequestDetailsRepository(_parkingManagementContext); }
public EditProfileModel PostEditUserMethod(EditProfileModel objRegisterModel, string id) { //string result = objRegisterModel.DOB.Substring(6); int birthyear = Convert.ToDateTime(objRegisterModel.DOB).Year; int currentyear = DateTime.Now.Year; //int age = currentyear - Convert.ToInt32(result); int Yourage = currentyear - birthyear; using (var reg_repo = new RegisterRepository()) { ApplicationUser _user = reg_repo.GetById(id); _user.UserName = objRegisterModel.UserName; _user.Email = objRegisterModel.Email; _user.FullName = objRegisterModel.FullName; _user.Surname = objRegisterModel.Surname; _user.Title = objRegisterModel.Title; _user.Password = objRegisterModel.Password; _user.MaritalStatus = objRegisterModel.MaritalStatus; _user.DOB = objRegisterModel.DOB; _user.Age = Convert.ToString(Yourage); _user.Sex = objRegisterModel.Sex; _user.Address1 = objRegisterModel.Address1; _user.Address2 = objRegisterModel.Address2; _user.Address3 = objRegisterModel.Address3; _user.PostalCode = objRegisterModel.PostalCode; _user.Telephone = objRegisterModel.Telephone; _user.Employer = objRegisterModel.Employer; _user.EmployerTelephone = objRegisterModel.EmployerTelephone; _user.Occupation = objRegisterModel.Occupation; _user.NationalId = objRegisterModel.NationalId; _user.Status = objRegisterModel.Status; _user.PatientAllergy = objRegisterModel.PatientAllergy; _user.MedicalAidName = objRegisterModel.MedicalAidName; _user.MedicalAidNo = objRegisterModel.MedicalAidNo; reg_repo.Update(_user); return(objRegisterModel); } }
public ActionResult Index(RegisterRequest registerRequest) { if (registerRequest == null) { ViewBag.Message = "No puede ser nulo el registro"; return(View()); } //Devuelvo la vista. var StoreRegister = RegisterRepository.StoreRegister(registerRequest); if (StoreRegister.status) { CredentialsRepository.CreateSession(registerRequest.Username); return(RedirectToAction("Index", "Products")); } ViewBag.Message = StoreRegister.message; return(View()); }
public void RemoveTest() { Cadastro item = new Cadastro() { Situacao = ActiveInactiveType.Inactive, Nome = "Nome04", CPF = "12345678904", RG = "70010013", Telefone = "4499778877", Celular = "4499778855", Fax = "4477884488", DataNascimento = DateTime.Parse("29/01/1970"), EMail = "[email protected]", CorrespCep = cep, Tipo = PersonType.Fisica }; IRegisterRepository target = new RegisterRepository(); target.Add(item); target.Remove(item); // use session to try to load the product using (ISession session = NHibernateHelper.OpenSession()) { var fromDb = session.Get <Cadastro>(item.Id); Assert.IsNull(fromDb); Assert.AreNotSame(item, fromDb); } }
public RegisterServiceEntity() { _registerRep = new RegisterRepository(); }