public async Task <IActionResult> GetCustomerDetailsAsync()
{
var custs = _context.GetCustomerListAsync().Result;
using (SqlConnection con = new SqlConnection(ConnectionString))
{
try
{
con.Open();
foreach (DataLayer.Models.TempWorksDB.CustomerList c in custs)
{
try
{
Customer cust = await TempWorksAPI.GetCustomerFromTempworksAsync(c.CustomerId);
DataLayer.TempWorks.AddCustomerProc(con, cust, 0, true);
_context.SaveErrorProc(con, "Updated Customer" + cust.CustomerId.ToString(), "");
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error Updating Customer " + c.CustomerId.ToString(), ex.Message);
}
}
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error adding Customer", ex.Message);
return(BadRequest(ex.Message));
}
}
return(Ok());
}
public async Task <IActionResult> GetServiceReps()
{
using (SqlConnection con = new SqlConnection(ConnectionString))
{
con.Open();
try
{
ServiceReps res = await TempWorksAPI.GetServiceRepsFromTempworksAsync();
foreach (ServiceRep rep in res.data)
{
try
{
DataLayer.TempWorks.AddServiceRepProc(con, rep);
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error servicerep " + rep.serviceRepFullName.ToString(), ex.Message);
}
}
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error JobOrder", ex.Message);
return(BadRequest(ex.Message));
}
}
return(Ok());
}
public async Task <IActionResult> GetJobOrders()
{
using (SqlConnection con = new SqlConnection(ConnectionString))
{
con.Open();
try
{
JobOrders jobs = await TempWorksAPI.SearchJobOrdersFromTempworksAsync();
foreach (JobOrder job in jobs.data)
{
try {
JobDetail detail = await TempWorksAPI.GetJobOrderDetailFromTempworksAsync(job.orderId);
DataLayer.TempWorks.AddJobOrderProc(con, detail, true);
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error JobOrder " + job.orderId.ToString(), ex.Message);
}
}
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error JobOrder", ex.Message);
return(BadRequest(ex.Message));
}
}
return(Ok());
}
public async Task <IActionResult> GetMasterAllEmployeesAndDetails()
{
var emps = await TempWorksAPI.SearchEmployeeFromTempworksAsync();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
con.Open();
foreach (Employee emp in emps.data)
{
// add basic employee without replace
DataLayer.TempWorks.AddEmployeeProc(con, emp, false);
// get their messages
Messages msgs = await TempWorksAPI.GetEmployeeMessagesTempworksAsync(emp.employeeId);
if (msgs != null)
{
foreach (Message msg in msgs.data)
{
DataLayer.TempWorks.AddMessageProc(con, msg);
}
}
Documents docs = await TempWorksAPI.GetEmployeeDocsFromTempworksAsync(emp.employeeId);
if (docs != null)
{
foreach (Document doc in docs.data)
{
DataLayer.TempWorks.AddDocumentProc(con, emp.employeeId, doc);
}
}
}
}
return(Ok());
}
public async Task <IActionResult> GetCustomerDepartments()
{
Customers custs = await TempWorksAPI.SearchCustomersFromTempworksAsync();
string conStr = "Server=employnetdata.database.windows.net;Database=DataSurf;Trusted_Connection=false;User Id=employnet;password=Employ1Now!";
using (SqlConnection con = new SqlConnection(conStr))
{
try
{
con.Open();
foreach (Customer cust in custs.data)
{
try
{
await DataLayer.TempWorks.AddDepartmentCustomerProc(con, null, cust.CustomerId, true);
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error Updating Customer " + cust.CustomerId.ToString(), ex.Message);
}
}
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error adding Departments", ex.Message);
return(BadRequest(ex.Message));
}
}
return(Ok());
}
public async Task <IActionResult> GetAllAssignments()
{
using (SqlConnection con = new SqlConnection(ConnectionString))
{
con.Open();
try
{
Assignments rets = await TempWorksAPI.SearchAssignmentFromTempworksAsync();
foreach (Assignment ass in rets.data)
{
DataLayer.TempWorks.AddAssignmentProc(con, ass);
if (ass.jobOrderId != 0)
{
WorkSite site = await TempWorksAPI.GetWorksiteFromTempworksAsync(ass.jobOrderId);
DataLayer.TempWorks.AddWorkSiteProc(con, site, DataLayer.TempWorks.AddAddressProc(con, site.address));
}
}
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error in employees", ex.Message);
return(BadRequest(ex.Message));
}
}
return(Ok("Success"));
}
public async Task <IActionResult> GetEmployeeEEOAsync()
{
var emps = _context.GetEmployeeListAsync().Result;
using (SqlConnection con = new SqlConnection(ConnectionString))
{
try
{
con.Open();
foreach (DataLayer.Models.TempWorksDB.EmployeeList e in emps)
{
try
{
EEO doc = await TempWorksAPI.GetEmployeeEEOFromTempworksAsync(e.EmployeeId);
DataLayer.TempWorks.AddEEOProc(con, doc);
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error Updating Employee " + e.EmployeeId.ToString(), ex.Message);
}
}
}
catch (Exception ex)
{
}
}
return(Ok("Success"));
}
public async Task <IActionResult> GetAllSearchColumns()
{
using (SqlConnection con = new SqlConnection(ConnectionString))
{
con.Open();
try
{
SearchColumns rets = await TempWorksAPI.GetSearchColumnsFromTempworksAsync(1);
foreach (SearchColumn col in rets.data)
{
DataLayer.TempWorks.SetSearchColumProc(con, col);
}
rets = await TempWorksAPI.GetSearchColumnsFromTempworksAsync(2);
foreach (SearchColumn col in rets.data)
{
DataLayer.TempWorks.SetSearchColumProc(con, col);
}
rets = await TempWorksAPI.GetSearchColumnsFromTempworksAsync(3);
foreach (SearchColumn col in rets.data)
{
DataLayer.TempWorks.SetSearchColumProc(con, col);
}
rets = await TempWorksAPI.GetSearchColumnsFromTempworksAsync(8);
foreach (SearchColumn col in rets.data)
{
DataLayer.TempWorks.SetSearchColumProc(con, col);
}
rets = await TempWorksAPI.GetSearchColumnsFromTempworksAsync(14);
foreach (SearchColumn col in rets.data)
{
DataLayer.TempWorks.SetSearchColumProc(con, col);
}
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error in employees", ex.Message);
return(BadRequest(ex.Message));
}
}
return(Ok("Success"));
}
public async Task <IActionResult> GetRepUsers()
{
string conStr = ConnectionString;
using (SqlConnection con = new SqlConnection(conStr))
{
con.Open();
var users = _context.GetUsersListAsync().Result;
foreach (DataLayer.Models.TempWorksDB.RepUserId rep in users)
{
User u = await TempWorksAPI.GetUserFromTempworksAsync(rep.srIdent);
DataLayer.TempWorks.AddRepUserProc(con, u);
}
}
return(Ok());
}
public async Task <IActionResult> GetEmployeeDocsAsync()
{
var emps = _context.GetEmployeeListAsync().Result;
string conStr = ConnectionString;
using (SqlConnection con = new SqlConnection(conStr))
{
try
{
con.Open();
foreach (DataLayer.Models.TempWorksDB.EmployeeList e in emps)
{
try
{
Documents docs = await TempWorksAPI.GetEmployeeDocsFromTempworksAsync(e.EmployeeId);
if (docs != null && docs.totalCount > 0)
{
foreach (Document doc in docs.data)
{
DataLayer.TempWorks.AddDocumentProc(con, e.EmployeeId, doc);
}
_context.SaveErrorProc(con, "Added Doc for employee " + e.EmployeeId.ToString(), "");
}
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error Updating Employee " + e.EmployeeId.ToString(), ex.Message);
}
}
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error adding employee", ex.Message);
return(BadRequest(ex.Message));
}
}
return(Ok());
}
public async Task <IActionResult> GetEmployeePaychecksAsync()
{
var emps = _context.GetEmployeeListAsync().Result;
string conStr = ConnectionString;
using (SqlConnection con = new SqlConnection(conStr))
{
try
{
con.Open();
foreach (DataLayer.Models.TempWorksDB.EmployeeList e in emps)
{
try
{
Paychecks docs = await TempWorksAPI.GetEmployeePaychecksFromTempworksAsync(e.EmployeeId);
if (docs.TotalCount > 0)
{
foreach (Paycheck doc in docs.data)
{
DataLayer.TempWorks.SetLastPayCheckProc(con, e.EmployeeId, Convert.ToDateTime(doc.checkDate));
}
_context.SaveErrorProc(con, "Set LastPaycheck for employee " + e.EmployeeId.ToString(), "");
}
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error Updating Employee LastPayCheck " + e.EmployeeId.ToString(), ex.Message);
}
}
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error updating employee checkdate", ex.Message);
return(BadRequest(ex.Message));
}
}
return(Ok());
}
public async Task <IActionResult> AddAssignments([FromBody] Assignments models)
{
string conStr = "Server=employnetdata.database.windows.net;Database=DataSurf;Trusted_Connection=false;User Id=employnet;password=Employ1Now!";
using (SqlConnection con = new SqlConnection(conStr))
{
try
{
con.Open();
if (models.data == null || models.data.Count() == 0)
{
_context.SaveError("Nothing to process, end of asssignments", "");
return(Ok("success"));
}
int start = models.data[0].assignmentId;
_context.SaveError("Add Bulk Assignment", "Total " + models.data.Count() + " records, starting at id " + start.ToString());
foreach (Assignment model in models.data)
{
DataLayer.TempWorks.AddAssignmentProc(con, model);
if (model.jobOrderId != 0)
{
WorkSite site = await TempWorksAPI.GetWorksiteFromTempworksAsync((int)model.jobOrderId);
DataLayer.TempWorks.AddWorkSiteProc(con, site, DataLayer.TempWorks.AddAddressProc(con, site.address));
}
}
//_context.SaveChanges();
}
catch (Exception ex)
{
_context.SaveError("Error in assignments", ex.Message);
return(BadRequest(ex.Message));
}
_context.SaveError("End of bulk assignments", "Total " + models.data.Count() + " records, starting at id " + models.data[0].assignmentId);
}
return(Ok("Success"));
}
public async Task <IActionResult> GetEmployeeDetailsAsync()
{
var emps = _context.GetEmployeeListAsync().Result;
string ConnectionString = "Server=employnetdata.database.windows.net;Database=DataSurf;Trusted_Connection=false;User Id=employnet;password=Employ1Now!";
string conStr = ConnectionString;
using (SqlConnection con = new SqlConnection(conStr))
{
try
{
con.Open();
foreach (DataLayer.Models.TempWorksDB.EmployeeList e in emps)
{
try
{
Employee emp = await TempWorksAPI.GetEmployeeFromTempworksAsync(e.EmployeeId);
DataLayer.TempWorks.AddEmployeeProc(con, emp, true);
_context.SaveErrorProc(con, "Updated Employee" + emp.employeeId.ToString(), "");
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error Updating Employee " + e.EmployeeId.ToString(), ex.Message);
}
}
}
catch (Exception ex)
{
_context.SaveErrorProc(con, "Error adding employee", ex.Message);
return(Ok());
}
}
return(Ok());
}
