public int TaskModifyProcessParamRegGeral(int _CodigoEmpresa, int _CodigoNatFunc, int _CodigoNatFuncLider, int _CodigoNatCliente, int _CodigoNatFornecedor, int _CodigoNatBanco, int _CodigoStatusAtivo, int _CodigoStatusInativo, string _PermiteCGCCPFZerado, int _CodigoNatTomadora, int _CodigoNatResp, string _PermiteCGCCPFDuplicado, string _TipoModificacao)
{
int _Result = 0;
List <DbParameter> _ParameterList = new List <DbParameter>();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Rg_ModificaProcessoParamRegGeral]";
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoEmpresa", System.Data.DbType.Int32, _CodigoEmpresa));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoNatFunc", System.Data.DbType.Int32, _CodigoNatFunc));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoNatFuncLider", System.Data.DbType.Int32, _CodigoNatFuncLider));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoNatCliente", System.Data.DbType.Int32, _CodigoNatCliente));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoNatFornecedor", System.Data.DbType.Int32, _CodigoNatFornecedor));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoNatBanco", System.Data.DbType.Int32, _CodigoNatBanco));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoStatusAtivo", System.Data.DbType.Int32, _CodigoStatusAtivo));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoStatusInativo", System.Data.DbType.Int32, _CodigoStatusInativo));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@PermiteCGCCPFZerado", System.Data.DbType.String, _PermiteCGCCPFZerado));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoNatTomadora", System.Data.DbType.Int32, _CodigoNatTomadora));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoNatResp", System.Data.DbType.Int32, _CodigoNatResp));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@PermiteCGCCPFDuplicado", System.Data.DbType.String, _PermiteCGCCPFDuplicado));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@ModifyType", System.Data.DbType.String, _TipoModificacao));
try
{
_Result = Convert.ToInt32(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteScalar));
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public SessaoUsuarioLogin RetornaProcessoSessaoUsuario(string _Usuario)
{
SessaoUsuarioLogin _Result = null;
DataTable _DataTable = new DataTable();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = " SELECT Usuario," +
" IdSession," +
" DateTimeSession," +
" MachineName," +
" MachineIP," +
" LogonNumber" +
" FROM ge_sessao_usuario" +
" WHERE Usuario = " + "'" + _Usuario + "'";
try
{
_DataTable = (DataTable)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, System.Data.CommandType.Text, null, ExecuteType.ExecuteDataTable);
if (_DataTable.Rows.Count > 0)
{
_Result = new SessaoUsuarioLogin(_DataTable.Rows[0]);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_DataTable.Dispose();
}
return(_Result);
}
public int TaskModifyProcessEmpresa(int _CodigoEmpresa, string _DescricaoEmpresa, string _DescricaoEmpresaRed, int _CodigoEmpresaConsolidada, string _Ativa, int _CodigoRg, string _Host, int _Port, string _Username, string _Senha, string _Email, string _EnderecoBanco, string _Versao, string _TipoModificacao)
{
int _Result = 0;
List <DbParameter> _ParameterList = new List <DbParameter>();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Rg_ModificaProcessoEmpresa]";
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoEmpresa", System.Data.DbType.Int32, _CodigoEmpresa));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@DescricaoEmpresa", System.Data.DbType.String, _DescricaoEmpresa));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@DescricaoEmpresaRed", System.Data.DbType.String, _DescricaoEmpresaRed));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoEmpresaConsolidada", System.Data.DbType.Int32, _CodigoEmpresaConsolidada));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Ativa", System.Data.DbType.String, _Ativa));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoRg", System.Data.DbType.Int32, _CodigoRg));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Host", System.Data.DbType.String, _Host));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Port", System.Data.DbType.Int32, _Port));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Username", System.Data.DbType.String, _Username));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Senha", System.Data.DbType.String, _Senha));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Email", System.Data.DbType.String, _Email));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@EnderecoBanco", System.Data.DbType.String, _EnderecoBanco));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Versao", System.Data.DbType.String, _Versao));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@ModifyType", System.Data.DbType.String, _TipoModificacao));
try
{
_Result = Convert.ToInt32(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteScalar));
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public NomeFantasiaLogin GetNomeFantasiaTask(int _CodigoEmpresa)
{
NomeFantasiaLogin _Result = null;
DataTable _DataTable = new DataTable();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "select distinct" +
" emp.descr_empr_red as NomeFantasia" +
" from ge_empresa as emp" +
" where emp.cod_empr = " + _CodigoEmpresa;
try
{
_DataTable = (DataTable)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, System.Data.CommandType.Text, null, ExecuteType.ExecuteDataTable);
if (_DataTable.Rows.Count > 0)
{
_Result = new NomeFantasiaLogin(_DataTable.Rows[0]);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_DataTable.Dispose();
}
return(_Result);
}
public string ActionExecuteChangeLog(ChangesHeader _ChangesHeader, List <ChangeItem> _ChangeItemCollection)
{
string _Result = string.Empty;
MappingChanges _MappingChanges = null;
string _XML = string.Empty;
List <DbParameter> _ParameterList = new List <DbParameter>();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04_HistoricoModificacoes"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04_HistoricoModificacoes"].ProviderName;
string _TSQL = "[dbo].[Log_ModificaLogModificacoes]";
_MappingChanges = ServiceHelper.CreateInstance.GetMappingChanges(_ChangesHeader, _ChangeItemCollection);
_XML = SerializationData.CreateInstance.GetSerializableData(_MappingChanges, "MappingExecuteChangeLog");
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@XMLChangeLog", System.Data.DbType.Xml, _XML));
try
{
_Result = Convert.ToString(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteScalar));
}
catch (Exception ex)
{
ExceptionHandling.CreateInstance.AddExceptionAndSaveTextFile(ex);
}
return(_Result);
}
public int TaskModifyProcessUsuario(string _Usuario, string _Nome, int _CodigoEmpresa, int _CodigoRG, string _StatusDBA, DateTime _DataCadastro, string _Senha, string _Ramal, string _Ativo, string _UsuarioIncl, string _TipoModificacao)
{
int _Result = 0;
List <DbParameter> _ParameterList = new List <DbParameter>();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Ge_ModificaProcessoUsuario]";
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Usuario", System.Data.DbType.String, _Usuario));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Nome", System.Data.DbType.String, _Nome));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoEmpresa", System.Data.DbType.Int32, _CodigoEmpresa));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoRG", System.Data.DbType.Int32, _CodigoRG));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@StatusDBA", System.Data.DbType.String, _StatusDBA));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@DataCadastro", System.Data.DbType.DateTime, _DataCadastro));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Senha", System.Data.DbType.String, _Senha));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Ramal", System.Data.DbType.String, _Ramal));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Ativo", System.Data.DbType.String, _Ativo));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@ModifyType", System.Data.DbType.String, _TipoModificacao));
try
{
_Result = Convert.ToInt32(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteScalar));
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public int ModificaProcessoSessaoUsuario(string _Usuario, string _IdSession, DateTime _DateTimeSession, string _MachineName, string _MachineIP, int _LogonNumber)
{
int _Result = 0;
List <DbParameter> _ParameterList = new List <DbParameter>();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Modifica_Processo_Sessao_Usuario]";
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Usuario", System.Data.DbType.String, _Usuario));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@IdSession", System.Data.DbType.String, _IdSession));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@DateTimeSession", System.Data.DbType.DateTime, _DateTimeSession));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@MachineName", System.Data.DbType.String, _MachineName));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@MachineIP", System.Data.DbType.String, _MachineIP));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@LogonNumber", System.Data.DbType.Int32, _LogonNumber));
try
{
_Result = Convert.ToInt32(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteNonQuery));
}
catch (Exception _Ex)
{
throw _Ex;
}
return(_Result);
}
public List <GeTipoProcesso> TaskGetCollectionGeTipoProcessoByFilter(string _StrFilter, int _IsFilter)
{
List <GeTipoProcesso> _Result = new List <GeTipoProcesso>();
List <DbParameter> _ParameterList = new List <DbParameter>();
DataTable _DataTable = null;
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Ge_RetornaTipoProcesso]";
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@StrFilter", System.Data.DbType.String, _StrFilter));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@IsFilter", System.Data.DbType.Int32, _IsFilter));
try
{
_DataTable = (DataTable)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteDataTable);
foreach (DataRow _Row in _DataTable.Rows)
{
_Result.Add(new GeTipoProcesso(_Row));
}
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public List <GeProcesso> TaskGetCollectionGeProcessoByEmpresaAplicacaoTipoProcesso(int _CodigoEmpresa, int _CodigoAplicacao, string _Usuario, string _TipoDeModificacao)
{
List <GeProcesso> _Result = new List <GeProcesso>();
List <DbParameter> _ParameterList = new List <DbParameter>();
DataTable _DataTable = null;
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Ge_RetornaProcessoDeLiberacaoUsuarioPorEmpresaAplicacaoTipoProcesso]";
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoEmpresa", System.Data.DbType.Int32, _CodigoEmpresa));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoAplicacao", System.Data.DbType.Int32, _CodigoAplicacao));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Usuario", System.Data.DbType.String, _Usuario));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@TipoDeModificacao", System.Data.DbType.String, _TipoDeModificacao));
try
{
_DataTable = (DataTable)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteDataTable);
foreach (DataRow _Row in _DataTable.Rows)
{
_Result.Add(new GeProcesso(_Row));
}
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public int TaskModifyProcessProcesso(int _CodigoProcesso, string _DescricaoProcesso, int _CodigoTipoProcesso, int _CodigoAplicacao, string _Ativo, string _Form, int _SequenciaProcesso, string _TipoModificacao)
{
int _Result = 0;
List <DbParameter> _ParameterList = new List <DbParameter>();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Ge_ModificaProcessoProcesso]";
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoProcesso", System.Data.DbType.Int32, _CodigoProcesso));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@DescricaoProcesso", System.Data.DbType.String, _DescricaoProcesso));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoTipoProcesso", System.Data.DbType.Int32, _CodigoTipoProcesso));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoAplicacao", System.Data.DbType.Int32, _CodigoAplicacao));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Ativo", System.Data.DbType.String, _Ativo));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Form", System.Data.DbType.String, _Form));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@SequenciaProcesso", System.Data.DbType.Int32, _SequenciaProcesso));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@ModifyType", System.Data.DbType.String, _TipoModificacao));
try
{
_Result = Convert.ToInt32(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteScalar));
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public string RetornaCaminhoDiretorioEmpresa(int _CodigoEmpresa)
{
string _Result = null;
DataTable _DataTable = new DataTable();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = " SELECT dir_logo_empresa" +
" FROM ge_parametro" +
" WHERE id_tabela = " + _CodigoEmpresa;
try
{
_DataTable = (DataTable)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, System.Data.CommandType.Text, null, ExecuteType.ExecuteDataTable);
if (_DataTable.Rows.Count > 0)
{
_Result = _DataTable.Rows[0]["dir_logo_empresa"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_DataTable.Dispose();
}
return(_Result);
}
public DataSet GetLoginTask(string _User, string _Password)
{
DataSet _Result = null;
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "declare @UserName char(20) = '" + _User + "'," +
" @Password char(10) = '" + _Password + "'," +
" @Usuario char(20)," +
" @Senha char(10);" +
" set @Usuario = (select usuario from ge_usuario where usuario = @UserName and senha = @Password and ativo = 'S');" +
" set @Senha = (select senha from ge_usuario where usuario = @UserName and senha = @Password and ativo = 'S');" +
" select usuario as Usuario," +
" nome as Nome," +
" cod_empr as CodigoEmpresa," +
" cod_rg as CodigoRegistroGeral," +
" status_dba as StatusDba," +
" ramal as Ramal" +
" from ge_usuario" +
" where usuario = @Usuario" +
" and senha = @Senha;" +
" select distinct" +
" upr.cod_empr as CodigoEmpresa," +
" emp.descr_empr_red as NomeFantasia" +
" from ge_usuario_processo as upr" +
" inner join ge_empresa as emp" +
" on upr.cod_empr = emp.cod_empr" +
" inner join rg_reg_geral as rgl" +
" on emp.cod_rg = rgl.cod_rg" +
" and rgl.cod_status = 1" +
" and upr.usuario = @Usuario" +
" order by upr.cod_empr";
try
{
_Result = (DataSet)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, System.Data.CommandType.Text, null, ExecuteType.ExecuteDataSet);
}
catch (Exception _Ex)
{
throw _Ex;
}
return(_Result);
}
public DataSet GetCollectionLiberacaoUsuarioTask()
{
DataSet _Result = null;
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Ge_RetornaLiberacaoUsuario]";
try
{
_Result = (DataSet)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.Text, null, ExecuteType.ExecuteDataSet);
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public DataSet TaskGeCollectionGeTipoProcessoAplicacaoPorVinculo()
{
DataSet _Result = null;
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Ge_RetornaTipoProcessoAplicacaoPorVinculo]";
try
{
_Result = (DataSet)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, null, ExecuteType.ExecuteDataSet);
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public List <ProcessoLogin> GetProcessoLoginTask(int _CodigoAplicacao, int _CodigoTipoProcesso)
{
List <ProcessoLogin> _Result = new List <ProcessoLogin>();
DataTable _DataTable = new DataTable();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "select distinct" +
" upr.cod_proc as CodigoProcesso," +
" pro.descr_proc as DescricaoProcesso" +
" from ge_usuario_processo as upr" +
" inner join ge_processo as pro" +
" on upr.cod_proc = pro.cod_proc" +
" inner join ge_tipo_processo as tpr" +
" on pro.cod_tipo_proc = tpr.cod_tipo_proc" +
" inner join ge_aplicacao as apl" +
" on apl.cod_aplic = pro.cod_aplic" +
" where pro.cod_aplic = " + _CodigoAplicacao +
" and tpr.cod_tipo_proc = " + _CodigoTipoProcesso +
" order by upr.cod_proc";
try
{
_DataTable = (DataTable)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, System.Data.CommandType.Text, null, ExecuteType.ExecuteDataTable);
foreach (DataRow _Row in _DataTable.Rows)
{
_Result.Add(new ProcessoLogin(_Row));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_DataTable.Dispose();
}
return(_Result);
}
public DataSet TaskGetCollectionsRegistroGeral(int _IdEmpr, int _IdRg)
{
DataSet _Result = null;
List <DbParameter> _ParameterList = new List <DbParameter>();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Rg_RetornaRegistroGeral]";
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@IdEmpr", System.Data.DbType.Int32, _IdEmpr));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@IdRg", System.Data.DbType.Int32, _IdRg));
try
{
_Result = (DataSet)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteDataSet);
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public int TaskModifyProcessGegistroGeral(string _XML, string _TipoModificacao)
{
int _Result = 0;
List <DbParameter> _ParameterList = new List <DbParameter>();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Rg_ModificaProcessoRegistroGeral]";
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@XMLProcessoRegistroGeral", System.Data.DbType.Xml, _XML));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@ModifyType", System.Data.DbType.String, _TipoModificacao));
try
{
_Result = Convert.ToInt32(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteScalar));
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public DataTable RetornaNoDeTiposDeProcessosNoMenuTask(int _CodigoAplicacao, int _CodigoEmpresa)
{
DataTable _Result = null;
List <DbParameter> _ParameterList = new List <DbParameter>();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Ge_RetornaNoDeTiposDeProcessosNoMenu]";
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoAplicacao", System.Data.DbType.Int32, _CodigoAplicacao));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoEmpresa", System.Data.DbType.Int32, _CodigoEmpresa));
try
{
_Result = (DataTable)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, System.Data.CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteDataTable);
}
catch (Exception _Ex)
{
throw _Ex;
}
return(_Result);
}
public void ParseAndSave()
{
var file = httpContext.Request.Files[0];
IEnumerable <ISupplier> list = null;
Dictionary <string, Dictionary <string, int> > ConversionDictionary = null;
switch (model.Supplier)
{
case "Igal":
list = csvParser.Parse <Igal>(file.InputStream);
ConversionDictionary = Igal.ConversionDictionary;
break;
case "IgalGIA":
list = csvParser.Parse <IgalGIA>(file.InputStream);
ConversionDictionary = IgalGIA.ConversionDictionary;
break;
}
list = list.Distinct().ToList();
var mapper = new Mapper <INV_DIAMONDS_INVENTORY>(ConversionDictionary);
mapper.SetPricePolicy(PricePolicy.Calibrate);
mapper.OurPriceCalibration((decimal)1.07);
var dblist = list.Select(mapper.Map).ToList();
var db = new DatabasePersistence();
db.AddSupplierDiamondList(dblist);
db.SaveOrUpdate();
}
public List <GeTipoProcesso> TaskGetCollectionTipoProcesso()
{
List <GeTipoProcesso> _Result = new List <GeTipoProcesso>();
DataTable _DataTable = null;
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Ge_RetornaTipoProcesso]";
try
{
_DataTable = (DataTable)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, null, ExecuteType.ExecuteDataTable);
foreach (DataRow _Row in _DataTable.Rows)
{
_Result.Add(new GeTipoProcesso(_Row));
}
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public GestaoProcessoLogin GetProcessoByIdTask(int _CodigoProcesso)
{
GestaoProcessoLogin _Result = null;
DataTable _DataTable = new DataTable();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = " select cod_proc," +
" descr_proc," +
" cod_tipo_proc," +
" cod_aplic," +
" ativo," +
" form," +
" sequ_proc" +
" from ge_processo" +
" where cod_proc = " + _CodigoProcesso;
try
{
_DataTable = (DataTable)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, System.Data.CommandType.Text, null, ExecuteType.ExecuteDataTable);
if (_DataTable.Rows.Count > 0)
{
_Result = new GestaoProcessoLogin(_DataTable.Rows[0]);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_DataTable.Dispose();
}
return(_Result);
}
public int TaskModifyProcessUsuarioGrupo(int _CodigoEmpresa, int _CodigoGrupo, string _Usuario, string _TipoModificacao)
{
int _Result = 0;
List <DbParameter> _ParameterList = new List <DbParameter>();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "[dbo].[Ge_ModificaProcessoUsuarioGrupo]";
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoEmpresa", System.Data.DbType.Int32, _CodigoEmpresa));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@CodigoGrupo", System.Data.DbType.Int32, _CodigoGrupo));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@Usuario", System.Data.DbType.String, _Usuario));
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@ModifyType", System.Data.DbType.String, _TipoModificacao));
try
{
_Result = Convert.ToInt32(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteScalar));
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
public List <ParametroGerenciador> TaskGetDataProcessesByFilter(int _CodigoParametroGerenciador, int _CodigoTipoProcessoEspecial, int _CodigoTipoProcessoInternet, string _TipoProcesso)
{
List <ParametroGerenciador> _Result = new List <ParametroGerenciador>();
DataTable _DataTable = new DataTable();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "DECLARE" +
" @IdCodigoParametroGerenciador int = 0," +
" @IdTipoProcessoEspecial int = 0," +
" @IdTipoProcessoInternet int = 0," +
" @IdTipoConsulta char(1) = '" + _TipoProcesso + "'" +
" SET @IdCodigoParametroGerenciador = " + _CodigoParametroGerenciador +
" SET @IdTipoProcessoEspecial = " + _CodigoTipoProcessoEspecial +
" SET @IdTipoProcessoInternet = " + _CodigoTipoProcessoInternet +
" IF @IdTipoConsulta = 'C'" +
" BEGIN" +
" SELECT" +
" id_tabela," +
" dir_logo_empresa," +
" dir_pgm_relatorio," +
" dir_relatorio," +
" dir_backup," +
" dir_script," +
" dir_importacao," +
" dir_exportacao_excel," +
" cod_tipo_proc_esp," +
" cod_tipo_proc_int," +
" mostra_form_menu," +
" dir_foto," +
" dir_servidor" +
" FROM" +
" ge_parametro" +
" where id_tabela = @IdCodigoParametroGerenciador" +
" order by id_tabela" +
" END" +
" IF @IdTipoConsulta = 'E'" +
" BEGIN" +
" SELECT" +
" id_tabela," +
" dir_logo_empresa," +
" dir_pgm_relatorio," +
" dir_relatorio," +
" dir_backup," +
" dir_script," +
" dir_importacao," +
" dir_exportacao_excel," +
" cod_tipo_proc_esp," +
" cod_tipo_proc_int," +
" mostra_form_menu," +
" dir_foto," +
" dir_servidor" +
" FROM" +
" ge_parametro" +
" where cod_tipo_proc_esp = @IdTipoProcessoEspecial" +
" order by id_tabela" +
" END" +
" IF @IdTipoConsulta = 'I'" +
" BEGIN" +
" SELECT" +
" id_tabela," +
" dir_logo_empresa," +
" dir_pgm_relatorio," +
" dir_relatorio," +
" dir_backup," +
" dir_script," +
" dir_importacao," +
" dir_exportacao_excel," +
" cod_tipo_proc_esp," +
" cod_tipo_proc_int," +
" mostra_form_menu," +
" dir_foto," +
" dir_servidor" +
" FROM" +
" ge_parametro" +
" where cod_tipo_proc_int = @IdTipoProcessoInternet" +
" order by id_tabela" +
" END" +
" IF @IdTipoConsulta = 'N'" +
" BEGIN" +
" SELECT TOP 100" +
" id_tabela," +
" dir_logo_empresa," +
" dir_pgm_relatorio," +
" dir_relatorio," +
" dir_backup," +
" dir_script," +
" dir_importacao," +
" dir_exportacao_excel," +
" cod_tipo_proc_esp," +
" cod_tipo_proc_int," +
" mostra_form_menu," +
" dir_foto," +
" dir_servidor" +
" FROM" +
" ge_parametro" +
" order by id_tabela" +
" END";
try
{
_DataTable = (DataTable)DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, System.Data.CommandType.Text, null, ExecuteType.ExecuteDataTable);
foreach (DataRow _Row in _DataTable.Rows)
{
_Result.Add(new ParametroGerenciador(_Row));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_DataTable.Dispose();
}
return(_Result);
}
public Object TaskModifyDataProcesses(int _IdTabela, string _DirLogoEmpresa, string _DirPgmRelatorio, string _DirRelatorio, string _DirBackup, string _DirScript, string _DirImportacao, string _DirExportacaoExcel, int _IdTipoProcEsp, int _IdTipoProcInt, string _MostraFormMenu, string _DirFoto, string _DirServidor, string _ModifyType)
{
Object _Result = null;
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04"].ProviderName;
string _TSQL = "DECLARE" +
" @IdTabela int = 0," +
" @DirLogoEmpresa varchar(100) = ''," +
" @DirPgmRelatorio varchar(100) = ''," +
" @DirRelatorio varchar(100) = ''," +
" @DirBackup varchar(100) = ''," +
" @DirScript varchar(100) = ''," +
" @DirImportacao varchar(100) = ''," +
" @DirExportacaoExcel varchar(100) = ''," +
" @IdTipoProcEsp int = 0," +
" @IdTipoProcInt int = 0," +
" @MostraFormMenu char(1) = ''," +
" @DirFoto varchar(100) = ''," +
" @DirServidor varchar(100) = ''," +
" @ModifyType char(1) = 'N'" +
" SET @IdTabela = " + _IdTabela +
" SET @DirLogoEmpresa = '" + _DirLogoEmpresa + "'" +
" SET @DirPgmRelatorio = '" + _DirPgmRelatorio + "'" +
" SET @DirRelatorio = '" + _DirRelatorio + "'" +
" SET @DirBackup = '" + _DirBackup + "'" +
" SET @DirScript = '" + _DirScript + "'" +
" SET @DirImportacao = '" + _DirImportacao + "'" +
" SET @DirExportacaoExcel = '" + _DirExportacaoExcel + "'" +
" SET @IdTipoProcEsp = " + _IdTipoProcEsp +
" SET @IdTipoProcInt = " + _IdTipoProcInt +
" SET @MostraFormMenu = '" + _MostraFormMenu + "'" +
" SET @DirFoto = '" + _DirFoto + "'" +
" SET @DirServidor = '" + _DirServidor + "'" +
" SET @ModifyType = '" + _ModifyType + "'" +
" IF @ModifyType = 'I'" +
" BEGIN" +
" INSERT INTO ge_parametro(dir_logo_empresa," +
" dir_pgm_relatorio," +
" dir_relatorio," +
" dir_backup," +
" dir_script," +
" dir_importacao," +
" dir_exportacao_excel," +
" cod_tipo_proc_esp," +
" cod_tipo_proc_int," +
" mostra_form_menu," +
" dir_foto," +
" dir_servidor)" +
" VALUES(@DirLogoEmpresa," +
" @DirPgmRelatorio," +
" @DirRelatorio," +
" @DirBackup," +
" @DirScript," +
" @DirImportacao," +
" @DirExportacaoExcel," +
" @IdTipoProcEsp," +
" @IdTipoProcInt," +
" @MostraFormMenu," +
" @DirFoto," +
" @DirServidor)" +
" SELECT SCOPE_IDENTITY()" +
" END" +
" IF @ModifyType = 'U'" +
" BEGIN" +
" UPDATE ge_parametro SET dir_logo_empresa = @DirLogoEmpresa," +
" dir_pgm_relatorio = @DirPgmRelatorio," +
" dir_relatorio = @DirRelatorio," +
" dir_backup = @DirBackup," +
" dir_script = @DirScript," +
" dir_importacao = @DirImportacao," +
" dir_exportacao_excel = @DirExportacaoExcel," +
" cod_tipo_proc_esp = @IdTipoProcEsp," +
" cod_tipo_proc_int = @IdTipoProcInt," +
" mostra_form_menu = @MostraFormMenu," +
" dir_foto = @DirFoto," +
" dir_servidor = @DirServidor" +
" WHERE id_tabela = @IdTabela" +
" END" +
" IF @ModifyType = 'D'" +
" BEGIN" +
" DELETE FROM ge_parametro WHERE id_tabela = @IdTabela" +
" END";
try
{
_Result = DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, System.Data.CommandType.Text, null, ExecuteType.ExecuteScalar);
}
catch (Exception ex)
{
throw ex;
}
return(_Result);
}
