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