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