public static void SaveDepartments() { List <Department> departmentsList = new List <Department>(); departmentsList = SoapUtils.GetDepartmentsFromSoap(); string departmentsTable = System.Configuration.ConfigurationManager.ConnectionStrings["DepartmentsTable"].ConnectionString; DbUtils.SaveDepartmentsToDb(departmentsTable, departmentsList); }
public static void SaveEmployees() { List <Employee> employeeList = new List <Employee>(); employeeList = SoapUtils.GetEmployeesFromSoap(); string employeesTable = System.Configuration.ConfigurationManager.ConnectionStrings["EmployeesTable"].ConnectionString; DbUtils.SaveEmployeesToDb(employeesTable, employeeList); }
public static void SaveProjects() { List <Project> projectsList = new List <Project>(); projectsList = SoapUtils.GetProjectFromSoap(); string projectsTable = System.Configuration.ConfigurationManager.ConnectionStrings["ProjectsTable"].ConnectionString; DbUtils.SaveProjectsToDb(projectsTable, projectsList); }
public static void SaveInvoiceLines(DateTime?startDate, DateTime?endDate) { List <InvoiceLine> invoiceLinesList = new List <InvoiceLine>(); invoiceLinesList = SoapUtils.GetInvoiceLinesFromSoap(startDate, endDate); string invoiceLinesTable = System.Configuration.ConfigurationManager.ConnectionStrings["InvoiceLinesTable"].ConnectionString; DbUtils.SaveInvoiceLinesToDb(invoiceLinesTable, startDate, endDate, invoiceLinesList); }
public static void SaveWorkUnits(DateTime?startDate, DateTime?endDate) { List <WorkUnit> workUnitsList = new List <WorkUnit>(); workUnitsList = SoapUtils.GetWorkUnitsFromSoap(startDate, endDate); string workUnitsTable = System.Configuration.ConfigurationManager.ConnectionStrings["WorkUnitsTable"].ConnectionString; DbUtils.SaveWorkUnitsToDb(workUnitsTable, startDate, endDate, workUnitsList); }