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()));
}
