static void Main(string[] args)
{
Console.WriteLine("Hello World!");
EmployeeRepo er = new EmployeeRepo();
er.GetAllEmployee();
}
private static void Main(string[] args)
{
Console.WriteLine("SQL!");
EmployeeRepo repo = new EmployeeRepo();
EmployeeSalaryModel employeeSalaryPayroll = new EmployeeSalaryModel();
EmployeePayroll employeePayroll = new EmployeePayroll();
employeePayroll.EmployeeName = "Johnny";
employeePayroll.BasicPay = 200900;
employeePayroll.StartDate = DateTime.Now;
employeePayroll.Gender = "M";
employeePayroll.PhoneNumber = "7677173446";
employeePayroll.Address = "Bangur Rd";
employeePayroll.Department = "HR";
employeePayroll.Deductions = 1050;
employeePayroll.TaxablePay = 17000;
employeePayroll.Tax = 1800;
employeePayroll.NetPay = 18000;
//repo.AddEmployee(employeePayroll);
Console.WriteLine("-------------");
//repo.GetAllEmployee();
employeeSalaryPayroll.EmployeeId = 3;
employeeSalaryPayroll.payroll_id = 1;
employeeSalaryPayroll.department = "Finance";
employeeSalaryPayroll.basic_pay = 2345678;
employeeSalaryPayroll.name = "UpdatedName";
employeeSalaryPayroll.start_Date = "01-01-20";
repo.UpdateEmployee(employeeSalaryPayroll);
}
static void Main(string[] args)
{
Console.WriteLine("Welcome to Employee Payroll");
EmployeeModel employeeModel = new EmployeeModel();
EmployeeRepo employeeRepo = new EmployeeRepo();
employeeModel.EmployeeName = "Purple";
employeeModel.PhoneNumber = "3216549870";
employeeModel.Address = "Alaska";
employeeModel.Department = "Marketing";
employeeModel.Gender = 'F';
employeeModel.BasicPay = 280000;
employeeModel.Deductions = 4357.54;
employeeModel.TaxablePay = 3256.35;
employeeModel.Tax = 756.23;
employeeModel.NetPay = 273234.23;
employeeModel.StartDate = Convert.ToDateTime("2020-10-13");
employeeRepo.addEmployee(employeeModel);
Console.WriteLine("1. Get All Employees");
Console.WriteLine("2. Get employees in a date range");
Console.WriteLine("3. Get Sum, Avg, Min, Max, Count by gender");
int choice = Convert.ToInt32(Console.ReadLine());
employeeRepo.getAllEmployee(choice);
}
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
//Get data of all employees from database
EmployeeRepo employeeRepo = new EmployeeRepo();
//employeeRepo.GetAllEmployee();
//Adding employee to database
//EmployeeModel employee = new EmployeeModel();
//employee.EmployeeName = "Indal";
//employee.Department = "Tech";
//employee.PhoneNumber = "6302907918";
//employee.Address = "02-Khajauli";
//employee.Gender = 'M';
//employee.BasicPay = 10000.00M;
//employee.Deductions = 1500;
//employee.StartDate = employee.StartDate = Convert.ToDateTime("2020-11-03");
//if (employeeRepo.AddEmployee(employee))
// Console.WriteLine("Records added successfully");
//if(employeeRepo.UpdateSalary("Bill", 200000))
// Console.WriteLine("Salary Updated successfully");
//employeeRepo.Retrieve_Employee_Within_Specified_Joining_Date(Convert.ToDateTime("03/11/2018"), Convert.ToDateTime("03/11/2019"));
employeeRepo.SumOfEmployeeSalary();
employeeRepo.AverageOfEmployeeSalary();
employeeRepo.MinOfEmployeeSalary();
employeeRepo.MaxOfEmployeeSalary();
}
static void Main(string[] args)
{
//Salary.EmployeesBetweenDateRange(DateTime.Parse("10-14-2019"), DateTime.Parse("10-15-2019"));
//Salary.EmployeesGroupData();
EmployeeRepo repo = new EmployeeRepo();
EmployeePayroll employee = new EmployeePayroll();
employee.EmployeeName = "rao";
employee.CompanyId = 420;
employee.PhoneNumber = "1234567890";
employee.Address = "1-106,sunnada";
employee.Department = ".Net";
employee.Gender = 'M';
employee.StartDate = DateTime.Parse("10-24-2009");
employee.City = "srikakulam";
employee.Country = "India";
if (repo.AddEmployee(employee))
{
Console.WriteLine("Added data to the database");
}
repo.AddEmployeeWithThread(employee);
//repo.GetAllEmployee();
}
public static void Start()
{
EmployeeRepo employeeRepo = new EmployeeRepo();
MultiThreadedEmployeeRepo threadedEmployeeRepo = new MultiThreadedEmployeeRepo();
//employeeRepo.GetAllEmployee();
//AddNewEmployee(employeeRepo);
CompareSequentialWithMultiThreading(employeeRepo, threadedEmployeeRepo);
}
static void Main(string[] args)
{
Console.WriteLine("Welcome to Employee Payroll Service!");
EmployeeModel model = new EmployeeModel();
model.EmployeeName = "Akash";
model.PhoneNumber = "9875241630";
model.Address = "Mumbai";
model.Department = "SD";
model.Gender = 'M';
model.BasicPay = 53000;
model.Deductions = 2000;
model.TaxablePay = 500;
model.Tax = 1000;
model.NetPay = 50000;
model.StartDate = DateTime.Now;
model.City = "Mulund";
model.Country = "In";
EmployeeRepo repo = new EmployeeRepo();
Console.WriteLine("Displaying All Data");
repo.GetAllEmployee();
bool res = repo.AddEmployee(model);
if (res)
{
Console.WriteLine("Employee Added Successfully");
repo.GetAllEmployee();
}
else
{
Console.WriteLine("Employee isn't Added");
}
Console.WriteLine("Retrieving Employee from StartDate");
EmployeeModel model1 = new EmployeeModel()
{
StartDate = DateTime.Parse("2018-06-26")
};
repo.RetrieveEmployeeBasedOnStartDate(model1);
Console.WriteLine("Retrieving Sum Avg Min Max from Employee");
EmployeeModel model2 = new EmployeeModel()
{
Gender = 'M'
};
repo.FindSumAvgMinMaxSalaryOfEmployee(model2);
}
private static void CompareSequentialWithMultiThreading(EmployeeRepo employeeRepo, MultiThreadedEmployeeRepo threadedEmployeeRepo)
{
List <EmployeeModel> employeeDetailsList = new List <EmployeeModel>();
employeeDetailsList.Add(new EmployeeModel("Batik", "9999999999", "Wuhan", "Research", 'M', 100000, new DateTime(2020, 11, 01)));
employeeDetailsList.Add(new EmployeeModel("Bipasha", "8888112233", "Mumbai", "Media", 'F', 200000, new DateTime(2020, 11, 10)));
employeeDetailsList.Add(new EmployeeModel("Rohit", "9876541230", "Mumbai", "Entertainment", 'M', 150000, new DateTime(2020, 11, 01)));
DateTime startDateTime = DateTime.Now;
employeeRepo.AddMultipleEmployee(employeeDetailsList);
DateTime endDateTime = DateTime.Now;
Console.WriteLine("\tWithout Thread : " + (endDateTime - startDateTime));
startDateTime = DateTime.Now;
threadedEmployeeRepo.AddMultipleEmployee(employeeDetailsList);
endDateTime = DateTime.Now;
Console.WriteLine("\tWith Thread : " + (endDateTime - startDateTime));
}
private static void AddNewEmployee(EmployeeRepo employeeRepo)
{
EmployeeModel employee = new EmployeeModel();
employee.EmployeeName = "Dibya";
employee.Department = "Tech";
employee.PhoneNumber = "6309807918";
employee.Address = "02-Khajauli";
employee.Gender = 'M';
employee.BasicPay = 110000.00M;
employee.Deductions = (SqlMoney)1500.00;
employee.StartDate = employee.StartDate = Convert.ToDateTime("2020-11-03");
if (employeeRepo.AddEmployee(employee))
{
Console.WriteLine("Records added successfully");
}
employeeRepo.RemoveEmployee("Satyam", 6);
}
static void Main(string[] args)
{
Console.WriteLine("welcome to employee payroll");
EmployeeRepo repo = new EmployeeRepo();
EmployeePayroll employee = new EmployeePayroll();
employee.EmployeeName = "harish";
employee.StartDate = Convert.ToDateTime("2020-10-01");
employee.Gender = 'M';
employee.Address = "mumbai";
employee.PhoneNumber = "+91 9866528888";
string query = @"select * from Employee_payroll";
// repo.GetAllEmployee(query);
// repo.UpdateEmployeeAddressUsingStoredProcedure("lokendra","HYD");
//repo.AddEmployeeDetailsUsingStoredProcedure(employee);
//repo.RetrieveAllSalaries();
repo.RemoveAnEmployee();
}
static void Main(string[] args)
{
//Console.WriteLine("Hello World!");
Console.WriteLine("Welcome to Employee Payroll!");
EmployeeRepo repo = new EmployeeRepo();
EmployeeModel employee = new EmployeeModel();
//employee.EmployeeName = "Indal1";
//employee.Department = "Tech1";
//employee.PhoneNumber = "6302907918";
//employee.Address = "02-Khajauli1";
//employee.Gender = 'M';
//employee.BasicPay = 10000.00M;
//employee.Deductions = 1500.00;
//employee.StartDate = employee.StartDate = Convert.ToDateTime("2020-11-03");
if (repo.AddEmployee(employee))
{
Console.WriteLine("Records added successfully");
}
repo.GetAllEmployee();
Console.ReadKey();
}
static void Main(string[] args)
{
Console.WriteLine("Welcome to Employee Payroll Service!");
EmployeeRepo employeeRepo = new EmployeeRepo();
EmployeeModel employeeModel = new EmployeeModel();
SalaryUpdateModel updateModel = new SalaryUpdateModel();
///Get All Employee present in Employee_Payroll table
employeeRepo.GetAllEmployee();
///Update Employee Salary
employeeModel.SalaryId = 1;
employeeModel.SalaryMonth = "Jan";
employeeModel.Salary = 500000.00;
employeeModel.EmpId = 2;
employeeRepo.UpdateEmployeeSalary(updateModel);
///Get All Employee in a particular data range
employeeRepo.GetAllEmployeeInADataRange();
///Get data by Gender
employeeRepo.GetDataByGroupByGender();
///Add Employee Details
employeeModel.EmpName = "Appu";
employeeModel.Salary = 500000.00;
employeeModel.Start_Date = Convert.ToDateTime("12/05/2020");
employeeModel.Gender = 'F';
employeeModel.Phone_Number = "9877553212";
employeeModel.Employee_Address = "Kharadi";
employeeModel.Department = "Tetsing";
employeeModel.Basic_Pay = 8765.00;
employeeModel.Deductions = 9876.00;
employeeModel.Taxable_Pay = 97765.00;
employeeModel.Income_Tax = 7654.00;
employeeModel.Net_Pay = 6543.00;
employeeModel.EmpId = 6;
employeeModel.DeptId = 7;
employeeModel.DeptName = "Development";
employeeModel.DeptLocation = "Pune";
employeeModel.SalaryMonth = "Jan";
///Add Employee in Employee_Payroll table
employeeRepo.AddEmployee(employeeModel);
///Remove particular employee entry using EmpId
employeeRepo.RemoveEmployee();
///Get Employee Details present in Employee table
employeeRepo.GetAllEmployeeDetails();
///Get Department details from Department table
employeeRepo.GetAllDepartment();
///Get Salary of Employee from Salary table
employeeRepo.GetEmployeeSalary();
///Get Data by Gender using joins
employeeRepo.GetDataByGroupByGenderER();
Console.WriteLine("Employee Payroll using Threads");
///retrieve url
string[] words = CreateWordArray(@"http://www.gutenberg.org/files/54700/54700-0.txt");
#region ParallelTasks
Parallel.Invoke
(() =>
{
Console.WriteLine("Begin First Task...");
GetLongestWord(words);
},
() =>
{
Console.WriteLine("Begin Second Task...");
GetMostCommonWords(words);
}, //close second action
() =>
{
Console.WriteLine("Begin Third Task...");
GetCountForWord(words, "Sleep");
} //close third action
); //close parallel.invoke
#endregion
}
static void Main(string[] args)
{
Console.WriteLine("Welcome To Employee Payroll Service System");
EmployeeRepo repo = new EmployeeRepo();
int loop = 1;
while (loop == 1)
{
Console.WriteLine("Choose \n1. View all records \n2. Add record \n3. Update salary \n4. Retrieve information from name \n5. Retrieve Employees with joining date in a range \n6. Sum of basic pay gender wise \n7. Average of basic pay gender wise \n8. Minimum basic pay gender wise \n9. Maximum basic pay gender wise \n10. Count of employees gender wise \n11. Remove emloyee from active employees \n12. Exit");
int choice = Convert.ToInt32(Console.ReadLine());
switch (choice)
{
case 1:
List <EmployeeModel> employeeList = repo.GetAllEmployee();
foreach (EmployeeModel employeeModel in employeeList)
{
System.Console.WriteLine(employeeModel.EmployeeName + " " + employeeModel.BasicPay + " " + employeeModel.StartDate + " " + employeeModel.Gender + " " + employeeModel.PhoneNumber + " " + employeeModel.Address + " " + employeeModel.Department + " " + employeeModel.Deductions + " " + employeeModel.TaxablePay + " " + employeeModel.Tax + " " + employeeModel.NetPay);
System.Console.WriteLine("\n");
}
break;
case 2:
Console.WriteLine("Enter number of employees to be added");
int noOfEmployeesAdded = Convert.ToInt32(Console.ReadLine());
List <EmployeeModel> list = new List <EmployeeModel>();
while (noOfEmployeesAdded >= 1)
{
EmployeeModel employee = new EmployeeModel();
Console.WriteLine("Enter Name");
employee.EmployeeName = Console.ReadLine();
Console.WriteLine("Enter Phone Number");
employee.PhoneNumber = Console.ReadLine();
Console.WriteLine("Enter Address");
employee.Address = Console.ReadLine();
Console.WriteLine("Enter Gender");
employee.Gender = Convert.ToChar(Console.ReadLine());
Console.WriteLine("Enter Basic Pay");
employee.BasicPay = Convert.ToDecimal(Console.ReadLine());
Console.WriteLine("Enter Start date");
employee.StartDate = Convert.ToDateTime(Console.ReadLine());
Console.WriteLine("Enter Department");
employee.Department = Console.ReadLine();
Console.WriteLine("Enter department id");
employee.DepartmentId = Convert.ToInt32(Console.ReadLine());
noOfEmployeesAdded--;
list.Add(employee);
}
noOfEmployeesAdded = repo.AddMultipleEmployeesUsingThread(list);
break;
case 3:
Console.WriteLine("Enter Name");
string name = Console.ReadLine();
Console.WriteLine("Enter Basic Pay");
double salary = Convert.ToDouble(Console.ReadLine());
bool result = repo.UpdateSalary(name, salary);
Console.WriteLine(result == true ? "Salary Updated" : "Salary cannot be updated");
break;
case 4:
Console.WriteLine("Enter Name");
string employeeName = Console.ReadLine();
List <EmployeeModel> employeeNameList = repo.RetrieveDataByName(employeeName);
foreach (EmployeeModel employeeInfo in employeeNameList)
{
System.Console.WriteLine(employeeInfo.EmployeeName + " " + employeeInfo.BasicPay + " " + employeeInfo.StartDate + " " + employeeInfo.Gender + " " + employeeInfo.PhoneNumber + " " + employeeInfo.Address + " " + employeeInfo.Department + " " + employeeInfo.Deductions + " " + employeeInfo.TaxablePay + " " + employeeInfo.Tax + " " + employeeInfo.NetPay);
System.Console.WriteLine("\n");
}
break;
case 5:
Console.WriteLine("Enter Start date");
DateTime startDate = Convert.ToDateTime(Console.ReadLine());
Console.WriteLine("Enter End date");
DateTime endDate = Convert.ToDateTime(Console.ReadLine());
List <EmployeeModel> employeeWithStartDateList = repo.RetrieveEmployeesWithParticularDateRange(startDate.ToString("yyyy-MM-dd"), endDate.ToString("yyyy-MM-dd"));
foreach (EmployeeModel employeeModel in employeeWithStartDateList)
{
System.Console.WriteLine(employeeModel.EmployeeName + " " + employeeModel.BasicPay + " " + employeeModel.StartDate + " " + employeeModel.Gender + " " + employeeModel.PhoneNumber + " " + employeeModel.Address + " " + employeeModel.Department + " " + employeeModel.Deductions + " " + employeeModel.TaxablePay + " " + employeeModel.Tax + " " + employeeModel.NetPay);
System.Console.WriteLine("\n");
}
break;
case 6:
repo.SumOfSalaryGenderWise();
break;
case 7:
repo.AverageOfSalaryGenderWise();
break;
case 8:
repo.MinimumSalaryGenderWise();
break;
case 9:
repo.MaximumSalaryGenderWise();
break;
case 10:
repo.CountOfEmployeesGenderWise();
break;
case 11:
Console.WriteLine("Enter employee Id of employee to be removed");
int empId = Convert.ToInt32(Console.ReadLine());
bool employeeRemoved = repo.RemoveEmployee(empId);
if (employeeRemoved)
{
Console.WriteLine("Employee Removed successfully");
}
break;
case 12:
loop = 0;
break;
}
}
}
static void Main(string[] args)
{
Console.WriteLine("Welcome to Employee Payroll Service!");
EmployeeRepo.GetAllEmployee();
/*
* //update salary
* var salaryUpdateModel = new SalaryUpdateModel { SalaryId = 1, EmployeeSalary = 30000000 };
* var salaryObj = new Salary();
* var salary = salaryObj.UpdateEmployeeSalary(salaryUpdateModel);
* salaryObj.UpdateMultipleSalariesUsingThreads(new List<SalaryUpdateModel> { salaryUpdateModel });
*/
//Console.WriteLine(salary);
/*
* //Retreiving Employees In a date range
* var startDate = Convert.ToDateTime("01/01/2018");
* var endDate = Convert.ToDateTime("01/01/2019");
*
* EmployeeRepo.GetAllEmployeeInDateRange(startDate, endDate);
*/
//EmployeeRepo.ExecuteAggregateFunctions();
/*
* //Adding employee with stored procedure
* var empModel = new EmployeeModel { EmployeeName = "Iron Man", Salary = 1300,Gender='M',PhoneNumber="5454545",
* StartDate=Convert.ToDateTime("01/01/2019"),Address="In the sky full of starts",Department="Legal"};
* var employeePayroll = new EmployeePayroll { employeeModel = empModel};
* EmployeeRepo.AddEmployee(employeePayroll);
*/
/*
* //Removing an employee
* EmployeeRepo.RemoveEmployee(5);
*/
//Adding Multiple Employees
var employees = new List <EmployeePayroll> {
new EmployeePayroll {
employeeModel = new EmployeeModel {
EmployeeName = "Steel Man", Salary = 1000000, Gender = 'M', PhoneNumber = "5454545",
StartDate = Convert.ToDateTime("01/01/2019"), Address = "In the sky full of starts", Department = "Legal"
}
},
new EmployeePayroll {
employeeModel = new EmployeeModel {
EmployeeName = "Copper Man", Salary = 1000000, Gender = 'M', PhoneNumber = "5454545",
StartDate = Convert.ToDateTime("01/01/2019"), Address = "In the sky full of starts", Department = "Legal"
}
},
new EmployeePayroll {
employeeModel = new EmployeeModel {
EmployeeName = "Aluminium Man", Salary = 1000000, Gender = 'M', PhoneNumber = "5454545",
StartDate = Convert.ToDateTime("01/01/2019"), Address = "In the sky full of starts", Department = "Legal"
}
}
};
EmployeeRepo.AddMultipleEmployees(employees);
EmployeeRepo.AddMultipleEmployeesUsingThreads(employees);
}
