public void SaveCL(string txtShipID) { using (SqlCommand cmd = new SqlCommand("payroll.[dbo].[sp_CL_Insert]", sql.SQLConnReturn())) { sql.SQLOpen(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = txtShipID; cmd.ExecuteNonQuery(); sql.SQLClose(); } }
public void SavePayrollHeader(DateTime dateFrom, DateTime dateTo, string description) { using (SqlCommand cmd = new SqlCommand("payroll.[dbo].[sp_PayrollHeader_Insert]", sql.SQLConnReturn())) { sql.SQLOpen(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@date_from", SqlDbType.Date).Value = dateFrom; cmd.Parameters.Add("@date_to", SqlDbType.Date).Value = dateTo; cmd.Parameters.Add("@description", SqlDbType.VarChar).Value = description; cmd.ExecuteNonQuery(); sql.SQLClose(); } }
public void SaveCall(string txtShip, string txtPort, DateTime txtDate) { using (SqlCommand cmd = new SqlCommand("payroll.[dbo].[sp_Call_Insert]", sql.SQLConnReturn())) { sql.SQLOpen(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ship", SqlDbType.VarChar).Value = txtShip; cmd.Parameters.Add("@date", SqlDbType.Date).Value = txtDate; cmd.Parameters.Add("@FK_PortID", SqlDbType.VarChar).Value = txtPort; cmd.ExecuteNonQuery(); sql.SQLClose(); } }
public void SavePayrollLine(string intHeader, string txtCallID, string txtEmployeeID, string txtTourID) { using (SqlCommand cmd = new SqlCommand("payroll.[dbo].[sp_PayrollLine_Insert]", sql.SQLConnReturn())) { sql.SQLOpen(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@HeaderID", SqlDbType.VarChar).Value = intHeader; cmd.Parameters.Add("@callId", SqlDbType.VarChar).Value = txtCallID; cmd.Parameters.Add("@employeeID", SqlDbType.VarChar).Value = txtEmployeeID; cmd.Parameters.Add("@tourID", SqlDbType.VarChar).Value = txtTourID; cmd.ExecuteNonQuery(); sql.SQLClose(); } }
public void SaveEmployee(string txtFirstName, string txtLastName, string txtEmail, string txtEmpID, string txtEmpType) { SqlCommand cmd = new SqlCommand("payroll.[dbo].[sp_Employees_Insert]", sql.SQLConnReturn()); sql.SQLOpen(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = txtFirstName; cmd.Parameters.Add("@lastName", SqlDbType.VarChar).Value = txtLastName; cmd.Parameters.Add("@emailAddress", SqlDbType.VarChar).Value = txtEmail; cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = txtEmpID; cmd.Parameters.Add("@type", SqlDbType.VarChar).Value = txtEmpType; cmd.ExecuteNonQuery(); sql.SQLClose(); }
public void SaveTour(string txtTourID, string txtPort, string txtTourName, decimal decimalRate) { Math.Round(decimalRate, 2); using (SqlCommand cmd = new SqlCommand("payroll.[dbo].[sp_Tour_Insert]", sql.SQLConnReturn())) { sql.SQLOpen(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tourID", SqlDbType.VarChar).Value = txtTourID; cmd.Parameters.Add("@port", SqlDbType.VarChar).Value = txtPort; cmd.Parameters.Add("@tourName", SqlDbType.VarChar).Value = txtTourName; cmd.Parameters.Add("@Rate", SqlDbType.Decimal).Value = decimalRate; cmd.ExecuteNonQuery(); sql.SQLClose(); } }