public static UserInfo get(double id)
{
UserInfo value = new UserInfo();
MySqlDataReader rs = Sql.ExecuteReader("select id,uname,status,createdate,updatedate,email,mobile,phone,icon,filteringIP,sex,classId,cash from m_admin where id=@id", new MySqlParameter[] { new MySqlParameter("id", id) });
if (rs.Read())
{
value.id = rs.GetDouble(0);
value.username = rs[1].ToString();
value.classId = rs.GetDouble(11);
value.status = rs.GetInt32(2);
value.createdate = rs.GetDateTime(3);
value.updatedate = rs.GetDateTime(4);
value.email = rs[5] + "";
value.mobile = rs[6] + "";
value.phone = rs[7] + "";
value.icon = rs[8] + "";
value.filteringIP = rs[9] + "";
value.sex = rs.IsDBNull(10) ? true : rs.GetBoolean(10);
value.cash = rs.IsDBNull(12) ? 0 : rs.GetInt32(12);
}
rs.Close();
if (value.id < 1)
{
return(null);
}
rs = Sql.ExecuteReader("select roleId from admin_role where userId=@id", new MySqlParameter[] { new MySqlParameter("id", id) });
string roleId = "";
while (rs.Read())
{
if (roleId != "")
{
roleId += ",";
}
roleId += rs.GetDouble(0);
value.role = roleId;
}
rs.Close();
return(value);
}
private RegionSettings ToRegionSettings(MySqlDataReader reader) => new RegionSettings
{
BlockTerraform = reader.GetBool("BlockTerraform"),
BlockFly = reader.GetBool("BlockFly"),
AllowDamage = reader.GetBool("AllowDamage"),
RestrictPushing = reader.GetBool("RestrictPushing"),
AllowLandResell = reader.GetBool("AllowLandResell"),
AllowLandJoinDivide = reader.GetBool("AllowLandJoinDivide"),
BlockShowInSearch = reader.GetBool("BlockShowInSearch"),
AgentLimit = reader.GetInt32("AgentLimit"),
ObjectBonus = reader.GetDouble("ObjectBonus"),
DisableScripts = reader.GetBool("DisableScripts"),
DisableCollisions = reader.GetBool("DisableCollisions"),
BlockFlyOver = reader.GetBool("BlockFlyOver"),
Sandbox = reader.GetBool("Sandbox"),
TerrainTexture1 = reader.GetUUID("TerrainTexture1"),
TerrainTexture2 = reader.GetUUID("TerrainTexture2"),
TerrainTexture3 = reader.GetUUID("TerrainTexture3"),
TerrainTexture4 = reader.GetUUID("TerrainTexture4"),
TelehubObject = reader.GetUUID("TelehubObject"),
Elevation1NW = reader.GetDouble("Elevation1NW"),
Elevation2NW = reader.GetDouble("Elevation2NW"),
Elevation1NE = reader.GetDouble("Elevation1NE"),
Elevation2NE = reader.GetDouble("Elevation2NE"),
Elevation1SE = reader.GetDouble("Elevation1SE"),
Elevation2SE = reader.GetDouble("Elevation2SE"),
Elevation1SW = reader.GetDouble("Elevation1SW"),
Elevation2SW = reader.GetDouble("Elevation2SW"),
WaterHeight = reader.GetDouble("WaterHeight"),
TerrainRaiseLimit = reader.GetDouble("TerrainRaiseLimit"),
TerrainLowerLimit = reader.GetDouble("TerrainLowerLimit"),
SunPosition = reader.GetDouble("SunPosition"),
IsSunFixed = reader.GetBoolean("IsSunFixed"),
UseEstateSun = reader.GetBool("UseEstateSun"),
BlockDwell = reader.GetBool("BlockDwell"),
ResetHomeOnTeleport = reader.GetBool("ResetHomeOnTeleport"),
AllowLandmark = reader.GetBool("AllowLandmark"),
AllowDirectTeleport = reader.GetBool("AllowDirectTeleport"),
MaxBasePrims = reader.GetInt32("MaxBasePrims"),
WalkableCoefficientsSerialization = reader.GetBytes("WalkableCoefficientsData")
};
// If Not the teacher wants to log in
private void StudentLogin()
{
if (cc.IfLogin())
{
try
{
_command = new MySqlCommand();
_command.Connection = cc.connection;
_command.CommandText = "SELECT tanulo.id, tanulo.nev, tanulo.kurzus_id, tanulo.felh, tanulo.jelszo, tanulo.tema, tanulo.telsz, tanulo.email, tanulo.belephet FROM tanulo WHERE tanulo.felh = '" + TxtUsername.Text + "' AND tanulo.jelszo = '" + pass.Coding(TxtPassword.Text) + "' ";
_command.ExecuteNonQuery();
_reader = _command.ExecuteReader();
_reader.Read();
if (_reader.HasRows)
{
if (_reader.GetBoolean(8))
{
new Student(new User(_reader.GetInt32(0), _reader.GetString(1), _reader.GetInt32(2), _reader.GetString(3), _reader.GetString(4), _reader.GetString(5), _reader.GetString(6), _reader.GetString(7)), this).Show();
Hide();
}
else
{
LblLoginError.Text += "A felhasználód jelenleg nem elérhető! \n";
}
}
else
{
LblLoginError.Text += "Érvénytelen adatok! \n";
}
_reader.Close();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cc.connection.Close();
}
}
}
public ShoppingCart GetShoppingCart(string userName)
{
try {
ShoppingCart ans = new ShoppingCart();
string sql = " SELECT * FROM UserCart where userName = '******';";
LinkedList <UserCart> ucs = new LinkedList <UserCart>();
MySqlCommand cmd = new MySqlCommand(sql, con);
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int saleId = reader.GetInt32("saleId");
int amount = reader.GetInt32("amount");
double offer = reader.GetDouble("offer");
Boolean couponActivated = reader.GetBoolean("couponActivated");
double price = reader.GetDouble("price");
double priceAfterDiscount = reader.GetDouble("priceAfterDiscount");
UserCart uc = new UserCart(userName, saleId, amount);
uc.Offer = offer;
uc.CouponActivated = couponActivated;
uc.Price = price;
uc.PriceAfterDiscount = priceAfterDiscount;
ucs.AddLast(uc);
}
con.Close();
ans.products = ucs;
return(ans);
}
catch (Exception e)
{
con.Close();
throw new Exception("DB ERROR");
}
}
public override LinkedList <User> Get()
{
try
{
string sql = " SELECT * FROM User";
LinkedList <User> users = new LinkedList <User>();
MySqlCommand cmd = new MySqlCommand(sql, con);
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int state = reader.GetInt32("state");
string userName = reader.GetString("userName");
string password = reader.GetString("password");
Boolean isActive = reader.GetBoolean("isActive");
User u = new User(userName, password);
u.setIsActive(isActive);
if (state == 2)
{
u.setState(new LogedIn());
}
else if (state == 3)
{
u.setState(new Admin());
}
users.AddLast(u);
}
con.Close();
foreach (User u in users)
{
u.shoppingCart = GetShoppingCart(u.userName);
}
return(users);
}
catch (Exception e)
{
con.Close();
throw new Exception("DB ERROR");
}
}
private List <Product> search()
{
List <Product> list = new List <Product>();
connection = new MySqlConnection(connString);
try
{
connection.Open();
command = new MySqlCommand(sql, connection);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
Product pro = new Product();
pro.ID = dataReader.GetInt32(0);
pro.BusinessPlanId = dataReader.GetInt32(1);
pro.ProductType = dataReader.GetBoolean(2);
pro.Name = dataReader.GetString(3);
pro.Directed_to = dataReader.GetString(4);
pro.Innovation_factor = dataReader.GetString(5);
pro.Technology = dataReader.GetString(6);
pro.License = dataReader.GetString(7);
pro.Competition = dataReader.GetString(8);
pro.Price = dataReader.GetInt32(9);
pro.Description = dataReader.GetString(10);
pro.Copyright = dataReader.GetString(11);
pro.ProductCost = dataReader.GetInt32(12);
pro.NumProduct = dataReader.GetInt32(13);
pro.PercentageIncome = dataReader.GetInt32(14);
list.Add(pro);
}
dataReader.Close();
command.Dispose();
connection.Close();
}
catch (Exception ex)
{
return(null);
}
return(list);
}
public List <Categoria> GetCategoria()
{
List <Categoria> list = new List <Categoria>();
try
{
db.Open();
string consulta = "sp_EliminarProducto";
MySqlCommand comm = new MySqlCommand(consulta, db);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@_id", "");
MySqlDataReader rd = comm.ExecuteReader();
if (rd.HasRows)
{
while (rd.Read())
{
list.Add(new Categoria
{
Id = rd.GetInt32(0),
StrCategoria = rd.GetString(1),
BitEstatus = rd.GetBoolean(4)
});
}
}
else
{
throw new Exception("No hay registros");
}
db.Close();
}
catch (Exception ex)
{
throw new Exception("Error", ex);
}
db.Close();
return(list);
}
public List <Task> GetAll(int ID)
{
List <Task> tasks = new List <Task>();
Dictionary <string, string> parameters = new Dictionary <string, string>
{
{ "@id", ID.ToString() }
};
MySqlDataReader dataReader = mySQLConnector.GetData("SELECT * FROM tasks WHERE section_id = @id", parameters);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
int id = dataReader.IsDBNull(0) ? 0 : dataReader.GetInt16("id");
int parent_task_id = dataReader.IsDBNull(1) ? 0 : dataReader.GetInt16("parent_task_id");
int requires_task_id = dataReader.IsDBNull(2) ? 0 : dataReader.GetInt16("requires_task_id");
int section_id = dataReader.IsDBNull(3) ? 0 : dataReader.GetInt16("section_id");
int user_id = dataReader.IsDBNull(4) ? 0 : dataReader.GetInt16("user_id");
string name = dataReader.IsDBNull(5) ? "" : dataReader.GetString("name");
string description = dataReader.IsDBNull(6) ? "" : dataReader.GetString("description");
DateTime start_date = (DateTime)dataReader.GetMySqlDateTime("start_date");
DateTime due_date = (DateTime)dataReader.GetMySqlDateTime("due_date");
bool completed = dataReader.IsDBNull(9) ? false : dataReader.GetBoolean("completed");
Double estimated_time = dataReader.IsDBNull(9) ? 0.0 : dataReader.GetDouble("estimated_time");
int priority = dataReader.IsDBNull(10) ? 0 : dataReader.GetInt16("priority");
DateTime created_at = (DateTime)dataReader.GetMySqlDateTime("created_at");
Task parentTask = parent_task_id == 0 ? null : this.Read(parent_task_id);
Task requiredTask = requires_task_id == 0 ? null : this.Read(requires_task_id);
Task task = new Task(id, parentTask, requiredTask, new UserDAO().Read(user_id), section_id, name, description, estimated_time, priority, completed, start_date, due_date, created_at);
tasks.Add(task);
}
}
mySQLConnector.CloseConnections(dataReader);
return(tasks);
}
public menuPrincipal(string user)
{
InitializeComponent();
MySqlCommand sql2 = new MySqlCommand(String.Format("Select * from Usuarios where Nick_Name='" + user + "'"), ConectarServidor.conexion());
MySqlDataReader reader = sql2.ExecuteReader();
if (reader.Read() == true)
{
btRentar.Enabled = reader.GetBoolean(4);
btCotizacion.Enabled = reader.GetBoolean(5);
btRegistro.Enabled = reader.GetBoolean(6);
btBusqueda.Enabled = reader.GetBoolean(7);
btDevoluciones.Enabled = reader.GetBoolean(8);
btRegistroUsuario.Enabled = reader.GetBoolean(9);
btConfiguracion.Enabled = reader.GetBoolean(10);
this.user = user;
}
reader.Close();
}
public List <TodoItem> Index()
{
string cs = @"server=localhost;userid=root;password='';database=todos;";
using var con = new MySqlConnection(cs);
con.Open();
var stm = "SELECT * FROM todotabell ORDER BY Id ASC";
var cmd = new MySqlCommand(stm, con);
using MySqlDataReader rdr = cmd.ExecuteReader();
TodoItem.TodoLista.Clear();
while (rdr.Read())
{
TodoItem Todo = new TodoItem {
Id = rdr.GetInt32(0), Name = rdr.GetString(1), IsComplete = rdr.GetBoolean(2)
};
TodoItem.TodoLista.Add(Todo);
}
return(TodoItem.TodoLista);
}
/// <summary>
/// Provides the ability to search for students using their uid.
/// </summary>
/// <param name="uid">Should be the FOB uid used to search for the student.</param>
/// <returns>
/// True = they're alive and well. False = check their pulse.
/// </returns>
public Student FindStudentByUID(uint uid)
{
MySqlDataReader reader = db.Query($"SELECT * FROM students WHERE uid={uid}");
Student result = null;
if (reader != null && reader.HasRows)
{
reader.Read();
result = new Student(reader.GetUInt32("id"),
reader.GetUInt32("uid"),
reader.GetUInt32("oasisid"),
reader.GetString("firstname"),
reader.GetString("lastname"),
reader.GetUInt16("finishyear"),
reader.GetBoolean("active"));
}
reader.Close();
db.CloseConnection();
return(result);
}
// Return all ListItems for a given list
public List <ListItem> GetAllItemsForList(int listId)
{
List <ListItem> results = new List <ListItem>();
string sql = $"SELECT ItemId, Text, Completed FROM ListItems WHERE ListId = {listId};";
using (MySqlCommand cmd = new MySqlCommand(sql, Connection))
{
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ListItem item = new ListItem(
rdr.GetInt32("ItemId"),
rdr.GetString("Text"),
rdr.GetBoolean("Completed"));
results.Add(item);
}
}
return(results);
}
/// <summary>
/// Muestra si un usuario es administrador
/// </summary>
/// <param name="email">Email o nombre de usuario, del usuario a chequear</param>
/// <returns>True si es administrador, false si no lo es</returns>
public static bool GetAdmin(string email)
{
bool resultado = false;
MySqlCommand command = new MySqlCommand("SELECT usuario.Administrador FROM usuario WHERE Email=@email");
command.Parameters.AddWithValue("@email", email);
MySqlDataReader reader = Database.ExecuteQuery(command);
if (reader.HasRows)
{
while (reader.Read())
{
if (reader.GetBoolean(0))
{
resultado = true;
}
}
}
reader.Close();
return(resultado);
}
public static bool CanPlayerLogin(string email, string password)
{
MySqlDataReader reader = Program.database.GetData("SELECT baned FROM Users WHERE email='" + email + "' AND password='******'");
if (reader.HasRows)
{
reader.Read();
if (reader.GetBoolean("baned"))
{
reader.Close();
return(false);
}
else
{
reader.Close();
return(true);
}
}
reader.Close();
return(false);
}
private List <Receipt_Food> retrieveOrderFood()
{
List <Receipt_Food> orderFood = new List <Receipt_Food>();
cnn = new MySqlConnection(connectionString);
cnn.Open();
String sql = "SELECT * from receipt_food WHERE receiptid = '" + Id + "'";;
MySqlCommand cmd = new MySqlCommand(sql, cnn);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
orderFood.Add(new Receipt_Food(dataReader.GetInt32(0), dataReader.GetInt32(1),
dataReader.GetString(2), dataReader.GetDecimal(3), dataReader.GetInt32(4),
dataReader.GetBoolean(5)));
}
return(orderFood);
}
public Uposlenik VratiUposlenika(int brojClanskeKarte)
{
try
{
MySqlCommand dataCommand = new MySqlCommand();
dataCommand.Connection = dataConnection;
dataCommand.CommandText = "SELECT * FROM clanovi_biblioteke, uposlenici WHERE uposlenici_uposlenikID = uposlenikID AND brojClanskeKarte = " + brojClanskeKarte + ";";
MySqlDataReader dataReader = dataCommand.ExecuteReader();
dataReader.Read();
Uposlenik u = new Uposlenik(dataReader.GetString(1), dataReader.GetString(2), dataReader.GetString(3), dataReader.GetString(4), dataReader.GetString(5), dataReader.GetString(6), dataReader.GetDateTime(7), dataReader.GetString(14), dataReader.GetString(15));
u.BrojIznajmljenihKnjiga = dataReader.GetInt32(9);
u.Zaduzen = dataReader.GetBoolean(10);
dataReader.Close();
return(u);
}
catch (MySqlException izuzetak)
{
throw new Exception(izuzetak.Message);
}
}
public static List <WordFilterData> ReadSwearWords()
{
List <WordFilterData> result = new List <WordFilterData>();
using (DatabaseConnection dbClient = Alias.Server.DatabaseManager.GetConnection())
{
using (MySqlDataReader Reader = dbClient.DataReader("SELECT `word`, `bannable` FROM `wordfilter`"))
{
while (Reader.Read())
{
WordFilterData data = new WordFilterData
{
Phrase = Reader.GetString("Word"),
Bannable = Reader.GetBoolean("bannable")
};
result.Add(data);
}
}
}
return(result);
}
// Lookup Existing Customer
public int LookupCustomer()
{
string lookupCustomerQuery = $"SELECT customerName, active, addressId FROM customer WHERE customerId = { _customerID };";
int customerAddress = 0;
dbCon.Open();
MySqlCommand lookupCustomerCommand = new MySqlCommand(lookupCustomerQuery, dbCon);
MySqlDataReader lookupCustomerReader = lookupCustomerCommand.ExecuteReader();
if (lookupCustomerReader.Read())
{
_customerName = lookupCustomerReader.GetString(0);
_isActive = lookupCustomerReader.GetBoolean(1);
customerAddress = lookupCustomerReader.GetInt32(2);
}
dbCon.Close();
return(customerAddress);
}
public Student VratiStudenta(int brojClanskeKarte)
{
try
{
MySqlCommand dataCommand = new MySqlCommand();
dataCommand.Connection = dataConnection;
dataCommand.CommandText = "SELECT * FROM clanovi_biblioteke, studenti WHERE studenti_studentID = studentID AND brojClanskeKarte = " + brojClanskeKarte + ";";
MySqlDataReader dataReader = dataCommand.ExecuteReader();
dataReader.Read();
Student s = new Student(dataReader.GetString(1), dataReader.GetString(2), dataReader.GetString(3), dataReader.GetString(4), dataReader.GetString(5), dataReader.GetString(6), dataReader.GetDateTime(7), dataReader.GetInt32(13), dataReader.GetString(14), dataReader.GetInt32(15));
s.BrojIznajmljenihKnjiga = dataReader.GetInt32(9);
s.Zaduzen = dataReader.GetBoolean(10);
dataReader.Close();
return(s);
}
catch (MySqlException izuzetak)
{
throw new Exception(izuzetak.Message);
}
}
private bool ReadBuilding(MySqlDataReader reader, out BuildingSaveData result)
{
if (reader.Read())
{
result = new BuildingSaveData();
result.Id = reader.GetString(0);
result.ParentId = reader.GetString(1);
result.EntityId = reader.GetInt32(2);
result.CurrentHp = reader.GetInt32(3);
result.RemainsLifeTime = reader.GetFloat(4);
result.IsLocked = reader.GetBoolean(5);
result.LockPassword = reader.GetString(6);
result.CreatorId = reader.GetString(7);
result.CreatorName = reader.GetString(8);
result.Position = new Vector3(reader.GetFloat(9), reader.GetFloat(10), reader.GetFloat(11));
result.Rotation = Quaternion.Euler(reader.GetFloat(12), reader.GetFloat(13), reader.GetFloat(14));
return(true);
}
result = new BuildingSaveData();
return(false);
}
static public List <Entidades.Seccion> buscarSeccionPorLote(string lote)
{
List <Entidades.Seccion> secciones = new List <Entidades.Seccion>();
Conexion.OpenConnection();
string query;
Entidades.Seccion b = new Entidades.Seccion();
query = "Select * from seccion where idLote = @lote";
MySqlCommand comando = new MySqlCommand(query, Conexion.Connection);
comando.Parameters.AddWithValue("@lote", lote);
comando.Prepare();
MySqlDataReader reader = comando.ExecuteReader();
while (reader.Read())
{
b = new Entidades.Seccion();
b.IdSeccion = reader.GetString("idSeccion");
b.IdLote = reader.GetString("idLote");
b.IdBloque = reader.GetString("idBloque");
b.Area = reader.GetDouble("area");
b.Posicion = reader.GetInt32("posicion");
b.NumPlantas = reader.GetInt32("numPlantas");
b.PosX = reader.GetInt32("posX");
b.PosY = reader.GetInt32("posY");
b.FechaSiembra = reader.GetDateTime("fechaSiembra");
b.FechaInicial = reader.GetDateTime("fechaInicial");
b.FechaProgramada = reader.GetDateTime("fechaProgramada");
b.Detalle = reader.GetString("detalle");
b.GrupoForza = reader.GetString("grupoForza");
b.Paquete = reader.GetString("idPaquete");
b.Bloqueo = reader.GetBoolean("bloqueo");
secciones.Add(b);
}
//retorna valores nulos en caso de no encontrar coincidencias
Conexion.CloseConnection();
return(secciones);
}
public IP CheckIp(string ip)
{
IP ret = null;
MySqlCommand cmd = CreateQuery();
cmd.CommandText = "SELECT * FROM ips WHERE ip=@ip;";
cmd.Parameters.AddWithValue("@ip", ip);
bool foundIp = false;
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.HasRows)
{
foundIp = true;
rdr.Read();
ret = new IP
{
Address = rdr.GetString("ip"),
Banned = rdr.GetBoolean("banned"),
Gifts = Utils.FromCommaSepString16(rdr.GetString("gifts")).ToList()
};
}
}
if (!foundIp)
{
cmd = CreateQuery();
cmd.CommandText = @"INSERT INTO ips(ip, banned, gifts) VALUES (@ip, @banned, @gifts)";
cmd.Parameters.AddWithValue("@ip", ip);
cmd.Parameters.AddWithValue("@banned", 0);
cmd.Parameters.AddWithValue("@gifts", "");
cmd.ExecuteNonQuery();
ret = new IP
{
Address = ip,
Banned = false,
Gifts = new List <short>()
};
}
return(ret);
}
//______________________________________________________
//ajouter les informations dans le bouton + stocker les infos pour la fenetres infos supplémentaires
public void Ajouter_dans_boutons(int id, Button btn_matin, Button btn_aprem, DateTime date, int num_tab)
{
try
{
connexion.Open();
MySqlCommand cmd1 = new MySqlCommand("SELECT * FROM emploi WHERE ID_Groupe ='" + id + "' AND Date_Seance='" + date.ToShortDateString() + "';", connexion);
using (MySqlDataReader Reader1 = cmd1.ExecuteReader())
{
while (Reader1.Read())
{
string Libelle_Cours = Reader1.GetString("Libelle_Cours");
int couleur = Reader1.GetInt32("Couleur_Cours");
bool debut_seance = Reader1.GetBoolean("Debut_Seance");
if (debut_seance == true)
{
btn_matin.Text = Libelle_Cours;
btn_matin.BackColor = System.Drawing.Color.FromArgb(couleur);
notes[num_tab] = Reader1.GetString("Note_Seance");
profs[num_tab] = Reader1.GetString("Prenom") + " " + Reader1.GetString("Nom");
ids_seance[num_tab] = Reader1.GetInt32("ID_Seance");
}
else
{
btn_aprem.Text = Libelle_Cours;
btn_aprem.BackColor = System.Drawing.Color.FromArgb(couleur);
notes[num_tab + 1] = Reader1.GetString("Note_Seance");
profs[num_tab + 1] = Reader1.GetString("Prenom") + " " + Reader1.GetString("Nom");
ids_seance[num_tab + 1] = Reader1.GetInt32("ID_Seance");
}
}
Reader1.Close();
}
connexion.Close();
}
catch (Exception ex)
{
MessageBox.Show("Erreur pendant l'execution de la méthode Ajouter dans boutons pour l'emploi du temps " + ex.ToString());
}
}
public static PyObject DBColumnToPyObject(int index, ref MySqlDataReader reader)
{
Type type = reader.GetFieldType(index);
switch (type.Name)
{
case "String":
return(new PyString(reader.IsDBNull(index) == true ? "" : reader.GetString(index)));
case "UInt32":
case "Int32":
case "UInt16":
case "Int16":
case "SByte":
case "Byte":
return(new PyInt(reader.IsDBNull(index) == true ? 0 : reader.GetInt32(index)));
case "UInt64":
case "Int64":
return(new PyLongLong(reader.IsDBNull(index) == true ? 0 : reader.GetInt64(index)));
case "Byte[]":
return(new PyBuffer(reader.IsDBNull(index) == true ? new byte[0] : (byte[])reader.GetValue(index)));
case "Double":
return(new PyFloat(reader.IsDBNull(index) == true ? 0.0 : reader.GetDouble(index)));
case "Decimal":
return(new PyFloat(reader.IsDBNull(index) == true ? 0.0 : (double)reader.GetDecimal(index)));
case "Boolean":
return(new PyBool(reader.IsDBNull(index) == true ? false : reader.GetBoolean(index)));
default:
Log.Error("Database", "Unhandled MySQL type " + type.Name);
break;
}
return(null);
}
public Bug getBugById(int id)
{
String sql = "SELECT b.id,b.name,b.package_name,b.class,b.method,b.line_start,b.line_end,b.status,b.date,b.image,b.code,u.username,p.title FROM tbl_bug AS b,tbl_project AS p,tbl_user AS u WHERE b.project_id=p.id AND b.user_id=u.id AND b.id=@id";
try
{
conn.Open();
MySqlCommand sqlCommand = new MySqlCommand(sql, conn);
sqlCommand.Parameters.AddWithValue("@id", id);
MySqlDataReader result = sqlCommand.ExecuteReader();
while (result.Read())
{
bug = new Bug();
bug.Id = result.GetInt32(result.GetOrdinal("id"));
bug.BugName = result.GetString(result.GetOrdinal("name"));
bug.PackageName = result.GetString(result.GetOrdinal("package_name"));
bug.ClassName = result.GetString(result.GetOrdinal("class"));
bug.MethodName = result.GetString(result.GetOrdinal("method"));
bug.LineStart = result.GetInt32(result.GetOrdinal("line_start"));
bug.LineEnd = result.GetInt32(result.GetOrdinal("line_end"));
bug.BugAddedDate = result.GetDateTime(result.GetOrdinal("date"));
bug.Status = result.GetBoolean(result.GetOrdinal("status"));
bug.BugAuthor = result.GetString(result.GetOrdinal("username"));
bug.ProjectName = result.GetString(result.GetOrdinal("title"));
bug.CodeBlock = result.GetString(result.GetOrdinal("code"));
byte[] img = (byte[])(result[result.GetOrdinal("image")]);
bug.Image = img;
return(bug);
// project.Id = result.GetInt32(result.GetOrdinal("id"));
}
}
catch (Exception e)
{
MessageBox.Show(" project bug" + e.Message);
}
return(null);
}
public Tables Get(Database database)
{
Tables tables = new Tables(database);
double tableCount = GetTablesCount(database);
double tableIndex = 0;
using (MySqlConnection conn = new MySqlConnection(connectioString))
{
database.Name = conn.Database;
using (MySqlCommand command = new MySqlCommand("select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE, VERSION, ROW_FORMAT, TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH, MAX_DATA_LENGTH, INDEX_LENGTH, DATA_FREE, IFNULL(AUTO_INCREMENT,0) AS AUTO_INCREMENT, CREATE_TIME, UPDATE_TIME, CHECK_TIME, TABLE_COLLATION, IFNULL(CHECKSUM,0) AS CHECKSUM, CREATE_OPTIONS, TABLE_COMMENT FROM Information_schema.tables WHERE TABLE_SCHEMA = '" + database.Name + "' ORDER BY TABLE_NAME", conn))
{
conn.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Table table = new Table(database);
table.Id = (int)tableIndex;
table.Name = reader["TABLE_NAME"].ToString();
table.AutoIncrement = reader.GetInt32("AUTO_INCREMENT");
table.CheckSum = reader.GetBoolean("CHECKSUM");
table.Collation = reader["TABLE_COLLATION"].ToString();
table.Comments = reader["TABLE_COMMENT"].ToString();
table.CreateOptions = reader["CREATE_OPTIONS"].ToString();
table.Engine = reader["ENGINE"].ToString();
table.Constraints = (new GenerateConstraint(connectioString, tableFilter)).Get(table); /*Primero debe ir las constraints*/
table.Columns = GetColumnsDatabase(table);
table.Triggers = GetTriggers(table);
//table.Indexes = (new GenerateIndex(connectioString,tableFilter)).Get(table);
tables.Add(table);
tableIndex++;
OnTableProgress(this, new ProgressEventArgs((tableIndex / tableCount) * 100));
}
}
}
}
//tables.Sort();
tables.ToSQL();
return(tables);
}
public System()
{
conn = DBUtils.GetDBConnection();
try
{
conn.Open();
Console.WriteLine("[MySQL] Verbindung erfolgreich!");
}
catch (Exception e)
{
Console.WriteLine("[MySQL] Verbindung fehlgeschlagen!");
Console.WriteLine(e.Message);
}
try
{
Thread Socket = new Thread(new ThreadStart(new SocketHandler().Handler)); //Start Console Handler
Socket.Start();
List <int> startServer = new List <int>();
MySqlDataReader data = DBUtils.ExecuteCommand(conn, "SELECT * FROM `server`");
while (data.Read())
{
int id = data.GetInt32(0);
if (data.GetBoolean(6))
{
startServer.Add(id);
//new Thread(() => StartServer(id)).Start();
}
}
data.Close();
foreach (int id in startServer)
{
StartServer(id);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
//Validate username and password
protected void login_Authenticate(object sender, AuthenticateEventArgs e)
{
using (SHA256CryptoServiceProvider encrypt = new SHA256CryptoServiceProvider())
{
byte [] username = Encoding.Unicode.GetBytes(login.UserName.Trim());
byte [] password = Encoding.Unicode.GetBytes(login.Password.Trim());
byte [] usernameHash = encrypt.ComputeHash(username);
byte [] passwordHash = encrypt.ComputeHash(password);
using (MySqlConnection database = new MySqlConnection(CONNECTION_STRING))
{
database.Open();
using (MySqlCommand select = new MySqlCommand("Select * from users where username = @usernameHash and password = @passwordHash", database))
{
select.Parameters.AddWithValue("@usernameHash", usernameHash);
select.Parameters.AddWithValue("@passwordHash", passwordHash);
using (MySqlDataReader reader = select.ExecuteReader())
{
reader.Read();
//If we have a result we are authenticated
if (reader.HasRows)
{
e.Authenticated = true;
Session ["user"] = new User(reader.GetUInt64("id"), reader.GetBoolean("is_admin"), reader.GetString("firstname"), reader.GetString("lastname"), reader.GetDateTime("dob"), reader.GetString("country"), reader.GetString("phone"));
Response.Redirect("Default.aspx");
}
else
{
e.Authenticated = false;
}
}
}
}
}
}
public clsVehiculoTransporte CargaVehiculoTransporte(Int32 Codigo)
{
clsVehiculoTransporte veh = null;
try
{
con.conectarBD();
cmd = new MySqlCommand("MuestraVehiculoTransporte", con.conector);
cmd.Parameters.AddWithValue("codveh", Codigo);
cmd.CommandType = CommandType.StoredProcedure;
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
veh = new clsVehiculoTransporte();
veh.CodVehiculoTransporte = Convert.ToInt32(dr.GetDecimal(0));
veh.Placa = dr.GetString(1);
veh.CodMarca = Convert.ToInt32(dr.GetDecimal(2));
veh.Marca = dr.GetString(3);
veh.CodModelo = Convert.ToInt32(dr.GetDecimal(4));
veh.Modelo = dr.GetString(5);
veh.Año = Convert.ToInt32(dr.GetDecimal(6));
veh.ConstanciaInscripcion = dr.GetString(7);
veh.Estado = dr.GetBoolean(8);
veh.CodUser = Convert.ToInt32(dr.GetDecimal(9));
veh.FechaRegistro = dr.GetDateTime(10);// capturo la fecha
veh.Soat = dr.GetString(11);
veh.ConfVehicular = dr.GetString(12);
veh.MTC = dr.GetString(13);
}
}
return(veh);
}
catch (MySqlException ex)
{
throw ex;
}
finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); }
}
public List <Item> GetItems()
{
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT items.* FROM pcs
JOIN inventory ON (pcs.id = inventory.pcs)
JOIN items ON (inventory.items = items.id)
WHERE pcs.id = @PCId;";
MySqlParameter pcIdParameter = new MySqlParameter();
pcIdParameter.ParameterName = "@PCId";
pcIdParameter.Value = _id;
cmd.Parameters.Add(pcIdParameter);
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
List <Item> items = new List <Item> {
};
while (rdr.Read())
{
int itemId = rdr.GetInt32(0);
// int pcId = rdr.GetInt32(1);
string itemName = rdr.GetString(1);
string itemType = rdr.GetString(2);
string itemSpecial = rdr.GetString(3);
bool itemMagic = rdr.GetBoolean(4);
Item newItem = Item.Find(itemId);
items.Add(newItem);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(items);
}