public ActionResult Upload(IEnumerable <HttpPostedFileBase> uploads)
{
int loadedFiles = 0;
DataToDB dataToDB = new DataToDB();
foreach (var file in uploads)
{
if (file != null)
{
string fileName = Server.MapPath("~/Files/" + System.IO.Path.GetFileName(file.FileName));
if (FileInfo.CanBeAdded(fileName))
{
file.SaveAs(fileName);
if (dataToDB.SaveDataToDB(fileName))
{
loadedFiles++;
}
else
{
FileInfo.DeleteFile(fileName);
}
}
}
}
ViewBag.FilesAmount = loadedFiles;
return(View("Success"));
}
public DataTable CheckIfRemoteSerialExists(string materialNumber, string serial)
{
DataTable dtTemp = new DataTable();
try
{
dtTemp = DataToDB.dtCheckRemoteSerial(materialNumber, serial);
dtTemp.TableName = "CheckIfRemoteSerialExists";
}
catch (Exception e)
{
logger.Error($"Error : {e.StackTrace}");
}
return(dtTemp);
}
public DataTable GetMaterialInfoUsingMaterialNumber(string _materialNumber)
{
DataTable dtTemp = new DataTable();
try
{
dtTemp = DataToDB.GetMaterialInfoUsingMaterialNumber(_materialNumber);
dtTemp.TableName = "GetMaterialInfoUsingMaterialNumber";
}
catch (Exception e)
{
logger.Error($"Error : {e.StackTrace}");
}
return(dtTemp);
}
public DataTable GetUDISpecialCases()
{
DataTable dtTemp = new DataTable();
try
{
dtTemp = DataToDB.GetUDIBarcodeSpecialCases();
dtTemp.TableName = "GetUDISpecialCases";
}
catch (Exception ex)
{
logger.Error($"Error : {ex.StackTrace}");
}
return(dtTemp);
}
/// <summary>
/// Perform a check to the Production DB and determine if material exists
/// </summary>
/// <param name="materialNumber"></param>
/// <returns>Boolean</returns>
bool ISapService.ValidateMaterialNumber(string materialNumber)
{
bool bIsValid = false;
try
{
//check if material number exists in the production utilities db
DataTable dbTemp = DataToDB.SearchByMaterialNumber(materialNumber);
dbTemp.TableName = "ValidateMaterialNumber";
//check if DataTable came back with and info
bIsValid = (dbTemp.Rows.Count > 0) ? true : false;
}
catch (Exception ex)
{
logger.Error($"Error : {ex.StackTrace}");
}
return(bIsValid);
}