public int SaveEmployee(Employee employee) { int id = 0; try { IEmployeeDb da = new EmployeeDb(); if (employee.Id == 0) { Task <int> emplTask = Task.Run(() => da.InsertEmployee(employee)); Task.WaitAll(emplTask); id = emplTask.Id; } else { Task emplTask = Task.Run(() => da.UpdateEmployee(employee)); Task.WhenAll(emplTask); id = employee.Id; } } catch (Exception ex) { throw ex; } return(id); }
protected override void Seed(EmployeeDb context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. context.Employee.AddOrUpdate( m => m.Name, new Employee { Name = "Nguyen Thanh Don", Email = "*****@*****.**", DepartmentName = "Sales", Designation = "Dev" }, new Employee { Name = "Ngo Minh Duc", Email = "*****@*****.**", DepartmentName = "Technical", Designation = "Dev" }, new Employee { Name = "Tran Xuan Hung", Email = "*****@*****.**", DepartmentName = "Technical", Designation = "Dev" } ); }
public async Task ExecuteAsync(EmployeeEntity employee) { using (var dbContext = new EmployeeDb(_connectionString)) { var model = await dbContext.Employee.AddAsync(employee); await dbContext.SaveChangesAsync(); } }
public async Task ExecuteAsync(EmployeeEntity employee) { using (var dbContext = new EmployeeDb(_connectionString)) { //var model = await dbContext.Employee.AddAsync(employee); dbContext.Entry(employee).State = EntityState.Modified; await dbContext.SaveChangesAsync(); } }
private ModelBuilder Import(ModelBuilder builder) { List <EmployeeDb> list = new List <EmployeeDb>(); List <DepartmentDb> listDepartment = new List <DepartmentDb>(); try { //using (StreamReader sr = new StreamReader(@"e:\TEMP\Employee.csv", System.Text.Encoding.Default)) using (StreamReader sr = new StreamReader(@"c:\inetpub\wwwroot\phoneBook.api\Employee.csv", System.Text.Encoding.Default)) { string line; long id = 1; while ((line = sr.ReadLine()) != null) { string[] mass = line.Split(';'); EmployeeDb employee = new EmployeeDb(); employee.Id = id; employee.DepartmentDbId = mass[0]; employee.Name = mass[1]; employee.Position = mass[2]; employee.Name_Upper = mass[1].ToUpper(); employee.Position_Upper = mass[2].ToUpper(); list.Add(employee); id++; } } //using (StreamReader sr = new StreamReader(@"e:\TEMP\Departments.csv", System.Text.Encoding.Default)) using (StreamReader sr = new StreamReader(@"c:\inetpub\wwwroot\phoneBook.api\Departments.csv", System.Text.Encoding.Default)) { string line; while ((line = sr.ReadLine()) != null) { string[] mass = line.Split(';'); DepartmentDb department = new DepartmentDb(); department.Id = mass[0]; department.Name = mass[1]; listDepartment.Add(department); } } } catch { } builder.Entity <EmployeeDb>().Property(x => x.Name).HasColumnType("TEXT COLLATE NOCASE"); builder.Entity <EmployeeDb>().Property(x => x.Position).HasColumnType("TEXT COLLATE NOCASE"); builder.Entity <EmployeeDb>().HasData( list.ToArray()); builder.Entity <DepartmentDb>().HasData( listDepartment.ToArray()); return(builder); }
public async Task <List <EmployeeEntity> > ExecuteQueryAsync() { using (var dbContext = new EmployeeDb(_connectionString)) { var model = await dbContext.Employee .Include(i => i.Salary) .ToListAsync(); return(model); } }
public async Task <EmployeeEntity> ExecuteQueryAsync(Guid employeeId) { using (var dbContext = new EmployeeDb(_connectionString)) { var model = await dbContext.Employee .Where(w => w.Id == employeeId) .Include(i => i.Salary) .FirstOrDefaultAsync(); return(model); } }
public static Employee Map(EmployeeDb employeeDb) { return(new Employee { Id = employeeDb.Id, Address = employeeDb.Address, Position = employeeDb.Position, Description = employeeDb.Description, Name = employeeDb.Name, PhoneNumber = employeeDb.PhoneNumber, Surname = employeeDb.Surname }); }
/// <summary> /// Delete Employee /// </summary> /// <param name="id"></param> public void DeleteEmployee(int id) { try { IEmployeeDb db = new EmployeeDb(); Task deleteTask = Task.Run(() => db.DeleteEmployee(id)); Task.WaitAll(deleteTask); } catch (Exception ex) { throw ex; } }
public JsonResult GetEmployee(int id) { if (id > 0) { var entity = EmployeeDb.GetEmployeesbyId(id); var employee = _mapper.Map <EmployeeDb, EmployeeViewModel>(entity); return(Json(employee)); } else { return(Json("")); } }
public EmployeeSalary calculateSalary(int employeeId, float value) { var salary = new EmployeeSalary(); var employee = EmployeeDb.GetEmployeesbyId(employeeId); var totalPay = employee.RatePerDay * value; var tt = Math.Round(totalPay, 2); salary.totol_amount = String.Format("{0:0.00}", employee.SalaryPm); salary.days_worked = String.Format("{0:0.00}", value); salary.net_payable = String.Format("{0:0.00}", tt); salary.rate_perday = String.Format("{0:0.00}", employee.RatePerDay); salary.work_type = employee.EmployeeType; return(salary); }
public static SelectList FnGetEmployeeList(string selectedValue) { var response = new List <SelectListItem>(); foreach (var employee in EmployeeDb.GetEmployees()) { response.Add(new SelectListItem { Text = employee.Name, Value = employee.Id.ToString() }); } var listTitle = response.Select(x => new { Value = x.Value, Text = x.Text }).ToList(); return(new SelectList(response, "Value", "Text", selectedValue)); }
/// <summary> /// Get all employees /// </summary> /// <returns></returns> public ObservableCollection <Employee> GetEmployees() { ObservableCollection <Employee> employees = new ObservableCollection <Employee>(); try { IEmployeeDb da = new EmployeeDb(); Task <ObservableCollection <Employee> > emplTask = Task.Run(() => da.FindEmployees()); Task.WhenAll(emplTask); employees = emplTask.Result; } catch (Exception ex) { throw ex; } return(employees); }
public async void AuthenticateCommand() { Employee employee = new Employee { EmployeeName = Username, Password = this.Password }; var emp = new EmployeeDb().EmployeeExists(employee); if (emp != null) { Preferences.Set("IsLogged", true); await _navigationService.NavigateToViewModelAsync(typeof(MainViewModel)); } else { await App.Current.MainPage.DisplayAlert("Login failed", "Please try again!", "OK"); } }
protected override void OnInitialized() { Save = false; int.TryParse(Id, out var EmpId); if (EmpId == 0) { EmployeeDb = new EmployeeDb() { Job = "", Name = "" }; } else { EmployeeDb = EmployeeRepo.GetByID(int.Parse(Id)); } base.OnInitialized(); }
public EmployeeSalary calculateSalary(int employeeId, float value) { var salary = new EmployeeSalary(); var employee = EmployeeDb.GetEmployeesbyId(employeeId); var oneDaySalary = employee.SalaryPm / 22; var absentDeduction = oneDaySalary * value; var taxDeduction = employee.SalaryPm * Constants.TaxRate / 100; var totalPay = employee.SalaryPm - absentDeduction - (taxDeduction); var tt = Math.Round(totalPay, 2); salary.totol_amount = String.Format("{0:0.00}", employee.SalaryPm); salary.absents = String.Format("{0:0.00}", value); salary.absent_deduction = String.Format("{0:0.00}", absentDeduction); salary.tax_deduction = String.Format("{0:0.00}", taxDeduction); salary.net_payable = String.Format("{0:0.00}", tt); salary.work_type = employee.EmployeeType; return(salary); }
public void Update(EmployeeDb emp) { _context.EmployeeDbs.Update(emp); _context.SaveChanges(); }
public void Insert(EmployeeDb emp) { _context.EmployeeDbs.Add(emp); _context.SaveChanges(); }
public void Delete(EmployeeDb emp) { _context.EmployeeDbs.Remove(emp); _context.SaveChanges(); }
public EmployeeLogin() { InitializeComponent(); empdbhelper = new EmployeeDb(); }
public EmployeeBL() { employeeDb = new EmployeeDb(); }
public ActionResult EmployeeRegistration(EmployeeRegistrationViewModel reg) { try { bool flag = false; HostelManagementSystemEntities7 db = new HostelManagementSystemEntities7(); EmployeeDb s = new EmployeeDb(); foreach (EmployeeDb e in db.EmployeeDbs) { if (e.Email == reg.email) { flag = true; ModelState.AddModelError("", "Email already exist"); if (e.CNIC == reg.CNIC) { flag = true; ModelState.AddModelError("", "CNIC already exist"); break; } break; } if (e.CNIC == reg.CNIC) { flag = true; ModelState.AddModelError("", "CNIC already exist"); break; } } if (flag == true) { return(View()); } else { s.Address = reg.Address; s.BloodGroup = reg.BloodGroup; s.CNIC = reg.CNIC; s.ContactNo = reg.ContactNo; s.FatherName = reg.FatherName; s.Name = reg.Name; s.DOB = reg.DOB; s.Password = reg.password; s.Email = reg.email; s.Designation = reg.Designation; LoginDb l = new LoginDb(); l.Designation = reg.Designation; l.Email = reg.email; l.Password = reg.password; l.Status = "NO"; db.LoginDbs.Add(l); db.EmployeeDbs.Add(s); db.SaveChanges(); ModelState.Clear(); ViewBag.Message = "You are Registered Successfully"; return(RedirectToAction("login")); } } catch (Exception e) { throw (e); } }
private void GetItemList() { ItemList = new EmployeeDb().GetEmployList(); }
public EmployeeBs() { _employeeObject = new EmployeeDb(); }
public EmployeeBs() { ObjDb = new EmployeeDb(); }
public EmployeeController() { empdbhelper = new EmployeeDb(); dbhelper = new JobOpeningDb(); }
public EmployeeController(EmployeeDb employeeDb) { _employeeDb = employeeDb; }
public static void CreateEmployeeTable() { EmployeeDb.CreateTable(); }
public EmployeeService() { _employee = EmployeeDb.Instance; _employer = EmployerDb.Instance; }
public NucesJobAccountController() { logindbhelper = new LoginDb(); candidatedbhelper = new CandidateDb(); employeedbhelper = new EmployeeDb(); }