protected void Page_Load(object sender, EventArgs e)
{
//Response.Write("用户名是" + Session["stuname"] + "密码是" + Session["stupwd"]);
//string sql = "select *from dri_user where user_id ='" + Session["stuname"] + "' and user_pwd = '" + Session["stupwd"] + "'";
//SqlCommand cmd = new SqlCommand(sql, user.getCon());
//SqlDataReader reader = cmd.ExecuteReader();
//while (reader.Read()) {
//}
User user = new global::User();
SqlConnection conn = user.getCon();
SqlDataAdapter sda = new SqlDataAdapter("select *from Dri_user where user_name = '" + Session["stuname"] + "'", conn);
DataSet Ds = new DataSet();
sda.Fill(Ds, "User_query");
//使用DataSet绑定时，必须同时指明DateMember
this.GridView1.DataSource = Ds;
this.GridView1.DataMember = "User_query";
//也可以直接用DataTable来绑定
this.GridView1.DataSource = Ds.Tables["User_query"];
GridView1.DataBind();
}
private void login(string username, string password)
{
OracleConnection conn;
//SqlConnection conn;
//SqlCommand comm;
OracleCommand comm;
OracleDataReader reader;
//SqlDataReader reader;
// Read the connection string from Web.config
string connectionString =
ConfigurationManager.ConnectionStrings[
"Dorknozzle"].ConnectionString;
// Initialize connection
conn = new OracleConnection(connectionString);
// Create command
comm = new OracleCommand(
"SELECT * FROM EMPLOYEE JOIN TAX ON EMPLOYEE.EMPLOYEEID = TAX.EMPLOYEEID where USERNAME= :UN and PASSWORD= :PW",
conn);
comm.Parameters.Add("UN", username);
comm.Parameters.Add("PW", password);
// Enclose database code in Try-Catch-Finally
try
{
// Open the connection
conn.Open();
// Execute the command
reader = comm.ExecuteReader();
if (reader != null && reader.HasRows)
{
reader.Read();
//showMessage(reader[0].ToString() + " " + reader[1].ToString());
showMessage(string.Format("Name: {0} {1}", reader["FIRSTNAME"], reader["LASTNAME"]));
User currUser = new global::User();
currUser.Firstname = reader["FIRSTNAME"].ToString();
currUser.Lastname = reader["LASTNAME"].ToString();
currUser.UserId = int.Parse(reader["EMPLOYEEID"].ToString());
currUser.TotalIncome = int.Parse(reader["TOTALINCOME"].ToString());
currUser.TotalTaxesPaid = int.Parse(reader["TOTALTAXESPAID"].ToString());
currUser.Contributions = int.Parse(reader["CONTRIBUTIONS"].ToString());
Session["User"] = currUser;
Response.Redirect(Session["RedirectPage"].ToString());
}
else
{
showMessage("Invalid username/password.");
}
reader.Close();
}
finally
{
// Close the connection
conn.Close();
}
}
public string AddAffiliation(string uId, string affiliationName)
{
User user = new global::User().GetUserById(int.Parse(uId));
Institute institute = new Institute().GetInstituteByName(affiliationName);
if (!user.Affiliations.Contains(institute))
{
new DBServices().InsertUserAffiliation(user.Id, institute.Id);
}
return("");
}
private User createUser()
{
User user = new global::User();
user.fullName = fname.Value;
user.companyName = comname.Value;
user.email = email.Value;
user.country = countryselect.Value;
user.password = password.Value;
user.userType = "Customer";
return(user);
}
public User Login(User user)
{//oahdpiubpiufpqiuwebcpiuqwbcpiasdbcpuy
SQLConexion _conexion = new SQLConexion();
List <SqlParameter> _Parametros = new List <SqlParameter>();
DataTableReader _dtr = null;
try
{
_conexion.Conectar(System.Configuration.ConfigurationManager.ConnectionStrings["MiBD"].ToString());
_Parametros.Add(new SqlParameter("@nick", user.Nick));
_Parametros.Add(new SqlParameter("@pass", user.Password));
_conexion.PrepararProcedimiento("[dbo].[sp_conf]", _Parametros);
_dtr = _conexion.EjecutarTableReader();
if (_dtr.HasRows)
{
_dtr.Read();
User _user = new global::User()
{
Id = long.Parse(_dtr["Id"].ToString()),
Name = _dtr["Nombre"].ToString(),
LastName = _dtr["LastName"].ToString(),
Nick = user.Nick,
Password = user.Password
};
_dtr.Close();
HttpContext.Current.Session["Identificador"] = _user.Id;
return(_user);
}
else
{
throw new Exception("User not found");
}
}
catch (Exception msg)
{
throw new Exception(msg.Message);
}
finally
{
_conexion.Desconectar();
_conexion = null;
_dtr = null;
}
//Aqui iría la logica a base de datos
//if (user.Nick == "andreiarias53" && user.Password == "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855")
//{
//Creamos session con el Id del Usuario
//}
//else
}
public string RemoveAffiliation(string uId, string affiliationName)
{
User user = new global::User().GetUserById(int.Parse(uId));
Institute institute = new Institute().GetInstituteByName(affiliationName);
foreach (var item in user.Affiliations)
{
if (item.Id == institute.Id)
{
new DBServices().RemoveUserAffiliation(user.Id, institute.Id);
return("");
}
}
return("");
}
//删除
protected void ImgBtnDelete_Click(object sender, ImageClickEventArgs e)
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].FindControl("cbisSelect");//查找每行中的CheckBox控件
if (cb.Checked)
{
string id = (GridView1.DataKeys[i].Value.ToString());
User user = new global::User();
if (user.deleteAll())
{
Response.Write("<script>alert('删除成功')</script>");
Response.Redirect("UserMS.aspx");
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
User user = new global::User();
SqlConnection conn = user.getCon();
SqlDataAdapter sda = new SqlDataAdapter("select *from Dri_car where car_num like '" + TextBox_car.Text + "%'", conn);
DataSet Ds = new DataSet();
sda.Fill(Ds, "Car_query");
//使用DataSet绑定时，必须同时指明DateMember
this.GridView_query.DataSource = Ds;
this.GridView_query.DataMember = "Car_query";
//也可以直接用DataTable来绑定
this.GridView_query.DataSource = Ds.Tables["Car_query"];
GridView_query.DataBind();
}
public User iniciarSesion(User Usuario)
{
SqlConexion _conexion = new SqlConexion();
List <SqlParameter> _Parametros = new List <SqlParameter>();
DataTableReader _dtr = null;
try
{
//Abrir conexion
_conexion.Conectar(System.Configuration.ConfigurationManager.ConnectionStrings["MiBD"].ToString());
// Se agregan parámetros a la lista List <SqlParameter>, con los valores para cada parametro que se obtienen de los atributos
// del objeto Pej.Objeto . Atributo_x
_Parametros.Add(new SqlParameter("@_Nick", Usuario.Nick));
_Parametros.Add(new SqlParameter("@_Password", Usuario.Password));
_conexion.PrepararProcedimiento("sp_LoginUser", _Parametros);
_dtr = _conexion.EjecutarTableReader();
if (_dtr.HasRows)
{
_dtr.Read();
User _user = new global::User()
{
Id_User = long.Parse(_dtr["Id_User"].ToString())
};
HttpContext.Current.Session["Identificador"] = _user.Id_User;
return(_user);
}
else
{
throw new Exception("User not found");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
_conexion.Desconectar();
_conexion = null;
_dtr = null;
}
}
//--------------------------------------------------------------------------
// Inserts a user to the database
// returns the created user from the database via login
//--------------------------------------------------------------------------
public string GetUserArticles(string uId)
{
try
{
User user = new global::User().GetUserById(int.Parse(uId));
foreach (var item in user.Articles)
{
item.GetFullInfo();
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(user.Articles.ToArray()));
}
catch (Exception ex)
{
LogManager.Report(ex);
return(ex.ToString());
}
}
//--------------------------------------------------------------------------
//--------------------------------------------------------------------------
public string FindUserAutomatically(string name, string email)
{
try
{
//User user = js.Deserialize<User>(userString);
User user = new global::User().GetUserByEmail(email);
//user.FixNulls();
//user.InsertUserToDatabase();
//user = user.GetUserByEmail(user.Email);
// user.GetFullInfo();
//div_res.InnerText = py.GetPath();
//div_res.InnerHtml = py.Run_cmd("InsertUser.py", "Noga alon");
ScholarDBServices sdbs = new ScholarDBServices();
ScholarUser sUser = sdbs.GetUserByName(user.Name);
if (sUser == null)
{
PythonServices py = new PythonServices();
py.Run_cmd("InsertUser.py", user.Name);
sUser = sdbs.GetUserByName(user.Name);
}
sdbs.IntegrateIntoUser(sUser.Id, user.Id);
user = user.GetUserById(user.Id);
//string res = user.InsertUserToDatabase().ToString();
user = user.Relog();
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(user));
// PythonServices py = new PythonServices();
// User user = new global::User("amit", " ", "rechavi", null);
}
catch (Exception ex)
{
LogManager.Report(ex);
return(ex.ToString());
}
}
public virtual global::System.Threading.Tasks.Task <global::User> GetUser(global::User request, grpc::ServerCallContext context)
{
throw new grpc::RpcException(new grpc::Status(grpc::StatusCode.Unimplemented, ""));
}
public virtual grpc::AsyncUnaryCall <global::User> GetUserAsync(global::User request, grpc::CallOptions options)
{
return(CallInvoker.AsyncUnaryCall(__Method_GetUser, null, options, request));
}
public virtual grpc::AsyncUnaryCall <global::User> GetUserAsync(global::User request, grpc::Metadata headers = null, global::System.DateTime?deadline = null, global::System.Threading.CancellationToken cancellationToken = default(global::System.Threading.CancellationToken))
{
return(GetUserAsync(request, new grpc::CallOptions(headers, deadline, cancellationToken)));
}
public virtual global::User GetUser(global::User request, grpc::CallOptions options)
{
return(CallInvoker.BlockingUnaryCall(__Method_GetUser, null, options, request));
}
public virtual global::Response setUser(global::User request, grpc::Metadata headers = null, global::System.DateTime?deadline = null, global::System.Threading.CancellationToken cancellationToken = default(global::System.Threading.CancellationToken))
{
return(setUser(request, new grpc::CallOptions(headers, deadline, cancellationToken)));
}
public User Login(User user)
{
SqlConexion _conexion = new SqlConexion();
List <SqlParameter> _Parametros = new List <SqlParameter>();
DataTableReader _dtr = null;
try
{
//Abrir conexion
_conexion.Conectar(System.Configuration.ConfigurationManager.ConnectionStrings["MiBD"].ToString());
// Se agregan parámetros a la lista List <SqlParameter>, con los valores para cada parametro que se obtienen de los atributos
// del objeto Pej.Objeto . Atributo_x
_Parametros.Add(new SqlParameter("@_Nick", user.Nick));
_Parametros.Add(new SqlParameter("@_Password", user.Password));
_conexion.PrepararProcedimiento("sp_LoginUser", _Parametros);
_dtr = _conexion.EjecutarTableReader();
if (_dtr.HasRows)
{
_dtr.Read();
User _user = new global::User()
{
Id = long.Parse(_dtr["Id_User"].ToString()),
Name = _dtr["Name"].ToString(),
LastName = _dtr["LastName"].ToString(),
};
HttpContext.Current.Session["Identificador"] = _user.Id;
return(_user);
}
else
{
throw new Exception("User not found");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally {
_conexion.Desconectar();
_conexion = null;
_dtr = null;
}
// // Aqui iria la logica de base de datos//
// if (user.Nick == "luis" && user.Password == "123")
// {
// User _user = new global::User()
// {
// Id = 1001,
// Name = "Luis Zanellita",
// LastName = "Contreritas",
// };
// //Crear sesion con el id del usuario
// HttpContext.Current.Session["Identificador"] = _user.Id;
// return _user;
// }
// else
// throw new Exception("User not found!!! = (");
//}
//[WebMethod(EnableSession = true)]
//public User Registro(User user)
//{
// // Aqui iria la logica de base de datos//
// User _user = new global::User()
// {
// Id = 1,
// Nick = user.Nick,
// LastName = user.LastName,
// Name = user.Name,
// Password = user.Password,
// };
// //Crear sesion con el id del usuario
// HttpContext.Current.Session["Identificador"] = _user.Id;
// return _user;
}
private void SetTasks(long id)
{
var myTasks = _projectService.MyTasks(id);
var todaysDate = DateTime.Today.Date;
if (myTasks != null)
{
var completedItems = new List <ListItem>();
// completed tasks
var completedId = (int)TaskStatus.Done;
var completedTasksList = myTasks.Where(x => x.status == completedId).ToList();
if (completedTasksList.Count > 0)
{
foreach (var task in completedTasksList)
{
var due = DateTime.Today;
if (task?.due_date != null)
{
due = task.due_date.Value.Date;
}
var days = GetRemainingDays(due, todaysDate);
if (task != null)
{
if (days >= 0)
{
completedItems.Add(new ListItem(task.body));
}
}
completedTasks.Visible = true;
}
}
else
{
noComplete.Visible = true;
}
// In-progress
var inProgressTasks = myTasks.Where(x => x.status != (int)TaskStatus.Done).ToList();
if (inProgressTasks.Count > 0)
{
var inprogressItems = new List <ListItem>();
foreach (var task in inProgressTasks)
{
var due = DateTime.Today;
if (task?.due_date != null)
{
due = task.due_date.Value.Date;
}
var days = GetRemainingDays(due, todaysDate);
if (task != null)
{
if (days < 0)
{
var listItem = new ListItem();
listItem.Text = "NB: " + task.body.PadLeft(20).ToUpper() + " # " + (days * -1).ToString().ToUpper() + " DAYS OVERDUE.";
listItem.Attributes.Add("style", "color:red;");
completedItems.Add(listItem);
}
else
{
inprogressItems.Add(new ListItem(task.body.PadLeft(20) + " # " + days + " days left."));
}
}
}
completedTasks.DataSource = completedItems;;
completedTasks.DataBind();
inProgress.DataSource = inprogressItems;
inProgress.DataBind();
inProgress.Visible = true;
}
else
{
lblNoTask.Visible = true;
}
// Assigned Tasks
var statsId = (int)TaskStatus.Assigned;
var assigned = myTasks.Select(x => x).Where(x => x.status == statsId).ToList();
if (assigned.Count > 0)
{
var items = new List <ListItem>();
foreach (var task in assigned)
{
var userAssigned = new global::User();
if (task.assigned_to != null)
{
userAssigned = _projectService.GetUserById(task.assigned_to.Value);
}
if (userAssigned.id != 0)
{
items.Add(new ListItem(task.body + " # Assignee: " + userAssigned.name + " " + userAssigned.surname, task.id.ToString()));
}
else
{
items.Add(new ListItem(task.body + " # Not Assigned"));
}
}
lstAssignedTasks.DataSource = items;
lstAssignedTasks.DataBind();
lstAssignedTasks.Visible = true;
}
else
{
lblWarning.Visible = true;
}
myTasksList.Visible = true;
var tasksList = myTasks.Where(x => x.status == (int)TaskStatus.Assigned || x.status == (int)TaskStatus.NotAssigned).OrderByDescending(x => x.created_at).Select(y => y.body).ToList();
var stringbuild = new StringBuilder();
var count = 0;
if (tasksList.Count < 1)
{
myTasksList.Visible = false;
taskError.Visible = true;
}
else
{
foreach (var task in tasksList)
{
count++;
stringbuild.Append(count + ". " + task + Environment.NewLine);
}
myTasksList.Text = Convert.ToString(stringbuild);
}
//SetTaskProcess(inProgressTasks);
//inProgress.DataBind();
}
}
//--------------------------------------------------------------------------
// Inserts a user to the database
// returns the created user from the database via login
//--------------------------------------------------------------------------
public string UpdateArticle(string uId, string aId, string title, string link, string[] authors)
{
try
{
Article article = new Article().GetArticleById(int.Parse(aId));
if (article == null)
{
article = new Article(-1, title, link);
}
else
{
article.Title = title;
article.Link = link;
article.GetFullInfo();
}
List <User> users = new List <global::User>();
for (int i = 0; i < authors.Length; i++)
{
string[] name = authors[i].Trim().Split(' ');
string fName = name[0];
string mName = string.Empty;
string lName = string.Empty;
if (name.Length > 2)
{
mName = name[1];
lName = name[2];
}
else if (name.Length == 2)
{
lName = name[1];
}
else
{
continue;
}
User author = new DBServices().GetUserByName(fName, mName, lName);
if (author == null)
{
author = new User(fName, mName, lName, article);
author.InsertAuthor();
author = new DBServices().GetUserByName(fName, mName, lName);
}
users.Add(author);
}
if (article.Id != -1)
{
foreach (var item in article.Users)
{
if (!users.Contains(item) && item.Id != int.Parse(uId))
{
article.RemoveAuthor(item.Id);
}
}
}
//User user = js.Deserialize<User>(userString);
//string res = user.InsertUserToDatabase().ToString();
//user = user.Relog();
bool userIsAuthor = false;
foreach (var item in users)
{
if (item.Id == int.Parse(uId))
{
userIsAuthor = true;
}
}
if (!userIsAuthor)
{
users.Add(new global::User().GetUserById(int.Parse(uId)));
}
article.UpdateUsers(users);
new DBServices().FullArticleInsert(article);
User user = new global::User().GetUserById(int.Parse(uId));
user.GetFullInfo();
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(user));
}
catch (Exception ex)
{
LogManager.Report(ex, "UpdateArticle method in Ajax Services",
"aId=" + aId,
"uId=" + uId,
"uId=" + uId,
"title=" + title,
"link= " + link);
return(ex.ToString());
}
}
