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