public bool addEmployee(employeeBO obj)
{
bool addEmployee = false;
int eidIncrement = getEmployeeID();
eidIncrement++;
SqlConnection s = new SqlConnection(connectionString);
string query = "insert into employees (eid,name,salary,bonusRatio,tax,designation) Values ('" + eidIncrement + "','" + obj.empName + "','" + obj.empSalary + "', '" + obj.empBonusRatio + "','" + obj.empTax + "','" + obj.empDesignation + "')";
SqlCommand cmd = new SqlCommand(query, s);
s.Open();
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
addEmployee = true;
}
else
{
addEmployee = false;
}
return(addEmployee);
}
private bool editEmployee()
{
int id = 0;
bool wrongDesignation = false;
string temp = "";
int temp1 = 0;
string employeeName = "", employeeDesignation = "";
double employeeSalary = 0;
Console.Write(" Enter ID :");
temp = Console.ReadLine();
Int32.TryParse(temp, out temp1);
id = temp1;
Console.Write(" Enter Name :");
employeeName = Console.ReadLine();
Console.Write(" Enter Designation :");
employeeDesignation = Console.ReadLine();
Console.Write(" Enter Salary :");
temp = Console.ReadLine();
Int32.TryParse(temp, out temp1);
employeeSalary = Convert.ToDouble(temp1);
employeeBO employeeBo = new employeeBO(id, employeeName, employeeSalary, employeeDesignation);
wrongDesignation = bll.editEmployee(employeeBo);
return(wrongDesignation);
}
public bool addEmployeeDetails(employeeBO obj)
{
wrongDesignation = false;
if (obj.empDesignation == "manager")
{
double tax = (15 * obj.empSalary) / 100;
obj.empTax = tax;
double bonus = (10 * obj.empSalary) / 100;
obj.empBonusRatio = bonus;
}
else if (obj.empDesignation == "Manager")
{
double tax = (15 * obj.empSalary) / 100;
obj.empTax = tax;
double bonus = (10 * obj.empSalary) / 100;
obj.empBonusRatio = bonus;
}
else if (obj.empDesignation == "developer")
{
double tax = (12 * obj.empSalary) / 100;
obj.empTax = tax;
double bonus = (50 * obj.empSalary) / 100;
obj.empBonusRatio = bonus;
}
else if (obj.empDesignation == "Developer")
{
double tax = (12 * obj.empSalary) / 100;
obj.empTax = tax;
double bonus = (50 * obj.empSalary) / 100;
obj.empBonusRatio = bonus;
}
else if (obj.empDesignation == "HR")
{
double tax = (10 * obj.empSalary) / 100;
obj.empTax = tax;
double bonus = (20 * obj.empSalary) / 100;
obj.empBonusRatio = bonus;
}
else if (obj.empDesignation == "hr")
{
double tax = (10 * obj.empSalary) / 100;
obj.empTax = tax;
double bonus = (20 * obj.empSalary) / 100;
obj.empBonusRatio = bonus;
}
else
{
wrongDesignation = true;
}
return(wrongDesignation);
}
public bool addEmployee(employeeBO obj)
{
bool wrongDesignation = false;
wrongDesignation = addEmployeeDetails(obj);
if (wrongDesignation == true)
{
}
else
{
adal.addEmployee(obj);
}
return(wrongDesignation);
}
public bool editEmployee(employeeBO obj)
{
bool employeeDesignation = false;
amendEmployee(obj);
employeeDesignation = addEmployeeDetails(obj);
if (employeeDesignation == true)
{
}
else
{
adal.editEmployee(obj);
}
return(employeeDesignation);
}
private bool addEmployee()
{
bool addEmployee = false;
string temp = "";
bool wrongDesignation = false;
int choose = 0;
int temp1 = 0;
string employeeName = "", employeeDesignation = "";
double employeeSalary = 0;
Console.Write(" Enter Name :");
employeeName = Console.ReadLine();
Console.Write(" Enter Designation :");
employeeDesignation = Console.ReadLine();
Console.Write(" Enter Salary :");
temp = Console.ReadLine();
Int32.TryParse(temp, out temp1);
employeeSalary = Convert.ToDouble(temp1);
Console.WriteLine("");
Console.WriteLine("");
Console.WriteLine("");
Console.WriteLine(" Press 1 to save the data.");
Console.WriteLine(" Press 2 to cancel.");
Console.WriteLine("");
Console.WriteLine("");
int[] arr = { 1, 2 };
Console.Write(" Enter choice: ");
choose = getRightOption(arr);
if (choose == 1)
{
employeeBO employeeBo = new employeeBO(employeeName, employeeSalary, employeeDesignation);
wrongDesignation = bll.addEmployee(employeeBo);
}
else if (choose == 2)
{
addEmployee = false;
}
else
{
}
return(wrongDesignation);
}
public void editEmployee(employeeBO obj)
{
SqlConnection s = new SqlConnection(connectionString);
string query = "select * from employees where eid= '" + obj.id + "'";
SqlCommand cmd = new SqlCommand(query, s);
s.Open();
int check = 0;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
check = 1;
}
if (check == 0)
{
Console.WriteLine("");
Console.WriteLine("");
Console.WriteLine(" ** No such employee exists. ** ");
}
else if (check == 1)
{
SqlConnection b = new SqlConnection(connectionString);
string query1 = "update employees set name= '" + obj.empName + "' , salary= '" + obj.empSalary + "', bonusRatio = '" + obj.empBonusRatio + "' , tax= '" + obj.empTax + "', designation= '" + obj.empDesignation + "' where eid= '" + obj.id + "' ";
cmd = new SqlCommand(query1, b);
b.Open();
cmd.ExecuteNonQuery();
b.Close();
Console.WriteLine("");
Console.WriteLine("");
Console.WriteLine(" ** New data is saved ** ");
check = 1;
}
s.Close();
}
public void amendEmployee(employeeBO obj)
{
SqlConnection s = new SqlConnection(connectionString);
if (obj.empName.Length == 0)
{
string query = "select name from employees where eid= '" + obj.id + "' ";
SqlCommand cmd = new SqlCommand(query, s);
s.Open();
SqlDataReader dr = cmd.ExecuteReader();
obj.empName = dr[0].ToString();
}
if (obj.empDesignation.Length == 0)
{
string query = "select * from employees where eid= '" + obj.id + "' ";
SqlCommand cmd = new SqlCommand(query, s);
s.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
obj.empDesignation = dr[5].ToString();
}
}
if (obj.empSalary == 0)
{
string query = "select * from employees where eid= '" + obj.id + "' ";
SqlCommand cmd = new SqlCommand(query, s);
s.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
obj.empSalary = int.Parse(dr[2].ToString());
}
}
}
