/// <summary> /// Loads the entity from a <b>SqlDataReader</b> object. /// </summary> /// <param name="dr">The data reader to read from.</param> /// <returns>Returns the number of columns read.</returns> /// <remarks> /// Always reads at the current cursor position, doesn't calls the <b>Read</b> function /// on the <b>SqlDataReader</b> object. Reads data columns by their ordinal position in /// the query and not by their names. /// </remarks> internal override int LoadFromDataReader(SqlDataReader dr) { int o = base.LoadFromDataReader(dr); ++o; // skip guid this.workflowTypeName = dr.GetString(++o); this.dateStarted = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.dateFinished = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.jobExecutionStatus = (JobExecutionState)dr.GetInt32(++o); this.suspendTimeout = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.scheduleType = (ScheduleType)dr.GetInt32(++o); this.scheduleTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); this.recurringPeriod = (RecurringPeriod)dr.GetInt32(++o); this.recurringInterval = dr.GetInt32(++o); this.recurringMask = dr.GetInt64(++o); this.workflowInstanceId = dr.IsDBNull(++o) ? Guid.Empty : dr.GetGuid(o); this.adminRequestTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o); if (!dr.IsDBNull(++o)) { XmlSerializer ser = new XmlSerializer(typeof(JobAdminRequestData)); StringReader sr = new StringReader(dr.GetString(o)); this.adminRequestData = (JobAdminRequestData)ser.Deserialize(sr); } else { this.adminRequestData = null; } this.adminRequestResult = dr.GetInt32(++o); this.exceptionMessage = dr.IsDBNull(++o) ? null : dr.GetString(o); return o; }
/// <summary> /// Creates a new instance of the ViewSeguridadUsuario class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewSeguridadUsuarioInfo MakeViewSeguridadUsuario(SqlDataReader dataReader) { ViewSeguridadUsuarioInfo viewSeguridadUsuario = new ViewSeguridadUsuarioInfo(); if (dataReader.IsDBNull(SeguridadUsuarioId) == false) viewSeguridadUsuario.SeguridadUsuarioId = dataReader.GetInt32(SeguridadUsuarioId); if (dataReader.IsDBNull(SeguridadRolId) == false) viewSeguridadUsuario.SeguridadRolId = dataReader.GetInt32(SeguridadRolId); if (dataReader.IsDBNull(Rol) == false) viewSeguridadUsuario.Rol = dataReader.GetString(Rol); if (dataReader.IsDBNull(NombreUsuario) == false) viewSeguridadUsuario.NombreUsuario = dataReader.GetString(NombreUsuario); if (dataReader.IsDBNull(Nombres) == false) viewSeguridadUsuario.Nombres = dataReader.GetString(Nombres); if (dataReader.IsDBNull(Apellidos) == false) viewSeguridadUsuario.Apellidos = dataReader.GetString(Apellidos); if (dataReader.IsDBNull(PaswordHash) == false) viewSeguridadUsuario.PaswordHash = dataReader.GetString(PaswordHash); if (dataReader.IsDBNull(Salt) == false) viewSeguridadUsuario.salt = dataReader.GetString(Salt); if (dataReader.IsDBNull(Activo) == false) viewSeguridadUsuario.Activo = dataReader.GetBoolean(Activo); if (dataReader.IsDBNull(NombreCompleto) == false) viewSeguridadUsuario.NombreCompleto = dataReader.GetString(NombreCompleto); return viewSeguridadUsuario; }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT FILE_INDEX, FILE_NEW_NAME, FILE_ORI_NAME, FILE_MD5, FILE_IMG, RECSTA, LDATE, LUSER FROM MIP_FILE_STORE WHERE FILE_INDEX=@FILE_INDEX_PARAM"; cmd.Parameters.AddWithValue("@FILE_INDEX_PARAM", _fILE_INDEX); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _fILE_INDEX = reader.GetInt32(0); _fILE_NEW_NAME = reader.GetString(1); _fILE_ORI_NAME = reader.GetString(2); _fILE_MD5 = reader.GetString(3); //_fILE_IMG = reader.GetByte(4); _fILE_IMG = (byte[])reader[4]; _rECSTA = reader.GetInt32(5); _lDATE = reader.GetDateTime(6); _lUSER = reader.GetString(7); } reader.Close(); } }
public List <Employee> GetEmployeeList() { List <Employee> employeeList = new List <Employee>(); Dao dao = new Dao(); string sqlStatement = "SELECT EmployeeID, EmployeeName, Gender, Position, StartDate, Address, PhoneNumber FROM Employee"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader == null) { return(null); } while (reader.Read()) { int id = reader.GetInt32(0); string name = reader.GetString(1); bool gender = reader.GetBoolean(2); string position = reader.GetString(3); DateTime date = reader.GetDateTime(4); string address = reader.GetString(5); string phone = reader.GetString(6); employeeList.Add(new Employee(id, name, gender, position, date, address, phone)); } dao.Con.Close(); return(employeeList); }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT MAIL_ID, APP_TYPE, SOURCE, EMAIL_ADDR, MAINORCC, NOTETXT, LDATA, LUSER FROM MIP_EMAIL WHERE MAIL_ID=@MAIL_ID_PARAM"; cmd.Parameters.AddWithValue("@MAIL_ID_PARAM", _mAIL_ID); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _mAIL_ID = reader.GetInt32(0); _aPP_TYPE = reader.GetInt32(1); _sOURCE = reader.GetString(2); _eMAIL_ADDR = reader.GetString(3); _mAINORCC = reader.GetInt32(4); _nOTETXT = reader.GetString(5); _lDATA = reader.GetDateTime(6); _lUSER = reader.GetString(7); } reader.Close(); } }
public void referralButton_Click(object sender, CommandEventArgs e) { int scholarshipID = Convert.ToInt32(e.CommandArgument); String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection(connectionString); sc.Open(); System.Data.SqlClient.SqlCommand pullJobInfo = new System.Data.SqlClient.SqlCommand(); pullJobInfo.CommandText = "SELECT Scholarship.ScholarshipName, Organization.OrganizationName FROM Scholarship INNER JOIN Organization ON Scholarship.OrganizationID = Organization.OrganizationEntityID WHERE Scholarship.ScholarshipID = " + scholarshipID; pullJobInfo.Connection = sc; System.Data.SqlClient.SqlDataReader reader = pullJobInfo.ExecuteReader(); String scholarshipName = ""; String orgName = ""; while (reader.Read()) { scholarshipName = reader.GetString(0); orgName = reader.GetString(1); } lblScholarshipName.Text = scholarshipName; lblOrgName.Text = orgName; ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openSendToModal();", true); }
///<summary></summary> protected override void ReadExecuted(System.Data.SqlClient.SqlDataReader dr) { if (dr != null && !dr.IsClosed) { #region Read Each Field if (!dr.IsDBNull(dr.GetOrdinal("Id"))) { m_Current.Id = dr.GetInt32(dr.GetOrdinal("Id")); } if (!dr.IsDBNull(dr.GetOrdinal("Name"))) { m_Current.Name = dr.GetString(dr.GetOrdinal("Name")); } if (!dr.IsDBNull(dr.GetOrdinal("UrlSlug"))) { m_Current.UrlSlug = dr.GetString(dr.GetOrdinal("UrlSlug")); } if (!dr.IsDBNull(dr.GetOrdinal("Description"))) { m_Current.Description = dr.GetString(dr.GetOrdinal("Description")); } #endregion ExistsInDB = true; Mode = EditMode.None; SetOriginalValues(); } }
public Project(string name, string description, string businessvalue) { mName = name; mDescription = description; mBusinessValue = businessvalue; mDatabase.connect(); mReader=mDatabase.executeread("SELECT Description FROM [dbo].[Issues] WHERE ProjectName='" + mName + "'"); while (mReader.Read() ) { mIssues.Add(new Issue(mReader.GetString(0).ToString(), mName)); } mReader.Close(); mReader = mDatabase.executeread("SELECT Description, Address FROM [dbo].[Link] WHERE ProjectName='" + mName + "'"); while (mReader.Read() ) { mLinks.Add(new Link(mReader.GetString(0).ToString(), mName, mReader.GetString(1).ToString())); } mReader.Close(); mReader = mDatabase.executeread("SELECT DependantName, [dbo].[Project].Description, [dbo].[Project].BusinessValueName FROM [dbo].[Dependents], [dbo].[Project] WHERE ProjectName='" + mName + "' AND DependantName=Name"); while (mReader.Read() ) { mDependencies.Add(new Project(mReader.GetString(0).ToString(), mReader.GetString(1).ToString(), mReader.GetString(2).ToString())); } mReader.Close(); }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT version, sqltype, file_desc, fileUploadOldName, fileUploadNewName, datetime, version_no, imageData FROM userUploadLog WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _version = reader.GetInt32(0); _sqltype = reader.GetInt32(1); _file_desc = reader.GetString(2); _fileUploadOldName = reader.GetString(3); _fileUploadNewName = reader.GetString(4); _datetime = reader.GetDateTime(5); _version_no = reader.GetString(6); //_imageData = reader.GetBytes(7); _imageData = (byte[])reader[7]; } reader.Close(); } }
protected void rejectStudentLinkBtn_Click(object sender, CommandEventArgs e) { String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString); int rowIndex = Convert.ToInt32(((sender as LinkButton).NamingContainer as GridViewRow).RowIndex); GridViewRow row = GridView1.Rows[rowIndex]; int jobID = Convert.ToInt32(e.CommandArgument); Session["selectedapplicationID"] = jobID.ToString(); sql.Open(); System.Data.SqlClient.SqlCommand moreJobInfo = new System.Data.SqlClient.SqlCommand(); moreJobInfo.Connection = sql; moreJobInfo.CommandText = "SELECT ApplicationRequest.ApplicationID, Student.FirstName + ' ' + Student.LastName AS FullName, JobListing.JobTitle, Organization.OrganizationName FROM ApplicationRequest INNER JOIN JobListing ON ApplicationRequest.JobListingID = JobListing.JobListingID INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID INNER JOIN Student ON ApplicationRequest.StudentEntityID = Student.StudentEntityID WHERE ApplicationRequest.ApplicationID = " + Session["selectedapplicationID"]; System.Data.SqlClient.SqlDataReader reader = moreJobInfo.ExecuteReader(); while (reader.Read()) { StudentRejectLabel.Text = reader.GetString(1); StudentRejectSubLabel.Text = reader.GetString(2); Student2ndRejectSubLabel.Text = reader.GetString(3); } sql.Close(); ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openRejectJModal();", true); }
public RoadMap(string name ) { mName = name; mDatabase.connect(); mReader = mDatabase.executeread("SELECT Timestamp, Description, UserID FROM [dbo].[Roadmap] WHERE Name = '" + name + "'"); mReader.Read(); mTimeStamp = mReader.GetDateTime(0); mDescription = mReader.GetString(1); string UID = mReader.GetString(2); mDatabase.close(); mDatabase.connect(); mReader = mDatabase.executeread("SELECT Name, Email, Password FROM [dbo].[User] WHERE ID = '" + UID + "'"); mReader.Read(); mUser = new User(mReader.GetString(0), UID, mReader.GetString(1), mReader.GetString(2)); mDatabase.close(); mTimeline = new TimeLine(mName); //Get the StrategyPoints mDatabase.connect(); mReader = mDatabase.executeread("SELECT Name, Description FROM [dbo].[StrategyPoint] WHERE RoadmapName = '" + name + "'"); while (mReader.Read()) { StrategyPoint sp = new StrategyPoint(mReader.GetString(0), mReader.GetString(1)); mStrategyPoints.Add(sp); } mDatabase.close(); }
public static JArray SqlDataReader2Json(SqlDataReader reader, string col0, string col1) { var colNames = new Dictionary<string, int>(); for (int i = 0; i < reader.FieldCount; i++) { colNames[reader.GetName(i)] = i; } var parent = new Dictionary<string, HashSet<string>>(StringComparer.OrdinalIgnoreCase); while (reader.Read()) { string parentColumn = reader.GetString(colNames[col0]); string childColumn = reader.GetString(colNames[col1]); HashSet<string> child; if (!parent.TryGetValue(parentColumn, out child)) { child = new HashSet<string>(StringComparer.OrdinalIgnoreCase); parent.Add(parentColumn, child); } child.Add(childColumn); } return MakeJArray(parent); }
public List <Settings> GetAll() { System.Data.SqlClient.SqlCommand cmd = null; System.Data.SqlClient.SqlDataReader SDR = null; System.Collections.Generic.List <Settings> ListTmp = new System.Collections.Generic.List <Settings>(); Settings ObjTmp = null; DBCon Obj = new DBCon(); try { string Query = "SELECT * FROM Settings "; cmd = new System.Data.SqlClient.SqlCommand(Query, Obj.Con); SDR = cmd.ExecuteReader(); while (SDR.Read()) { ObjTmp = new Settings { SettingId = SDR.GetInt32(0), KeyName = SDR.GetString(1), KeyValue = SDR.GetString(2), KeyDiscription = SDR.GetString(3), }; ListTmp.Add(ObjTmp); } } catch (System.Exception e) { e.ToString(); } finally { cmd.Dispose(); SDR.Close(); Obj.Con.Close(); Obj.Con.Dispose(); Obj.Con = null; } return(ListTmp); }
public Customer ReturnCustomer(int id) { Customer a = new Customer(); System.Data.SqlClient.SqlDataReader reader = null; string strSQL = "SELECT * FROM Customer WHERE ID = @id"; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(strSQL, conn); cmd.Parameters.AddWithValue("@id", id); reader = cmd.ExecuteReader(); if (reader.Read()) { a.ID = reader.GetInt32(0); a.Email = reader.GetString(1); a.FirstName = reader.GetString(2); a.LastName = reader.GetString(3); a.Age = reader.GetInt32(4); a.PhoneNumber = reader.GetInt32(4); return(a); } else { return(null); } }
public bool SearchUserInfo(string username, string password) { using (var command = new C.SqlCommand()) { command.Connection = connection; command.CommandType = D.CommandType.Text; command.CommandText = @" SELECT Username, Password FROM dbo.Users; "; C.SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { this.username = reader.GetString(0); this.password = reader.GetString(1); if (username.Equals(this.username) && password.Equals(this.password)) { reader.Close(); return(true); } } reader.Close(); return(false); } }
private Documents(SqlDataReader data) { ID = data.GetInt32(0); Name = data.GetString(1); hash = data.GetString(2); buffer = data.GetSqlBinary(3).Value; }
public int getComments(int id, out List<string> name, out List<DateTime> date, out List<string> comments) { name = new List<string>(); date = new List<DateTime>(); comments = new List<string>(); cmd.CommandText = "SELECT * FROM comment where id=" + id.ToString() + " ORDER BY comdate DESC"; try { SqlInit(); dr = cmd.ExecuteReader(); while (dr.Read()) { name.Add(dr.GetString(1)); date.Add(dr.GetDateTime(2)); comments.Add(dr.GetString(3)); } } catch(SqlException e) { SqlExit(); return 666; } if (name.Count == 0) { SqlExit(); return 1;//no comments } SqlExit(); return 0;//success }
protected override Exception ProcessSqlResult(SqlDataReader reader) { Exception nextResultSet = StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader); if (nextResultSet == null) { reader.NextResult(); List<IDictionary<XName, object>> parameters = new List<IDictionary<XName, object>>(); if (reader.Read()) { do { IDictionary<XName, object> item = new Dictionary<XName, object>(); item.Add(WorkflowServiceNamespace.SiteName, reader.GetString(0)); item.Add(WorkflowServiceNamespace.RelativeApplicationPath, reader.GetString(1)); item.Add(WorkflowServiceNamespace.RelativeServicePath, reader.GetString(2)); parameters.Add(item); } while (reader.Read()); } else { base.Store.UpdateEventStatus(false, InstancePersistenceEvent<HasActivatableWorkflowEvent>.Value); base.StoreLock.InstanceDetectionTask.ResetTimer(false); } base.InstancePersistenceContext.QueriedInstanceStore(new ActivatableWorkflowsQueryResult(parameters)); } return nextResultSet; }
public static IDictionary <string, IList <string> > GetUserPushTokensByOs(String databaseName, Guid userId) { using (var conn = new System.Data.SqlClient.SqlConnection(Solution.CreateFromContext(databaseName).ConnectionString)) { conn.Open(); var cmd = new System.Data.SqlClient.SqlCommand("[admin].[GetUserPushTokens]", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; try { System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(cmd); } catch { throw new Exception("Database does not support push notifications"); } cmd.Parameters["@UserId"].Value = userId; var result = new Dictionary <string, IList <string> >(); using (System.Data.SqlClient.SqlDataReader r = cmd.ExecuteReader()) while (r.Read()) { string token = r.GetString(0); string os = r.GetString(1); IList <string> tokens; if (!result.TryGetValue(os, out tokens)) { result.Add(os, tokens = new List <string>()); } tokens.Add(token); } return(result); } }
public LoginDB(System.Data.SqlClient.SqlDataReader reader) { this.reader = reader; this.ID = reader.GetInt64(reader.GetOrdinal("Id")); this.Login = reader.GetString(reader.GetOrdinal("Login")); this.Senha = reader.GetString(reader.GetOrdinal("Senha")); }
///<summary></summary> protected override void ReadExecuted(System.Data.SqlClient.SqlDataReader dr) { if (dr != null && !dr.IsClosed) { #region Read Each Field if (!dr.IsDBNull(dr.GetOrdinal("ImageId"))) { m_Current.ImageId = dr.GetInt32(dr.GetOrdinal("ImageId")); } if (!dr.IsDBNull(dr.GetOrdinal("FileName"))) { m_Current.FileName = dr.GetString(dr.GetOrdinal("FileName")); } if (!dr.IsDBNull(dr.GetOrdinal("Extension"))) { m_Current.Extension = dr.GetString(dr.GetOrdinal("Extension")); } if (!dr.IsDBNull(dr.GetOrdinal("ProjectFileDirectory"))) { m_Current.ProjectFileDirectory = dr.GetString(dr.GetOrdinal("ProjectFileDirectory")); } if (!dr.IsDBNull(dr.GetOrdinal("Description"))) { m_Current.Description = dr.GetString(dr.GetOrdinal("Description")); } if (!dr.IsDBNull(dr.GetOrdinal("Enabled"))) { m_Current.Enabled = dr.GetBoolean(dr.GetOrdinal("Enabled")); } #endregion ExistsInDB = true; Mode = EditMode.None; SetOriginalValues(); } }
/// <summary> /// Creates a new instance of the ViewAuditoriaListaVerificacionDetalle class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewAuditoriaListaVerificacionDetalleInfo MakeViewAuditoriaListaVerificacionDetalle(SqlDataReader dataReader) { ViewAuditoriaListaVerificacionDetalleInfo viewAuditoriaListaVerificacionDetalle = new ViewAuditoriaListaVerificacionDetalleInfo(); if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaListaVerificacionDetalleId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleId); if (dataReader.IsDBNull(AuditoriaListaVerificacionId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaListaVerificacionId = dataReader.GetInt32(AuditoriaListaVerificacionId); if (dataReader.IsDBNull(AuditoriaPuntoId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaPuntoId = dataReader.GetInt32(AuditoriaPuntoId); if (dataReader.IsDBNull(AuditoriaControlId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaControlId = dataReader.GetInt32(AuditoriaControlId); if (dataReader.IsDBNull(PuntajeRequerido) == false) viewAuditoriaListaVerificacionDetalle.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido); if (dataReader.IsDBNull(AuditoriaPunto) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaPunto = dataReader.GetString(AuditoriaPunto); if (dataReader.IsDBNull(AuditoriaControl) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaControl = dataReader.GetString(AuditoriaControl); if (dataReader.IsDBNull(Orden) == false) viewAuditoriaListaVerificacionDetalle.Orden = dataReader.GetByte(Orden); if (dataReader.IsDBNull(Activo) == false) viewAuditoriaListaVerificacionDetalle.Activo = dataReader.GetBoolean(Activo); return viewAuditoriaListaVerificacionDetalle; }
public static NewMemberBalancePrediction Factory(SqlDataReader reader) { var newMemberId = reader.GetInt32(0); var dependentId = reader.GetInt32(1); var birthYear = reader.GetInt32(2); var state = reader.GetString(3); var lastCptCode = reader.GetString(4); var cachedBalance = reader.GetString(5); var recommendedBalance = reader.GetValue(6); double d; double.TryParse(recommendedBalance == null ? "0" : recommendedBalance.ToString(), out d); var sufficientAmount = reader.GetInt32(7); var serviceEnd = reader.GetDateTime(8); return new NewMemberBalancePrediction { NewMemberId = newMemberId, DependentId = dependentId, BirthYear = birthYear, State = state, LastCptCode = lastCptCode, CachedBalance = cachedBalance, RecommendedBalance = Math.Round(d, 2), SufficientAmount = sufficientAmount, ServiceEnd = serviceEnd }; }
public void referralButton_Click(object sender, CommandEventArgs e) { int jobListingID = Convert.ToInt32(e.CommandArgument); String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection(connectionString); sc.Open(); System.Data.SqlClient.SqlCommand pullJobInfo = new System.Data.SqlClient.SqlCommand(); pullJobInfo.CommandText = "SELECT JobListing.JobTitle, JobListing.JobDescription, JobListing.JobType, JobListing.Location, JobListing.Deadline, Organization.OrganizationName FROM JobListing INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID WHERE JobListing.JobListingID = " + jobListingID; pullJobInfo.Connection = sc; System.Data.SqlClient.SqlDataReader reader = pullJobInfo.ExecuteReader(); String jobTitle = ""; String orgName = ""; while (reader.Read()) { jobTitle = reader.GetString(0); orgName = reader.GetString(5); } lblJobTitle.Text = jobTitle; lblOrgName.Text = orgName; //ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openSendToModal();", true); }
protected void btnSignIn_Click(object sender, ImageClickEventArgs e) { if (txtUsername.Text.Trim() == "" || txtPassword.Text.Trim() == "") lblMessage.Text = "Both fields are required"; else { query = "select usertype from Login where username='******' AND Password='******'"; reader = db.data_read(query); if (reader.Read()) { if (reader.GetString(0).Trim() == "Employee") // Go to employee's home page { Session["username"] = txtUsername.Text; reader.Close(); Response.Redirect("~/employee/EmployeeHome.aspx"); } else if (reader.GetString(0).Trim() == "Employer")// Go to employer's home page { Session["username"] = txtUsername.Text; reader.Close(); Response.Redirect("~/employer/EmployerHome.aspx"); } else // Go to admin's home page { Session["username"] = txtUsername.Text; Response.Redirect("~/admin/Home.aspx"); } } else { lblMessage.Text = "Invalid Username/Password or no such user exists"; } } }
public bool AuthTest(string username, string password, ref userType theUser) { bool autorised = false; OpenConnection(); Console.WriteLine("Debugging:"); soHigh(username, ref password); sqlCmd.CommandText = string.Format("select StaffName, Password, StaffTypeID, StaffID from Staff WHERE StaffName='{0}' AND Password='******';", username, password); sqlCmd.Connection = dbConnection; reader = sqlCmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); if ((username == reader.GetString(0)) && (password == reader.GetString(1))) { userid = reader.GetInt32(3); theUser = (userType)reader.GetInt32(2); autorised = true; } } if(debugging){ AuthDebugging(username, password); } CloseConnection(); return autorised; }
public List <Product> SearchProductListByName(string searchvalue) { List <Product> ProductList = new List <Product>(); Dao dao = new Dao(); string sqlStatement = "SELECT ProductID, ProductName, Price, Quantity, Image, Description, CategoryID FROM Product where ProductName Like N'%" + searchvalue + "%'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader == null) { return(null); } while (reader.Read()) { try { int id = reader.GetInt32(0); string name = reader.GetString(1); double price = (double)reader.GetDecimal(2); int quantity = reader.GetInt32(3); string image = reader.GetString(4); string description = "sss"; int categoryID = reader.GetInt32(6); ProductList.Add(new Product(id, name, price, quantity, image, description, categoryID)); } catch (Exception) { } } dao.Con.Close(); return(ProductList); }
//Gridview Approve Button in Reject Gridview protected void approveJobLinkBtn_Click(object sender, CommandEventArgs e) { String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString); int rowIndex = Convert.ToInt32(((sender as LinkButton).NamingContainer as GridViewRow).RowIndex); GridViewRow row = gridviewRejJobs.Rows[rowIndex]; int jobID = Convert.ToInt32(e.CommandArgument); Session["selectedjobID"] = jobID.ToString(); sql.Open(); System.Data.SqlClient.SqlCommand moreJobInfo = new System.Data.SqlClient.SqlCommand(); moreJobInfo.Connection = sql; moreJobInfo.CommandText = "SELECT JobListing.JobTitle, Organization.OrganizationName, JobListing.JobListingID FROM JobListing INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID where JobListingID = " + Session["selectedjobID"]; System.Data.SqlClient.SqlDataReader reader = moreJobInfo.ExecuteReader(); while (reader.Read()) { lblJobApprove.Text = reader.GetString(0); lblJobSubApprove.Text = reader.GetString(1); } sql.Close(); ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openApproveXModal();", true); }
//Gridview Approve Button in Rejected GridView protected void btnScholarshipApprove_Click(object sender, CommandEventArgs e) { String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString); int rowIndex = Convert.ToInt32(((sender as LinkButton).NamingContainer as GridViewRow).RowIndex); GridViewRow row = rejScholarshipGridview.Rows[rowIndex]; int scholarshipID = Convert.ToInt32(e.CommandArgument); Session["selectedScholarshipID"] = scholarshipID.ToString(); sql.Open(); System.Data.SqlClient.SqlCommand moreJobInfo = new System.Data.SqlClient.SqlCommand(); moreJobInfo.Connection = sql; moreJobInfo.CommandText = "SELECT Scholarship.ScholarshipID, Scholarship.ScholarshipName, Organization.OrganizationName FROM Scholarship INNER JOIN Organization ON Scholarship.OrganizationID = Organization.OrganizationEntityID where ScholarshipID = " + Session["selectedScholarshipID"]; System.Data.SqlClient.SqlDataReader reader = moreJobInfo.ExecuteReader(); while (reader.Read()) { lblScholarApprove.Text = reader.GetString(1); lblScholarSubApprove.Text = reader.GetString(2); } sql.Close(); ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openApproveSModal();", true); }
/// <summary> /// Creates a new instance of the ViewLDV class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewLDVInfo MakeViewLDV(SqlDataReader dataReader) { ViewLDVInfo viewLDV = new ViewLDVInfo(); if (dataReader.IsDBNull(Cod_LDV) == false) viewLDV.Cod_LDV = dataReader.GetInt32(Cod_LDV); if (dataReader.IsDBNull(Cod_TipoLDV) == false) viewLDV.Cod_TipoLDV = dataReader.GetInt32(Cod_TipoLDV); if (dataReader.IsDBNull(Tipo_LDV) == false) viewLDV.Tipo_LDV = dataReader.GetString(Tipo_LDV); if (dataReader.IsDBNull(Nombre_Lugar) == false) viewLDV.Nombre_Lugar = dataReader.GetString(Nombre_Lugar); if (dataReader.IsDBNull(Cod_Direccion) == false) viewLDV.Cod_Direccion = dataReader.GetInt32(Cod_Direccion); if (dataReader.IsDBNull(Calle) == false) viewLDV.Calle = dataReader.GetString(Calle); if (dataReader.IsDBNull(Cod_Localidad) == false) viewLDV.Cod_Localidad = dataReader.GetInt32(Cod_Localidad); if (dataReader.IsDBNull(Localidad) == false) viewLDV.Localidad = dataReader.GetString(Localidad); if (dataReader.IsDBNull(Cod_Provincia) == false) viewLDV.Cod_Provincia = dataReader.GetInt32(Cod_Provincia); if (dataReader.IsDBNull(Provincia) == false) viewLDV.Provincia = dataReader.GetString(Provincia); return viewLDV; }
public TList_Empreendimento Select(TpBusca[] vBusca, Int32 vTop, string vNM_Campo) { bool podeFecharBco = false; TList_Empreendimento lista = new TList_Empreendimento(); if (Banco_Dados == null) { this.CriarBanco_Dados(false); podeFecharBco = true; } System.Data.SqlClient.SqlDataReader reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, vTop, vNM_Campo)); try { while (reader.Read()) { TRegistro_Empreendimento reg = new TRegistro_Empreendimento(); if (!(reader.IsDBNull(reader.GetOrdinal("ID_Empreendimento")))) { reg.Id_empreendimento = reader.GetDecimal(reader.GetOrdinal("ID_Empreendimento")); } if (!(reader.IsDBNull(reader.GetOrdinal("CD_Empresa")))) { reg.Cd_empresa = reader.GetString(reader.GetOrdinal("CD_Empresa")); } if (!(reader.IsDBNull(reader.GetOrdinal("NM_Empresa")))) { reg.Nm_empresa = reader.GetString(reader.GetOrdinal("NM_Empresa")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Empreendimento"))) { reg.Ds_empreendimento = reader.GetString(reader.GetOrdinal("DS_Empreendimento")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Observacao"))) { reg.Ds_observacao = reader.GetString(reader.GetOrdinal("DS_Observacao")); } if (!reader.IsDBNull(reader.GetOrdinal("DT_IniEmpreendimento"))) { reg.Dt_iniempreendimento = reader.GetDateTime(reader.GetOrdinal("DT_IniEmpreendimento")); } if (!(reader.IsDBNull(reader.GetOrdinal("ST_Registro")))) { reg.St_registro = reader.GetString(reader.GetOrdinal("ST_Registro")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
protected void Button1_Click(object sender, EventArgs e) { using (System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection("Data Source=dcm.uhcl.edu;Initial Catalog=c432016fa02kasichainulak;User ID=kasichainulak;Password=1456090")) { sql.Open(); String selectquery = "SELECT * FROM kasichainulak_WADfl16_studentinfor"; System.Data.SqlClient.SqlCommand sp = new System.Data.SqlClient.SqlCommand(selectquery, sql); System.Data.SqlClient.SqlDataReader reader = sp.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { StudentInfor student = new StudentInfor(); student.emailAddress = reader.GetString(7); if (student.emailAddress == TextBox1.Text) { student.password = reader.GetString(2); password = student.password; email_valid = 1; } } } reader.Close(); sql.Close(); } if (email_valid == 1) { /* Body of the email is:*/ string body_part1 = "Dear Valued Student, <br /> You are receiving this email beause you requested to recover your password."; string body_part2 = "<br /><br />Your current password is:" + "<mark>" + password + "</mark>"; string body_part3 = "<br /><mark>K.K Student Loan</mark>"; //string body_part4 = "<br /> You can now access your loan account at" + "<a href=" + "login.aspx\"" + ">" + "</a>"; string body = body_part1 + body_part2 + body_part3; using (MailMessage mail = new MailMessage(ConfigurationManager.AppSettings["SMTPuser"], TextBox1.Text)) { mail.Subject = "We have recovered your password!"; mail.Body = body; mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = ConfigurationManager.AppSettings["Host"]; smtp.EnableSsl = Convert.ToBoolean(ConfigurationManager.AppSettings["EnableSSL"]);; NetworkCredential NetworkCred = new NetworkCredential(ConfigurationManager.AppSettings["SMTPuser"], ConfigurationManager.AppSettings["SMTPpassword"]); smtp.UseDefaultCredentials = true; smtp.Credentials = NetworkCred; smtp.Port = int.Parse(ConfigurationManager.AppSettings["Port"]);; smtp.Send(mail); ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Thank You. An email has been sent to the address you have provided');", true); } } else { ClientScript.RegisterStartupScript(GetType(), "alert", "alert('You are not in my database');", true); } }
//approve button clicked in gridview--opens modal-- populates modal protected void approveJobLinkBtn_Click(object sender, CommandEventArgs e) { String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString); int rowIndex = Convert.ToInt32(((sender as LinkButton).NamingContainer as GridViewRow).RowIndex); GridViewRow row = GridView1.Rows[rowIndex]; int jobID = Convert.ToInt32(e.CommandArgument); Session["selectedjobID"] = jobID.ToString(); String temp = Session["selectedjobID"].ToString(); sql.Open(); System.Data.SqlClient.SqlCommand moreJobInfo = new System.Data.SqlClient.SqlCommand(); moreJobInfo.Connection = sql; moreJobInfo.CommandText = "SELECT Organization.OrganizationName, JobListing.JobTitle FROM JobListing INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID where JobListingID = " + Session["selectedjobid"]; System.Data.SqlClient.SqlDataReader reader = moreJobInfo.ExecuteReader(); while (reader.Read()) { Label2.Text = reader.GetString(0); sublabelapprovemodal.Text = reader.GetString(1); } sql.Close(); System.Data.SqlClient.SqlConnection EmailQuery = new System.Data.SqlClient.SqlConnection(connectionString); // Mail Button Query EmailQuery.Open(); System.Data.SqlClient.SqlCommand query = new System.Data.SqlClient.SqlCommand(); query.Connection = EmailQuery; query.CommandText = "SELECT UserEntity.EmailAddress FROM JobListing INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID INNER JOIN UserEntity ON Organization.OrganizationEntityID = UserEntity.UserEntityID WHERE JobListing.JobListingID = " + Session["selectedjobID"]; System.Data.SqlClient.SqlDataReader Result = query.ExecuteReader(); while (Result.Read()) { email = Result.GetString(0); } EmailQuery.Close(); MailButtonLink.NavigateUrl = "mailto:" + email + "?Subject=CommUP:%20Job%20Approval!"; ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openApproveXModal();", true); }
/// <summary> /// Constructs an instance of IStoreLocation using parts of a row from SqlDataReader. /// Used for creating the shard location instance. /// </summary> /// <param name="reader">SqlDataReader whose row has shard information.</param> /// <param name="offset">Reader offset for column that begins shard information.</param> internal SqlLocation(SqlDataReader reader, int offset) { this.Location = new ShardLocation( reader.GetString(offset + 1), reader.GetString(offset + 3), (SqlProtocol)reader.GetInt32(offset), reader.GetInt32(offset + 2)); }
public void PopulateCategory(SqlDataReader _dtr, Category obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_DESCRIPTION); if (!_dtr.IsDBNull(columnIndex)) { obj.Description = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_TYPE); if (!_dtr.IsDBNull(columnIndex)) { obj.Type = (TG.ExpressCMS.DataLayer.Enums.RootEnums.CategoryType)_dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ATTRIBUTES); if (!_dtr.IsDBNull(columnIndex)) { obj.Attributes = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ISDELETED); if (!_dtr.IsDBNull(columnIndex)) { obj.IsDeleted = _dtr.GetBoolean((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_XSL_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.XslID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_image); if (!_dtr.IsDBNull(columnIndex)) { obj.Image = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_LANGUAGE_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.LanguageID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_HASH); if (!_dtr.IsDBNull(columnIndex)) { obj.Hash = _dtr.GetString((columnIndex)); } }
//Gridview Approve Button in Rejected GridView protected void btnScholarshipApprove_Click(object sender, CommandEventArgs e) { String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString); int rowIndex = Convert.ToInt32(((sender as LinkButton).NamingContainer as GridViewRow).RowIndex); GridViewRow row = rejScholarshipGridview.Rows[rowIndex]; int scholarshipID = Convert.ToInt32(e.CommandArgument); Session["selectedScholarshipID"] = scholarshipID.ToString(); sql.Open(); System.Data.SqlClient.SqlCommand moreJobInfo = new System.Data.SqlClient.SqlCommand(); moreJobInfo.Connection = sql; moreJobInfo.CommandText = "SELECT Scholarship.ScholarshipID, Scholarship.ScholarshipName, Organization.OrganizationName FROM Scholarship INNER JOIN Organization ON Scholarship.OrganizationID = Organization.OrganizationEntityID where ScholarshipID = " + Session["selectedScholarshipID"]; System.Data.SqlClient.SqlDataReader reader = moreJobInfo.ExecuteReader(); while (reader.Read()) { lblScholarApprove.Text = reader.GetString(1); lblScholarSubApprove.Text = reader.GetString(2); } sql.Close(); System.Data.SqlClient.SqlConnection EmailQuery = new System.Data.SqlClient.SqlConnection(connectionString); // Mail Button Query EmailQuery.Open(); System.Data.SqlClient.SqlCommand query = new System.Data.SqlClient.SqlCommand(); query.Connection = EmailQuery; query.CommandText = "SELECT UserEntity.EmailAddress FROM Scholarship INNER JOIN Organization ON Scholarship.OrganizationID = Organization.OrganizationEntityID INNER JOIN UserEntity ON Organization.OrganizationEntityID = UserEntity.UserEntityID WHERE Scholarship.ScholarshipID= " + Session["selectedScholarshipID"]; System.Data.SqlClient.SqlDataReader Result = query.ExecuteReader(); while (Result.Read()) { email = Result.GetString(0); } EmailQuery.Close(); AcceptSMaillink.NavigateUrl = "mailto:" + email + "?Subject=CommUP:%20Scholarship%20Approval!"; ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openApproveSModal();", true); }
/** * Get all the information for a user **/ public User GetUser( string username ) { mDatabase.connect(); mReader = mDatabase.executeread("SELECT Name, Email, Password FROM [dbo].[User] WHERE ID = '" + username + "'" ); mReader.Read(); User user = new User(mReader.GetString(0).ToString(), username, mReader.GetString(1).ToString(), mReader.GetString(2).ToString()); mDatabase.close(); return user; }
protected override DomainObject LoadEntity(int Id, SqlDataReader res) { Rehber rehber = new Rehber(string.Empty); while (res.Read()) { rehber.RehberAdi = res.GetString(1); rehber.KisiEkle(new Kisi(res.GetString(2), res.GetString(3))); } return rehber; }
public EntityBase PopulateEntity(SqlDataReader reader) { Customer customer = new Customer(); if (!reader.IsDBNull(ord_CustomerID)) customer.CustomerID = reader.GetInt32(ord_CustomerID); if (!reader.IsDBNull(ord_FirstName)) customer.FirstName = reader.GetString(ord_FirstName); if (!reader.IsDBNull(ord_LastName)) customer.LastName = reader.GetString(ord_LastName); if (!reader.IsDBNull(ord_Age)) customer.Age = reader.GetInt32(ord_Age); if (!reader.IsDBNull(ord_EmailAddress)) customer.EmailAddress = reader.GetString(ord_EmailAddress); return customer; }
private string GetObjectValue(System.Data.SqlClient.SqlDataReader reader, int i) { string fieldType = reader.GetFieldType(i).ToString(); object FieldValue = null;; if (fieldType.Contains("Int32")) { FieldValue = reader.GetInt32(i); } else if (fieldType.Contains("Int64")) { FieldValue = reader.GetInt64(i); } else if (fieldType.Contains("Decimal")) { FieldValue = reader.GetDecimal(i); } else if (fieldType.Contains("Double")) { FieldValue = reader.GetDouble(i); } else if (fieldType.Contains("DateTime")) { FieldValue = reader.GetDateTime(i); } else if (fieldType.Contains("String")) { FieldValue = reader.GetString(i); } else if (fieldType.Contains("Boolean")) { FieldValue = reader.GetBoolean(i); } else if (fieldType.Contains("Byte")) { FieldValue = reader.GetByte(i); } else if (fieldType.Contains("Guid")) { FieldValue = reader.GetGuid(i); } else { FieldValue = reader.GetString(i); } if (FieldValue != null) { return(FieldValue.ToString()); } else { return(""); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT RecordID, ModuleDesc, FunctionDesc, ActionDesc, FieldDesc, FieldBefore, FieldAfter, Name, AccountID, cDatetime, Top5 FROM SecurityUserAccount_OperateRecord WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _recordID = reader.GetString(0); _moduleDesc = reader.GetString(1); _functionDesc = reader.GetString(2); _actionDesc = reader.GetString(3); _fieldDesc = reader.GetString(4); _fieldBefore = reader.GetString(5); _fieldAfter = reader.GetString(6); _name = reader.GetString(7); _accountID = reader.GetString(8); _cDatetime = reader.GetDateTime(9); _top5 = reader.GetInt32(10); } reader.Close(); } }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT MIP_MSG_NO, MSG_TARGET, RESERVATION, ONLINE_TIME, OFFLINE_TIME, DOPUSH, MSG_KIND_1, MSG_KIND_2, MSG_TITLE, MSG_CONTENT, MSG_STATE, LDATE, LUSER, SELECTALL, PROCESSED, ISNEW FROM MIP_MSG_MAIN WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _mIP_MSG_NO = reader.GetInt32(0); _mSG_TARGET = reader.GetString(1); _rESERVATION = reader.GetString(2); _oNLINE_TIME = reader.GetDateTime(3); _oFFLINE_TIME = reader.GetDateTime(4); _dOPUSH = reader.GetString(5); _mSG_KIND_1 = reader.GetString(6); _mSG_KIND_2 = reader.GetString(7); _mSG_TITLE = reader.GetString(8); _mSG_CONTENT = reader.GetString(9); _mSG_STATE = reader.GetString(10); _lDATE = reader.GetDateTime(11); _lUSER = reader.GetString(12); _sELECTALL = reader.GetInt32(13); _pROCESSED = reader.GetInt32(14); _iSNEW = reader.GetInt32(15); } reader.Close(); } }
//protected void SearchButton_Click(object sender, EventArgs e) //{ // String term = SearchBox.Text; // StudentOpportunity.SelectParameters.Add("term", term); // StudentOpportunity.SelectCommand = "SELECT ApplicationRequest.ApplicationID, Student.StudentImage, CONCAT(Student.FirstName, ' ', Student.LastName) AS FullName, Student.StudentGradeLevel, Student.StudentGPA, Student.HoursOfWorkPlaceExp, JobListing.JobTitle, JobListing.JobDescription, JobListing.JobType, Organization.OrganizationName FROM ApplicationRequest INNER JOIN JobListing ON ApplicationRequest.JobListingID = JobListing.JobListingID INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID INNER JOIN Student ON ApplicationRequest.StudentEntityID = Student.StudentEntityID WHERE(ApplicationRequest.ApprovedFlag = 'P') and((Student.FirstName like '%" + @term + "%' or Student.LastName like '%" + @term + "%') or (JobListing.JobTitle like '%" + @term + "%') or (Organization.OrganizationName like '%" + @term + "%') or (Student.StudentGradeLevel like '%" + @term + "%') or (Student.StudentGPA like '%" + @term + "%') or (Student.HoursOfWorkPlaceExp like '%" + @term + "%') or (JobListing.JobDescription like '%" + @term + "%') or (JobListing.JobType like '%" + @term + "%'))"; // StudentOpportunity.DataBind(); // GridView1.DataBind(); // StudentOpportunity.SelectParameters.Clear(); //} protected void btnStudentView_Click(object sender, CommandEventArgs e) { String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString); int rowIndex = Convert.ToInt32(((sender as LinkButton).NamingContainer as GridViewRow).RowIndex); int applicationID = Convert.ToInt32(e.CommandArgument); Session["applicationID"] = applicationID.ToString(); //find student ID from logID sql.Open(); System.Data.SqlClient.SqlCommand findStudentID = new System.Data.SqlClient.SqlCommand(); findStudentID.Connection = sql; findStudentID.CommandText = "SELECT StudentEntityID FROM ApplicationRequest WHERE applicationID = " + Session["applicationID"]; System.Data.SqlClient.SqlDataReader IDreader = findStudentID.ExecuteReader(); //declare studentID session variable Session["studentID"] = 0; while (IDreader.Read()) { Session["studentID"] = IDreader.GetInt32(0); } sql.Close(); //get student info for selected student sql.Open(); System.Data.SqlClient.SqlCommand getStudentInfo = new System.Data.SqlClient.SqlCommand(); getStudentInfo.Connection = sql; getStudentInfo.CommandText = "SELECT CONCAT(FirstName,' ',LastName), StudentGradeLevel, StudentGPA, StudentSATScore, HoursOfWorkPlaceExp, StudentEntityID, StudentImage FROM Student WHERE StudentEntityID = " + Session["studentID"]; System.Data.SqlClient.SqlDataReader studentReader = getStudentInfo.ExecuteReader(); while (studentReader.Read()) { //fill labels in modal lblStudentName.Text = studentReader.GetString(0); lblGradeLevel.Text = "Grade Level: " + studentReader.GetString(1); lblGPA.Text = "GPA: " + studentReader.GetDouble(2); lblSATScore.Text = "SAT Score: " + studentReader.GetInt32(3); lblHoursWorked.Text = "WBL Hours Earned: " + studentReader.GetInt32(4); imgStudent.ImageUrl = studentReader.GetString(6); } ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openviewStudentModal();", true); }
private static Songs fillSongsFromSQLDataReader(SqlDataReader reader) { Songs allSongs = new Songs(); Song oneSong = new Song(); oneSong.TrackID = reader.GetString(0); oneSong.AlbumID = reader.GetString(1); oneSong.InterpretID = reader.GetString(2); oneSong.titel = reader.GetString(3); allSongs.Add(oneSong); return allSongs; }
public BusinessValue(string name) { mName = name; mDatabase.connect(); mReader = mDatabase.executeread("SELECT Name, Description FROM [dbo].[Project] WHERE BusinessValueName='" + mName + "'"); while (mReader.Read()) { mProjects.Add(new Project(mReader.GetString(0).ToString(), mReader.GetString(1).ToString(), mName)); } mDatabase.close(); }
private Author FillAuthor(SqlDataReader reader) { var author = new Author(); author.Id = reader.GetInt32(0); author.Name = reader.GetString(1); author.Email = reader.GetString(2); author.Password = reader.GetString(3); author.IsActive = reader.GetBoolean(4); author.DateCreated = reader.GetDateTime(5); return author; }
internal static Message Load(SqlDataReader reader) { var message = new Message { ConversationGroupId = reader.GetGuid(0), ConversationHandle = reader.GetGuid(1), MessageSequenceNumber = reader.GetInt64(2), ServiceName = reader.GetString(3), ServiceContractName = reader.GetString(4), MessageTypeName = reader.GetString(5), Body = reader.IsDBNull(7) ? new byte[0] : reader.GetSqlBytes(7).Buffer }; return message; }
/// <summary> /// 数据转查询实体 /// </summary> public static UserQueryInfo DataToModel(SqlDataReader rdr) { UserQueryInfo query = new UserQueryInfo(); if (!rdr.IsDBNull(0)) query.UserQueryID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) query.UserQueryName = rdr.GetString(1); if (!rdr.IsDBNull(2)) query.UserQueryURL = rdr.GetString(2); if (!rdr.IsDBNull(3)) query.UserQueryValue = rdr.GetString(3); if (!rdr.IsDBNull(4)) query.UserQueryLive = rdr.GetByte(4); if (!rdr.IsDBNull(5)) query.UserID = rdr.GetInt32(5); if (!rdr.IsDBNull(6)) query.ModifyDate = rdr.GetDateTime(6); return query; }
public HorarioAtencion crearObjetoHorarioAtencion(SqlDataReader resultado) { HorarioAtencion ha = new HorarioAtencion(); Medico me = new Medico(); me.Nombre = resultado.GetString(0); ha.Inicio = resultado.GetString(1); ha.Fin = resultado.GetString(2); ha.Consultorio = resultado.GetString(3); me.Id = resultado.GetInt32(4); ha.Id = resultado.GetInt32(5); ha.Medico = me; return ha; }
private Comment FillComment(SqlDataReader reader) { var comment = new Comment(); comment.Id = reader.GetInt32(0); comment.PostId = reader.GetInt32(1); comment.Name = reader.GetString(2); comment.Email = reader.GetValueOrDefault<string>(3); comment.Url = reader.GetValueOrDefault<string>(4); comment.Body = reader.GetString(5); comment.Status = (CommentStatus)reader.GetInt32(6); comment.DateCreated = reader.GetDateTime(7); return comment; }
/// <summary> /// 数据转第三方登录实体 /// </summary> public static OAuthInfo DataToModel(SqlDataReader rdr) { OAuthInfo oauth = new OAuthInfo(); if (!rdr.IsDBNull(0)) oauth.OAuthID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) oauth.OpenID = rdr.GetString(1); if (!rdr.IsDBNull(2)) oauth.AccessToken = rdr.GetString(2); if (!rdr.IsDBNull(3)) oauth.UserID = rdr.GetInt32(3); if (!rdr.IsDBNull(4)) oauth.OldUserID = rdr.GetInt32(4); if (!rdr.IsDBNull(5)) oauth.OAuthBound = rdr.GetByte(5); if (!rdr.IsDBNull(6)) oauth.OAuthFrom = rdr.GetString(6); if (!rdr.IsDBNull(7)) oauth.ModifyDate = rdr.GetDateTime(7); return oauth; }
/// <summary> /// 数据转专题实体 /// </summary> public static ZhuanTiInfo DataToModel(SqlDataReader rdr) { ZhuanTiInfo zhuanTi = new ZhuanTiInfo(); if (!rdr.IsDBNull(0)) zhuanTi.ZhuanTiID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) zhuanTi.ZhuanTiName = rdr.GetString(1); if (!rdr.IsDBNull(2)) zhuanTi.ZhuanTiImage = rdr.GetString(2); if (!rdr.IsDBNull(3)) zhuanTi.UserID = rdr.GetInt32(3); if (!rdr.IsDBNull(4)) zhuanTi.ZhuanTiLive = rdr.GetByte(4); if (!rdr.IsDBNull(5)) zhuanTi.Synchronize = rdr.GetByte(5); if (!rdr.IsDBNull(6)) zhuanTi.ModifyDate = rdr.GetDateTime(6); if (!rdr.IsDBNull(7)) zhuanTi.ZTID = rdr.GetInt32(7); return zhuanTi; }
/// <summary> /// /// </summary> public void Load(System.Data.SqlClient.SqlConnection connection) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.Connection = connection; cmd.CommandText = "SELECT appname, AccountID, deviceid, pushid, phonetype, status, createdatetime, PHONE_OS, PHONE_NAME, PHONE_MODEL, updatedatetime FROM MobileDeviceData WHERE "; System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); if (true == reader.Read()) { _appname = reader.GetString(0); _accountID = reader.GetString(1); _deviceid = reader.GetString(2); _pushid = reader.GetString(3); _phonetype = reader.GetString(4); _status = reader.GetBoolean(5); _createdatetime = reader.GetDateTime(6); _pHONE_OS = reader.GetString(7); _pHONE_NAME = reader.GetString(8); _pHONE_MODEL = reader.GetString(9); _updatedatetime = reader.GetDateTime(10); } reader.Close(); } }
SqlJobMetrics build_sql_job_metric_from_reader(SqlDataReader reader) { var metric = new SqlJobMetrics(); metric.job_name = reader.GetString(0); metric.message = reader.GetString(1); var job_outcome_key = reader.GetByte(2); metric.job_status = get_job_outcome_from_key(job_outcome_key); metric.last_run = reader.GetDateTime(3); metric.job_step = reader.GetInt16(4); return metric; }
protected override DomainObject LoadEntity(int Id, SqlDataReader res) { if (res.Read()) { bool userIsAdmin = res.GetBoolean(2); if (userIsAdmin) return _adminMapper.LoadUser(Id, res.GetString(1),res.GetString(3)); else return _nUserMapper.LoadUser(Id, res.GetString(1)); } else return null; }
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { rbl = (RadioButtonList)Login1.FindControl("RadioButtonList1"); System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["WSConnectionString"].ConnectionString); con.Open(); if (rbl.SelectedIndex == -1) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "Aad", "alert('请选择用户类型')", true); } else { string strSql = "select * from [User] where UserName='******' and password='******' and userid='" + rbl.SelectedItem.Value + "'"; System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(strSql, con); System.Data.SqlClient.SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { Session["username"] = dr.GetString(0);//Login1.UserName.ToString(); Session["userid"] = dr.GetString(2); if (Session["userid"].ToString() == "学工组" || Session["userid"].ToString() == "用人单位") { Session["remark"] = dr.GetString(3); } e.Authenticated = true;//通过验证 if (Session["userid"].ToString() == "学生") { Response.Redirect("~/u_student/Apply.aspx"); } if (Session["userid"].ToString() == "用人单位") { Response.Redirect("~/u_employer/ApplyReview.aspx"); } if (Session["userid"].ToString() == "学工组") { Response.Redirect("~/u_stuwg/StudentInfoMgr2.aspx"); } if (Session["userid"].ToString() == "资助中心") { Response.Redirect("~/u_fmc/WorkInfoMaintain.aspx"); } } else { e.Authenticated = false; } dr.Close(); con.Close(); } }
public string LoadMenu1(int CNMe, int level) { string result = string.Empty; string ConnectString = "server=(local)\\SQLEXPRESS;uid=sa;pwd=123;database=QuanLyCongVan"; System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(); conn.ConnectionString = ConnectString; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "SELECT * FROM [Menu] WHERE [CNMe] = " + CNMe.ToString(); cmd.Connection = conn; conn.Open(); System.Data.SqlClient.SqlDataReader rd = cmd.ExecuteReader(); if (!rd.HasRows) { return(result); } else { result = "<ul>"; while (rd.Read()) { result += "<li>" + rd.GetString(rd.GetOrdinal("TenCN")) + "</li>"; result += LoadMenu1(Convert.ToInt32(rd.GetInt32(rd.GetOrdinal("Ma"))), level + 1); } result += "</ul>"; conn.Close(); } return(result); }
protected void Button3_Click1(object sender, EventArgs e) { // Stopped here before class. Need to get the query result from the database (the business email) and store that as a variable to pass // to the client script start up String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString); sql.Open(); System.Data.SqlClient.SqlCommand approveScholarship = new System.Data.SqlClient.SqlCommand(); approveScholarship.Connection = sql; approveScholarship.CommandText = "SELECT EmailAddress FROM UserEntity where UserEntityID = " + Session["selectedjobID"]; System.Data.SqlClient.SqlDataReader reader = approveScholarship.ExecuteReader(); while (reader.Read()) { email = reader.GetString(0); } sql.Close(); string url = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority) + "%26argument=Number1"; string command = "mailto:" + email + "?subject=CommUp: Job Approval"; System.Diagnostics.Process.Start(command); //ClientScript.RegisterStartupScript(this.GetType(), "mailto", "parent.location='mailto:" + OpportunityActDec.email + "'", true); //Response.Redirect("~/OpportunityActDec.aspx"); }
/// <summary> /// Reads BBMenuLink and Param tables from database in form of XML /// </summary> public static String GetBBMenuLinkParamXML(String bbCode) { log4net.ILog log = PtaUtil.getLog4netLogger(typeof(PtaUtil).FullName + ".GetBBMenuLinkParamXML(): "); SqlConnection con = GetSqlConnection(); String sql = "SELECT * from BBMenuLink join Param " + " on BBMenuLink.BBoardCode = Param.BBoardCode and BBMenuLink.BBLinkPath = Param.BBLinkPath " + " where BBMenuLink.BBoardCode = @BBoardCode ORDER BY BBMenuLink.BBLinkPath, Param.ParamOrderCode for xml auto"; System.Data.SqlClient.SqlParameter param = new System.Data.SqlClient.SqlParameter("BBoardCode", bbCode); log.Info("sql: " + sql); System.Data.SqlClient.SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(PtaUtil.GetSqlConnection(), System.Data.CommandType.Text, sql, param); String xml = null; if (dr.HasRows) { xml = ""; while (dr.Read()) { xml += dr.GetString(0); } xml = xml.Replace("><", ">" + System.Environment.NewLine + "<"); } return(xml); }