private void Load(MySqlDataReader dr) { SetId(Convert.ToInt32(dr["Id"])); this._key = Convert.ToString(dr["key_"]); this._value = Convert.ToString(dr["value"]); this._leaf = Convert.ToBoolean(dr["leaf"]); this._listName = Convert.ToString(dr["listName"]); this._parId = Convert.ToInt32(dr["parId"]); MarkOld(); }
public Message(MySqlDataReader dr) { this.Load(dr); }
public Entry(MySqlDataReader dr, CatList catList) { Setup(); _catList = catList; this.Load(dr); }
public Effort(MySqlDataReader dr) { this.Load(dr); }
public void Load(MySqlDataReader dr) { Setup(); SetId(Convert.ToInt32(dr["Id"])); _extId = Convert.ToInt32(dr["extId"]); this._effId = new EffortID(dr["type"].ToString() + _extId); _testedBy = Convert.ToString(dr["testedBy"]); _approved = Convert.ToBoolean(dr["approved"]); _pmResource = Convert.ToString(dr["pmResource"]); _webResource = Convert.ToString(dr["webResource"]); _dbResource = Convert.ToString(dr["dbResource"]); _uatApproved = Convert.ToBoolean(dr["uatApproved"]); _projectManager = Convert.ToString(dr["pmResource"]); _maxResource = Convert.ToString(dr["maxResource"]); _uatApprovedBy = Convert.ToString(dr["uatApprovedBy"]); _branchFileHierarchy = Convert.ToString(dr["branchFileHierarchy"]); _environment = Convert.ToString(dr["environment"]); if (Convert.ToChar(dr["type"]) == 'P') _effType = EffortType.Project; if (Convert.ToChar(dr["type"]) == 'T') _effType = EffortType.Ticket; this._desc = Convert.ToString(dr["desc_"]); _requester = Convert.ToString(dr["requestor"]); MarkOld(); }
public void Load(MySqlDataReader dr) { Setup(); SetId(Convert.ToInt32(dr["Id"])); this._clientId = Convert.ToInt32(dr["clientId"]); this._finalComments= Convert.ToString(dr["finalComments"]); this._rolledBack = Convert.ToBoolean(dr["rolledBack"]); this._rolledDate= Convert.ToDateTime(dr["rolledDate"]); this._scheduledDate = Convert.ToDateTime(dr["scheduledDate"]); this._rolledBy = Convert.ToString(dr["rolledBy"]); this.Rolled = Convert.ToBoolean(dr["rolled"]); MarkOld(); }
public void Load(MySqlDataReader dr) { Setup(); SetId(Convert.ToInt32(dr["Id"])); string name = Convert.ToString(dr["Name"]); string[] splitName = System.Text.RegularExpressions.Regex.Split(name, " - "); if (splitName.Length == 1) { this._name = splitName[0].Trim(); this._retired = false; }else{ if (splitName[0] == "RETIRED") { this._retired = true; this._name = splitName[1].Trim(); }else{ this._retired = false; this._name = splitName[0].Trim(); } } this._description = Convert.ToString(dr["Description"]); this._email = Convert.ToString(dr["Email"]); MarkOld(); }
public Defect(MySqlDataReader dr) { this.Load(dr); }
public void Load(MySqlDataReader dr) { Setup(); SetId(Convert.ToInt32(dr["Id"])); if (dr.GetSchemaTable().Select("ColumnName = 'text'").Length == 1) // Check the schema to determine if the "text" column is in it. this._text = Convert.ToString(dr["text"]); this._userEmail = Convert.ToString(dr["userEmail"]); this._rollClass = Convert.ToString(dr["rollClass"]); this._rollType = (RollType)Enum.Parse(Type.GetType("QED.Business.CodePromotion.RollType"), Convert.ToString(dr["rollType"])); if (dr["ts"] != DBNull.Value) this._dateTime = Convert.ToDateTime(dr["ts"]); MarkOld(); }
public Server(MySqlDataReader dr) { this.Load(dr); }
public void Load(MySqlDataReader dr) { Setup(); SetId(Convert.ToInt32(dr["id"])); this._desc = dr["desc_"].ToString(); this._effId = Convert.ToInt32(dr["effId"]); this._rollId = Convert.ToInt32(dr["rollId"]); this._resolver = dr["resolver"].ToString(); this._createdBy = dr["createdBy"].ToString(); //this._status = dr["Status"].ToString(); this._forRoll = Convert.ToBoolean(dr["forRoll"]); MarkOld(); }
public void Load(MySqlDataReader dr) { Setup(); SetId(Convert.ToInt32(dr["Id"])); this._desc = Convert.ToString(dr["desc_"]); this._dnsName = Convert.ToString(dr["dnsName"]); MarkOld(); }
/// <summary> /// Executes the query, and returns the first column of the first row in the /// result set returned by the query. Extra columns or rows are ignored. /// </summary> /// <returns></returns> public object ExecuteScalar() { // There must be a valid and open connection. if (connection == null || connection.State != ConnectionState.Open) throw new InvalidOperationException("Connection must be valid and open"); // Data readers have to be closed first if (connection.Reader != null) throw new MySqlException("There is already an open DataReader associated with this Connection which must be closed first."); arraySql = SplitSql( cmdText ); updateCount = -1; MySqlDataReader reader = new MySqlDataReader(this, 0); reader.NextResult(); object val = null; if (reader.Read()) val = reader.GetValue(0); reader.Close(); return val; }
/// <summary> /// Overloaded. Sends the CommandText to the Connection and builds a MySqlDataReader. /// </summary> /// <returns></returns> public MySqlDataReader ExecuteReader(CommandBehavior behavior) { // There must be a valid and open connection. if (connection == null || connection.State != ConnectionState.Open) throw new InvalidOperationException("Connection must be valid and open"); // make sure all readers on this connection are closed if (connection.Reader != null) throw new InvalidOperationException("There is already an open DataReader associated with this Connection which must be closed first."); string sql = cmdText; if (0 != (behavior & CommandBehavior.KeyInfo)) { } if (0 != (behavior & CommandBehavior.SchemaOnly)) { } if (0 != (behavior & CommandBehavior.SequentialAccess)) { } if (0 != (behavior & CommandBehavior.SingleResult)) { } if (0 != (behavior & CommandBehavior.SingleRow)) { sql = String.Format("SET SQL_SELECT_LIMIT=1;{0};SET sql_select_limit=-1;", cmdText); } arraySql = SplitSql( sql ); updateCount = -1; MySqlDataReader reader = new MySqlDataReader(this, behavior); // move to the first resultset reader.NextResult(); connection.Reader = reader; return reader; }
public void Load(MySqlDataReader dr) { SetId(Convert.ToInt32(dr["Id"])); this._effortId = Convert.ToInt32(dr["effId"]); this._rolloutId = Convert.ToInt32(dr["rollId"]); this._rolled = Convert.ToBoolean(dr["rolled"]); this._text = Convert.ToString(dr["text"]); this._reasonForCodeFix = Convert.ToString(dr["reasonForCodeFix"]); this._reasonForRollBack = Convert.ToString(dr["reasonForRollBack"]); if (dr["wasCodeFixed"] == DBNull.Value) this._codeFixed = -1; else this._codeFixed = Convert.ToInt32(dr["wasCodeFixed"]); this._departmentResponsibleForErrorId = Convert.ToInt32(dr["departmentResponsibleForErrorId"]); this._finalComments= Convert.ToString(dr["finalComment"]); MarkOld(); }
public void Load(MySqlDataReader dr) { Setup(); SetId(Convert.ToInt32(dr["Id"])); this._effId = Convert.ToInt32(dr["effId"]); this._rollId = Convert.ToInt32(dr["rollId"]); this._minutes = Convert.ToInt32(dr["minutes"]); this._date = Convert.ToDateTime(dr["date"]); this._user = Convert.ToString(dr["user"]); this._text = Convert.ToString(dr["text"]); MarkOld(); }
public EffortRollout(MySqlDataReader dr) { Setup(); this.Load(dr); }
public Time(MySqlDataReader dr) { this.Load(dr); }
public Rollout(MySqlDataReader dr) { this.Load(dr); }
public void Load(MySqlDataReader dr) { Setup(); SetId(Convert.ToInt32(dr["Id"])); this._catalog = Convert.ToString(dr["catalog"]); this._encPasswd = Convert.ToString(dr["passwd"]); this._port = Convert.ToInt32(dr["port"]); this._protocol = (QED.Business.Protocol) Enum.Parse(typeof(QED.Business.Protocol), Convert.ToString(dr["protocol"])); this._serverId = Convert.ToInt32(dr["serverId"]); this._SSPI = Convert.ToBoolean(dr["sspi"]); this._systemName = Convert.ToString(dr["systemName"]); this._transport = (QED.Business.Transport) Enum.Parse(typeof(QED.Business.Transport), Convert.ToString(dr["transport"])); this._user = Convert.ToString(dr["user"]); MarkOld(); }
public Group(MySqlDataReader dr) { this.Load(dr); }
public Connection(MySqlDataReader dr) { this.Load(dr); }
public Effort(MySqlDataReader dr, bool loadExternal) { this.Load(dr); if (loadExternal) this.LoadExternal(); }
public Client(MySqlDataReader dr) { this.Load(dr); }
public void LoadTicket(MySqlDataReader dr) { /*TODO: There are more ticket data we could get here but other table hits would be necessary */ this._extId = Convert.ToInt32(dr["ID"]); this._overdue = (dr["overdue"] == DBNull.Value) ? false : Convert.ToBoolean(dr["overdue"]); if (dr["CreationDate"] != DBNull.Value) this._creationDate = Convert.ToDateTime(dr["CreationDate"]); if (dr["CloseDate"] != DBNull.Value) this._closeDate = Convert.ToDateTime(dr["CloseDate"]); if (dr["ClientId"] != DBNull.Value) this._clientId = Convert.ToInt32(dr["ClientId"]); if (dr["PriorityID"] != DBNull.Value) this._priorityID = Convert.ToInt32(dr["PriorityID"]); }
public void Load(MySqlDataReader dr) { Setup(); SetId(Convert.ToInt32(dr["Id"])); this._text = Convert.ToString(dr["text"]); this._effId = Convert.ToInt32(dr["effId"]); this._rollId = Convert.ToInt32(dr["rollId"]); this._createdBy = Convert.ToString(dr["createdBy"]); MarkOld(); }