public void LoadFromDB(MySqlDataReader reader) { if (reader.Read()) { Nickname = (reader.IsDBNull(0) ? null : reader.GetString(0)); Level = reader.GetInt16(1); Exp = reader.GetInt16(2); } }
public void LoadFromDB(MySqlDataReader reader) { Items.Clear(); while (reader.Read()) { Int32 characterNo = reader.GetInt32(0); Int32 characterId = reader.GetInt32(1); Character ch = new Character(_user, characterId, characterNo); ch.Level = reader.GetInt16(2); ch.Exp = reader.GetInt32(3); ch.GradeId = reader.GetInt16(4); ch.PromotionId = reader.GetInt16(5); Items.Add(ch); } }
void Ekle(string kID) { int makaleID = 1; String connStr = System.Configuration.ConfigurationManager.ConnectionStrings["WebConnString"].ToString(); conn = new MySql.Data.MySqlClient.MySqlConnection(connStr); conn.Open(); queryStr = "SELECT * FROM tasarimdersi.yazarmakale WHERE ID= " + kID + " AND MakaleID = (SELECT MAX(MakaleID) FROM tasarimdersi.yazarmakale WHERE ID= " + kID + ")"; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); reader = cmd.ExecuteReader(); while (reader.HasRows && reader.Read()) { makaleID = reader.GetInt16(reader.GetOrdinal("MakaleID")) + 1; } conn.Close(); if (FileUpload1.HasFile) { if (FileUpload1.PostedFile.ContentType == "application/pdf") { if (FileUpload1.PostedFile.ContentLength < 10240000) { isim = Session["IDSes"].ToString() + "-" + makaleID; makaleIsim = isim + ".pdf"; makalePath = (Server.MapPath("//resimler//") + makaleIsim); FileUpload1.SaveAs(makalePath); } else { lblMesaj.InnerText = "Dosya boyutu maximum 10MB olmalıdır."; } } else { lblMesaj.InnerText = "Sadece pdf uzantılı dosyalar yüklenebilir."; } } else { lblMesaj.InnerText = "Lütfen bir dosya seçiniz."; } conn.Open(); queryStr = "INSERT INTO tasarimdersi.yazarmakale (ID,MakaleID,alan,baslik,aciklama,makalepdf,onay)" + "Values('" + kID + "','" + makaleID + "','" + Alan.Text + "','" + Baslik.Text + "','" + Aciklama.Text + "','" + makaleIsim + "','" + "Editör İncelemesinde" + "')"; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); cmd.ExecuteReader(); conn.Close(); Response.Redirect(Request.RawUrl); }
public GuildMember(Guild Guild, MySqlDataReader reader) { this.Guild = Guild; CharacterID = reader.GetInt32(1); Rank = (GuildRank)reader.GetByte(2); Corp = (ushort)reader.GetInt16(3); }
private void LoginWithPasswordHashFunction() { String saltHash = null; try { connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString(); conn = new MySql.Data.MySqlClient.MySqlConnection(connectionString); conn.Open(); String query = "SELECT userID, slowHashSalt, firstname, middlename, lastname, isPT FROM webAppPersonalFit.userregistration WHERE username=?uname"; cmd = new MySql.Data.MySqlClient.MySqlCommand(query, conn); cmd.Parameters.AddWithValue("?uname", usernameTextBox.Value); reader = cmd.ExecuteReader(); if (reader.HasRows && reader.Read()) { String saltHashes = reader.GetString(reader.GetOrdinal("slowHashSalt")); //Console.WriteLine(saltHashes); saltHash = saltHashes; userID = "" + reader.GetInt16(reader.GetOrdinal("userID")); isPT = Convert.ToInt32(reader.GetByte(reader.GetOrdinal("isPT"))); } else { ValidationTextBoxLabel.Text = "Invalid Username or Password."; } if (saltHash != null) { bool validUser = PasswordStorage.VerifyPassword(passwordTextBox.Value, saltHash); if (validUser == true) { Session[userID] = userID; Response.BufferOutput = true; Server.Transfer("TrainerCatalog.aspx", true); } else { ValidationTextBoxLabel.Text = "Invalid Username or Password."; } } ValidationTextBoxLabel.Text = "Invalid Username or Password."; reader.Close(); conn.Close(); } catch (Exception e) { Console.WriteLine(e); } }
// Changement du mot de passe private void btnValider_Click(object sender, EventArgs e) { // Si tout les champs renseignés if (txtAncMdp.Text != "" && txtCnfNouvMdp.Text != "" && txtNouvMdp.Text != "") { // ---------- Vérification des informations rentrées --------------- // Vérification que nouveau mot de passe + confirmation soient identiques if (txtNouvMdp.Text == txtCnfNouvMdp.Text) { // Vérification de la longueur du nouveau mot de passe if (txtNouvMdp.TextLength >= Global._MIN_CARAC_PWD) { // Vérification du mot de passe actuel try { cmd = new MySqlCommand("SELECT count(*) FROM utilisateur WHERE idUtilisateur = '" + Global.userId + "' and password = PASSWORD(@pwd)", Global.Connection); MySqlParameter pMdp = new MySqlParameter("@pwd", MySqlDbType.Text); pMdp.Value = txtAncMdp.Text; cmd.Parameters.Add(pMdp); cmd.Prepare(); rd = cmd.ExecuteReader(); rd.Read(); // Si ancien mot de passe OK if (rd.GetInt16(0) == 1) { rd.Close(); // MAJ du mot de passe cmd = new MySqlCommand("UPDATE utilisateur SET password = PASSWORD(@pwd) WHERE idUtilisateur = '" + Global.userId + "'", Global.Connection); MySqlParameter pNouvMdp = new MySqlParameter("@pwd", MySqlDbType.Text); pNouvMdp.Value = txtNouvMdp.Text; cmd.Parameters.Add(pNouvMdp); cmd.Prepare(); cmd.ExecuteNonQuery(); MessageBox.Show("Votre mot de passe a bien été modifié ! ", "Succès", MessageBoxButtons.OK, MessageBoxIcon.Information); rd.Close(); // Retour à l'écran principal this.Close(); } else { MessageBox.Show("Votre mot de passe actuel est incorrect. Veuillez recommencer.", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); txtAncMdp.Text = ""; rd.Close(); } } catch (MySqlException) { MessageBox.Show("Une erreur est survenue. Le mot de passe n'a pas été changé.", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); rd.Close(); } } else { MessageBox.Show("Le nouveau mot de passe est trop petit : minimum " + Global._MIN_CARAC_PWD + " caractères.", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); txtNouvMdp.Text = ""; txtCnfNouvMdp.Text = ""; } } else { MessageBox.Show("Le nouveau mot de passe et sa confirmation ne correspondent pas.", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); txtNouvMdp.Text = ""; txtCnfNouvMdp.Text = ""; } } else { MessageBox.Show("Veuillez renseigner tous les champs.", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void LoadFromDB(MySqlDataReader reader) { Decks.ForEach(v => v.Clear()); while (reader.Read()) { DeckType deckType = (DeckType)reader.GetInt32(0); Int32 slotNo = reader.GetInt16(1); Int32 characterNo = reader.GetInt32(2); this[deckType].Characters[slotNo] = _user.InvenCharacter.Find(characterNo); } }
public void LoadFromDB(MySqlDataReader reader) { Items.Clear(); while (reader.Read()) { Int32 itemNo = reader.GetInt32(0); Int32 itemId = reader.GetInt32(1); Item ch = new Item(_user, itemId, itemNo); ch.PromotionId = reader.GetInt16(2); ch.Quantity = reader.GetInt32(3); Items.Add(ch); } }
private User createUserFromDataReader(MySqlDataReader dataReader) { if (!dataReader.HasRows) return null; dataReader.Read(); User user = new User(dataReader["login"].ToString(), dataReader["password"].ToString(), dataReader["name"].ToString()); EvaluetionMethod em; int evaluetionMethod = dataReader.GetInt16("evaluetionMethod"); if(evaluetionMethod == 0) em = EvaluetionMethod.Grade; else em = EvaluetionMethod.Stars; user.setEvaluetionMethodInfo(em, (float) dataReader.GetInt16("lowerLimit"), (float) dataReader.GetInt16("higherLimit"), float.Parse(dataReader["step"].ToString())); return user; }
public static int GetIntFromRdr(MySql.Data.MySqlClient.MySqlDataReader rdr, string column) { try { int ord = rdr.GetOrdinal(column); if (rdr[ord] == DBNull.Value) { return(0); } string typeName = rdr.GetDataTypeName(ord); if (typeName == "TINYINT") { return(rdr.GetInt16(ord)); } return(rdr.GetInt32(ord)); } catch (Exception exc) { log.Error("GetIntFromRdr", exc); return(0); } }
public void LoadFromDB(MySqlDataReader reader) { Items.Clear(); while (reader.Read()) { Int32 energyId = reader.GetInt16(0); Int32 point = reader.GetInt32(1); DateTime lastUpdateTime = reader.GetDateTime(2); Items.Add(new Data(_user, energyId, point, lastUpdateTime)); } }
public ContentResult OnPostGetUserPreferencesAsync() { var autoscreen = ""; var tahajjud = ""; int?establishid = null; int?events = null; int?viewmode = null; var establishname = ""; var tweetid = ""; var audiourl = ""; var videocdn = ""; var videourl = ""; var cameradesc = ""; int?micstatus = null; IConfigurationRoot configuration = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); var connectionString = configuration.GetConnectionString("dbAirMasjid"); try { using (MySqlConnection conn = new MySqlConnection(connectionString)) { using (MySqlCommand cmd = new MySqlCommand("getuserpreferences", conn)) { // cmd.CommandText = "updateestablishment"; cmd.CommandType = System.Data.CommandType.StoredProcedure; conn.Open(); var serialno = serial; cmd.Parameters.AddWithValue("@serialno", serial); MySql.Data.MySqlClient.MySqlDataReader myReader = default(MySql.Data.MySqlClient.MySqlDataReader); myReader = cmd.ExecuteReader(); while (myReader.Read()) { autoscreen = myReader.GetString(0); tahajjud = myReader.GetString(1); establishid = myReader.GetInt16(2); events = myReader.GetInt16(3); viewmode = myReader.GetInt16(4); establishname = myReader.GetString(5); tweetid = myReader.GetString(6); audiourl = myReader.GetString(7); videocdn = myReader.GetString(8); videourl = myReader.GetString(9); cameradesc = myReader.GetString(10); micstatus = myReader.GetInt16(11); // establishid = myReader.GetString(2); // tblCameraLookup.Description, } // cmd.ExecuteNonQuery(); conn.Close(); // return Content(autoscreen,tahajjud); return(Content("{ " + "\"autoscreen\":" + "\"" + autoscreen + "\"" + ",\"tahajjud\":" + "\"" + tahajjud + "\"" + ",\"establishid\":" + establishid + ",\"events\":" + events + ",\"viewmode\":" + viewmode + ",\"establishname\":" + "\"" + establishname + "\"" + ",\"tweetid\":" + "\"" + tweetid + "\"" + ",\"audiourl\":" + "\"" + audiourl + "\"" + ",\"videocdn\":" + "\"" + videocdn + "\"" + ",\"videourl\":" + "\"" + videourl + "\"" + ",\"cameradesc\":" + "\"" + cameradesc + "\"" + ",\"micstatus\":" + micstatus + "}", "application/json")); // return Content("{ \"name\":\"John\", \"age\":31, \"city\":\"New York\" }", "application/json"); } } } catch (Exception ex) { var Message = $"Failed to get user preferences " + ex.Message; _logger.LogWarning(Message); return(Content("failed")); } }
private MedicalInformation constructMedical(MySqlDataReader medicalReader) { MedicalInformation newMedical = new MedicalInformation(); newMedical.MedicalID = medicalReader.GetInt16("Medical_ID"); newMedical.Allergies = SafeGetString(medicalReader, "Allergies"); newMedical.Medication = SafeGetString(medicalReader, "Medication"); newMedical.Other = SafeGetString(medicalReader, "Other"); newMedical.Doctor = medicalReader.GetString("Doctor"); newMedical.DoctorAddress = constructAddress(medicalReader); return newMedical; }
private Employee constructEmployee(MySqlDataReader staffReader) { Employee newEmployee = new Employee(); newEmployee.NINo = staffReader.GetString("National_Insurance_Number"); newEmployee.FirstName = staffReader.GetString("First_Name"); newEmployee.LastName = staffReader.GetString("Last_Name"); newEmployee.Position = staffReader.GetString("Position"); newEmployee.Gender = staffReader.GetChar("Gender"); newEmployee.DateStarted = staffReader.GetDateTime("Date_Started"); newEmployee.DateFinished = SafeGetDateTime(staffReader, "Date_Finished"); newEmployee.PVGDate = staffReader.GetDateTime("PVG_Date"); newEmployee.HolidaysEntitled = staffReader.GetInt16("Holidays_Entitled"); newEmployee.HolidaysTaken = staffReader.GetInt16("Holidays_Taken"); newEmployee.WeeksHours = staffReader.GetInt16("Hours"); newEmployee.Address = constructAddress(staffReader); newEmployee.DOB = staffReader.GetDateTime("DOB"); newEmployee.Salary = staffReader.GetDecimal("Salary"); newEmployee.HomePhone = staffReader.GetString("Home_Phone"); newEmployee.MobilePhone = staffReader.GetString("Mobile_Phone"); newEmployee.Email = staffReader.GetString("Email"); newEmployee.Training = SafeGetString(staffReader, "Training"); newEmployee.Medical = constructMedical(staffReader); //EC... return newEmployee; }
private Child constructChild(MySqlDataReader childrenReader) { Child newChild = new Child(); newChild.ChildID = childrenReader.GetInt32("Child_Id"); newChild.FirstName = childrenReader.GetString("First_Name"); newChild.LastName = childrenReader.GetString("Last_Name"); newChild.Gender = childrenReader.GetChar("Gender"); newChild.DOB = childrenReader.GetDateTime("DOB"); newChild.FirstLanguage = childrenReader.GetString("First_Language"); newChild.RoomAttending = childrenReader.GetString("Room_Attending"); //newChild.Sibling = SafeGetInt(childrenReader, "Sibling"); newChild.DateApplied = childrenReader.GetDateTime("Date_Applied"); newChild.DateLeft = SafeGetDateTime(childrenReader, "Date_Left"); newChild.Attendance = constructAttendance(childrenReader); newChild.ExtraDays = childrenReader.GetInt16("Extra_Days"); newChild.Teas = childrenReader.GetInt16("Teas"); newChild.MedicalInfo = constructMedical(childrenReader); //newChild.ParentsIDs.Add(childrenReader.GetInt16(16)); //newChild.EmergencyContactsIDs.Add(childrenReader.GetInt16(16)); //Get parents //foreach (int parentID in selectChildsParentIDs(newChild.ChildID)) // newChild.Parents.Add(constructParent(childrenReader, 16)); ////Get Emergency Contacts //foreach (int contactID in selectChildsContactIDs(newChild.ChildID)) // newChild.EmergencyContacts.Add(selectEmergencyContact(contactID), 30); return newChild; }
private Video createVideoFromDataReader(MySqlDataReader dataReader) { if (!dataReader.HasRows) return null; dataReader.Read(); int code = dataReader.GetInt16("code"); String category; if (!dataReader["categoryCode"].Equals(DBNull.Value)) category = getCategory(dataReader.GetInt16("categoryCode")); else category = ""; String originalTitle; if(!dataReader["originalTitle"].Equals(DBNull.Value)) originalTitle = dataReader["originalTitle"].ToString(); else originalTitle = ""; String nationalTitle; if (!dataReader["nationalTitle"].Equals(DBNull.Value)) nationalTitle = dataReader["nationalTitle"].ToString(); else nationalTitle = ""; String director; if (!dataReader["director"].Equals(DBNull.Value)) director = dataReader["director"].ToString(); else director = ""; int year; if (!dataReader["year"].Equals(DBNull.Value)) year = dataReader.GetInt16("year"); else year = 0; int duration; if (!dataReader["duration"].Equals(DBNull.Value)) duration = dataReader.GetInt16("duration"); else duration = 0; List<String> tagsList = populateTags(code); String[] tags; if(tagsList.Count > 0) tags = tagsList.ToArray(); else tags = new String[0]; Video video = new Video(code, originalTitle, nationalTitle, director, year, duration, category, tags); return video; }
/// <summary> /// Reads a relation member from the MySqlDataReader /// </summary> /// <param name="reader">The MySqlDataReader to attempt reading the relation member from</param> /// <returns>The relation member read from the MySqlReader</returns> private RelationMember ReadRelationMember(MySqlDataReader reader) { var relation_member = new RelationMember(); relation_member.MemberType = ConvertMemberType(reader.GetInt16(0)); relation_member.MemberId = reader.GetInt64(1); relation_member.MemberRole = reader.GetString(2); return relation_member; }
public void LoadFromDB(MySqlDataReader reader) { Items.Clear(); while (reader.Read()) { Int32 resourceId = reader.GetInt16(0); Int32 point = reader.GetInt32(1); Items.Add(new Data(resourceId, point)); } }
public void SetProperty(object obj, SelectQueryFieldStore item,MySqlDataReader rdr) { var pinfo = obj.GetType().GetProperty(item.Property); if (pinfo != null) { switch (item.Type) { case SelectQueryFieldStore.DataTypes.Int: pinfo.SetValue(obj, rdr.GetInt32(item.Column), null); break; case SelectQueryFieldStore.DataTypes.Bool: pinfo.SetValue(obj, Convert.ToBoolean(rdr.GetInt32(item.Column)), null); break; case SelectQueryFieldStore.DataTypes.Float: pinfo.SetValue(obj, rdr.GetFloat(item.Column), null); break; case SelectQueryFieldStore.DataTypes.String: pinfo.SetValue(obj, rdr.GetString(item.Column), null); break; case SelectQueryFieldStore.DataTypes.Long: pinfo.SetValue(obj, rdr.GetInt64(item.Column), null); break; case SelectQueryFieldStore.DataTypes.Short: pinfo.SetValue(obj, rdr.GetInt16(item.Column), null); break; default: pinfo.SetValue(obj, rdr.GetString(item.Column), null); break; } } }
// 取 dr 中某字段的数据并返回 public static object GetValue( DbColumn col, MySqlDataReader r, int idx ) { switch( col.dataType ) { case DbDataTypes.Boolean: return r.GetBoolean( idx ); case DbDataTypes.Int8: return r.GetSByte( idx ); case DbDataTypes.Int16: return r.GetInt16( idx ); case DbDataTypes.Int32: return r.GetInt32( idx ); case DbDataTypes.Int64: return r.GetInt64( idx ); case DbDataTypes.UInt8: return r.GetByte( idx ); case DbDataTypes.UInt16: return r.GetUInt16( idx ); case DbDataTypes.UInt32: return r.GetUInt32( idx ); case DbDataTypes.UInt64: return r.GetUInt64( idx ); case DbDataTypes.Float: return r.GetFloat( idx ); case DbDataTypes.Double: return r.GetDouble( idx ); case DbDataTypes.DateTime: return r.GetDateTime( idx ); case DbDataTypes.String: return r.GetString( idx ); case DbDataTypes.Bytes: var len = (int)r.GetBytes( idx, 0, null, 0, 0 ); var buf = new byte[ len ]; r.GetBytes( idx, 0, buf, 0, len ); return buf; default: throw new Exception( "unsupported DbType" ); } }
// 往 dr 填充 r 于 i 索引的值 public static void FillValue( DbRow dr, MySqlDataReader r, int i ) { switch( dr.parent.columns[ i ].dataType ) { case DbDataTypes.Boolean: dr[ i ].Assign( r.GetBoolean( i ) ); break; case DbDataTypes.Int8: dr[ i ].Assign( r.GetSByte( i ) ); break; case DbDataTypes.Int16: dr[ i ].Assign( r.GetInt16( i ) ); break; case DbDataTypes.Int32: dr[ i ].Assign( r.GetInt32( i ) ); break; case DbDataTypes.Int64: dr[ i ].Assign( r.GetInt64( i ) ); break; case DbDataTypes.UInt8: dr[ i ].Assign( r.GetByte( i ) ); break; case DbDataTypes.UInt16: dr[ i ].Assign( r.GetUInt16( i ) ); break; case DbDataTypes.UInt32: dr[ i ].Assign( r.GetUInt32( i ) ); break; case DbDataTypes.UInt64: dr[ i ].Assign( r.GetUInt64( i ) ); break; case DbDataTypes.Float: dr[ i ].Assign( r.GetFloat( i ) ); break; case DbDataTypes.Double: dr[ i ].Assign( r.GetDouble( i ) ); break; case DbDataTypes.DateTime: dr[ i ].Assign( r.GetDateTime( i ) ); break; case DbDataTypes.String: dr[ i ].Assign( r.GetString( i ) ); break; case DbDataTypes.Bytes: var len = (int)r.GetBytes( i, 0, null, 0, 0 ); var buf = new byte[ len ]; r.GetBytes( i, 0, buf, 0, len ); dr[ i ].Assign( buf ); break; default: break; } }
private void form1_Load(object sender, EventArgs e) { res = 0; this.ControlBox = false; hh = RulesForm.temp / 60; mm = RulesForm.temp % 60; ss = 0; timer1.Enabled = true; timer1.Interval = 1000; label1.Text = "Time :" +hh + ":" + mm + ":" + ss; try { con.Open(); //to get the number of questions for the subject cmd=new MySqlCommand("select tot_quest from exam where eid='"+SelectExam.exam_code+"'",con); dr1 = cmd.ExecuteReader(); dr1.Read(); noq = dr1.GetInt32("tot_quest"); ticked = new bool[noq]; status = new bool[noq]; ans = new char[noq]; ans_status = new RadioButton[noq]; drawcontrols(sender,e,noq); dr1.Close(); label2.Text = "1 Out Of " + noq; //Initialize form with 1st question with respect to the subject selected cmd = new MySqlCommand("select * from test where qno=1 and ecode='"+SelectExam.exam_code+"'", con); dr1 = cmd.ExecuteReader(); dr1.Read(); qno.Text = "Q.No. " + dr1["qno"]; textBox1.Text = dr1["quest"].ToString(); opt1.Text = dr1["opt1"].ToString(); opt2.Text = dr1["opt2"].ToString(); opt3.Text = dr1["opt3"].ToString(); opt4.Text = dr1["opt4"].ToString(); answer = dr1.GetInt16("ans"); mark = dr1.GetInt16("mark"); dr1.Close(); con.Close(); } catch (Exception ex) { MessageBox.Show("Invalid Exam Code...!","Exam Code Error"); label1.Visible = false; this.Hide(); new SelectExam().Show(); } }
/// <summary> /// Reads a relation id and relation member from the MySqlDataReader /// </summary> /// <param name="reader">The MySqlDataReader to attempt reading the relation id and member from</param> /// <returns>The relation member and relation id read from the MySqlReader</returns> private Tuple<long, RelationMember> ReadRelationIdAndMember(MySqlDataReader reader) { var relation_member = new RelationMember(); relation_member.MemberType = ConvertMemberType(reader.GetInt16(1)); relation_member.MemberId = reader.GetInt64(2); relation_member.MemberRole = reader.GetString(3); return new Tuple<long,RelationMember>(reader.GetInt64(0), relation_member); }