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 generatePayrollFile(string ID) { //string text = System.IO.File.ReadAllText("C:\\Payroll\\FileLoaction.txt"); //using (StreamWriter writer = new StreamWriter(text + "payroll_" + DateTime.Now.ToString("yyyy-dd-M") + ".txt")) using (StreamWriter writer = new StreamWriter("C:\\Users\\phil\\Documents\\payroll_" + DateTime.Now.ToString("yyyy-dd-M") + ".txt")) { SQLConn sql = new SQLConn(); sql.SQLOpen(); SqlCommand cmd = new SqlCommand("payroll.[dbo].[sp_PayrollTotal_Get]", sql.SQLConnReturn()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@id", SqlDbType.VarChar).Value = ID; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { writer.WriteLine(reader["employeeID"] + "," + reader["1099"] + "," + reader["w-2"] + "," + reader["salary"]); } } }
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(); } }
public void test() { using (StreamWriter writer = new StreamWriter("C:\\Users\\phil\\Documents\\payroll.txt")) { writer.WriteLine("test2"); SQLConn sql = new SQLConn(); sql.SQLOpen(); SqlCommand cmd = new SqlCommand("payroll.[dbo].[sp_Employees_Get_All]", sql.SQLConnReturn()); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { writer.WriteLine(reader["FirstName"]); } } }