public ids idsGetById(int IdsId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "idsGetById", IdsId).Tables[0]; ids NewEnt = new ids(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.IdsId = Int32.Parse(dr["IdsId"].ToString()); NewEnt.idsName = dr["IdsName"].ToString(); NewEnt.DatabaseTypeId = Int32.Parse(dr["DatabaseTypeId"].ToString()); NewEnt.IdsTypeId = Int32.Parse(dr["IdsTypeId"].ToString()); NewEnt.Active = sbyte.Parse(dr["Active"].ToString()); NewEnt.IdsIP = dr["IdsIP"].ToString(); NewEnt.DatabaseUser = dr["DatabaseUser"].ToString(); NewEnt.DatabasePass = dr["DatabasePass"].ToString(); NewEnt.DatabaseName = dr["DatabaseName"].ToString(); NewEnt.DatabaseHost = dr["DatabaseHost"].ToString(); NewEnt.IdsVersion = dr["IdsVersion"].ToString(); } return(NewEnt); } catch (Exception ex) { throw ex; } }
public bool smtpserversUpdate(smtpservers smtpservers) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "smtpserversUpdate", smtpservers.SmtpServerId, smtpservers.SmtpServerHostname, smtpservers.SmtpServerPort, smtpservers.SmtpServerAccount, smtpservers.SmtpServerPassword, smtpservers.StmpServerEnabled); if (update > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public smtpservers smtpserversGetById(int SmtpServerId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "smtpserversGetById", SmtpServerId).Tables[0]; smtpservers NewEnt = new smtpservers(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.SmtpServerId = Int32.Parse(dr["SmtpServerId"].ToString()); NewEnt.SmtpServerHostname = dr["SmtpServerHostname"].ToString(); NewEnt.SmtpServerPort = dr["SmtpServerPort"].ToString(); NewEnt.SmtpServerAccount = dr["SmtpServerAccount"].ToString(); NewEnt.SmtpServerPassword = dr["SmtpServerPassword"].ToString(); NewEnt.StmpServerEnabled = sbyte.Parse(dr["StmpServerEnabled"].ToString()); } return(NewEnt); } catch (Exception ex) { throw ex; } }
public eventsalarm eventsalarmGetById(int EventsAlarmId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventsalarmGetById", EventsAlarmId).Tables[0]; eventsalarm NewEnt = new eventsalarm(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.EventsAlarmId = Int32.Parse(dr["EventsAlarmId"].ToString()); NewEnt.IdsId = Int32.Parse(dr["IdsId"].ToString()); NewEnt.IdsSignatureCategoryId = Int32.Parse(dr["IdsSignatureCategoryId"].ToString()); NewEnt.Active = sbyte.Parse(dr["Active"].ToString()); NewEnt.CheckFrecuency = Int32.Parse(dr["CheckFrecuency"].ToString()); NewEnt.Severity = Int32.Parse(dr["Severity"].ToString()); NewEnt.AffectConfidence = sbyte.Parse(dr["AffectConfidence"].ToString()); NewEnt.AffectIntegrity = sbyte.Parse(dr["AffectIntegrity"].ToString()); NewEnt.AffectAvailability = sbyte.Parse(dr["AffectAvailability"].ToString()); NewEnt.EventsAlarmTittle = dr["AffectAvailability"].ToString(); } return(NewEnt); } catch (Exception ex) { throw ex; } }
public List <smtpservers> smtpserversGetAll() { List <smtpservers> lstsmtpservers = new List <smtpservers>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "smtpserversGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colSmtpServerId = dt.Columns["SmtpServerId"].Ordinal; int colSmtpServerHostname = dt.Columns["SmtpServerHostname"].Ordinal; int colSmtpServerPort = dt.Columns["SmtpServerPort"].Ordinal; int colSmtpServerAccount = dt.Columns["SmtpServerAccount"].Ordinal; int colSmtpServerPassword = dt.Columns["SmtpServerPassword"].Ordinal; int colStmpServerEnabled = dt.Columns["StmpServerEnabled"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { smtpservers NewEnt = new smtpservers(); NewEnt.SmtpServerId = Int32.Parse(dt.Rows[i].ItemArray[colSmtpServerId].ToString()); NewEnt.SmtpServerHostname = dt.Rows[i].ItemArray[colSmtpServerHostname].ToString(); NewEnt.SmtpServerPort = dt.Rows[i].ItemArray[colSmtpServerPort].ToString(); NewEnt.SmtpServerAccount = dt.Rows[i].ItemArray[colSmtpServerAccount].ToString(); NewEnt.SmtpServerPassword = dt.Rows[i].ItemArray[colSmtpServerPassword].ToString(); NewEnt.StmpServerEnabled = sbyte.Parse(dt.Rows[i].ItemArray[colStmpServerEnabled].ToString()); lstsmtpservers.Add(NewEnt); } } return(lstsmtpservers); } catch (Exception ex) { throw ex; } }
public List <databasestype> databasestypeGetAll() { List <databasestype> lstdatabasestype = new List <databasestype>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "databasestypeGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colDatabaseTypeId = dt.Columns["DatabaseTypeId"].Ordinal; int colDatabaseName = dt.Columns["DatabaseName"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { databasestype NewEnt = new databasestype(); NewEnt.DatabaseTypeId = Int32.Parse(dt.Rows[i].ItemArray[colDatabaseTypeId].ToString()); NewEnt.DatabaseName = dt.Rows[i].ItemArray[colDatabaseName].ToString(); lstdatabasestype.Add(NewEnt); } } return(lstdatabasestype); } catch (Exception ex) { throw ex; } }
public bool eventsalarmUpdate(eventsalarm eventsalarm) { try { int update = (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "eventsalarmUpdate", eventsalarm.EventsAlarmId, eventsalarm.IdsId, eventsalarm.IdsSignatureCategoryId, eventsalarm.Active, eventsalarm.CheckFrecuency, eventsalarm.Severity, eventsalarm.AffectConfidence, eventsalarm.AffectIntegrity, eventsalarm.AffectAvailability, eventsalarm.EventsAlarmTittle); if (update > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public List <ids> idsGetAll() { List <ids> lstids = new List <ids>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "idsGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colIdsId = dt.Columns["IdsId"].Ordinal; int colDatabaseTypeId = dt.Columns["DatabaseTypeId"].Ordinal; int colIdsTypeId = dt.Columns["IdsTypeId"].Ordinal; int colActive = dt.Columns["Active"].Ordinal; int colIdsIP = dt.Columns["IdsIP"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { ids NewEnt = new ids(); NewEnt.IdsId = Int32.Parse(dt.Rows[i].ItemArray[colIdsId].ToString()); NewEnt.DatabaseTypeId = Int32.Parse(dt.Rows[i].ItemArray[colDatabaseTypeId].ToString()); NewEnt.IdsTypeId = Int32.Parse(dt.Rows[i].ItemArray[colIdsTypeId].ToString()); NewEnt.Active = sbyte.Parse(dt.Rows[i].ItemArray[colActive].ToString()); NewEnt.IdsIP = dt.Rows[i].ItemArray[colIdsIP].ToString(); lstids.Add(NewEnt); } } return(lstids); } catch (Exception ex) { throw ex; } }
public List <eventstype> eventstypeGetByDescription(string description) { List <eventstype> lsteventstype = new List <eventstype>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventstypeGetByDescription", description).Tables[0]; if (dt.Rows.Count > 0) { int colEventsTypeId = dt.Columns["EventsTypeId"].Ordinal; int colDescription = dt.Columns["Description"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { eventstype NewEnt = new eventstype(); NewEnt.EventsTypeId = Int32.Parse(dt.Rows[i].ItemArray[colEventsTypeId].ToString()); NewEnt.Description = dt.Rows[i].ItemArray[colDescription].ToString(); lsteventstype.Add(NewEnt); } } return(lsteventstype); } catch (Exception ex) { throw ex; } }
public List <userrolesmapping> userrolesmappingGetByUserGroupId(int UserGroupId) { List <userrolesmapping> lstuserrolesmapping = new List <userrolesmapping>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "userrolesmappingGetByUserGroupId", UserGroupId).Tables[0]; if (dt.Rows.Count > 0) { int colUserRoleId = dt.Columns["UserRoleId"].Ordinal; int colUserGroupId = dt.Columns["UserGroupId"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { userrolesmapping NewEnt = new userrolesmapping(); NewEnt.UserRoleId = Int32.Parse(dt.Rows[i].ItemArray[colUserRoleId].ToString()); NewEnt.UserGroupId = Int32.Parse(dt.Rows[i].ItemArray[colUserGroupId].ToString()); lstuserrolesmapping.Add(NewEnt); } } return(lstuserrolesmapping); } catch (Exception ex) { throw ex; } }
public List <eventsalarm_intrusionevents_mapping> eventsalarm_intrusionevents_mappingGetByEventsAlarmId(int EventsAlarmId) { List <eventsalarm_intrusionevents_mapping> lsteventsalarm_intrusionevents_mapping = new List <eventsalarm_intrusionevents_mapping>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventsalarm_intrusionevents_mappingGetByEventsAlarmId", EventsAlarmId).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 List <taskstatus> taskstatusGetAll() { List <taskstatus> lsttaskstatus = new List <taskstatus>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "taskstatusGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colTaskStatusId = dt.Columns["TaskStatusId"].Ordinal; int colTaskStatusDescription = dt.Columns["TaskStatusDescription"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { taskstatus NewEnt = new taskstatus(); NewEnt.TaskStatusId = Int32.Parse(dt.Rows[i].ItemArray[colTaskStatusId].ToString()); NewEnt.TaskStatusDescription = dt.Rows[i].ItemArray[colTaskStatusDescription].ToString(); lsttaskstatus.Add(NewEnt); } } return(lsttaskstatus); } catch (Exception ex) { throw ex; } }
public intrusionevents intrusioneventsGetById(int IntrusionEventsId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "intrusioneventsGetById", IntrusionEventsId).Tables[0]; intrusionevents NewEnt = new intrusionevents(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.IntrusionEventsId = Int32.Parse(dr["IntrusionEventsId"].ToString()); NewEnt.IntrusionEventDetail = dr["IntrusionEventDetail"].ToString(); NewEnt.CVEId = dr["CVEId"].ToString(); NewEnt.CWEId = dr["CWEId"].ToString(); NewEnt.CWEId = dr["CAPECId"].ToString(); NewEnt.CWEId = dr["OWASPId"].ToString(); } return(NewEnt); } catch (Exception ex) { throw ex; } }
public bool intrusioneventsUpdate(intrusionevents intrusionevents) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "intrusioneventsUpdate", intrusionevents.IntrusionEventsId, intrusionevents.IntrusionEventDetail, intrusionevents.CVEId, intrusionevents.CWEId, intrusionevents.CAPECId, intrusionevents.OWASPId); if (update > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public bool taskdetailsUpdate(taskdetails taskdetails) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "taskdetailsUpdate", taskdetails.TaskDetailsId, taskdetails.TaskId, taskdetails.Details, taskdetails.DateTime, taskdetails.EffortHours, taskdetails.UserId); if (update > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public List <severity> severityGetAll() { List <severity> lstseverity = new List <severity>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "severityGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colSeverityId = dt.Columns["SeverityId"].Ordinal; int colSeverityDescription = dt.Columns["SeverityDescription"].Ordinal; int colSLATimeToResponse = dt.Columns["SLATimeToResponse"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { severity NewEnt = new severity(); NewEnt.SeverityId = Int32.Parse(dt.Rows[i].ItemArray[colSeverityId].ToString()); NewEnt.SeverityDescription = dt.Rows[i].ItemArray[colSeverityDescription].ToString(); NewEnt.SLATimeToResponse = Int32.Parse(dt.Rows[i].ItemArray[colSLATimeToResponse].ToString()); lstseverity.Add(NewEnt); } } return(lstseverity); } catch (Exception ex) { throw ex; } }
public taskdetails taskdetailsGetById(int TaskDetailsId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "taskdetailsGetById", TaskDetailsId).Tables[0]; taskdetails NewEnt = new taskdetails(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.TaskDetailsId = Int32.Parse(dr["TaskDetailsId"].ToString()); NewEnt.TaskId = Int32.Parse(dr["TaskId"].ToString()); NewEnt.Details = dr["Details"].ToString(); NewEnt.DateTime = DateTime.Parse(dr["DateTime"].ToString()); NewEnt.EffortHours = Decimal.Parse(dr["EffortHours"].ToString()); NewEnt.UserId = Int32.Parse(dr["UserId"].ToString()); } return(NewEnt); } catch (Exception ex) { throw ex; } }
public List <taskdetails> taskdetailsGetAll() { List <taskdetails> lsttaskdetails = new List <taskdetails>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "taskdetailsGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colTaskDetailsId = dt.Columns["TaskDetailsId"].Ordinal; int colTaskId = dt.Columns["TaskId"].Ordinal; int colDetails = dt.Columns["Details"].Ordinal; int colDateTime = dt.Columns["DateTime"].Ordinal; int colEffortHours = dt.Columns["EffortHours"].Ordinal; int colUserId = dt.Columns["UserId"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { taskdetails NewEnt = new taskdetails(); NewEnt.TaskDetailsId = Int32.Parse(dt.Rows[i].ItemArray[colTaskDetailsId].ToString()); NewEnt.TaskId = Int32.Parse(dt.Rows[i].ItemArray[colTaskId].ToString()); NewEnt.Details = dt.Rows[i].ItemArray[colDetails].ToString(); NewEnt.DateTime = DateTime.Parse(dt.Rows[i].ItemArray[colDateTime].ToString()); NewEnt.EffortHours = Decimal.Parse(dt.Rows[i].ItemArray[colEffortHours].ToString()); NewEnt.UserId = Int32.Parse(dt.Rows[i].ItemArray[colUserId].ToString()); lsttaskdetails.Add(NewEnt); } } return(lsttaskdetails); } catch (Exception ex) { throw ex; } }
public users usersGetById(int UserId, int UserGroupId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "usersGetById", UserId, UserGroupId).Tables[0]; users NewEnt = new users(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.UserId = Int32.Parse(dr["UserId"].ToString()); NewEnt.UserGroupId = Int32.Parse(dr["UserGroupId"].ToString()); NewEnt.UserName = dr["UserName"].ToString(); NewEnt.UserFirstName = dr["UserFirstName"].ToString(); NewEnt.UserLastName = dr["UserLastName"].ToString(); NewEnt.UserMail = dr["UserMail"].ToString(); NewEnt.UserSMSNumber = dr["UserSMSNumber"].ToString(); NewEnt.UserPassword = dr["UserPassword"].ToString(); NewEnt.UserActive = sbyte.Parse(dr["UserActive"].ToString()); } return(NewEnt); } catch (Exception ex) { throw ex; } }
public bool usersUpdate(users users) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "usersUpdate", users.UserId, users.UserGroupId, users.UserName, users.UserFirstName, users.UserLastName, users.UserMail, users.UserSMSNumber, users.UserPassword, users.UserActive); if (update > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public bool idsUpdate(ids ids) { try { int update = (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "idsUpdate", ids.IdsId, ids.idsName, ids.DatabaseTypeId, ids.IdsTypeId, ids.Active, ids.IdsIP, ids.DatabaseUser, ids.DatabasePass, ids.DatabaseName, ids.DatabaseHost, ids.IdsVersion); if (update > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public eventsdetection eventsdetectionGetById(int eventsdetectionId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventsdetectionGetById", eventsdetectionId).Tables[0]; eventsdetection NewEnt = new eventsdetection(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.EventsDetectionId = Int32.Parse(dr["EventsDetectionId"].ToString()); NewEnt.IdsId = Int32.Parse(dr["IdsId"].ToString()); NewEnt.DateTime = DateTime.Parse(dr["DateTime"].ToString()); NewEnt.EventStatus = Int32.Parse(dr["EventStatus"].ToString()); NewEnt.EventsAlarmId = Int32.Parse(dr["EventsAlarmId"].ToString()); NewEnt.IDPSEventId = Int32.Parse(dr["IDPSEventId"].ToString()); } return(NewEnt); } catch (Exception ex) { throw ex; } }
public List <eventsalarm> eventsalarmGetAll() { List <eventsalarm> lsteventsalarm = new List <eventsalarm>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventsalarmGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colEventsAlarmId = dt.Columns["EventsAlarmId"].Ordinal; int colEventsTypeId = dt.Columns["EventsTypeId"].Ordinal; int colActive = dt.Columns["Active"].Ordinal; int colCheckFrecuency = dt.Columns["CheckFrecuency"].Ordinal; int colSeverity = dt.Columns["Severity"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { eventsalarm NewEnt = new eventsalarm(); NewEnt.EventsAlarmId = Int32.Parse(dt.Rows[i].ItemArray[colEventsAlarmId].ToString()); NewEnt.EventsTypeId = Int32.Parse(dt.Rows[i].ItemArray[colEventsTypeId].ToString()); NewEnt.Active = sbyte.Parse(dt.Rows[i].ItemArray[colActive].ToString()); NewEnt.CheckFrecuency = Int32.Parse(dt.Rows[i].ItemArray[colCheckFrecuency].ToString()); NewEnt.Severity = Int32.Parse(dt.Rows[i].ItemArray[colSeverity].ToString()); lsteventsalarm.Add(NewEnt); } } return(lsteventsalarm); } catch (Exception ex) { throw ex; } }
public List <eventsdetection> eventsdetectionGetAll() { List <eventsdetection> lsteventsdetection = new List <eventsdetection>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventsdetectionGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colEventsDetectionId = dt.Columns["EventsDetectionId"].Ordinal; int colIdsId = dt.Columns["IdsId"].Ordinal; int colDateTime = dt.Columns["DateTime"].Ordinal; int colEventStatus = dt.Columns["EventStatus"].Ordinal; int colEventsAlarmId = dt.Columns["EventsAlarmId"].Ordinal; int colEventsIDPSEventId = dt.Columns["IDPSEventId"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { eventsdetection NewEnt = new eventsdetection(); NewEnt.EventsDetectionId = Int32.Parse(dt.Rows[i].ItemArray[colEventsDetectionId].ToString()); NewEnt.IdsId = Int32.Parse(dt.Rows[i].ItemArray[colIdsId].ToString()); NewEnt.DateTime = DateTime.Parse(dt.Rows[i].ItemArray[colDateTime].ToString()); NewEnt.EventStatus = Int32.Parse(dt.Rows[i].ItemArray[colEventStatus].ToString()); NewEnt.EventsAlarmId = Int32.Parse(dt.Rows[i].ItemArray[colEventsAlarmId].ToString()); NewEnt.IDPSEventId = Int32.Parse(dt.Rows[i].ItemArray[colEventsIDPSEventId].ToString()); lsteventsdetection.Add(NewEnt); } } return(lsteventsdetection); } catch (Exception ex) { throw ex; } }
public bool eventsdetectionUpdate(eventsdetection eventsdetection) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "eventsdetectionUpdate", eventsdetection.EventsDetectionId, eventsdetection.IdsId, eventsdetection.DateTime, eventsdetection.EventStatus, eventsdetection.EventsAlarmId, eventsdetection.IDPSEventId); if (update > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public bool tasksUpdate(tasks tasks) { try { int update = (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "tasksUpdate", tasks.TaskId, tasks.EventsDetectionId, tasks.TaskStatudId, tasks.UserId, tasks.TaskTittle, tasks.DateTime); if (update > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public List <tasks> tasksGetAll() { List <tasks> lsttasks = new List <tasks>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "tasksGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colTaskId = dt.Columns["TaskId"].Ordinal; int colEventsDetectionId = dt.Columns["EventsDetectionId"].Ordinal; int colTaskStatudId = dt.Columns["TaskStatudId"].Ordinal; int colUserId = dt.Columns["UserId"].Ordinal; int colTaskTittle = dt.Columns["TaskTittle"].Ordinal; int colDateTime = dt.Columns["DateTime"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { tasks NewEnt = new tasks(); NewEnt.TaskId = Int32.Parse(dt.Rows[i].ItemArray[colTaskId].ToString()); NewEnt.EventsDetectionId = Int32.Parse(dt.Rows[i].ItemArray[colEventsDetectionId].ToString()); NewEnt.TaskStatudId = Int32.Parse(dt.Rows[i].ItemArray[colTaskStatudId].ToString()); NewEnt.UserId = Int32.Parse(dt.Rows[i].ItemArray[colUserId].ToString()); NewEnt.TaskTittle = dt.Rows[i].ItemArray[colTaskTittle].ToString(); NewEnt.DateTime = DateTime.Parse(dt.Rows[i].ItemArray[colDateTime].ToString()); lsttasks.Add(NewEnt); } } return(lsttasks); } catch (Exception ex) { throw ex; } }
public tasks tasksGetByEventsDetectionId(int EventsDetectionId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "tasksGetByIntrusionDetectionId", EventsDetectionId).Tables[0]; tasks NewEnt = new tasks(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.TaskId = Int32.Parse(dr["TaskId"].ToString()); NewEnt.EventsDetectionId = Int32.Parse(dr["EventsDetectionId"].ToString()); NewEnt.TaskStatudId = Int32.Parse(dr["TaskStatudId"].ToString()); NewEnt.UserId = Int32.Parse(dr["UserId"].ToString()); NewEnt.TaskTittle = dr["TaskTittle"].ToString(); NewEnt.DateTime = DateTime.Parse(dr["DateTime"].ToString()); } return(NewEnt); } catch (Exception ex) { throw ex; } }
public List <usergroup> usergroupGetAll() { List <usergroup> lstusergroup = new List <usergroup>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "usergroupGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colUserGroupId = dt.Columns["UserGroupId"].Ordinal; int colUserGroupDescription = dt.Columns["UserGroupDescription"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { usergroup NewEnt = new usergroup(); NewEnt.UserGroupId = Int32.Parse(dt.Rows[i].ItemArray[colUserGroupId].ToString()); NewEnt.UserGroupDescription = dt.Rows[i].ItemArray[colUserGroupDescription].ToString(); lstusergroup.Add(NewEnt); } } return(lstusergroup); } catch (Exception ex) { throw ex; } }
public int usergroupAdd(usergroup usergroup) { try { return((int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "usergroupAdd", usergroup.UserGroupDescription)); } catch (Exception ex) { throw ex; } }