private void PopulateList(SqlCeDataReader reader, List<Business.CommApplication> list)
{
while (reader.Read())
{
var cap = new Business.CommApplication();
cap.ID = Convert.ToInt32(reader["ID"]);
cap.Name = reader["Name"].ToString();
cap.Path = reader["Path"].ToString();
cap._recordExists = true;
cap._hasChanged = false;
list.Add(cap);
}
}
public static TRonda GetRondaFromDr(SqlCeDataReader dr)
{
TRonda r = new TRonda();
bool primero = true;
while (dr.Read())
{
if (primero)
{
r.rondaId = dr.GetInt32(0);
r.nombre = dr.GetString(1);
r.tag = dr.GetString(2);
r.tagf = dr.GetString(3);
r.RondasPuntos = new List<TRondaPunto>();
primero = false;
}
TRondaPunto rp = new TRondaPunto();
TPunto p = new TPunto();
TEdificio e = new TEdificio();
TGrupo g = new TGrupo();
rp.rondaPuntoId = dr.GetInt32(4);
rp.orden = dr.GetInt32(5);
p.puntoId = dr.GetInt32(6);
p.nombre = dr.GetString(7);
e.edificioId = dr.GetInt32(8);
p.tag = dr.GetString(9);
e.nombre = dr.GetString(10);
g.grupoId = dr.GetInt32(11);
g.nombre = dr.GetString(12);
p.cota = dr.GetString(13);
p.cubiculo = dr.GetString(14);
r.mintime = dr.GetInt32(15);
r.maxtime = dr.GetInt32(16);
p.csnmax = dr.GetInt32(17);
p.csnmargen = dr.GetInt32(18);
p.lastcontrol = dr.GetDateTime(19);
e.Grupo = g;
p.Edificio = e;
rp.Punto = p;
rp.Ronda = r;
r.RondasPuntos.Add(rp);
}
return r;
}
//повернути типи тестів для того щоб користувач вибрав тип тесту який створює
public string[] GetTestTypes()
{
List <string> result = new List <string>();
using (SqlCeConnection connection = new SqlCeConnection(connectionString))
{
connection.Open();
using (SqlCeCommand cmd = connection.CreateCommand())
{
cmd.CommandText = "SELECT DISTINCT TestType FROM Test WHERE OwnerId=@id OR OwnerId=@userId";
cmd.Parameters.AddWithValue("@userId", userId);
cmd.Parameters.AddWithValue("@id", constId);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string type = dr["TestType"].ToString();
result.Add(type);
}
}
}
return(result.ToArray());
}
public bool Exist(string username, DailyUsageBO usage, out DailyUsageBO data)
{
using (SqlCeCommand cmd = new SqlCeCommand(String.Format("SELECT * FROM {0} WHERE day = @day", username),
DataBaseFactory.Instance.GetConnection()))
{
cmd.Parameters.Add(new SqlCeParameter("@day", SqlDbType.DateTime)
{
Value = usage.Day
});
using (SqlCeDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
data = ReadRecord(dr);
return(true);
}
}
}
data = null;
return(false);
}
private void button2_Click(object sender, EventArgs e)
{
string cmdstr = "SELECT * FROM CANDIDATE WHERE S_ID=@CSID";
SqlCeConnection sqlcon = new SqlCeConnection(constr);
SqlCeCommand sqlcmd = new SqlCeCommand(cmdstr, sqlcon);
sqlcmd.Parameters.AddWithValue("@CSID", comboBox1.Text);
try
{
sqlcon.Open();
SqlCeDataReader sdr = sqlcmd.ExecuteReader();
while (sdr.Read())
{
textBox2.Text = sdr[1].ToString();
string g = sdr[2].ToString();
if (g == "M")
{
radioButton1.Checked = true;
}
else if (g == "F")
{
radioButton2.Checked = true;
}
textBox4.Text = sdr[3].ToString();
textBox5.Text = sdr[4].ToString();
textBox3.Text = sdr[5].ToString();
}
sqlcon.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Form71(int licence)
{
//
// Required for Windows Form Designer support
//
//lic = licence;
string connectionString;
lic = licence;
connectionString = "DataSource=Baza.sdf; Password=matrix1";
SqlCeConnection cn = new SqlCeConnection(connectionString);
cn.Open();
SqlCeCommand cmd2 = cn.CreateCommand();
cmd2.CommandText = "SELECT * FROM opcje WHERE id = 1";
cmd2.Prepare();
SqlCeDataReader dr = cmd2.ExecuteReader();
while (dr.Read())
{
transfer = dr.GetString(1);
com = dr.GetString(2);
ip = dr.GetString(3);
ufile = dr.GetString(4);
dfile = dr.GetString(5);
bdll = dr.GetString(6);
bflag = dr.GetBoolean(7);
ipflag = dr.GetBoolean(8);
port = dr.GetInt32(9);
skaner = dr.GetString(10);
}
cn.Close();
InitializeComponent();
this.Height = Screen.PrimaryScreen.Bounds.Height;
this.Width = Screen.PrimaryScreen.Bounds.Width;
Update();
}
public static int GetIdByClassesId(int classesId)
{
int result = -1;
try
{
SqlCeCommand command = new SqlCeCommand(@"SELECT Id FROM Courses WHERE ClassesId = @classesid", Connection);
command.Parameters.AddWithValue("@classesid", classesId);
SqlCeDataReader reader = command.ExecuteReader();
reader.Read();
result = (int)reader["Id"];
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(result);
}
private bool populateInvoiceStatements(DateTime openingDate, AccountStatementDataSet dataset)
{
string sql = getInvoiceRetrievalSQL(openingDate);
string errorText;
SqlCeConnection connection = Global.getDatabaseConnection(out errorText);
try
{
using (SqlCeCommand command = connection.CreateCommand())
{
command.CommandText = sql;
using (SqlCeDataReader reader = command.ExecuteReader())
{
AccountStatementDataSet.AccountStatementRow row;
while (reader.Read())
{
row = dataset.AccountStatement.NewAccountStatementRow();
row.TransactionDate = reader.GetDateTime(1);
row.Description = "Invoice# " + reader.GetInt32(0) + " issued";
row.DebitAmount = reader.GetDecimal(2);
dataset.AccountStatement.AddAccountStatementRow(row);
}
}
}
}
catch (Exception ex)
{
string message = "An error occurred in fetching the account details from " +
"the database. The error text is as follows:\n" +
Global.getExceptionText(ex);
Cursor.Current = Cursors.Default;
MessageBox.Show(message, "Error Occurred", MessageBoxButtons.OK,
MessageBoxIcon.Error);
ErrorLogger.LogError(ex);
return(false);
}
return(true);
}
/// <summary>
/// Returns list of dates from the range that contain at least one schedule with built routes.
/// </summary>
/// <param name="dateFrom">Start date used to query schedules.</param>
/// <param name="dateTo">Finish date used to query schedules.</param>
/// <returns>List of dates from the range that contain at least one schedule with built routes.</returns>
/// <remarks>
/// Schedule with built routes is a schedule where at least one order is assigned.
/// </remarks>
public IList <DateTime> SearchDaysWithBuiltRoutes(DateTime dateFrom,
DateTime dateTo)
{
SqlCeCommand cmd = new SqlCeCommand(
QUERY_DAYS_WITH_BUILT_ROUTES,
_DataService.StoreConnection);
cmd.Parameters.Add(new SqlCeParameter("date_from", dateFrom.Date));
cmd.Parameters.Add(new SqlCeParameter("date_to", dateTo.Date));
List <DateTime> dates = new List <DateTime>();
using (SqlCeDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
dates.Add(reader.GetDateTime(0));
}
}
return(dates);
}
public List <GeometryColumn> GetGeometryColumns()
{
List <GeometryColumn> list = new List <GeometryColumn>();
SqlCeDataReader sqlCeDataReader = _sqlCeDb.GetDataReader(_tableName, null, SortOrder.None) as SqlCeDataReader;
if (sqlCeDataReader == null)
{
return(list);
}
while (sqlCeDataReader.Read())
{
list.Add(new GeometryColumn()
{
TableName = sqlCeDataReader["G_TABLE_NAME"].ToString(),
GeometryType = Convert.ToInt32(sqlCeDataReader["GEOMETRY_TYPE"])
});
}
sqlCeDataReader.Close();
sqlCeDataReader.Dispose();
return(list);
}
public void PdaSiparisBaslikOku(System.Windows.Forms.Label label)
{
SqlConn.Open();
CeConn.Open();
string sql = " select count(*) from SiparisBaslik";
SqlCeCommand cmd = new SqlCeCommand(sql, CeConn);
int i = Convert.ToInt16(cmd.ExecuteScalar().ToString());
sql = " select * from SiparisBaslik";
cmd.CommandText = sql;
SqlCeDataReader rdr = cmd.ExecuteReader();
int k = 0;
while (rdr.Read())
{
PdaSiparisBaslikYaz(
rdr["Musteri_Kodu"].ToString(),
rdr["Musteri_Adi"].ToString(),
rdr["Plasiyer_Kodu"].ToString(),
Convert.ToDateTime(rdr["Teslim_Tarihi"].ToString()),
Convert.ToInt16(rdr["Vade_Gunu"].ToString()),
rdr["Odeme_Sekli"].ToString().ToLower(),
Convert.ToDateTime(rdr["Siparis_Tarihi"].ToString()),
Convert.ToInt16(rdr["Siparis_No"].ToString()));
label.Text = i.ToString() + "/" + k.ToString();
System.Windows.Forms.Application.DoEvents();
k += 1;
}
sql = "delete from SiparisBaslik";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
CeConn.Close();
SqlConn.Close();
}
public void LoadDataToSettings()
{
try
{
SqlCeDataReader reader = DA.GetData("select * from EmailSettings");
while (reader.Read())
{
emailAddress = reader["EmailAddress"].ToString();
userName = reader["UserName"].ToString();
password = reader["Password"].ToString();
mailServer = reader["EmailServer"].ToString();
schedule = (DateTime)reader["Schedule"];
port = (int)reader["Port"];
recepients = reader["Recepients"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void txt_ascode_KeyPress(object sender, KeyPressEventArgs e)
{
NAME = string.Empty;
if (e.KeyChar == Convert.ToChar(Keys.Enter))
{
if (txt_ascode.Text == null || txt_ascode.Text == "")
{
MessageBox.Show("ใส่ข้อมูลไม่ครบ");
}
else
{
try
{
string ASSETID = txt_ascode.Text.ToString();
txt_ctcode.Focus();
using (SqlCeConnection con = new SqlCeConnection(strcon))
{
con.Open();
string sql_check = @"SELECT NAME FROM MAS_ASSET WHERE ASSETID = '" + ASSETID + "'";
using (SqlCeCommand command = new SqlCeCommand(sql_check, con))
{
using (SqlCeDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
NAME = (reader["NAME"].ToString());
}
}
}
con.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
public List <SoldProduct> GetSoldProducts()
{
List <SoldProduct> soldProducts = new List <SoldProduct>();
string sql = "SELECT * FROM SoldProduct";
using (SqlCeConnection conn = new SqlCeConnection(Storage.ConnectionString))
{
try
{
conn.Open();
}
catch
{
MessageBox.Show("Невозможно установить соединение с базой данных!", "Ошибка подключения", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(soldProducts);
}
SqlCeCommand command = new SqlCeCommand(sql, conn);
using (SqlCeDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
soldProducts.Add(new SoldProduct
{
Id = (int)reader[0],
CategoryId = (int)reader[1],
CreditId = (int)reader[2],
Name = reader[3].ToString(),
Price = (decimal)reader[4],
AddAmount = (decimal)reader[5],
Discount = (decimal)reader[6],
Total = (decimal)reader[7]
});
}
}
}
return(soldProducts);
}
public static void SetMeasureTime()
{
SqlCeConnection con = new SqlCeConnection(Properties.Settings.Default.lcmsConnectionString);
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
SqlCeCommand bkCmd = new SqlCeCommand("select * from time", con);
bkCmd.CommandType = CommandType.Text;
SqlCeDataReader bkDr = bkCmd.ExecuteReader();
if (bkDr.Read())
{
BKManager.supposeMillSecond = Convert.ToDouble(bkDr["sample"]) * 60 * 1000;
BKManager.supposeSecond = Convert.ToDouble(bkDr["sample"]) * 60;
}
bkDr.Close();
con.Close();
}
public static TTipoAnomalia GetTTipoAnomalia(int id, SqlCeConnection conn)
{
TTipoAnomalia ta = null;
string sql = String.Format("SELECT * FROM TipoAnomalia WHERE tipo_anomalia_id={0}", id);
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ta = new TTipoAnomalia();
ta.TipoAnomaliaId = dr.GetInt32(0);
ta.Nombre = dr.GetString(1);
}
if (!dr.IsClosed)
{
dr.Close();
}
}
return(ta);
}
public void Refresh()
{
this.Clear();
using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(m_User))
{
cmd.CommandText = "SELECT id, clr_name, parent_id FROM TypeDefinitions";
SqlCeDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TypeDefinition info = new TypeDefinition();
info.Id = Convert.ToInt32(reader["id"]);
info.ClrName = reader["clr_name"].ToString();
object result = reader["parent_id"];
info.ParentId = (result is DBNull || result == null) ? -1 : Convert.ToInt32(result);
this.Add(info.Id, info);
}
}
}
public void loadCompatibilities()
{
// Add Compatibilities to List
ArrayList theCompatibilities = new ArrayList();
openDB();
SqlCeCommand cmd = TecanDatabase.CreateCommand();
cmd.CommandText = "SELECT CompatibilityName, CompatibilityID FROM Compatibility ORDER BY CompatibilityName";
SqlCeDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
theCompatibilities.Add(new Compatibilities(reader[0].ToString(), reader[1].ToString()));
}
reader.Dispose();
TecanDatabase.Close();
compatibilitiesListBox.DataSource = theCompatibilities;
compatibilitiesListBox.DisplayMember = "Name";
compatibilitiesListBox.ValueMember = "ID";
}
public long TicketsCargados(long SemanaID)
{
long lngResult = 0;
List <SqlCeParameter> lstParameters = new List <SqlCeParameter>();
lstParameters.Add(new SqlCeParameter("SemanaID", SemanaID));
string query = "SELECT COUNT(1) AS Result FROM " + tablename + " WHERE SemanaID = ?";
SqlCeDataReader rdrLector = AccesoDatos.ExecuteReader(query, CommandType.Text, lstParameters, conn);
if (rdrLector != null)
{
if (rdrLector.Read())
{
lngResult = rdrLector.GetInt32(0);
}
rdrLector.Close();
}
return(lngResult);
}
private Exame ObterExame(string nome)
{
//objeto medico que será retornado pelo método
Exame exame = new Exame();
//instância da conexão
SqlCeConnection conn = new SqlCeConnection(@"Data Source=C:\Users\Wallace\Contacts\Desktop\Projeto Teste implementação\Bancodedados.sdf;Password=123");
//string com o comando a ser executado
string sql = "SELECT * from Exame WHERE Nome = @Nome";
//instância do comando recebendo como parâmetro
//a string com o comando e a conexão
SqlCeCommand cmd = new SqlCeCommand(sql, conn);
//informo o parâmetro do comando
cmd.Parameters.AddWithValue("@Nome", nome);
//abro conexão
conn.Open();
//instância do leitor
SqlCeDataReader leitor = cmd.ExecuteReader();
//enquanto leitor lê
while (leitor.Read())
{
//passo os valores para o objeto paciente
//que será retornado
exame.Id = Convert.ToInt32(leitor["Id"].ToString());
}
//fecha conexão
conn.Close();
//Retorno o objeto paciente cujo o
//nome é igual ao informado no parâmetro
return(exame);
}
private void btnSinleRow_Click(object sender, System.EventArgs e)
{
SqlCeDataReader obj_Reader = SqlHelper.ExecuteReader(ssceconn, CommandType.Text, "Select * from Customer");
string str_result = "";
while (obj_Reader.Read())
{
str_result = str_result + "Customer ID : " + obj_Reader.GetInt32(0).ToString() + "\r\n";
str_result = str_result + "Name : " + obj_Reader.GetString(1) + " " + obj_Reader.GetString(2) + "\r\n";
str_result = str_result + "Address : " + obj_Reader.GetString(3) + "\r\n";
str_result = str_result + "City: " + obj_Reader.GetString(4) + "\r\n";
str_result = str_result + "State : " + obj_Reader.GetString(5) + "\r\n";
str_result = str_result + "Zip : " + obj_Reader.GetString(6) + "\r\n";
str_result = str_result + "Country : " + obj_Reader.GetString(7) + "\r\n";
str_result = str_result + "Phone : " + obj_Reader.GetString(8) + "\r\n";
str_result = str_result + "\r\n";
}
txtResult.Text = str_result;
//(ssceconn ,CommandType.Text ,"Select * fro"
}
public static void SyncDataToServer()
{
string query = "select q_query from LTB_QUERY";
List <string> list = new List <string>();
using (SqlCeDataReader reader = LocalDataService.GetInstance().ExecuteReader(query))
{
while (reader.Read())
{
list.Add(reader.GetString(0));
}
}
foreach (string text in list)
{
DataService.GetInstance().ExecuteNonQuery(text);
}
string delText = "delete from LTB_QUERY";
//LocalDataService.GetInstance().ExecuteNonQuery(delText);
}
/// <summary>
/// Leera de la base de datos y los almacenara en una clase.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPOO_Click(object sender, EventArgs e)
{
try
{
string query = @" Select * from Auto";
_conn = new SqlCeConnection(_conectionString);
_conn.Open();
_cmd = new SqlCeCommand(query, _conn);
List <ClsCar> lst = new List <ClsCar>();
SqlCeDataReader reader = _cmd.ExecuteReader();
while (reader.Read())
{
ClsCar car = new ClsCar();
car.Model = reader["Modelo"].ToString();
car.Year = Convert.ToInt32(reader["Año"]);
car.Maker = reader["Fabricante"].ToString();
car.Type = (TypeCar)Convert.ToInt32(reader["Tipo"]);
lst.Add(car);
}
StringBuilder result = new StringBuilder();
foreach (ClsCar item in lst)
{
result.AppendLine(item.GetAllInformation);
}
txtResults.Text = result.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Mensaje de error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static TGrupo GetGrupo(int id, SqlCeConnection conn)
{
TGrupo g = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = String.Format("SELECT * FROM grupos WHERE grupoId = {0}", id);
using (SqlCeDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
g = GetGrupoFromDr(dr);
}
if (!dr.IsClosed)
{
dr.Close();
}
}
}
return(g);
}
/// <summary>
/// Charge la liste complète de tous les tireurs depuis la base de donnée
/// </summary>
public void GetAllTireurs()
{
Clear();
using (SqlCeConnection con = new SqlCeConnection(BaseDeDonnee.InfoConnexion))
{
con.Open();
using (SqlCeCommand com = new SqlCeCommand("SELECT * FROM tireurs ORDER BY nom ASC", con))
{
SqlCeDataReader objReader = com.ExecuteReader();
while (objReader.Read())
{
int id = objReader.GetInt32(0);
int idEquipe = objReader.GetInt32(1);
string nom = objReader.GetString(2);
DateTime dateDeNaissance = objReader.GetDateTime(3);
Add(new Tireur(id, idEquipe, nom, dateDeNaissance));
}
}
}
}
private void button2_Click(object sender, EventArgs e)
{
bool flag = true;
try
{
SqlCeConnection conn = new SqlCeConnection("Data Source=D:\\containerinfo.sdf;Persist Security Info=False;");
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "select count(position) from container where containerid='" + textBox1.Text + "'";
SqlCeDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
if ((int)rd[0] == 0)
{
MessageBox.Show("Container does not exist");
flag = false;
}
}
if (flag)
{
cmd.CommandText = "delete from container where containerid='" + textBox1.Text + "'";
cmd.ExecuteNonQuery();
label14.Text = "Container deleted successfully!";
}
cmd.CommandText = "select * from container where yardnum='" + yardid + "' and col='" + col + "' and rowid='" + row + "'";
cmd.ExecuteNonQuery();
SqlCeDataAdapter sd = new SqlCeDataAdapter(cmd);
DataTable dt = new DataTable();
sd.Fill(dt);
dataGridView1.DataSource = dt;
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static TPrograma GetTPrograma(int id, SqlCeConnection conn)
{
TPrograma programa = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandText = String.Format("SELECT * FROM Programa WHERE programa_id = {0}", id);
SqlCeDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
programa = new TPrograma()
{
ProgramaId = dr.GetInt32(0),
FechaProgramada = dr.GetDateTime(1),
Usuario = GetTUsuario(dr.GetInt32(2), conn),
Estado = dr.GetString(3),
Comentarios = dr.GetString(4),
Abm = dr.GetByte(5)
};
}
if (!dr.IsClosed)
{
dr.Close();
}
//if (programa != null)
//{
// // Ahora buscamos las revisiones asociadas.
// cmd.CommandText = String.Format("SELECT * FROM Revision WHERE programa_id = {0}", programa.ProgramaId);
// dr = cmd.ExecuteReader();
// while (dr.Read())
// {
// TRevision tr = CntSciTerminal.GetTRevision(dr.GetInt32(0), conn);
// if (tr != null) programa.Revisiones.Add(tr);
// }
// if (!dr.IsClosed) dr.Close();
//}
}
return(programa);
}
public static List <string> Select_gameModes(string endpoint)
{
string connStr = "Data Source = mydatabase.sdf;";
List <string> line = new List <string>();
SqlCeConnection conn = new SqlCeConnection(connStr);
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = string.Format("SELECT * FROM gameModes WHERE endpoint = '{0}'", endpoint);
SqlCeDataReader w = cmd.ExecuteReader();
int i = 0;
while (w.Read())
{
line.Add(w["gameModes"].ToString());
i++;
}
conn.Close();
return(line);
}
private bool duplicate(SqlCeConnection conn, string catname, string query)
{
try
{
SqlCeDataReader reader = null;
SqlCeCommand cmd = new SqlCeCommand(query, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (catname.ToLower() == reader.GetString(0).ToLower())
{
return(true);
}
}
return(false);
}
catch (Exception ex)
{
MessageBox.Show("Error occured while checking for duplicate entry");
return(true);
}
}
internal static List <String> LoadProducts(TypeFood typeFood)
{
if (dbCon.State == ConnectionState.Closed)
{
dbCon.Open();
}
string sqGetAllProductsFromType = @"SELECT ProductName, Category FROM Products
WHERE (Category = N'" + typeFood.ToString() + "')";
SqlCeCommand cmd = new SqlCeCommand(sqGetAllProductsFromType, dbCon);
SqlCeDataReader reader = cmd.ExecuteReader();
List <string> result = new List <string>();
while (reader.Read())
{
result.Add((string)reader["ProductName"]);
}
dbCon.Close();
return(result);
}
public static TAdministrador GetTAdministrador(int id, SqlCeConnection conn)
{
TAdministrador administrador = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = String.Format("SELECT * FROM Administradores WHERE administradorId = {0}", id);
using (SqlCeDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
administrador = GetAdministradorFromDr(dr);
}
if (!dr.IsClosed)
{
dr.Close();
}
}
}
return(administrador);
}
public static TAdministrador GetLogin(string login, string password, SqlCeConnection conn)
{
TAdministrador administrador = null;
using (SqlCeCommand cmd = conn.CreateCommand())
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = String.Format("SELECT * FROM administradores WHERE login = '******' AND password = '******'", login, password);
using (SqlCeDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
administrador = GetAdministradorFromDr(dr);
}
if (!dr.IsClosed)
{
dr.Close();
}
}
}
return(administrador);
}
public Hashtable[] getMediaTable()
{
Hashtable[] table;
sqlRdr = new SqlCeCommand("SELECT COUNT(*) FROM Media", sc).ExecuteReader();
sqlRdr.Read();
int numFiles = (int)sqlRdr[0];
table = new Hashtable[numFiles];
int rowCount = 0;
string query = "SELECT * FROM Media;";
sqlCmd = new SqlCeCommand(query, sc);
sqlRdr = sqlCmd.ExecuteReader();
while (sqlRdr.Read())
{
table[rowCount] = new Hashtable();
table[rowCount]["media_id"] = (int)sqlRdr["media_id"];
table[rowCount]["url"] = (string)sqlRdr["url"];
table[rowCount]["filename"] = (string)sqlRdr["filename"];
table[rowCount]["file_extension"] = (string)sqlRdr["file_extension"];
table[rowCount]["type_id"] = (int)sqlRdr["type_id"];
table[rowCount]["width"] = (int)sqlRdr["width"];
table[rowCount]["height"] = (int)sqlRdr["height"];
table[rowCount]["date_start"] = DateTime.Parse(sqlRdr["date_start"].ToString());
table[rowCount]["date_end"] = DateTime.Parse(sqlRdr["date_end"].ToString());
rowCount++;
}
Console.WriteLine(table.Length);
return table;
}
public void removeDups()
{
Hashtable[] table = getMediaTable("date_end", Order.DESC);
for (int rowA = 0; rowA < table.Length; rowA++)
{
for (int rowB = 0; rowB < table.Length; rowB++)
{
if (rowA == rowB)
{
break;
}
else
{
if (table[rowA]["url"].ToString()==table[rowB]["url"].ToString())
{
sqlRdr = executeQuery("SELECT COUNT(*) FROM Media WHERE url = '" + table[rowA]["url"].ToString() + "'");
sqlRdr.Read();
int numDups = (int)sqlRdr[0];
while (numDups > 1)
{
Console.WriteLine("Deleting dups.");
removeFirstOccurance(table[rowA]["url"].ToString());
numDups--;
}
}
}
}
}
}
public string[] grabURLs()
{
string[] mediaURLs;
sqlRdr = new SqlCeCommand("SELECT COUNT(*) FROM Media", sc).ExecuteReader();
sqlRdr.Read();
int numFiles = (int)sqlRdr[0];
int count = 0;
string query = "SELECT url FROM Media;";
sqlCmd = new SqlCeCommand(query, sc);
sqlRdr = sqlCmd.ExecuteReader();
mediaURLs = new string[numFiles];
while (sqlRdr.Read())
{
mediaURLs[count] = sqlRdr["url"].ToString();
count++;
}
return mediaURLs;
}
public string[] grabActiveURLs()
{
ArrayList mediaURLs = new ArrayList();
string query = "SELECT * FROM Media;";
sqlCmd = new SqlCeCommand(query, sc);
sqlRdr = sqlCmd.ExecuteReader();
while (sqlRdr.Read())
{
if ((DateTime.Parse(sqlRdr["date_start"].ToString()) <= DateTime.Now) &&
(DateTime.Parse(sqlRdr["date_end"].ToString()) >= DateTime.Now))
{
Console.WriteLine("Okay");
mediaURLs.Add(sqlRdr["url"].ToString());
}
}
return mediaURLs.ToArray(typeof(string)) as string[];
}
private DataTable ReaderToDT(SqlCeDataReader dataReader)
{
DataTable dt = new DataTable();
foreach (DataRow dr in dataReader.GetSchemaTable().Rows)
{
dt.Columns.Add(dr["ColumnName"] as string, (Type)(dr["DataType"]));
}
while (dataReader.Read())
{
DataRow dr = dt.NewRow();
foreach (DataColumn dc in dt.Columns)
{
dr[dc] = dataReader[dc.ColumnName];
}
dt.Rows.Add(dr);
}
return dt;
}
private bool DoReadMeaningId(SqlCeDataReader reader, ref Guid meaningId)
{
lock (_connVocabulary)
{
bool success = reader.Read();
if (success)
{
meaningId = (Guid)reader[0];
}
return success;
}
}
/// <summary>
/// Converts a SqlCeDataReader to a DataSet
/// <param name='reader'>
/// SqlDataReader to convert.</param>
/// <returns>
/// DataSet filled with the contents of the reader.</returns>
/// </summary>
public static DataSet ConvertDataReaderToDataSet(SqlCeDataReader reader, string tabela)
{
DataSet dataSet = new DataSet();
do
{
// Create new data table
DataTable schemaTable = reader.GetSchemaTable();
DataTable dataTable = new DataTable(tabela);
if (schemaTable != null)
{
// A query returning records was executed
for (int i = 0; i < schemaTable.Rows.Count; i++)
{
DataRow dataRow = schemaTable.Rows[i];
// Create a column name that is unique in the data table
string columnName = (string)dataRow["ColumnName"]; //+ "<C" + i + "/>";
// Add the column definition to the data table
DataColumn column = new DataColumn(columnName, (Type)dataRow["DataType"]);
dataTable.Columns.Add(column);
}
dataSet.Tables.Add(dataTable);
// Fill the data table we just created
while (reader.Read())
{
DataRow dataRow = dataTable.NewRow();
for (int i = 0; i < reader.FieldCount; i++)
dataRow[i] = reader.GetValue(i);
dataTable.Rows.Add(dataRow);
}
}
else
{
// No records were returned
DataColumn column = new DataColumn("RowsAffected");
dataTable.Columns.Add(column);
dataSet.Tables.Add(dataTable);
DataRow dataRow = dataTable.NewRow();
dataRow[0] = reader.RecordsAffected;
dataTable.Rows.Add(dataRow);
}
}
while (reader.NextResult());
return dataSet;
}
