public TiposTicketsClientesModel GuardarTiposTicketsClientes(TiposTicketsClientesModel tiposTicketsClientesModel)
{
TiposTicketsClientesModel model = new TiposTicketsClientesModel();
try
{
iGenericDataAccess.OpenConnection();
TiposTicketsClientes ticketsClientes = new TiposTicketsClientes
{
IdCliente = tiposTicketsClientesModel.IdCliente,
IdPersonaResponsable = tiposTicketsClientesModel.IdPersonaResponsable,
IdPersonaEscalamiento1 = tiposTicketsClientesModel.IdPersonaEscalamiento1,
IdPersonaEscalamiento2 = tiposTicketsClientesModel.IdPersonaEscalamiento2,
HorasAtencion = tiposTicketsClientesModel.HorasAtencion,
HorasSegundoEscalamiento = tiposTicketsClientesModel.HorasSegundoEscalamiento
};
StringBuilder findSQL = new StringBuilder();
findSQL.Append(" SELECT COUNT(tt.TipoId) TiempoAtencion ");
findSQL.Append(" FROM dbo.TiposTicket tt ");
findSQL.Append(" INNER JOIN dbo.TiposTicketsClientes ttc ");
findSQL.Append(" ON ttc.TipoId = tt.TipoId ");
findSQL.Append(" AND ttc.IdCliente = " + tiposTicketsClientesModel.IdCliente);
findSQL.Append(" AND tt.Descripcion = '" + tiposTicketsClientesModel.TiposTicket.Descripcion + "'");
TiposTicket findTiposTickets = iGenericDataAccess.ExecuteQuery <TiposTicket>(findSQL.ToString())[0];
if (findTiposTickets.TiempoAtencion > 0)
{
throw new DomainException(CodesConfigParamTickets.INF_08_01);
}
TiposTicket tt = new TiposTicket
{
Descripcion = tiposTicketsClientesModel.TiposTicket.Descripcion,
TiempoAtencion = tiposTicketsClientesModel.TiposTicket.TiempoAtencion,
Activa = true
};
TiposTicket saveTicket = iGenericDataAccess.Guardar(tt);
ticketsClientes.TipoId = saveTicket.TipoId;
TiposTicketsClientes saveTiposTicketsClientes = iGenericDataAccess.Guardar(ticketsClientes);
model.IdCliente = saveTiposTicketsClientes.TipoId;
iGenericDataAccess.CloseConnection();
return(model);
}
catch (DomainException e)
{
throw new DomainException(e.Mensaje);
}
catch (Exception e)
{
iGenericDataAccess.CloseConnection();
throw new DalException(CodesConfigParamTickets.ERR_08_03, e);
}
}
public IList <ClienteProductoModel> ConsultarClientes(ClienteProductoModel clienteProductoModel)
{
try
{
iGenericDataAccess.OpenConnection();
//Se cambia para optimizar la consulta.
IList <VwNueListaClientesProducto> lista = iGenericDataAccess
.ExecuteQuery <VwNueListaClientesProducto>(
"SELECT " +
"total.Nombre as NombreCliente" +
", total.idCliente as IdCliente" +
" FROM" +
"(" +
" SELECT " +
" p.Nombre " +
" , ttC.idCliente " +
" , ROW_NUMBER() over(order by ttC.idCliente) as RowNumber " +
" , RANK()over(order by ttC.idCliente) as Rank " +
" FROM dbo.TiposTicketsClientes ttC " +
" INNER JOIN( " +
" SELECT " +
" pD.Valor " +
" FROM " +
" dbo.PerfilDatos pD " +
" Where ISNUMERIC(pD.Valor) = 1 " +
" AND pD.Opcion = 1169 " +
" AND pd.PersonaID = " + clienteProductoModel.GetIdUsuarioSesion() + " AND pd.PerfilID =" + clienteProductoModel.GetIdPerfilUsuarioSesion() + " " +
" ) as pD " +
" ON " +
" ttC.IdCliente = pD.Valor " +
" INNER JOIN dbo.nePersonas p " +
" ON p.PersonaID = pD.Valor and p.Tipo=212 " +
" ) as total" +
" where Rank = RowNumber AND total.Nombre LIKE \'%" + clienteProductoModel.NombreCliente + "%\'");
iGenericDataAccess.CloseConnection();
IList <ClienteProductoModel> clientesList = lista.Select(
x => new ClienteProductoModel()
{
IdCliente = x.IdCliente,
NombreCliente = x.NombreCliente
}).ToList();
return(clientesList);
}
catch (Exception e)
{
iGenericDataAccess.CloseConnection();
throw new DalException(CodesTickets.ERR_00_04, e);
}
}
public int ConsultarTotalDiasInhabiles(DateTime fechaRecepcion)
{
try
{
iGenericDataAccess.OpenConnection();
var queryFinal = "SELECT COUNT(Dia) totalInhabiles FROM CatDiasHabiles WHERE Dia >= {FechaRecepcion} AND Dia < GETDATE()";
queryFinal = queryFinal.Replace("{FechaRecepcion}", "'" + fechaRecepcion.ToString(("yyyy-MM-dd hh:mm:ss")) + "'");
IList <CatDiasHabilesEntidad> inhabiles = iGenericDataAccess.ExecuteQuery <CatDiasHabilesEntidad>(queryFinal);
return(inhabiles[0].TotalInhabiles);
}
catch (Exception e)
{
throw new DalException("Error:::", e);
}
}
public AmVersionSistemaModel ConsultaVesionSistema()
{
try
{
iGenericDataAccess.OpenConnection();
IList <AmVersionSistema> version = iGenericDataAccess.ExecuteQuery <AmVersionSistema>(CQuerysSeguridad.QryVersionSistema);
iGenericDataAccess.CloseConnection();
IList <AmVersionSistemaModel> versionSistema = version.Select(x => new AmVersionSistemaModel
{
IdVersion = x.IdVersion,
Version = x.Version,
Descripcion = x.Descripcion,
Fecha = x.Fecha,
Ot = x.Ot
}).ToList();
return(versionSistema[0]);
}
catch (Exception e)
{
iGenericDataAccess.CloseConnection();
throw new DalException(Codes.ERR_00_00, e);
}
}
