public List <string> GetSignLink([FromBody] CtrEngieDataDTO engieData)
{
return(_signAnywhere.SendToSign_CTR(engieData));
}
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;
searchCtrEngieData = new SearchCtrEngieDataDto
{
nr_contract = "4000000125",
cnp = "1790121445364",
nume_contractant = "Eugen Cioclea",
telefon = "740222124"
};
engieData = new CtrEngieDataDTO
{
nr_contract = "4000000123",
data_semnarii = "04-07-2018",
nume_contractant = "Bratcoveanu Nicoleta",
localitate = "Bucuresti",
strada = "Aleea Alexandru",
nr = "1",
cod_cladire = "bl1",
apt = "1",
cod_postal = "10203",
judet = "Sector 1",
tel = "740222122",
email = "*****@*****.**",
serie_nr_ci = "RX442362",
eliberat_de = "SPCEPS1",
eliberat_la_data = "01-01-2000",
valabil_pana_la = "31-12-2030",
cnp = "1790121445362",
iban = "RO00BTRL00042163",
banca = "BT",
c_localitatea = "Bucuresti",
c_strada = "Aleea Alexandru",
c_nr = "1",
c_cod_cladire = "bl1",
c_apt = "1",
c_cod_postal = "10203",
c_judet = "Sector 1",
c_nr_loc_consum = "XX123000456",
c_cod_loc_consum = "ZZ098755555",
c_distribuitor = "Enel",
c_serie_contor = "BB4456",
c_putere = "220",
denumire_oferta = "engie e-Ampero",
pret_dela = "01-07-2018",
pret_pana_la = "01-07-2020",
pret = "184",
nivel_tensiune = "35",
termen_plata = "integral",
f_localitate = "Bucuresti",
f_strada = "Aleea Alexandru",
f_nr = "1",
f_ap = "bl1",
f_cod_postal = "10203",
f_judet = "Sector 1",
ianuarie = "",
februarie = "",
martie = "",
aprilie = "",
mai = "",
iunie = "",
iulie = "",
august = "",
septembrie = "",
octombrie = "",
noiembrie = "",
decembrie = "",
total = "",
cod_move_in = "4000000123",
cod_partener = "300004449998",
vanzator = "Brian Tracy",
client = "Bratcoveanu Nicoleta"
};
}
public XmlDocument FormatedXmlContractEngie(CtrEngieDataDTO engieData, string xmlOverrideOptionTests)
{
XElement document = XElement.Parse(xmlOverrideOptionTests);
document.SetElementValue("name", "Contract Electricitate " + engieData.client);
document.SetElementValue("eMailSubject", "Contract Electricitate " + engieData.client);
var listOfTextBoxes = document.Element("overrideFormFieldValues").Element("document").Descendants("textBox");
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "cod_move_in").SetElementValue("value", engieData.cod_move_in);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "cod_partener").SetElementValue("value", engieData.cod_partener);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "nr_contract").SetElementValue("value", engieData.nr_contract);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "data_semnarii").SetElementValue("value", engieData.data_semnarii);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "nume_contractant").SetElementValue("value", engieData.nume_contractant);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "localitate").SetElementValue("value", engieData.localitate);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "strada").SetElementValue("value", engieData.strada);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "nr").SetElementValue("value", engieData.nr);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "cod_cladire").SetElementValue("value", engieData.cod_cladire);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "apt").SetElementValue("value", engieData.apt);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "cod_postal").SetElementValue("value", engieData.cod_postal);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "judet").SetElementValue("value", engieData.judet);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "tel").SetElementValue("value", engieData.tel);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "email").SetElementValue("value", engieData.email);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "serie_nr_ci").SetElementValue("value", engieData.serie_nr_ci);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "eliberat_de").SetElementValue("value", engieData.eliberat_de);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "eliberat_la_data").SetElementValue("value", engieData.eliberat_la_data);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "valabil_pana_la").SetElementValue("value", engieData.valabil_pana_la);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "cnp").SetElementValue("value", engieData.cnp);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "iban").SetElementValue("value", engieData.iban);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "banca").SetElementValue("value", engieData.banca);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_localitatea").SetElementValue("value", engieData.c_localitatea);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_strada").SetElementValue("value", engieData.c_strada);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_nr").SetElementValue("value", engieData.c_nr);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_cod_cladire").SetElementValue("value", engieData.c_cod_cladire);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_apt").SetElementValue("value", engieData.c_apt);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_cod_postal").SetElementValue("value", engieData.c_cod_postal);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_judet").SetElementValue("value", engieData.c_judet);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_nr_loc_consum").SetElementValue("value", engieData.c_nr_loc_consum);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_cod_loc_consum").SetElementValue("value", engieData.c_cod_loc_consum);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_distribuitor").SetElementValue("value", engieData.c_distribuitor);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_serie_contor").SetElementValue("value", engieData.c_serie_contor);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "c_putere").SetElementValue("value", engieData.c_putere);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "denumire_oferta").SetElementValue("value", engieData.denumire_oferta);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "pret_dela").SetElementValue("value", engieData.pret_dela);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "pret_pana_la").SetElementValue("value", engieData.pret_pana_la);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "pret").SetElementValue("value", engieData.pret);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "nivel_tensiune").SetElementValue("value", engieData.nivel_tensiune);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "termen_plata").SetElementValue("value", engieData.termen_plata);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "f_localitate").SetElementValue("value", engieData.f_localitate);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "f_strada").SetElementValue("value", engieData.f_strada);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "f_nr").SetElementValue("value", engieData.f_nr);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "f_ap").SetElementValue("value", engieData.f_ap);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "f_cod_postal").SetElementValue("value", engieData.f_cod_postal);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "f_judet").SetElementValue("value", engieData.f_judet);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "ianuarie").SetElementValue("value", engieData.ianuarie);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "februarie").SetElementValue("value", engieData.februarie);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "martie").SetElementValue("value", engieData.martie);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "aprilie").SetElementValue("value", engieData.aprilie);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "mai").SetElementValue("value", engieData.mai);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "iunie").SetElementValue("value", engieData.iunie);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "iulie").SetElementValue("value", engieData.iulie);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "august").SetElementValue("value", engieData.august);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "septembrie").SetElementValue("value", engieData.septembrie);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "octombrie").SetElementValue("value", engieData.octombrie);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "noiembrie").SetElementValue("value", engieData.noiembrie);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "decembrie").SetElementValue("value", engieData.decembrie);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "total").SetElementValue("value", engieData.total);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "vanzator").SetElementValue("value", engieData.vanzator);
listOfTextBoxes.Single(x => (string)x.Attribute("name") == "client").SetElementValue("value", engieData.client);
var documentc = new XmlDocument();
documentc.LoadXml(document.ToString());
return(documentc);
}
public async Task <List <CtrEngieDataDTO> > ReadDataContractEngie(string _connectionPath)
{
var returnData = new List <CtrEngieDataDTO>();
var ctrEngieDataDTO = new CtrEngieDataDTO();
string[] strProperties = new string[60];
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 CtrEngieDataDTO
{
nr_contract = strProperties[0],
data_semnarii = strProperties[1],
nume_contractant = strProperties[2],
localitate = strProperties[3],
strada = strProperties[4],
nr = strProperties[5],
cod_cladire = strProperties[6],
apt = strProperties[7],
cod_postal = strProperties[8],
judet = strProperties[9],
tel = strProperties[10],
email = strProperties[11],
serie_nr_ci = strProperties[12],
eliberat_de = strProperties[13],
eliberat_la_data = strProperties[14],
valabil_pana_la = strProperties[15],
cnp = strProperties[16],
iban = strProperties[17],
banca = strProperties[18],
c_localitatea = strProperties[19],
c_strada = strProperties[20],
c_nr = strProperties[21],
c_cod_cladire = strProperties[22],
c_apt = strProperties[23],
c_cod_postal = strProperties[24],
c_judet = strProperties[25],
c_nr_loc_consum = strProperties[26],
c_cod_loc_consum = strProperties[27],
c_distribuitor = strProperties[28],
c_serie_contor = strProperties[29],
c_putere = strProperties[30],
denumire_oferta = strProperties[31],
pret_dela = strProperties[32],
pret_pana_la = strProperties[33],
pret = strProperties[34],
nivel_tensiune = strProperties[35],
termen_plata = strProperties[36],
f_localitate = strProperties[37],
f_strada = strProperties[38],
f_nr = strProperties[39],
f_ap = strProperties[40],
f_cod_postal = strProperties[41],
f_judet = strProperties[42],
ianuarie = strProperties[43],
februarie = strProperties[44],
martie = strProperties[45],
aprilie = strProperties[46],
mai = strProperties[47],
iunie = strProperties[48],
iulie = strProperties[49],
august = strProperties[50],
septembrie = strProperties[51],
octombrie = strProperties[52],
noiembrie = strProperties[53],
decembrie = strProperties[54],
total = strProperties[55],
cod_move_in = strProperties[56],
cod_partener = strProperties[57],
vanzator = strProperties[58],
client = strProperties[59]
});
}
}
return(returnData);
}
public List <string> SendToSign_CTR(CtrEngieDataDTO d)
{
var returnUrlsLinks = new List <string>();
try
{
string xmlOverrideOptionTests = File.ReadAllText(_appConfiguration.ContractElSignConfig);
var documentc = _signUtil.FormatedXmlContractEngie(d, xmlOverrideOptionTests);
var ws = GetSawWebService.eSawWebService(_appConfiguration.eSawUrlBeta3);
if (ws != null)
{
string[] documentsPath = new string[] { _appConfiguration.ContractFormPdf };
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);
}
}
