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);
}
}
