private static IEnumerable <EcCard> LoadFromReader(OleDbDataReader reader) { if (reader == null) { yield break; } int idIndex = reader.GetOrdinal("ID"); int custIndex = reader.GetOrdinal("KndNr"); int projIndex = reader.GetOrdinal("ProjNr"); int cardNoIndex = reader.GetOrdinal("Kartennr"); int cardIdIndex = reader.GetOrdinal("CardZK"); int textIndex = reader.GetOrdinal("Text"); int[] flagIndexes = new int[13]; for (int i = 0; i < FlagNames.Length; i++) { flagIndexes[i] = reader.GetOrdinal(FlagNames[i]); } while (reader.Read()) { var card = new EcCard(); card.ID = reader.GetInt32(idIndex); card.CustomerNumber = (int)reader.GetDouble(custIndex); card.ProjectNumber = (int)reader.GetDouble(projIndex); card.CardNumber = reader.GetInt16(cardNoIndex); card.CardIdentity = reader.GetString(cardIdIndex); card.Text = reader.GetValue(textIndex) as string; for (int i = 0; i < FlagNames.Length; i++) { card._flags[i] = reader.GetBoolean(flagIndexes[i]); } yield return(card); } }
/// <summary> /// this function returns all published posts. /// </summary> /// <returns>all the posts that are published.</returns> public Dictionary <int, Post> getAllPublishedPosts() { Dictionary <int, Post> res = new Dictionary <int, Post>(); dataset.Open(); string query = "SELECT * FROM posts WHERE [isPublished] = " + true.ToString(); OleDbCommand checker = new OleDbCommand(query, dataset); OleDbDataReader reader = checker.ExecuteReader(); while (reader.Read()) { Post postToAdd = new Post(reader.GetString(0), reader.GetString(1), new List <string>(), reader.GetString(2), reader.GetString(3), reader.GetBoolean(4)); int postid = reader.GetInt32(5); postToAdd.id = postid.ToString(); res.Add(postid, postToAdd); } dataset.Close(); dataset.Open(); foreach (int i in res.Keys) { string queryForAreas = "SELECT area FROM PostsAreas WHERE postid = " + i; OleDbCommand checker1 = new OleDbCommand(queryForAreas, dataset); OleDbDataReader reader1 = checker1.ExecuteReader(); List <string> area = new List <string>(); while (reader1.Read()) { area.Add(reader1.GetString(0)); } res[i].postAreas = area; } dataset.Close(); return(res); }
///////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////// // Private methods ///////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////// private ProfileInfoCollection GetProfilesForQuery(string sqlQuery, OleDbParameter[] args, int pageIndex, int pageSize, out int totalRecords) { if (pageIndex < 0) { throw new ArgumentException("Page index must be non-negative", "pageIndex"); } if (pageSize < 1) { throw new ArgumentException("Page size must be positive", "pageSize"); } long lBound = (long)pageIndex * pageSize; long uBound = lBound + pageSize - 1; if (uBound > System.Int32.MaxValue) { throw new ArgumentException("pageIndex*pageSize too large"); } try { AccessConnectionHolder holder = AccessConnectionHelper.GetConnection(_DatabaseFileName, true); ProfileInfoCollection profiles = new ProfileInfoCollection(); OleDbDataReader reader = null; try { OleDbCommand cmd = new OleDbCommand(sqlQuery, holder.Connection); cmd.Parameters.Add(new OleDbParameter("@AppId", GetApplicationId(holder))); int len = args.Length; for (int iter = 0; iter < len; iter++) { cmd.Parameters.Add(args[iter]); } reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess); totalRecords = 0; while (reader.Read()) { totalRecords++; if (totalRecords - 1 < lBound || totalRecords - 1 > uBound) { continue; } string username; DateTime dtLastActivity, dtLastUpdated; bool isAnon; username = reader.GetString(0); isAnon = reader.GetBoolean(1); dtLastActivity = reader.GetDateTime(2); dtLastUpdated = reader.GetDateTime(3); int size = reader.GetInt32(4); profiles.Add(new ProfileInfo(username, isAnon, dtLastActivity, dtLastUpdated, size)); } return(profiles); } catch (Exception e) { throw AccessConnectionHelper.GetBetterException(e, holder); } finally { if (reader != null) { reader.Close(); } holder.Close(); } } catch { throw; } }
//Onglet 1a1 private void init1a1(int ligne) { try { lvPersonne.Items.Clear(); List <int> max = new List <int>(); string jointure = ""; int codeTransaction = 0; List <int> Personne = new List <int>(); OleDbCommand cd0 = new OleDbCommand("SELECT [codeTransaction] FROM[Transaction]", connec); connec.Open(); OleDbDataReader dr0 = cd0.ExecuteReader(); while (dr0.Read()) { max.Add(dr0.GetInt32(0)); } if (ligne == -2) { ligne = 1; ligneTable = 1; } else if (ligne == -1) { if (ligneTable == 1) { ligne = 1; } else { ligneTable--; ligne = ligneTable; } } else if (ligne == 1) { if (ligneTable == max.Count) { ligne = max.Count; } else { ligneTable++; ligne = ligneTable; } } else { ligne = max.Count; ligneTable = max.Count; } OleDbCommand cd1 = new OleDbCommand("SELECT [Transaction].* FROM[Transaction] where [codeTransaction] = " + ligne, connec); OleDbDataReader dr1 = cd1.ExecuteReader(); while (dr1.Read()) { lblCode.Text = dr1.GetInt32(0).ToString(); codeTransaction = dr1.GetInt32(0); dtp1a1.Value = dr1.GetDateTime(1); lblDescription.Text = dr1.GetString(2); lblValeur.Text = dr1.GetValue(3).ToString() + " €"; checkRecette.Checked = dr1.GetBoolean(4); chkPercu.Checked = dr1.GetBoolean(5); if (dr1[6].ToString() == "") { jointure = ""; } else { jointure = dr1.GetInt32(6).ToString(); } } if (jointure != "") { //Pour eviter de faire une requette avec une jointure OleDbCommand cd2 = new OleDbCommand("SELECT [TypeTransaction].* FROM [TypeTransaction] where [codeType] = " + jointure, connec); OleDbDataReader dr2 = cd2.ExecuteReader(); while (dr2.Read()) { lblType.Text = dr2.GetString(1); } } else { lblType.Text = "Type NULL"; } OleDbCommand cd3 = new OleDbCommand("SELECT [CodePersonne] FROM[Beneficiaires] where [codeTransaction] =" + codeTransaction, connec); OleDbDataReader dr3 = cd3.ExecuteReader(); while (dr3.Read()) { Personne.Add(dr3.GetInt32(0)); } for (int i = 0; i < Personne.Count(); i++) { OleDbCommand cd4 = new OleDbCommand("SELECT [nomPersonne],[pnPersonne] FROM[Personne] where [codePersonne] =" + Personne[i].ToString(), connec); OleDbDataReader dr4 = cd4.ExecuteReader(); while (dr4.Read()) { lvPersonne.Items.Add(dr4.GetString(0) + dr4.GetString(1)); } } connec.Close(); } catch (InvalidOperationException erreur) { MessageBox.Show("Erreur de chaine de connexion ! 1a1"); } catch (OleDbException erreur) { MessageBox.Show("Erreur de requete SQL ! 1a1"); } }
private void Modifier_Bien_Load(object sender, EventArgs e) { string ChaineBd = "Provider=SQLOLEDB;Data Source=INFO-joyeux;Initial Catalog=IMMOBILLY_JACKYTEAM;Persist Security Info=True; Integrated Security=sspi;"; OleDbConnection dbConnection = new OleDbConnection(ChaineBd); dbConnection.Open(); string sql = "select b.code_bien, b.surface_habitable, b.surface_parcelle, b.nb_piéces, b.nb_chambres, b.nb_Salle_de_bain, b.garage, b.cave, b.prix_vendeur, b.adresse, b.date_Mise_en_Vente, b.commentaire, b.statut, vi.nom_ville, vi.code_postal, ve.nom_client, ve.prénom_client, ve.téléphone, ve.e_mail from bien b left join ville vi on vi.code_ville = b.code_ville left join vendeur ve on ve.num_client = b.num_client where b.code_bien = '" + ApplicationState.id_bien + "' "; OleDbCommand cmd = new OleDbCommand(sql, dbConnection); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { textBox1.Text = reader.GetInt16(0).ToString(); textBox2.Text = reader.GetInt32(1).ToString(); textBox3.Text = reader.GetInt32(2).ToString(); numericUpDown1.Value = reader.GetInt32(3); numericUpDown2.Value = reader.GetInt32(4); numericUpDown3.Value = reader.GetInt32(5); if (reader.GetBoolean(6) == true) { Garage.Checked = true; } if (reader.GetBoolean(7) == true) { Cave.Checked = true; } textBox4.Text = reader.GetInt32(8).ToString(); dateTimePicker1.Text = reader.GetDateTime(10).ToString(); textBox12.Text = reader.GetString(9); if (reader.GetString(12) == "D") { Disponible.Checked = true; } if (reader.GetString(12) == "S") { Sous_Sein.Checked = true; } if (reader.GetString(12) == "V") { Vendu.Checked = true; } if (reader.GetString(12) == "R") { Retire.Checked = true; } textBox9.Text = reader.GetString(11); textBox11.Text = reader.GetString(13); textBox10.Text = reader.GetValue(14).ToString(); } reader.Close(); string sql1 = "Select count (v.code_visite) nb_visite from bien b left join proposition p on p.code_bien = b.code_bien left join visite v on v.code_proposition = p.code_proposition where b.code_bien = '" + textBox1.Text + "' "; OleDbCommand cmd1 = new OleDbCommand(sql1, dbConnection); OleDbDataReader reader1 = cmd1.ExecuteReader(); while (reader1.Read()) { textBox5.Text = reader1.GetValue(0).ToString(); } reader1.Close(); }
private static void visualizzaVeicoli() { if (connectionString != null) { OleDbConnection connection = new OleDbConnection(connectionString); using (connection) { connection.Open(); OleDbCommand command = new OleDbCommand("SELECT * FROM Veicoli", connection); try { OleDbDataReader exeReader = command.ExecuteReader(); if (exeReader.HasRows) { Console.WriteLine("\n"); while (exeReader.Read()) { Console.WriteLine("{0} | {1} | {2} | {3} | {4} | {5} | {6} | {7} | {8} | {9} | {10} | {11} | {12}", exeReader.GetInt32(0), exeReader.GetString(1), exeReader.GetString(2), exeReader.GetString(3), exeReader.GetString(4), exeReader.GetInt32(5), exeReader.GetInt32(6), exeReader.GetDateTime(7).ToShortDateString(), exeReader.GetBoolean(8), exeReader.GetBoolean(9), exeReader.GetInt32(10), exeReader.GetString(11), exeReader.GetString(12)); } } else { Console.WriteLine("\n\nIL DATABASE NON CONTIENE VEICOLI!"); } exeReader.Close(); } catch (Exception ex) { Console.WriteLine($"\n{ex.Message}"); } } Thread.Sleep(8000); } }
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { try { con.Open(); string selectedGod = godsListComboBox.Text; cmd.Connection = con; //Constructing SQL Query string query = String.Format("select * from [{0}]", selectedGod); cmd.CommandText = query; cmd.ExecuteNonQuery(); //Making reader object OleDbDataReader reader = cmd.ExecuteReader(); //Reading and updating acquired skins box skinsAcquiredListBox.Update(); skinsAcquiredListBox.Items.Clear(); while (reader.Read()) { skinsAcquiredListBox.Items.Add(reader["Skins"]); skinsAcquiredListBox.SetItemChecked(skinsAcquiredListBox.Items.IndexOf(reader.GetString(0)), reader.GetBoolean(1)); } skinsAcquiredListBox.EndUpdate(); con.Close(); } catch (Exception ex) { MessageBox.Show("Ryan's Error Catcher:\n\n" + ex); con.Close(); } }
/// <summary> /// Fetches all persons and resources from database /// </summary> /// <returns>Returns list of all person and resources, If return is null something has gone wrong</returns> internal int getPersonsResources(out SortedList retlist) { // Get all persons i database String sqlcmd = "SELECT name, color, pass, administrator FROM Person WHERE name<>'admin'"; OleDbDataReader reader = executeSql(sqlcmd); retlist = new SortedList(); if (reader == null) { return(ErrorHandler.ERR_FETCH_PERSON); } // Add all persons to the sortedlist int i = 0; while (reader.Read()) { Person person = new Person(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetBoolean(3)); retlist.Add(i, person); i++; } reader.Close(); // Get all resources from database sqlcmd = "SELECT name, color FROM Resource"; reader = executeSql(sqlcmd); if (reader == null) { return(ErrorHandler.ERR_FETCH_RESOURCE); } // Add all resources to the sortedlist while (reader.Read()) { Resource resurs = new Resource(reader.GetString(0), reader.GetString(1)); retlist.Add(i, resurs); i++; } reader.Close(); return(ErrorHandler.NO_ERROR); }
public Kurswahlen(string aktSj, Klasses klasses, Fachs fachs, Unterrichts unterrichts, int periode) { using (OleDbConnection oleDbConnection = new OleDbConnection(Global.ConnectionStringUntis)) { try { Console.Write("Kurswahlen ".PadRight(75, '.') + " "); string queryString = @"SELECT StudentChoice.STUDENT_ID, Student.Longname, Student.FirstName, Student.BirthDate, StudentChoice.Number, StudentChoice.AlternativeCourses, Student.Name, Student.StudNumber, StudentChoice.Deleted FROM Student LEFT JOIN StudentChoice ON Student.STUDENT_ID = StudentChoice.STUDENT_ID WHERE (((StudentChoice.SCHOOLYEAR_ID)= " + aktSj + ") AND ((StudentChoice.TERM_ID)=" + periode + ")) ORDER BY StudentChoice.STUDENT_ID;"; OleDbCommand oleDbCommand = new OleDbCommand(queryString, oleDbConnection); oleDbConnection.Open(); OleDbDataReader oleDbDataReader = oleDbCommand.ExecuteReader(); while (oleDbDataReader.Read()) { Kurswahl kurswahl = new Kurswahl(aktSj, periode); kurswahl.StudentId = oleDbDataReader.GetInt32(0); try { kurswahl.Nachname = Global.SafeGetString(oleDbDataReader, 1); if (kurswahl.Nachname == "Dillhage") { string a = ""; } kurswahl.Vorname = Global.SafeGetString(oleDbDataReader, 2); kurswahl.Geburtsdatum = DateTime.ParseExact((oleDbDataReader.GetInt32(3)).ToString(), "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture); kurswahl.Number = Convert.ToInt32(oleDbDataReader.GetValue(4)); kurswahl.AlternativeCourses.Add(Global.SafeGetString(oleDbDataReader, 5)); kurswahl.StudentKurzname = Global.SafeGetString(oleDbDataReader, 6); kurswahl.Fach = (from f in fachs where f.IdUntis.ToString() == kurswahl.AlternativeCourses[0].Split('/')[1] select f.KürzelUntis).FirstOrDefault(); kurswahl.Klasse = (from u in unterrichts where u.IdUntis.ToString() == kurswahl.AlternativeCourses[0].Split('/')[0] select u.Klasse.NameUntis).FirstOrDefault(); kurswahl.AtlantisId = Global.SafeGetString(oleDbDataReader, 7); kurswahl.Deleted = oleDbDataReader.GetBoolean(8); this.Add(kurswahl); } catch (Exception) { Console.WriteLine("Schüler " + kurswahl.Nachname + " " + kurswahl.Vorname + " hat keine Klasse"); } } ; oleDbDataReader.Close(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { oleDbConnection.Close(); Console.WriteLine(this.Count); } } }
private void Form6_Load(object sender, EventArgs e) { OleDbConnection connection = new OleDbConnection("Provider=VFPOLEDB.1;" + "Data Source=C:\\Users\\igory\\Desktop\\gdk_db\\data1.dbc;"); OleDbCommand command = new OleDbCommand("SELECT id, login, password, f, i, o, pol, admin from table1", connection); connection.Open(); command.Connection = connection; OleDbDataReader reader = command.ExecuteReader(); int i = 0; while (reader.Read()) { dataGridView1.Rows.Add(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetBoolean(6), reader.GetBoolean(7)); } connection.Close(); }
private static void visualizzaListaVeicoli() { if (connStr != null) { OleDbConnection connection = new OleDbConnection(connStr); using (connection) { connection.Open(); OleDbCommand command = new OleDbCommand("SELECT * FROM Veicoli", connection); try { OleDbDataReader rdr = command.ExecuteReader(); if (rdr.HasRows) { Console.WriteLine("\n"); while (rdr.Read()) { Console.WriteLine("{0} | {1} | {2} | {3} | {4} | {5} | {6} | {7} | {8} | {9} | {10} | {11}", rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetInt32(5), rdr.GetInt32(6), rdr.GetDateTime(7).ToShortDateString(), rdr.GetBoolean(8), rdr.GetBoolean(9), rdr.GetInt32(10), rdr.GetString(11)); } } else { Console.WriteLine("\n\nNel DB non sono presenti veicoli"); } rdr.Close(); } catch (Exception ex) { Console.WriteLine($"\n{ex.Message}"); } } Thread.Sleep(7000); } }
private ProfileInfoCollection GetProfilesForQuery(OleDbParameter[] insertArgs, int pageIndex, int pageSize, StringBuilder insertQuery, out int totalRecords) { if (pageIndex < 0) { throw new ArgumentException("pageIndex"); } if (pageSize < 1) { throw new ArgumentException("pageSize"); } long lowerBound = (long)pageIndex * pageSize; long upperBound = lowerBound + pageSize - 1; if (upperBound > Int32.MaxValue) { throw new ArgumentException("pageIndex and pageSize"); } OleDbConnection conn = null; OleDbDataReader reader = null; OleDbCommand cmd = null; try { conn = new OleDbConnection(SqlHelper.ConnString); conn.Open(); StringBuilder cmdStr = new StringBuilder(200); // Create a temp table TO store the select results cmd = new OleDbCommand("CREATE TABLE #PageIndexForProfileUsers(IndexId int IDENTITY (0, 1) NOT NULL, UserId int)", conn); cmd.CommandTimeout = CommandTimeout; cmd.ExecuteNonQuery(); cmd.Dispose(); insertQuery.Append(" ORDER BY UserName"); cmd = new OleDbCommand(insertQuery.ToString(), conn); cmd.CommandTimeout = CommandTimeout; if (insertArgs != null) { foreach (OleDbParameter arg in insertArgs) { cmd.Parameters.Add(arg); } } cmd.ExecuteNonQuery(); cmd.Dispose(); cmdStr = new StringBuilder(200); cmdStr.AppendFormat("SELECT u.M_NAME, u.M_LASTHEREDATE, p.M_LASTUPDATED FROM {0}MEMBERS u, ", Config.MemberTablePrefix).AppendLine(TableName); cmdStr.Append(" p, #PageIndexForProfileUsers i WHERE u.MEMBER_ID = p.UserId AND p.UserId = i.UserId AND i.IndexId >= "); cmdStr.Append(lowerBound).Append(" AND i.IndexId <= ").Append(upperBound); cmd = new OleDbCommand(cmdStr.ToString(), conn); cmd.CommandTimeout = CommandTimeout; reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess); ProfileInfoCollection profiles = new ProfileInfoCollection(); while (reader.Read()) { string username; DateTime dtLastActivity, dtLastUpdated = DateTime.UtcNow; bool isAnon; username = reader.GetString(0); isAnon = reader.GetBoolean(1); dtLastActivity = DateTime.SpecifyKind(reader.GetDateTime(2), DateTimeKind.Utc); dtLastUpdated = DateTime.SpecifyKind(reader.GetDateTime(3), DateTimeKind.Utc); profiles.Add(new ProfileInfo(username, isAnon, dtLastActivity, dtLastUpdated, 0)); } totalRecords = profiles.Count; if (reader != null) { reader.Close(); reader = null; } cmd.Dispose(); // Cleanup, REVIEW: should move to finally? cmd = new OleDbCommand("DROP TABLE #PageIndexForProfileUsers", conn); cmd.ExecuteNonQuery(); return(profiles); } finally { if (reader != null) { reader.Close(); } if (cmd != null) { cmd.Dispose(); } if (conn != null) { conn.Close(); conn = null; } } }
public void generateTimeTable() { OleDbConnection con = new OleDbConnection(connectionString); con.Open(); OleDbCommand cmd = new OleDbCommand("SELECT count(*) FROM Lessons", con); int[] lessonsID = new int[Convert.ToInt32(cmd.ExecuteScalar())]; cmd = new OleDbCommand("SELECT ID FROM Lessons", con); OleDbDataReader odr = cmd.ExecuteReader(); for (int i = 0; i < lessonsID.Length; i++) { odr.Read(); lessonsID[i] = odr.GetInt32(0); } con.Close(); lessonsID = sortLessonsByDegreeOfFreedom(lessonsID); timetable = new Lesson[count, 5, 5]; for (int i = 0; i < lessonsID.Length; i++) { con.Open(); cmd = new OleDbCommand("SELECT * FROM Lessons WHERE Lessons.ID = " + lessonsID[i], con); odr = cmd.ExecuteReader(); odr.Read(); bool isLect = odr.GetBoolean(2); int group = odr.GetInt32(3); int tID = odr.GetInt32(4); // Вытащим массив всех подходящих аудиторий cmd = new OleDbCommand("SELECT Room FROM Rooms WHERE (Capacity >= " + "(SELECT Population FROM Groups WHERE Number = " + group + ")" + ") AND (Projector = " + "(SELECT Projector FROM Lessons WHERE ID = " + lessonsID[i] + ")" + ") AND (Laboratory = " + "(SELECT Laboratory FROM Lessons WHERE ID = " + lessonsID[i] + ")" + ") AND (Computers = " + "(SELECT Computers FROM Lessons WHERE ID = " + lessonsID[i] + ")" + ") AND (Gym = " + "(SELECT Gym FROM Lessons WHERE ID = " + lessonsID[i] + "))", con); OleDbDataReader reader = cmd.ExecuteReader(); List <int> rooms = new List <int>(); while (reader.Read()) { rooms.Add(reader.GetInt32(0)); } // Заменим фактический номер группы на ее порядковый номер, как индекс массива int groupIndex = 0; cmd = new OleDbCommand("SELECT Number FROM Groups", con); reader = cmd.ExecuteReader(); for (int num = 0; num < count; num++) { reader.Read(); if (group == reader.GetInt32(0)) { groupIndex = num; break; } } con.Close(); double max = -1.0; int r_max = -1; int day_max = -1; int pos_max = -1; foreach (int r in rooms) { // Подберем нужное время double R_max = -10.0; int d = -1; int p = -1; double R; for (int day = 0; day < 5; day++) { for (int pos = 0; pos < 5; pos++) { if (timetable[groupIndex, day, pos].id != 0) { continue; } bool flag = false; for (int t = 0; t < count; t++) { if ((timetable[t, day, pos].id != 0) && (t != groupIndex) && ((timetable[t, day, pos].room == r) || (timetable[t, day, pos].tId == tID))) { flag = true; break; } } if (!flag) { R = 0; R += w[0] * measureOfQualityInTimeSpace(groupIndex, tID, 0, day, pos); R += w[1] * measureOfQualityInTimeSpace(groupIndex, tID, 1, day, pos); R += w[2] * measureOfQualityInTimeSpace(groupIndex, tID, 2, day, pos); R += w[3] * measureOfQualityInTimeSpace(groupIndex, tID, 3, day, pos); R += w[4] * measureOfQualityInTimeSpace(groupIndex, tID, 4, day, pos); if (R > R_max) { R_max = R; d = day; p = pos; } } } } if (R_max + w[5] * measureOfQualityInRoomSpace(group, r) > max) { max = R_max + w[5] * measureOfQualityInRoomSpace(group, r); r_max = r; day_max = d; pos_max = p; } } timetable[groupIndex, day_max, pos_max] = new Lesson(lessonsID[i], isLect, tID, r_max); } }
static void BanUserMenu() { try { bool isBanned = false; ReadAllUsers(); // target id Console.Write("\nSelect ID you want to BAN/UNBAN ('0' back to menu): "); int id = int.Parse(Console.ReadLine()); if (id != 0) { // check if banned and shows some basic info myConnection.Open(); OleDbCommand myCommandSelectID = new OleDbCommand("SELECT * FROM RegisteredUsers WHERE ID=@id", myConnection); myCommandSelectID.Parameters.AddWithValue("@id", id); OleDbDataReader myReader = myCommandSelectID.ExecuteReader(); while (myReader.Read()) { if (myReader.GetBoolean(8) == true) { isBanned = true; } else { isBanned = false; } Console.Write("\nid: {0} usrname: {1} \n\n ", myReader.GetInt32(0).ToString(), myReader.GetString(1)); } myReader.Close(); myConnection.Close(); if (isBanned == true) { Console.Write("Do you want to UNBAN this user? (y/n) "); string choice = Console.ReadLine(); do { if (choice == "y") { EditUserCommand("banned", "false", id); Console.ReadLine(); BanUserMenu(); } else if (choice == "n") { Console.WriteLine("\nYour choice was 'NO'. Press any key to continue ..."); Console.ReadLine(); BanUserMenu(); } } while (choice == ""); } else if (isBanned == false) { Console.Write("Do you want to BAN this user? (y/n) "); string choice = Console.ReadLine(); do { if (choice == "y") { EditUserCommand("banned", "true", id); Console.WriteLine(""); Console.ReadKey(); BanUserMenu(); } else if (choice == "n") { Console.WriteLine("\nYour choice was 'NO'. Press any key to continue ..."); Console.ReadLine(); BanUserMenu(); } } while (choice == ""); } } else { Menu(); } } catch (Exception e) { myConnection.Close(); ErrorDisplay(e.StackTrace); } }
static void EditUserMenu() { try { ReadAllUsers(); // target id Console.Write("\n\nSelect ID you want to change ('0' - back to menu): "); int id = int.Parse(Console.ReadLine()); if (id != 0) { // show target info myConnection.Open(); OleDbCommand myCommandSelectID = new OleDbCommand("SELECT * FROM RegisteredUsers WHERE ID=@id", myConnection); myCommandSelectID.Parameters.AddWithValue("@id", id); OleDbDataReader myReader = myCommandSelectID.ExecuteReader(); while (myReader.Read()) { Console.WriteLine("\nID: {0}\n1) username: {1}\n2) password: {2}\n3) email: {3}\n4) Realname: {4}\n5) birthday: {5}\n6) active: {6}", myReader.GetInt32(0).ToString(), myReader.GetString(1), myReader.GetString(2), myReader.GetString(3), myReader.GetString(4), myReader.GetDateTime(6).ToString("yyyy-MM-dd"), myReader.GetBoolean(7)); } myReader.Close(); myConnection.Close(); // pick value to change int choice; string newValue; do { Console.Write("\nValue you want to change (write digit or '0' to change id): "); choice = int.Parse(Console.ReadLine()); if (choice == 1) { Console.Write("\nWrite new username: "******""); EditUserCommand("username", newValue, id); } else if (choice == 2) { Console.Write("\nWrite new password: "******""); EditUserCommand("password", newValue, id); } else if (choice == 3) { Console.Write("\nWrite new email: "); do { newValue = Console.ReadLine(); } while (newValue == ""); EditUserCommand("email", newValue, id); } else if (choice == 4) { Console.Write("\nWrite new name: "); do { newValue = Console.ReadLine(); } while (newValue == ""); EditUserCommand("realname", newValue, id); } else if (choice == 5) { Console.Write("\nWrite new birthday(yyyy-mm-dd): "); do { newValue = Console.ReadLine(); } while (newValue == ""); EditUserCommand("birthday", newValue, id); } else if (choice == 6) { Console.Write("\nIs user activated by email? (true/false): "); do { newValue = Console.ReadLine(); } while (newValue == ""); EditUserCommand("activated", newValue, id); } else if (choice == 7) { Console.Write("\nIs user banned? (true/false): "); do { newValue = Console.ReadLine(); } while (newValue == ""); EditUserCommand("banned", newValue, id); } else if (choice == 0) { EditUserMenu(); Console.ReadKey(); } } while (choice != 0); } else { Menu(); } } catch (Exception e) { myConnection.Close(); ErrorDisplay(e.Message); } }
public void WczytajRole(Konto konto) { conn.Open(); var zapytanie = $"Select * from Role WHERE Rola='{konto.rola}'"; OleDbCommand komenda = new OleDbCommand(zapytanie, conn); OleDbDataReader reader = komenda.ExecuteReader(); role.Clear(); while (reader.Read()) { Rola rola = new Rola( reader.GetString(0), // rola reader.GetBoolean(1), // adresy odczyt reader.GetBoolean(2), // adresy zapis reader.GetBoolean(3), // konta odczyt reader.GetBoolean(4), // konta zapis reader.GetBoolean(5), // oceny odczyt reader.GetBoolean(6), // oceny zapis reader.GetBoolean(7), // produkty odczyt reader.GetBoolean(8), // produkty zapis reader.GetBoolean(9), // role odczyt reader.GetBoolean(10), // role zapis reader.GetBoolean(11), // transakcje odczyt reader.GetBoolean(12), // transakcje zapis reader.GetBoolean(13), // zamowienia odczyt reader.GetBoolean(14) // zamowienia zapis ); role.Add(rola); } conn.Close(); }
/// <summary> /// Get resourceboxes from the database /// </summary> /// <param name="startdate">Startdate of the resourceboxes to read, if DateTime(0) all resourceboxes are fetched</param> /// <param name="enddate">Enddate of the resourceboxes to read</param> /// <returns>0 - If all is ok</returns> internal int getResourceBoxes(DateTime startdate, DateTime enddate, out SortedList retlist) { /* Create SQL code for fetching resourceboxes */ String sqlcmd = "SELECT id, starttime, endtime, name, free, locked, lockedstarttime, lockedendtime FROM ResourceBox"; // If startdate and enddate is given, use them in a WHERE part of SQL if (startdate != new DateTime(0)) { sqlcmd += " WHERE starttime BETWEEN #" + startdate.ToShortDateString() + " " + startdate.ToLongTimeString() + "# AND #" + enddate.ToShortDateString() + " " + enddate.ToLongTimeString() + "#"; } // #1.01.003 - added line sqlcmd += " ORDER BY starttime"; retlist = new SortedList(); // Get data from database OleDbDataReader reader = executeSql(sqlcmd); if (reader == null) { return(ErrorHandler.ERR_UNEXPECTED_RESOURCEBOX_FETCH); } int i = 0; // #1.01.003 - added lines ResourceBox[] rbs; rbs = new ResourceBox[20000]; // Add all data in the sortedlist while (reader.Read()) { ResourceBox resursbox = new ResourceBox(reader.GetDateTime(1), reader.GetDateTime(2), reader.GetString(3), reader.GetBoolean(4), reader.GetBoolean(5), reader.GetDateTime(6), reader.GetDateTime(7)); resursbox.Id = reader.GetInt32(0); // Get all overlaps of resourcebox retlist.Add(resursbox.Id, resursbox); rbs[i] = resursbox; // #1.01.003 - added line i++; } // #1.01.003 - added lines for (int o = 0; o < i - 1; o++) { for (int a = o + 1; rbs[a].StartTime <= rbs[o].EndTime && o < i; a++) { if (rbs[a].StartTime != rbs[a].EndTime && rbs[o].StartTime != rbs[o].EndTime) { rbs[a].IdsNextTo.Add(rbs[o].Id, rbs[o].Id); rbs[o].IdsNextTo.Add(rbs[a].Id, rbs[a].Id); } // #1.03 - added lines if (a + 1 >= i) { break; } } } // #1.01.003 - end reader.Close(); return(ErrorHandler.NO_ERROR); }
public bool ImporteerSorteerFilms(string syntaxSQL) { bool gelukt = false; OleDbDataReader dbRead = null; string sqlOpdracht = syntaxSQL; try { dbConn.Open(); sqlCommand = new OleDbCommand(sqlOpdracht, dbConn); dbRead = sqlCommand.ExecuteReader(); while (dbRead.Read()) { int _id = dbRead.GetInt16(0); string _title = dbRead.GetString(1).ToString(); int _year = dbRead.GetInt16(2); int _runTime = dbRead.GetInt16(3); string _genre = dbRead.GetString(4).ToString(); string _director = dbRead.GetString(5).ToString(); string _actor = dbRead.GetString(6).ToString(); string _description = dbRead.GetString(7).ToString(); string _awards = dbRead.GetString(8).ToString(); string _coverURL = dbRead.GetString(9).ToString(); int _metaScore = dbRead.GetInt16(10); double _imdbRating = dbRead.GetDouble(11); string _imdbID = dbRead.GetString(12).ToString(); string _url = dbRead.GetString(13).ToString(); bool _watched = dbRead.GetBoolean(14); bool _favorite = dbRead.GetBoolean(15); Movie film = new Movie { id = (int)_id, title = _title, year = _year, runTime = _runTime, genre = _genre, director = _director, actor = _actor, description = _description, awards = _awards, coverURL = _coverURL, metaScore = _metaScore, imdbRating = (float)_imdbRating, imdbId = _imdbID, url = _url, watched = _watched, favorite = _favorite }; filmLijst.Add(film); } gelukt = true; } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { if (dbRead != null) { dbRead.Close(); } if (dbConn != null) { dbConn.Close(); } } return(gelukt); }
public Anrechnungs() { Anrechnungsgrunds anrechnungsgrunds = new Anrechnungsgrunds(); using (OleDbConnection oleDbConnection = new OleDbConnection(Global.ConU)) { try { string queryString = @"SELECT CountValue.Deleted, CountValue.Text, CountValue.Value, CountValue.CV_REASON_ID, CountValue.TEACHER_ID, CountValue.DateFrom, CountValue.DateTo, Teacher.Name, Teacher.PlannedWeek FROM CountValue LEFT JOIN Teacher ON CountValue.TEACHER_ID = Teacher.TEACHER_ID WHERE (((CountValue.SCHOOLYEAR_ID)=" + Global.AktSjUnt + @") AND ((CountValue.Deleted)=False) AND ((CountValue.Value)<>0) AND ((CountValue.TEACHER_ID)<>0) AND ((Teacher.SCHOOLYEAR_ID)=" + Global.AktSjUnt + @")) ORDER BY CountValue.TEACHER_ID;"; OleDbCommand oleDbCommand = new OleDbCommand(queryString, oleDbConnection); oleDbConnection.Open(); OleDbDataReader oleDbDataReader = oleDbCommand.ExecuteReader(); double gesamtwert = 0; while (oleDbDataReader.Read()) { double wert; try { wert = Convert.ToDouble(oleDbDataReader.GetInt32(2)) / 100000; } catch (Exception) { wert = 0; } Anrechnung anrechnung = new Anrechnung() { Gelöscht = oleDbDataReader.GetBoolean(0), Beschreibung = Global.SafeGetString(oleDbDataReader, 1), Wert = wert, Grund = (from a in anrechnungsgrunds where a.UntisId == oleDbDataReader.GetInt32(3) select a).FirstOrDefault(), LehrerIdUntis = oleDbDataReader.GetInt32(4), Von = oleDbDataReader.GetInt32(5) == 0 ? Global.ErsterTagDesSchuljahres : DateTime.ParseExact((oleDbDataReader.GetInt32(5)).ToString(), "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture), Bis = oleDbDataReader.GetInt32(6) == 0 ? Global.ErsterTagDesSchuljahres : DateTime.ParseExact((oleDbDataReader.GetInt32(6)).ToString(), "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture), LehrerKürzel = Global.SafeGetString(oleDbDataReader, 7), DeputatSoll = Convert.ToDouble(oleDbDataReader.GetInt32(8)) / 1000 }; // Wenn eine Anrechnung mit dem selben Lehrer und dem selben Grund schon existiert, dann wird der Wert addiert, ... var anr = (from an in this where an.LehrerIdUntis == anrechnung.LehrerIdUntis where an.Grund == anrechnung.Grund select an).FirstOrDefault(); if (anr != null) { anr.Wert = anr.Wert + anrechnung.Wert; } else { this.Add(anrechnung); } gesamtwert = gesamtwert + anrechnung.Wert; } ; oleDbDataReader.Close(); } catch (Exception ex) { } finally { oleDbConnection.Close(); } } }
private void ShowButtonClick(object sender, EventArgs e) { int counter = 0; try { fromDateDT = DateTime.Parse(fromDayTB.Text + "/" + fromMonthTB.Text + "/" + fromYearTB.Text); toDateDT = DateTime.Parse(toDayTB.Text + "/" + toMonthTB.Text + "/" + toYearTB.Text); fromYear = fromDateDT.Year; fromMonth = fromDateDT.Month; fromDay = fromDateDT.Day; toYear = toDateDT.Year; toMonth = toDateDT.Month; toDay = toDateDT.Day; } catch (Exception ex) { MessageBox.Show("Get date from user failed. Check your date values and try again " + ex.Message, "Errors", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { OleDbCommand datacommand = new OleDbCommand(); datacommand.Connection = dataConnection; datacommand.CommandText = "SELECT * " + "FROM tblAnnuals " + "WHERE ((annualYear BETWEEN " + fromYear + " AND " + toYear + ") " + "OR (" + fromYear + "=" + toYear + "= annualYear" + " AND (annualMonth BETWEEN " + fromMonth + " AND " + toMonth + ")) " + "OR (" + fromYear + "=" + toYear + "= annualYear" + " AND " + fromMonth + "=" + toMonth + "= annualMonth" + " AND (annualDay BETWEEN " + fromDay + " AND " + toDay + ")) " + "OR (" + fromYear + "=" + toYear + "= annualYear" + " AND " + fromMonth + "=" + toMonth + "= annualMonth" + " AND " + fromDay + "=" + toDay + "= annualDay" + ")) " + "ORDER BY annualID"; OleDbDataReader dataReader = datacommand.ExecuteReader(); while (dataReader.Read()) { annualID = dataReader.GetInt32(0).ToString(); annualType = dataReader.GetString(1); annualName = dataReader.GetString(2); annualYear = dataReader.GetInt32(3).ToString(); annualMonth = dataReader.GetInt32(4).ToString(); annualDay = dataReader.GetInt32(5).ToString(); if (GregDateRadioButton.Checked && !dataReader.GetBoolean(6)) { continue; } else if (HebDateRadioButton.Checked && dataReader.GetBoolean(6)) { continue; } annualPicture = dataReader.GetString(7); counter++; EditListView(counter); } dataReader.Close(); } catch (Exception ex) { MessageBox.Show("ShowButtonClick failed. " + ex.Message, "Errors", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }
private void textBox1_MouseDoubleClick(object sender, MouseEventArgs e) { if (myport.IsOpen) { while (cflag == 0) //接受下位机卡号 { byte[] data = new byte[8]; byte[] rdata = new byte[6]; myport.Read(data, 0, 8); if ((data[6] == 0x33) && (data[7] == 0x44)) { for (int i = 0; i <= 5; i++) { rdata[i] = data[i]; } cflag = 1; ss = byteToHexStr(rdata); } } textBox1.Text = ss; //生成链接数据库字符串 string conStr = "provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Data Source=" + "myNewIC.mdb"; //创建数据库连接 OleDbConnection conn = new OleDbConnection(conStr); //打开数据库连接 conn.Open(); OleDbDataReader myReader = null; //sql语句 string sql = "select * from myTable where cstr(卡号)='" + ss + "'"; //命令 OleDbCommand cmd = new OleDbCommand(sql, conn); myReader = cmd.ExecuteReader(); if (myReader.Read()) //是否查到卡号 { if (myReader.GetBoolean(3)) //是否挂失 { www(); MessageBox.Show("此卡已挂失", "Warning"); cflag = 0; ID.Visible = false; textBox1.Visible = false; button1.Visible = true; textBox1.Text = ""; } else { if (myReader.GetBoolean(1)) //是否管理员 { MessageBox.Show("请点击管理员登录", "Warning"); cflag = 0; myport.Close(); ID.Visible = false; textBox1.Visible = false; button1.Visible = true; textBox1.Text = ""; } else { //把余额转后后发送给下位机 decimal money = myReader.GetDecimal(4); if (money >= 100) { string mm = Convert.ToString(money * 10); byte[] myMoney = new byte[8]; myMoney[0] = 0xaa; myMoney[5] = 0x00; myMoney[6] = 0x33; myMoney[7] = 0x44; for (int x = 0; x <= 3; x++) { if (mm[x] == '0') { myMoney[4 - x] = 0x30; } if (mm[x] == '1') { myMoney[4 - x] = 0x31; } if (mm[x] == '2') { myMoney[4 - x] = 0x32; } if (mm[x] == '3') { myMoney[4 - x] = 0x33; } if (mm[x] == '4') { myMoney[4 - x] = 0x34; } if (mm[x] == '5') { myMoney[4 - x] = 0x35; } if (mm[x] == '6') { myMoney[4 - x] = 0x36; } if (mm[x] == '7') { myMoney[4 - x] = 0x37; } if (mm[x] == '8') { myMoney[4 - x] = 0x38; } if (mm[x] == '9') { myMoney[4 - x] = 0x39; } } myport.Write(myMoney, 0, 8); } tString = textBox1.Text; //传递给user窗口 user form = new user(); form.ShowDialog(); this.Hide(); myport.Close(); cflag = 0; } } } else { www(); MessageBox.Show("此卡无效", "Warning"); cflag = 0; ID.Visible = false; textBox1.Visible = false; button1.Visible = true; textBox1.Text = ""; } myReader.Close(); conn.Close(); myport.Close(); } else { MessageBox.Show("请打开串口", "Warning"); ID.Visible = false; textBox1.Visible = false; button1.Visible = true; } }
public static List <ziyaretci> SelectAllziyaretci(OleDbCommand komut) { List <ziyaretci> Listziyaretci = new List <ziyaretci>(); OleDbConnection baglanti = AcikBaglantiGetir(); try { komut.Connection = baglanti; OleDbDataReader oku = komut.ExecuteReader(); while (oku.Read()) { ziyaretci yeniziyaretci = new ziyaretci(); if (!oku.IsDBNull(0)) { yeniziyaretci.Id = oku.GetInt32(0); } if (!oku.IsDBNull(1)) { yeniziyaretci.Ip = oku.GetString(1); } if (!oku.IsDBNull(2)) { yeniziyaretci.Dil = oku.GetString(2); } if (!oku.IsDBNull(3)) { yeniziyaretci.Sistem = oku.GetString(3); } if (!oku.IsDBNull(4)) { yeniziyaretci.Browser = oku.GetString(4); } if (!oku.IsDBNull(5)) { yeniziyaretci.Tarih = oku.GetDateTime(5); } if (!oku.IsDBNull(6)) { yeniziyaretci.Link = oku.GetString(6); } if (!oku.IsDBNull(7)) { yeniziyaretci.Gonderen = oku.GetString(7); } if (!oku.IsDBNull(8)) { yeniziyaretci.Durum = oku.GetBoolean(8); } Listziyaretci.Add(yeniziyaretci); } } catch { throw; } finally { BaglantiyiKapat(baglanti); } return(Listziyaretci); }
public static void esportaInWord() { string path = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Utilities\\Veicoli.accdb"; string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path; if (connStr != null) { OleDbConnection con = new OleDbConnection(connStr); using (con) { OleDbCommand com = new OleDbCommand("SELECT * FROM VEICOLI", con); con.Open(); OleDbDataReader reader = com.ExecuteReader(); if (reader.HasRows) { string filepath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Utilities\\Veicoli.docx"; WordprocessingDocument doc = WordprocessingDocument.Create(filepath, WordprocessingDocumentType.Document); MainDocumentPart mainPart = doc.AddMainDocumentPart(); mainPart.Document = new Document(); Body body = mainPart.Document.AppendChild(new Body()); ClsWord.AddStyle(mainPart, "Intestazione", "style1", "Consolas", 28, "#FF8800", true, false, false); Paragraph headingPar = ClsWord.CreateParagraphWithStyle("Intestazione", JustificationValues.Center); ClsWord.AddTextToParagraph(headingPar, "Vendita veicoli"); body.AppendChild(headingPar); while (reader.Read()) { string usato = String.Empty; string kmzero = String.Empty; if (reader.GetBoolean(8)) { usato = "Sì"; } else { usato = "No"; } if (reader.GetBoolean(9)) { kmzero = "Sì"; } else { kmzero = "No"; } if (reader.GetString(1) == "MOTO") { Paragraph p = body.AppendChild(new Paragraph()); Run r = p.AppendChild(new Run()); r.AppendChild(new Text("- " + reader.GetString(1))); r.AppendChild(new Break()); r.AppendChild(new Text("Marca: " + reader.GetString(2))); r.AppendChild(new Break()); r.AppendChild(new Text("Modello: " + reader.GetString(3))); r.AppendChild(new Break()); r.AppendChild(new Text("Colore: " + reader.GetString(4))); r.AppendChild(new Break()); r.AppendChild(new Text("Cilindrata: " + reader.GetInt32(5).ToString())); r.AppendChild(new Break()); r.AppendChild(new Text("PotenzaKw: " + reader.GetInt32(6).ToString())); r.AppendChild(new Break()); r.AppendChild(new Text("Data di immatricolazione: " + reader.GetDateTime(7).ToShortDateString())); r.AppendChild(new Break()); r.AppendChild(new Text("Usato: " + usato)); r.AppendChild(new Break()); r.AppendChild(new Text("Kmzero: " + kmzero)); r.AppendChild(new Break()); r.AppendChild(new Text("Km percorsi: " + reader.GetInt32(10).ToString() + " km")); r.AppendChild(new Break()); r.AppendChild(new Text("Sella: " + reader.GetString(11))); r.AppendChild(new Break()); } else { Paragraph p = body.AppendChild(new Paragraph()); Run r = p.AppendChild(new Run()); r.AppendChild(new Text("- " + reader.GetString(1))); r.AppendChild(new Break()); r.AppendChild(new Text("Marca: " + reader.GetString(2))); r.AppendChild(new Break()); r.AppendChild(new Text("Modello: " + reader.GetString(3))); r.AppendChild(new Break()); r.AppendChild(new Text("Colore: " + reader.GetString(4))); r.AppendChild(new Break()); r.AppendChild(new Text("Cilindrata: " + reader.GetInt32(5).ToString())); r.AppendChild(new Break()); r.AppendChild(new Text("PotenzaKw: " + reader.GetInt32(6).ToString())); r.AppendChild(new Break()); r.AppendChild(new Text("Data di immatricolazione: " + reader.GetDateTime(7).ToShortDateString())); r.AppendChild(new Break()); r.AppendChild(new Text("Usato: " + usato)); r.AppendChild(new Break()); r.AppendChild(new Text("Kmzero: " + kmzero)); r.AppendChild(new Break()); r.AppendChild(new Text("Km percorsi: " + reader.GetInt32(10).ToString() + " km")); r.AppendChild(new Break()); r.AppendChild(new Text("Numero di airbag: " + reader.GetString(11))); r.AppendChild(new Break()); } } doc.Close(); Console.Write("\nDocumento creato correttamente, desideri aprirlo?[S/N]: "); if (Console.ReadLine() == "S") { Process.Start(filepath); } else { Thread.Sleep(2000); } } else { Console.WriteLine("No rows found"); } } } }
public static List <kullanici> SelectAllkullanici(OleDbCommand komut) { List <kullanici> Listkullanici = new List <kullanici>(); OleDbConnection baglanti = AcikBaglantiGetir(); try { komut.Connection = baglanti; OleDbDataReader oku = komut.ExecuteReader(); while (oku.Read()) { kullanici yenikullanici = new kullanici(); if (!oku.IsDBNull(0)) { yenikullanici.Id = oku.GetInt32(0); } if (!oku.IsDBNull(1)) { yenikullanici.AdiSoyadi = oku.GetString(1); } if (!oku.IsDBNull(2)) { yenikullanici.KullaniciAdi = oku.GetString(2); } if (!oku.IsDBNull(3)) { yenikullanici.Sifre = oku.GetString(3); } if (!oku.IsDBNull(4)) { yenikullanici.Mail = oku.GetString(4); } if (!oku.IsDBNull(5)) { yenikullanici.Tel = oku.GetString(5); } if (!oku.IsDBNull(6)) { yenikullanici.Adres = oku.GetString(6); } if (!oku.IsDBNull(7)) { yenikullanici.AdminMi = oku.GetBoolean(7); } if (!oku.IsDBNull(8)) { yenikullanici.Durum = oku.GetBoolean(8); } Listkullanici.Add(yenikullanici); } } catch { throw; } finally { BaglantiyiKapat(baglanti); } return(Listkullanici); }
private void timer1_Tick(object sender, EventArgs e) { if ((notifyIcon1.Visible) && 窗口.leave_count == 1) { //如果有在处理的请假信息 就查询 try { OleDbCommand sql1 = 窗口.conn.CreateCommand(); sql1.CommandText = "SELECT 请假时间,请假条编号,是否通过,结束时间 from 请假 where 请假人工号='" + a + "' and 是否查看=true and 是否通知 = false"; OleDbDataReader rea = sql1.ExecuteReader(); if (rea.Read()) { string sql = "update 请假 set 是否通知=true where 请假条编号 =" + rea.GetValue(1); OleDbCommand cmd = new OleDbCommand(sql, 窗口.conn); int res = cmd.ExecuteNonQuery(); 窗口.leave_count = 0; if (rea.GetBoolean(2)) { MessageBox.Show("你的" + rea.GetDateTime(0).ToString("yyyy/MM/dd") + "至" + rea.GetDateTime(3).ToString("yyyy/MM/dd") + "的请假已通过"); } else { MessageBox.Show("你的" + rea.GetDateTime(0).ToString("yyyy/MM/dd") + "至" + rea.GetDateTime(3).ToString("yyyy/MM/dd") + "的请假未通过"); } } } catch { this.Hide(); this.Close(); if (窗口.登录 != null) { 窗口.登录.Show(); } } } if ((notifyIcon1.Visible) && 窗口.error_count > 0) { //如果有在处理的错误报告 就查询 try { OleDbCommand sql2 = 窗口.conn.CreateCommand(); sql2.CommandText = "SELECT 错误内容,编号 from 错误报告 where 申请人工号='" + a + "' and 是否处理=true and 是否通知 = false"; OleDbDataReader read = sql2.ExecuteReader(); if (read.Read()) { string sql = "update 错误报告 set 是否通知=true where 编号 =" + read.GetValue(1); OleDbCommand cmd = new OleDbCommand(sql, 窗口.conn); int res = cmd.ExecuteNonQuery(); if (res > 0) { MessageBox.Show("你提交的错误:\n" + read.GetString(0) + "\n已处理\n如修改过照片 请重新登录以更新"); 窗口.error_count--; } } } catch { this.Hide(); this.Close(); if (窗口.登录 != null) { 窗口.登录.Show(); } } } }
public static ayar Selectayar(OleDbCommand komut) { ayar yeniayar = null; OleDbConnection baglanti = AcikBaglantiGetir(); try { komut.Connection = baglanti; OleDbDataReader oku = komut.ExecuteReader(); if (oku.Read()) { yeniayar = new ayar(); if (!oku.IsDBNull(0)) { yeniayar.Id = oku.GetInt32(0); } if (!oku.IsDBNull(1)) { yeniayar.SirketAdi = oku.GetString(1); } if (!oku.IsDBNull(2)) { yeniayar.SiteAdi = oku.GetString(2); } if (!oku.IsDBNull(3)) { yeniayar.Adres = oku.GetString(3); } if (!oku.IsDBNull(4)) { yeniayar.Telefon = oku.GetString(4); } if (!oku.IsDBNull(5)) { yeniayar.Telefon2 = oku.GetString(5); } if (!oku.IsDBNull(6)) { yeniayar.Faks = oku.GetString(6); } if (!oku.IsDBNull(7)) { yeniayar.Gsm = oku.GetString(7); } if (!oku.IsDBNull(8)) { yeniayar.Klasor = oku.GetString(8); } if (!oku.IsDBNull(9)) { yeniayar.AdminMail = oku.GetString(9); } if (!oku.IsDBNull(10)) { yeniayar.Mail = oku.GetString(10); } if (!oku.IsDBNull(11)) { yeniayar.MailServer = oku.GetString(11); } if (!oku.IsDBNull(12)) { yeniayar.MailPassword = oku.GetString(12); } if (!oku.IsDBNull(13)) { yeniayar.MailPort = oku.GetString(13); } if (!oku.IsDBNull(14)) { yeniayar.SorumluMail = oku.GetString(14); } if (!oku.IsDBNull(15)) { yeniayar.HataLoglama = oku.GetBoolean(15); } if (!oku.IsDBNull(16)) { yeniayar.HataMail = oku.GetBoolean(16); } if (!oku.IsDBNull(17)) { yeniayar.Aktif = oku.GetBoolean(17); } } } catch { throw; } finally { BaglantiyiKapat(baglanti); } return(yeniayar); }
//Onglet Recapitulatif private void btnCreeReca_Click(object sender, EventArgs e) { try { //Initialisation des variables connec.Open(); string mois = dtpReca.Value.Month.ToString(); string annee = dtpReca.Value.Year.ToString(); string text = "____________________________________________________"; string typeNull = "Type NULL"; float montant = 0; int recette = 0; int percu = 0; int indentation = 20; int hauteurDesLignes = 720; List <string> un = new List <string>(); List <string> de = new List <string>(); List <string> tr = new List <string>(); List <string> qu = new List <string>(); List <string> ci = new List <string>(); List <string> si = new List <string>(); List <Boolean> nbTransaction = new List <Boolean>(); pdfDocument myDoc = new pdfDocument("Recapitulatif_" + mois + "_" + annee, "Pique_Sous"); pdfPage myPage = myDoc.addPage(); //SQL OleDbCommand cd1 = new OleDbCommand("SELECT [Transaction].* FROM [Transaction] WHERE MONTH([dateTransaction]) = " + dtpReca.Value.Month.ToString(), connec); OleDbDataReader dr1 = cd1.ExecuteReader(); //Lecture de la base while (dr1.Read()) { nbTransaction.Add(dr1.GetBoolean(4)); if (dr1.GetBoolean(4) == true) { recette++; } if (dr1.GetBoolean(5) == true) { percu++; } montant = montant + dr1.GetFloat(3); un.Add(dr1[1].ToString().Substring(0, 11)); de.Add(dr1[2].ToString()); tr.Add(dr1[3].ToString()); qu.Add(dr1[4].ToString()); ci.Add(dr1[5].ToString()); if (dr1[6].ToString() != "") { si.Add(dr1[6].ToString()); } else { si.Add(typeNull); } } for (int i = 0; i < si.Count; i++) { if (si[i] != typeNull) { //Pour eviter de faire une requette avec une jointure OleDbCommand cd2 = new OleDbCommand("SELECT [TypeTransaction].* FROM [TypeTransaction] where [codeType] = " + si[i], connec); OleDbDataReader dr2 = cd2.ExecuteReader(); while (dr2.Read()) { si[i] = dr2[1].ToString(); } } } //Creation du text dans le PDF myPage.addText("Recapitulatif du : " + mois + "_" + annee, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText("Dépenses", indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - (30 + 25 * un.Count); myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText("Recette : " + recette.ToString(), indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText(" Depenses : " + montant.ToString(), indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText("Reste a persevoir : " + percu.ToString(), indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText("Somme total dépensée : -" + montant.ToString(), indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText("nombres de transactions : " + nbTransaction.Count.ToString(), indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); hauteurDesLignes = hauteurDesLignes - 30; myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20); //Initiallisation tableau PDF pdfTable myTable = new pdfTable(myDoc); myTable.borderSize = 1; myTable.borderColor = sharpPDF.pdfColor.Black; myTable.tableHeader.addColumn(90); myTable.tableHeader.addColumn(120); myTable.tableHeader.addColumn(70); myTable.tableHeader.addColumn(70); myTable.tableHeader.addColumn(70); myTable.tableHeader.addColumn(110); pdfTableRow myRow = myTable.createRow(); //Remplissage de la première ligne du tableau myRow[0].addText("Date Transaction"); myRow[1].addText("Description"); myRow[2].addText("Montant"); myRow[3].addText("Recette ?"); myRow[4].addText("Perçu ?"); myRow[5].addText("Type de dépence ?"); myTable.addRow(myRow); //Remplissage des ligne du tableau for (int i = 0; i < un.Count; i++) { myRow = myTable.createRow(); myRow[0].addText(un[i]); myRow[1].addText(de[i]); myRow[2].addText(tr[i]); myRow[3].addText(qu[i]); myRow[4].addText(ci[i]); myRow[5].addText(si[i]); myTable.addRow(myRow); } //Place le tableau myTable.coordY = 650; myTable.coordX = 20; myPage.addTable(myTable); //creer le PDF FolderBrowserDialog fbd = new FolderBrowserDialog(); if (fbd.ShowDialog() == DialogResult.OK) { myDoc.createPDF(fbd.SelectedPath + @"\Recapitulatif_" + mois + "_" + annee + ".pdf"); } myPage = null; myDoc = null; connec.Close(); MessageBox.Show("PDF créé"); } catch (InvalidOperationException erreur) { MessageBox.Show("Erreur de chaine de connexion ! pdf"); MessageBox.Show(erreur.Message); } catch (OleDbException erreur) { MessageBox.Show("Erreur de requete SQL ! pdf"); MessageBox.Show(erreur.Message); } }
public override Family PopulateRecord(OleDbDataReader reader) { return(new Family { PID = reader.GetDouble(0), SaveDate = reader.GetDateTime(1), Stroke = reader.GetBoolean(2), CAD = reader.GetBoolean(3), MI = reader.GetBoolean(4), Father = reader.GetBoolean(5), Mother = reader.GetBoolean(6), NotSure = reader.GetBoolean(7), DiabetesType = reader.IsDBNull(8) == true ? null : reader.GetString(8), Breast = reader.GetBoolean(9), Liver = reader.GetBoolean(10), Gastric = reader.GetBoolean(11), Colon = reader.GetBoolean(12), Skin = reader.GetBoolean(13), Lung = reader.GetBoolean(14), CancerOthers = reader.IsDBNull(15) == true ? null : reader.GetString(15) }); }
/// <summary> /// Loads the catalog's settings and sets up the class to take requests. /// </summary> /// <returns></returns> public void Load() { if (sync) { throw(new ContentManagerException("Cannot create a synchronized catalog.", 991)); } StringBuilder s = new StringBuilder("SELECT "); s.Append(catalogFields); s.Append(" FROM kitCms_Catalogs WHERE CatalogID="); s.Append(iD); s.Append(";"); OleDbDataReader r = this.runReader(s.ToString()); if (r.Read()) { name = r.GetString(0); description = r.GetString(1); pressTime = TimeSpan.FromTicks((long)r.GetDouble(2)); pressDate = r.GetDateTime(3); expireTime = TimeSpan.FromTicks((long)r.GetDouble(4)); expireDate = r.GetDateTime(5); archiveTime = TimeSpan.FromTicks((long)r.GetDouble(6)); archiveDate = r.GetDateTime(7); archiveOnExpiration = r.GetBoolean(8); archiveCatalogID = r.GetInt32(9); authorRoleID = r.GetInt32(10); reviewerRoleID = r.GetInt32(11); editorRoleID = r.GetInt32(12); publisherRoleID = r.GetInt32(13); adminRoleID = r.GetInt32(14); authorDisabled = r.GetBoolean(15); reviewDisabled = r.GetBoolean(16); editDisabled = r.GetBoolean(17); publishDisabled = r.GetBoolean(18); dynamicParseTypeDisabled = r.GetBoolean(19); trackChangesDisabled = r.GetBoolean(20); hitCounterDisabled = r.GetBoolean(21); contentType = (ContentType)r.GetByte(22); trackChangesType = (ContentTrackChangesType)r.GetByte(23); hitCounterType = (ContentHitCounterType)r.GetByte(24); enableHtmlAuthoring = r.GetBoolean(25); enableCss = r.GetBoolean(26); enableParagraphStyles = r.GetBoolean(27); enableFontForeColor = r.GetBoolean(28); enableFontBackColor = r.GetBoolean(29); enableFormatting = r.GetBoolean(30); enableImages = r.GetBoolean(31); enableCustomCss = r.GetBoolean(32); cssLink = r.GetString(33); cssStyles = r.GetString(34); cssNames = r.GetString(35); paragraphStyles = r.GetString(36); paragraphNames = r.GetString(37); fontColorValues = r.GetString(38); fontColorNames = r.GetString(39); imageLocation = r.GetString(40); sync = true; } }
private void Form_Load(object sender, EventArgs e) { if (insertMode) { btnAction.Text = "&Insert"; } else { btnAction.Text = "&Update"; cbPost.Enabled = false; txtStation.Enabled = false; } InitComboPost(); if (staName == "" || postName == "") { return; } if (Database.Me.Connected) { string sql = "SELECT name,post,canlogin,keterangan FROM stations WHERE name=? and post=?"; try { Database.Me.OpenConnection(); using (OleDbCommand cmd = new OleDbCommand(sql, Database.Me.Connection)) { cmd.Parameters.Add("?", OleDbType.VarChar, 32).Value = staName; cmd.Parameters.Add("?", OleDbType.VarChar, 32).Value = postName; using (OleDbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { reader.Read(); txtStation.Text = staName; string _post = reader.GetString(1).Trim(); cbPost.Text = _post; bool _canLogin = reader.GetBoolean(2); rbCanLogin.Checked = _canLogin; rbCannotLogin.Checked = !_canLogin; var remark = reader.GetValue(3); if (remark != null) { txtRemark.Text = remark.ToString().Trim(); } } } } } catch (Exception ex) { Logger.Log("QueueAdmin : Exception : " + ex.Message); } } }