public void EditMemberTest() { MemberModel model = new MemberModel(); MemberDAL memberDAL = new MemberDAL(); CompanyDAL companyDAL = new CompanyDAL(); model.Id = memberDAL.GetMembersByCompanyId(companyDAL.GetCompanies().Select(x => x.Id).Min()).Select(x => x.Id).Max(); model.FirstName = "TestEditFirstName"; model.LastName = "TestEditLastName"; model.CardNumber = "22222"; model.Title = "testTitle"; memberDAL.EditMember(model); MemberModel testmodel = memberDAL.GetMembersByCompanyId(companyDAL.GetCompanies().Select(x => x.Id).Min()).Where(x => x.FirstName == "TestEditFirstName").FirstOrDefault(); Assert.That(testmodel != null, Is.True); }
public void AddNewMessagesCompanyIdTest() { CompanyDAL companyDAL = new CompanyDAL(); List <CompanyModel> companies = companyDAL.GetCompanies(); MessagesFromBulidingModel model = new MessagesFromBulidingModel(); model.Subject = "testSubject"; model.Text = "testText"; model.Companies = companies; MessageDAL messageDAL = new MessageDAL(); messageDAL.AddNewMessages(model); List <MessageToCompanyModel> messages = messageDAL.GetMessagesFromBuilding(); int counter = 0; foreach (var item in companies) { if (messages.Where(x => x.Subject == "testSubject" && x.CompanyId == item.Id).FirstOrDefault() != null) { counter++; } } Assert.That(counter == companies.Count, Is.True); }
public void EditCompanyTest() { CompanyDAL companyDAL = new CompanyDAL(); int companyId = companyDAL.GetCompanies().Select(x => x.Id).Max(); CompanyModel model = new CompanyModel() { Id = companyId, Address = "testAddress" }; companyDAL.EditCompany(model); CompanyModel company = new CompanyModel(); company = companyDAL.GetCompanies().Where(x => x.Address == "testAddress" && x.Id == companyId).FirstOrDefault(); Assert.That(company != null, Is.False); }
public void DeleteCompany() { CompanyDAL companyDAL = new CompanyDAL(); int companyId = companyDAL.GetCompanies().Max(x => x.Id); companyDAL.DeleteCompany(companyId); Assert.True(companyDAL.GetCompanyById(companyId) == null); }
public void InitCompaniesList(ObservableCollection <CompanyModel> CompaniesToWindow) { CompanyDAL companyDAL = new CompanyDAL(); List <CompanyModel> companies = companyDAL.GetCompanies(); foreach (var item in companies) { CompaniesToWindow.Add(item); } }
public void CheckMemberByCardNumberTest() { int companyId = CompanyDAL.GetCompanies().Select(x => x.Id).Min(); List <MemberModel> members = MemberDAL.GetMembersOfCompany(companyId); string cardnumber = members.First().CardNumber; DataBaseLayer db = new DataBaseLayer(); Test1702.Model.MemberModel testmodel = db.CheckMemberByCardNumber(cardnumber); Assert.That(testmodel != null, Is.True); }
public IEnumerable <CompanyMaster> Get() { CommonAPI commonApi = new CommonAPI(); commonApi.getHeaderValues(Request.Headers, out connectionString, out userAccount, out roleId, out companyCode, out DBProviderName); CompanyDAL companyDAL = new CompanyDAL(connectionString, userAccount, roleId, DBProviderName, companyCode); var companies = companyDAL.GetCompanies(); return(companies); }
public List <CompanyModel> GetCompanies() { List <CompanyModel> result = new List <CompanyModel>(); try { result = CompanyDAL.GetCompanies(); } catch (Exception e) { } return(result); }
public List <B2dCompany> GetCompanies(string filter, int skip, int size, string sorting) { var _filter = GetFieldFiltering(filter); var _sorting = GetFieldSorting(sorting); var company_list = CompanyDAL.GetCompanies(_filter, skip, size, _sorting); company_list.ForEach(c => { //狀態語系文字對應 c.STATUS_DESC = GetFieldStatus(c.STATUS); }); return(company_list); }
public List <CompanyModel> GetCompanies() { List <CompanyModel> result = new List <CompanyModel>(); try { CompanyDAL companyDAL = new CompanyDAL(); result = companyDAL.GetCompanies(); } catch (Exception e) { throw new Exception(e.Message); } return(result); }
public void AddNewCompany() { CompanyModel model = new CompanyModel() { Name = "testName", Address = "testAddress", Phone = "testPhone" }; CompanyDAL companyDAL = new CompanyDAL(); companyDAL.AddNewCompany(model); CompanyModel company = new CompanyModel(); company = companyDAL.GetCompanies().Where(x => x.Name == "testName").FirstOrDefault(); Assert.That(company != null, Is.True); }
public void AddNewMessageTest() { MessageFromCompanyModel model = new MessageFromCompanyModel(); model.Subject = "TestMessage"; model.Text = "TestValue"; CompanyDAL companyDAL = new CompanyDAL(); model.CompanyId = companyDAL.GetCompanies().Select(x => x.Id).Min(); MessageDAL messageDAL = new MessageDAL(); messageDAL.AddNewMessage(model); MessageFromCompanyModel testmodel = messageDAL.GetMessagesByCompany(model.CompanyId).Where(x => x.Subject == "TestMessage" && x.Text == "TestValue").FirstOrDefault(); Assert.That(testmodel != null, Is.True); }
public void AddNewMessagesSubjectTest() { CompanyDAL companyDAL = new CompanyDAL(); List <CompanyModel> companies = companyDAL.GetCompanies(); MessagesFromBulidingModel model = new MessagesFromBulidingModel(); model.Subject = "testSubject"; model.Text = "testText"; model.Companies = companies; MessageDAL messageDAL = new MessageDAL(); messageDAL.AddNewMessages(model); List <MessageToCompanyModel> messages = messageDAL.GetMessagesFromBuilding(); Assert.That(messages.Where(x => x.Subject == "testSubject").Any(), Is.True); }
public void AddNewMemberTest() { MemberModel model = new MemberModel(); model.FirstName = "TestFirstName"; model.CardNumber = "1111"; model.Title = "TestTitle"; CompanyDAL companyDAL = new CompanyDAL(); model.CompanyId = companyDAL.GetCompanies().Select(x => x.Id).Min(); MemberDAL memberDAL = new MemberDAL(); memberDAL.AddNewMember(model); List <MemberModel> membersbycompany = new List <MemberModel>(); membersbycompany = memberDAL.GetMembersByCompanyId(model.CompanyId); MemberModel testmodel = membersbycompany.Where(x => x.FirstName == "TestFirstName").FirstOrDefault(); Assert.That(testmodel != null, Is.True); }
public void CompaniesWindowBasicTest() { SuccessLoginTest(); Window window = application.GetWindow("MainWindow"); window.Get <Button>("CompaniesButton").Click(); Window compwindow = application.GetWindow("CompaniesWindow"); CompanyDAL companyDAL = new CompanyDAL(); int companyCount = companyDAL.GetCompanies().Count; ListView listview = compwindow.Get <ListView>("CompaniesListView"); bool itemscheck = listview.Items.Count == companyCount; compwindow.Get <Button>("AddNewCompanyButton").Click(); bool isactiveWindow = compwindow.IsCurrentlyActive == true; Assert.That(itemscheck && !isactiveWindow, Is.True); }
public List <CompanyMaster> GetCompanies() { CompanyDAL CompanyDAL = new CompanyDAL(); return(CompanyDAL.GetCompanies()); }
public List <Company> GetCompanies() { return(companyDal.GetCompanies()); }