/// <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);
}
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>
/// 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);
}
