Пример #1
0
        public Caso ClienteCaso(int iIdCaso)
        {
            using (SqlConnection _SqlConnection = new SqlConnection(ConnectionString.DbMPY))
            {
                Caso       NoCliente   = null;
                SqlCommand _SqlCommand = new SqlCommand("MPYCCSPS_NOCLIENTE_CASO", _SqlConnection)
                {
                    CommandType = CommandType.StoredProcedure
                };
                _SqlCommand.Parameters.AddWithValue("@IdCaso", iIdCaso);

                try
                {
                    _SqlConnection.Open();
                    SqlDataReader _SqlDataReader = _SqlCommand.ExecuteReader();
                    if (_SqlDataReader.HasRows)
                    {
                        while (_SqlDataReader.Read())
                        {
                            NoCliente = new Caso()
                            {
                                sCliente = _SqlDataReader["Cliente"].ToString()
                            };
                        }
                    }
                }
                catch (Exception)
                {
                    NoCliente = null;
                }
                return(NoCliente);
            }
        }
Пример #2
0
        public bool bCerrarCaso(Caso caso)
        {
            using (SqlConnection _SqlConnection = new SqlConnection(ConnectionString.DbMPY))
            {
                SqlCommand _SqlCommand = new SqlCommand("LXCCSPU_CASO_ACT_CIERRE", _SqlConnection)
                {
                    CommandType = CommandType.StoredProcedure
                };
                _SqlCommand.Parameters.AddWithValue("@IdCaso", SqlDbType.BigInt).Value            = caso.iIdCaso;
                _SqlCommand.Parameters.AddWithValue("@IdUsuarioModifica", SqlDbType.BigInt).Value = caso.iIdUsuarioModifica;

                var Resultado = _SqlCommand.Parameters.Add("@Id", SqlDbType.BigInt);
                Resultado.Direction = ParameterDirection.ReturnValue;

                try
                {
                    _SqlConnection.Open();
                    _SqlCommand.ExecuteNonQuery();
                    var Resp = Resultado.Value;
                    if (int.Parse(Resp.ToString()) != 0)
                    {
                        return(true);
                    }
                    else
                    {
                        return(false);
                    }
                }
                catch (Exception)
                {
                    return(false);
                }
            }
        }
Пример #3
0
        public Caso InformacionCaso(int iIdCaso)
        {
            using (SqlConnection _SqlConnection = new SqlConnection(ConnectionString.DbMPY))
            {
                Caso       caso        = null;
                SqlCommand _SqlCommand = new SqlCommand("LXCCSPS_CASO_ABIERTO_INFO", _SqlConnection)
                {
                    CommandType = CommandType.StoredProcedure
                };
                _SqlCommand.Parameters.AddWithValue("@IdCaso", iIdCaso);

                try
                {
                    _SqlConnection.Open();
                    SqlDataReader _SqlDataReader = _SqlCommand.ExecuteReader();
                    if (_SqlDataReader.HasRows)
                    {
                        while (_SqlDataReader.Read())
                        {
                            caso = new Caso()
                            {
                                iIdCaso            = int.Parse(_SqlDataReader["IdCaso"].ToString()),
                                sDescripcion       = _SqlDataReader["Descripcion"].ToString(),
                                dtFechaCreacion    = DateTime.Parse(_SqlDataReader["FechaCreacion"].ToString()),
                                iIdUsuarioCreacion = int.Parse(_SqlDataReader["IdUsuarioCreacion"].ToString()),
                                sContadorNombre    = _SqlDataReader["Nombre"].ToString(),
                                sContadorAPaterno  = _SqlDataReader["APaterno"].ToString(),
                                sContadorAMaterno  = _SqlDataReader["AMaterno"].ToString(),
                                sMotivo            = _SqlDataReader["Motivo"].ToString(),
                                bActivo            = bool.Parse(_SqlDataReader["Estado"].ToString()),
                                sCliente           = _SqlDataReader["Cliente"].ToString(),
                                sNombre            = _SqlDataReader["CNombre"].ToString(),
                                sAPaterno          = _SqlDataReader["CAPaterno"].ToString(),
                                sAMaterno          = _SqlDataReader["CAMaterno"].ToString(),
                                sFechaCierre       = _SqlDataReader["FechaCierre"].ToString()
                            };
                        }
                    }
                }
                catch (Exception)
                {
                    caso = null;
                }
                return(caso);
            }
        }
Пример #4
0
        public List <Caso> LAbiertos(int iIdCliente)
        {
            using (SqlConnection _SqlConnection = new SqlConnection(ConnectionString.DbMPY))
            {
                List <Caso> list        = new List <Caso>();
                SqlCommand  _SqlCommand = new SqlCommand("LXCCSPS_CASO_ABIERTOS", _SqlConnection)
                {
                    CommandType = CommandType.StoredProcedure
                };
                _SqlCommand.Parameters.Add("@IdCliente", SqlDbType.BigInt).Value = iIdCliente;

                try
                {
                    _SqlConnection.Open();
                    SqlDataReader _sqlDataReader = _SqlCommand.ExecuteReader();
                    if (_sqlDataReader.HasRows)
                    {
                        while (_sqlDataReader.Read())
                        {
                            Caso cCaso = new Caso()
                            {
                                iIdCaso      = int.Parse(_sqlDataReader["IdCaso"].ToString()),
                                sMotivo      = _sqlDataReader["Motivo"].ToString(),
                                sDescripcion = _sqlDataReader["Descripcion"].ToString()
                            };
                            list.Add(cCaso);
                        }
                    }
                }
                catch (Exception)
                {
                    list = null;
                }
                return(list);
            }
        }
Пример #5
0
        public List <Caso> LTodosBusqueda(string sCliente)
        {
            using (SqlConnection _SqlConnection = new SqlConnection(ConnectionString.DbMPY))
            {
                List <Caso> list        = new List <Caso>();
                SqlCommand  _SqlCommand = new SqlCommand("LXCCSPS_CASO_TODOS_CL", _SqlConnection)
                {
                    CommandType = CommandType.StoredProcedure
                };
                _SqlCommand.Parameters.AddWithValue("@Cliente", sCliente);

                try
                {
                    _SqlConnection.Open();
                    SqlDataReader _sqlDataReader = _SqlCommand.ExecuteReader();
                    if (_sqlDataReader.HasRows)
                    {
                        while (_sqlDataReader.Read())
                        {
                            Caso cCaso = new Caso()
                            {
                                iIdCaso  = int.Parse(_sqlDataReader["IdCaso"].ToString()),
                                bActivo  = bool.Parse(_sqlDataReader["Estado"].ToString()),
                                sCliente = _sqlDataReader["Cliente"].ToString()
                            };
                            list.Add(cCaso);
                        }
                    }
                }
                catch (Exception)
                {
                    list = null;
                }
                return(list);
            }
        }