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 IActionResult Update([FromBody] DataLayer.Models.CovidTestJson model) { _context.SaveError("Entering Update", ""); try { CovidTest.AddCovidRecord(_context, model); } catch (Exception ex) { _context.SaveError("In Update", ex.Message); return(BadRequest(ex.Message)); } return(Ok("Success")); }
public IActionResult GetJsonFromCSV([FromBody] DataLayer.Models.GenericModels.GenericString fileContent) { int succesCount = 0; int errorCount = 0; int totalCount = 0; try { if (string.IsNullOrEmpty(fileContent.Message) == true) { return(Ok("No content")); } string[] rows = fileContent.Message.Split("\n"); totalCount = rows.Count(); // first row has headers string[] headers = rows[0].Split(","); // skip second row int i = 2; _context.SaveError("Start importing file", "Row count " + rows.Count().ToString()); _context.SaveChanges(); foreach (string row in rows) //for (i = 2; i <= rows.Count() - 2; i++) { if (string.IsNullOrEmpty(row) == true) { continue; } string[] columns = row.Split(","); // cases where we don't want the records if (columns[14] == columns[17])// inTime == outTime then skip { errorCount++; _context.SaveError("Skipping PDID - In and Out same", columns[1] + " " + columns[2]); // _context.SaveChanges(); continue; } float outHours; bool ret = float.TryParse(columns[19], out outHours); if (outHours == 0 || ret == false) // total hours == 0 { errorCount++; _context.SaveError("Skipping PDID - no TotalHours", columns[1] + " " + columns[2] + " " + columns[19]); // _context.SaveChanges(); continue; } DataLayer.Models.EmploynetDB.PeopleNet_PDID model = new DataLayer.Models.EmploynetDB.PeopleNet_PDID(); model.SSN = columns[0]; model.LastName = columns[1]; model.FirstName = columns[2]; int outValue; int.TryParse(columns[3], out outValue); model.EmployeeNo = outValue; model.Department = columns[8]; model.Shift = columns[9]; DateTime outDate; DateTime.TryParse(columns[11], out outDate); model.DateTime = outDate; model.InDay = columns[13]; model.InTime = columns[14]; model.OutDay = columns[16]; model.OutTime = columns[17]; model.Adjust = columns[18]; float outFloat; float.TryParse(columns[19], out outFloat); model.TotalHours = outFloat; float.TryParse(columns[20], out outFloat); model.RegHours = outFloat; float.TryParse(columns[21], out outFloat); model.OTHours = outFloat; float.TryParse(columns[22], out outFloat); model.DTHours = outFloat; try { _context.PeopleNet_PDID.Add(model); // _context.SaveChanges(); succesCount++; } catch (Exception ex) { // _context.PeopleNet_PDID.Remove(model); _context.SaveError("Add PDID", model.FirstName + " " + model.LastName + " " + model.DateTime.ToString() + " " + model.InTime + " " + model.OutTime + " " + model.TotalHours + " " + ex.InnerException != null?ex.InnerException.Message:ex.Message); errorCount++; // _context.SaveChanges(); } } _context.SaveChanges(); }catch (Exception ex) { return(Ok(ex.InnerException != null?ex.InnerException.Message:ex.Message)); } return(Ok("Total count " + totalCount.ToString() + " Success Count " + succesCount.ToString() + " Error count " + errorCount.ToString())); }