public List<eventsalarm_intrusionevents_mapping> eventsalarm_intrusionevents_mappingGetAll()
{
List<eventsalarm_intrusionevents_mapping> lsteventsalarm_intrusionevents_mapping = new List<eventsalarm_intrusionevents_mapping>();
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventsalarm_intrusionevents_mappingGetAll").Tables[0];
if (dt.Rows.Count > 0)
{
int colEventsAlarmId = dt.Columns["EventsAlarmId"].Ordinal;
int colIntrusionEventId = dt.Columns["IntrusionEventId"].Ordinal;
for (int i = 0; dt.Rows.Count > i; i++)
{
eventsalarm_intrusionevents_mapping NewEnt = new eventsalarm_intrusionevents_mapping();
NewEnt.EventsAlarmId = Int32.Parse(dt.Rows[i].ItemArray[colEventsAlarmId].ToString());
NewEnt.IntrusionEventId = Int32.Parse(dt.Rows[i].ItemArray[colIntrusionEventId].ToString());
lsteventsalarm_intrusionevents_mapping.Add(NewEnt);
}
}
return lsteventsalarm_intrusionevents_mapping;
}
catch(Exception ex)
{
throw ex;
}
}
public int eventsalarm_intrusionevents_mappingAdd(eventsalarm_intrusionevents_mapping eventsalarm_intrusionevents_mapping)
{
try
{
return (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "eventsalarm_intrusionevents_mappingAdd",
eventsalarm_intrusionevents_mapping.EventsAlarmId,
eventsalarm_intrusionevents_mapping.IntrusionEventId);
}
catch(Exception ex)
{
throw ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
eventsalarm auxNewEventAlarm = new eventsalarm();
eventsalarmBus oEventsAlarm = new eventsalarmBus();
eventsalarm_intrusionevents_mapping auxIntrusionEventMapping = new eventsalarm_intrusionevents_mapping();
eventsalarm_intrusionevents_mappingBus oIntrusionEventsMapping = new eventsalarm_intrusionevents_mappingBus();
bool needRequiredFields = false;
int saveType = 0;
if (btnNew.Enabled) saveType = 2;
if (!btnNew.Enabled) saveType = 1;
if (String.IsNullOrEmpty(txtCheckFrequency.Text)) needRequiredFields = true;
if (String.IsNullOrEmpty(txtEventsAlarmTittle.Text)) needRequiredFields = true;
if (!needRequiredFields)
{
auxNewEventAlarm.Severity = Convert.ToInt32(ddlSeverity.SelectedValue);
auxNewEventAlarm.EventsAlarmTittle = txtEventsAlarmTittle.Text;
auxNewEventAlarm.CheckFrecuency = Convert.ToInt32(txtCheckFrequency.Text);
auxNewEventAlarm.Active = Convert.ToSByte(chkActive.Checked);
auxNewEventAlarm.AffectConfidence = Convert.ToSByte(chkBIA.Items[0].Selected);
auxNewEventAlarm.AffectIntegrity = Convert.ToSByte(chkBIA.Items[1].Selected);
auxNewEventAlarm.AffectAvailability = Convert.ToSByte(chkBIA.Items[2].Selected);
auxNewEventAlarm.IdsId = Convert.ToInt32(ddlIDPS.SelectedValue);
auxNewEventAlarm.IdsSignatureCategoryId = Convert.ToInt32(ddlIDPSSignatures.SelectedValue);
switch (saveType)
{
case 1: //save
if (oEventsAlarm.eventsalarmAdd(auxNewEventAlarm) > 0)
{
if (gvIntrusionEventsAssigned.Rows.Count > 0)
{
foreach (GridViewRow rowIntrusion in gvIntrusionEventsAssigned.Rows)
{
auxIntrusionEventMapping.EventsAlarmId = Convert.ToInt32(txtEventAlarmId.Text);
auxIntrusionEventMapping.IntrusionEventId = Convert.ToInt32(((Label)rowIntrusion.FindControl("intrusionEventsId")).Text);
if (oIntrusionEventsMapping.eventsalarm_intrusionevents_mappingAdd(auxIntrusionEventMapping) <= 0)
{
lblMessage.Text = "Error al guardar Referencias del Evento [Evento de Intrusion] " + ((Label)rowIntrusion.FindControl("intrusionEventsId")).Text;
}
}
}
lblMessage.Text = "Datos guardados correctamente!";
clearFields();
activateFields(false, true);
btnNew.Enabled = true;
getEventsAlarmData();
}
else
lblMessage.Text = "Error al guardar los datos!";
break;
case 2: //update
auxNewEventAlarm.EventsAlarmId = Convert.ToInt32(txtEventAlarmId.Text);
if (oEventsAlarm.eventsalarmUpdate(auxNewEventAlarm))
{
if (gvIntrusionEventsAssigned.Rows.Count > 0)
{
foreach (GridViewRow rowIntrusion in gvIntrusionEventsAssigned.Rows)
{
auxIntrusionEventMapping.EventsAlarmId = Convert.ToInt32(txtEventAlarmId.Text);
auxIntrusionEventMapping.IntrusionEventId = Convert.ToInt32(((Label)rowIntrusion.FindControl("intrusionEventsId")).Text);
if (oIntrusionEventsMapping.eventsalarm_intrusionevents_mappingAdd(auxIntrusionEventMapping) <= 0)
{
lblMessage.Text = "Error al guardar Referencias del Evento [Evento de Intrusion] " + ((Label)rowIntrusion.FindControl("intrusionEventsId")).Text;
}
}
}
lblMessage.Text = "Datos actualizados correctamente!";
clearFields();
activateFields(false, true);
btnSave.Enabled = false;
getEventsAlarmData();
}
else
lblMessage.Text = "Error al guardar los datos!";
break;
}
}
else
{
lblMessage.Text = "Error, existen campos sin completar!";
}
}
public bool eventsalarm_intrusionevents_mappingUpdate(eventsalarm_intrusionevents_mapping eventsalarm_intrusionevents_mapping)
{
eventsalarm_intrusionevents_mappingImpl oeventsalarm_intrusionevents_mappingImpl = new eventsalarm_intrusionevents_mappingImpl();
return oeventsalarm_intrusionevents_mappingImpl.eventsalarm_intrusionevents_mappingUpdate(eventsalarm_intrusionevents_mapping);
}
public int eventsalarm_intrusionevents_mappingAdd(eventsalarm_intrusionevents_mapping eventsalarm_intrusionevents_mapping)
{
eventsalarm_intrusionevents_mappingImpl oeventsalarm_intrusionevents_mappingImpl = new eventsalarm_intrusionevents_mappingImpl();
return oeventsalarm_intrusionevents_mappingImpl.eventsalarm_intrusionevents_mappingAdd(eventsalarm_intrusionevents_mapping);
}
public bool eventsalarm_intrusionevents_mappingUpdate(eventsalarm_intrusionevents_mapping eventsalarm_intrusionevents_mapping)
{
try
{
int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "eventsalarm_intrusionevents_mappingUpdate",
eventsalarm_intrusionevents_mapping.EventsAlarmId,
eventsalarm_intrusionevents_mapping.IntrusionEventId);
if (update > 0)
{
return true;
}
else
{
return false;
}
}
catch(Exception ex)
{
throw ex;
}
}
public eventsalarm_intrusionevents_mapping eventsalarm_intrusionevents_mappingGetById(int EventsAlarmId, int IntrusionEventId)
{
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventsalarm_intrusionevents_mappingGetById",
EventsAlarmId,
IntrusionEventId).Tables[0];
eventsalarm_intrusionevents_mapping NewEnt = new eventsalarm_intrusionevents_mapping();
if(dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
NewEnt.EventsAlarmId = Int32.Parse(dr["EventsAlarmId"].ToString());
NewEnt.IntrusionEventId = Int32.Parse(dr["IntrusionEventId"].ToString());
}
return NewEnt;
}
catch(Exception ex)
{
throw ex;
}
}
