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(); } }
internal Asset(MySql.Data.MySqlClient.MySqlDataReader dr) { Fill(dr); }
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); }
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(); } }
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(); } }
public Status(MySql.Data.MySqlClient.MySqlDataReader dr) { Fill(dr); }
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); } }
internal Role(MySql.Data.MySqlClient.MySqlDataReader dr) { Fill(dr); }
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; }
public Ticket(MySql.Data.MySqlClient.MySqlDataReader dr) { Fill(dr); }
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"); }
/// <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"); }
/// <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(); }
/// <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"); }
public PersonRequest(MySql.Data.MySqlClient.MySqlDataReader reader) { this.person = new PersonRequest.Person(reader); this.request = new Request(reader); }
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(); }
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); }
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()); }
public IEntity Get(MySql.Data.MySqlClient.MySqlDataReader aReader) { throw new NotImplementedException(); }
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(); }
public virtual IList GetAll(MySql.Data.MySqlClient.MySqlDataReader aReader) { throw new NotImplementedException(); }
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; } } } }
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; } } } }
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; } } } }
/// <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"); }