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