public static List <SchedulerLog> GetSchedulerLogByFeedProvider(int feedProviderId) { var schedulerLogs = new List <SchedulerLog>(); var lstSqlParameter = new List <SqlParameter>(); var dt = DBProvider.GetDataTable("GetScheduledJobLogForFeedProvider", CommandType.StoredProcedure, ref lstSqlParameter); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { var schedulerJobLog = new SchedulerLog(); schedulerJobLog.Id = Convert.ToInt32(row["Id"]); schedulerJobLog.FeedProviderId = Convert.ToInt32(row["FeedProviderId"]); if (row["StartDate"] != DBNull.Value) { schedulerJobLog.StartDate = Convert.ToDateTime(row["StartDate"]).ToString("dd/MM/yyyy hh:mm:ss"); } ; if (row["EndDate"] != DBNull.Value) { schedulerJobLog.EndDate = Convert.ToDateTime(row["EndDate"]).ToString("dd/MM/yyyy hh:mm:ss"); } ; schedulerJobLog.Status = Convert.ToString(row["Status"]); schedulerLogs.Add(schedulerJobLog); } } return(schedulerLogs); }
public string[] GetUserIds(string[] roleIds) { string[] userIds = null; if (roleIds != null && roleIds.Length > 0) { // 需要显示未被删除的用户 //string sqlQuery = " SELECT Id AS USERID FROM PiUser WHERE (RoleId IN ( " + BusinessLogic.ArrayToList(roleIds) + ")) AND (DeleteMark = 0) AND (Enabled = 1) " // + " UNION SELECT UserId FROM PiUserRole WHERE (RoleId IN (" // + BusinessLogic.ArrayToList(roleIds) // + ")) AND (UserId IN (SELECT Id FROM PiUser WHERE (DeleteMark = 0))) AND (DeleteMark = 0) "; var sbQuery = new System.Text.StringBuilder(); sbQuery.Append(" SELECT " + PiUserTable.FieldId + " AS USERID FROM " + PiUserTable.TableName); sbQuery.Append(" WHERE ( " + PiUserTable.FieldRoleId + " IN( " + BusinessLogic.ArrayToList(roleIds, "'") + ")) "); sbQuery.Append(" AND ( " + PiUserTable.FieldDeleteMark + " = 0) AND (" + PiUserTable.FieldEnabled + " = 1 ) "); sbQuery.Append(" UNION SELECT " + PiUserRoleTable.FieldUserId + " FROM " + PiUserRoleTable.TableName); sbQuery.Append(" WHERE ( " + PiUserRoleTable.FieldRoleId + " IN( " + BusinessLogic.ArrayToList(roleIds, ",")); sbQuery.Append(" )) AND ( " + PiUserRoleTable.FieldUserId + " IN( SELECT " + PiUserTable.FieldId); sbQuery.Append(" FROM " + PiUserTable.TableName + " WHERE ( " + PiUserTable.FieldDeleteMark + " = 0))) "); sbQuery.Append(" AND ( " + PiUserRoleTable.FieldDeleteMark + " = 0)"); var dataTable = DBProvider.Fill(sbQuery.ToString()); userIds = BusinessLogic.FieldToArray(dataTable, PiUserRoleTable.FieldUserId); } return(userIds); }
/// <summary> /// Metodo per l'aggiornamento della data di prossima stampa del registro di conservazione. /// L'aggiornamento avviene sulla base della frequenza impostata. /// Viene aggiornato anche l'ultimo ID stampato. /// </summary> /// <param name="reg"></param> /// <returns></returns> public bool UpdateNextPrintDate(RegistroConservazionePrint reg) { //ricavo la data di prossima stampa string nextPrintDate = this.GetNextPrintDate(DateTime.Now, reg.printFreq); //imposto la data attuale come data di ultima stampa string lastPrintDate = DateTime.Now.ToString("dd/MM/yyyy"); //recupero l'ultimo id stampato string idLastPrinted = reg.idLastToPrint; Query query = InitQuery.getInstance().getQuery("U_REG_CONS_UPDATE_CONFIG"); query.setParam("nextPrintDate", nextPrintDate); query.setParam("lastPrintDate", lastPrintDate); query.setParam("idLastPrintedEvent", idLastPrinted); query.setParam("idAmm", reg.idAmministrazione); logger.Debug(query.getSQL()); //esecuzione query bool retVal = false; using (DBProvider dbProvider = new DBProvider()) { retVal = dbProvider.ExecuteNonQuery(query.getSQL()); } return(retVal); }
/// <summary> /// Metodo per il recupero delle informazioni necessarie alla scrittura /// del summary di un'istanza nella stampa del registro di conservazione. /// </summary> /// <param name="idIstanza"></param> /// <returns></returns> public RegistroConservazioneSummary GetSummaryDataIst(string idIstanza) { RegistroConservazioneSummary retVal = new RegistroConservazioneSummary(); Query query = InitQuery.getInstance().getQuery("S_REG_CONS_SUMMARY_DATA_IST"); query.setParam("id_istanza", idIstanza); logger.Debug("GetSummaryDataIst: " + query.getSQL()); using (DBProvider dbProvider = new DBProvider()) { using (IDataReader dataReader = dbProvider.ExecuteReader(query.getSQL())) { while (dataReader.Read()) { //retVal.descrizione = dataReader["var_descrizione"].ToString(); //retVal.creationDate = Convert.ToDateTime(dataReader["data_apertura"]); //retVal.invioDate = Convert.ToDateTime(dataReader["data_invio"]); //retVal.numDoc = dataReader["n_doc"].ToString(); //retVal.fileDim = dataReader["tot_size"].ToString(); retVal.descrizione = dataReader["var_descrizione"].Equals(DBNull.Value) ? string.Empty : dataReader["var_descrizione"].ToString(); retVal.creationDate = dataReader["data_apertura"].Equals(DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dataReader["data_apertura"]); retVal.invioDate = dataReader["data_invio"].Equals(DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dataReader["data_invio"]); retVal.numDoc = dataReader["n_doc"].Equals(DBNull.Value) ? string.Empty : dataReader["n_doc"].ToString(); retVal.fileDim = dataReader["tot_size"].Equals(DBNull.Value) ? string.Empty : dataReader["tot_size"].ToString(); } } } return(retVal); }
/// <summary> /// 获取上一条记录主键 /// </summary> /// <param name="id">当前记录主键</param> /// <returns>上一条记录主键</returns> private string GetPreviousId(string id) { string returnValue = string.Empty; string sqlQuery = " SELECT TOP 1 " + BusinessLogic.FieldId + " FROM " + this.CurrentTableName + " WHERE " + BusinessLogic.FieldCreateOn + " = (SELECT MAX(" + BusinessLogic.FieldCreateOn + ")" + " FROM " + this.CurrentTableName + " WHERE (" + BusinessLogic.FieldCreateOn + "< (SELECT " + BusinessLogic.FieldCreateOn + " FROM " + this.CurrentTableName + " WHERE " + BusinessLogic.FieldId + " = " + DBProvider.GetParameter(BusinessLogic.FieldId) + "))"; sqlQuery += " AND (" + BusinessLogic.FieldCreateUserId + " = " + DBProvider.GetParameter(BusinessLogic.FieldCreateUserId) + " ) AND ( " + BusinessLogic.FieldDeleteMark + " = 0 )) "; string[] names = new string[2]; Object[] values = new Object[2]; names[0] = BusinessLogic.FieldId; values[0] = id; names[1] = BusinessLogic.FieldCreateUserId; values[1] = UserInfo.Id; object returnObject = DBProvider.ExecuteScalar(sqlQuery, DBProvider.MakeParameters(names, values)); if (returnObject != null) { returnValue = returnObject.ToString(); } return(returnValue); }
/// <summary> /// Restituisce la lista degli id dei documenti appartenenti ad un'istanza. /// </summary> /// <param name="request"></param> /// <returns></returns> public List <string> GetListaDocumentiIstanze(PrintReportRequest request) { List <string> retList = new List <string>(); string idAmm = request.SearchFilters.Where(f => f.argomento == "id_amm").FirstOrDefault().valore; string nextSysId = request.SearchFilters.Where(f => f.argomento == "next_system_id").FirstOrDefault().valore; string lastSysId = request.SearchFilters.Where(f => f.argomento == "last_system_id").FirstOrDefault().valore; string idIst = request.SearchFilters.Where(f => f.argomento == "id_istanza").FirstOrDefault().valore; using (DBProvider dbProvider = new DBProvider()) { Query query = InitQuery.getInstance().getQuery("S_REG_CONS_GET_LIST_DOC_ISTANZE"); query.setParam("id_amm", idAmm); query.setParam("next_system_id", nextSysId); query.setParam("last_system_id", lastSysId); query.setParam("id_istanza", idIst); using (IDataReader dataReader = dbProvider.ExecuteReader(query.getSQL())) { while (dataReader.Read()) { retList.Add(dataReader["ID_OGGETTO"].ToString()); } } } return(retList); }
//Andrea De Marco - Insert del Report Import Pregressi public string InsertReportPregressi(DocsPaVO.Import.Pregressi.ReportPregressi report) { string system_id = string.Empty; try { using (DocsPaDB.DBProvider dbProvider = new DBProvider()) { dbProvider.BeginTransaction(); Query query = InitQuery.getInstance().getQuery("I_DPA_PREGRESSI"); query.setParam("paramA", DocsPaDbManagement.Functions.Functions.GetSystemIdColName()); query.setParam("paramB", DocsPaDbManagement.Functions.Functions.GetSystemIdNextVal("DPA_PREGRESSI")); query.setParam("id_amm", report.idAmm); query.setParam("id_utente_creatore", report.idUtenteCreatore); query.setParam("id_ruolo_creatore", report.idRuoloCreatore); query.setParam("data_esecuzione", DocsPaDbManagement.Functions.Functions.GetDate()); query.setParam("data_fine", DocsPaDbManagement.Functions.Functions.ToDate(report.dataFine)); query.setParam("num_doc", report.itemPregressi.Count().ToString()); //Andrea - Aggiunta descrizione report string desc = string.Empty; if (string.IsNullOrEmpty(report.descrizione)) { query.setParam("descrizione", "--"); } else { desc = report.descrizione.Replace("'", "''"); query.setParam("descrizione", report.descrizione.ToString()); } string commandText = query.getSQL(); System.Diagnostics.Debug.WriteLine("SQL - InsertReportPregressi - DocsPaDB/ImportPregressi.cs - QUERY : " + commandText); logger.Debug("SQL - InsertReportPregressi - DocsPaDB/ImportPregressi.cs - QUERY : " + commandText); if (!dbProvider.ExecuteNonQuery(commandText)) { dbProvider.RollbackTransaction(); throw new Exception(); } else { // Recupero systemid appena inserito string sql = DocsPaDbManagement.Functions.Functions.GetQueryLastSystemIdInserted("DPA_PREGRESSI"); System.Diagnostics.Debug.WriteLine("SQL - InsertReportPregressi - DocsPaDB/ImportPregressi.cs - QUERY : " + sql); logger.Debug("SQL - InsertReportPregressi - DocsPaDB/ImportPregressi.cs - QUERY : " + sql); dbProvider.ExecuteScalar(out system_id, sql); dbProvider.CommitTransaction(); } } } catch (Exception e) { system_id = string.Empty; logger.Debug(e.Message); } return(system_id); }
public bool NumeroProtocolloUnivocoPerReg(string numproto, string codreg) { bool result = true; DocsPaUtils.Query q; string queryString; try { using (DocsPaDB.DBProvider dbProvider = new DBProvider()) { q = DocsPaUtils.InitQuery.getInstance().getQuery("V_PROTO_PREGRESSI"); q.setParam("param1", codreg); q.setParam("param2", " = " + numproto); queryString = q.getSQL(); logger.Debug("Inserimento nuova applicazione: "); logger.Debug(queryString); if (!dbProvider.ExecuteNonQuery(queryString)) { result = false; throw new Exception(); } } } catch (Exception e) { result = false; logger.Debug(e.Message); } return(result); }
public void saveStrutturaSottofascicoli(int id, DataTable data, string name, string idAmm) { using (DBProvider provider = new DBProvider()) { provider.BeginTransaction(); bool Isnew = id == int.MinValue; try { // Salvo nella template if (Isnew) { insertTemplateStruttura(ref id, name, idAmm); insertStrutturaFascicoli(id, data); } else { updateTemplateStruttura(id, name); updateStrutturaFascicoli(id, data, idAmm); } provider.CommitTransaction(); } catch (Exception ex) { provider.RollbackTransaction(); _log.Error(ex); } } }
public static HttpResult register(SqlConnection connect, User user, Address addess, string password) { HttpResult result = new HttpResult(); password = DBProvider.EncodeSHA1(password); try { string sql = "[tk].[register_user]"; SqlCommand cmd = new SqlCommand(sql, connect); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@userName", user.UserName); cmd.Parameters.AddWithValue("@password", password); cmd.Parameters.AddWithValue("@email", user.Email); cmd.Parameters.AddWithValue("@address", addess.AddressName); cmd.Parameters.AddWithValue("@phoneNumber", addess.PhoneNumber); cmd.Parameters.Add("@userIdOut", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@resultOut", SqlDbType.VarChar, 200).Direction = ParameterDirection.Output; connect.Open(); cmd.ExecuteNonQuery(); result.ID = (int)cmd.Parameters["@userIdOut"].Value; result.Message = cmd.Parameters["@resultOut"].Value.ToString(); result.Result = result.ID > 0 ? true : false; } catch (Exception e) { result.ID = -1; result.Message = TkConstant.UnexpectedError; result.Result = false; connect.Close(); return(result); } connect.Close(); return(result); }
public bool IsNodoStrutturaInFascicoliEmpty(string strutturaid, string nodename, out int numfascicoli, string idamm) { bool result = false; try { // SELECT DocsPaUtils.Query q = DocsPaUtils.InitQuery.getInstance().getQuery("S_NODO_IN_FASCICOLI"); q.setParam("ID_TEMPLATE", strutturaid); q.setParam("NODE_NAME", nodename); q.setParam("PARAM1", string.Format("AND ID_AMM = {0}", idamm)); string count = string.Empty; string command = q.getSQL(); _log.Debug(command); result = new DBProvider().ExecuteScalar(out count, command); numfascicoli = Convert.ToInt32(count); } catch (Exception e) { _log.Debug("SQL - IsNodoStrutturaInFascicoliEmpty - ERRORE : " + e.Message); numfascicoli = 0; } return(result); }
/// <summary> /// /// </summary> /// <param name="historyId"></param> public void DeleteLdapSyncHistoryItem(int idHistoryItem) { try { using (DocsPaDB.DBProvider dbProvider = new DBProvider()) { DocsPaUtils.Query queryDef = DocsPaUtils.InitQuery.getInstance().getQuery("D_DELETE_LDAP_SYNC_HISTORY_ITEM"); queryDef.setParam("id", idHistoryItem.ToString()); string commandText = queryDef.getSQL(); logger.Debug(commandText); int rowsAffected; dbProvider.ExecuteNonQuery(commandText, out rowsAffected); if (rowsAffected == 0) { throw new ApplicationException("Errore in esecuzione query D_DELETE_LDAP_SYNC_HISTORY_ITEM"); } } } catch (Exception ex) { string errorMessage = "Errore nella rimozione delle informazioni sulle sincronizzazioni LDAP effettuate per l'amministrazione"; logger.Debug(errorMessage, ex); throw new ApplicationException(errorMessage, ex); } }
/// <summary> /// Reperimento tipi documento ammessi per l'amministrazione /// per cui è presente un modello predefinito /// </summary> /// <param name="admin"></param> /// <returns></returns> private static AdminSupportedFile[] GetAdminSupportedFileModels(string admin) { List <AdminSupportedFile> list = new List <AdminSupportedFile>(); DocsPaUtils.Query queryDef = DocsPaUtils.InitQuery.getInstance().getQuery("S_GET_ADMIN_BY_CODE_SUPPORTED_FILE_MODELS"); queryDef.setParam("codiceAmministrazione", admin); string commandText = queryDef.getSQL(); logger.Debug(commandText); using (DBProvider provider = new DBProvider()) { using (IDataReader reader = provider.ExecuteReader(commandText)) { while (reader.Read()) { AdminSupportedFile supportedFile = new AdminSupportedFile(); supportedFile.FileExtension = reader.GetValue(reader.GetOrdinal("FILE_EXTENSION")).ToString(); if (!reader.IsDBNull(reader.GetOrdinal("CONTAINS_FILE_MODEL"))) { supportedFile.ContainsModel = (reader.GetInt32(reader.GetOrdinal("CONTAINS_FILE_MODEL")) > 0); } list.Add(supportedFile); } } } return(list.ToArray()); }
/// <summary> /// Metodo per il recupero delle informazioni necessarie alla scrittura /// del summary di un documento nella stampa del registro di conservazione. /// </summary> /// <param name="idDoc"></param> /// <returns></returns> public RegistroConservazioneSummary GetSummaryDataDoc(string idDoc) { RegistroConservazioneSummary retVal = new RegistroConservazioneSummary(); Query query = InitQuery.getInstance().getQuery("S_REG_CONS_SUMMARY_DATA_DOC"); query.setParam("id_doc", idDoc); using (DBProvider dbProvider = new DBProvider()) { using (IDataReader dataReader = dbProvider.ExecuteReader(query.getSQL())) { while (dataReader.Read()) { retVal.creationDate = dataReader["DATA_INS"].Equals(DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dataReader["DATA_INS"]); retVal.descrizione = dataReader["VAR_OGGETTO"].Equals(DBNull.Value) ? string.Empty : dataReader["VAR_OGGETTO"].ToString(); retVal.codiceFascicolo = dataReader["COD_FASC"].Equals(DBNull.Value) ? string.Empty : dataReader["COD_FASC"].ToString(); retVal.numDoc = dataReader["NUMERO_ALLEGATI"].Equals(DBNull.Value) ? string.Empty : dataReader["NUMERO_ALLEGATI"].ToString(); retVal.tipoFile = dataReader["VAR_TIPO_FILE"].Equals(DBNull.Value) ? string.Empty : dataReader["VAR_TIPO_FILE"].ToString(); retVal.fileDim = dataReader["SIZE_ITEM"].Equals(DBNull.Value) ? string.Empty : dataReader["SIZE_ITEM"].ToString(); //retVal.creationDate = Convert.ToDateTime(dataReader["DATA_INS"]); //retVal.descrizione = dataReader["VAR_OGGETTO"].ToString(); //retVal.codiceFascicolo = dataReader["COD_FASC"].ToString(); //retVal.numDoc = dataReader["NUMERO_ALLEGATI"].ToString(); //retVal.tipoFile = dataReader["VAR_TIPO_FILE"].ToString(); //retVal.fileDim = dataReader["SIZE_ITEM"].ToString(); } } } return(retVal); }
/// <summary> /// Set the <see cref="ConnectionType"/> to use it for opening connections to the database. /// </summary> private void SetConnectionType() { switch (DBProvider.ToUpperInvariant()) { case "SQLSERVER": case "MSSQL": case "MICROSOFT": case "MSDE": #if NETSTANDARD case "SYSTEM.DATA.SQLCLIENT": var assembly = Assembly.Load(new AssemblyName("System.Data.SqlClient")); #else var assembly = systemDataAssembly; #endif ConnectionType = assembly.GetType("System.Data.SqlClient.SqlConnection", true, true); break; #if !NETSTANDARD case "OLEDB": ConnectionType = systemDataAssembly.GetType("System.Data.OleDb.OleDbConnection", true); break; case "ODBC": ConnectionType = systemDataAssembly.GetType("System.Data.Odbc.OdbcConnection", true); break; #endif default: ConnectionType = Type.GetType(DBProvider, true); break; } }
/// <summary> /// Inserir Usuário na tabela tb_Usuario /// </summary> /// <param name="_nome"></param> /// <param name="_dataNascimento"></param> /// <param name="_escolaridade"></param> /// <param name="_foneFixo"></param> /// <param name="_foneCel"></param> /// <param name="_estIngles"></param> /// <param name="_escolaEstIngles"></param> /// <param name="_anoEstIngles"></param> /// <param name="_estagioEstIngles"></param> /// <param name="_motivo"></param> /// <param name="_userid">ID do usuário inserido na tabela do membership</param> /// <returns>"-1" indica erro</returns> public static int InserirUsuario(String _nome, String _dataNascimento, int _escolaridade, String _foneFixo, String _foneCel, char _estIngles, String _escolaEstIngles, int?_anoEstIngles, String _estagioEstIngles, String _motivo, String _role, String _applicationName, String _userName, String _password, String _passSalt, String _email, String _question, String _answer) { String msg; Hashtable retorno = DBProvider.InstanceProcedureOutData("inserirUsuario", out msg, DbParametro.Parametro("@nome", _nome, DbType.String), DbParametro.Parametro("@dataNascimento", _dataNascimento, DbType.String), DbParametro.Parametro("@escolaridade", _escolaridade, DbType.Int32), DbParametro.Parametro("@foneFixo", _foneFixo, DbType.String), DbParametro.Parametro("@foneCel", _foneCel, DbType.String), DbParametro.Parametro("@estudouIngles", _estIngles, DbType.String), DbParametro.Parametro("@escolaEstIngles", _escolaEstIngles, DbType.String), DbParametro.Parametro("@anoEstIngles", _anoEstIngles, DbType.Int32), DbParametro.Parametro("@estagioEstIngles", _estagioEstIngles, DbType.String), DbParametro.Parametro("@motivo", _motivo, DbType.String), DbParametro.Parametro("@role", _role, DbType.String), DbParametro.Parametro("@ApplicationName", _applicationName, DbType.String), DbParametro.Parametro("@UserName", _userName, DbType.String), DbParametro.Parametro("@Password", _password, DbType.String), DbParametro.Parametro("@PasswordSalt", _passSalt, DbType.String), DbParametro.Parametro("@Email", _email, DbType.String), DbParametro.Parametro("@PasswordQuestion", _question, DbType.String), DbParametro.Parametro("@PasswordAnswer", _answer, DbType.String), DbParametro.Parametro("@UserId", DBNull.Value, DbType.Int32, ParameterDirection.InputOutput)); return(Convert.ToInt32(retorno["@UserId"])); }
public void RefreshOrdersRange() { var res = DBProvider.GetOrders(StartDt, EndDt, out List <OrderFlight> sVOOrders); if (res != null) { foreach (DateTime dt in dOrders.Keys) { if ((dt >= StartDt) && (dt < EndDt)) { List <OrderFlight> flList = new List <OrderFlight>(); dOrders.TryGetValue(dt, out flList); if (flList != null) { flList.RemoveAll(a => a.DeliveryDate >= StartDt && a.DeliveryDate < EndDt); } flList.AddRange(res.Where(a => a.DeliveryDate >= dt && a.DeliveryDate < dt.AddMonths(1))); Calc.CalkDiscounts(flList); } } UpdateOrders(res); SVOorders.Clear(); SVOorders.AddRange(sVOOrders); } }
public static void InsertJsonToken(JsonImportData Model) { try { var lstSqlParameter = new List <SqlParameter>(); lstSqlParameter.Add(new SqlParameter() { ParameterName = "@FeedProviderID", Value = Model.FeedProviderID, SqlDbType = SqlDbType.BigInt }); lstSqlParameter.Add(new SqlParameter() { ParameterName = "@EventID", Value = Model.EventID, SqlDbType = SqlDbType.BigInt }); lstSqlParameter.Add(new SqlParameter() { ParameterName = "@FeedID", Value = Model.FeedID, SqlDbType = SqlDbType.NVarChar }); lstSqlParameter.Add(new SqlParameter() { ParameterName = "@JsonData", Value = Model.JsonData, SqlDbType = SqlDbType.NVarChar }); var oResult = DBProvider.ExecuteNonQuery("spr_JsonImportData_Insert", CommandType.StoredProcedure, ref lstSqlParameter); } catch (Exception ex) { LogHelper.InsertErrorLogs("[DataLaundryScheduler] JsonImportDataHelper", "InsertJsonToken", ex.Message, ex.InnerException?.Message, ex.StackTrace, Model.FeedProviderID); } }
public IActionResult RangeGet(string resource, string field) { try { if (Request.Query.ContainsKey("start") || Request.Query.ContainsKey("end")) { var q = SpecialQueries.TryGetRangeQuery(resource, field, Request.Query); if (q == null) { return(StatusCode(400)); } return(Json(DBProvider.Select(q))); } else { return(StatusCode(400)); } } catch (Npgsql.PostgresException) { return(StatusCode(400)); } catch (DBProviderExecuteException) { return(StatusCode(500)); } }
public FileContentResult GetFile(int id) { var imagedata = provider.returnCommanditaire(id).logo; var contentType = DBProvider.GetContentType(imagedata); return(new FileContentResult(imagedata, string.Format("image/{0}", contentType.ToString().ToLower()))); }
public IActionResult Add(string resource, [FromBody] JObject RequestData) { DataModel requestModel; try { requestModel = (DataModel)RequestData.ToObject(ResourceMap.TryGetResourceType(resource)); } catch { return(StatusCode(400)); } int insertID = 0; try { insertID = DBProvider.Insert(resource, requestModel); } catch (DBProviderExecuteException) { return(StatusCode(500)); } return(Json(new KeyValuePair <string, int>(key: "insert id", value: insertID))); }
public IActionResult ExpandGet(string resource) { try { // Try find expand query string q = SpecialQueries.TryGetExpandQuery(resource); if (q != null) { return(Json(DBProvider.Select(q))); } else { return(Json(DBProvider.Select("SELECT * FROM " + resource))); } } catch (Npgsql.PostgresException) { return(StatusCode(400)); } catch (DBProviderExecuteException) { return(StatusCode(500)); } }
public static bool UpdateExtApplication(DocsPaVO.utente.ExtApplication applicazione) { bool result = true; DocsPaUtils.Query q; string queryString; try { using (DocsPaDB.DBProvider dbProvider = new DBProvider()) { q = DocsPaUtils.InitQuery.getInstance().getQuery("U_DPA_APPLICAZIONE"); q.setParam("param1", applicazione.codice); q.setParam("param2", applicazione.descrizione); q.setParam("param3", applicazione.systemId); queryString = q.getSQL(); logger.Debug(queryString); if (!dbProvider.ExecuteNonQuery(queryString)) { result = false; dbProvider.RollbackTransaction(); throw new Exception(); } } } catch (Exception e) { result = false; logger.Debug(e.Message); } return(result); }
public static ArrayList GetExtApplications() { ArrayList appicazioni = new ArrayList(); using (DocsPaDB.DBProvider dbProvider = new DBProvider()) { logger.Debug("getExtApplication"); Query query = DocsPaUtils.InitQuery.getInstance().getQuery("S_DPA_APPLICAZIONI"); string commandText = query.getSQL(); logger.Debug(commandText); DataSet dataSet; if (dbProvider.ExecuteQuery(out dataSet, "DPA_EXT_APPS", commandText)) { foreach (DataRow dataRow in dataSet.Tables["DPA_EXT_APPS"].Rows) { DocsPaVO.utente.ExtApplication extApp = new DocsPaVO.utente.ExtApplication(); extApp.systemId = dataRow["SYSTEM_ID"].ToString(); extApp.codice = dataRow["VAR_CODE"].ToString(); extApp.descrizione = dataRow["DESCRIPTION"].ToString(); appicazioni.Add(extApp); } dataSet.Dispose(); } else { logger.Debug("Errore nell'esecuzione della query in 'getExtApplications'"); throw new ApplicationException("Errore nell'esecuzione della query 'getExtApplications'"); } } return(appicazioni); }
public static bool CreateRelExtApp_Utents(string idApplicazione, string idUtenti) { bool result = true; DocsPaUtils.Query q; string queryString; try { using (DocsPaDB.DBProvider dbProvider = new DBProvider()) { //inserimento della nuova delega nella tabelle DPA_GestioneApplicazioni q = DocsPaUtils.InitQuery.getInstance().getQuery("I_DPA_REL_APP_UTENTI"); q.setParam("param1", idApplicazione); q.setParam("param2", idUtenti); queryString = q.getSQL(); logger.Debug("Inserimento relazione applicazione utente: "); logger.Debug(queryString); if (!dbProvider.ExecuteNonQuery(queryString)) { result = false; dbProvider.RollbackTransaction(); throw new Exception(); } } } catch (Exception e) { result = false; logger.Debug(e.Message); } return(result); }
public static bool DeleteRelExtApp_Utents(string idApplicazione, string idUtenti) { bool result = true; DocsPaUtils.Query q; string queryString; try { using (DocsPaDB.DBProvider dbProvider = new DBProvider()) { q = DocsPaUtils.InitQuery.getInstance().getQuery("D_DPA_REL_APP_UTENTE"); q.setParam("param1", idApplicazione + " AND ID_PEOPLE IN (" + idUtenti + ")"); queryString = q.getSQL(); logger.Debug("Cancellazione relazioni applicazione utenti: "); logger.Debug(queryString); if (!dbProvider.ExecuteNonQuery(queryString)) { result = false; dbProvider.RollbackTransaction(); throw new Exception(); } } } catch (Exception e) { result = false; logger.Debug(e.Message); } return(result); }
public DBElement(DBProvider prov) { Name = prov.Name; ProviderName = prov.ProviderName; DatabaseClassName = prov.EnumDb.ToString(); ConnectionString = prov.ConnectionsString; }
public DataSet GetNotifichePecData(InfoUtente userInfo, List <FiltroRicerca> searchFilters) { DataSet dataSet = new DataSet(); using (DBProvider dbProvider = new DBProvider()) { // Reperimento query da eseguire ed esecuzione Query query = InitQuery.getInstance().getQuery("S_DPA_NOTIFICA2"); query.setParam("dbuser", DocsPaDbManagement.Functions.Functions.GetDbUserSession()); query.setParam("docnumber", "docnumber = " + searchFilters[0].valore); // Impostazione filtri query.setParam("filterCond", this.GetConditionFilter(searchFilters)); //verifica se è necessario stampare anche le conferme di ricezione if (IsPrintConfirmRecept(searchFilters)) { query.setParam("unionConfermaRicevute", GetQueryConfirmRecept(searchFilters)); //modifico la queryper le conferme di ricezione } else { query.setParam("unionConfermaRicevute", string.Empty); } dbProvider.ExecuteQuery(out dataSet, query.getSQL()); } return(dataSet); }
public static User Login(string email, string password) { User user = null; var lstSqlParameter = new List <SqlParameter>(); string encPassword = CommonFunctions.EncyptData(password); lstSqlParameter.Add(new SqlParameter() { ParameterName = "@Email", SqlDbType = SqlDbType.NVarChar, Value = email }); lstSqlParameter.Add(new SqlParameter() { ParameterName = "@Password", SqlDbType = SqlDbType.NVarChar, Value = encPassword }); var dt = DBProvider.GetDataTable("ValidateAdminLogin", CommandType.StoredProcedure, ref lstSqlParameter); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { user = new User() { Id = Convert.ToInt32(row["Id"]), Name = row["Name"].ToString(), Email = row["Email"].ToString(), }; break; } } return(user); }
/// <summary> /// Metodo per il salvataggio del dettaglio di un Raggruppamento Funzionale nella rubrica /// locale. /// </summary> /// <param name="rf">Dettagli da salvare</param> /// <param name="idRf">Id dell'RF</param> /// <returns>Esito dell'operazione di salvataggio dei dettagli</returns> public bool SaveRaggruppamentoFunzionaleCorrGlobali(RaggruppamentoFunzionale rf, String idRf) { bool retVal = false; String idCorr = this.GetIdRfCorrGlobali(idRf); Query query = InitQuery.getInstance().getQuery("U_DPADettGlob2"); query.setParam("param1", String.Format("'{0}',", rf.indirizzo)); query.setParam("param2", String.Format("'{0}',", rf.citta)); query.setParam("param3", String.Format("'{0}',", rf.cap)); query.setParam("param4", String.Format("'{0}',", rf.prov)); query.setParam("param5", String.Format("'{0}',", rf.nazionalita)); query.setParam("param6", String.Format("'{0}',", rf.telefono1)); query.setParam("param7", String.Format("'{0}',", String.Empty)); query.setParam("param8", String.Format("'{0}',", rf.fax)); query.setParam("var_note", String.Format("'{0}'", String.Empty)); query.setParam("param9", idCorr); using (DBProvider dbProvider = new DBProvider()) { retVal = dbProvider.ExecuteNonQuery(query.getSQL()); } return(retVal); }
public DBIIFFile(FileInfo file, DBProvider dbProvider) : this(file.Name, dbProvider) { }
public DBCIFFile(string filename, DBProvider dbProvider) : base(filename) { this.dbProvider = Contract.Required(dbProvider, "dbProvider"); }
private void InitializeLists(DBProvider dbProvider) { languages = new Lazy<LanguageCache>(() => new LanguageCache(dbProvider, this)); countries = new Lazy<CountryCache>(() => new CountryCache()); associations = new Lazy<AssociationCache>(() => new AssociationCache(dbProvider, this)); states = new Lazy<StateCache>(() => new StateCache(dbProvider, this)); reasons = new Lazy<ReasonCache>(() => new ReasonCache(dbProvider, this)); users = new Lazy<UserCache>(() => new UserCache(dbProvider, this)); surcharges = new Lazy<SurchargeCache>(() => new SurchargeCache(dbProvider, this)); usages = new Lazy<UsageCache>(() => new UsageCache(dbProvider, this)); serieTypes = new Lazy<SerieTypeCache>(() => new SerieTypeCache(dbProvider, this)); deliveryModes = new Lazy<DeliveryModeCache>(() => new DeliveryModeCache(dbProvider, this)); clause31Insurers = new Lazy<Clause31InsurerCache>(() => new Clause31InsurerCache(dbProvider, this)); insurerCalendars = new Lazy<InsurerCalendarCache>(() => new InsurerCalendarCache(dbProvider, this)); packetTypes = new Lazy<PacketTypeCache>(() => new PacketTypeCache(dbProvider, this)); holders = new Lazy<HolderCache>(() => new HolderCache()); }
public DBFileFactory(DBProvider provider) { this.provider = Contract.Required(provider, "provider"); }
public TIRReferences(DBProvider dbProvider) { InitializeLists(dbProvider); }
public DBCIFFile(FileInfo file, DBProvider dbProvider) : this(file.FullName, dbProvider) { }
/// <summary> /// 注册新的数据库提供器(动态注射数据库提供器)到缓存中 /// </summary> /// <param name="provider"></param> public static void RegisterProvider(string name, DBProvider.IDBProvider provider) { if (providerList == null) { providerList = new Dictionary<string, ADeeWu.HuoBi3J.SQL.DBProvider.IDBProvider>(); } lock (syncProviderList) { if (providerList.ContainsKey(name)) { providerList.Remove(name); } providerList.Add(name, provider); } }