public void SaveEmployee(Employee employee) { Console.WriteLine("SaveEmployee Called @: " + DateTime.Now); _lastSavedEmployee = employee; string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spSaveEmployee", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter { ParameterName = "@Id", Value = employee.Id }; cmd.Parameters.Add(parameterId); SqlParameter parameterName = new SqlParameter { ParameterName = "@Name", Value = employee.Name }; cmd.Parameters.Add(parameterName); //SqlParameter parameterGender = new SqlParameter //{ // ParameterName = "@Gender", // Value = employee.Gender //}; //cmd.Parameters.Add(parameterGender); SqlParameter parameterDateOfBirth = new SqlParameter { ParameterName = "@DateOfBirth", Value = employee.DateOfBirth }; cmd.Parameters.Add(parameterDateOfBirth); SqlParameter parameterEmployeeType = new SqlParameter { ParameterName = "@EmployeeType", Value = employee.Type }; cmd.Parameters.Add(parameterEmployeeType); if (employee.GetType() == typeof(FullTimeEmployee)) { SqlParameter parameterAnnualSalary = new SqlParameter { ParameterName = "@AnnualSalary", Value = ((FullTimeEmployee)employee).AnnualSalary }; cmd.Parameters.Add(parameterAnnualSalary); } else if (employee.GetType() == typeof(PartTimeEmployee)) { SqlParameter parameterHourlyPay = new SqlParameter { ParameterName = "@HourlyPay", Value = ((PartTimeEmployee)employee).HourlyPay, }; cmd.Parameters.Add(parameterHourlyPay); SqlParameter parameterHoursWorked = new SqlParameter { ParameterName = "@HoursWorked", Value = ((PartTimeEmployee)employee).HoursWorked }; cmd.Parameters.Add(parameterHoursWorked); } con.Open(); cmd.ExecuteNonQuery(); } }
public void SaveEmployee(Employee employee) { string cs = ConfigurationManager.ConnectionStrings["cdkConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spSaveEmployee", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter { ParameterName = "@Id", Value = employee.Id }; cmd.Parameters.Add(parameterId); SqlParameter parameterName = new SqlParameter { ParameterName = "@Name", Value = employee.Name }; cmd.Parameters.Add(parameterName); SqlParameter parameterGender = new SqlParameter { ParameterName = "@Gender", Value = employee.Gender }; cmd.Parameters.Add(parameterGender); SqlParameter parameterDateOfBirth = new SqlParameter { ParameterName = "@DateOfBirth", Value = employee.DateOfBirth }; cmd.Parameters.Add(parameterDateOfBirth); SqlParameter parameterEmployeeType = new SqlParameter { ParameterName = "@EmployeeType", Value = employee.Type }; cmd.Parameters.Add(parameterEmployeeType); if (employee.GetType() == typeof(FullTimeEmployee)) { SqlParameter parameterAnnualSalary = new SqlParameter { ParameterName = "@AnnualSalary", Value = ((FullTimeEmployee)employee).AnnualSalary }; cmd.Parameters.Add(parameterAnnualSalary); } else { SqlParameter parameterHourlyPay = new SqlParameter { ParameterName = "@HourlyPay", Value = ((PartTimeEmployee)employee).Hourlypay }; cmd.Parameters.Add(parameterHourlyPay); SqlParameter parameterHoursWorked = new SqlParameter { ParameterName = "@HoursWorked", Value = ((PartTimeEmployee)employee).HoursWorked }; cmd.Parameters.Add(parameterHoursWorked); } con.Open(); cmd.ExecuteNonQuery(); } }
public void SaveEmployee(Employee employee) { string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spSaveEmployee", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter { ParameterName = "@Id", Value = employee.Id }; cmd.Parameters.Add(parameterId); SqlParameter parameterName = new SqlParameter { ParameterName = "@Name", Value = employee.Name }; cmd.Parameters.Add(parameterName); SqlParameter parameterGender = new SqlParameter { ParameterName = "@Gender", Value = employee.Gender }; cmd.Parameters.Add(parameterGender); SqlParameter parameterDateOfBirth = new SqlParameter { ParameterName = "@DateOfBirth", Value = employee.DateOfBirth }; cmd.Parameters.Add(parameterDateOfBirth); // extending this method with new parameters SqlParameter parameterEmployeeType = new SqlParameter { ParameterName = "@EmployeeType", Value = employee.Type }; cmd.Parameters.Add(parameterEmployeeType); //if fullTimeEmployee if (employee.GetType() == typeof(FullTimeEmployee)) { SqlParameter parameterAnnualSalary = new SqlParameter { ParameterName = "@AnnualSalary", Value = ((FullTimeEmployee)employee).AnnualSalary }; cmd.Parameters.Add(parameterAnnualSalary); } else { SqlParameter parameterHourlyPay = new SqlParameter { ParameterName = "@HourlyPay", Value = ((PartTimeEmployee)employee).HourlyPay, }; cmd.Parameters.Add(parameterHourlyPay); SqlParameter parameterHoursWorked = new SqlParameter { ParameterName = "@HoursWorked", Value = ((PartTimeEmployee)employee).HoursWorked }; cmd.Parameters.Add(parameterHoursWorked); } con.Open(); cmd.ExecuteNonQuery(); } }
public void SetEmployee(Employee employee) { // 1- Parepare the connection string cs = ConfigurationManager.ConnectionStrings["DDBC"].ConnectionString; using(SqlConnection conn = new SqlConnection(cs)) { // 2- Setup the command type SqlCommand cmd = new SqlCommand("spSaveEmployee", conn); cmd.CommandType = CommandType.StoredProcedure; // 3- Add the parameters SqlParameter parameterId = new SqlParameter() { ParameterName = "@Id", Value = employee.Id }; SqlParameter parameterName = new SqlParameter() { ParameterName = "@Name", Value = employee.Name }; SqlParameter parameterDateOfBirth = new SqlParameter() { ParameterName = "@DateOfBirth", Value = employee.DateOfBirth.ToShortDateString() }; SqlParameter parameterEmployeeType = new SqlParameter() { ParameterName = "@EmployeeType", Value = employee.Type }; cmd.Parameters.Add(parameterId); cmd.Parameters.Add(parameterName); cmd.Parameters.Add(parameterDateOfBirth); cmd.Parameters.Add(parameterEmployeeType); if (employee.GetType() == typeof(FullTimeEmployee)) { SqlParameter parameterAnnualSalary = new SqlParameter() { ParameterName = "@AnnualSalary", Value = ((FullTimeEmployee)employee).AnnualSalary }; cmd.Parameters.Add(parameterAnnualSalary); } else { SqlParameter parameterHourlyPay = new SqlParameter() { ParameterName = "@HourlyPay", Value = ((PartTimeEmployee)employee).HourlyPay }; SqlParameter parameterHoursWorked = new SqlParameter() { ParameterName = "@HoursWorked", Value = ((PartTimeEmployee)employee).HoursWorked }; cmd.Parameters.Add(parameterHourlyPay); cmd.Parameters.Add(parameterHoursWorked); } // 4- Open and Execute conn.Open(); cmd.ExecuteNonQuery(); } }
public void SaveEmployee(Employee employee) { string cs = ConfigurationManager.ConnectionStrings["subhasishConnectionString"].ConnectionString; _lastSavedEmployee = employee; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spSaveEmployee", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter parameterId = new SqlParameter() { ParameterName = "@Id", Value = employee.Id }; cmd.Parameters.Add(parameterId); SqlParameter parameterName = new SqlParameter() { ParameterName = "@Name", Value = employee.Name }; cmd.Parameters.Add(parameterName); //SqlParameter parameterGender = new SqlParameter() //{ // ParameterName = "@Gender", // Value = employee.Gender //}; //cmd.Parameters.Add(parameterGender); SqlParameter parameterDateOfBirth = new SqlParameter() { ParameterName = "@DateOfBirth", Value = employee.DateOfBirth }; cmd.Parameters.Add(parameterDateOfBirth); SqlParameter parameterEmployeeType = new SqlParameter() { ParameterName = "@EmployeeType", Value = employee.Type }; cmd.Parameters.Add(parameterEmployeeType); if (employee.GetType() == typeof(FullTimeEmployee)) { SqlParameter parameterAnnualSalary = new SqlParameter() { ParameterName = "@AnnualSalary", Value = ((FullTimeEmployee)employee).AnnualSalary }; cmd.Parameters.Add(parameterAnnualSalary); } else { SqlParameter parameterHourlyPay = new SqlParameter() { ParameterName = "@HourlyPay", Value = ((PartTimeEmployee)employee).HourlyPay }; cmd.Parameters.Add(parameterHourlyPay); SqlParameter parameterHoursWorked = new SqlParameter() { ParameterName = "@HoursWorked", Value = ((PartTimeEmployee)employee).HoursWorked }; cmd.Parameters.Add(parameterHoursWorked); SqlParameter parameterCity = new SqlParameter() { ParameterName = "@City", Value = employee.City }; cmd.Parameters.Add(parameterCity); } con.Open(); cmd.ExecuteNonQuery(); } }