//Add Data To the Employees Using Stored Procedure
public bool AddEmployee(EmployeeDetails employeeDetails)
{
SqlCommand command = new SqlCommand("SpAddEmployeeDetails", this.connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@EmployeeName", employeeDetails.EmployeeName);
command.Parameters.AddWithValue("@PhoneNumber", employeeDetails.PhoneNumber);
command.Parameters.AddWithValue("@Address", employeeDetails.Address);
command.Parameters.AddWithValue("@Department", employeeDetails.Department);
command.Parameters.AddWithValue("@Gender", employeeDetails.Gender);
command.Parameters.AddWithValue("@BasicPay", employeeDetails.Salary);
command.Parameters.AddWithValue("@Deductions", employeeDetails.Deduction);
command.Parameters.AddWithValue("@TaxablePay", employeeDetails.Taxable_Pay);
command.Parameters.AddWithValue("@Tax", employeeDetails.Income_Tax);
command.Parameters.AddWithValue("@NetPay", employeeDetails.Net_Pay);
command.Parameters.AddWithValue("@StartDate", DateTime.Now);
try
{
this.connection.Open();
var result = command.ExecuteNonQuery();
if (result != 0)
{
return(true);
}
return(false);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
this.connection.Close();
}
return(false);
}
