protected override void OnInitialized()
{
if (this.EmployeeDetails.ListEmployee == null || this.EmployeeDetails.ListEmployee.Count == 0)
{
this.EmployeeDetails.ListEmployee = EmployeeCRUD.FetchEmployees();
}
}
private void EmployeeToolStripMenuItem1_Click(object sender, EventArgs e)
{
this.Hide();
EmployeeCRUD Emp = new EmployeeCRUD();
Emp.ShowDialog();
}
public IHttpActionResult PutEmaployeeMaster(EmployeeCRUD employee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
EmployeeCRUD objEmp = new EmployeeCRUD();
objEmp = objEntity.EmployeeCRUDs.Find(employee.EmpID);
if (objEmp != null)
{
objEmp.EmpName = employee.EmpName;
objEmp.EmailID = employee.EmailID;
objEmp.DOB = employee.DOB;
objEmp.Gender = employee.Gender;
}
int i = this.objEntity.SaveChanges();
}
catch (Exception)
{
throw;
}
return(Ok(employee));
}
protected override void OnInitialized()
{
employee = EmployeeCRUD.FetchSingleEmployee(EmployeeNumber);
var strTableName = nameof(employee.City);
DropDownValues = EmployeeCRUD.FetchDropDownList(strTableName);
}
public MainWindowViewModel()
{
DepartmentUC = new DepartmentCRUDControl();
EmployeeVC = new EmployeeCRUD();
((EmployeeCRUDVM)EmployeeVC.EmployeeGrid.DataContext).switchToEditTask += new EventHandler <switchTaskViewEventArgs>(SwitchToEditTask);
CurrentView = DepartmentUC;
}
//private async Task LoadStateAsync()
//{
// Employee = await ProtectedLocalStorage.GetAsync<EmployeeInformation>("EmployeeData");
//}
protected void CreateNewEmployee()
{
EmployeeCRUD.CreateEmployee(this.Employee);
//ProtectedLocalStorage.SetAsync("EmployeeData", Employee);
EmployeeDetails.ListEmployee = null;
this.NavigationManager.NavigateTo("listemployees");
}
private void btnTestCode_Click(object sender, EventArgs e)
{
EmployeeCRUD empCRUD = new EmployeeCRUD(new LaundryManagement.Models.LaundryDataContext());
//empCRUD.Create(CreateNewEmployeeDummyData());
//empCRUD.Update(UpdateEmployeeDummyData());
// List<Employee> res =(List<Employee>) empCRUD.GetAllEmployees();
//empCRUD.Delete(1);
MessageBox.Show("wait");
}
public IHttpActionResult DeleteEmaployeeDelete(int id)
{
//int empId = Convert.ToInt32(id);
EmployeeCRUD emaployee = objEntity.EmployeeCRUDs.Find(id);
if (emaployee == null)
{
return(NotFound());
}
objEntity.EmployeeCRUDs.Remove(emaployee);
objEntity.SaveChanges();
return(Ok(emaployee));
}
//BL
//MAP
//Init
private void initConstructor(DBMAINContext poDB)
{
//DBContext
this.db = poDB;
//VM
this.oVM = new EmployeeVM();
//DS
this.oDS = new EmployeeDS(this.db);
this.oDSUnit = new UnitDS(this.db);
this.oDSJobtitle = new JobtitleDS(this.db);
//CRUD
this.oCRUD = new EmployeeCRUD(this.db);
//BL
//MAP
} //End initConstructor
public void GetAllEmployeeofAnManager()
{
EmployeeCRUD objEmplyeeCRUD = new EmployeeCRUD();
var emp1 = new Employee.Models.Employee()
{
EmployeeID = 3,
EmployeeName = "Tom miller3",
ManagerId = 0,
TopLowerEmployeeIDs = new HashSet <int> {
1, 2
}
};
//Employee ID 3 is reporting to emp 4
var emp2 = new Employee.Models.Employee()
{
EmployeeID = 4,
EmployeeName = "Tom miller4",
ManagerId = 0,
TopLowerEmployeeIDs = new HashSet <int> {
3
}
};
var emp3 = new Employee.Models.Employee()
{
EmployeeID = 5,
EmployeeName = "Tom miller5",
ManagerId = 0,
TopLowerEmployeeIDs = new HashSet <int> {
4
}
};
// act
//adding above employee object into collection
objEmplyeeCRUD.AddUpdateEmployee(emp1);
objEmplyeeCRUD.AddUpdateEmployee(emp2);
objEmplyeeCRUD.AddUpdateEmployee(emp3);
//employeeIds 1,2,3,4 get selected
List <Employee.Models.Employee> lst = objEmplyeeCRUD.GetEmployeeListByManagerId(5);
//assert
//assert is pending
//all hirarchical employee will get selected.
}
public IHttpActionResult PostEmaployee(EmployeeCRUD data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
objEntity.EmployeeCRUDs.Add(data);
objEntity.SaveChanges();
}
catch (Exception)
{
throw;
}
return(Ok(data));
}
public void ChaingingReportingOfAnEmployee()
{
EmployeeCRUD objEmplyeeCRUD = new EmployeeCRUD();
var emp1 = new Employee.Models.Employee()
{
EmployeeID = 3,
EmployeeName = "Tom miller3",
ManagerId = 0,
TopLowerEmployeeIDs = new HashSet <int> {
}
};
//Employee ID 3 is reporting to emp 4
var emp2 = new Employee.Models.Employee()
{
EmployeeID = 4,
EmployeeName = "Tom miller4",
ManagerId = 0,
TopLowerEmployeeIDs = new HashSet <int> {
3
}
};
var emp3 = new Employee.Models.Employee()
{
EmployeeID = 5,
EmployeeName = "Tom miller5",
ManagerId = 0,
TopLowerEmployeeIDs = new HashSet <int> {
}
};
// act
//adding above employee object into collection
objEmplyeeCRUD.AddUpdateEmployee(emp1);
objEmplyeeCRUD.AddUpdateEmployee(emp2);
objEmplyeeCRUD.AddUpdateEmployee(emp3);
// currently employee "Tom miller3" is reporting to "Tom miller4"
// now I am changing employee "Tom miller3" is reporting to "Tom miller5"
objEmplyeeCRUD.ChangingReportingManager(4, 3, 5);
//assert
//assert is pending
}
public void RemoveAllEmployeeReportingToManager()
{
// arrange
EmployeeCRUD objEmplyeeCRUD = new EmployeeCRUD();
var emp1 = new Employee.Models.Employee()
{
EmployeeID = 3,
EmployeeName = "Tom miller3",
ManagerId = 4,
TopLowerEmployeeIDs = new HashSet <int> {
}
};
var emp2 = new Employee.Models.Employee()
{
EmployeeID = 4,
EmployeeName = "Tom miller4",
ManagerId = 0,
TopLowerEmployeeIDs = new HashSet <int> {
3, 5
}
};
var emp3 = new Employee.Models.Employee()
{
EmployeeID = 5,
EmployeeName = "Tom miller5",
ManagerId = 4,
TopLowerEmployeeIDs = new HashSet <int> {
}
};
// act
//adding above employee object into collection
objEmplyeeCRUD.AddUpdateEmployee(emp1);
objEmplyeeCRUD.AddUpdateEmployee(emp2);
objEmplyeeCRUD.AddUpdateEmployee(emp3);
// deleting all employee who has manager "Tom miller4"
// employee 3 and 5 will removed after execution of function.
objEmplyeeCRUD.DeleteAllEmployeeByManagerId(4);
//assert is pending
}
public IHttpActionResult GetEmaployeeById(string EmployeeID)
{
EmployeeCRUD objempdetails = new EmployeeCRUD();
int ID = Convert.ToInt32(EmployeeID);
try
{
objempdetails = objEntity.EmployeeCRUDs.Find(ID);
if (objempdetails == null)
{
return(NotFound());
}
}
catch (Exception)
{
throw;
}
return(Ok(objempdetails));
}
public void AddUpdateEmployee()
{
// arrange
// arrange
EmployeeCRUD objEmplyeeCRUD = new EmployeeCRUD();
var emp = new Employee.Models.Employee()
{
EmployeeID = 3,
EmployeeName = "Tom miller",
ManagerId = 0,
TopLowerEmployeeIDs = new HashSet <int> {
}
};
// act
objEmplyeeCRUD.AddUpdateEmployee(emp);
List <Employee.Models.Employee> lstEmployees = objEmplyeeCRUD.GetEmployees();
var savedEmp = lstEmployees.Find(x => x.EmployeeID == 3);
// assert
Assert.AreEqual(savedEmp.EmployeeName, emp.EmployeeName);
}
static void Main(string[] args)
{
EmployeeCRUD crud = new EmployeeCRUD();
crud.InsertEmployee(1234, "Test", "Test 2", "*****@*****.**");
crud.SelectByFirstName("Test");
crud.UpdateEmployee(1234, "Test Test", "Test 1", "*****@*****.**");
crud.SelectEmployees(1234);
crud.Delete(1234);
// Employees with POCO
List <Employee> employees = crud.SelectEmployees();
foreach (Employee employee in employees)
{
Console.WriteLine("{0} {1} {2}", employee.EmployeeId, employee.FirstName, employee.LastName);
}
// Select Single Employee
Dictionary <string, string> employee = crud.SelectEmployees(222);
Console.WriteLine("{0} {1} {2}", employee["employee_id"], employee["first_name"], employee["last_name"]);
// Insert Employee Using Dictionar
Dictionary <string, string> employee2 = crud.SelectEmployees(456);
Console.WriteLine("{0} {1}", employee2["employee_id"], employee2["first_name"], employee2["last_name"]);
// With Model
EmployeeCRUD crud = new EmployeeCRUD();
Employee employee = crud.SelectEmployees(456);
Console.WriteLine("{0} {1}", employee.FirstName, employee.LastName);
Console.ReadKey();
}
public EmployeeService()
{
employeeTableActions = new EmployeeCRUD();
employeePersonalInfoTableActions = new EmployeePersonalInfoCRUD();
}
protected override void OnInitialized()
{
employee = EmployeeCRUD.FetchSingleEmployee(this.EmployeeNumber);
}
//[Inject]
//private IJSRuntime JSRuntime { get; set; }
#endregion
#region Protecteds
protected override void OnInitialized()
{
const string strTableName = nameof(this.Employee.City);
DropDownValues = EmployeeCRUD.FetchDropDownList(strTableName);
}
