public XmlDocument FormatedXmlNotaInformativa(EngieNotaInformatiovaDataDto engieData, string xmlOverrideOptionTests)
{
XElement document = XElement.Parse(xmlOverrideOptionTests);
document.SetElementValue("name", "Nota Verificaret " + engieData.nume_client_final);
document.SetElementValue("eMailSubject", "Nota Verificare " + engieData.nume_client_final);
var listOfTextBoxes = document.Element("overrideFormFieldValues").Element("document").Descendants("textBox");
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "nr_inreg_dgsr").SetElementValue("value", engieData.nr_inreg_dgsr);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "nr_fisa_evidenta").SetElementValue("value", engieData.nr_fisa_evidenta);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "data_inreg_dgsr").SetElementValue("value", DateTime.Now.ToShortDateString());
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "cod_loc_consum").SetElementValue("value", engieData.cod_loc_consum);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "nume_client_final").SetElementValue("value", engieData.nume_client_final);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "nume_client_final2").SetElementValue("value", engieData.nume_client_final2);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "strada").SetElementValue("value", engieData.strada);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "numar").SetElementValue("value", engieData.numar);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "bloc_scara_apartament").SetElementValue("value", engieData.bloc_scara_apartament);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "localitate_judet").SetElementValue("value", engieData.bloc_scara_apartament);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "telefon").SetElementValue("value", engieData.localitate_judet);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_debit_1").SetElementValue("value", engieData.aparat_debit_1);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_nr_1").SetElementValue("value", engieData.aparat_nr_1);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_nr_2").SetElementValue("value", engieData.aparat_nr_2);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_nr_3").SetElementValue("value", engieData.aparat_nr_3);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_nr_4").SetElementValue("value", engieData.aparat_nr_4);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_debit_2").SetElementValue("value", engieData.aparat_debit_2);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_debit_3").SetElementValue("value", engieData.aparat_debit_3);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_debit_4").SetElementValue("value", engieData.aparat_debit_4);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_tip_1").SetElementValue("value", engieData.aparat_tip_1);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_tip_2").SetElementValue("value", engieData.aparat_tip_2);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_tip_3").SetElementValue("value", engieData.aparat_tip_3);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aparat_tip_4").SetElementValue("value", engieData.aparat_tip_4);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "reprezentantul_legal_nume_prenume").SetElementValue("value", engieData.reprezentantul_legal_nume_prenume);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "instalatorul_autorizat_nume_prenume").SetElementValue("value", engieData.instalatorul_autorizat_nume_prenume);
var documentc = new XmlDocument();
documentc.LoadXml(document.ToString());
return(documentc);
}
public void TestInitializate()
{
//var pathFile = Path.GetFullPath(Directory.GetParent(Directory.GetCurrentDirectory()).Parent.Parent.Parent.FullName) + "\\EngiePOC\\Files\\fisier_date_test_engie_servicii.xlsx";
//configurationSection["ExcelFilePath"] = pathFile;
searchEngieData = new SearchEngieDataDto
{
cod_loc_consum = "DGSBSC100537143",
nr_inreg_dgsr = "300020062",
nume_client_final = "Ion Ionescu 12",
telefon = "0724730799"
};
engieData = new EngieNotaInformatiovaDataDto
{
cod_loc_consum = "DGSBSC100537143",
nr_inreg_dgsr = "300020062",
nume_client_final = "Ion Ionescu 12",
telefon = "0724730799",
nr_fisa_evidenta = "13",
aparat_debit_1 = "App debit 1",
aparat_debit_2 = "App debit 2",
aparat_debit_3 = "App debit 3",
aparat_debit_4 = "App debit 4",
aparat_nr_1 = "App nr 1",
aparat_nr_2 = "App nr 2",
aparat_nr_3 = "App nr 3",
aparat_nr_4 = "App nr 4",
aparat_tip_1 = "App tip 1",
aparat_tip_2 = "App tip 2",
aparat_tip_3 = "App tip 3",
aparat_tip_4 = "App tip 4",
bloc_scara_apartament = "33-B-18",
instalatorul_autorizat_nume_prenume = "Nenea Instalatorulul",
localitate_judet = "La tara",
numar = "18",
reprezentantul_legal_nume_prenume = "No name",
strada = "saidac Gheorghe"
};
}
public async Task <List <EngieNotaInformatiovaDataDto> > ReadDataNotaInformativaAsync(string _connectionPath)
{
try
{
var returnData = new List <EngieNotaInformatiovaDataDto>();
EngieNotaInformatiovaDataDto engieDataDto = new EngieNotaInformatiovaDataDto();
string[] strProperties = new string[24];
int j = 0;
using (SpreadsheetDocument document = SpreadsheetDocument.Open(_connectionPath, false))
{
WorkbookPart workbookPart = document.WorkbookPart;
IEnumerable <Sheet> sheets = document.WorkbookPart.Workbook.GetFirstChild <Sheets>().Elements <Sheet>();
string relationshipId = sheets.First().Id.Value;
WorksheetPart worksheetPart = (WorksheetPart)document.WorkbookPart.GetPartById(relationshipId);
Worksheet workSheet = worksheetPart.Worksheet;
SheetData sheetData = workSheet.GetFirstChild <SheetData>();
IEnumerable <Row> rows = sheetData.Descendants <Row>().Where(x => x.RowIndex > 1).ToList();
string value;
foreach (Row r in rows)
{
IEnumerable <Cell> cells = SpreedsheetHelper.GetRowCells(r);
foreach (Cell c in cells)
{
if (c != null)
{
value = c.InnerText;
if (c.DataType != null)
{
switch (c.DataType.Value)
{
case CellValues.SharedString:
var stringTable = workbookPart.GetPartsOfType <SharedStringTablePart>().FirstOrDefault();
if (stringTable != null)
{
value = stringTable.SharedStringTable.
ElementAt(int.Parse(value)).InnerText;
}
break;
case CellValues.Boolean:
switch (value)
{
case "0":
value = "FALSE";
break;
default:
value = "TRUE";
break;
}
break;
}
}
strProperties[j] = value;
j = j + 1;
}
}
j = 0;
returnData.Add(new EngieNotaInformatiovaDataDto
{
//id = strProperties[0] != null ? Convert.ToInt32(strProperties[0]) : 0,
nr_inreg_dgsr = strProperties[0],
nr_fisa_evidenta = strProperties[1],
cod_loc_consum = strProperties[2],
nume_client_final = strProperties[3],
strada = strProperties[4],
numar = strProperties[5],
bloc_scara_apartament = strProperties[6],
localitate_judet = strProperties[7],
telefon = strProperties[8],
aparat_tip_1 = strProperties[9],
aparat_nr_1 = strProperties[10],
aparat_debit_1 = strProperties[11],
aparat_tip_2 = strProperties[12],
aparat_nr_2 = strProperties[13],
aparat_debit_2 = strProperties[14],
aparat_tip_3 = strProperties[15],
aparat_nr_3 = strProperties[16],
aparat_debit_3 = strProperties[17],
aparat_tip_4 = strProperties[18],
aparat_nr_4 = strProperties[19],
aparat_debit_4 = strProperties[20],
reprezentantul_legal_nume_prenume = strProperties[21],
instalatorul_autorizat_nume_prenume = strProperties[22]
});
}
}
// var ddd= await Task.Run(() => returnData);
return(returnData);
}
catch (Exception ex)
{
var exception = ex.InnerException.Message;
return(new List <EngieNotaInformatiovaDataDto>());
}
}
public List <string> GetSignLink([FromBody] EngieNotaInformatiovaDataDto engieData)
{
return(_signAnywhere.SendToSign_NVR(engieData));
}
public List <string> SendToSign_NVR(EngieNotaInformatiovaDataDto d)
{
return(GetEnvelopeByIdCreateWorkStepId(d).GetAwaiter().GetResult());
}
public async Task <List <string> > GetEnvelopeByIdCreateWorkStepId(EngieNotaInformatiovaDataDto engieData)
{
var returnUrlsLinks = new List <string>();
try
{
string xmlOverrideOptionTests = File.ReadAllText(_appConfiguration.NotaVerificareSignConfig);
var documentc = _signUtil.FormatedXmlNotaInformativa(engieData, xmlOverrideOptionTests);
var ws = GetSawWebService.eSawWebService(_appConfiguration.eSawUrlBeta3);
if (ws != null)
{
string[] documentsPath = new string[] { _appConfiguration.NotaVerificareFormPdf };
string[] docIds = _signUtil.UploadPdfsAndGetDocIds(ws, Util.GetApiAuthorization(_appConfiguration.OrganizationKeyBeta3, _appConfiguration.UserAccountName), documentsPath);
string sendEnvelopeResponseXml = ws.SendEnvelope_v1Async(Util.GetApiAuthorization(_appConfiguration.OrganizationKeyBeta3, _appConfiguration.UserAccountName), docIds, documentc.InnerXml).GetAwaiter().GetResult();
SignAnywhereResponse response = SignAnywhereResponse.parseResponse(sendEnvelopeResponseXml);
if (response.BaseResult == SignAnywhereResponse.Result.Failed)
{
returnUrlsLinks.Add(response.ErrorMsg);
return(returnUrlsLinks);
}
var envelopeId = response.okInfo.InnerText;
var getEnvelopeByIdResponse = ws.GetEnvelopeById_v1Async(Util.GetApiAuthorization(_appConfiguration.OrganizationKeyBeta3, _appConfiguration.UserAccountName), envelopeId).GetAwaiter().GetResult();
var linkUrl = Util.ExtractXmlValue("/apiResult/okInfo/envelopeStatus/bulkRecipients/bulkRecipient/recipients/recipient/workstepRedirectionUrl", getEnvelopeByIdResponse);
if (string.IsNullOrEmpty(linkUrl))
{
returnUrlsLinks.Add("Error extracting the xml node value");
return(returnUrlsLinks);
}
//the urllink like this
//https://beta3.testlab.xyzmo.com/saw/SignAnyWhere.aspx?WorkstepId=2632166D6CE3D58D992A024A7D2FDCFC51AA52FC4201EAA8F1158BB361BEE0B6E0CFBEF308D02E8D536F4A253C33117A&setLng=en
string webLinkUrl = Util.GetWebRedirectedUri(linkUrl);
if (!string.IsNullOrEmpty(webLinkUrl))
{
var workStepId = webLinkUrl.Split("=")[1].Split("&").First();
if (!string.IsNullOrEmpty(workStepId))
{
var androidLink = string.Format(_appConfiguration.AndroidLinkTemplate, workStepId);
returnUrlsLinks.Add(webLinkUrl);
returnUrlsLinks.Add(androidLink);
}
}
}
return(returnUrlsLinks);
}
catch (Exception ex)
{
returnUrlsLinks.Add(ex.Message);
return(returnUrlsLinks);
}
}
