/// <summary>
/// Registra las pistas de auditoria
/// de inserción de un responsable de solución
/// </summary>
private void InsertSolutionRespAudit()
{
String[] fieldNames = { "NAME", "EMAIL", "AREA", "RECORD_STATUS" };
String[] fieldValues = { tbName.Text, tbEmail.Text, tbArea.Text, ddlStatus.SelectedValue };
SafetyPad.RegAuditTrail(SafetyPad.GetUserLogin(), fieldNames, fieldValues, "IN_SOLUTION_RESPONSIBLES", "C");
}
protected void ibtnEditReg_Click(object sender, ImageClickEventArgs e)
{
try
{
Session["Action"] = ConfigurationTool.Command.Update;
//Obtner la fila donde se activo el evento
GridViewRow gvRow = (GridViewRow)(sender as ImageButton).Parent.Parent;
int rowIndex;
rowIndex = gvRow.RowIndex;
/*tbCodigo.Enable = false;
* tbAlias.Enable = false;*/
pnlEditor.Visible = true;
EditHTML(rowIndex);
pnlLoad.Visible = false;
Utilities.CreateConfirmBox(btnSave, "Esta seguro de realizar cambio?");
//Utilities.CreateConfirmBox(btnSaveAsunto, "Esta seguro de realizar cambio?");
}
catch (Exception ex)
{
TitleSubtitle1.SetSubtitle("Ocurrió un inconveniente");
TitleSubtitle1.SetSubTitleVisible = true;
SafetyPad.SetLogRecord("HtmlEditor.aspx.cs", ex.ToString());
}
}
/// <summary>
/// Registra las pistas de auditoria
/// de inserción de un responsable de solución
/// </summary>
private void InsertEmailMaintAudit()
{
String[] fieldNames = { "EMAIL", "RECORD_STATUS" };
String[] fieldValues = { tbEmail.Text, ddlStatus.SelectedValue };
SafetyPad.RegAuditTrail(SafetyPad.GetUserLogin(), fieldNames, fieldValues, "IN_EMAIL_MAINTENANCES", "C");
}
/// <summary>
/// Registra las pistas de auditoria
/// de inserción de un responsable de solución
/// </summary>
private void InsertParameters()
{
String[] fieldNames = { "COD_PARAMETER", "PARAMETER_ALIAS", "PARAMETER_VALUE" };
String[] fieldValues = { tbCodigo.Text, tbAlias.Text, tbValor.Text };
SafetyPad.RegAuditTrail(SafetyPad.GetUserLogin(), fieldNames, fieldValues, "IN_PARAMETERS", "C");
}
/// <summary>
/// Autor: Olonyl Rocha Landeros
/// Fecha: 29/07/2011
/// Descripción: Función que retorna los resultados de una consulta en un DataTable
/// </summary>
/// <param name="query">Consulta de Base de Datos</param>
/// <returns>Resultados de una consulta en un DataTable</returns>
public static int ExecQuery(String query)
{
String stringConection = ConfigurationManager.ConnectionStrings["cnxAPP_APLICACIONES"].ConnectionString;
OracleConnection oracleConnection = new OracleConnection(stringConection);
OracleCommand command = new OracleCommand(query, oracleConnection);//Crear la consulta
OracleTransaction trans = null;
int res;
try
{
oracleConnection.Open();
trans = oracleConnection.BeginTransaction();
command.Transaction = trans;
res = command.ExecuteNonQuery();
trans.Commit();
}
catch (Exception ex)
{
SafetyPad.SetLogRecord("ConfigurationTool.cs", ex.ToString());
if (trans != null)
{
trans.Rollback();
}
throw ex;
}
finally
{
if (oracleConnection.State != ConnectionState.Closed)
{
oracleConnection.Close();
}
}
return(res);
}
/// <summary>
/// Registra las pistas de Auditoria de
/// Inserción
/// </summary>
private void UpdateAffectedClientAudit()
{
String[] fieldNames = { "AFFECTED_CLIENT_NAME", "RECORD_STATUS" };
String[] fieldValues = { tbName.Text, ddlStatus.SelectedValue };
SafetyPad.RegAuditTrail(SafetyPad.GetUserLogin(), fieldNames, fieldValues, "IN_AFFECTED_CLIENTS", "U");
}
/// <summary>
/// Metodo para establecer las acciones
/// del usuario en sesion
/// </summary>
private void SetUserPermissions()
{
btnSearchEmail.Enabled = SafetyPad.IsAllowed("Buscar");
btnShowAllEmail.Enabled = SafetyPad.IsAllowed("MostrarTodos");
btnSave.Enabled = SafetyPad.IsAllowed("Guardar");
gvEmail.Visible = SafetyPad.IsAllowed("Consultar");
btnNewEmail.Enabled = SafetyPad.IsAllowed("Agregar");
}
/// <summary>
/// Actualiza la información de un
/// responsable de solución
/// Autor: Manuel Gutierrez Rojas
/// Fecha: 18.Oct.2011
/// </summary>
private void Update()
{
SolutionResponsible updResponsible = new SolutionResponsible();
updResponsible.Name = tbName.Text;
updResponsible.Email = tbEmail.Text;
updResponsible.Area = tbArea.Text;
updResponsible.Status = ddlStatus.SelectedValue;
updResponsible.IdCountryR = decimal.Parse(ddlCountries.SelectedValue);
try
{
Decimal codSolutionResponsible = Convert.ToDecimal(Session["COD_SOLUTION_RESPONSIBLE"]);
if (updResponsible.GetUnfinishedIncidents(codSolutionResponsible) > 0 && ddlStatus.SelectedValue == "0")
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = "El Registro no puede ser dado de baja</br>Aún hay incidencias Activas para el";
wucMessageControl.ShowPopup();
}
else
{
updResponsible.UpdateAffectedClient(updResponsible, codSolutionResponsible);
if (updResponsible.Messages.Status == 1)
{
wucMessageControl.Title = "Mensaje";
wucMessageControl.Image = "../include/imagenes/info_32.png";
}
else
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
}
wucMessageControl.Message = updResponsible.Messages.Message;
wucMessageControl.ShowPopup();
//Registrar las pistas de Auditoria
UpdateSolutionRespAudit();
btnNewResponsible_ModalPopupExtender.Enabled = false;
Load_SolutionResponsibles();
}
}
catch (Exception ex)
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = ex.Message.ToString();
wucMessageControl.ShowPopup();
SafetyPad.SetLogRecord("SolutionResponsibles.aspx.cs", ex.ToString());
}
}
/// <summary>
/// Actualizar Valor de Parametro Asunto
/// Fecha: 05.Agost.2015
/// Autor: Xolo
/// </summary>
private void UpdateAsunto()
{
Parameters updParameter = new Parameters();
string ValorFinal = "";
updParameter.CodParameter = Convert.ToDecimal(Session["COD_PARAMETER"]);
updParameter.Alias = "ASUNTO";
foreach (ParameterAsunto Item in ListaValoresAsunto.OrderBy(x => x.Orden).ToList()) //.OrderBy(x => x.Orden).ToList()
{
if (ValorFinal == "")
{
ValorFinal = Item.Name;
}
else
{
ValorFinal = ValorFinal + " || ' - ' || " + Item.Name;
}
}
updParameter.Valor = ValorFinal;
try
{
decimal codParameterAct = Convert.ToDecimal(Session["COD_PARAMETER"]);
updParameter.UpdateParameter(updParameter, codParameterAct);
if (updParameter.Messages.Status == 1)
{
wucMessageControl.Title = "Mensaje";
wucMessageControl.Image = "../include/imagenes/info_32.png";
}
else
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
}
wucMessageControl.Message = updParameter.Messages.Message;
wucMessageControl.ShowPopup();
//Registrar las pistas de Auditoria
//UpdateAffectedClientAudit();
btnAsunto_ModalPopupExtender.Enabled = false;
ListaValoresAsunto.Clear();
Load_Parameters();
}
catch (Exception ex)
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = ex.Message.ToString();
wucMessageControl.ShowPopup();
SafetyPad.SetLogRecord("Parameters.aspx.cs", ex.ToString());
}
}
/// <summary>
/// Metodo para establecer las acciones
/// del usuario en sesion
/// </summary>
private void SetUserPermissions()
{
string userName = SafetyPad.GetUserLogin();
btnSearchClient.Enabled = SafetyPad.IsAllowed("Buscar");
btnShowAllClient.Enabled = SafetyPad.IsAllowed("MostrarTodos");
btnSave.Enabled = SafetyPad.IsAllowed("Guardar");
gvAffectedClients.Visible = SafetyPad.IsAllowed("Consultar");
btnNewClient.Enabled = SafetyPad.IsAllowed("Agregar");
}
/// <summary>
/// Metodo para establecer las acciones
/// del usuario en sesion
/// </summary>
private void SetUserPermissions()
{
string userName = SafetyPad.GetUserLogin();
btnSearchParameter.Enabled = SafetyPad.IsAllowed("Buscar");
btnShowAllParameter.Enabled = SafetyPad.IsAllowed("MostrarTodos");
btnSave.Enabled = SafetyPad.IsAllowed("Guardar");
gvParameters.Visible = SafetyPad.IsAllowed("Consultar");
btnNewParameter.Enabled = SafetyPad.IsAllowed("Agregar");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadDropDown();
hdfEdit.Value = SafetyPad.GetParameterXSA_CUENTA(2); //"EDITAR_SEGM";//
hdfEditRol.Value = SafetyPad.IsAllowed("Editar").ToString(); //"true"; //
//lblMessage.Text = "Valor Parametro 2 cuenta: "+ hdfEdit.Value + " :::::::: Valor Rol: " + hdfEditRol.Value;
}
}
/// <summary>
/// Inserta un nuevo cliente afectado
/// Fecha:17.Oct.2011
/// Autor: Manuel Gutiérrez Rojas
/// </summary>
private void Update()
{
AffectedClient updClient = new AffectedClient();
updClient.Name = tbName.Text;
updClient.Status = ddlStatus.SelectedValue;
try
{
decimal codAffectedClient = Convert.ToDecimal(Session["COD_AFFECTED_CLIENT"]);
if (updClient.GetUnfinishedIncidents(codAffectedClient) > 0 && ddlStatus.SelectedValue == "0")
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = "El Registro no puede ser dado de baja</br>Aún hay incidencias Activas para el";
wucMessageControl.ShowPopup();
}
else
{
updClient.UpdateAffectedClient(updClient, codAffectedClient);
if (updClient.Messages.Status == 1)
{
wucMessageControl.Title = "Mensaje";
wucMessageControl.Image = "../include/imagenes/info_32.png";
}
else
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
}
wucMessageControl.Message = updClient.Messages.Message;
wucMessageControl.ShowPopup();
//Registrar las pistas de Auditoria
//UpdateAffectedClientAudit();
btnNewClient_ModalPopupExtender.Enabled = false;
Load_AffectedClients();
}
}
catch (Exception ex)
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = ex.Message.ToString();
wucMessageControl.ShowPopup();
SafetyPad.SetLogRecord("AffectedClients.aspx.cs", ex.ToString());
}
}
/// <summary>
/// Actualiza la información de un
/// Correo de mantenimiento
/// Autor: Xolo
/// Fecha: 06.Agost.2015
/// </summary>
private void Update()
{
EmailMaintenance updEmail = new EmailMaintenance();
updEmail.Email = tbEmail.Text;
updEmail.Status = ddlStatus.SelectedValue;
updEmail.IdCountryR = decimal.Parse(ddlCountries.SelectedValue);
try
{
Decimal codEmailMaint = Convert.ToDecimal(Session["COD_EMAIL_MAINTENANCE"]);
updEmail.UpdateEmailMaintenance(updEmail, codEmailMaint);
if (updEmail.Messages.Status == 1)
{
wucMessageControl.Title = "Mensaje";
wucMessageControl.Image = "../include/imagenes/info_32.png";
}
else
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
}
wucMessageControl.Message = updEmail.Messages.Message;
wucMessageControl.ShowPopup();
//Registrar las pistas de Auditoria
UpdateEmailMaintAudit();
btnNewEmail_ModalPopupExtender.Enabled = false;
Load_SolutionResponsibles();
}
catch (Exception ex)
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = ex.Message.ToString();
wucMessageControl.ShowPopup();
SafetyPad.SetLogRecord("SolutionResponsibles.aspx.cs", ex.ToString());
}
}
/// <summary>
/// Inserta un nuevo Responsable de solución
/// Autor: Manuel Gutiérrez Rojas
/// Fecha: 18.Oct.2011
/// </summary>
private void Insert()
{
SolutionResponsible newResponsible = new SolutionResponsible();
newResponsible.Name = tbName.Text;
newResponsible.Email = tbEmail.Text;
newResponsible.Area = tbArea.Text;
newResponsible.Status = ddlStatus.SelectedValue;
newResponsible.IdCountryR = decimal.Parse(ddlCountries.SelectedValue);
try
{
newResponsible.InsertSolutionResponsible(newResponsible);
if (newResponsible.Messages.Status == 1)
{
wucMessageControl.Title = "Mensaje";
wucMessageControl.Image = "../include/imagenes/info_32.png";
}
else
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
}
wucMessageControl.Message = newResponsible.Messages.Message;
wucMessageControl.ShowPopup();
//Registrar las pistas de Auditoria
InsertSolutionRespAudit();
btnNewResponsible_ModalPopupExtender.Enabled = false;
Load_SolutionResponsibles();
}
catch (Exception ex)
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = ex.Message.ToString();
wucMessageControl.ShowPopup();
SafetyPad.SetLogRecord("SolutionResponsibles.aspx.cs", ex.ToString());
}
}
protected void btnCancel_Click(object sender, EventArgs e)
{
try
{
TitleSubtitle1.SetSubTitleVisible = false;
pnlLoad.Visible = true;
//CKEdHtml.Text = "";
txtClas.Text = String.Empty;
txtDescript.Text = String.Empty;
txtType.Text = String.Empty;
pnlEditor.Visible = false;
}
catch (Exception ex)
{
TitleSubtitle1.SetSubtitle("Ocurrió un inconveniente");
TitleSubtitle1.SetSubTitleVisible = true;
SafetyPad.SetLogRecord("HtmlEditor.aspx.cs", ex.ToString());
}
}
protected void ddlClasif_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
HTMLEditor incidence = new HTMLEditor();
DataTable dtHtmlList = new DataTable();
Fill_gvEmail(ddlClasif.Text, true);
/* grvHtml.DataSource = dtHtmlList;
* grvHtml.DataBind();*/
}
catch (Exception ex)
{
//TitleSubtitle1.SetSubtitle("Ocurrió un inconveniente");
// TitleSubtitle1.SetSubTitleVisible = true;
SafetyPad.SetLogRecord("HtmlEditor.aspx.cs", ex.ToString());
}
}
/// <summary>
/// Inserta un nuevo cliente afectado
/// Fecha:17.Oct.2011
/// Autor: Manuel Gutiérrez Rojas
/// </summary>
private void Insert()
{
AffectedClient newClient = new AffectedClient();
newClient.Name = tbName.Text;
newClient.Status = ddlStatus.SelectedValue;
try
{
newClient.InsertAffectedClient(newClient);
if (newClient.Messages.Status == 1)
{
wucMessageControl.Title = "Mensaje";
wucMessageControl.Image = "../include/imagenes/info_32.png";
}
else
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
}
wucMessageControl.Message = newClient.Messages.Message;
wucMessageControl.ShowPopup();
//Registrar las pistas de Auditoria
//InsertAffectedClientAudit();
btnNewClient_ModalPopupExtender.Enabled = false;
Load_AffectedClients();
}
catch (Exception ex)
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = ex.Message.ToString();
wucMessageControl.ShowPopup();
SafetyPad.SetLogRecord("AffectedClients.aspx.cs", ex.ToString());
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
//Session["COD_INCIDENCE"] = grvHtml.DataKeys[rowIndex]["COD_HTML_PK"].ToString();
TitleSubtitle1.SetSubTitleVisible = false;
HTMLEditor incidence = new HTMLEditor();
string strHtml = txtContenido.Content;
//strHtml = strHtml.Replace("&","|||");
//strHtml = "'" + strHtml + "'";
string strDesc = txtDescript.Text;
decimal idHtml = Convert.ToDecimal(Session["COD_INCIDENCE"]);
string id2 = Convert.ToString(idHtml);
int id3 = Convert.ToInt32(id2);
//preCKEditorData.InnerText = strHtml;
incidence.UpdateHtml(strHtml, strDesc, idHtml);
if (incidence.Messages.Status == 1)
{
wucMessageControl.Title = "Mensaje";
wucMessageControl.Image = "../include/imagenes/info_32.png";
}
else
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
}
wucMessageControl.Message = incidence.Messages.Message;
wucMessageControl.ShowPopup();
Fill_gvEmail(ddlClasif.Text, true);
pnlEditor.Visible = false;
pnlLoad.Visible = true;
}
catch (Exception ex)
{
TitleSubtitle1.SetSubtitle("Ocurrió un inconveniente");
TitleSubtitle1.SetSubTitleVisible = true;
SafetyPad.SetLogRecord("HtmlEditor.aspx.cs", ex.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
TitleSubtitle1.SetSubTitleVisible = false;
//CKEdHtml.config.uiColor = "#0099FF"; //"#006666"; /*"#BFEE62";*/
//CKEdHtml.config.allowedContent = true;
//CKEdHtml.config.language = "es";
TitleSubtitle1.SetTitle("Administración HTML de Notificaciones"); //Poniendo Título a la página
txtClas.Attributes.Add("readonly", "true"); //Declarando controles como de sólo lectura
txtType.Attributes.Add("readonly", "true");
if (!IsPostBack)
{
LoadGrid();
pnlEditor.Visible = false;
}
}
catch (Exception ex)
{
TitleSubtitle1.SetSubtitle("Ocurrió un inconveniente");
TitleSubtitle1.SetSubTitleVisible = true;
SafetyPad.SetLogRecord("HtmlEditor.aspx.cs", ex.ToString());
}
}
/// <summary>
/// Inserta un nuevo Parametro
/// Fecha: 04.Agost.2015
/// Autor: Xolo
/// </summary>
private void Insert()
{
Parameters newParameter = new Parameters();
// newParameter.CodParameter = Convert.ToDecimal(tbCodigo.Text);
newParameter.Alias = tbAlias.Text;
newParameter.Valor = tbValor.Text;
try
{
//if (newParameter.ExistCodigo(Convert.ToDecimal(tbCodigo.Text)) > 0)
//{
// wucMessageControl.Title = "Error";
// wucMessageControl.Image = "../include/imagenes/error_32.png";
// wucMessageControl.Message = "Ya existe Código";
// wucMessageControl.ShowPopup();
// ClearFields();
//}
//else
if (newParameter.ExistAlia(tbAlias.Text) > 0)
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = "Ya existe un parámetro con el mismo nombre";
wucMessageControl.ShowPopup();
ClearFields();
}
else
{
newParameter.InsertParameter(newParameter);
if (newParameter.Messages.Status == 1)
{
wucMessageControl.Title = "Mensaje";
wucMessageControl.Image = "../include/imagenes/info_32.png";
}
else
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
}
wucMessageControl.Message = newParameter.Messages.Message;
wucMessageControl.ShowPopup();
//Registrar las pistas de Auditoria
//InsertAffectedClientAudit();
btnNewParameter_ModalPopupExtender.Enabled = false;
Load_Parameters();
}
}
catch (Exception ex)
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = ex.Message.ToString();
wucMessageControl.ShowPopup();
SafetyPad.SetLogRecord("Parameters.aspx.cs", ex.ToString());
}
}
/// <summary>
/// Actualiza un Parametro
/// Fecha: 04.Agost.2015
/// Autor: Xolo
/// </summary>
private void Update()
{
Parameters updParameter = new Parameters();
updParameter.CodParameter = Convert.ToDecimal(tbCodigo.Text);
updParameter.Alias = tbAlias.Text;
updParameter.Valor = tbValor.Text;
try
{
decimal codParameter = Convert.ToDecimal(tbCodigo.Text);
decimal codParameterAct = Convert.ToDecimal(Session["COD_PARAMETER"]);
if (updParameter.ExistCodigo(codParameter) > 0 && hdfCodigo.Value != tbCodigo.Text.Trim())
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = "Ya existe un parámetro con el mismo código";
wucMessageControl.ShowPopup();
ClearFields();
}
else if (updParameter.ExistAlia(tbAlias.Text) > 0 && hdfAlias.Value != tbAlias.Text.Trim())
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = "Ya existe un parámetro con el mismo nombre";
wucMessageControl.ShowPopup();
ClearFields();
}
else
{
updParameter.UpdateParameter(updParameter, codParameterAct);
if (updParameter.Messages.Status == 1)
{
wucMessageControl.Title = "Mensaje";
wucMessageControl.Image = "../include/imagenes/info_32.png";
}
else
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
}
wucMessageControl.Message = updParameter.Messages.Message;
wucMessageControl.ShowPopup();
//Registrar las pistas de Auditoria
//UpdateAffectedClientAudit();
btnNewParameter_ModalPopupExtender.Enabled = false;
Load_Parameters();
}
}
catch (Exception ex)
{
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
wucMessageControl.Message = ex.Message.ToString();
wucMessageControl.ShowPopup();
SafetyPad.SetLogRecord("Parameters.aspx.cs", ex.ToString());
}
}
/// <summary>
/// Enviar comentario
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void sendButton_Click(object sender, EventArgs e)
{
try
{
String sql, strComment, segmentType = string.Empty, codLevels = string.Empty;
string codSegm = string.Empty, codType = string.Empty, codLevel = string.Empty, seqLevel = string.Empty, seqLevelT = string.Empty; //,codMot=string.Empty;
bool edit = false;
//vfin = false;
Level resultLevel = new Level();
int res;
DataView dt = new DataView();
strComment = txtComment.Text.Replace("'", "''");
if (strComment.Equals(""))
{
wucMessageControl.Message = "Debe de proveer un comentario";
wucMessageControl.ShowPopup();
}
else
{
/*Obtener las filas para insertar en el Logs*/
dsIncidentNotification.OperationsLogsDataTable dtIncidentLogs = new dsIncidentNotification.OperationsLogsDataTable();
dsIncidentNotificationTableAdapters.OperationsLogsTableAdapter taIncidentLogs = new dsIncidentNotificationTableAdapters.OperationsLogsTableAdapter();
taIncidentLogs.FillByCodIncidence(dtIncidentLogs, Convert.ToInt16(hidIncidentNumber.Value));
/*Obtener código de motivo de Validación*/
dsIncidentNotification.IN_CAT_MOTIVESDataTable dtMotive = new dsIncidentNotification.IN_CAT_MOTIVESDataTable();
dsIncidentNotificationTableAdapters.IN_CAT_MOTIVESTableAdapter taMotive = new dsIncidentNotificationTableAdapters.IN_CAT_MOTIVESTableAdapter();
/**Segmento de código para verificar si se hace modificación en segmentos y tipos*/
//if (trSegment.Visible == true && trType.Visible == true && trStatus.Visible == true)
if (trSegment.Visible == true && trType.Visible == true)
{
segmentType = string.Format(",COD_SEGMENT={0},COD_TYPE={1} ", ddlSegment.SelectedValue, ddlType.SelectedValue);
codSegm = ddlSegment.SelectedValue;
codType = ddlType.SelectedValue;
//El id de la secuencia del nivel del registro actual
resultLevel.GetLevelRec(decimal.Parse(dtIncidentLogs[0]["COD_LEVEL"].ToString()));
seqLevel = resultLevel.LevelsTable.Rows[0]["LEVEL_SEQUENCE"].ToString();
codLevels = resultLevel.LevelsTable.Rows[0]["COD_LEVEL"].ToString(); //código del nivel
//Niveles del tipo seleccionado
resultLevel.GetLevelsType(decimal.Parse(ddlType.SelectedValue.ToString()));
foreach (DataRow item in resultLevel.LevelsTable.Rows)
{
seqLevelT = item["LEVEL_SEQUENCE"].ToString();
if (seqLevel == seqLevelT)
{
break;
}
}
if (seqLevelT != seqLevel)//(seqLevelT != seqLevel)
{
codLevel = codLevelChg;
}
else
{
codLevel = resultLevel.GetCodLevelTypeLevel(decimal.Parse(ddlType.SelectedValue.ToString()), decimal.Parse(seqLevel)).ToString();
}
//codLevel= codLevelChg;
/*if (ddlStatus.SelectedItem.Text.ToString().ToUpper().Contains("FIN"))
* vfin = true;
*/
edit = true;
}
taMotive.FillByOperations(dtMotive);
decimal criticalityLevel = 0;
if (!string.IsNullOrEmpty(dtIncidentLogs[0]["CRITICALITY"].ToString()))
{
criticalityLevel = decimal.Parse(dtIncidentLogs[0]["CRITICALITY"].ToString());
}
sql = "DECLARE\n" +
" cod_incidence_log DECIMAL;\n" +
" message VARCHAR2(500);\n" +
"BEGIN\n";
/* sql += "UPDATE IN_INCIDENCES\n" +
* /* string.Format("SET COD_MOTIVE = {0}, \"MONITORING\" = '{1}'" /*+ ((vfin) ? " ,END_DATE=sysdate ": " "), ((edit) ? ddlStatus.SelectedValue : dtMotive.Rows[0][0], strComment) + segmentType + ((edit) ? string.Format(",COD_LEVEL={0}", codLevel) : "") +
* "\nWHERE COD_INCIDENCE = " + dtIncidentLogs[0]["COD_INCIDENCE"] + ";\n";*/
sql += "UPDATE IN_INCIDENCES\n" +
string.Format("SET COD_MOTIVE = {0}, \"MONITORING\" = :Monitoring", dtMotive.Rows[0][0]) + segmentType + ((edit) ? string.Format(",COD_LEVEL={0}", codLevel) : "") +
"\nWHERE COD_INCIDENCE = " + dtIncidentLogs[0]["COD_INCIDENCE"] + ";\n";
sql += "SELECT COD_INCIDENCE_LOG_SEQ.NEXTVAL INTO cod_incidence_log FROM DUAL;\n" +
"INSERT INTO IN_INCIDENCE_LOGS (COD_INCIDENCE_LOG,COD_INCIDENCE, COD_LEVEL, COD_MOTIVE, COD_SEGMENT, COD_TYPE, DESCRIPTION,INCIDENCE_CAUSE, \"MONITORING\",LOG_DATE, USERNAME, IS_LEVEL_CHANGE_LOG, RECEIVED_CALLS, SCRIPT, TYPOLOGY,CRITICALITY,IN_COUNTRY_PK,SUBJECT,MAINTENANCE)\n" +
String.Format("VALUES (cod_incidence_log,{7},{0},{1},{2},{3},'{4}','{5}',:Monitoring,sysdate,'{6}','N',{8},'{9}','{10}',{11},{12},'{13}','{14}');\n",
(edit) ? codLevel : dtIncidentLogs[0]["COD_LEVEL"], /*((edit)? ddlStatus.SelectedValue:*/ dtMotive.Rows[0][0].ToString().Replace("'", "''"), (edit) ? codSegm : dtIncidentLogs[0]["COD_SEGMENT"], (edit) ? codType : dtIncidentLogs[0]["COD_TYPE"], dtIncidentLogs[0]["DESCRIPTION"].ToString().Replace("'", "''"), dtIncidentLogs[0]["INCIDENCE_CAUSE"].ToString().Replace("'", "''"),
SafetyPad.GetUserLogin(), dtIncidentLogs[0]["COD_INCIDENCE"], dtIncidentLogs[0]["RECEIVED_CALLS"], dtIncidentLogs[0]["SCRIPT"].ToString().Replace("'", "''"), dtIncidentLogs[0]["TYPOLOGY"].ToString().Replace("'", "''"), criticalityLevel, dtIncidentLogs[0]["IN_COUNTRY_PK"], dtIncidentLogs[0]["SUBJECT"], dtIncidentLogs[0]["MAINTENANCE"]);
sql += "\nCOMMIT;\nSELECT IN_OPERATIONS_API.INCIDENCE_REPORT_SENT_FUN(cod_incidence_log) INTO message FROM DUAL; ";
sql += "\nEND;";
try
{
res = ConfigurationTool.ExecQueryParam(sql, strComment);
taMotive.FillByOperations(dtMotive);
/*taMotive.FillByCodMotive(dtMotive,decimal.Parse (ddlStatus.SelectedValue.ToString()));*/
lblState.Text = dtMotive.Rows[0][1].ToString();
populateGridComments(Convert.ToInt16(hidIncidentNumber.Value));
//txtIncident_TextChanged(null, null);
wucMessageControl.Message = "La notificación se realizó correctamente!";
wucMessageControl.Title = "Mensaje";
wucMessageControl.Image = "../include/imagenes/info_32.png";
wucMessageControl.ShowPopup();
txtComment.Text = String.Empty;
/*if (vfin)
* {
* ddlSegment.Enabled = false;
* ddlType.Enabled = false;
* //ddlStatus.Enabled = false;
* txtComment.Enabled = false;
* sendButton.Enabled = false;
* }*/
}
catch (Exception ex)
{
wucMessageControl.Message = ex.Message;
wucMessageControl.Title = "Error";
wucMessageControl.Image = "../include/imagenes/error_32.png";
SafetyPad.SetLogRecord("Operations.aspx.cs", ex.ToString());
wucMessageControl.ShowPopup();
}
}
}
catch (Exception ex)
{
SafetyPad.SetLogRecord("Operations.aspx.cs", ex.ToString());
}
}
