Example #1
0
        protected void LoginButton_Click(object sender, EventArgs e)
        {
            String connString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString();

            using (conn = new MySql.Data.MySqlClient.MySqlConnection(connString))
            {
                conn.Open();
                queryStr = "";
                queryStr = "SELECT * FROM db_9f3dca_webapp.user_registration WHERE username='******' AND password='******' ";
                cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);

                reader = cmd.ExecuteReader();

                name = "";
                while (reader.HasRows && reader.Read())
                {
                    name = reader.GetString(reader.GetOrdinal("username"));
                }

                if (reader.HasRows)
                {
                    Session["uname"] = name;
                    Response.BufferOutput = true;
                    Response.Redirect("loggedIn.aspx", false);
                }
                else
                {
                    LoginError.Text = "Invalid username password combination!";
                }
                reader.Close();

                conn.Close();
            }
        }      
Example #2
0
 internal Asset(MySql.Data.MySqlClient.MySqlDataReader dr)
 {
     Fill(dr);
 }
Example #3
0
        public DataSet GetStockReport(bool allPart, string partStart, string partEnd, bool allGroup,
                                      string groupStart, string groupEnd, DateTime asOfDate)
        {
            DataSet ds = new DataSet();

            m_cmd.CommandText = "delete from table_temp";
            m_cmd.ExecuteNonQuery();

            m_cmd.CommandText = Part.GetStockReport(allPart, partStart, partEnd, allGroup, groupStart, groupEnd);
            MySql.Data.MySqlClient.MySqlDataReader rdr = m_cmd.ExecuteReader();
            IList result = Part.GetAllStaticForReport(rdr);

            rdr.Close();
            //IList stockcards = new ArrayList();
            foreach (Part p in result)
            {
                p.UNIT       = PartRepository.GetUnitByID(m_cmd, p.UNIT.ID);
                p.PART_GROUP = PartRepository.GetPartGroupByID(m_cmd, p.PART_GROUP.ID);

                StockCard sc = new StockCard(p, null, null);
                m_cmd.CommandText = StockCardEntry.FindByStockCardEntryByPart(p.ID, new DateTime(2000, 1, 1), asOfDate);
                rdr = m_cmd.ExecuteReader();
                sc.STOCK_CARD_ENTRIES = StockCardEntry.TransformReaderList(rdr);
                rdr.Close();
                foreach (StockCardEntry e in sc.STOCK_CARD_ENTRIES)
                {
                    if (e.STOCK_CARD_ENTRY_TYPE == StockCardEntryType.SupplierInvoice)
                    {
                        m_cmd.CommandText = SupplierInvoiceItem.GetByIDSQL(e.EVENT_ITEM.ID);
                        rdr          = m_cmd.ExecuteReader();
                        e.EVENT_ITEM = SupplierInvoiceItem.TransformReader(rdr);
                        rdr.Close();
                    }
                    if (e.STOCK_CARD_ENTRY_TYPE == StockCardEntryType.CustomerInvoice)
                    {
                        m_cmd.CommandText = CustomerInvoiceItem.GetByIDSQL(e.EVENT_ITEM.ID);
                        rdr          = m_cmd.ExecuteReader();
                        e.EVENT_ITEM = CustomerInvoiceItem.TransformReader(rdr);
                        rdr.Close();
                    }
                }
                sc.recalculateAvailable();
                m_cmd.CommandText = string.Format(@"insert into table_temp 
                    (
                        string1,string2,string3,double1,double2
                    )
                    values   
                    (
                        '{0}','{1}','{2}',{3},{4}
                    )",
                                                  p.PART_GROUP.NAME + " ~ " + p.PART_GROUP.CODE,
                                                  p.CODE,
                                                  p.UNIT.NAME,
                                                  sc.BALANCE_AVAILABLE,
                                                  p.MINIMUM_STOCK
                                                  );
                m_cmd.ExecuteNonQuery();
                //stockcards.Add(sc);
            }
            return(ds);
        }
Example #4
0
        public override void Update(IEntity en)
        {
            OpenConnection();
            MySql.Data.MySqlClient.MySqlTransaction trans    = m_connection.BeginTransaction();
            MySql.Data.MySqlClient.MySqlCommand     aCommand = new MySql.Data.MySqlClient.MySqlCommand();
            aCommand.Connection  = m_connection;
            aCommand.Transaction = trans;
            try
            {
                Part e = (Part)en;
                aCommand.CommandText = e.GetUpdateSQL();
                this.SavePicture(e.PICTURE, e.CODE);
                aCommand.ExecuteNonQuery();
                //Update base unit---------------------------
                aCommand.CommandText = UnitConversion.GetByPartAndUnitConIDSQL(e.ID, e.UNIT.ID);
                MySql.Data.MySqlClient.MySqlDataReader r = aCommand.ExecuteReader();
                UnitConversion uc = UnitConversion.GetUnitConversion(r);
                r.Close();
                if (uc == null)
                {
                    uc = new UnitConversion();
                }
                uc.BARCODE         = e.BARCODE;
                uc.CONVERSION_QTY  = 1;
                uc.CONVERSION_UNIT = e.UNIT;
                uc.COST_PRICE      = e.COST_PRICE;
                uc.ORIGINAL_QTY    = 1;
                uc.PART            = e;
                uc.SELL_PRICE      = e.SELL_PRICE;
                e.UNIT_CONVERSION_LIST.Add(uc);
                //------------------------------
                foreach (UnitConversion ucp in e.UNIT_CONVERSION_LIST)
                {
                    if (ucp.ID > 0)
                    {
                        aCommand.CommandText = ucp.GetUpdateSQL();
                        aCommand.ExecuteNonQuery();
                    }
                    else
                    {
                        aCommand.CommandText = ucp.GetInsertSQL();
                        aCommand.ExecuteNonQuery();
                        aCommand.CommandText = ucp.GetMaximumIDSQL();
                        ucp.ID = Convert.ToInt32(aCommand.ExecuteScalar());
                    }
                }
                aCommand.CommandText = UnitConversion.DeleteUpdate(e.ID, e.UNIT_CONVERSION_LIST);
                aCommand.ExecuteNonQuery();

                //IList luc = UnitConversion.GetAllStatic(r);
                //r.Close();
                //foreach (UnitConversion chk in luc)
                //{
                //    chk.UPDATED = e.UNIT_CONVERSION_LIST.Contains(chk);
                //}
                //foreach (UnitConversion chk in luc)
                //{
                //    if (!chk.UPDATED)
                //    {
                //        aCommand.CommandText = chk.GetDeleteSQL();
                //        aCommand.ExecuteNonQuery();
                //    }
                //}

                trans.Commit();
            }
            catch (Exception x)
            {
                trans.Rollback();
                throw new Exception(getErrorMessage(x));
            }
            finally
            {
                m_connection.Close();
            }
        }
Example #5
0
        private void insertTransaction()
        {
            if (moneyList.Items.Count <= 0)
            {
                Response.Write("<script>alert('Inserire prodotti')</script>");
            }
            else
            {
                String connS = System.Configuration.ConfigurationManager.ConnectionStrings["VideogameStore_String"].ToString();
                conn = new MySql.Data.MySqlClient.MySqlConnection(connS);
                conn.Open();
                int id_pv  = Convert.ToInt32(idTextBox.Text);
                int id_sub = 0;
                findAmount();
                if (subTextBox.Text != "")
                {
                    id_sub = Convert.ToInt32(subTextBox.Text);
                }
                string today = DateTime.Today.ToString("yy-mm-dd");
                if (SubscriberCb.Checked)
                {
                    query = "INSERT INTO tbl_transazione(datee, price, tipo, id_ab, id_pv)values('" + today + "', " + totalPrice + "," + ((transType.SelectedIndex) - 1) + "," + id_sub + ", " + id_pv + "); ";
                }
                else
                {
                    query = "INSERT INTO tbl_transazione(datee,price,tipo,id_pv)values('" + today + "'," + totalPrice + "," + ((transType.SelectedIndex) - 1) + "," + id_pv + "); ";
                }
                command = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
                command.ExecuteReader();
                query = "SELECT MAX(COD_tr) as max FROM tbl_transazione;";
                conn.Close();
                conn.Open();
                command = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
                reader  = command.ExecuteReader();
                int id_tr = 0;
                while (reader.HasRows && reader.Read())
                {
                    id_tr = reader.GetInt32(reader.GetOrdinal("max"));
                }
                reader.Close();
                conn.Close();
                conn.Open();
                for (int i = 0; i < qntList.Items.Count; i++)
                {
                    int productType = Convert.ToInt32(typeList.Items[i].ToString());
                    switch (productType)
                    {
                    case 1:
                        query   = "insert into tbl_contiene_vdg(id_vdg, id_tr, qnt) values (" + Convert.ToInt32(codList.Items[i].ToString()) + "," + id_tr + "," + Convert.ToInt32(qntList.Items[i].ToString()) + ");";
                        command = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
                        command.ExecuteReader();
                        conn.Close();
                        updateCopies(Convert.ToInt32(codList.Items[i].ToString()), 1, Convert.ToInt32(qntList.Items[i].ToString()));
                        break;

                    case 2:
                        query   = "insert into tbl_contiene_cn(id_cn, id_tr, qnt) values (" + Convert.ToInt32(codList.Items[i].ToString()) + "," + id_tr + "," + Convert.ToInt32(qntList.Items[i].ToString()) + ");";
                        command = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
                        command.ExecuteReader();
                        conn.Close();
                        updateCopies(Convert.ToInt32(codList.Items[i].ToString()), 2, Convert.ToInt32(qntList.Items[i].ToString()));

                        break;

                    case 3:
                        query   = "insert into tbl_contiene_ac(id_ac, id_tr, qnt) values (" + Convert.ToInt32(codList.Items[i].ToString()) + "," + id_tr + "," + Convert.ToInt32(qntList.Items[i].ToString()) + ");";
                        command = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
                        command.ExecuteReader();
                        conn.Close();
                        updateCopies(Convert.ToInt32(codList.Items[i].ToString()), 3, Convert.ToInt32(qntList.Items[i].ToString()));

                        break;
                    }

                    conn.Open();
                }

                nameList.Items.Clear();
                moneyList.Items.Clear();
                qntList.Items.Clear();
                codList.Items.Clear();
                typeList.Items.Clear();
                totalPrice = 0;
                conn.Close();
            }
        }
Example #6
0
 public Status(MySql.Data.MySqlClient.MySqlDataReader dr)
 {
     Fill(dr);
 }
Example #7
0
        public List <Question> getQuestionList()
        {
            List <Question> q = new List <Question>();

            msqlConnection = new MySql.Data.MySqlClient.MySqlConnection(constr);
            //define the command reference
            MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
            //define the connection used by the command object
            msqlCommand.Connection = this.msqlConnection;
            //define the command text
            msqlCommand.CommandText = "SELECT questionid,q_name,c_a,c_b,c_c,c_d,hardlevel,score,answer FROM question ;";

            Console.WriteLine(msqlCommand.CommandText);
            try
            {
                //open the connection
                this.msqlConnection.Open();
                //use a DataReader to process each record
                msqlCommand.ExecuteNonQuery();
                MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader();
                DataTable dt = new DataTable();
                dt.Load(msqlReader);
                int    C         = dt.Rows.Count;
                Random r         = new Random(Guid.NewGuid().GetHashCode());
                bool[] Bquestion = new bool[C];
                int    j         = 0;
                for (int i = 0; i < 100000; i++)
                {
                    int rc = r.Next(C);
                    if (Bquestion[rc] == false)
                    {
                        Question qu = new Question();
                        qu.questionid = int.Parse(dt.Rows[rc]["questionid"].ToString());
                        qu.q_name     = dt.Rows[rc]["q_name"].ToString();
                        qu.c_a        = dt.Rows[rc]["c_a"].ToString();
                        qu.c_b        = dt.Rows[rc]["c_b"].ToString();
                        qu.c_c        = dt.Rows[rc]["c_c"].ToString();
                        qu.c_d        = dt.Rows[rc]["c_d"].ToString();
                        qu.hardlevel  = int.Parse(dt.Rows[rc]["hardlevel"].ToString());
                        qu.score      = int.Parse(dt.Rows[rc]["score"].ToString());
                        qu.answer     = dt.Rows[rc]["answer"].ToString();
                        q.Add(qu);
                        j++;
                    }
                    if (j == 10)
                    {
                        break;
                    }
                }
            }
            catch (Exception er)
            {
                //do something with the exception
            }
            finally
            {
                //always close the connection
                this.msqlConnection.Close();
            }
            return(q);
        }
        /// <summary>
        /// Realiza uma consulta no banco de dados, armazenando os dados de retorno em um <see creg="System.Data.DataTable"/>.
        /// Utiliza um DataReader para buscar em blocos. Conexão com o banco precisa estar aberta.
        /// </summary>
        /// <param name='p_sql'>
        /// Código SQL a ser consultado no banco de dados.
        /// </param>
        /// <param name='p_tablename'>
        /// Nome virtual da tabela onde deve ser armazenado o resultado, para fins de cache.
        /// </param>
        /// <param name='p_startrow'>
        /// Número da linha inicial.
        /// </param>
        /// <param name='p_endrow'>
        /// Número da linha final.
        /// </param>
        /// <param name='p_hasmoredata'>
        /// Indica se ainda há mais dados a serem lidos.
        /// </param>
        public override System.Data.DataTable Query(string p_sql, string p_tablename, uint p_startrow, uint p_endrow, out bool p_hasmoredata)
        {
            System.Data.DataTable v_table = null;
            System.Data.DataRow v_row;

            try
            {
                if (this.v_reader == null)
                {
                    this.v_cmd.CommandText = p_sql;
                    this.v_reader = this.v_cmd.ExecuteReader();
                    this.v_currentrow = 0;
                }

                v_table = new System.Data.DataTable(p_tablename);
                for (int i = 0; i < v_reader.FieldCount; i++)
                    v_table.Columns.Add(this.FixColumnName(this.v_reader.GetName(i)), typeof(string));

                p_hasmoredata = false;
                while (this.v_reader.Read())
                {
                    p_hasmoredata = true;

                    if (this.v_currentrow >= p_startrow && this.v_currentrow <= p_endrow)
                    {
                        v_row = v_table.NewRow();
                        for (int i = 0; i < this.v_reader.FieldCount; i++)
                            v_row[i] = this.v_reader[i].ToString();
                        v_table.Rows.Add(v_row);
                    }

                    this.v_currentrow++;

                    if (this.v_currentrow > p_endrow)
                        break;
                }

                if (! p_hasmoredata)
                {
                    this.v_reader.Close();
                    this.v_reader = null;
                }

                return v_table;
            }
            catch (MySql.Data.MySqlClient.MySqlException e)
            {
                throw new Spartacus.Database.Exception(e);
            }
        }
Example #9
0
 internal Role(MySql.Data.MySqlClient.MySqlDataReader dr)
 {
     Fill(dr);
 }
Example #10
0
        static void Main(string[] args)
        {
            if (args.Length != 1)
            {
                Console.WriteLine("ERROR - Invalid Arguments - Must be \"Connection String\"");
                Console.ReadLine();
                return;
            }
            MySql.Data.MySqlClient.MySqlConnection _conn       = null;
            MySql.Data.MySqlClient.MySqlConnection _updateconn = null;
            MySql.Data.MySqlClient.MySqlDataReader rdr         = null;
            Dictionary <string, long> PlayerSorties            = new Dictionary <string, long>();
            long auto_gen_sortie_id = 0;
            long rows_processed     = 0;

            try
            {
                _conn = new MySql.Data.MySqlClient.MySqlConnection(args[0]);
                _conn.Open();
                _updateconn = new MySql.Data.MySqlClient.MySqlConnection(args[0]);
                _updateconn.Open();
                MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT id, session_id, ucid, event FROM raw_gameevents_log WHERE ucid IS NOT NULL ORDER BY session_id, ucid;")
                {
                    Connection  = _conn,
                    CommandType = System.Data.CommandType.Text
                };
                rdr = cmd.ExecuteReader();
                DataTable dt = new DataTable();
                dt.Load(rdr);

                long total_rows = dt.Rows.Count;

                foreach (DataRow dr in dt.Rows)
                {
                    string ucid   = dr.Field <string>("ucid");
                    string gevent = dr.Field <string>("event");
                    long   id     = dr.Field <long>("id");

                    if (ucid != null && dr["ucid"] != DBNull.Value)
                    {
                        if (!PlayerSorties.ContainsKey(ucid))
                        {
                            auto_gen_sortie_id += 1;
                            PlayerSorties.Add(ucid, auto_gen_sortie_id);
                        }

                        if (gevent == "TAKEOFF")
                        {
                            auto_gen_sortie_id += 1;
                            PlayerSorties[ucid] = auto_gen_sortie_id;
                        }

                        try
                        {
                            MySql.Data.MySqlClient.MySqlCommand updatecmd =
                                new MySql.Data.MySqlClient.MySqlCommand("UPDATE raw_gameevents_log SET sortie_id = @param_sortie_id WHERE id = @param_event_id;");
                            updatecmd.Parameters.AddWithValue("@param_sortie_id", PlayerSorties[ucid]);
                            updatecmd.Parameters.AddWithValue("@param_event_id", id);

                            updatecmd.Connection  = _conn;
                            updatecmd.CommandType = System.Data.CommandType.Text;
                            int res = Convert.ToInt32(updatecmd.ExecuteScalar());
                        }
                        catch (Exception ex)
                        {
                            Console.WriteLine("Error updating row (id: " + id + ") - " + ex.Message);
                        }
                    }
                    rows_processed += 1;
                    if (rows_processed % 100 == 0)
                    {
                        Console.WriteLine("Processed Rows " + rows_processed + " of " + total_rows);
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error selecting data - " + ex.Message);
            }
            finally
            {
                if (_conn != null)
                {
                    if (_conn.State == System.Data.ConnectionState.Open || _conn.State == System.Data.ConnectionState.Connecting)
                    {
                        _conn.Close();
                    }
                }

                if (rdr != null)
                {
                    if (!rdr.IsClosed)
                    {
                        rdr.Close();
                    }
                }
            }

            Console.WriteLine("Complete");
            Console.ReadLine();
            return;
        }
Example #11
0
 public Ticket(MySql.Data.MySqlClient.MySqlDataReader dr)
 {
     Fill(dr);
 }
Example #12
0
        public String LocalSetupGet(my.MySqlClient.MySqlConnection conn)
        {
            string strQuery = String.Empty;

            strQuery = string.Format("SELECT username, domain, ipaddress, computer_name, process_name, process_path, process_starttime, processid, process_description, process_exittime, version, productname, companyname, semester, process_path_commandline, sid, fullname, department, role, idactivity FROM app_performance.activity WHERE process_exittime BETWEEN '2016-10-06 11:00:30' AND '2016-11-09 20:21:30'");

            my.MySqlClient.MySqlCommand cmd = new my.MySqlClient.MySqlCommand(strQuery, conn);


            my.MySqlClient.MySqlDataReader myReader = null;



            try
            {
                myReader = cmd.ExecuteReader();
                int n = 0;

                try {
                    System.IO.Directory.CreateDirectory(@"C:\bithubReports");
                } catch (Exception ex) {
                    return(ex.Message.ToString());
                }

                //var filepath = @"C:\bithubReports\report.txt";

                var csv = new System.Text.StringBuilder();


                while (myReader.Read())
                {
                    HttpContext.Current.Response.Write(myReader.GetString(0) + "\n");
                    string result = "";
                    string name, domain, ip, cpu, proc, procPath, procStart, procID, procDesc, procExit, v, pName, cName, sem, ppcl, sid, fName, dep, role, id;
                    if (myReader.IsDBNull(0))
                    {
                        name = " ";
                    }
                    else
                    {
                        name = String.Format("{0}", myReader.GetString(0));
                    }
                    if (myReader.IsDBNull(1))
                    {
                        domain = " ";
                    }
                    else
                    {
                        domain = String.Format("{0}", myReader.GetString(1));
                    }
                    if (myReader.IsDBNull(2))
                    {
                        ip = " ";
                    }
                    else
                    {
                        ip = String.Format("{0}", myReader.GetString(2));
                    }
                    if (myReader.IsDBNull(3))
                    {
                        cpu = " ";
                    }
                    else
                    {
                        cpu = String.Format("{0}", myReader.GetString(3));
                    }
                    if (myReader.IsDBNull(4))
                    {
                        proc = " ";
                    }
                    else
                    {
                        proc = String.Format("{0}", myReader.GetString(4));
                    }
                    if (myReader.IsDBNull(5))
                    {
                        procPath = " ";
                    }
                    else
                    {
                        procPath = String.Format("{0}", myReader.GetString(5));
                    }
                    if (myReader.IsDBNull(6))
                    {
                        procStart = " ";
                    }
                    else
                    {
                        procStart = String.Format("{0}", myReader.GetDateTime(6));
                    }
                    if (myReader.IsDBNull(7))
                    {
                        procID = " ";
                    }
                    else
                    {
                        procID = String.Format("{0}", myReader.GetInt64(7));
                    }
                    if (myReader.IsDBNull(8))
                    {
                        procDesc = " ";
                    }
                    else
                    {
                        procDesc = String.Format("{0}", myReader.GetString(8));
                    }
                    if (myReader.IsDBNull(9))
                    {
                        procExit = " ";
                    }
                    else
                    {
                        procExit = String.Format("{0}", myReader.GetDateTime(9));
                    }
                    if (myReader.IsDBNull(10))
                    {
                        v = " ";
                    }
                    else
                    {
                        v = String.Format("{0}", myReader.GetString(10));
                    }
                    if (myReader.IsDBNull(11))
                    {
                        pName = " ";
                    }
                    else
                    {
                        pName = String.Format("{0}", myReader.GetString(11));
                    }
                    if (myReader.IsDBNull(12))
                    {
                        cName = " ";
                    }
                    else
                    {
                        cName = String.Format("{0}", myReader.GetString(12));
                    }
                    if (myReader.IsDBNull(13))
                    {
                        sem = " ";
                    }
                    else
                    {
                        sem = String.Format("{0}", myReader.GetString(13));
                    }
                    if (myReader.IsDBNull(14))
                    {
                        ppcl = " ";
                    }
                    else
                    {
                        ppcl = String.Format("{0}", myReader.GetString(14));
                    }
                    if (myReader.IsDBNull(15))
                    {
                        sid = " ";
                    }
                    else
                    {
                        sid = String.Format("{0}", myReader.GetString(15));
                    }
                    if (myReader.IsDBNull(16))
                    {
                        fName = " ";
                    }
                    else
                    {
                        fName = String.Format("{0}", myReader.GetString(16));
                    }
                    if (myReader.IsDBNull(17))
                    {
                        dep = " ";
                    }
                    else
                    {
                        dep = String.Format("{0}", myReader.GetString(17));
                    }
                    if (myReader.IsDBNull(18))
                    {
                        role = " ";
                    }
                    else
                    {
                        role = String.Format("{0}", myReader.GetString(18));
                    }
                    if (myReader.IsDBNull(19))
                    {
                        id = " ";
                    }
                    else
                    {
                        id = String.Format("{0}", myReader.GetString(19));
                    }

                    result = name + "," + domain + "," + ip + "," + cpu + "," + proc + "," + procPath + "," + procStart + "," + procID + "," + procDesc + "," + procExit + "," + v + "," + pName + "," + cName + "," + sem + "," + ppcl + "," + sid + "," + fName + "," + dep + "," + role + "," + id;

                    string line = result;

                    try{
                        csv.AppendLine(line);
                    } catch (Exception ex) {
                        return(ex.Message.ToString());
                    }
                    n = 0;
                }


                try{
                    System.IO.File.WriteAllText(filepath, csv.ToString());
                } catch (Exception ex) {
                    return(ex.Message.ToString());
                }
            }
            catch (Exception ex)
            {
                return(ex.Message.ToString());
            }

            try
            {
                String email = "*****@*****.**";
                send_email(email);
            }
            catch (Exception ex)
            {
                return(ex.Message.ToString());
            }

            if (myReader != null)
            {
                if (myReader.IsClosed == false)
                {
                    myReader.Close();
                    myReader.Dispose();
                }
            }


            if (conn != null)
            {
                if (conn.State == System.Data.ConnectionState.Open)
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            HttpContext.Current.Response.Write("Success");
            return("Success");
        }
Example #13
0
 /// <summary>
 /// Fills the object out with data from the datareader.
 /// </summary>
 /// <param name="dr"></param>
 public void Fill(MySql.Data.MySqlClient.MySqlDataReader dr)
 {
     ID   = dr.GetInt32("CategoryID");
     Name = dr.GetString("Name");
 }
Example #14
0
 /// <summary>
 /// Constructor that calls the fill method.
 /// </summary>
 /// <param name="dr"></param>
 public Category(MySql.Data.MySqlClient.MySqlDataReader dr)
 {
     Fill(dr);
 }
        private void dgvView_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            DialogResult dr;
            StaffDetailsSavers staffSavers= new StaffDetailsSavers();
            string empNo = Convert.ToString(dgvView.Rows[e.RowIndex].Cells["ER_EMP_NO"].Value);

            # region DeleteUser
            if (DeleteState)
            {
                dr = MessageBox.Show("Do you want to delete the details of Employee " + Convert.ToString(dgvView.Rows[e.RowIndex].Cells["ER_EMP_NAME"].Value), "Delete User", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
                if (dr == DialogResult.No)
                {
                    return;
                }

                staffSavers.deleteStaffDetails(empNo);
                staffSavers.deleteStaffProof(empNo);

                updateStatus(this, "User Deleted");
                LoadDGV();
                return;
            }
            # endregion delete

            # region PrintUser
            if (PrintState && e.RowIndex != -1)
            {
                WinformPdfViewer wfPdfView = new WinformPdfViewer(Convert.ToString(dgvView.Rows[e.RowIndex].Cells["ER_EMP_NO"].Value));
                wfPdfView.ShowDialog();
                this.Cursor = Cursors.Default;
                return;
            }
            # endregion PrintUser

            # region Modify/User
            dr = MessageBox.Show("Do you want to Modify the details of Employee " + Convert.ToString(dgvView.Rows[e.RowIndex].Cells[2].Value), "Modify Employee Details", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
            if (dr == DialogResult.No)
            {
                return;
            }

            //add employee number and name to text box
            txtEmpNo.Text = Convert.ToString(dgvView[1, e.RowIndex].Value);
            txtName.Text = Convert.ToString(dgvView[2, e.RowIndex].Value);

            myReader = staffSavers.fetchStaffDetails(txtEmpNo.Text);
            while (myReader.Read())
            {
                txtFthrName.Text = (myReader["ER_FATHER_NAME"].ToString());
                dtpDob.Value = ((DateTime)myReader["ER_EMP_DOB"]);

                txtRead.Text = (myReader["ER_EMP_READ"].ToString());
                txtWrite.Text = (myReader["ER_EMP_WRITE"].ToString());
                txtSpeak.Text = (myReader["ER_EMP_SPEAK"].ToString());

                txtPermAdd.Text = (myReader["ER_EMP_PER_ADDRESS"].ToString());
                txtPhoneNo.Text = (myReader["ER_EMP_PHONE_NO"].ToString());
                txtPresAdd.Text = (myReader["ER_EMP_PRES_ADDRESS"].ToString());
                txtMobNo.Text = (myReader["ER_EMP_MOBILE_NO"].ToString());

                txtEduQual.Text = (myReader["ER_EMP_EDU_QUAL"].ToString());
                txtOthrQual.Text = (myReader["ER_EMP_OTHR_QUAL"].ToString());
                txtExpInSec.Text = (myReader["ER_EMP_EXPERIENCE_SEC_SER"].ToString());
                txtAbout.Text = (myReader["ER_EMP_ABOUT"].ToString());

                txtNameRef1.Text = (myReader["ER_REF1_NAME"].ToString());
                txtHouseNoRef1.Text = (myReader["ER_REF1_HOUSE_NO"].ToString());
                txtStreetNoRef1.Text = (myReader["ER_REF1_STREET_NO"].ToString());
                txtPostOffRef1.Text = (myReader["ER_REF1_POST_OFFICE"].ToString());
                txtDistRef1.Text = (myReader["ER_REF1_DISTRICT"].ToString());
                txtStateRef1.Text = (myReader["ER_REF1_STATE"].ToString());
                txtTeleRef1.Text = (myReader["ER_REF1_TELEPHONE"].ToString());
                txtPincodeRef1.Text = (myReader["ER_REF1_PINCODE"].ToString());
                txtOccRef1.Text = (myReader["ER_REF1_OCCUPATION"].ToString());

                txtNameRef2.Text = (myReader["ER_REF2_NAME"].ToString());
                txtHouseNoRef2.Text = (myReader["ER_REF2_HOUSE_NO"].ToString());
                txtStreetNoRef2.Text = (myReader["ER_REF2_STREET_NO"].ToString());
                txtPostOffRef2.Text = (myReader["ER_REF2_POST_OFFICE"].ToString());
                txtDistRef2.Text = (myReader["ER_REF2_DISTRICT"].ToString());
                txtStateRef2.Text = (myReader["ER_REF2_STATE"].ToString());
                txtTeleRef2.Text = (myReader["ER_REF2_TELEPHONE"].ToString());
                txtPincodeRef2.Text = (myReader["ER_REF2_PINCODE"].ToString());
                txtOccRef2.Text = (myReader["ER_REF2_OCCUPATION"].ToString());

                if (myReader["ER_EMP_MARITAL_STATUS"].ToString() == "Single")
                {
                    rdbSingle.Checked = true;
                    grbMarital.Enabled = false;
                }
                else
                {
                    rdbMarried.Checked = true;
                    txtWifeName.Text = (myReader["ER_WIFE_NAME"].ToString());
                    txtNoOfChild.Text = (myReader["ER_EMP_NOCHILD"].ToString());
                    if (File.Exists(myReader["EP_EMP_NOCHILD_PROOF"].ToString()))
                        txtNoOfChildProof.Text = (myReader["EP_EMP_NOCHILD_PROOF"].ToString());
                }

                pcbEmpImage.ImageLocation = (myReader["EP_EMP_PIC"].ToString());
                txtDobProof.Text = (myReader["EP_EMP_DOB_PROOF"].ToString());
                txtPerAddressProof.Text = (myReader["EP_EMP_PER_ADDRESS_PROOF"].ToString());
                txtPresAddressProof.Text = (myReader["EP_EMP_PRES_ADDRESS_PROOF"].ToString());
                txtEduProof.Text = (myReader["EP_EMP_EDU_QUAL_PROOF"].ToString());
                if (File.Exists(myReader["EP_EMP_OTHR_QUAL_PROOF"].ToString()))
                    txtOthrQualProof.Text = (myReader["EP_EMP_OTHR_QUAL_PROOF"].ToString());

                EmpPicext = Path.GetExtension(pcbEmpImage.ImageLocation);
                DOBext = Path.GetExtension(txtDobProof.Text);
                PermAddext = Path.GetExtension(txtPerAddressProof.Text);
                PresAddext = Path.GetExtension(txtPresAddressProof.Text);
                EduQualext = Path.GetExtension(txtEduProof.Text);

                if (!string.IsNullOrEmpty(txtNoOfChildProof.Text))
                {
                    NOChildext = Path.GetExtension(txtNoOfChildProof.Text);
                }

                if (!string.IsNullOrEmpty(txtOthrQualProof.Text))
                {
                    OthrQualext = Path.GetExtension(txtOthrQualProof.Text);
                }
            }

            //menustate close
            MenuMode(this, false);

            //pnlview
            pnlUsrView.Visible = false;

            //pnlnew.visible = true
            tabControl1.Visible = true;

            UpdateState = true;
            this.Cursor = Cursors.Default;
            # endregion ModifyUser
        }
        /// <summary>
        /// Lista os nomes e tipos de colunas de uma determinada consulta.
        /// </summary>
        /// <returns>Matriz com os nomes e tipos de colunas.</returns>
        /// <param name="p_sql">Consulta SQL.</param>
        public override string[,] GetColumnNamesAndTypes(string p_sql)
        {
            string[,] v_matrix;

            if (this.v_con == null)
            {
                try
                {
                    this.v_con = new MySql.Data.MySqlClient.MySqlConnection(this.v_connectionstring);
                    this.v_con.Open();
                    this.v_cmd = new MySql.Data.MySqlClient.MySqlCommand(p_sql, this.v_con);
                    this.v_reader = this.v_cmd.ExecuteReader();

                    v_matrix = new string[v_reader.FieldCount, 2];
                    for (int i = 0; i < v_reader.FieldCount; i++)
                    {
                        v_matrix[i, 0] = this.FixColumnName(this.v_reader.GetName(i));
                        v_matrix[i, 1] = this.v_reader.GetDataTypeName(i);
                    }

                    return v_matrix;
                }
                catch (MySql.Data.MySqlClient.MySqlException e)
                {
                    throw new Spartacus.Database.Exception(e);
                }
                finally
                {
                    if (this.v_reader != null)
                    {
                        this.v_reader.Close();
                        this.v_reader = null;
                    }
                    if (this.v_cmd != null)
                    {
                        this.v_cmd.Dispose();
                        this.v_cmd = null;
                    }
                    if (this.v_con != null)
                    {
                        this.v_con.Close();
                        this.v_con = null;
                    }
                }
            }
            else
            {
                try
                {
                    this.v_cmd.CommandText = p_sql;
                    this.v_reader = this.v_cmd.ExecuteReader();

                    v_matrix = new string[v_reader.FieldCount, 2];
                    for (int i = 0; i < v_reader.FieldCount; i++)
                    {
                        v_matrix[i, 0] = this.FixColumnName(this.v_reader.GetName(i));
                        v_matrix[i, 1] = this.v_reader.GetDataTypeName(i);
                    }

                    return v_matrix;
                }
                catch (MySql.Data.MySqlClient.MySqlException e)
                {
                    throw new Spartacus.Database.Exception(e);
                }
                finally
                {
                    if (this.v_reader != null)
                    {
                        this.v_reader.Close();
                        this.v_reader = null;
                    }
                }
            }
        }
        public List <RealtimeCameraInfo> GetCamerasByGroupID(uint groupId)
        {
            using (MySql.Data.MySqlClient.MySqlConnection conn
                       = new MySql.Data.MySqlClient.MySqlConnection(string.Format(m_connString, m_serverIP, "vdm_server_db")))
            {
                try
                {
                    List <RealtimeCameraInfo> list = new List <RealtimeCameraInfo>();
                    //string sql = "SELECT * FROM `camera_info` where GROUP_ID="+groupId;
                    string sql = "SELECT"
                                 + " cam.ID AS CameraID,"
                                 + " cam.`NAME` AS CameraName,"
                                 + " cam.GROUP_ID AS GroupID,"
                                 + " cam.`CODE` AS CameraCode,"
                                 + " cam.COORD_X AS PosCoordX,"
                                 + " cam.COORD_Y AS PosCoordY,"
                                 + " cam.NET_STORE_DEV_ID AS PlatId,"
                                 + " cam.NET_DEV_CHANNEL AS CameraChannelID,"
                                 + " dev.ACCESS_PROTOCOL_TYPE AS ProtocolType,"
                                 + " dev.DEVICE_IP AS PlatIP,"
                                 + " dev.DEVICE_PORT AS PlatPort,"
                                 + " dev.LOGIN_USER AS UserName,"
                                 + " dev.LOGIN_PWD AS `Password`"
                                 + " FROM"
                                 + " camera_info AS cam"
                                 + " INNER JOIN net_store_dev_info AS dev ON cam.NET_STORE_DEV_ID = dev.ID";

                    if (groupId > 0)
                    {
                        sql += " where cam.GROUP_ID=" + groupId;
                    }


                    conn.Open();
                    MyLog4Net.Container.Instance.Log.Debug("GetCamerasByGroupID sql:" + sql);
                    MySql.Data.MySqlClient.MySqlCommand    cmd    = new MySql.Data.MySqlClient.MySqlCommand(sql, conn);
                    MySql.Data.MySqlClient.MySqlDataReader reader = cmd.ExecuteReader();
                    DataTable table = new DataTable();
                    table.Load(reader);
                    foreach (DataRow item in table.Rows)
                    {
                        RealtimeCameraInfo cameraInfo = new RealtimeCameraInfo();

                        cameraInfo.CameraID   = Convert.ToUInt32(item["CameraID"].ToString());
                        cameraInfo.GroupID    = Convert.ToUInt32(item["GroupID"].ToString());
                        cameraInfo.CameraName = item["CameraName"].ToString();
                        cameraInfo.CameraCode = item["CameraCode"].ToString();

                        cameraInfo.PlatId          = Convert.ToUInt32(item["PlatId"].ToString());
                        cameraInfo.CameraChannelID = item["CameraChannelID"].ToString();
                        cameraInfo.PosCoordX       = Convert.ToSingle(item["PosCoordX"].ToString());
                        cameraInfo.PosCoordY       = Convert.ToSingle(item["PosCoordY"].ToString());
                        cameraInfo.Password        = item["Password"].ToString();
                        cameraInfo.UserName        = item["UserName"].ToString();
                        cameraInfo.PlatIP          = item["PlatIP"].ToString();
                        cameraInfo.PlatPort        = Convert.ToUInt32(item["PlatPort"].ToString());
                        cameraInfo.ProtocolType    = (E_VDA_NET_STORE_DEV_PROTOCOL_TYPE)Convert.ToUInt32(item["ProtocolType"].ToString());
                        if (string.IsNullOrEmpty(cameraInfo.CameraCode))
                        {
                            //192.168.137.177_13300_1_34010000001320000001
                            cameraInfo.CameraCode = cameraInfo.PlatIP + "_" + cameraInfo.PlatPort + "_" + (int)cameraInfo.ProtocolType + "_" + cameraInfo.CameraChannelID;
                        }
                        list.Add(cameraInfo);
                    }

                    conn.Close();
                    list.Sort((it1, it2) => it1.CameraName.CompareTo(it2.CameraName));
                    return(list);
                }
                catch (Exception ex)
                {
                    MyLog4Net.Container.Instance.Log.DebugWithDebugView("GetCamerasByGroupID sql error:" + ex.ToString());
                    //Framework.Container.Instance.InteractionService.ShowMessageBox("数据库失败", Framework.Environment.PROGRAM_NAME);
                    return(new List <RealtimeCameraInfo>());
                }
            }
        }
        /// <summary>
        /// Inicializa uma nova instancia da classe <see cref="Spartacus.Database.Mysql"/>.
        /// </summary>
        /// <param name='p_server'>
        /// IP do servidor MySQL.
        /// </param>
        /// <param name='p_port'>
        /// Porta de conexão.
        /// </param>
        /// <param name='p_database'>
        /// Nome da base de dados ou schema.
        /// </param>
        /// <param name='p_user'>
        /// Usuário do MySQL.
        /// </param>
        /// <param name='p_password'>
        /// Senha do MySQL.
        /// </param>
        public Mysql(string p_server, string p_port, string p_database, string p_user, string p_password)
            : base(p_server, p_port, p_database, p_user, p_password)
        {
            this.v_connectionstring = "Persist Security Info=False;"
                + "Server=" + this.v_host + ";"
                + "Port=" + this.v_port + ";"
                + "Database=" + this.v_service + ";"
                + "Uid=" + this.v_user + ";"
                + "Pwd=" + this.v_password;

            this.v_con = null;
            this.v_cmd = null;
            this.v_reader = null;
        }
        public List <CrowdInfo> QueryCrowdData(DateTime startT, DateTime endT, RealtimeCameraInfo[] SelectedCrowdCameraInfo)
        {
            List <CrowdInfo> CrowdDatas = new List <CrowdInfo>();

            string cameras   = "";
            string startTime = Convert.ToUInt64(startT.Subtract(DataModel.Common.ZEROTIME).TotalSeconds).ToString();
            string endTime   = Convert.ToUInt64(endT.Subtract(DataModel.Common.ZEROTIME).TotalSeconds).ToString();

            if (SelectedCrowdCameraInfo != null && SelectedCrowdCameraInfo.Length > 0)
            {
                foreach (var item in SelectedCrowdCameraInfo)
                {
                    cameras += "\"" + item.CameraCode + "\",";
                }
                cameras = cameras.TrimEnd(',');
            }
            using (MySql.Data.MySqlClient.MySqlConnection conn
                       = new MySql.Data.MySqlClient.MySqlConnection(string.Format(m_connString, RTRISServerIP, "rtrs_server_db")))
            {
                try
                {
                    string sql = "SELECT"
                                 + " info.ID,"
                                 + " info.CAMERA_CODE,"
                                 + " info.TIME_MILLI_SEC,"
                                 + " info.PEOPLE_COUNT,"
                                 + " info.REGION_AREA,"
                                 + " info.REGION_POINT_NUM,"
                                 + " info.REGION_POINT,"
                                 + " info.RESERVED"
                                 + " FROM"
                                 + " rt_crowd_result_info AS info "
                                 + " WHERE info.TIME_MILLI_SEC BETWEEN \"" + startTime + "\" AND \"" + endTime + "\"";


                    if (!string.IsNullOrEmpty(cameras))
                    {
                        sql += " AND info.CAMERA_CODE in (" + cameras + ")";
                    }
                    MyLog4Net.Container.Instance.Log.Debug("QueryData sql:" + sql);
                    conn.Open();
                    MySql.Data.MySqlClient.MySqlCommand    cmd    = new MySql.Data.MySqlClient.MySqlCommand(sql, conn);
                    MySql.Data.MySqlClient.MySqlDataReader reader = cmd.ExecuteReader();
                    DataTable table = new DataTable();
                    table.Load(reader);
                    conn.Close();

                    CrowdDatas = new List <CrowdInfo>();
                    foreach (DataRow item in table.Rows)
                    {
                        CrowdInfo info = new CrowdInfo();
                        info.ID          = Convert.ToUInt64(item["ID"].ToString());
                        info.CameraCode  = item["CAMERA_CODE"].ToString();
                        info.TimeSec     = DataModel.Common.ZEROTIME.AddSeconds(Convert.ToUInt64(item["TIME_MILLI_SEC"].ToString()));
                        info.PeopleCount = Convert.ToUInt32(item["PEOPLE_COUNT"].ToString());
                        info.RegionArea  = Convert.ToUInt32(item["REGION_AREA"].ToString());
                        string[]     ps     = item["REGION_POINT"].ToString().Split(new string[] { "/" }, StringSplitOptions.RemoveEmptyEntries);
                        List <Point> listps = new List <Point>();
                        for (int i = 0; i < ps.Length; i += 2)
                        {
                            listps.Add(new Point(Convert.ToInt32(ps[i]), Convert.ToInt32(ps[i + 1])));
                        }
                        info.RegionPoints = listps;//691/84/1852/142/1891/1020/716/1036/
                        //byte[] bytes1 = (byte[])item["HOT_IMAGE_BUFFER"];
                        //int len1 = Convert.ToInt32(item["HOT_IMAGE_LEN"].ToString());
                        //info.HotImage = BOCOM.RealtimeProtocol.Model.ModelParser.GetImage(bytes1, len1);
                        //byte[] bytes2 = (byte[])item["DIRECTION_IMAGE_BUFFER"];
                        //int len2 = Convert.ToInt32(item["DIRECTION_IMAGE_LEN"].ToString());
                        //info.DirectionImage = BOCOM.RealtimeProtocol.Model.ModelParser.GetImage(bytes2, len2);
                        //byte[] bytes3 = (byte[])item["ORIGINAL_IMAGE_BUFFER"];
                        //int len3 = Convert.ToInt32(item["ORIGINAL_IMAGE_LEN"].ToString());
                        //info.OriginaloImage = BOCOM.RealtimeProtocol.Model.ModelParser.GetImage(bytes3, len3);

                        CrowdDatas.Add(info);
                    }
                    return(CrowdDatas);
                    //if (FinishQueryData != null)
                    //    FinishQueryData(CrowdDatas, null);
                }
                catch (Exception ex)
                {
                    MyLog4Net.Container.Instance.Log.DebugWithDebugView("QueryCrowdData sql error:" + ex.ToString());

                    //Framework.Container.Instance.InteractionService.ShowMessageBox("数据库失败", Framework.Environment.PROGRAM_NAME);
                    return(new List <CrowdInfo>());
                }
            }
        }
        public List <PlateInfo> QueryPlateData(DateTime startT, DateTime endT, RealtimeCameraInfo[] SelectedCrowdCameraInfo, string plateNum, uint vehicleColor, uint plateColor, IVX.Controls.DAO.VehicleBrand[] m_CheckedVehicleModels, long m_Brand, int m_NVehicleDetailType, bool isStart = true)
        {
            List <PlateInfo> PlateDatas = new List <PlateInfo>();

            m_page = isStart ? 0 : m_page;
            string cameras   = "";
            string startTime = Convert.ToUInt64(startT.Subtract(DataModel.Common.ZEROTIME).TotalSeconds).ToString();
            string endTime   = Convert.ToUInt64(endT.Subtract(DataModel.Common.ZEROTIME).TotalSeconds).ToString();

            if (SelectedCrowdCameraInfo != null && SelectedCrowdCameraInfo.Length > 0)
            {
                foreach (var item in SelectedCrowdCameraInfo)
                {
                    cameras += "\"" + item.CameraCode + "\",";
                }
                cameras = cameras.TrimEnd(',');
            }
            string modelids = "";

            if (m_CheckedVehicleModels != null && m_CheckedVehicleModels.Length > 0)
            {
                foreach (var item in m_CheckedVehicleModels)
                {
                    modelids += "\"" + item.Id + "\",";
                }
                modelids = modelids.TrimEnd(',');
            }
            //string m_Brand = "";
            //string plateNum = "";
            //string m_NVehicleDetailType = "";

            using (MySql.Data.MySqlClient.MySqlConnection conn
                       = new MySql.Data.MySqlClient.MySqlConnection(string.Format(m_connString, RTRISServerIP, "rtrs_server_db")))
            {
                try
                {
                    string sql = "SELECT "
                                 + " info.ID, "
                                 + " info.CAMERA_CODE, "
                                 + " info.TIME_STAMP_SEC, "
                                 + " info.TIME_STAMP_MILLI_SEC, "
                                 + " info.OBJECT_TYPE, "
                                 + " info.RELIABILITY, "
                                 + " info.PLATE_NUM, "
                                 + " info.PLATE_NUM_ROW, "
                                 + " info.PLATE_COLOR, "
                                 + " info.VEHICLE_COLOR, "
                                 + " info.VEHICLE_TYPE, "
                                 + " info.VEHICLE_TYPE_DETAIL, "
                                 + " info.VEHICLE_LABEL, "
                                 + " info.VEHICLE_LABEL_DETAIL, "
                                 + " info.VEHICLE_SPEED, "
                                 + " info.DIRECTION, "
                                 + " info.ROAD_WAY_NUM, "
                                 + " info.PLATE_COORDX, "
                                 + " info.PLATE_COORDY, "
                                 + " info.PLATE_COORD_WIDTH, "
                                 + " info.PLATE_COORD_HEIGHT, "
                                 + " info.PLATE_IMG_SIZE, "
                                 + " info.PLAT_IMG_DATA, "
                                 + " info.VEHIBODY_COORDX, "
                                 + " info.VEHIBODY_COORDY, "
                                 + " info.VEHIBODY_COORD_WIDTH, "
                                 + " info.VEHIBODY_COORD_HEIGHT, "
                                 + " info.FULL_IMG_WIDTH, "
                                 + " info.FULL_IMG_HEIGHT, "
                                 + " info.COMPOSE_IMG_WIDTH, "
                                 + " info.COMPOSE_IMG_HEIGHT "
                                 + " FROM rt_vehicle_detect_info as info "
                                 + " WHERE info.TIME_STAMP_SEC BETWEEN \"" + startTime + "\" AND \"" + endTime + "\"";

                    if (!string.IsNullOrEmpty(cameras))
                    {
                        sql += " AND info.CAMERA_CODE in (" + cameras + ")";
                    }

                    if (vehicleColor != 0)
                    {
                        sql += " AND info.VEHICLE_COLOR = " + vehicleColor;
                    }

                    if (plateColor != 0)
                    {
                        sql += " AND info.PLATE_COLOR = " + plateColor;
                    }

                    if (m_Brand != -1)
                    {
                        sql += " AND info.VEHICLE_LABEL = " + m_Brand;
                    }

                    if (m_NVehicleDetailType != 0)
                    {
                        sql += " AND info.VEHICLE_TYPE_DETAIL = " + m_NVehicleDetailType;
                    }

                    if (!string.IsNullOrEmpty(modelids))
                    {
                        sql += " AND info.VEHICLE_LABEL_DETAIL in (" + modelids + ")";
                    }

                    if (!string.IsNullOrEmpty(plateNum))
                    {
                        sql += " AND info.PLATE_NUM like \"*" + plateNum + "*\"";
                    }

                    sql += " LIMIT " + (m_page++) * PAGE_PER_COUNT + "," + PAGE_PER_COUNT;

                    MyLog4Net.Container.Instance.Log.Debug("QueryData sql:" + sql);

                    conn.Open();
                    MySql.Data.MySqlClient.MySqlCommand    cmd    = new MySql.Data.MySqlClient.MySqlCommand(sql, conn);
                    MySql.Data.MySqlClient.MySqlDataReader reader = cmd.ExecuteReader();
                    DataTable table = new DataTable();
                    table.Load(reader);
                    conn.Close();


                    foreach (DataRow item in table.Rows)
                    {
                        PlateInfo info = new PlateInfo();
                        info.ID                   = Convert.ToUInt64(item["ID"].ToString());
                        info.CameraCode           = item["CAMERA_CODE"].ToString();
                        info.TimeStampSec         = DataModel.Common.ZEROTIME.AddSeconds(Convert.ToUInt32(item["TIME_STAMP_SEC"].ToString())).AddMilliseconds(Convert.ToUInt64(item["TIME_STAMP_MILLI_SEC"].ToString()));
                        info.ObjectType           = Convert.ToUInt32(item["OBJECT_TYPE"].ToString());
                        info.Reliability          = Convert.ToUInt32(item["RELIABILITY"].ToString());
                        info.PlateNum             = item["PLATE_NUM"].ToString();
                        info.PlateNumRow          = Convert.ToUInt32(item["PLATE_NUM_ROW"].ToString());
                        info.PlateColor           = Convert.ToUInt32(item["PLATE_COLOR"].ToString());
                        info.VehicleColor         = Convert.ToUInt32(item["VEHICLE_COLOR"].ToString());
                        info.VehicleType          = Convert.ToUInt32(item["VEHICLE_TYPE"].ToString());
                        info.VehicleTypeDetail    = Convert.ToUInt32(item["VEHICLE_TYPE_DETAIL"].ToString());
                        info.VehicleLabelID       = Convert.ToUInt32(item["VEHICLE_LABEL"].ToString());
                        info.VehicleLabelDetailID = Convert.ToUInt32(item["VEHICLE_LABEL_DETAIL"].ToString());
                        info.VehicleSpeed         = Convert.ToUInt32(item["VEHICLE_SPEED"].ToString());
                        info.Direction            = Convert.ToUInt32(item["DIRECTION"].ToString());
                        info.RoadWayNum           = Convert.ToUInt32(item["ROAD_WAY_NUM"].ToString());
                        info.PlateCoordRect       = new Rectangle(Convert.ToInt32(item["PLATE_COORDX"].ToString()), Convert.ToInt32(item["PLATE_COORDY"].ToString()), Convert.ToInt32(item["PLATE_COORD_WIDTH"].ToString()), Convert.ToInt32(item["PLATE_COORD_HEIGHT"].ToString()));

                        byte[] bytes3 = (byte[])item["PLAT_IMG_DATA"];
                        int    len3   = Convert.ToInt32(item["PLATE_IMG_SIZE"].ToString());
                        info.PlateImgData = IVX.DataModel.Common.GetImage(bytes3, len3);

                        info.VehiBodyCoordRect = new Rectangle(Convert.ToInt32(item["VEHIBODY_COORDX"].ToString()), Convert.ToInt32(item["VEHIBODY_COORDY"].ToString()), Convert.ToInt32(item["VEHIBODY_COORD_WIDTH"].ToString()), Convert.ToInt32(item["VEHIBODY_COORD_HEIGHT"].ToString()));
                        info.FullImgSize       = new Size(Convert.ToInt32(item["FULL_IMG_WIDTH"].ToString()), Convert.ToInt32(item["FULL_IMG_HEIGHT"].ToString()));
                        info.ComposeImgSize    = new Size(Convert.ToInt32(item["COMPOSE_IMG_WIDTH"].ToString()), Convert.ToInt32(item["COMPOSE_IMG_HEIGHT"].ToString()));

                        PlateDatas.Add(info);
                    }

                    return(PlateDatas);
                }
                catch (Exception ex)
                {
                    MyLog4Net.Container.Instance.Log.DebugWithDebugView("QueryPlateData sql error:" + ex.ToString());

                    //Framework.Container.Instance.InteractionService.ShowMessageBox("数据库失败", Framework.Environment.PROGRAM_NAME);
                    return(new List <PlateInfo>());
                }
            }
        }
        // @TODO: to rewrite ASAP!! just for test
        // I know, it it TOTAL MESS
        public void LoadFromDB(int entryorguid)
        {
            this.entryorguid = entryorguid;
            DBConnect connect = new DBConnect();
            bool      opened  = connect.OpenConnection();

            if (!opened)
            {
                return;
            }

            events.Clear();

            MySql.Data.MySqlClient.MySqlCommand      cmd        = connect.Query("SELECT * FROM conditions WHERE sourceentry = " + entryorguid + " and sourceid=0 and sourcetypeorreferenceid=22");
            Dictionary <int, List <SmartCondition> > conditions = new Dictionary <int, List <SmartCondition> >();

            using (MySql.Data.MySqlClient.MySqlDataReader reader = cmd.ExecuteReader())
            {
                int prevelsegroup = 0;
                while (reader.Read())
                {
                    int id = Convert.ToInt32(reader["sourcegroup"]) - 1;

                    if (!conditions.ContainsKey(id))
                    {
                        conditions.Add(id, new List <SmartCondition>());
                    }

                    if (Convert.ToInt32(reader["ElseGroup"]) != prevelsegroup)
                    {
                        conditions[id].Add(new CONDITION_LOGICAL_OR());
                    }

                    SmartCondition cond = SmartFactory.GetInstance().ConditionFactory(Convert.ToInt32(reader["ConditionTypeOrReference"]));
                    cond.UpdateParams(0, (Convert.ToInt32(reader["ConditionValue1"])));
                    cond.UpdateParams(1, (Convert.ToInt32(reader["ConditionValue2"])));
                    cond.UpdateParams(2, (Convert.ToInt32(reader["ConditionValue3"])));
                    cond.invert = (Convert.ToInt32(reader["NegativeCondition"]) == 1);


                    conditions[id].Add(cond);
                    prevelsegroup = Convert.ToInt32(reader["ElseGroup"]);
                }
            }

            cmd = connect.Query("SELECT * FROM smart_scripts WHERE source_type = " + (int)Type + " and entryorguid = " + entryorguid + " order by id");
            SmartEvent prev = null;
            bool       keep_legacy_comments       = false;
            bool       keep_lagacy_comments_asked = false;

            using (MySql.Data.MySqlClient.MySqlDataReader reader = cmd.ExecuteReader())
            {
                int next_link = -1;
                while (reader.Read())
                {
                    //(`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`)
                    int         id      = Convert.ToInt32(reader["id"]);
                    int         entry   = Convert.ToInt32(reader["entryorguid"]);
                    string      comment = Convert.ToString(reader["comment"]);
                    SmartAction a       = SmartFactory.GetInstance().ActionFactory(Convert.ToInt32(reader["action_type"]));
                    SmartTarget target  = SmartFactory.GetInstance().TargetFactory(Convert.ToInt32(reader["target_type"]));

                    for (int i = 0; i < 6; i++)
                    {
                        a.UpdateParams(i, Convert.ToInt32(reader["action_param" + (i + 1)]));
                    }

                    for (int i = 0; i < 3; i++)
                    {
                        target.UpdateParams(i, Convert.ToInt32(reader["target_param" + (i + 1)]));
                    }

                    target.position[0] = (float)Convert.ToDouble(reader["target_x"]);
                    target.position[1] = (float)Convert.ToDouble(reader["target_y"]);
                    target.position[2] = (float)Convert.ToDouble(reader["target_z"]);
                    target.position[3] = (float)Convert.ToDouble(reader["target_o"]);

                    a.Target = target;


                    if (comment.IndexOf(" // ") > -1)
                    {
                        a.Comment = comment.Substring(comment.IndexOf(" // ") + 4);
                    }
                    else if (!Properties.Settings.Default.DiscardLegacyComments)
                    {
                        if (!keep_lagacy_comments_asked)
                        {
                            DialogResult res =
                                PSTaskDialog.cTaskDialog.ShowTaskDialogBox("Legacy comments",
                                                                           "Legacy comments",
                                                                           "Visual SAI Studio has detected script you loaded doesn't have comments created with SAI Studio.\n",
                                                                           "",
                                                                           "",
                                                                           "Never propose keeping legacy comments",
                                                                           "",
                                                                           "Keep legacy comments|Discard legacy comments",
                                                                           PSTaskDialog.eTaskDialogButtons.Cancel,
                                                                           PSTaskDialog.eSysIcons.Question, PSTaskDialog.eSysIcons.Information);
                            if (PSTaskDialog.cTaskDialog.VerificationChecked)
                            {
                                Properties.Settings.Default.DiscardLegacyComments = true;
                            }
                            if (PSTaskDialog.cTaskDialog.CommandButtonResult == 0)
                            {
                                keep_legacy_comments = true;
                            }
                            keep_lagacy_comments_asked = true;
                        }

                        if (keep_legacy_comments)
                        {
                            a.Comment = comment;
                        }
                    }

                    if (id == next_link)
                    {
                        prev.AddAction(a);
                    }
                    else
                    {
                        SmartEvent ev = SmartFactory.GetInstance().EventFactory(Convert.ToInt32(reader["event_type"]));
                        ev.chance    = Convert.ToInt32(reader["event_chance"]);
                        ev.flags     = (SmartEventFlag)Convert.ToInt32(reader["event_flags"]);
                        ev.phasemask = (SmartPhaseMask)Convert.ToInt32(reader["event_phase_mask"]);
                        ev.UpdateParams(0, Convert.ToInt32(reader["event_param1"]));
                        ev.UpdateParams(1, Convert.ToInt32(reader["event_param2"]));
                        ev.UpdateParams(2, Convert.ToInt32(reader["event_param3"]));
                        ev.UpdateParams(3, Convert.ToInt32(reader["event_param4"]));
                        if (conditions.ContainsKey(id))
                        {
                            foreach (SmartCondition cond in conditions[id])
                            {
                                ev.AddCondition(cond);
                            }
                        }

                        ev.AddAction(a);
                        events.Add(ev);
                        prev = ev;
                    }


                    next_link = Convert.ToInt32(reader["link"]);
                }
            }
            connect.CloseConnection();
            scratch1.Refresh();
        }
Example #22
0
 /// <summary>
 /// Fills the object using the datareader
 /// </summary>
 /// <param name="dr"></param>
 public void Fill(MySql.Data.MySqlClient.MySqlDataReader dr)
 {
     ID        = dr.GetInt32("StatusID");
     Condition = dr.GetString("Status");
 }
Example #23
0
 public PersonRequest(MySql.Data.MySqlClient.MySqlDataReader reader)
 {
     this.person  = new PersonRequest.Person(reader);
     this.request = new Request(reader);
 }
Example #24
0
        private void addProduct()
        {
            String connS = System.Configuration.ConfigurationManager.ConnectionStrings["VideogameStore_String"].ToString();

            conn = new MySql.Data.MySqlClient.MySqlConnection(connS);
            conn.Open();
            String productName = productTextBox.Text;
            int    count       = Convert.ToInt32(qntTBox.Text);

            switch (ProductType.SelectedIndex)
            {
            case 1:
                query   = "SELECT COD_vdg , price , qnt FROM tbl_videogioco WHERE descr='" + productName + "';";
                command = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
                reader  = command.ExecuteReader();
                while (reader.HasRows && reader.Read())
                {
                    int count2 = reader.GetInt32(reader.GetOrdinal("qnt"));
                    if (count2 - count >= 0 || transType.SelectedIndex != 1)
                    {
                        codList.Items.Add(reader.GetInt32(reader.GetOrdinal("COD_vdg")).ToString());
                        nameList.Items.Add(productName);
                        qntList.Items.Add(count.ToString());
                        moneyList.Items.Add(reader.GetFloat(reader.GetOrdinal("price")).ToString());
                        typeList.Items.Add(ProductType.SelectedIndex.ToString());
                    }
                    else
                    {
                        Response.Write("<script>alert('Not enough copies')</script>");
                    }
                }
                if (!reader.HasRows)
                {
                    Response.Write("<script>alert('Product not found')</script>");
                }
                break;

            case 2:
                query   = "SELECT COD_cn , price , qnt FROM tbl_console WHERE descr='" + productName + "';";
                command = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
                reader  = command.ExecuteReader();
                while (reader.HasRows && reader.Read())
                {
                    int count2 = reader.GetInt32(reader.GetOrdinal("qnt"));
                    if (count2 - count >= 0 || transType.SelectedIndex != 1)
                    {
                        codList.Items.Add(reader.GetInt32(reader.GetOrdinal("COD_cn")).ToString());
                        nameList.Items.Add(productName);
                        qntList.Items.Add(count.ToString());
                        moneyList.Items.Add(reader.GetFloat(reader.GetOrdinal("price")).ToString());
                        typeList.Items.Add(ProductType.SelectedIndex.ToString());
                    }
                    else
                    {
                        Response.Write("<script>alert('Not enough copies')</script>");
                    }
                }
                if (!reader.HasRows)
                {
                    Response.Write("<script>alert('Product not found')</script>");
                }
                break;

            case 3:
                query   = "SELECT COD_ac , price , qnt FROM tbl_accessorio WHERE descr='" + productName + "';";
                command = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
                reader  = command.ExecuteReader();
                while (reader.HasRows && reader.Read())
                {
                    int count2 = reader.GetInt32(reader.GetOrdinal("qnt"));
                    if (count2 - count >= 0 || transType.SelectedIndex != 1)
                    {
                        codList.Items.Add(reader.GetInt32(reader.GetOrdinal("COD_ac")).ToString());
                        nameList.Items.Add(productName);
                        qntList.Items.Add(count.ToString());
                        moneyList.Items.Add(reader.GetFloat(reader.GetOrdinal("price")).ToString());
                        typeList.Items.Add(ProductType.SelectedIndex.ToString());
                    }
                    else
                    {
                        Response.Write("<script>alert('Not enough copies')</script>");
                    }
                }
                if (!reader.HasRows)
                {
                    Response.Write("<script>alert('Product not found')</script>");
                }
                break;
            }
            reader.Close();
            conn.Close();
        }
Example #25
0
        public IList FindGRNItemlistBySupplierDate(string find, int supID, DateTime trdate, IList grnIDS)
        {
            m_command.CommandText = SupplierInvoiceItem.GetGRNUseBySupplierInvoice();
            MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
            if (r.HasRows)
            {
                while (r.Read())
                {
                    int id = Convert.ToInt32(r[0]);
                    if (!grnIDS.Contains(id))
                    {
                        grnIDS.Add(id);
                    }
                }
            }
            r.Close();
            StringBuilder poisSB = new StringBuilder();

            foreach (int i in grnIDS)
            {
                poisSB.Append(i.ToString());
                poisSB.Append(',');
            }
            string pois = poisSB.ToString();

            pois = grnIDS.Count > 0 ? pois.Substring(0, pois.Length - 1) : "";
            if (find == "")
            {
                m_command.CommandText = GoodReceiveNoteItem.GetGRNItemBySuppDate(supID, trdate, pois);
            }
            else
            {
                m_command.CommandText = GoodReceiveNoteItem.GetSearchByPartAndGRNNo(find, supID, pois, trdate);
            }
            r = m_command.ExecuteReader();
            IList result = GoodReceiveNoteItem.TransformReaderList(r);

            r.Close();
            foreach (GoodReceiveNoteItem t in result)
            {
                m_command.CommandText = GoodReceiveNote.GetByIDSQL(t.EVENT.ID);
                r       = m_command.ExecuteReader();
                t.EVENT = GoodReceiveNote.TransformReader(r);
                r.Close();

                m_command.CommandText = Part.GetByIDSQLStatic(t.PART.ID);
                r      = m_command.ExecuteReader();
                t.PART = Part.GetPart(r);
                r.Close();

                m_command.CommandText = Unit.GetByIDSQLstatic(t.UNIT.ID);
                r      = m_command.ExecuteReader();
                t.UNIT = Unit.GetUnit(r);
                r.Close();

                m_command.CommandText = Warehouse.GetByIDSQLStatic(t.WAREHOUSE.ID);
                r           = m_command.ExecuteReader();
                t.WAREHOUSE = Warehouse.GetWarehouse(r);
                r.Close();

                m_command.CommandText = Unit.GetByIDSQLstatic(t.PART.UNIT.ID);
                r           = m_command.ExecuteReader();
                t.PART.UNIT = Unit.GetUnit(r);
                r.Close();
            }
            return(result);
        }
Example #26
0
        public void LoadAll()
        {
            CurrentAction(this, new LoadingEventArgs("quests"));
            dbString.Add(StorageType.Quest, new ClientDataDB <string>("LogTitle", "quest_template"));

            CurrentAction(this, new LoadingEventArgs("creatures"));
            dbString.Add(StorageType.Creature, new ClientDataDB <string>("entry", "name", "creature_template"));
            dbString.Add(StorageType.CreatureEntryWithAI, new ClientDataDB <string>("entry", "ScriptName", "creature_template", "AIName = \"SmartAI\""));

            //dbInt.Add(StorageType.CreatureGuid, new ClientDataDB<int>("guid", "entry", "creature"));



            MySql.Data.MySqlClient.MySqlCommand cmd = DBConnect.GetInstance().Query(String.Format("SELECT guid, concat(name, ' ', creature.id) as _name, count(source_type) as smartAI FROM creature left join smart_scripts on source_type=0 and entryorguid=(-guid) join creature_template on creature_template.entry=creature.id group by guid "));
            dbString.Add(StorageType.CreatureGuid, new ClientData <String>());
            dbString.Add(StorageType.CreatureGuidWithSAI, new ClientData <String>());
            if (cmd != null)
            {
                using (MySql.Data.MySqlClient.MySqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        dbString[StorageType.CreatureGuid].Set(Convert.ToInt32(reader["guid"]), Convert.ToString(reader["_name"]));
                        if (Convert.ToInt32(reader["smartAI"]) > 0)
                        {
                            dbString[StorageType.CreatureGuidWithSAI].Set(Convert.ToInt32(reader["guid"]), Convert.ToString(reader["_name"]));
                        }
                    }
                }
            }


            CurrentAction(this, new LoadingEventArgs("gameobjects"));
            dbString.Add(StorageType.GameObject, new ClientDataDB <string>("entry", "name", "gameobject_template"));
            dbString.Add(StorageType.GameObjectEntryWithAI, new ClientDataDB <string>("entry", "ScriptName", "gameobject_template", "AIName = \"SmartGameObjectAI\""));


            cmd = DBConnect.GetInstance().Query(String.Format("SELECT guid, concat(name, ' ', gameobject.id) as _name, count(source_type) as smartAI FROM gameobject left join smart_scripts on source_type=1 and entryorguid=(-guid) join gameobject_template on gameobject_template.entry=gameobject.id group by guid "));
            dbString.Add(StorageType.GameObjectGuid, new ClientData <String>());
            dbString.Add(StorageType.GameObjectGuidWithAI, new ClientData <String>());
            if (cmd != null)
            {
                using (MySql.Data.MySqlClient.MySqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        dbString[StorageType.GameObjectGuid].Set(Convert.ToInt32(reader["guid"]), Convert.ToString(reader["_name"]));
                        if (Convert.ToInt32(reader["smartAI"]) > 0)
                        {
                            dbString[StorageType.GameObjectGuidWithAI].Set(Convert.ToInt32(reader["guid"]), Convert.ToString(reader["_name"]));
                        }
                    }
                }
            }


            cmd = DBConnect.GetInstance().Query(String.Format("SELECT entryorguid FROM smart_scripts where source_type=9 group by entryorguid"));
            dbString.Add(StorageType.TimedActionList, new ClientData <String>());
            if (cmd != null)
            {
                using (MySql.Data.MySqlClient.MySqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        dbString[StorageType.TimedActionList].Set(Convert.ToInt32(reader["entryorguid"]), null);
                    }
                }
            }

            CurrentAction(this, new LoadingEventArgs("area triggers"));
            dbString.Add(StorageType.AreaTrigger, new ClientDataDBC("AreaTrigger.dbc",
                                                                    delegate(BinaryReader br, Dictionary <int, string> strings)
            {
                StringBuilder sb = new StringBuilder();
                br.ReadInt32();
                sb.Append("(");
                sb.Append(br.ReadSingle());
                sb.Append(", ");
                sb.Append(br.ReadSingle());
                sb.Append(", ");
                sb.Append(br.ReadSingle());
                sb.Append(")");
                return(sb.ToString());
            }
                                                                    ));
            dbString.Add(StorageType.AreaTriggerWithSAI, new ClientDataDB <string>("entry", "ScriptName", "areatrigger_scripts", "ScriptName = \"SmartTrigger\""));

            CurrentAction(this, new LoadingEventArgs("game events"));
            dbString.Add(StorageType.GameEvent, new ClientDataDB <string>("EventEntry", "description", "game_event"));



            Dictionary <String, DBCConfig> dbc_config = JsonConvert.DeserializeObject <Dictionary <String, DBCConfig> >(File.ReadAllText(@"data\dbc.json"));

            if (string.IsNullOrEmpty(Properties.Settings.Default.DBCVersion))
            {
                Properties.Settings.Default.DBCVersion = GuessDBCVersion(dbc_config);
                Properties.Settings.Default.Save();
            }

            if (!string.IsNullOrEmpty(Properties.Settings.Default.DBCVersion))
            {
                foreach (StorageType type in dbc_config[Properties.Settings.Default.DBCVersion].offsets.Keys)
                {
                    if (dbc_config[Properties.Settings.Default.DBCVersion].offsets[type].unsupported)
                    {
                        continue;
                    }
                    CurrentAction(this, new LoadingEventArgs(type.ToString()));

                    var config = dbc_config[Properties.Settings.Default.DBCVersion].offsets[type];
                    dbString.Add(type, new ClientDataDBC(config.file, config.idOffset, config.nameOffset, this));
                }
            }



            FinishedLoading(this, new EventArgs());
        }
Example #27
0
 public IEntity Get(MySql.Data.MySqlClient.MySqlDataReader aReader)
 {
     throw new NotImplementedException();
 }
Example #28
0
        public DashboardJson(int ID_UTILIZATOR, int ID_SOCIETATE, string conStr)
        {
            DataAccess da = new DataAccess(ID_UTILIZATOR, conStr, System.Data.CommandType.StoredProcedure, "DASHBOARDsp_select", new object[] { new MySql.Data.MySqlClient.MySqlParameter("_ID_SOCIETATE", ID_SOCIETATE), new MySql.Data.MySqlClient.MySqlParameter("_EXPIRATION_DAYS", 15) }); // TO DO: de adaugat parametru in setari !!!

            MySql.Data.MySqlClient.MySqlDataReader r = da.ExecuteSelectQuery();
            while (r.Read())
            {
                System.Data.IDataRecord dj = (System.Data.IDataRecord)r;
                try { this.DOSARE_TOTAL = Convert.ToInt32(dj["DOSARE_TOTAL"]); }
                catch { }
                try { this.DOSARE_CASCO_TOTAL = Convert.ToInt32(dj["DOSARE_CASCO_TOTAL"]); }
                catch { }
                try { this.DOSARE_RCA_TOTAL = Convert.ToInt32(dj["DOSARE_RCA_TOTAL"]); }
                catch { }

                // -- doar pt. Admin si Super --
                try { this.DOSARE_NEASIGNATE = Convert.ToInt32(dj["DOSARE_NEASIGNATE"]); }
                catch { }
                try { this.DOSARE_CASCO_NEASIGNATE = Convert.ToInt32(dj["DOSARE_CASCO_NEASIGNATE"]); }
                catch { }
                try { this.DOSARE_RCA_NEASIGNATE = Convert.ToInt32(dj["DOSARE_RCA_NEASIGNATE"]); }
                catch { }

                try { this.DOSARE_NEASIGNATE_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_NEASIGNATE_FROM_LAST_LOGIN"]); }
                catch { }
                try { this.DOSARE_NEASIGNATE_CASCO_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_NEASIGNATE_CASCO_FROM_LAST_LOGIN"]); }
                catch { }
                try { this.DOSARE_NEASIGNATE_RCA_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_NEASIGNATE_RCA_FROM_LAST_LOGIN"]); }
                catch { }

                // -- pt. All --
                try { this.DOSARE_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_FROM_LAST_LOGIN"]); }
                catch { }
                try { this.DOSARE_CASCO_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_CASCO_FROM_LAST_LOGIN"]); }
                catch { }
                try { this.DOSARE_RCA_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_RCA_FROM_LAST_LOGIN"]); }
                catch { }

                try { this.DOSARE_NEOPERATE = Convert.ToInt32(dj["DOSARE_NEOPERATE"]); }
                catch { this.DOSARE_NEOPERATE = 0; }
                try { this.DOSARE_CASCO_NEOPERATE = Convert.ToInt32(dj["DOSARE_CASCO_NEOPERATE"]); }
                catch { this.DOSARE_CASCO_NEOPERATE = 0; }
                try { this.DOSARE_RCA_NEOPERATE = Convert.ToInt32(dj["DOSARE_RCA_NEOPERATE"]); }
                catch { this.DOSARE_RCA_NEOPERATE = 0; }

                try { this.PROCESE_TOTAL = Convert.ToInt32(dj["PROCESE_TOTAL"]); }
                catch { this.PROCESE_TOTAL = 0; }
                try { this.PROCESE_RECLAMANT_TOTAL = Convert.ToInt32(dj["PROCESE_RECLAMANT_TOTAL"]); }
                catch { this.PROCESE_RECLAMANT_TOTAL = 0; }
                try { this.PROCESE_PARAT_TOTAL = Convert.ToInt32(dj["PROCESE_PARAT_TOTAL"]); }
                catch { this.PROCESE_PARAT_TOTAL = 0; }
                try { this.PROCESE_NOI_TOTAL = Convert.ToInt32(dj["PROCESE_NOI_TOTAL"]); }
                catch { this.PROCESE_NOI_TOTAL = 0; }

                /* -- PT. STATUS DOSARE -- */
                try { this.DOSARE_INCOMPLETE = Convert.ToInt32(dj["DOSARE_INCOMPLETE"]); }
                catch { this.DOSARE_INCOMPLETE = 0; }
                try { this.DOSARE_NEAVIZATE = Convert.ToInt32(dj["DOSARE_NEAVIZATE"]); }
                catch { this.DOSARE_NEAVIZATE = 0; }
                try { this.DOSARE_AVIZATE = Convert.ToInt32(dj["DOSARE_AVIZATE"]); }
                catch { this.DOSARE_AVIZATE = 0; }
                try { this.DOSARE_AVIZATE_NEEXPEDIATE = Convert.ToInt32(dj["DOSARE_AVIZATE_NEEXPEDIATE"]); }
                catch { this.DOSARE_AVIZATE_NEEXPEDIATE = 0; }
                try { this.DOSARE_NEACHITATE = Convert.ToInt32(dj["DOSARE_NEACHITATE"]); }
                catch { this.DOSARE_NEACHITATE = 0; }
                try { this.DOSARE_ACHITATE_PARTIAL = Convert.ToInt32(dj["DOSARE_ACHITATE_PARTIAL"]); }
                catch { this.DOSARE_ACHITATE_PARTIAL = 0; }
                try { this.DOSARE_ACHITATE = Convert.ToInt32(dj["DOSARE_ACHITATE"]); }
                catch { this.DOSARE_ACHITATE = 0; }
                try { this.DOSARE_AVIZATE_TOTAL = DOSARE_AVIZATE + DOSARE_NEACHITATE + DOSARE_ACHITATE_PARTIAL + DOSARE_ACHITATE; }
                catch { this.DOSARE_AVIZATE_TOTAL = 0; }

                try { this.DOSARE_FARA_DOCUMENTE = Convert.ToInt32(dj["DOSARE_FARA_DOCUMENTE"]); }
                catch { this.DOSARE_FARA_DOCUMENTE = 0; }
                try { this.DOSARE_FARA_PROCES = Convert.ToInt32(dj["DOSARE_FARA_PROCES"]); }
                catch { this.DOSARE_FARA_PROCES = 0; }
                /* --- */

                /* -- PENTRU TERMENE -- */
                try { this.TERMENE_IN_URMATOARELE_7_ZILE = Convert.ToInt32(dj["TERMENE_IN_URMATOARELE_7_ZILE"]); }
                catch { this.TERMENE_IN_URMATOARELE_7_ZILE = 0; }
                try { this.TERMENE_DEPASITE = Convert.ToInt32(dj["TERMENE_DEPASITE"]); }
                catch { this.TERMENE_DEPASITE = 0; }
                /* --- */

                /* -- PENTRU MESAJE -- */
                try { this.MESAJE_NOI = Convert.ToInt32(dj["MESAJE_NOI"]); }
                catch { }
                try { this.MESAJE_NOI_DOSAR_NOU = Convert.ToInt32(dj["MESAJE_NOI_DOSAR_NOU"]); }
                catch { }
                try { this.MESAJE_NOI_DOCUMENT_NOU = Convert.ToInt32(dj["MESAJE_NOI_DOCUMENT_NOU"]); }
                catch { }
                /* --- */

                break;
            }

            LABELS_STATUS = new List <string>()
            {
                socisaV2.Resources.DashboardResx.DOSARE_INCOMPLETE,
                socisaV2.Resources.DashboardResx.DOSARE_NEOPERATE,
                socisaV2.Resources.DashboardResx.DOSARE_AVIZATE_TOTAL
            };
            LABELS_STATUS_AVIZATE = new List <string>()
            {
                socisaV2.Resources.DashboardResx.DOSARE_AVIZATE,
                socisaV2.Resources.DashboardResx.DOSARE_NEACHITATE,
                socisaV2.Resources.DashboardResx.DOSARE_ACHITATE_PARTIAL,
                socisaV2.Resources.DashboardResx.DOSARE_ACHITATE
            };

            VALUES_STATUS = new List <int>()
            {
                DOSARE_INCOMPLETE,
                DOSARE_NEAVIZATE,
                DOSARE_AVIZATE_TOTAL
            };
            VALUES_STATUS_AVIZATE = new List <int>()
            {
                DOSARE_AVIZATE,
                DOSARE_NEACHITATE,
                DOSARE_ACHITATE_PARTIAL,
                DOSARE_ACHITATE
            };
            r.Close(); r.Dispose(); da.CloseConnection();
        }
Example #29
0
 public virtual IList GetAll(MySql.Data.MySqlClient.MySqlDataReader aReader)
 {
     throw new NotImplementedException();
 }
Example #30
0
        private void importar()
        {
            label1.Text    = "Iniciando Importação. Aguarde";
            label1.Visible = true;

            Cursor.Current = Cursors.WaitCursor;
            Application.DoEvents();

            limpaTabelas();
            label1.Text = "Dados locais apagados";
            Application.DoEvents();

            //abre conexao
            try
            {
                myconn = new MySql.Data.MySqlClient.MySqlConnection(strconn);
                myconn.Open();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Não foi possível conectar ao servidor, verifique a sua conexão com a internet.");
                return;
            }

            if (myconn.State == ConnectionState.Open)
            {
                Cursor.Current = Cursors.WaitCursor;
                Application.DoEvents();
                //inicia a transacao
                MySql.Data.MySqlClient.MySqlCommand mycommand = myconn.CreateCommand();
                mycommand.Connection  = myconn;
                mycommand.CommandText =
                    "SELECT `tipo_luminaria`.`id`, " +
                    "`tipo_luminaria`.`descricao` " +
                    "FROM `eletrocad`.`tipo_luminaria`";
                //mycommand.Parameters.Clear();
                //mycommand.Parameters.AddWithValue("estado", cbEstado.Text);
                //mycommand.Parameters.AddWithValue("ano", txtAno.Value);

                try
                {
                    MySql.Data.MySqlClient.MySqlDataReader reader = mycommand.ExecuteReader();
                    while (reader.Read())
                    {
                        //
                        //insere nova programação
                        db.eletrocadDataSet.tipo_luminariaRow pipRow;
                        pipRow           = eletrocadDataSet.tipo_luminaria.Newtipo_luminariaRow();
                        pipRow.id        = reader.GetInt32("id");
                        pipRow.descricao = reader.GetString("descricao");

                        eletrocadDataSet.tipo_luminaria.Rows.Add(pipRow);
                    }
                    tipo_luminariaTableAdapter.Update(eletrocadDataSet.tipo_luminaria);
                    eletrocadDataSet.tipo_luminaria.AcceptChanges();
                    tipo_luminariaTableAdapter.Fill(eletrocadDataSet.tipo_luminaria);

                    reader.Close();

                    Cursor.Current = Cursors.Default;
                    Application.DoEvents();
                    MessageBox.Show("Informações recuperadas com sucesso");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Não foi possível importar: " + ex.Message);
                }
                finally
                {
                    //myconn.Close();
                }
            }
            myconn.Close();
            label1.Visible = false;
            Cursor.Current = Cursors.Default;
            Application.DoEvents();
        }
 /// <summary>
 /// Creates the object from the locationDB
 /// </summary>
 /// <returns>The object.</returns>
 /// <param name="reader">Reader.</param>
 public static Campus createObject(MySql.Data.MySqlClient.MySqlDataReader reader)
 {
     return(new Campus(int.Parse(reader["ID"].ToString()), reader["name"].ToString(), double.Parse(reader["north"].ToString()), double.Parse(reader["east"].ToString()), double.Parse(reader["south"].ToString()), double.Parse(reader["west"].ToString())));
 }
        /// <summary>
        /// Transfere dados do banco de dados atual para um banco de dados de destino.
        /// Conexão com o banco de destino precisa estar aberta.
        /// </summary>
        /// <returns>Número de linhas transferidas.</returns>
        /// <param name="p_query">Consulta SQL para buscar os dados no banco atual.</param>
        /// <param name="p_table">Nome da tabela de destino.</param>
        /// <param name="p_insert">Comando de inserção para inserir cada linha no banco de destino.</param>
        /// <param name="p_destdatabase">Conexão com o banco de destino.</param>
        /// <param name="p_log">Log de inserção.</param>
        /// <param name='p_startrow'>Número da linha inicial.</param>
        /// <param name='p_endrow'>Número da linha final.</param>
        /// <param name='p_hasmoredata'>Indica se ainda há mais dados a serem lidos.</param>
        public override uint Transfer(string p_query, string p_table, Spartacus.Database.Command p_insert, Spartacus.Database.Generic p_destdatabase, ref string p_log, uint p_startrow, uint p_endrow, out bool p_hasmoredata)
        {
            uint v_transfered = 0;
            System.Collections.ArrayList v_rows = new System.Collections.ArrayList();

            try
            {
                if (this.v_reader == null)
                {
                    this.v_cmd.CommandText = p_query;
                    this.v_reader = this.v_cmd.ExecuteReader();
                    this.v_currentrow = 0;
                }

                p_hasmoredata = false;
                while (v_reader.Read())
                {
                    p_hasmoredata = true;

                    if (this.v_currentrow >= p_startrow && this.v_currentrow <= p_endrow)
                    {
                        for (int i = 0; i < v_reader.FieldCount; i++)
                            p_insert.SetValue(this.FixColumnName(v_reader.GetName(i)).ToLower(), v_reader[i].ToString());

                        v_rows.Add(p_insert.GetUpdatedText());

                        v_transfered++;
                    }

                    this.v_currentrow++;

                    if (this.v_currentrow > p_endrow)
                        break;
                }

                if (! p_hasmoredata)
                {
                    this.v_reader.Close();
                    this.v_reader = null;
                }
                else
                {
                    try
                    {
                        p_destdatabase.InsertBlock(p_table, v_rows);
                    }
                    catch (Spartacus.Database.Exception e)
                    {
                        p_log += e.v_message + "\n";
                    }
                }

                return v_transfered;
            }
            catch (MySql.Data.MySqlClient.MySqlException e)
            {
                throw new Spartacus.Database.Exception(e);
            }
        }
 internal LoginModel(MySql.Data.MySqlClient.MySqlDataReader dr)
 {
     Fill(dr);
 }
        /// <summary>
        /// Realiza uma consulta no banco de dados, armazenando os dados de retorno em um <see cref="System.Data.DataTable"/>.
        /// </summary>
        /// <param name='p_sql'>
        /// Código SQL a ser consultado no banco de dados.
        /// </param>
        /// <param name='p_tablename'>
        /// Nome virtual da tabela onde deve ser armazenado o resultado, para fins de cache.
        /// </param>
        /// <param name='p_progress'>Evento de progresso da execução da consulta.</param>
        /// <returns>Retorna uma <see cref="System.Data.DataTable"/> com os dados de retorno da consulta.</returns>
        public override System.Data.DataTable Query(string p_sql, string p_tablename, Spartacus.Utils.ProgressEventClass p_progress)
        {
            System.Data.DataTable v_table = null;
            System.Data.DataRow v_row;
            uint v_counter = 0;

            p_progress.FireEvent(v_counter);

            if (this.v_con == null)
            {
                try
                {
                    this.v_con = new MySql.Data.MySqlClient.MySqlConnection(this.v_connectionstring);
                    this.v_con.Open();
                    this.v_cmd = new MySql.Data.MySqlClient.MySqlCommand(p_sql, this.v_con);
                    this.v_reader = this.v_cmd.ExecuteReader();

                    v_table = new System.Data.DataTable(p_tablename);
                    for (int i = 0; i < v_reader.FieldCount; i++)
                        v_table.Columns.Add(this.FixColumnName(this.v_reader.GetName(i)), typeof(string));

                    while (this.v_reader.Read())
                    {
                        v_row = v_table.NewRow();
                        for (int i = 0; i < this.v_reader.FieldCount; i++)
                            v_row[i] = this.v_reader[i].ToString();
                        v_table.Rows.Add(v_row);

                        v_counter++;
                        p_progress.FireEvent(v_counter);
                    }

                    return v_table;
                }
                catch (MySql.Data.MySqlClient.MySqlException e)
                {
                    throw new Spartacus.Database.Exception(e);
                }
                finally
                {
                    if (this.v_reader != null)
                    {
                        this.v_reader.Close();
                        this.v_reader = null;
                    }
                    if (this.v_cmd != null)
                    {
                        this.v_cmd.Dispose();
                        this.v_cmd = null;
                    }
                    if (this.v_con != null)
                    {
                        this.v_con.Close();
                        this.v_con = null;
                    }
                }
            }
            else
            {
                try
                {
                    this.v_cmd.CommandText = p_sql;
                    this.v_reader = this.v_cmd.ExecuteReader();

                    v_table = new System.Data.DataTable(p_tablename);
                    for (int i = 0; i < v_reader.FieldCount; i++)
                        v_table.Columns.Add(this.FixColumnName(this.v_reader.GetName(i)), typeof(string));

                    while (this.v_reader.Read())
                    {
                        v_row = v_table.NewRow();
                        for (int i = 0; i < this.v_reader.FieldCount; i++)
                            v_row[i] = this.v_reader[i].ToString();
                        v_table.Rows.Add(v_row);

                        v_counter++;
                        p_progress.FireEvent(v_counter);
                    }

                    return v_table;
                }
                catch (MySql.Data.MySqlClient.MySqlException e)
                {
                    throw new Spartacus.Database.Exception(e);
                }
                finally
                {
                    if (this.v_reader != null)
                    {
                        this.v_reader.Close();
                        this.v_reader = null;
                    }
                }
            }
        }
Example #35
0
        public IList FindPRForAPDebitNote(string find, int supID, DateTime trdate, IList added)
        {
            m_command.CommandText = APDebitNoteItem.GetPRUsedByAPDN();
            MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
            if (r.HasRows)
            {
                while (r.Read())
                {
                    int id = Convert.ToInt32(r[0]);
                    if (!added.Contains(id))
                    {
                        added.Add(id);
                    }
                }
            }
            r.Close();
            StringBuilder poisSB = new StringBuilder();

            foreach (int i in added)
            {
                poisSB.Append(i.ToString());
                poisSB.Append(',');
            }
            string pois = poisSB.ToString();

            pois = added.Count > 0 ? pois.Substring(0, pois.Length - 1) : "";

            m_command.CommandText = PurchaseReturn.GetSearchPRNoForAPDN(find, supID, pois, trdate);
            r = m_command.ExecuteReader();
            IList result = PurchaseReturn.TransformReaderList(r);

            r.Close();
            foreach (PurchaseReturn p in result)
            {
                m_command.CommandText = PurchaseReturnItem.GetByEventIDSQL(p.ID);
                r             = m_command.ExecuteReader();
                p.EVENT_ITEMS = PurchaseReturnItem.TransformReaderList(r);
                r.Close();

                foreach (PurchaseReturnItem t in p.EVENT_ITEMS)
                {
                    if ((t.GRN_ITEM == null) && (t.GRN_ITEM.ID == 0))
                    {
                        continue;
                    }


                    m_command.CommandText = GoodReceiveNoteItem.GetByIDSQL(t.GRN_ITEM.ID);
                    r          = m_command.ExecuteReader();
                    t.GRN_ITEM = GoodReceiveNoteItem.TransformReader(r);
                    r.Close();

                    if ((t.GRN_ITEM.PO_ITEM == null))
                    {
                        continue;
                    }
                    if (t.GRN_ITEM.PO_ITEM.ID == 0)
                    {
                        continue;
                    }

                    m_command.CommandText = PurchaseOrderItem.GetByIDSQL(t.GRN_ITEM.PO_ITEM.ID);
                    r = m_command.ExecuteReader();
                    t.GRN_ITEM.PO_ITEM = PurchaseOrderItem.TransformReader(r);
                    r.Close();

                    t.GRN_ITEM.PART = PartRepository.GetByID(m_command, t.GRN_ITEM.PART.ID);
                    t.GRN_ITEM.PART.UNIT_CONVERSION_LIST = PartRepository.GetUnitConversionsStatic(m_command, t.GRN_ITEM.PO_ITEM.PART.ID);
                    t.PART = t.GRN_ITEM.PO_ITEM.PART = t.GRN_ITEM.PART;

                    double subamount = (t.GRN_ITEM.PO_ITEM.SUBTOTAL / t.GRN_ITEM.PO_ITEM.GetAmountInSmallestUnit()) * t.GetAmountInSmallestUnit();
                    p.TOTAL_AMOUNT_FROM_PO += subamount;

                    t.GRN_ITEM.PO_ITEM.EVENT = PurchaseOrderRepository.GetHeaderOnly(m_command, t.GRN_ITEM.PO_ITEM.EVENT.ID);
                    p.CURRENCY = ((PurchaseOrder)t.GRN_ITEM.PO_ITEM.EVENT).CURRENCY;
                }
            }
            return(result);
        }
        /// <summary>
        /// Realiza uma consulta no banco de dados, armazenando os dados de retorno em uma string HTML.
        /// </summary>
        /// <param name='p_sql'>
        /// Código SQL a ser consultado no banco de dados.
        /// </param>
        /// <param name='p_id'>
        /// ID da tabela no HTML.
        /// </param>
        /// <param name='p_options'>
        /// Opções da tabela no HTML.
        /// </param>
        public override string QueryHtml(string p_sql, string p_id, string p_options)
        {
            string v_html;

            if (this.v_con == null)
            {
                try
                {
                    this.v_con = new MySql.Data.MySqlClient.MySqlConnection(this.v_connectionstring);
                    this.v_con.Open();
                    this.v_cmd = new MySql.Data.MySqlClient.MySqlCommand(p_sql, this.v_con);
                    this.v_reader = this.v_cmd.ExecuteReader();

                    v_html = "<table id='" + p_id + "' " + p_options + "><thead><tr>";

                    for (int i = 0; i < v_reader.FieldCount; i++)
                        v_html += "<th>" + this.FixColumnName(this.v_reader.GetName(i)) + "</th>";

                    v_html += "</tr></thead><tbody>";

                    while (this.v_reader.Read())
                    {
                        v_html += "<tr>";
                        for (int i = 0; i < this.v_reader.FieldCount; i++)
                            v_html += "<td>" + this.v_reader[i].ToString() + "</td>";
                        v_html += "</tr>";
                    }

                    v_html += "</tbody></table>";

                    return v_html;
                }
                catch (MySql.Data.MySqlClient.MySqlException e)
                {
                    throw new Spartacus.Database.Exception(e);
                }
                finally
                {
                    if (this.v_reader != null)
                    {
                        this.v_reader.Close();
                        this.v_reader = null;
                    }
                    if (this.v_cmd != null)
                    {
                        this.v_cmd.Dispose();
                        this.v_cmd = null;
                    }
                    if (this.v_con != null)
                    {
                        this.v_con.Close();
                        this.v_con = null;
                    }
                }
            }
            else
            {
                try
                {
                    this.v_cmd.CommandText = p_sql;
                    this.v_reader = this.v_cmd.ExecuteReader();

                    v_html = "<table id='" + p_id + "' " + p_options + "><thead><tr>";

                    for (int i = 0; i < v_reader.FieldCount; i++)
                        v_html += "<th>" + this.FixColumnName(this.v_reader.GetName(i)) + "</th>";

                    v_html += "</tr></thead><tbody>";

                    while (this.v_reader.Read())
                    {
                        v_html += "<tr>";
                        for (int i = 0; i < this.v_reader.FieldCount; i++)
                            v_html += "<td>" + this.v_reader[i].ToString() + "</td>";
                        v_html += "</tr>";
                    }

                    v_html += "</tbody></table>";

                    return v_html;
                }
                catch (MySql.Data.MySqlClient.MySqlException e)
                {
                    throw new Spartacus.Database.Exception(e);
                }
                finally
                {
                    if (this.v_reader != null)
                    {
                        this.v_reader.Close();
                        this.v_reader = null;
                    }
                }
            }
        }
Example #37
0
        protected void submitEventMethod(object sender, EventArgs e)
        {
            List <String> saltHashList = null;
            List <String> namesList    = null;

            try
            {
                String connString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString();

                conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
                conn.Open();
                queryStr = "SELECT customerID, slowHashSalt, cust_first_name, cust_last_name FROM webapp.customer WHERE cust_username=?uname";

                cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
                cmd.Parameters.AddWithValue("?uname", tb_username.Text);
                reader = cmd.ExecuteReader();

                if (!reader.HasRows)
                {
                    lb_invalid.Text = "Wrong username and/or password";
                }

                while (reader.HasRows && reader.Read())
                {
                    if (saltHashList == null)
                    {
                        saltHashList = new List <String>();
                        namesList    = new List <String>();
                    }

                    String saltHashes = reader.GetString(reader.GetOrdinal("slowHashSalt"));
                    saltHashList.Add(saltHashes);

                    String fullName = reader.GetString(reader.GetOrdinal("cust_first_name")) + " " + reader.GetString(reader.GetOrdinal("cust_last_name"));
                    namesList.Add(fullName);
                }

                if (saltHashList != null)
                {
                    for (int i = 0; i < saltHashList.Count; i++)
                    {
                        queryStr = "";
                        bool validUser = PasswordStorage.VerifyPassword(tb_password.Text, saltHashList[i]);
                        if (validUser == true)
                        {
                            int customerId = reader.GetInt32(reader.GetOrdinal("customerID"));
                            Session["uname"]      = namesList[i];
                            Response.BufferOutput = true;
                            Response.Redirect($"CustomerManageBooking.aspx?customerId={customerId}&barberId=0", false);
                        }
                        else
                        {
                            lb_invalid.Text = "Wrong username and/or password";
                        }
                    }
                }

                reader.Close();
            }
            catch (Exception ex)
            {
                lb_invalid.Text = ex.ToString();
            }
        }
        /// <summary>
        /// Transfere dados do banco de dados atual para um banco de dados de destino.
        /// Conexão com o banco de destino precisa estar aberta.
        /// </summary>
        /// <returns>Número de linhas transferidas.</returns>
        /// <param name="p_query">Consulta SQL para buscar os dados no banco atual.</param>
        /// <param name="p_insert">Comando de inserção para inserir cada linha no banco de destino.</param>
        /// <param name="p_destdatabase">Conexão com o banco de destino.</param>
        public override uint Transfer(string p_query, Spartacus.Database.Command p_insert, Spartacus.Database.Generic p_destdatabase)
        {
            uint v_transfered = 0;

            if (this.v_con == null)
            {
                try
                {
                    this.v_con = new MySql.Data.MySqlClient.MySqlConnection(this.v_connectionstring);
                    this.v_con.Open();
                    this.v_cmd = new MySql.Data.MySqlClient.MySqlCommand(p_query, this.v_con);
                    this.v_reader = this.v_cmd.ExecuteReader();

                    while (v_reader.Read())
                    {
                        for (int i = 0; i < v_reader.FieldCount; i++)
                            p_insert.SetValue(this.FixColumnName(v_reader.GetName(i)).ToLower(), v_reader[i].ToString());

                        p_destdatabase.Execute(p_insert.GetUpdatedText());
                        v_transfered++;
                    }

                    return v_transfered;
                }
                catch (MySql.Data.MySqlClient.MySqlException e)
                {
                    throw new Spartacus.Database.Exception(e);
                }
                finally
                {
                    if (this.v_reader != null)
                    {
                        this.v_reader.Close();
                        this.v_reader = null;
                    }
                    if (this.v_cmd != null)
                    {
                        this.v_cmd.Dispose();
                        this.v_cmd = null;
                    }
                    if (this.v_con != null)
                    {
                        this.v_con.Close();
                        this.v_con = null;
                    }
                }
            }
            else
            {
                try
                {
                    this.v_cmd.CommandText = p_query;
                    this.v_reader = this.v_cmd.ExecuteReader();

                    while (v_reader.Read())
                    {
                        for (int i = 0; i < v_reader.FieldCount; i++)
                            p_insert.SetValue(this.FixColumnName(v_reader.GetName(i)).ToLower(), v_reader[i].ToString());

                        p_destdatabase.Execute(p_insert.GetUpdatedText());
                        v_transfered++;
                    }

                    return v_transfered;
                }
                catch (MySql.Data.MySqlClient.MySqlException e)
                {
                    throw new Spartacus.Database.Exception(e);
                }
                finally
                {
                    if (this.v_reader != null)
                    {
                        this.v_reader.Close();
                        this.v_reader = null;
                    }
                }
            }
        }
Example #39
0
 /// <summary>
 /// Fills the object from the datareader
 /// </summary>
 /// <param name="dr"></param>
 public void Fill(MySql.Data.MySqlClient.MySqlDataReader dr)
 {
     ID          = dr.GetInt32("NoteID");
     Description = dr.GetString("Description");
     DateCreated = dr.GetDateTime("DateCreated");
 }