public AuditPostTRNAPI(IConfiguration configuration)
{
AllowAnonymous = true;
RecaptchaRequire = true;
Configuration = configuration;
FilesUtilSvc = new FilesUtil(Configuration);
}
private void cleanSpaceToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
StringBuilder deletedFileNames = new StringBuilder();
ISamplesService sampleService = new SamplesServiceImpl();
List <String> filesfromSamples = FilesUtil.getStorageFileNamesByMeta(sampleService.getAllMetaByType(1));
String[] reportFolderFiles = FilesUtil.GetFileNames(Program.applicationReportsPath, "*");
foreach (String fileFromStorage in reportFolderFiles)
{
if (!filesfromSamples.Contains(fileFromStorage))
{
deletedFileNames.Append(fileFromStorage).AppendLine();
try
{
File.Delete(Path.Combine(Program.applicationReportsPath, fileFromStorage));
}
catch (Exception ex)
{
logger.Error(ex);
throw ex;
}
}
}
MessageBox.Show("Место освобождено, удалены:" + deletedFileNames.ToString(),
"Внимание", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception ex)
{
logger.Error(ex);
MessageBox.Show(ex.Message,
"Внимание", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public AuditDuplicateApi(IConfiguration configuration)
{
AllowAnonymous = true;
RecaptchaRequire = true;
Configuration = configuration;
FilesUtilSvc = new FilesUtil(Configuration);
}
public string GetScreenshotDirectory(string branchName, string buildName, string useCaseName, string scenarioName)
{
return(string.Format(
@"{0}{1}{2}",
this.GetScenarioDirectory(branchName, buildName, useCaseName, scenarioName),
Path.DirectorySeparatorChar,
FilesUtil.EncodeName(DirectoryNameScenarioScreenshot)));
}
public string GetUseCaseDirectory(string branchName, string buildName, string useCaseName)
{
return(string.Format(
@"{0}{1}{2}",
this.GetBuildDirectory(branchName, buildName),
Path.DirectorySeparatorChar,
FilesUtil.EncodeName(useCaseName)));
}
public string GetBranchDirectory(string branchName)
{
return(string.Format(
@"{0}{1}{2}",
this.rootDirectory,
Path.DirectorySeparatorChar,
FilesUtil.EncodeName(branchName)));
}
private void clbColumnas_ItemCheck(object sender, ItemCheckEventArgs e)
{
UltraGridLayout layout = this.grdDetalleQuincena.DisplayLayout;
UltraGridBand band = layout.Bands[0];
if (this.grdDetalleQuincena.DisplayLayout.Bands[0].Columns.Count > 0)
{
band.Columns[e.Index].Hidden = this.clbColumnas.GetItemChecked(e.Index);
checkedColumns[band.Columns[e.Index].Header.Caption]
= band.Columns[e.Index].Hidden ? "0" : "1";
}
FilesUtil.Write(checkedColumns, "dictionary.bin");
}
public void Export(ExportFormatType exportFormat)
{
try
{
string tmpFileName;
string ReportNumber = "";
if (result != null)
{
ReportNumber = result.REPORTNUMBER + " " + result.CUSTOMER_NAME;
}
switch (exportFormat)
{
case ExportFormatType.PortableDocFormat:
tmpFileName = FilesUtil.GetTmpPdfFileName(ReportNumber);
break;
case ExportFormatType.WordForWindows:
case ExportFormatType.EditableRTF:
tmpFileName = FilesUtil.GetTmpDocFileName(ReportNumber);
break;
case ExportFormatType.Excel:
tmpFileName = FilesUtil.GetTmpXlsFileName(ReportNumber);
break;
default:
tmpFileName = FilesUtil.GetTmpPdfFileName(ReportNumber);
break;
}
using (ReportDocument rpt = new RPT002_WorkPlaceAirQualityReport())
{
rpt.SetParameterValue("@p_ID", WPA_ID);
rpt.SetDatabaseLogon(OISDataInfo.DatabaseInfomation.USERNAME, OISDataInfo.DatabaseInfomation.PASSWORD, OISDataInfo.DatabaseInfomation.DATASOURCE, OISDataInfo.DatabaseInfomation.DATABASENAME);
SetConnection(rpt);
rpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4;
rpt.ExportToDisk(exportFormat, tmpFileName);
Process.Start(tmpFileName);
CloseConnection(rpt);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void MainForm_FormClosing(object sender, FormClosingEventArgs e)
{
if (rMessageBox.ShowConfirmation(this, "คุณต้องการปิดโปรแกรมใช่หรือไม่ ?") != DialogResult.Yes)
{
e.Cancel = true;
}
try
{
using (SystemViewModel vmSys = new SystemViewModel())
{
vmSys.UserLogout();
}
}
catch (Exception ex)
{
rMessageBox.ShowException(this, ex);
}
FilesUtil.ClearApplicationTempPath();
}
private void FileCopyTest()
{
string targetedFolderPath = "variants/default";
//merge downloaded files to git folder
string copyFromRootFolder =
"C:\\Users\\Administrator\\AppData\\Local\\Temp\\f310d95b-43f2-4fb4-8859-baf6741fca2d_CMS_INT_integration-test";
string copyToRootFolder =
"C:\\Users\\Administrator\\AppData\\Local\\Temp\\f310d95b-43f2-4fb4-8859-baf6741fca2d_Akamai_INT_";
if (!string.IsNullOrEmpty(copyToRootFolder) && Directory.Exists(copyToRootFolder))
{
string copyFromDir = Path.Combine(copyFromRootFolder, targetedFolderPath.Replace('/', '\\'));
string copyToDir = Path.Combine(copyToRootFolder, targetedFolderPath.Replace('/', '\\'));
FilesUtil.CopyFiles(copyFromDir, copyToDir, false, "*.json");
}
richTextBox1.Text = "Done!!!";
}
private void initComponentsBySample()
{
this.maskedTextBox1.Text = selectedSample.Date;
foreach (MetaObject itemMeta in selectedSample.metaList)
{
if (itemMeta.type == 0)
{
string[] row = { itemMeta.Value };
ListViewItem item = new ListViewItem(row);
this.listView1.Items.Add(item);
}
else
{
String visibleFileName = FilesUtil.getVisibleFileNameByMetaItem(itemMeta.Value);
String storageFileName = FilesUtil.getStorageFileNameByMetaItem(itemMeta.Value);
string[] row = { visibleFileName, storageFileName };
ListViewItem item = new ListViewItem(row);
this.listView2.Items.Add(item);
copyFilesFromApplicationToTmpDir(visibleFileName, storageFileName);
}
}
this.NameTextBox.Text = selectedSample.name;
}
public void ExportExcelSpecial()
{
try
{
if (dataList != null && dataList.Count > 0)
{
string tmpFileName = FilesUtil.GetTmpXlsxFileName();
FileInfo newFile = new FileInfo(tmpFileName);
using (ExcelPackage NewPck = new ExcelPackage(newFile))
using (ExcelWorkbook NewWb = NewPck.Workbook)
{
//load template
string TEMPLATE_FILE_NAME = "RPT001_Template.xlsx";
string TemplatePath = Path.Combine(Application.StartupPath, OISBaseConstant.PATH_TEMPLATE, TEMPLATE_FILE_NAME);
FileInfo OrgFile = new FileInfo(TemplatePath);
//create sheet
using (ExcelPackage OrgPck = new ExcelPackage(OrgFile))
using (ExcelWorkbook OrgWb = OrgPck.Workbook)
{
ExcelWorksheet OrgSheet;
int firstRecordRow, templateColumnCount, LV3Row, LV2Row, LOCRow;
OrgSheet = OrgWb.Worksheets[1];
firstRecordRow = 3;
templateColumnCount = 6;
LV3Row = 3;
LV2Row = 4;
LOCRow = 5;
//add sheet
NewWb.Worksheets.Add(dataList[0].REPORTNUMBER, OrgSheet);
ExcelWorksheet sht = NewWb.Worksheets[1];
sht.DeleteRow(firstRecordRow, 4);
sht.Cells.Worksheet.Workbook.Styles.UpdateXml();
int nextRow = firstRecordRow;
string tmpLV3 = "", tmpLV2 = "";
for (int i = 0; i < dataList.Count; i++)
{
sp_RPT001_GetWorkPlaceLightReport_Result data = dataList[i];
if (!data.LOC_NAME_LV3.IsNull())
{
if (tmpLV3 != data.LOC_NAME_LV3)
{
tmpLV3 = data.LOC_NAME_LV3;
OrgSheet.Cells[LV3Row, 1, LV3Row, templateColumnCount].Copy(sht.Cells[nextRow, 1, nextRow, templateColumnCount]);
sht.Cells[nextRow, 2].Value = data.LOC_NAME_LV3;
nextRow++;
}
}
if (!data.LOC_NAME_LV2.IsNull())
{
if (tmpLV2 != data.LOC_NAME_LV2)
{
tmpLV2 = data.LOC_NAME_LV2;
OrgSheet.Cells[LV2Row, 1, LV2Row, templateColumnCount].Copy(sht.Cells[nextRow, 1, nextRow, templateColumnCount]);
sht.Cells[nextRow, 2].Value = data.LOC_NAME_LV2;
nextRow++;
}
}
if (i + 1 == dataList.Count)
{
OrgSheet.Cells[firstRecordRow + 3, 1, firstRecordRow + 3, templateColumnCount].Copy(sht.Cells[nextRow, 1, nextRow, templateColumnCount]);
}
else
{
OrgSheet.Cells[LOCRow, 1, LOCRow, templateColumnCount].Copy(sht.Cells[nextRow, 1, nextRow, templateColumnCount]);
}
sht.Cells[nextRow, 1].Value = i + 1;
sht.Cells[nextRow, 2].Value = data.LOC_NAME;
sht.Cells[nextRow, 3].Value = data.STDLIGHT_NAME;
if (data.RESULT_DAY.HasValue)
{
sht.Cells[nextRow, 4].Value = data.RESULT_DAY_STR;
}
else
{
sht.Cells[nextRow, 4].Value = data.RESULT_NIGHT_STR;
}
//sht.Cells[nextRow, 5].Value = data.STDLIGHT_STANDARD_STR;
sht.Cells[nextRow, 6].Value = data.CONDITION;
var rtDir2 = sht.Cells[nextRow, 5].RichText.Add(data.STDLIGHT_STANDARD.GetValueOrDefault().ToString("#,##0"));
rtDir2.UnderLine = false;
nextRow++;
}
//Open Excel
NewPck.Save();
Process.Start(tmpFileName);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public RPT002_2_Process(int WPA_ID)
{
try
{
List <sp_RPT002_GetWorkPlaceAirReport_2_Result> dataList = vmRpt.GetWorkPlaceAirReport_2(WPA_ID);
if (dataList != null && dataList.Count > 0)
{
string fileName = string.Format("{0} ({1})", dataList[0].ANALYSYS_NO, dataList[0].CUSTOMER_NAME_TH);
string tmpFileName = FilesUtil.GetTmpXlsxFileName(fileName);
FileInfo newFile = new FileInfo(tmpFileName);
using (ExcelPackage NewPck = new ExcelPackage(newFile))
using (ExcelWorkbook NewWb = NewPck.Workbook)
{
//load template
string TEMPLATE_FILE_NAME = "RPT002_Template.xlsx";
string TemplatePath = Path.Combine(Application.StartupPath, OISBaseConstant.PATH_TEMPLATE, TEMPLATE_FILE_NAME);
FileInfo OrgFile = new FileInfo(TemplatePath);
//create sheet
using (ExcelPackage OrgPck = new ExcelPackage(OrgFile))
using (ExcelWorkbook OrgWb = OrgPck.Workbook)
{
ExcelWorksheet OrgSheet;
int firstRecordRow, templateColumnCount, firstReferenceRow;
OrgSheet = OrgWb.Worksheets[1];
firstRecordRow = 15;
firstReferenceRow = 17;
templateColumnCount = CellStringToIndex("BV");
//add sheet
NewWb.Worksheets.Add(dataList[0].ANALYSYS_NO, OrgSheet);
ExcelWorksheet sht = NewWb.Worksheets[1];
sht.DeleteRow(16);
sht.Cells.Worksheet.Workbook.Styles.UpdateXml();
// Header
sht.Cells[4, CellStringToIndex("J")].Value = dataList[0].CUSTOMER_NAME_TH;
sht.Cells[5, CellStringToIndex("F")].Value = dataList[0].CUSTOMER_ADDRNO;
sht.Cells[5, CellStringToIndex("N")].Value = dataList[0].CUSTOMER_MOO;
sht.Cells[5, CellStringToIndex("R")].Value = dataList[0].CUSTOMER_ROAD;
sht.Cells[5, CellStringToIndex("AC")].Value = dataList[0].CUSTOMER_SUBDISTRICT;
sht.Cells[5, CellStringToIndex("AT")].Value = dataList[0].CUSTOMER_DISTRICT;
sht.Cells[5, CellStringToIndex("BJ")].Value = dataList[0].CUSTOMER_PROVINCE;
sht.Cells[6, CellStringToIndex("G")].Value = dataList[0].CUSTOMER_POSTCODE;
sht.Cells[5, CellStringToIndex("O")].Value = dataList[0].CUSTOMER_TEL;
sht.Cells[22, CellStringToIndex("W")].Value = dataList[0].ANALYST_NAME;
sht.Cells[22, CellStringToIndex("BH")].Value = dataList[0].AGENT_NAME;
string t = sht.Cells[23, CellStringToIndex("BH")].Text;
sht.Cells[23, CellStringToIndex("BH")].Value = null;
var rt1 = sht.Cells[23, CellStringToIndex("BH")].RichText.Add("นายจ้าง");
var rt2 = sht.Cells[23, CellStringToIndex("BH")].RichText.Add("/");
var rt3 = sht.Cells[23, CellStringToIndex("BH")].RichText.Add("ผู้กระทำแทน");
if (dataList[0].AGENT_FLAG)
{
rt3.Strike = true;
}
else
{
rt1.Strike = true;
}
// Reference
int nextRow = firstReferenceRow;
var instList = dataList
.Where(x => x.INST_NAME != null)
.Select(x => new
{
INST_NAME = x.INST_NAME,
INST_EDITION = x.INST_EDITION,
INST_PAGE_FROM = x.INST_PAGE_FROM,
INST_PAGE_TO = x.INST_PAGE_TO,
}).Distinct().ToList();
if (instList != null && instList.Count > 0)
{
for (int i = 0; i < instList.Count; i++)
{
if (i > 0 && i < instList.Count - 1)
{
sht.InsertRow(nextRow, 1, firstReferenceRow);
OrgSheet.Cells[firstReferenceRow + 1, 1, firstReferenceRow + 1, templateColumnCount].Copy(sht.Cells[nextRow, 1, nextRow, templateColumnCount]);
}
var data = instList[i];
sht.Cells[nextRow, CellStringToIndex("V")].Value = string.Format("{0}. {1}", i + 1, data.INST_NAME);
sht.Cells[nextRow, CellStringToIndex("AT")].Value = data.INST_EDITION;
sht.Cells[nextRow, CellStringToIndex("BG")].Value = data.INST_PAGE_FROM;
sht.Cells[nextRow, CellStringToIndex("BP")].Value = data.INST_PAGE_TO;
}
}
// Detail
nextRow = firstRecordRow;
for (int i = 0; i < dataList.Count; i++)
{
if (i > 0 && i < dataList.Count - 1)
{
sht.InsertRow(nextRow, 1, firstRecordRow);
OrgSheet.Cells[firstRecordRow + 1, 1, firstRecordRow + 1, templateColumnCount].Copy(sht.Cells[nextRow, 1, nextRow, templateColumnCount]);
}
sp_RPT002_GetWorkPlaceAirReport_2_Result data = dataList[i];
sht.Cells[nextRow, CellStringToIndex("A")].Value = data.PARAMETER_NAME;
sht.Cells[nextRow, CellStringToIndex("H")].Value = data.SAMPLING_DATE;
sht.Cells[nextRow, CellStringToIndex("L")].Value = data.LOC_NAME;
sht.Cells[nextRow, CellStringToIndex("Y")].Value = data.TOOLPICK_NAME;
sht.Cells[nextRow, CellStringToIndex("AK")].Value = data.AIR_FLOW;
sht.Cells[nextRow, CellStringToIndex("AN")].Value = data.SAMPLING_TIME;
sht.Cells[nextRow, CellStringToIndex("AS")].Value = data.ANALYTICAL_DATE;
sht.Cells[nextRow, CellStringToIndex("AX")].Value = data.TOOLANALYSIS_NAME;
sht.Cells[nextRow, CellStringToIndex("BJ")].Value = data.RESULT_DISP.ToString();
sht.Cells[nextRow, CellStringToIndex("BO")].Value = data.STANDARD_DISP;
sht.Cells[nextRow, CellStringToIndex("BS")].Value = "ไม่เกิน";
nextRow++;
}
//Open Excel
NewPck.Save();
Process.Start(tmpFileName);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void LoadData()
{
UltraGridLayout layout = this.grdDetalleQuincena.DisplayLayout;
UltraGridBand band = layout.Bands[0];
try
{
this.LlenaDicMeses();
if (this.DtDetalleComisiones == null)
{
return;
}
this.Text = this.Title;
try
{
checkedColumns = FilesUtil.Read("dictionary.bin");
}
catch
{
checkedColumns = new Dictionary <string, string>();
}
try
{
this.grdDetalleQuincena.DataSource = this.DtDetalleComisiones.AsEnumerable()
.AsParallel().Where(x => Convert.ToInt32(x["mes"]) == this.Mes &&
this.Q == x["Q"].ToString().Trim() &&
Convert.ToInt32(x["anio"]) == this.Año &&
x["es_servicio"].ToString() == (this.SonServicios ? "Si" : "No"))
.OrderBy(x => x["factura"]).CopyToDataTable();
this.tcFacturasPagadas.TabPages["FacturasPagadas"].Text = "Facturas Pagadas [" +
this.grdDetalleQuincena.Rows.Count + "]";
}
catch
{
this.tcFacturasPagadas.TabPages["FacturasPagadas"].Text = "Facturas Pagadas [0]";
}
try
{
this.grdFacturasCanceladas.DataSource = this.DtFacturasCanceladas.AsEnumerable()
.AsParallel().Where(x => this.dicMeses[x["mes"].ToString()] == this.Mes &&
this.Q == x["Q"].ToString().Trim() &&
Convert.ToInt32(x["anio"]) == this.Año).OrderBy(x => x["factura"]).CopyToDataTable();
this.tcComplemento.TabPages["FacturasCanceladas"].Text = "Facturas Canceladas [" +
this.grdFacturasCanceladas.Rows.Count + "]";
}
catch
{
this.tcComplemento.TabPages["FacturasCanceladas"].Text = "Facturas Canceladas [0]";
}
try
{
this.grdFacturasPendientes.DataSource = this.DtFacturasPendientes.AsEnumerable()
.AsParallel().Where(x => this.dicMeses[x["mes"].ToString()] == this.Mes &&
this.Q == x["Q"].ToString().Trim() &&
Convert.ToInt32(x["anio"]) == this.Año).OrderBy(x => x["factura"]).CopyToDataTable();
this.tcComplemento.TabPages["FacturasPendientes"].Text = "Facturas Pendientes [" +
this.grdFacturasPendientes.Rows.Count + "]";
}
catch
{
this.tcComplemento.TabPages["FacturasPendientes"].Text = "Facturas Pendientes [0]";
}
foreach (string columName in this.DtDetalleComisiones.Columns.Cast <DataColumn>()
.Select(x => x.ColumnName))
{
this.clbColumnas.Items.Add(columName);
this.columnIndexes.Add(columName, this.clbColumnas.Items.Count - 1);
if (checkedColumns.ContainsKey(columName))
{
this.clbColumnas.SetItemChecked(this.clbColumnas.Items.Count - 1,
checkedColumns[columName] == "1");
band.Columns[columName].Hidden = checkedColumns[columName] == "0";
}
else
{
this.checkedColumns.Add(columName, "1");
this.clbColumnas.SetItemChecked(this.clbColumnas.Items.Count - 1, true);
}
}
}
catch (Exception ex) { ex.ToString(); }
}
