示例#1
0
        public List <UserInfo> GetTopExp()
        {
            var           rs        = new List <UserInfo>();
            var           sql       = "SELECT top 100 * FROM [portal].[dbo].view_user_info ORDER BY EXP DESC";
            SqlConnection conn      = new SqlConnection(Constants.DBConnection);
            SqlCommand    MyCommand = new SqlCommand(sql, conn);
            SqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                var u = new UserInfo
                {
                    uid      = MyReader.GetInt64(MyReader.GetOrdinal("id")),
                    userName = MyReader.GetString(MyReader.GetOrdinal("username")),
                    fullName = MyReader.GetString(MyReader.GetOrdinal("fullname")),
                    cashWin  = MyReader.GetInt64(MyReader.GetOrdinal("EXP"))
                };
                rs.Add(u);
            }
            MyReader.Close();
            conn.Close();
            return(rs);
        }
示例#2
0
        /// <summary>
        /// Danh sách top user thắng nhiều (top) theo từng Game Id
        /// </summary>
        /// <param name="zoneId"></param>
        /// <param name="top"></param>
        /// <returns></returns>
        public List <UserInfo> GetTopUserByZoneID(int zoneId, int top)
        {
            var rs  = new List <UserInfo>();
            var sql = "select b.id,b.username, b.fullname,sum(a.cash) as total_cash_win from newDB.game_history a inner join newDB.view_user_info b on a.user_id = b.id where a.cash > 0 AND (trans_type=1 or trans_type=18) AND game_id = @zoneId" +
                      " group by a.user_id order by total_cash_win desc" +
                      " limit 0, @top";
            MySqlConnection conn      = new MySqlConnection(Constants.DBConnection);
            MySqlCommand    MyCommand = new MySqlCommand(sql, conn);

            MyCommand.Parameters.AddWithValue("zoneId", zoneId);
            MyCommand.Parameters.AddWithValue("top", top);
            MySqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                UserInfo u = new UserInfo();
                u.uid      = MyReader.GetInt64("id");
                u.userName = MyReader.GetString("username");
                u.fullName = MyReader.GetString("fullname");
                u.cashWin  = MyReader.GetInt64("total_cash_win");
                rs.Add(u);
            }
            MyReader.Close();
            conn.Close();
            return(rs);
        }
示例#3
0
        /// <summary>
        /// Báo cáo Danh sách user nạp nhiều tiền nhất (theo tổng số tiền Su đã nạp)
        /// </summary>
        /// <param name="from"></param>
        /// <param name="to"></param>
        /// <param name="top"></param>
        /// <returns></returns>
        public List <ReportUserChargeMoneyItem> ReportUserChargedMost(DateTime from, DateTime to, int top)
        {
            var             rs        = new List <ReportUserChargeMoneyItem>();
            string          sql       = String.Format("SELECT h.user_id, u.username, u.fullname, u.ip, u.gameCash, u.vCash, SUM(h.cash) AS 'SuNap' FROM newDB.game_history h INNER JOIN newDB.view_user_info u ON h.user_id = u.id WHERE h.trans_type = 4 and h.time > '{0}' and h.time < '{1}' group by h.user_id, u.username, u.fullname order by SUM(h.cash) desc limit 0, {2}", from.ToString("yyyy-MM-dd HH:mm:ss"), to.ToString("yyyy-MM-dd HH:mm:ss"), top);
            MySqlConnection conn      = new MySqlConnection(Constants.DBConnection);
            MySqlCommand    MyCommand = new MySqlCommand(sql, conn);
            MySqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                ReportUserChargeMoneyItem item1 = new ReportUserChargeMoneyItem();
                item1.user_id  = MyReader.GetInt32("user_id");
                item1.username = MyReader.GetString("username");
                item1.fullname = MyReader.GetString("fullname");
                item1.ip       = MyReader.GetString("ip");
                item1.gameCash = MyReader.GetInt64("gameCash");
                item1.vCash    = MyReader.GetInt64("vCash");
                if (String.IsNullOrEmpty(item1.fullname))
                {
                    item1.fullname = item1.username;
                }
                item1.moenyCharged = MyReader.GetInt64("SuNap");
                rs.Add(item1);
            }
            MyReader.Close();
            conn.Close();
            return(rs);
        }
示例#4
0
        public List <GameGuideItem> GameGuideGetAll()
        {
            var           lst       = new List <GameGuideItem>();
            string        sql       = "SELECT gui.*, ga.Name FROM [portal].[dbo].gameGuide gui LEFT JOIN [portal].[dbo].game ga ON ga.ID = gui.game_id ORDER BY gui.id DESC";
            SqlConnection conn      = new SqlConnection(Constants.DBConnection);
            SqlCommand    MyCommand = new SqlCommand(sql, conn);
            SqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                var item = new GameGuideItem
                {
                    id          = MyReader.GetInt32(MyReader.GetOrdinal("id")),
                    game        = MyReader.GetString(MyReader.GetOrdinal("Name")),
                    description = MyReader.GetString(MyReader.GetOrdinal("description")),
                    game_id     = MyReader.GetInt32(MyReader.GetOrdinal("game_id")),
                };

                lst.Add(item);
            }
            MyReader.Close();
            conn.Close();
            return(lst);
        }
示例#5
0
        /*update 24/03*/

        public List <GameTextItem> GetAll()
        {
            var           lst       = new List <GameTextItem>();
            string        sql       = "SELECT * FROM [portal].[dbo].chuchaychay ORDER BY id DESC";
            SqlConnection conn      = new SqlConnection(Constants.DBConnection);
            SqlCommand    MyCommand = new SqlCommand(sql, conn);
            SqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                var item = new GameTextItem
                {
                    ID              = MyReader.GetInt32(MyReader.GetOrdinal("id")),
                    Title           = MyReader.GetString(MyReader.GetOrdinal("Title")),
                    Link            = MyReader.GetString(MyReader.GetOrdinal("Link")),
                    DataStart       = MyReader.GetDateTime(MyReader.GetOrdinal("DataStart")),
                    DateEnd         = MyReader.GetDateTime(MyReader.GetOrdinal("DateEnd")),
                    IsDelete        = MyReader.GetBoolean(MyReader.GetOrdinal("IsDelete")),
                    Order           = MyReader.GetInt32(MyReader.GetOrdinal("Orders")),
                    DataStartstring = MyReader.GetDateTime(MyReader.GetOrdinal("DataStart")).ToShortDateString(),
                    DateEndstring   = MyReader.GetDateTime(MyReader.GetOrdinal("DateEnd")).ToShortDateString()
                };

                lst.Add(item);
            }
            MyReader.Close();
            conn.Close();
            return(lst);
        }
        //**************recuperation du nom et prenom de la table Perso dans le form Accident**************//
        private void btnRecVict_Click(object sender, EventArgs e)
        {
            string        sqlreq = "select Perso_Nom,Perso_Prenom  From Perso INNER JOIN Accident ON Perso.Perso_Matricule = Accident.IdAccident where Perso.Perso_Matricule=" + Convert.ToInt32(textBoxMatr.Text) + "";
            SqlDataReader MyReader;
            SqlCommand    cmd = new SqlCommand(sqlreq, chaineConn.Cnx);

            chaineConn.Cnx.Open();
            try
            {
                MyReader = cmd.ExecuteReader();
                if (MyReader.HasRows)
                {
                    while (MyReader.Read())
                    {
                        string nom    = MyReader.GetString(0);
                        string prenom = MyReader.GetString(1);
                        textBoxNom.Text    = nom;
                        textBoxPrenom.Text = prenom;
                    }
                }
                MyReader.Close();
            }
            catch (Exception exception)
            {
                Console.WriteLine(exception);
            }

            chaineConn.Cnx.Close();
        }
示例#7
0
        void folio_pedido() // Método para mostrar el folio siguiente al último registrado en la base de datos
        {
            int             folio     = 0;
            MySqlConnection conexion  = Conectar();
            String          sentencia = "SELECT IDpedido FROM pedido ORDER BY IDpedido DESC LIMIT 1";
            MySqlCommand    comando   = new MySqlCommand(sentencia, conexion);

            conexion.Open();
            comando.ExecuteNonQuery();
            MySqlDataReader MyReader;

            MyReader = comando.ExecuteReader();
            while (MyReader.Read())
            {
                folio = (MyReader.GetInt16("IDpedido"));
                folio = folio + 1;
            }
            if (folio == 0)
            {
                folio = 1;
            }
            MyReader.Close();
            conexion.Close();
            var folio_padded = folio.ToString().PadLeft(4, '0');

            textBox_idPedido.Text = folio_padded;
        }
示例#8
0
        public JsonResult Put(EmployeeData data)
        {
            string        query         = @"
                     update dbo.Employee set 
                     QuickLookId = '" + data.QuickLookId + @"',
                     FirstName = '" + data.FirstName + @"',
                     LastName = '" + data.LastName + @"',
                     PhoneNumber = '" + data.PhoneNumber + @"',
                     Address = '" + data.Address + @"',
                     City = '" + data.City + @"',
                     State = '" + data.State + @"',
                     Country = '" + data.Country + @"',
                     ImageURL = '" + data.ImageURL + @"'
                     where EmployeeID = " + data.EmployeeID + @" 
                     ";
            DataTable     table         = new DataTable();
            string        sqlConnection = _configuration.GetConnectionString("EmployeeAppCon");
            SqlDataReader MyReader;

            using (SqlConnection myConnection = new SqlConnection(sqlConnection))
            {
                myConnection.Open();
                using (SqlCommand myCommand = new SqlCommand(query, myConnection))
                {
                    MyReader = myCommand.ExecuteReader();
                    table.Load(MyReader);;

                    MyReader.Close();
                    myConnection.Close();
                }
            }

            return(new JsonResult("Updated Sucessfully"));
        }
示例#9
0
        public List <Paciente> Filtar(string nome)
        {
            try
            {
                using (MyConnection = new MySqlConnection(ConnectionString))
                {
                    MyConnection.Open();

                    using (MyCommand = new MySqlCommand("SELECT * FROM pacientes WHERE nome LIKE '" + nome + "%'", MyConnection))
                    {
                        using (MyReader = MyCommand.ExecuteReader())
                        {
                            List <Paciente> pacientes = new List <Paciente>();

                            while (MyReader.Read())
                            {
                                pacientes.Add(new Content().Get(MyReader));
                            }

                            return(pacientes);
                        }
                    }
                }
            }
            finally
            {
                MyReader.Close();
                MyCommand.Dispose();
                MyConnection.Close();
            }
        }
示例#10
0
        public AnnouncementItem GetOne(int ID)
        {
            var           item      = new AnnouncementItem();
            string        sql       = "SELECT * FROM [newDB].[dbo].[event] WHERE id = @id";
            SqlConnection conn      = new SqlConnection(Constants.DBConnection);
            SqlCommand    MyCommand = new SqlCommand(sql, conn);

            MyCommand.Parameters.AddWithValue("id", ID);
            SqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                item.ID               = MyReader.GetInt32(MyReader.GetOrdinal("id"));
                item.begin_time       = MyReader.GetDateTime(MyReader.GetOrdinal("DateStart"));
                item.end_time         = MyReader.GetDateTime(MyReader.GetOrdinal("DateEnd"));
                item.Subject          = MyReader.GetString(MyReader.GetOrdinal("name"));
                item.UrlImage         = MyReader.GetString(MyReader.GetOrdinal("UrlImage"));
                item.Content          = MyReader.GetString(MyReader.GetOrdinal("content"));
                item.DoiTuong         = MyReader.GetString(MyReader.GetOrdinal("DoiTuong"));
                item.ThoiGian         = MyReader.GetString(MyReader.GetOrdinal("ThoiGian"));
                item.GameID           = MyReader.GetInt32(MyReader.GetOrdinal("GameID"));
                item.DisplayOrder     = MyReader.GetInt32(MyReader.GetOrdinal("DisplayOrder"));
                item.begin_timestring = item.begin_time.ToString(Constants.DateFormat);
                item.end_timestring   = item.end_time.ToString(Constants.DateFormat);
            }
            MyReader.Close();
            conn.Close();
            return(item);
        }
示例#11
0
        public JsonResult Delete(int Id)
        {
            string        query         = @"
                    delete from dbo.Employee
                    where EmployeeID = " + Id + @" 
                    ";
            DataTable     table         = new DataTable();
            string        sqlConnection = _configuration.GetConnectionString("EmployeeAppCon");
            SqlDataReader MyReader;

            using (SqlConnection myConnection = new SqlConnection(sqlConnection))
            {
                myConnection.Open();
                using (SqlCommand myCommand = new SqlCommand(query, myConnection))
                {
                    MyReader = myCommand.ExecuteReader();
                    table.Load(MyReader);;

                    MyReader.Close();
                    myConnection.Close();
                }
            }

            return(new JsonResult("Delete Sucessfully"));
        }
示例#12
0
        public List <AnnouncementItem> GetAll(int currentRecord = 0, int numberRecord = 10)
        {
            var           lst       = new List <AnnouncementItem>();
            string        sql       = "SELECT * FROM [newDB].[dbo].[event] where [IsDelete] = 0 order by id desc OFFSET " + currentRecord + " ROWS FETCH NEXT " + numberRecord + "ROWS ONLY ";
            SqlConnection conn      = new SqlConnection(Constants.DBConnection);
            SqlCommand    MyCommand = new SqlCommand(sql, conn);
            SqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                var item = new AnnouncementItem
                {
                    ID           = MyReader.GetInt32(MyReader.GetOrdinal("id")),
                    DisplayOrder = MyReader.GetInt32(MyReader.GetOrdinal("DisplayOrder")),
                    begin_time   = MyReader.GetDateTime(MyReader.GetOrdinal("DateStart")),
                    end_time     = MyReader.GetDateTime(MyReader.GetOrdinal("DateEnd")),
                    Subject      = MyReader.GetString(MyReader.GetOrdinal("name")),
                    Content      = MyReader.GetString(MyReader.GetOrdinal("content")),
                };
                lst.Add(item);
            }
            MyReader.Close();
            conn.Close();
            return(lst);
        }
        private void button_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                string          Query     = "insert into hopedatabase.patient_data (`patient_name`, `patient_age`, `patient_contact_no`, `patient_address`, `time_of_admission`, `patient_sex`, `patient_occupation`) values('" + patient_name.Text + "','" + patient_age.Text + "','" + patient_contact_no2.Text + "','" + patient_address.Text + "','" + datepicker.Text + "','" + comboboxPatient_sex.SelectedItem.ToString() + "','" + patient_occupation.Text + "');";
                MySqlCommand    MyCommand = new MySqlCommand(Query, connn);
                MySqlDataReader MyReader;
                MyReader = MyCommand.ExecuteReader();
                MyReader.Close();

                MessageBox.Show("Patient Registered");
                string          Query1     = "insert into hopedatabase.patient_data ( `patient_blood_group` ) values('" + comboboxBloodGroup.SelectedItem.ToString() + "');";
                MySqlCommand    MyCommand1 = new MySqlCommand(Query1, connn);
                MySqlDataReader MyReader1;
                MyReader1 = MyCommand1.ExecuteReader();
                MyReader1.Close();

                patient_name.Text       = ""; patient_address.Text = ""; patient_age.Text = ""; patient_contact_no2.Text = ""; referred_by.Text = ""; datepicker.Text = "";
                patient_occupation.Text = "";
                comboboxBloodGroup.Items.Clear(); comboboxPatient_sex.Items.Clear();

                load_blood_group();

                load();
                patient_name.IsEnabled       = false; patient_address.IsEnabled = false; patient_age.IsEnabled = false; referred_by.IsEnabled = false;
                comboboxBloodGroup.IsEnabled = false;
            }
            catch
            {
            }
            //catch (Exception ex)
            //{
            //    MessageBox.Show(ex.Message);
            //}
        }
示例#14
0
        public List <UserInfo> GetTopNapTien()
        {
            var           rs        = new List <UserInfo>();
            var           sql       = "SELECT b.id, b.fullname, b.username, ABS(SUM(a.cash)) AS cashWin FROM [portal].[dbo].game_history a INNER JOIN [portal].[dbo].view_user_info b ON a.user_id = b.id WHERE trans_type = 4 AND a.cash > 0 GROUP BY b.id, b.fullname, b.username ORDER BY ABS(SUM(a.cash)) DESC";
            SqlConnection conn      = new SqlConnection(Constants.DBConnection);
            SqlCommand    MyCommand = new SqlCommand(sql, conn);
            SqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                var u = new UserInfo
                {
                    uid      = MyReader.GetInt64(MyReader.GetOrdinal("id")),
                    userName = MyReader.GetString(MyReader.GetOrdinal("username")),
                    fullName = MyReader.GetString(MyReader.GetOrdinal("fullname")),
                    cashWin  = MyReader.GetInt64(MyReader.GetOrdinal("cashWin"))
                };
                rs.Add(u);
            }
            MyReader.Close();
            conn.Close();
            return(rs);
        }
示例#15
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="TextQuery"></param>
        /// <param name="result"></param>
        /// <returns></returns>
        public bool ExecuteWithRead(string TextQuery, out DataTable result)
        {
            result = new DataTable();
            if (!ExecuteQuery(QueryParser(TextQuery)))
            {
                return(false);
            }
            for (int i = 0; i < MyReader.FieldCount; i++)
            {
                result.Columns.Add(MyReader.GetName(i), MyReader.GetFieldType(i));
            }

            while (MyReader.Read())
            {
                DataRow dr = result.NewRow();
                for (int col = 0; col < MyReader.FieldCount; col++)
                {
                    dr[col] = MyReader.GetValue(col);
                }
                result.Rows.Add(dr);
            }
            MyReader.Close();

            return(true);
        }
示例#16
0
        public bool PacienteInternado(int paciente)
        {
            try
            {
                using (MyConnection = new MySqlConnection(ConnectionString))
                {
                    MyConnection.Open();

                    using (MyCommand = new MySqlCommand("SELECT * FROM internacoes WHERE paciente=@paciente AND data_saida='" +
                                                        DateTime.MinValue.ToString("yyyy-MM-dd") + "'", MyConnection))
                    {
                        MyCommand.Parameters.AddWithValue("@paciente", paciente);

                        using (MyReader = MyCommand.ExecuteReader())
                        {
                            List <Internacao> internacoes = new List <Internacao>();

                            while (MyReader.Read())
                            {
                                internacoes.Add(new Content().Get(MyReader));
                            }

                            return(internacoes.Count > 0);
                        }
                    }
                }
            }
            finally
            {
                MyReader.Close();
                MyCommand.Dispose();
                MyConnection.Close();
            }
        }
示例#17
0
 /// <summary>
 /// возвращает список данных элемента справочника по его IDD или же ID (регулируется параметром ThisID)
 /// </summary>
 /// <param name="IDDorID"></param>
 /// <param name="SCType"></param>
 /// <param name="FieldList"></param>
 /// <param name="DataMap"></param>
 /// <param name="ThisID"></param>
 /// <returns></returns>
 public bool GetSCData(string IDDorID, string SCType, List <string> FieldList, out Dictionary <string, object> DataMap, bool ThisID)
 {
     SCType  = "Спр." + SCType;
     DataMap = new Dictionary <string, object>();
     if (!ExecuteQuery("SELECT " + ToFieldString(FieldList) + " FROM " + GetSynh(SCType) + " (nolock)" +
                       " WHERE " + (ThisID ? "ID" : GetSynh(SCType + ".IDD")) + "='" + IDDorID + "'"))
     {
         return(false);
     }
     if (MyReader.Read())
     {
         for (int i = 0; i < MyReader.FieldCount; i++)
         {
             DataMap[FieldList[i]] = MyReader[i];
         }
         MyReader.Close();
         return(true);
     }
     else
     {
         MyReader.Close();
         FExcStr = "Элемент справочника не найден!";
         return(false);
     }
 }
示例#18
0
        public List <Internacao> Listar(int paciente)
        {
            try
            {
                using (MyConnection = new MySqlConnection(ConnectionString))
                {
                    MyConnection.Open();

                    using (MyCommand = new MySqlCommand("SELECT * FROM internacoes WHERE paciente=@paciente ORDER BY id DESC", MyConnection))
                    {
                        MyCommand.Parameters.AddWithValue("@paciente", paciente);

                        using (MyReader = MyCommand.ExecuteReader())
                        {
                            List <Internacao> internacoes = new List <Internacao>();

                            while (MyReader.Read())
                            {
                                internacoes.Add(new Content().Get(MyReader));
                            }

                            return(internacoes);
                        }
                    }
                }
            }
            finally
            {
                MyReader.Close();
                MyCommand.Dispose();
                MyConnection.Close();
            }
        }
示例#19
0
        //PESTAÑA "NUEVO", OPCION PARA AGREGAR NUEVOS PEDIDOS

        private void agregarPedido_btn_Click_1(object sender, EventArgs e) // Hacer click en "Nuevo", hacer visible la tab pedidos y cargar los clientes existentes
        {
            DateTime today = DateTime.Today;

            tab_pedidos.Visible = true;
            tab_pedidos.SelectTab(0);
            comboBox_producto1.SelectedIndex = -1;
            textBox_cliente.Clear();
            textBox_cantidad1.Clear();
            cargar_productos();
            folio_pedido();

            MySqlConnection conexion  = Conectar();
            String          sentencia = "SELECT nombre FROM clientes";
            MySqlCommand    comando   = new MySqlCommand(sentencia, conexion);

            conexion.Open();
            comando.ExecuteNonQuery();
            MySqlDataReader MyReader;

            MyReader = comando.ExecuteReader();
            while (MyReader.Read())
            {
                autotext_clientes.Add(MyReader.GetString(0));
            }

            textBox_cliente.AutoCompleteMode         = AutoCompleteMode.SuggestAppend;
            textBox_cliente.AutoCompleteSource       = AutoCompleteSource.CustomSource;
            textBox_cliente.AutoCompleteCustomSource = autotext_clientes;

            MyReader.Close();
            conexion.Close();
        }
示例#20
0
        public Internacao Buscar(string[] colunas, string[] valores)
        {
            try
            {
                using (MyConnection = new MySqlConnection(ConnectionString))
                {
                    MyConnection.Open();

                    using (MyCommand = new MySqlCommand(RawSelect("internacoes", colunas, valores), MyConnection))
                    {
                        using (MyReader = MyCommand.ExecuteReader())
                        {
                            if (MyReader.Read())
                            {
                                return(new Content().Get(MyReader));
                            }
                            else
                            {
                                return(null);
                            }
                        }
                    }
                }
            }
            finally
            {
                MyConnection.Close();
                MyCommand.Dispose();
                MyReader.Close();
            }
        }
示例#21
0
        // ***************************************************** PESTAÑA MODIFICAR PEDIDO *******************************************************************
        private void pestañaModificarPedido_Btn_Click(object sender, EventArgs e)
        {
            tab_pedidos.Visible = true;
            tab_pedidos.SelectTab(1);
            textBox_buscarFolio.Clear();
            cargar_productos();

            MySqlConnection conexion  = Conectar();
            String          sentencia = "SELECT nombre FROM clientes";
            MySqlCommand    comando   = new MySqlCommand(sentencia, conexion);

            conexion.Open();
            comando.ExecuteNonQuery();
            MySqlDataReader MyReader;

            MyReader = comando.ExecuteReader();
            while (MyReader.Read())
            {
                autotext_clientes.Add(MyReader.GetString(0));
            }

            textBox_clienteEncontrado.AutoCompleteMode         = AutoCompleteMode.SuggestAppend;
            textBox_clienteEncontrado.AutoCompleteSource       = AutoCompleteSource.CustomSource;
            textBox_clienteEncontrado.AutoCompleteCustomSource = autotext_clientes;

            MyReader.Close();
            conexion.Close();
        }
示例#22
0
        /// <summary>
        /// Borrar una Oferta
        /// </summary>
        /// <returns></returns>
        public bool BorrarOferta(Oferta unaOferta)
        {
            bool   borrado = false;
            string sql     = "delete from oferta where id=" + unaOferta.Id + ";";

            MySqlCommand comandoInsert = new MySqlCommand(sql, conexion);

            MySqlDataReader MyReader;

            try
            {
                MyReader = comandoInsert.ExecuteReader();  // Here our query will be executed and data saved into the database.
                while (MyReader.Read())
                {
                }
                MyReader.Close();
                borrado = true;
            }
            catch (MySqlException ex)
            {
                switch (ex.Number)
                {
                case 1452: throw new Exception("No se puede borrar, no existe este idEmpresa en Empresa");

                default:
                    throw;
                }
            }

            return(borrado);
        }
示例#23
0
        public GameGuideItem GameGuideGetOne(int id)
        {
            var           item      = new GameGuideItem();
            string        sql       = "SELECT * FROM [portal].[dbo].gameGuide WHERE id = @id";
            SqlConnection conn      = new SqlConnection(Constants.DBConnection);
            SqlCommand    MyCommand = new SqlCommand(sql, conn);

            MyCommand.Parameters.AddWithValue("id", id);
            SqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                item = new GameGuideItem
                {
                    id          = MyReader.GetInt32(MyReader.GetOrdinal("id")),
                    description = MyReader.GetString(MyReader.GetOrdinal("description")),
                    game_id     = MyReader.GetInt32(MyReader.GetOrdinal("game_id")),
                };
            }
            MyReader.Close();
            conn.Close();
            return(item);
        }
示例#24
0
        private void comboboxDoctorName_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            ///////Loading Doctor Department Value
            try
            {
                string          Query      = "select id,department from doctor where name='" + comboboxDoctorName.SelectedItem.ToString() + "';";
                MySqlCommand    MyCommand2 = new MySqlCommand(Query, conn);
                MySqlDataReader MyReader2;
                MyReader2 = MyCommand2.ExecuteReader();

                while (MyReader2.Read())
                {
                    docId   = MyReader2.GetString(0);
                    docDept = MyReader2.GetString(1);
                    textboxDoctorDept.Text = docDept;
                }
                MyReader2.Close();

                string          Query1    = "select department from doctor where name='" + comboboxDoctorName.SelectedItem.ToString() + "';";
                MySqlCommand    MyCommand = new MySqlCommand(Query, conn);
                MySqlDataReader MyReader;
                MyReader = MyCommand.ExecuteReader();
                MyReader.Close();
                assd.IsEnabled = true;
            }
            catch { }
        }
示例#25
0
        public GameTextItem GetOne(int ID)
        {
            var           item      = new GameTextItem();
            string        sql       = "SELECT * FROM [portal].[dbo].chuchaychay WHERE id = @id";
            SqlConnection conn      = new SqlConnection(Constants.DBConnection);
            SqlCommand    MyCommand = new SqlCommand(sql, conn);

            MyCommand.Parameters.AddWithValue("id", ID);
            SqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                item = new GameTextItem
                {
                    ID        = MyReader.GetInt32(MyReader.GetOrdinal("id")),
                    Title     = MyReader.GetString(MyReader.GetOrdinal("Title")),
                    Link      = MyReader.GetString(MyReader.GetOrdinal("Link")),
                    DataStart = MyReader.GetDateTime(MyReader.GetOrdinal("DataStart")),
                    DateEnd   = MyReader.GetDateTime(MyReader.GetOrdinal("DateEnd")),
                    IsDelete  = MyReader.GetBoolean(MyReader.GetOrdinal("IsDelete")),
                    Order     = MyReader.GetInt32(MyReader.GetOrdinal("Orders")),
                };
            }
            MyReader.Close();
            conn.Close();
            return(item);
        }
示例#26
0
        public List <ConfigMiniPokerItem> GetConfigXeng()
        {
            var rs  = new List <ConfigMiniPokerItem>();
            var sql = "SELECT top 1 * FROM [newDB].[dbo].configQuayXeng ORDER BY id DESC";

            var           conn      = new SqlConnection(Constants.DBConnection);
            var           MyCommand = new SqlCommand(sql, conn);
            SqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                var u = new ConfigMiniPokerItem
                {
                    Id = MyReader.GetInt32(MyReader.GetOrdinal("id")),
                    a  = MyReader.GetInt32(MyReader.GetOrdinal("a")),
                    a1 = MyReader.GetInt32(MyReader.GetOrdinal("a1")),
                    a2 = MyReader.GetInt32(MyReader.GetOrdinal("a2")),
                    a3 = MyReader.GetInt32(MyReader.GetOrdinal("a3")),
                    a4 = MyReader.GetInt32(MyReader.GetOrdinal("a4")),
                    a5 = MyReader.GetInt32(MyReader.GetOrdinal("a5")),
                    a6 = MyReader.GetInt32(MyReader.GetOrdinal("a6"))
                };
                rs.Add(u);
            }
            MyReader.Close();

            conn.Close();
            return(rs);
        }
 private void comboboxpatient_name_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     try
     {
         clear_data();
         string          sql       = "SELECT patient_contact_no,patient_age,patient_blood_group,patient_address,time_of_admission,patient_sex,referred_by,patient_occupation,patient_id from hopedatabase.patient_data where patient_name='" + comboboxpatient_name.SelectedItem + "';";
         MySqlCommand    MyCommand = new MySqlCommand(sql, conn);
         MySqlDataReader MyReader;
         MyReader = MyCommand.ExecuteReader();
         while (MyReader.Read())
         {
             patient_contact_no.Text = MyReader.GetString(0).ToString();
             patient_age.Text        = MyReader.GetString(1).ToString();
             patient_bloodgroup.Text = MyReader.GetString(2).ToString();
             patient_address.Text    = MyReader.GetString(3).ToString();
             time_of_admission.Text  = MyReader.GetString(4).ToString();
             patient_sex.Text        = MyReader.GetString(5).ToString();
             referred_by.Text        = MyReader.GetString(6).ToString();
             patient_occupation.Text = MyReader.GetString(7).ToString();
             selected_id             = MyReader.GetString(8).ToString();
         }
         MyReader.Close();
     }
     catch (Exception eee)
     {
         MessageBox.Show(eee.Message.ToString());
     }
 }
示例#28
0
        public ConfigMiniPokerItem GetConfigXengDetail(int id)
        {
            var rs  = new ConfigMiniPokerItem();
            var sql = "SELECT * FROM [newDB].[dbo].configQuayXeng where id = " + id;

            var           conn      = new SqlConnection(Constants.DBConnection);
            var           MyCommand = new SqlCommand(sql, conn);
            SqlDataReader MyReader;

            conn.Open();
            MyReader = MyCommand.ExecuteReader();
            while (MyReader.Read())
            {
                rs = new ConfigMiniPokerItem
                {
                    Id = MyReader.GetInt32(MyReader.GetOrdinal("id")),
                    a  = MyReader.GetInt32(MyReader.GetOrdinal("a")),
                    a1 = MyReader.GetInt32(MyReader.GetOrdinal("a1")),
                    a2 = MyReader.GetInt32(MyReader.GetOrdinal("a2")),
                    a3 = MyReader.GetInt32(MyReader.GetOrdinal("a3")),
                    a4 = MyReader.GetInt32(MyReader.GetOrdinal("a4")),
                    a5 = MyReader.GetInt32(MyReader.GetOrdinal("a5")),
                    a6 = MyReader.GetInt32(MyReader.GetOrdinal("a6"))
                };
            }
            MyReader.Close();

            conn.Close();
            return(rs);
        }
        public bool SelectById()
        {
            Command = MyCommand(@"Select Id,Name,Email,FatherName,MotherName,
                                    LocalGuardian,IdNumber,BloodGroup,AddressPresent,
                                    AddressPermanent,CityId,ProgramId 
                                    from Student WHERE Id = @Id");

            Command.Parameters.AddWithValue("@Id", Id);

            MyReader = ExecuteReader(Command);

            while (MyReader.Read())
            {
                Name             = MyReader["name"].ToString();
                Email            = MyReader["email"].ToString();
                FatherName       = MyReader["FatherName"].ToString();
                MotherName       = MyReader["MotherName"].ToString();
                LocalGuardian    = MyReader["dateOfBirth"].ToString();
                IdNumber         = MyReader["IdNumber"].ToString();
                BloodGroup       = MyReader["BloodGroup"].ToString();
                AddressPresent   = MyReader["AddressPresent"].ToString();
                AddressPermanent = MyReader["AddressPermanent"].ToString();
                Image            = (byte[])MyReader["Image"];
                CityId           = Convert.ToInt32(MyReader["cityId"]);
                ProgramId        = Convert.ToInt32(MyReader["ProgramId"]);

                return(true);
            }
            MyReader.Close();
            return(false);
        }
示例#30
0
 private void btnAddTest_Click(object sender, RoutedEventArgs e)
 {
     if (txtTestName.Text.Equals("") || comboDiseaseType.Text.Equals("") || comboDiseaseName.Text.Equals("") || comboDiseaseName.Text.Equals("") || txtCost.Text.Equals(""))
     {
         MessageBox.Show("Please Fill All Fields");
     }
     else
     {
         try
         {
             string          Query     = "insert into user.test_name values('" + txtTestName.Text + "','" + comboDiseaseType.SelectedItem.ToString() + "','" + comboDiseaseName.SelectedItem.ToString() + "','" + txtCost.Text + "');";
             MySqlCommand    MyCommand = new MySqlCommand(Query, conn);
             MySqlDataReader MyReader;
             MyReader = MyCommand.ExecuteReader();
             MyReader.Close();
             MessageBox.Show("Test Added");
             txtTestName.Text = "";
             txtCost.Text     = "";
             table();
             txtCost.Text     = "";
             txtTestName.Text = "";
             comboDiseaseName.Items.Clear();
             comboDiseaseType.Items.Clear();
             load_combo_disease_typee();
         }
         catch { }
     }
 }