public int Upload_Dimensions(UploadParams _uploadParams)
{
int _res = 0;
string xItem = "";
try
{
DynamicParameters param = new DynamicParameters();
xItem = _uploadParams.ITEM;
param.Add("@ITEM", xItem);
param.Add("@QUANTITY_UM", _uploadParams.QUANTITY_UM);
param.Add("@COMPANY", _uploadParams.COMPANY);
param.Add("@LENGTH", _uploadParams.LENGTH);
param.Add("@WIDTH", _uploadParams.WIDTH);
param.Add("@HEIGHT", _uploadParams.HEIGHT);
param.Add("@DIMENSION_UM", _uploadParams.DIMENSION_UM);
param.Add("@DIM_WEIGHT", _uploadParams.DIM_WEIGHT);
param.Add("@VOLUME", _uploadParams.VOLUME);
param.Add("@VOLUME_UM", _uploadParams.VOLUME_UM);
param.Add("@WEIGHT", _uploadParams.WEIGHT);
param.Add("@WEIGHT_UM", _uploadParams.WEIGHT_UM);
param.Add("@FACTOR", _uploadParams.FACTOR);
param.Add("@CASEQTY", _uploadParams.CASEQTY);
param.Add("@USER_DEF1", _uploadParams.USER_DEF1);
param.Add("@USER_DEF2", _uploadParams.USER_DEF2);
param.Add("@USER_DEF3", _uploadParams.USER_DEF3);
param.Add("@USER_DEF4", _uploadParams.USER_DEF4);
param.Add("@USER_DEF5", _uploadParams.USER_DEF5);
param.Add("@USER_DEF6", _uploadParams.USER_DEF6);
param.Add("@USER_DEF7", _uploadParams.USER_DEF7);
param.Add("@USER_DEF8", _uploadParams.USER_DEF8);
param.Add("@CONTAINER", _uploadParams.CONTAINER);
using (IDbConnection Conn = new SqlConnection(stringConn))
{
var _id = Conn.Query <int>("CUBISCAN_UPLOAD_DIMENSIONS", param, null, true, null, CommandType.StoredProcedure);
_res = _id.FirstOrDefault();
}
}
catch (Exception ex)
{
ErrorLogParams exparams = new ErrorLogParams();
exparams.ITEM = xItem.ToString();
exparams.DESCRIPTION = ex.Message.ToString();
Update_ErrLog(exparams);
}
finally
{
}
return(_res);
}
private void StartViewPdfBtn_Click(object sender, EventArgs e)
{
var filesCount = Convert.ToInt32(ViewPdfCountTB.Text ?? "1");
var threads = Convert.ToInt32(ViewPdfThreadsTB.Text ?? "1");
var parameters = new UploadParams()
{
Count = filesCount,
Threads = threads,
FileName = ViewPdfFileNameTB.Text
};
SdkTest.ViewPDF(CallType.Forms, parameters);
}
//public Task<Data.Project> CreateNew(Data.ProjectCreate newProject)
// => Post<Data.Project>(new ExecuteParams("/v2/quotes", newProject));
public Task <ProjectsSmart.Data.File> Upload(string quoteId, UploadParams uploadParam)
=> Upload <ProjectsSmart.Data.File>(new ExecuteParams($"/v2/quotes/{quoteId}/files/upload"), uploadParam);
public bool PrepFile(string FilePath)
{
bool _res = false;
string xItem = "";
string xType = "EA";
string xFile = FilePath;
try
{
// Processed CUBISCAN files ** \\wmsapp\ILS\Interface\Cubiscan
using (var reader = new StreamReader(FilePath))
{
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
var values = line.Split(',');
if (values[0] != "Item number")
{
UploadParams _upParms = new UploadParams();
xItem = values[0];
xType = GetContainerType(xItem, FilePath);
if (xType != "EA")
{
xItem = values[0].Substring(0, (values[0].Length - 3));
}
_upParms.ITEM = xItem;
_upParms.LENGTH = Convert.ToDecimal(values[3].ToString());
_upParms.WIDTH = Convert.ToDecimal(values[4].ToString());
_upParms.HEIGHT = Convert.ToDecimal(values[5].ToString());
_upParms.WEIGHT = Convert.ToDecimal(values[6].ToString());
_upParms.VOLUME = Convert.ToDecimal(values[7].ToString());
_upParms.DIM_WEIGHT = Convert.ToDecimal(values[8].ToString());
_upParms.DIMENSION_UM = values[9];
_upParms.WEIGHT_UM = values[10];
_upParms.VOLUME_UM = values[11];
_upParms.FACTOR = values[12].ToString();
_upParms.COMPANY = values[13];
if (!string.IsNullOrEmpty(values[15].ToString()))
{
_upParms.CASEQTY = Convert.ToInt32(values[15].ToString());
}
else
{
_upParms.CASEQTY = 0;
}
_upParms.QUANTITY_UM = xType;
_upParms.USER_DEF1 = "";
_upParms.USER_DEF2 = values[16];
_upParms.USER_DEF3 = values[17];
_upParms.USER_DEF4 = values[18];
_upParms.USER_DEF5 = values[19];
_upParms.USER_DEF6 = values[20];
if (values[21].ToString() == "")
{
_upParms.USER_DEF7 = 0;
}
else
{
_upParms.USER_DEF7 = Convert.ToDecimal(values[21].ToString());
}
_upParms.USER_DEF8 = Convert.ToDecimal(values[22].ToString());
_upParms.CONTAINER = xType;
Upload_Dimensions(_upParms);
_res = true;
}
}
}
}
catch (Exception ex)
{
ErrorLogParams exparams = new ErrorLogParams();
exparams.ITEM = xItem.ToString();
exparams.DESCRIPTION = ex.Message.ToString();
exparams.FILE_NAME = xFile.ToString();
Update_ErrLog(exparams);
_res = false;
}
return(_res);
}
public Task <ProjectsSmart.Data.File> Upload(string projectId, UploadParams uploadParams)//, Data.FormDataMultiPart file)
=> base.Upload <ProjectsSmart.Data.File>(new ExecuteParams($"/v2/projects/{projectId}/files/upload"), uploadParams);
public string Start()
{
var commands = "\nup - Upload files.\n" +
"\ndown - Download files\n" +
"\npdfcnv - Convert file to PDF\n" +
"\nviewpdf - View file as PDF\n" +
"\nviewpdfa - View DOCX, XLSX, PPTX files as PDF with same name\n" +
"\n";
Console.WriteLine(commands);
Console.Write("Enter command :> ");
string input = Console.ReadLine();
var inputn = "";
var parameters = new UploadParams();
switch (input)
{
case "up":
Console.WriteLine("\nFile name: ");
inputn = Console.ReadLine();
UploadFiles(CallType.Console, inputn);
Console.WriteLine("Upload success!");
break;
case "down":
inputn = Console.ReadLine();
DownloadFiles(CallType.Console, inputn);
Console.WriteLine("Download success!");
break;
case "pdfcnv":
inputn = Console.ReadLine();
ConvertToPDF(CallType.Console, inputn);
Console.WriteLine("Convert success!");
break;
case "viewpdfw":
inputn = Console.ReadLine();
parameters.FileName = inputn;
ViewPDF(CallType.Console, parameters);
Console.WriteLine("Convert success!");
break;
case "viewpdfx":
inputn = Console.ReadLine();
parameters.FileName = inputn;
ViewPDF(CallType.Console, parameters);
Console.WriteLine("Convert success!");
break;
case "viewpdfp":
inputn = Console.ReadLine();
parameters.FileName = inputn;
ViewPDF(CallType.Console, parameters);
Console.WriteLine("Convert success!");
break;
case "viewpdfa":
inputn = Console.ReadLine();
parameters.FileName = inputn;
ViewPDF(CallType.Console, parameters);
ViewPDF(CallType.Console, parameters);
ViewPDF(CallType.Console, parameters);
Console.WriteLine("Convert success!");
break;
case "exit":
return(input);
}
return("");
}
public string ViewPDF(CallType callType, UploadParams parameters)
{
InitConsole();
string name;
string ext;
if (callType == CallType.Console)
{
name = ConfigurationManager.AppSettings["SourcePath"] + Path.GetFileNameWithoutExtension(parameters.FileName);;
ext = !string.IsNullOrEmpty(Path.GetExtension(parameters.FileName)) ? Path.GetExtension(parameters.FileName) : "docx";
}
else
{
name = parameters.FileName;
ext = "";
}
var total = parameters.Count;
var offset = total / parameters.Threads;
var parameter = new DownloadParams
{
Offset = 0,
Count = offset,
Config = _config,
FileName = name,
FileType = ext
};
parameters.Config = _config;
switch (ext == "" ? Path.GetExtension(parameters.FileName).Remove(0, 1) : ext)
{
case "docx":
case "doc":
case "docm":
case "dot":
case "dotm":
case "dotx":
case "odt":
case "rtf":
ConvertWordToPdf(name, ext, parameters.Count, parameters.Threads);
break;
case "xls":
case "xlsx":
case "xlsm":
case "xlsb":
case "xml":
case "csv":
case "mht":
case "ods":
case "prn":
case "slk":
ConvertExcelToPdf(name, ext, parameters.Count, parameters.Threads);
break;
case "ppt":
case "pptx":
case "pptm":
case "pps":
case "ppsm":
case "ppsx":
case "odp":
ConvertPowerPointToPdf(name, ext, parameters.Count, parameters.Threads);
break;
}
return("Convert Success!");
}
public string UploadFiles(CallType callType, string fileName = "file", int count = 1, int threads = 1)
{
InitConsole();
var consoleOut = new StringWriter();
var consoleOut1 = Console.Out;
//Console.SetOut(consoleOut);
string name;
string ext;
if (callType == CallType.Console)
{
name = ConfigurationManager.AppSettings["SourcePath"] + Path.GetFileNameWithoutExtension(fileName);;
ext = !string.IsNullOrEmpty(Path.GetExtension(fileName)) ? Path.GetExtension(fileName) : "docx";
}
else
{
name = fileName;
ext = "";
}
var total = count;
var offset = total / threads;
var parameters = new UploadParams
{
Offset = 0,
Count = offset,
Config = _config,
FileName = name,
FileType = ext
};
for (int i = 0; i < threads; i++)
{
parameters.Offset = i * offset;
var upload = new UploadThread("THREAD " + i + ", Upload of " + offset + name + ext, parameters);
}
//var parametersXlsx = new UploadParams
//{
// Offset = 0,
// Count = offset,
// Config = _config,
// FileName = name,
// FileType = "xlsx"
// //FileType = !string.IsNullOrEmpty(ext) ? ext : "xlsx"
//};
//for (int i = 0; i < threads; i++)
//{
// parametersXlsx.Offset = i * offset;
// var uploadXlsx = new UploadThread("THREAD " + i + ", View PDF of " + offset + " XLSX", parametersXlsx);
//}
//var parametersPptx = new UploadParams
//{
// Offset = 0,
// Count = offset,
// Config = _config,
// FileName = name,
// FileType = "pptx"
// //FileType = !string.IsNullOrEmpty(ext) ? ext : "pptx"
//};
//for (int i = 0; i < threads; i++)
//{
// parametersPptx.Offset = i * offset;
// var uploadPptx = new UploadThread("THREAD " + i + ", View PDF of " + offset + " PPTX", parametersPptx);
//}
return("Upload success!");
return(consoleOut1.ToString());
return(consoleOut.ToString());
}
//public Task<Data.Project> Upload(string jobId, Data.FormDataMultiPart file)
// => Post<Data.Project>(new ExecuteParams("/v2/jobs/{jobId}/files/delivered/upload", newProject));
public Task <ProjectsSmart.Data.File> Upload(string jobId, UploadParams uploadParam)
=> Upload <ProjectsSmart.Data.File>(new ExecuteParams($"/v2/jobs/{jobId}/files/delivered/upload"), uploadParam);
