/// <summary> /// Transfers the data containing on the dataset (related to MSGS table) to the database /// </summary> /// <param name="data">DataSet with updated MSGS info</param> public void UpdateMessages(DataSet data) { Database d = DatabaseFactory.GetDatabase(); IDbDataAdapter da = d.GetDataAdapter(); da.UpdateCommand = d.PrepareCommand("UPDATE MSGS SET MSG_STATUS = @MSGS.MSG_STATUS@, MSG_NUMRETRIES = @MSGS.MSG_NUMRETRIES@, MSG_LASTRETRY = @MSGS.MSG_LASTRETRY@"); d.UpdateDataSet(da, data.Tables[0]); }
/// <summary> /// Updates the USR_PERMISSIONS table /// </summary> /// <param name="dt">DataTable to udpate</param> public void SaveViewsAssignedToUsers(DataTable dt) { Database d = DatabaseFactory.GetDatabase(); IDbDataAdapter da = d.GetDataAdapter(); da.UpdateCommand = d.PrepareCommand("UPDATE USR_PERMISSIONS SET UPER_INSALLOWED = @USR_PERMISSIONS.UPER_INSALLOWED@, UPER_UPDALLOWED = @USR_PERMISSIONS.UPER_UPDALLOWED@, UPER_DELALLOWED= @USR_PERMISSIONS.UPER_DELALLOWED@, UPER_EXEALLOWED=@USR_PERMISSIONS.UPER_EXEALLOWED@ WHERE UPER_USR_ID = @USR_PERMISSIONS.UPER_USR_ID@ AND UPER_VELE_VIE_ID = @USR_PERMISSIONS.UPER_VELE_VIE_ID@ AND UPER_VELE_ELEMENTNUMBER = @USR_PERMISSIONS.UPER_VELE_ELEMENTNUMBER@", false); da.InsertCommand = d.PrepareCommand("INSERT INTO USR_PERMISSIONS (UPER_USR_ID, UPER_VELE_VIE_ID, UPER_VELE_ELEMENTNUMBER, UPER_INSALLOWED,UPER_UPDALLOWED, UPER_DELALLOWED, UPER_EXEALLOWED) VALUES (@USR_PERMISSIONS.UPER_USR_ID@, @USR_PERMISSIONS.UPER_VELE_VIE_ID@, @USR_PERMISSIONS.UPER_VELE_ELEMENTNUMBER@, @USR_PERMISSIONS.UPER_INSALLOWED@,@USR_PERMISSIONS.UPER_UPDALLOWED@, @USR_PERMISSIONS.UPER_DELALLOWED@, @USR_PERMISSIONS.UPER_EXEALLOWED@)", false); da.DeleteCommand = d.PrepareCommand("DELETE FROM USR_PERMISSIONS WHERE UPER_USR_ID = @USR_PERMISSIONS.UPER_USR_ID@ AND UPER_VELE_VIE_ID = @USR_PERMISSIONS.UPER_VELE_VIE_ID@ AND UPER_VELE_ELEMENTNUMBER = @USR_PERMISSIONS.UPER_VELE_ELEMENTNUMBER@", false); IDbConnection con = d.GetNewConnection(); con.Open(); da.UpdateCommand.Connection = con; da.InsertCommand.Connection = con; da.DeleteCommand.Connection = con; d.UpdateDataSet(da, dt); con.Close(); dt.AcceptChanges(); }
public override void SaveData(DataTable dt) { // Loads XML Schema from database LoadSchema(); Database d = DatabaseFactory.GetDatabase(); IDbConnection con = d.GetNewConnection(); con.Open(); IDbDataAdapter da = d.GetDataAdapter(); da.InsertCommand = d.PrepareCommand(CreateInsertCommand(), false); da.UpdateCommand = d.PrepareCommand(CreateUpdateCommand(), false); da.DeleteCommand = d.PrepareCommand(CreateDeleteCommand(), false); da.InsertCommand.Connection = con; da.UpdateCommand.Connection = con; da.DeleteCommand.Connection = con; d.UpdateDataSet(da, dt); dt.AcceptChanges(); con.Close(); }
/// <summary> /// Saves subviews' permissions for a role (ROL_PERMISSIONS table) /// </summary> /// <param name="dt">DataTable containint the users to save</param> public void SaveViewsAssignedToRoles(DataTable dt) { Database d = DatabaseFactory.GetDatabase(); IDbDataAdapter da = d.GetDataAdapter(); IDbCommand cmd = d.PrepareCommand("UPDATE ROL_PERMISSIONS SET RPER_INSALLOWED = @ROL_PERMISSIONS.RPER_INSALLOWED@, RPER_UPDALLOWED = @ROL_PERMISSIONS.RPER_UPDALLOWED@, RPER_DELALLOWED= @ROL_PERMISSIONS.RPER_DELALLOWED@, RPER_EXEALLOWED=@ROL_PERMISSIONS.RPER_EXEALLOWED@ WHERE RPER_ROL_ID = @ROL_PERMISSIONS.RPER_ROL_ID@ AND RPER_VELE_VIE_ID = @ROL_PERMISSIONS.RPER_VELE_VIE_ID@ AND RPER_VELE_ELEMENTNUMBER = @ROL_PERMISSIONS.RPER_VELE_ELEMENTNUMBER@", false); IDbConnection con = d.GetNewConnection(); con.Open(); cmd.Connection = con; da.UpdateCommand = cmd; d.UpdateDataSet(da, dt); con.Close(); dt.AcceptChanges(); }
/// <summary> /// Delete ALL alarms contained in arraylist alarms (for the UNIT specified) /// </summary> /// <param name="alarms">ArrayList of ints (alarms ==> ALA_DALA_ID)</param> /// <param name="uniid">UNI_ID of the unit</param> /// <param name="con">Connection to use</param> /// <param name="tran">Transaction context to use</param> /// <returns>true if succesful, false if error</returns> protected void DeleteAlarms(ArrayList alarms, int uniid, IDbConnection con, DateTime date) { Database d = DatabaseFactory.GetDatabase(); IDbDataAdapter da = d.GetDataAdapter(); try { //m.WaitOne(); // Get all the current alarms DataTable dtAlarms = d.FillDataTable( "SELECT ALA_ID, ALA_DALA_ID, ALA_UNI_ID, ALA_INIDATE " + "FROM ALARMS WHERE ALA_UNI_ID = @ALARMS.ALA_UNI_ID@", "ALARMS", uniid); // Foreach alarm check if we have to delete it (==> set ALA_ENDDATE to Now) foreach (DataRow dr in dtAlarms.Rows) { // cfe -- evito que el error en el procesamiento de una alarma afecte al resto try { int ialarm = Convert.ToInt32(dr["ALA_DALA_ID"]); if (alarms.Contains(ialarm)) { // Insert the alarm into alarm_his... InsertAlarmHistory(dr, con, date); // ... and delete it from DataTable dr.Delete(); } } catch (Exception) { } } // Update the database da.DeleteCommand = d.PrepareCommand("DELETE FROM ALARMS WHERE ALA_ID = @ALARMS.ALA_ID@", false); da.DeleteCommand.Connection = con; d.UpdateDataSet(da, dtAlarms); dtAlarms.AcceptChanges(); } finally { //m.ReleaseMutex(); } }