public StringBuilder CreateTableHTMLHistorico(DataTable dtHistoricRPU)
{
Class.Encrypt oclsEncrypt = new Class.Encrypt();
//Building an HTML string.
StringBuilder html = new StringBuilder();
try
{
string strRPU = string.Empty;
html.Append(" <thead>");
//Building the Header row.
html.Append("<tr>");
foreach (DataColumn column in dtHistoricRPU.Columns)
{
html.Append("<th>");
html.Append(column.ColumnName);
html.Append("</th>");
}
html.Append("</tr>");
html.Append("</thead>");
html.Append("<tbody id='myTable'> ");
//Building the Data rows.
foreach (DataRow row in dtHistoricRPU.Rows)
{
html.Append("<tr>");
foreach (DataColumn column in dtHistoricRPU.Columns)
{
html.Append("<td>");
if (row[column.ColumnName].ToString() != "01-01-1900")
{
html.Append(row[column.ColumnName]);
}
else
{
html.Append(" ");
}
html.Append("</td>");
}
html.Append("</tr>");
}
html.Append("</tbody>");
}
catch (Exception ex)
{
LogError.LogErrorMedicion clsError = new LogError.LogErrorMedicion();
clsError.logMessage = ex.ToString();
clsError.logModule = "CreateTableHTMLHistorico";
clsError.LogWrite();
}
return(html);
}
public Boolean InsertAgreement(string strAgreement, string strRPU, string strChecked, string strEmail, decimal decCharge)
{
//SqlDataReader drInsert;
DataTable dtData;
Boolean bMsg = true;
Class.Encrypt oclsEncrypt = new Class.Encrypt();
string strAgreementDecrypted = string.Empty;
LogError.LogErrorMedicion clsError = new LogError.LogErrorMedicion();
try
{
oclsEncrypt.strData = strAgreement;
strAgreementDecrypted = oclsEncrypt.DecryptData();
Int16 intSeleccionado = Convert.ToInt16(strChecked);
string query = string.Format("spInsertar_ConvenioPuntoCarga");
SqlParameter[] sqlParameters = new SqlParameter[5];
sqlParameters[0] = new SqlParameter("@chrRPU", SqlDbType.NVarChar);
sqlParameters[0].Value = strRPU;
sqlParameters[1] = new SqlParameter("@chrConvenio", SqlDbType.NVarChar);
sqlParameters[1].Value = strAgreementDecrypted;
sqlParameters[2] = new SqlParameter("@intSeleccionado", SqlDbType.SmallInt);
sqlParameters[2].Value = intSeleccionado;
sqlParameters[3] = new SqlParameter("@chrEmail", SqlDbType.NVarChar);
sqlParameters[3].Value = strEmail;
sqlParameters[4] = new SqlParameter("@dblTotalCarga", SqlDbType.Float);
sqlParameters[4].Value = decCharge;
con.dbConnection();
dtData = con.executeStoreProcedure(query, sqlParameters);
}
catch (Exception ex)
{
clsError.logMessage = ex.ToString();
clsError.logModule = "InsertAgreement";
clsError.LogWrite();
bMsg = false;
}
return(bMsg);
}
public StringBuilder CreateTableHTMLArchivos(DataTable dtAgreements, string strFullPath)
{
Class.Encrypt oclsEncrypt = new Class.Encrypt();
//Building an HTML string.
StringBuilder html = new StringBuilder();
try
{
string strAgregar = string.Empty;
html.Append(" <thead>");
//Building the Header row.
html.Append("<tr>");
foreach (DataColumn column in dtAgreements.Columns)
{
if ((column.ColumnName == "IdArchivosComunicacion") || (column.ColumnName == "Archivo") || (column.ColumnName == "TipoArchivo") || (column.ColumnName == "ExtensionArchivo") || (column.ColumnName == "FechaCreacion"))
{
html.Append("<th style='display:none;'> ");
}
else
{
html.Append("<th>");
}
html.Append(column.ColumnName);
html.Append("</th>");
}
html.Append("</tr>");
html.Append("</thead>");
html.Append("<tbody id='myTable'> ");
//Building the Data rows.
foreach (DataRow row in dtAgreements.Rows)
{
html.Append("<tr>");
//string sFilename = String.Format("<a href='\\servername\\folder1\\folder2\\folder3\\{0}' target = '_blank' > " + row[1] + "</ a > ", row[2] + row[4]);
html.Append("<td >");//strFullPath
html.Append("<a href='" + "\\uploads\\Comunicacion\\" + row[1] + "' target='_Blank'>" + row[1] + "</a>");
html.Append("</td>");
//foreach (DataColumn column in dtAgreements.Columns)
//{
// if ((column.ColumnName == "IdArchivosComunicacion") || (column.ColumnName == "Archivo") || (column.ColumnName == "TipoArchivo") || (column.ColumnName == "ExtensionArchivo") || (column.ColumnName == "FechaCreacion"))
// {
// html.Append("<td style='display:none;'>");
// html.Append(row[column.ColumnName]);
// html.Append("</td>");
// }
// else
// {
// html.Append("<td>");
// html.Append(row[column.ColumnName]);
// html.Append("</td>");
// }
//}
}
html.Append("</tbody>");
}
catch (Exception ex)
{
LogError.LogErrorMedicion clsError = new LogError.LogErrorMedicion();
clsError.logMessage = ex.ToString();
clsError.logModule = "CreateTableHTML";
clsError.LogWrite();
}
return(html);
}
public String UploadFiles(System.Web.UI.WebControls.FileUpload UploadFiles, string strPathServer, HttpFileCollection hfc, string strEmail, string strRPU)
{
String strMsg = string.Empty;
Class.Encrypt oclsEncrypt = new Class.Encrypt();
try
{
Int32 intNumMaxUploadFiles = GetMaxNumber2UploadFiles();
string strArchivo = DateTime.Now.ToString("ddMMyyyyhhmmssffff");
oclsEncrypt.strData = strArchivo;
strArchivo = oclsEncrypt.EncryptData();
if (!Directory.Exists(strPathServer))
{
Directory.CreateDirectory(strPathServer);
}
if (UploadFiles.HasFile)
{
int iUploadedCnt = 0;
int iFailedCnt = 0;
if (hfc.Count <= intNumMaxUploadFiles) // 10 FILES RESTRICTION.
{
for (int i = 0; i <= hfc.Count - 1; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0)
{
if (!File.Exists(strPathServer + Path.GetFileName(strArchivo)))
{
DirectoryInfo objDir = new DirectoryInfo(strPathServer);
string sFileName = Path.GetFileName(hpf.FileName);
string sFileExt = Path.GetExtension(hpf.FileName);
FileInfo[] objFI = objDir.GetFiles(sFileName.Replace(sFileExt, "") + ".*");
if (objFI.Length > 0)
{
// CHECK IF FILE WITH THE SAME NAME EXISTS
//(IGNORING THE EXTENTIONS).
foreach (FileInfo file in objFI)
{
string sFileName1 = objFI[0].Name;
string sFileExt1 = Path.GetExtension(objFI[0].Name);
if (sFileName1.Replace(sFileExt1, "") == sFileName.Replace(sFileExt, ""))
{
iFailedCnt += 1; // NOT ALLOWING DUPLICATE.
break;
}
}
}
else
{
string strContentType = hpf.ContentType.ToString();
// SAVE THE FILE IN A FOLDER.
hpf.SaveAs(strPathServer + Path.GetFileName(sFileName));
//save to the database like a log
Boolean strSavedFile = SaveFileCommunication2DB(sFileName, sFileExt, strEmail, strRPU, strArchivo, strContentType);
iUploadedCnt += 1;
}
}
else
{
string strContentType = hpf.ContentType.ToString();
if (File.Exists(strPathServer + Path.GetFileName(strArchivo)))
{
string sFileName = Path.GetFileName(hpf.FileName);
string sFileExt = Path.GetExtension(hpf.FileName);
File.Delete(strPathServer + Path.GetFileName(strArchivo + '.' + sFileExt));
hpf.SaveAs(strPathServer + Path.GetFileName(strArchivo + '.' + sFileExt));
Boolean strSavedFile = SaveFileCommunication2DB(sFileName, sFileExt, strEmail, strRPU, strArchivo, strContentType);
}
}
}
}
}
}
}
catch (Exception ex)
{
LogError.LogErrorMedicion clsError = new LogError.LogErrorMedicion();
clsError.logMessage = ex.ToString();
clsError.logModule = "UploadFiles";
clsError.LogWrite();
}
return(strMsg);
}
public StringBuilder CreateTableHTML4Agreement(DataTable dtAgreements)
{
Class.Encrypt oclsEncrypt = new Class.Encrypt();
//Building an HTML string.
StringBuilder html = new StringBuilder();
try
{
string strAgregar = string.Empty;
string strrpu;
html.Append(" <thead>");
//Building the Header row.
html.Append("<tr>");
foreach (DataColumn column in dtAgreements.Columns)
{
if (column.ColumnName == "RPU")
{
//html.Append("Activo");
}
else
{
html.Append("<th>");
html.Append(column.ColumnName);
html.Append("</th>");
}
}
html.Append("</tr>");
html.Append("</thead>");
html.Append("<tbody id='myTable'> ");
//Building the Data rows.
foreach (DataRow row in dtAgreements.Rows)
{
html.Append("<tr>");
foreach (DataColumn column in dtAgreements.Columns)
{
if (column.ColumnName == "RPU")
{
strrpu = Convert.ToString(row["RPU"]);
strAgregar = Convert.ToString(row["Convenio"]);
oclsEncrypt.strData = strAgregar;
strAgregar = oclsEncrypt.EncryptData();
if (!string.IsNullOrEmpty(strrpu))
{
// html.Append("<td>");
//html.Append("<span class='glyphicon glyphicon-ok text-success text-center' aria-hidden='true'></span>");
////html.Append("<input type='checkbox' class='chk' runat='server' id='" + strAgregar + "' value='' checked='checked' disabled>");
//html.Append("</td>");
}
else
{
// html.Append("<td>");
//html.Append("<input type='checkbox' class='chk' runat='server' id='" + strAgregar + "' value='' >");
//html.Append("</td>");
}
}
else if (column.ColumnName == "CARGA")
{
html.Append("<td>");
//html.Append("<input type='number' id='str" + strAgregar + "' value = '" + row[column.ColumnName] + "' class='clsnmbr' data-bv-integer-message='Campo solo numérico' readonly >");
html.Append("<span>" + row[column.ColumnName] + "</span>");
html.Append("</td>");
}
else
{
html.Append("<td>");
html.Append(row[column.ColumnName]);
html.Append("</td>");
}
}
}
html.Append("</tbody>");
}
catch (Exception ex)
{
LogError.LogErrorMedicion clsError = new LogError.LogErrorMedicion();
clsError.logMessage = ex.ToString();
clsError.logModule = "CreateTableHTML";
clsError.LogWrite();
}
return(html);
}
/// <summary>
/// Create table divison schema just columns
/// </summary>
/// <returns></returns>
public StringBuilder CreateTableHTML()
{
Class.Encrypt oclsEncrypt = new Class.Encrypt();
//Building an HTML string.
StringBuilder html = new StringBuilder();
try
{
string strRPU = string.Empty;
html.Append(" <thead>");
//Building the Header row.
html.Append("<tr>");
foreach (DataColumn column in dtElectricMeters.Columns)
{
if ((column.ColumnName == "RPUPuntoCarga") ||
(column.ColumnName == "IdDivivion") || (column.ColumnName == "IdDIVISION") ||
(column.ColumnName == "IdZona") || (column.ColumnName == "IdZONA") ||
(column.ColumnName == "IdGestorComercial") || (column.ColumnName == "IdGestorMedicion") ||
(column.ColumnName == "IdEstatus") ||
(column.ColumnName == "IdTarifa") ||
(column.ColumnName == "IdGrupo")
)
{
html.Append("<th style='display:none;'>");
}
else
{
html.Append("<th>");
}
html.Append(column.ColumnName);
html.Append("</th>");
}
html.Append("</tr>");
html.Append("</thead>");
html.Append("<tbody id='myTable'> ");
//Building the Data rows.
foreach (DataRow row in dtElectricMeters.Rows)
{
html.Append("<tr>");
foreach (DataColumn column in dtElectricMeters.Columns)
{
if (column.ColumnName == "Con Prelación")
{
if (row[18].ToString() == "" || row[18].ToString() == "0")
{
html.Append("<td>");
html.Append("No");
html.Append("</td>");
}
else if (row[18].ToString() == "1")
{
html.Append("<td>");
html.Append("Si");
html.Append("</td>");
}
}
else if ((column.ColumnName == "RPUPuntoCarga") ||
(column.ColumnName == "IdDivivion") || (column.ColumnName == "IdDIVISION") ||
(column.ColumnName == "IdZona") || (column.ColumnName == "IdZONA") ||
(column.ColumnName == "IdEstatus") ||
(column.ColumnName == "IdTarifa") ||
(column.ColumnName == "IdGrupo") ||
(column.ColumnName == "IdGestorMedicion") ||
(column.ColumnName == "IdGestorComercial")
)
{
html.Append("<td style='display:none;'>");
html.Append(row[column.ColumnName]);
html.Append("</td>");
}
else
{
html.Append("<td>");
html.Append(row[column.ColumnName]);
html.Append("</td>");
}
if (column.ColumnName == "RPU")
{
strRPU = Convert.ToString(row[column.ColumnName]);
//if (!string.IsNullOrEmpty(strRPU)) {
// oclsEncrypt.strData = strRPU;
// strRPU = oclsEncrypt.EncryptData();
//}
}
}
html.Append("<td>");
html.Append("<a href='#' class='btn btn-warning btn-sm' data-toggle='modal' data-target='.bs-example-modal-lg' aria-label='Left Align' title='Contactos' data-placement='top' style='width:17px; height:17px;'><img src='img/account-card-details.png' width='15px' height='15px' style='margin-top: -14px; margin-left: -8px; ' ></a>");
html.Append("<p></p>");
html.Append("<a href='comunicaciones.aspx?rpu=" + strRPU + "' class='btn btn-info btn-sm' title='Comunicacion' data-target='.bs-example-modal-lg' data-toggle='tooltip' data-placement='top' style='width:17px; height:17px;'><img src='img/access-point-network.png' width='15px' height='15px' style='margin-top: -14px; margin-left: -8px; ' ></a>");
html.Append("</td>");
html.Append("<td>");
html.Append("<a href='medidores.aspx?rpu=" + strRPU + "' class='btn btn-success btn-sm' aria-label='Left Align' title='Medidores' data-toggle='tooltip' data-placement='top' style='width:17px; height:17px;' ><img src='img/smartmeter.png' width='15px' height='15px' style='margin-top: -14px; margin-left: -8px; ' ></a><p></p>");
html.Append("</td>");
//html.Append("<td>");
//html.Append("<a href='#' class='btn btn-info btn-sm' aria-label='Left Align' title='Eliminar' data-toggle='tooltip' data-placement='top' ><span class='glyphicon glyphicon-trash btn-sm'></span></a>");
//html.Append("</td>");
html.Append("</tr>");
}
html.Append("</tbody>");
}
catch (Exception ex)
{
LogError.LogErrorMedicion clsError = new LogError.LogErrorMedicion();
clsError.logMessage = ex.ToString();
clsError.logModule = "CreateTableHTML";
clsError.LogWrite();
}
return(html);
}
/// <summary>
/// Create table divison schema just columns
/// </summary>
/// <returns></returns>
public StringBuilder CreateTableHTML(DataTable dtHistoricRPU)
{
Class.Encrypt oclsEncrypt = new Class.Encrypt();
//Building an HTML string.
StringBuilder html = new StringBuilder();
string strFileName;
try
{
string strRPU = string.Empty;
html.Append(" <thead>");
//Building the Header row.
html.Append("<tr>");
foreach (DataColumn column in dtHistoricRPU.Columns)
{
if (column.ColumnName == "NombreArchivo")
{
html.Append("<th id='hidefile'>");
html.Append("ARCHIVO ADJUNTO");
html.Append("</th>");
}
else if (column.ColumnName == "Archivo")
{
}
else
{
html.Append("<th>");
html.Append(column.ColumnName);
html.Append("</th>");
}
}
html.Append("</tr>");
html.Append("</thead>");
html.Append("<tbody id='myTable'> ");
//Building the Data rows.
foreach (DataRow row in dtHistoricRPU.Rows)
{
html.Append("<tr>");
foreach (DataColumn column in dtHistoricRPU.Columns)
{
if (column.ColumnName == "NombreArchivo")
{
html.Append("<td id='hidefile'>");
strFileName = Convert.ToString(row[column.ColumnName]);
//if (!string.IsNullOrEmpty(strFileName))
//{
// oclsEncrypt.strData = strFileName;
// strFileName = oclsEncrypt.EncryptData();
//}
html.Append("<a href='bajararchivo.aspx?doc=" + Convert.ToString(row["Archivo"]) + "'>" + Convert.ToString(row[column.ColumnName]) + "</a>");
html.Append("</td>");
}
else if (column.ColumnName == "Archivo")
{
}
else
{
if (column.ColumnName == "HABILITADO")
{
html.Append("<td class='text-center'>");
if (Convert.ToString(row[column.ColumnName]) == "1")
{
html.Append("<span class='glyphicon glyphicon-ok text-success text-center' aria-hidden='true'></span>");
}
else if (Convert.ToString(row[column.ColumnName]) == "0")
{
html.Append("<span class='glyphicon glyphicon-remove text-danger text-center' aria-hidden='true'></span>");
}
html.Append("</td>");
}
else
{
html.Append("<td>");
html.Append(row[column.ColumnName]);
html.Append("</td>");
}
if (column.ColumnName == "RPU")
{
strRPU = Convert.ToString(row[column.ColumnName]);
if (!string.IsNullOrEmpty(strRPU))
{
oclsEncrypt.strData = strRPU;
strRPU = oclsEncrypt.EncryptData();
}
}
}
}
//html.Append("<td>");
//html.Append("<a href='#' class='btn btn-warning btn-sm' data-toggle='modal' data-target='.bs-example-modal-lg' aria-label='Left Align' title='Contactos' data-placement='top' ><img src='img/account-card-details.png'></a>");
//html.Append("<p></p>");
//html.Append("<a href='comunicaciones.aspx?rpu=" + strRPU + "' class='btn btn-info btn-sm' title='Comunicacion' data-target='.bs-example-modal-lg' data-toggle='tooltip' data-placement='top'><img src='img/access-point-network.png'></a>");
//html.Append("</td>");
//html.Append("<td>");
//html.Append("<a href='medidores.aspx?rpu=" + strRPU + "' class='btn btn-success btn-sm' aria-label='Left Align' title='Medidores' data-toggle='tooltip' data-placement='top' ><img src='img/smartmeter.png'></a><p></p>");
//html.Append("</td>");
//html.Append("<td>");
//html.Append("<a href='#' class='btn btn-info btn-sm' aria-label='Left Align' title='Eliminar' data-toggle='tooltip' data-placement='top' ><span class='glyphicon glyphicon-trash btn-sm'></span></a>");
//html.Append("</td>");
//html.Append("</tr>");
}
html.Append("</tbody>");
}
catch (Exception ex)
{
LogError.LogErrorMedicion clsError = new LogError.LogErrorMedicion();
clsError.logMessage = ex.ToString();
clsError.logModule = "CreateTableHTML";
clsError.LogWrite();
}
return(html);
}
/// <summary>
/// Create table divison schema just columns
/// </summary>
/// <returns></returns>
public StringBuilder CreateCommunicationTableHTML(DataTable dtCommunication)
{
//Building an HTML string.
StringBuilder html = new StringBuilder();
Class.Encrypt oclsEncrypt = new Class.Encrypt();
string strFileName;
string strRPU = string.Empty;
try
{
html.Append(" <thead>");
//Building the Header row.
html.Append("<tr>");
foreach (DataColumn column in dtCommunication.Columns)
{
if (column.ColumnName == "NombreArchivo")
{
html.Append("<th id='hidefile'>");
html.Append("ARCHIVO ADJUNTO");
html.Append("</th>");
}
else if (column.ColumnName == "Archivo")
{
}
else
{
html.Append("<th>");
html.Append(column.ColumnName);
html.Append("</th>");
}
}
html.Append("</tr>");
html.Append("</thead>");
html.Append("<tbody id='myTableCom'> ");
//Building the Data rows.
foreach (DataRow row in dtCommunication.Rows)
{
html.Append("<tr>");
foreach (DataColumn column in dtCommunication.Columns)
{
if (column.ColumnName == "NombreArchivo")
{
html.Append("<td id='hidefile'>");
strFileName = Convert.ToString(row[column.ColumnName]);
//if (!string.IsNullOrEmpty(strFileName))
//{
// oclsEncrypt.strData = strFileName;
// strFileName = oclsEncrypt.EncryptData();
//}
html.Append("<a href='bajararchivo.aspx?doc=" + Convert.ToString(row["Archivo"]) + "'>" + Convert.ToString(row[column.ColumnName]) + "</a>");
html.Append("</td>");
}
else if (column.ColumnName == "Archivo")
{
}
else
{
if (column.ColumnName == "HABILITADO")
{
html.Append("<td class='text-center'>");
if (Convert.ToString(row[column.ColumnName]) == "1")
{
html.Append("<span class='glyphicon glyphicon-ok text-success text-center' aria-hidden='true'></span>");
}
else if (Convert.ToString(row[column.ColumnName]) == "0")
{
html.Append("<span class='glyphicon glyphicon-remove text-danger text-center' aria-hidden='true'></span>");
}
html.Append("</td>");
}
else
{
html.Append("<td>");
html.Append(row[column.ColumnName]);
html.Append("</td>");
}
if (column.ColumnName == "RPU")
{
strRPU = Convert.ToString(row[column.ColumnName]);
if (!string.IsNullOrEmpty(strRPU))
{
oclsEncrypt.strData = strRPU;
strRPU = oclsEncrypt.EncryptData();
}
}
}
}
//html.Append("<td><a href='#' class='btn btn-primary btn-xs' data-toggle='modal' data-target='#edit' contenteditable='false'><span class='glyphicon glyphicon-pencil'></span></a></td>");
//html.Append("<td><a href='#' class='btn btn-danger btn-xs' data-toggle='modal' data-target='#delete' contenteditable='false'><span class='glyphicon glyphicon-trash'></span></a></td>");
//html.Append("</tr>");
}
html.Append("</tbody>");
}
catch (Exception ex)
{
LogError.LogErrorMedicion clsError = new LogError.LogErrorMedicion();
clsError.logMessage = ex.ToString();
clsError.logModule = "CreateTableHTML";
clsError.LogWrite();
}
return(html);
}
