public void Run()
{
SalaryProcess salaryProcess = ProcessUtils.CreateSalaryProcess(_entry);
if (salaryProcess.Run())
{
SaveProcess(salaryProcess);
}
}
private void SaveProcess(SalaryProcess process)
{
const string connectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=unSysVovk;Integrated Security=True";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand cm = new SqlCommand();
cm.Connection = conn;
using (conn)
{
conn.Open();
using (cm)
{
cm.CommandText = "INSERT INTO Process (Data,EntryId,DataType) VALUES ('" + process.Data + "','" + process.Id + "','" + process.DataType + "')";
cm.ExecuteNonQuery();
}
}
}
public void DeleteTempEmpListSalary()
{
SalaryProcess.DeleteTempEmpListSalary();
}
public CustomList <SalaryProcess> deleteProcessedSalary(string tableName, string YearNo, string MonthNo)
{
return(SalaryProcess.deleteProcessedSalary(tableName, YearNo, MonthNo));
}
public CustomList <SalaryProcess> doSalaryProcess(string spName, string YearNo, string MonthNo, string FromDate, string Todate, string tableName)
{
return(SalaryProcess.doSalaryProcess(spName, YearNo, MonthNo, FromDate, Todate, tableName));
}
