public void EditCompany_NameIsNullOrWhiteSpace() { // Arrange var id = 1; var repo = new CompanyRepo(null); var company1 = new Company() { Id = id, Name = "" }; var company2 = new Company() { Id = id, Name = " " }; var company3 = new Company() { Id = id, Name = null }; // Act var result1 = repo.EditCompany(id, company1); var result2 = repo.EditCompany(id, company2); var result3 = repo.EditCompany(id, company3); // Assert Assert.False(result1); Assert.False(result2); Assert.False(result3); }
public ActionResult Details(FASViewModel vm) { if (vm.SelectedCompanies == null) { vm.SelectedCompanies = new List <string>(); } if (vm.SelectedRegions == null) { vm.SelectedRegions = new List <string>(); } if (vm.SelectedTerritories == null) { vm.SelectedTerritories = new List <string>(); } if (vm.SelectedZones == null) { vm.SelectedZones = new List <string>(); } vm.Companies = CompanyRepo.GetCompanies(user.UserID); vm.Regions = FASRepo.GetRegions(1, vm.SelectedCompanies.Select(x => x.ToString()).ToList(), user.UserID); vm.Zones = FASRepo.GetZones(1, vm.SelectedCompanies.Select(x => x.ToString()).ToList(), vm.SelectedRegions.Select(x => x.ToString()).ToList(), user.UserID); vm.Territories = FASRepo.GeTerritories(1, vm.Companies.Select(x => x.Compcode.ToString()).ToList(), vm.SelectedRegions.Select(x => x.ToString()).ToList(), vm.SelectedZones.Select(x => x.ToString()).ToList(), user.UserID); ViewBag.WhereClause = FASRepo.GetWhereClause(vm, "FAS", 1, user.UserID); var list = FASRepo.GetDetails("FAS", FASRepo.GetWhereClause(vm, "FAS", 1, user.UserID), user.UserID); ViewBag.ListDetails = list; return(View(vm)); }
public List <ProjectDto> GetAllByName(string name) { using (CompanyRepo repo = new CompanyRepo()) { var projects = repo.ProjectRepository.GetAllByName(projectName => projectName.Name == name); return(projects.Select(project => new ProjectDto { Id = project.Id, Name = project.Name, Description = project.Description, Created = project.Created, Client = project.Client, Price = project.Price, managerDto = new ManagerDto { Id = project.Manager_Id, FirstName = project.manager.FirstName, LastName = project.manager.LastName, PhoneNumber = project.manager.PhoneNumber, Email = project.manager.Email, BirthDate = project.manager.BirthDate, Nationality = project.manager.Nationality, Salary = project.manager.Salary } }).ToList()); } }
public ActionResult Edit(CompanyViewModel model) { if (ModelState.IsValid) { model.Update_By = User.Identity.Name; ResultResponse result = CompanyRepo.Update(model); return(Json(new { success = result.Success, entity = model, message = result.Message }, JsonRequestBehavior.AllowGet)); } else { ResultResponse result = new ResultResponse(); result.Success = false; result.Message = "Theres blank column, Please fill data correctly !"; return(Json(new { success = result.Success, entity = model, message = result.Message }, JsonRequestBehavior.AllowGet)); } }
public EmployeeDto GetById(int id) { EmployeeDto employeeDto = new EmployeeDto(); using (CompanyRepo repo = new CompanyRepo()) { Employee employee = repo.EmployeeRepository.GetByID(id); if (employee != null) { employeeDto = new EmployeeDto { Id = employee.Id, FirstName = employee.FirstName, LastName = employee.LastName, PhoneNumber = employee.PhoneNumber, Email = employee.Email, BirthDate = employee.BirthDate, Position = employee.Position, Salary = employee.Salary }; } } return(employeeDto); }
protected void login_click(object sender, EventArgs e) { string email = txt_email_login.Text; if ((!string.IsNullOrWhiteSpace(email))) { CompanyRepo CompanyRepo = new CompanyRepo(); string result = CompanyRepo.forgotPassword(email); if (result.Equals("true")) { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Password sent to your email address.');", true); return; } if (result.Equals("wrong")) { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Invalid email.');", true); return; } if (result.Equals("false")) { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Something went wrong.');", true); return; } } else { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Email is required.');", true); return; } }
public bool Save(EmployeeDto employeeDto) { Employee employee = new Employee { FirstName = employeeDto.FirstName, LastName = employeeDto.LastName, PhoneNumber = employeeDto.PhoneNumber, Email = employeeDto.Email, BirthDate = employeeDto.BirthDate, Position = employeeDto.Position, Salary = employeeDto.Salary }; try { using (CompanyRepo repo = new CompanyRepo()) { repo.EmployeeRepository.Insert(employee); repo.Save(); } return(true); } catch { return(false); } }
public bool Save(ProjectEmployeeDto projectEmployeeDto) { try { using (CompanyRepo repo = new CompanyRepo()) { try { var pe = new ProjectEmployee() { id_project = projectEmployeeDto.id_project, project = repo.ProjectRepository.GetByID(projectEmployeeDto.projectDto.Id), id_employee = projectEmployeeDto.id_employee, empployee = repo.EmployeeRepository.GetByID(projectEmployeeDto.employeeDto.Id) }; repo.ProjectEmployeeRepository.Insert(pe); repo.Save(); return(true); } catch { return(false); } } return(true); } catch { return(true); } }
public ActionResult DeleteConfirm(int id) { bool result = ProductRepo.Delete(id); UserViewModel modul = CompanyRepo.GetIdByName(User.Identity.Name); if (modul.Role == "Admin") { if (CompanyRepo.Delete(id)) { return(Json(new { success = result, entity = "", message = "delete success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = result, entity = "", message = "delete fail" }, JsonRequestBehavior.AllowGet)); } } else { return(new RedirectToRouteResult(new RouteValueDictionary(new { controller = "AccessDenied", action = "Index" }))); } }
public bool Save(ManagerDto managerDto) { Manager manager = new Manager { FirstName = managerDto.FirstName, LastName = managerDto.LastName, PhoneNumber = managerDto.PhoneNumber, Email = managerDto.Email, BirthDate = managerDto.BirthDate, Nationality = managerDto.Nationality, Salary = managerDto.Salary }; try { using (CompanyRepo repo = new CompanyRepo()) { repo.ManagerRepository.Insert(manager); repo.Save(); } return(true); } catch { return(false); } }
public void CreateCompany_NameIsNullOrWhiteSpace() { // Arrange var repo = new CompanyRepo(null); var company1 = new Company() { Name = "" }; var company2 = new Company() { Name = " " }; var company3 = new Company() { Name = null }; // Act var result1 = repo.CreateCompany(company1); var result2 = repo.CreateCompany(company2); var result3 = repo.CreateCompany(company3); // Assert Assert.Null(result1); Assert.Null(result2); Assert.Null(result3); }
public ActionResult Attendance(AttendanceViewModel vm) { if (vm.SelectedCompanies == null) { vm.SelectedCompanies = new List <string>(); } if (vm.SelectedRegions == null) { vm.SelectedRegions = new List <string>(); } if (vm.SelectedTerritories == null) { vm.SelectedTerritories = new List <string>(); } if (vm.SelectedZones == null) { vm.SelectedZones = new List <string>(); } vm.Companies = CompanyRepo.GetCompanies(user.UserID); vm.Regions = AttendanceRepo.GetRegions(1, vm.SelectedCompanies.Select(x => x.ToString()).ToList(), user.UserID); vm.Zones = AttendanceRepo.GetZones(1, vm.SelectedCompanies.Select(x => x.ToString()).ToList(), vm.SelectedRegions.Select(x => x.ToString()).ToList(), user.UserID); vm.Territories = AttendanceRepo.GeTerritories(1, vm.Companies.Select(x => x.Compcode.ToString()).ToList(), vm.SelectedRegions.Select(x => x.ToString()).ToList(), vm.SelectedZones.Select(x => x.ToString()).ToList(), user.UserID); //ViewBag.CreditDebit = AttendanceRepo.GetList(AttendanceRepo.GetWhereClause(vm)); ViewBag.WhereClause = AttendanceRepo.GetWhereClause(vm, 1); ViewBag.WhereClauseAb = AttendanceRepo.GetWhereAbClause(vm, 1, user.UserID); //var list = AttendanceRepo.GetDetails("FirstCheckIn", AttendanceRepo.GetWhereClause(vm), AttendanceRepo.GetWhereAbClause(vm), user.UserID); var list = AttendanceRepo.GetDetails("FirstCheckIn", AttendanceRepo.GetWhereClause(vm, 1), AttendanceRepo.GetWhereAbClause(vm, 1, user.UserID), user.UserID); ViewBag.ListDetails = list; return(View(vm)); }
public ManagerDto GetById(int id) { ManagerDto managerDto = new ManagerDto(); using (CompanyRepo repo = new CompanyRepo()) { Manager manager = repo.ManagerRepository.GetByID(id); if (manager != null) { managerDto = new ManagerDto { Id = manager.Id, FirstName = manager.FirstName, LastName = manager.LastName, PhoneNumber = manager.PhoneNumber, Email = manager.Email, BirthDate = manager.BirthDate, Nationality = manager.Nationality, Salary = manager.Salary }; } } return(managerDto); }
// GET : Create public ActionResult Create() { UserViewModel model = EmployeeRepo.GetIdByName(User.Identity.Name); ViewBag.Company = new SelectList(CompanyRepo.Get(), "id", "Name"); return(PartialView("_Create", new EmployeeViewModel())); }
// GET: User public ActionResult Index() { ViewBag.Employee = new SelectList(EmployeeRepo.Get(), "FullName", "FullName"); ViewBag.Role = new SelectList(RoleRepo.Get(), "Name", "Name"); ViewBag.Company = new SelectList(CompanyRepo.Get(), "Name", "Name"); return(View(UserRepo.Get())); }
public ProjectDto GetById(int id) { /* ProjectDto projectDto = new ProjectDto(); * * using (CompanyRepo repo = new CompanyRepo()) * { * Project project = repo.ProjectRepository.GetByID(id); * if (project != null) * { * projectDto = new ProjectDto * { * Id = project.Id, * Name = project.Name, * Description = project.Description, * Created = project.Created, * Client = project.Client, * Price = project.Price, * managerDto = new ManagerDto * { * Id = project.Manager_Id, * FirstName = project.manager.FirstName, * LastName = project.manager.LastName, * PhoneNumber = project.manager.PhoneNumber, * Email = project.manager.Email, * BirthDate = project.manager.BirthDate, * Nationality = project.manager.Nationality, * Salary = project.manager.Salary * } * }; * } * } * return projectDto;*/ using (CompanyRepo repo = new CompanyRepo()) { var project = repo.ProjectRepository.GetByID(id); return(project == null ? null : new ProjectDto { Id = project.Id, Name = project.Name, Description = project.Description, Created = project.Created, Client = project.Client, Price = project.Price, managerId = project.Manager_Id, managerDto = new ManagerDto { Id = project.Manager_Id, FirstName = project.manager.FirstName, LastName = project.manager.LastName, PhoneNumber = project.manager.PhoneNumber, Email = project.manager.Email, BirthDate = project.manager.BirthDate, Nationality = project.manager.Nationality, Salary = project.manager.Salary } }); } }
public void ctrl(SqlConnection conn) { CompanyRepo CR = new CompanyRepo(); CR.Read(conn); CR.CreateOrUpdate(conn, "testcompany"); Console.ReadLine(); }
public IActionResult SaveCompany([FromBody] CompanyModel company) { if (CompanyRepo.SaveCompany(company) != null) { return(Ok(company)); } return(StatusCode(500)); }
//GET : Edit public ActionResult Edit(int id) { //UserViewModel model2 = EmployeeRepo.GetIdByName(User.Identity.Name); ViewBag.Company = new SelectList(CompanyRepo.Get(), "id", "Name"); EmployeeViewModel model = EmployeeRepo.GetById(id); return(PartialView("_Edit", model)); }
public CompanyRepo GetCompanyByIdForDisplaying(int _id) { try { using (var context = new VeraEntities()) { var company = context.Company.FirstOrDefault(a => a.Id == _id && a.Status == 1); if (company != null) { var companyUser = context.CompanyUser.FirstOrDefault(b => b.CompanyId == company.Id); var user = context.User.FirstOrDefault(x => x.Id == companyUser.UserId && x.Status == 1); var returnObj = new CompanyRepo() { Id = company.Id, MainCompanyId = company.MainCompanyId, CompanyTypeId = company.CompanyTypeId, CompanyPartnerId = company.CompanyPartnerId, PlatformId = company.PlatformId, DistributorId = company.DistributorId, SectorId = company.SectorId, Address1 = company.Address1, CompanyReportId = company.CompanyReportId, CompanyCode = company.CompanyCode, CompanyDescription = company.CompanyDescription, Phone = company.Phone, TechnicalReport = company.TechnicalReport, TechnicalEmail1 = company.TechnicalEmail1, TechnicalEmail2 = company.TechnicalEmail2, TechnicalEmail3 = company.TechnicalEmail3, CompanyStatus = company.CompanyStatus, AlarmSms = company.AlarmSms, PasswordControl = company.PasswordControl, CompanyVehicleProgramming = company.CompanyVehicleProgramming, CompanyGroupName = company.CompanyGroupName, CreationDate = company.CreationDate, UserId = user.Id, UserCode = user.UserCode, UserEmail = user.Mail, UserName = user.Name, UserPassword = user.Password, UserSurname = user.Surname, UserTelephone = user.Telephone, UserTypeId = user.UserTypeId, UserStatus = company.UserStatus, AccountingCode = company.AccountingCode }; return(returnObj); } return(null); } } catch (Exception) { throw; } }
public AuthController(RecruitmentSystemContext context, SignInManager <SystemUser> signInManager, IServiceProvider serviceProvider, IConfiguration config, SystemUserRepo userRepo, CompanyRepo companyRepo, LabourerRepo labourerRepo) { _context = context; _signInManager = signInManager; _serviceProvider = serviceProvider; _config = config; _userRepo = userRepo; _companyRepo = companyRepo; _labourerRepo = labourerRepo; }
public IActionResult GetAllCompany(int pp, int page) { var companyList = CompanyRepo.GetAllCompany(pp, page); if (companyList != null) { return(new ObjectResult(companyList)); } return(StatusCode(500)); }
public IActionResult GetCompany(int companyId) { var company = CompanyRepo.GetCompany(companyId); if (company != null) { return(new ObjectResult(company)); } return(StatusCode(500)); }
public IActionResult GetCompanyCount() { var count = CompanyRepo.GetCompanyCount(); if (count > -1) { return(new ObjectResult(count)); } return(StatusCode(500)); }
public IActionResult GetCompanySelect() { var companyList = CompanyRepo.GetCompanySelect(); if (companyList != null) { return(new ObjectResult(companyList)); } return(StatusCode(500)); }
public static List <string> SearchEmail(string prefixText, int count) { var list = new CompanyRepo().GetListByContainsEmail(prefixText); List <string> fullnames = new List <string>(); foreach (var item in list) { fullnames.Add(item.EMAIL); } return(fullnames); }
public ActionResult Edit(CompanyViewModel model) { if (CompanyRepo.Update(model)) { return(Json(new { success = true, entity = model }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteConfirm(int id) { if (CompanyRepo.Delete(id)) { return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(int id) { ViewBag.CompanyType = new SelectList(CompanyRepo.All().Select(p => new { CompanyType = p.客戶分類 }).Distinct(), "CompanyType", "CompanyType"); var data = CompanyRepo.Find(id); if (data == null) { throw new InvalidOperationException("操作錯誤"); } return(View(data)); }
public IActionResult GetCompanyName(int companyId) { try { var name = CompanyRepo.GetCompanyName(companyId); return(new ObjectResult(name)); } catch (Exception) { return(StatusCode(500)); } }