private void OnChangeRoleID()
{
try
{
LoginView2 logView2 = new LoginView2();
if (DialogResult.OK == logView2.ShowDialog())
{
string tempUserName = "";
int tempRoleID = logView2.GetLoginRole(ref tempUserName);
if (tempRoleID < 1)
{
return;
}
this.roleID = tempRoleID;
this.userName = tempUserName;
this.labelUser.Text = "当前用户：" + this.userName;
foreach (BaseChildView childView in childViews)
{
childView.ChangeRoleID(this.roleID);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
protected void Button2_Click(object sender, EventArgs e)
{
//var Label1 = (Label)LoginView2.FindControl("Label1");
//var RadioButtonList1 = (RadioButtonList)LoginView2.FindControl("RadioButtonList1");
var TextBox2 = (TextBox)LoginView2.FindControl("TextBox2");
String uname = User.Identity.Name;
var poza = Request.Params["id"];
String text = TextBox2.Text;
String query = "INSERT INTO comentarii (poza,text,username) VALUES(@poza,@text,@uname) ";
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.MDF;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("text", text);
sql.Parameters.AddWithValue("uname", uname);
sql.Parameters.AddWithValue("poza", poza);
sql.ExecuteNonQuery();
con.Close();
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
catch
{
var Label1 = (Label)LoginView2.FindControl("Label1");
Label1.Text = "Eroare";
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
TextBox tb1 = (TextBox)LoginView2.FindControl("TextBox1");
DropDownList dl1 = (DropDownList)LoginView2.FindControl("DropDownList1");
tb1.Text = dl1.SelectedValue;
}
protected void deleteCom(object sender, EventArgs e)
{
var Label1 = (Label)LoginView2.FindControl("Label1");
Button btn = (Button)sender;
var comId = btn.ValidationGroup;
String idcom = comId;
String uname2 = User.Identity.Name;
String query = "DELETE FROM comentarii WHERE id_comentariu=@idcom ";
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.MDF;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("idcom", idcom);
sql.ExecuteNonQuery();
con.Close();
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
catch
{
Label1.Text = "Eroare";
}
}
private void ShowLoginView2_Click(object sender, RoutedEventArgs e)
{
var view = new LoginView2();
view.Owner = Application.Current.MainWindow;
view.Show();
}
protected void Button3_Click(object sender, EventArgs e)
{
DateTime now = DateTime.Now;
var Label4 = (Label)LoginView2.FindControl("Label4");
var TextBox2 = (TextBox)LoginView2.FindControl("TextBox2");
String uname = User.Identity.Name;
String gid = Request.Params["gid"];
String mesaj = TextBox2.Text;
String query = "INSERT INTO postari (autor,mesaj,data,grup_id) VALUES (@uname,@mesaj,@data,@gid) ";
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.MDF;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("uname", uname);
sql.Parameters.AddWithValue("mesaj", mesaj);
sql.Parameters.AddWithValue("data", now);
sql.Parameters.AddWithValue("gid", gid);
sql.ExecuteNonQuery();
Label4.Text = "Succes";
Page.Response.Redirect(Page.Request.Url.ToString(), true);
con.Close();
}
catch (SqlException err)
{
Label4.Text = "Eroare" + err.Message;
}
}
protected void Button2_Click1(object sender, EventArgs e)
{
var Label1 = (Label)LoginView2.FindControl("Label1");
String uname = User.Identity.Name;
String uname2 = Request.Params["uname"];
String query = "INSERT INTO cereriprietenie VALUES (@uname1,@uname2) ";
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.MDF;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("uname1", uname);
sql.Parameters.AddWithValue("uname2", uname2);
sql.ExecuteNonQuery();
Label1.Text = "Succes";
Page.Response.Redirect(Page.Request.Url.ToString(), true);
con.Close();
}
catch
{
Label1.Text = "Eroare";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack && User.Identity.IsAuthenticated)
{
var username = User.Identity.Name;
var SqlDataSource1 = (SqlDataSource)LoginView2.FindControl("SqlDataSource1");
var SqlDataSource2 = (SqlDataSource)LoginView2.FindControl("SqlDataSource2");
var SqlDataSource3 = (SqlDataSource)LoginView2.FindControl("SqlDataSource3");
var SqlDataSource4 = (SqlDataSource)LoginView2.FindControl("SqlDataSource4");
var SqlDataSource5 = (SqlDataSource)LoginView2.FindControl("SqlDataSource5");
SqlDataSource1.SelectCommand = "SELECT [user1] FROM [cereriprietenie] where user2=@param";
SqlDataSource1.SelectParameters.Add("param", username);
SqlDataSource1.DataBind();
SqlDataSource2.SelectCommand = "SELECT [user2],[friendship_id] FROM [prietenii] WHERE user1=@param";
SqlDataSource2.SelectParameters.Add("param", username);
SqlDataSource2.DataBind();
SqlDataSource3.SelectCommand = "SELECT [numealbum] FROM [albume] where username=@param";
SqlDataSource3.SelectParameters.Add("param", username);
SqlDataSource3.DataBind();
SqlDataSource4.SelectCommand = "SELECT [user1],[friendship_id] FROM [prietenii] WHERE user2=@param";
SqlDataSource4.SelectParameters.Add("param", username);
SqlDataSource4.DataBind();
SqlDataSource5.SelectCommand = "SELECT [userul],[mesaj],[id] FROM [notificariadmin] WHERE userul=@param";
SqlDataSource5.SelectParameters.Add("param", username);
SqlDataSource5.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
var TextBox1 = (TextBox)LoginView2.FindControl("TextBox1");
var TextBox2 = (TextBox)LoginView2.FindControl("TextBox2");
String mesaj = TextBox2.Text;
String user = TextBox1.Text;
String query = "INSERT INTO notificariadmin (userul,mesaj) VALUES(@use,@mes) ";
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.MDF;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("use", user);
sql.Parameters.AddWithValue("mes", mesaj);
sql.ExecuteNonQuery();
con.Close();
var Label1 = (Label)LoginView2.FindControl("Label1");
Label1.Text = "Succes";
}
catch
{
var Label1 = (Label)LoginView2.FindControl("Label1");
Label1.Text = "Eroare";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
var TextBox2 = (TextBox)LoginView2.FindControl("TextBox2");
var Label1 = (Label)LoginView2.FindControl("Label1");
String uname = User.Identity.Name;
String album = TextBox2.Text;
String query = "INSERT INTO albume VALUES (@uname,@numealbum) ";
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("numealbum", album);
sql.Parameters.AddWithValue("uname", uname);
sql.ExecuteNonQuery();
Label1.Text = "Succes";
con.Close();
}
catch
{
Label1.Text = "Eroare";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
var Label1 = (Label)LoginView2.FindControl("Label1");
var RadioButtonList1 = (RadioButtonList)LoginView2.FindControl("RadioButtonList1");
String uname = User.Identity.Name;
String nouisan = RadioButtonList1.SelectedValue;
String query = "UPDATE [vw_aspnet_Users] SET [IsAnonymous]=@nouisan WHERE [UserName]=@uname ";
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("nouisan", nouisan);
sql.Parameters.AddWithValue("uname", uname);
sql.ExecuteNonQuery();
Label1.Text = "Succes";
con.Close();
}
catch
{
Label1.Text = "Eroare";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
var Label2 = (Label)LoginView2.FindControl("Label2");
String uname = User.Identity.Name;
String gid = Request.Params["gid"];
String query = "INSERT INTO apartine VALUES (@uname,@gid) ";
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.MDF;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("uname", uname);
sql.Parameters.AddWithValue("gid", gid);
sql.ExecuteNonQuery();
Label2.Text = "Succes";
Page.Response.Redirect(Page.Request.Url.ToString(), true);
con.Close();
}
catch (SqlException err)
{
Label2.Text = "Eroare" + err.Message;
}
}
protected void SaveRecipe_Click(object sender, EventArgs e)
{
NutritionEntities4 bob = new NutritionEntities4();
UserFunctions.addRecipe(bob);
Label lbl = (Label)LoginView2.FindControl("SavedMessage");
lbl.Text = "Recipe has been saved to your account!";
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList dl1 = (DropDownList)LoginView2.FindControl("DropDownList1");
TextBox tb1 = (TextBox)LoginView2.FindControl("TextBox1");
tb1.Text = dl1.SelectedValue;
Response.Redirect("Mesaje_new.aspx?to=" + dl1.SelectedValue);
return;
}
protected void Page_Load(object sender, EventArgs e)
{
var Label1 = (Label)LoginView2.FindControl("Label1");
var SqlDataSource1 = (SqlDataSource)LoginView2.FindControl("SqlDataSource1");
Label1.Text = Request.Params["numealbum"];
SqlDataSource1.SelectCommand = "SELECT [id] FROM [poza] where [album]=@param";
SqlDataSource1.SelectParameters.Add("param", Request.Params["numealbum"]);
SqlDataSource1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack && User.Identity.IsAuthenticated)
{
var username = User.Identity.Name;
var SqlDataSource3 = (SqlDataSource)LoginView2.FindControl("SqlDataSource3");
SqlDataSource3.SelectCommand = "SELECT [numealbum] FROM [albume] where username=@param";
SqlDataSource3.SelectParameters.Add("param", username);
SqlDataSource3.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (HttpContext.Current.User.Identity.IsAuthenticated)
{
if (LoginView2.FindControl("HyperLinkProfil") != null)
{
(LoginView2.FindControl("HyperLinkProfil") as HyperLink).NavigateUrl = "~/Profil.aspx?username=" + Profile.UserName;
}
}
}
}
protected void Button1_Click(object sender = null, EventArgs e = null)
{
TextBox tb1 = (TextBox)LoginView2.FindControl("TextBox1");
TextBox tb2 = (TextBox)LoginView2.FindControl("TextBox2");
SqlDataSource ds6 = (SqlDataSource)LoginView2.FindControl("SqlDataSourceMesaje");
Literal raspuns_user = (Literal)LoginView2.FindControl("UserExista");
if (tb1.Text == null || tb1.Text == "") //n-a introdus niciun user, caut toate mesajele userului curent ce contin tb2.text
{
ds6.SelectCommand = "SELECT DISTINCT Conversatii.mesaj, Conversatii.citit, Conversatii.data, (SELECT UserName FROM aspnet_Users WHERE (UserId = Conversatii.cod_sender)) AS senderN, (SELECT UserName FROM aspnet_Users AS aspnet_Users_2 WHERE (UserId = Conversatii.cod_receiver)) AS receiverN FROM Conversatii INNER JOIN aspnet_Users AS aspnet_Users_1 ON (Conversatii.cod_sender = aspnet_Users_1.UserId OR Conversatii.cod_receiver = aspnet_Users_1.UserId) and (Conversatii.cod_sender = '" + Membership.GetUser().ProviderUserKey.ToString() + "' or Conversatii.cod_receiver = '" + Membership.GetUser().ProviderUserKey.ToString() + "' ) where mesaj like '%" + tb2.Text + "%' order by data desc";
}
else //a fost introdus un nume de utilizator
{
string nume_user2 = tb1.Text, cod_user2 = "";
//caut codul userului 2
try
{
SqlConnection connection = new SqlConnection();
connection.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.mdf;Integrated Security=True;User Instance=True";
connection.Open();
SqlCommand command = new SqlCommand("Select UserId from aspnet_Users where LoweredUserName = LOWER(@user2);", connection);
command.Parameters.AddWithValue("user2", nume_user2);
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
cod_user2 = dr[0].ToString();
//raspuns_user.Text = "userul exista: " + cod_user2;
}
dr.Close();
connection.Close();
}
catch (NullReferenceException ex)
{
raspuns_user.Text = ex.Message;
}
if (cod_user2 != "")
{
ds6.SelectCommand = "SELECT DISTINCT Conversatii.mesaj, Conversatii.citit, Conversatii.data, (SELECT UserName FROM aspnet_Users WHERE (UserId = Conversatii.cod_sender)) AS senderN, (SELECT UserName FROM aspnet_Users AS aspnet_Users_2 WHERE (UserId = Conversatii.cod_receiver)) AS receiverN FROM Conversatii INNER JOIN aspnet_Users AS aspnet_Users_1 ON (Conversatii.cod_sender = aspnet_Users_1.UserId OR Conversatii.cod_receiver = aspnet_Users_1.UserId) and (Conversatii.cod_sender = '" + Membership.GetUser().ProviderUserKey.ToString() + "' and Conversatii.cod_receiver = '" + cod_user2 + "') or (Conversatii.cod_sender = '" + cod_user2 + "' and Conversatii.cod_receiver = '" + Membership.GetUser().ProviderUserKey.ToString() + "' ) where mesaj like '%" + tb2.Text + "%' order by data desc";
}
else
{
raspuns_user.Text = "Userul introdus nu exista";
ds6.SelectCommand = "";
}
}
//ds6.SelectCommand = "SELECT DISTINCT Conversatii.mesaj, Conversatii.citit, Conversatii.data, (SELECT UserName FROM aspnet_Users WHERE (UserId = Conversatii.cod_sender)) AS senderN, (SELECT UserName FROM aspnet_Users AS aspnet_Users_2 WHERE (UserId = Conversatii.cod_receiver)) AS receiverN FROM Conversatii INNER JOIN aspnet_Users AS aspnet_Users_1 ON (Conversatii.cod_sender = aspnet_Users_1.UserId OR Conversatii.cod_receiver = aspnet_Users_1.UserId) and (((SELECT UserName FROM aspnet_Users WHERE (UserId = Conversatii.cod_sender)) = '" + user_send + "' and (SELECT UserName FROM aspnet_Users AS aspnet_Users_2 WHERE (UserId = Conversatii.cod_receiver)) = '" + user_recv + "') or ((SELECT UserName FROM aspnet_Users WHERE (UserId = Conversatii.cod_sender)) = '" + user_recv + "' and (SELECT UserName FROM aspnet_Users AS aspnet_Users_2 WHERE (UserId = Conversatii.cod_receiver)) = '" + user_send + "')) order by data desc";
Session["select_cmd"] = ds6.SelectCommand;
}
protected void Button3_Click(object sender, EventArgs e)
{
var q = Request.Params["uid"];
String username = "";
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand("SELECT [UserName] FROM [vw_aspnet_Users] WHERE [UserId]=@id and [isAnonymous]=0", con);
try
{
sql.Parameters.AddWithValue("id", q);
var reader = sql.ExecuteReader();
if (reader.Read())
{
username = (string)reader["UserName"];
}
}
catch
{
return;
}
DateTime now = DateTime.Now;
var Label2 = (Label)LoginView2.FindControl("Label2");
var TextBox2 = (TextBox)LoginView2.FindControl("TextBox2");
String uname = User.Identity.Name;
String mesaj = TextBox2.Text;
String query = "INSERT INTO postari (autor,mesaj,data,userul) VALUES (@uname,@mesaj,@data,@uid) ";
con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.MDF;Integrated Security=True;User Instance=True");
con.Open();
sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("uname", uname);
sql.Parameters.AddWithValue("mesaj", mesaj);
sql.Parameters.AddWithValue("data", now);
sql.Parameters.AddWithValue("uid", username);
sql.ExecuteNonQuery();
Label2.Text = "Succes";
Page.Response.Redirect(Page.Request.Url.ToString(), true);
con.Close();
}
catch (SqlException err)
{
Label2.Text = "Eroare" + err.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
anm_Utility ut = new anm_Utility();
DateTime data = DateTime.Now;
currentDate.Text = string.Format("{0}", data.ToString("f", System.Globalization.CultureInfo.CurrentCulture));
if (LoginView2.FindControl("HLreg") == null)
{
HyperLink myp = (HyperLink)LoginView2.FindControl("Myp");
myp.NavigateUrl = Page.Request.ApplicationPath.ToString() + "/MyProfile.aspx";
}
else
{
HyperLink hlreg = (HyperLink)LoginView2.FindControl("HLreg");
hlreg.NavigateUrl = Page.Request.Url.AbsolutePath.ToString() + "?p=NewUser";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (HttpContext.Current.User != null && HttpContext.Current.User.Identity.IsAuthenticated)
{
user_send = Membership.GetUser().UserName.ToString();
SqlDataSource ds2 = (SqlDataSource)LoginView2.FindControl("SqlDataSourceNeCitite");
SqlDataSource ds4 = (SqlDataSource)LoginView2.FindControl("SqlDataSourceCitite");
//ds2.SelectCommand = "SELECT aspnet_Users.UserName as UserN, COUNT(*) AS nrC FROM aspnet_Users INNER JOIN Conversatii ON aspnet_Users.UserId = Conversatii.cod_receiver and Conversatii.cod_sender = '" + Membership.GetUser().ProviderUserKey.ToString() + "' GROUP BY aspnet_Users.UserName;";
//lista conversatii cu msg necitite
//ds2.SelectCommand = "SELECT aspnet_Users.UserName as UserN, count(*) AS nrC, Min(Conversatii.citit) as citit FROM aspnet_Users INNER JOIN Conversatii ON (aspnet_Users.UserId = Conversatii.cod_receiver OR aspnet_Users.UserId = Conversatii.cod_sender) and (Conversatii.cod_sender = '" + Membership.GetUser().ProviderUserKey.ToString() + "' OR Conversatii.cod_receiver = '" + Membership.GetUser().ProviderUserKey.ToString() + "') GROUP BY aspnet_Users.UserName HAVING Min(Conversatii.citit) = 0";
//lista conversatii vechi
//ds4.SelectCommand = "SELECT aspnet_Users.UserName as UserN, count(*) AS nrC, Min(Conversatii.citit) as citit FROM aspnet_Users INNER JOIN Conversatii ON (aspnet_Users.UserId = Conversatii.cod_receiver OR aspnet_Users.UserId = Conversatii.cod_sender) and (Conversatii.cod_sender = '" + Membership.GetUser().ProviderUserKey.ToString() + "' OR Conversatii.cod_receiver = '" + Membership.GetUser().ProviderUserKey.ToString() + "') GROUP BY aspnet_Users.UserName HAVING Min(Conversatii.citit) = 1";
string userk = Membership.GetUser().ProviderUserKey.ToString();
//ds2.SelectCommand = "SELECT aspnet_Users.UserName as UserN, COUNT(*) AS nrC FROM aspnet_Users INNER JOIN Conversatii ON aspnet_Users.UserId = Conversatii.cod_receiver and Conversatii.cod_sender = '" + Membership.GetUser().ProviderUserKey.ToString() + "' GROUP BY aspnet_Users.UserName;";
//ds2.SelectCommand = "SELECT aspnet_Users.UserName as UserN, count(*) AS nrC, Min(Conversatii.citit) as citit FROM aspnet_Users INNER JOIN Conversatii ON (aspnet_Users.UserId = Conversatii.cod_receiver OR aspnet_Users.UserId = Conversatii.cod_sender) and (Conversatii.cod_sender <> Conversatii.cod_receiver) and (Conversatii.cod_sender = '" + Membership.GetUser().ProviderUserKey.ToString() + "' OR Conversatii.cod_receiver = '" + Membership.GetUser().ProviderUserKey.ToString() + "') GROUP BY aspnet_Users.UserName HAVING Min(Conversatii.citit) = 0";
ds2.SelectCommand = "select (select UserName from aspnet_Users where UserId = (case cod_sender when '" + userk + "' then cod_receiver else cod_sender end) ) as userN, count(case citit when 0 then 1 else null end) as nrC, count(*) as nrC2 from Conversatii where (cod_sender = '" + userk + "' and cod_receiver <> cod_sender) or (cod_receiver = '" + userk + "' and cod_sender <> cod_receiver) group by (case cod_sender when '" + userk + "' then cod_receiver else cod_sender end) having min(citit) = 0";
//ds2.SelectParameters["" + userk + ""].DefaultValue = userk;
//ds4.SelectCommand = "SELECT aspnet_Users.UserName as UserN, count(*) AS nrC, Min(Conversatii.citit) as citit FROM aspnet_Users INNER JOIN Conversatii ON (aspnet_Users.UserId = Conversatii.cod_receiver OR aspnet_Users.UserId = Conversatii.cod_sender) and (Conversatii.cod_sender <> Conversatii.cod_receiver) and (Conversatii.cod_sender = '" + Membership.GetUser().ProviderUserKey.ToString() + "' OR Conversatii.cod_receiver = '" + Membership.GetUser().ProviderUserKey.ToString() + "') GROUP BY aspnet_Users.UserName HAVING Min(Conversatii.citit) = 1";
ds4.SelectCommand = "select (select UserName from aspnet_Users where UserId = (case cod_sender when '" + userk + "' then cod_receiver else cod_sender end) ) as userN, count(case citit when 1 then 1 else null end) as nrC, count(*) as nrC2 from Conversatii where (cod_sender = '" + userk + "' and cod_receiver <> cod_sender) or (cod_receiver = '" + userk + "' and cod_sender <> cod_receiver) group by (case cod_sender when '" + userk + "' then cod_receiver else cod_sender end) having min(citit) = 1";
//ds4.SelectParameters["@userkey"].DefaultValue = Membership.GetUser().ProviderUserKey.ToString();
}
}
//pt lista useri din campul to:
SqlDataSource ds8 = (SqlDataSource)LoginView2.FindControl("SqlDataSource_userlist");
ds8.SelectCommand = "SELECT DISTINCT [UserName] FROM [aspnet_Users] where UserName <> '" + Membership.GetUser().UserName + "' and ApplicationId = '0657f582-1791-422d-872a-5a7ae8663066';";
//sa pastreze queryu cand schimb pagina daca rezultatul are mai mult de o pagina
SqlDataSource ds6 = (SqlDataSource)LoginView2.FindControl("SqlDataSourceMesaje");
if (Session["select_cmd"] != null && ds6.SelectCommand == "")
{
ds6.SelectCommand = Session["select_cmd"].ToString();
//http://stackoverflow.com/questions/17582930/aspsqldatasource-selectcommand-property-does-not-persist-when-paging
//not recommended: unsafe
}
}
protected void acceptClick(object sender, EventArgs e)
{
var Label1 = (Label)LoginView2.FindControl("Label1");
Button btn = (Button)sender;
var userId = btn.ValidationGroup;
String uname = userId;
String uname2 = User.Identity.Name;
DateTime now = DateTime.Now;
String query = "DELETE FROM cereriprietenie WHERE user1=@uname1 and user2=@uname2 ";
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.MDF;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("uname1", uname);
sql.Parameters.AddWithValue("uname2", uname2);
sql.ExecuteNonQuery();
con.Close();
String query2 = "INSERT INTO prietenii (user1,user2,data) VALUES(@uname1,@uname2,@data)";
SqlConnection con2 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.MDF;Integrated Security=True;User Instance=True");
con2.Open();
SqlCommand sql2 = new SqlCommand(query2, con2);
try
{
sql2.Parameters.AddWithValue("uname1", uname);
sql2.Parameters.AddWithValue("uname2", uname2);
sql2.Parameters.AddWithValue("data", now);
sql2.ExecuteNonQuery();
con2.Close();
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
catch
{
Label1.Text = "eroare";
}
}
catch
{
Label1.Text = "Eroare";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack && User.Identity.IsAuthenticated)
{
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
var Label2 = (Label)LoginView2.FindControl("Label2");
var id = Request.Params["id"];
var Image1 = (Image)LoginView2.FindControl("Image1");
var SqlDataSource2 = (SqlDataSource)LoginView2.FindControl("SqlDataSource2");
var LoginView4 = (LoginView)LoginView2.FindControl("LoginView4");
var stergepoza = (Button)LoginView4.FindControl("stergePoza");
SqlDataSource2.SelectCommand = "SELECT * FROM comentarii WHERE poza=@id";
SqlDataSource2.SelectParameters.Add("id", id);
SqlDataSource2.DataBind();
Image1.ImageUrl = "/WebSite1/image.aspx/?id=" + Request.Params["id"];
//pt butonul sterge poza
String uname2 = User.Identity.Name;
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand("SELECT [uname] as uname FROM [poza] WHERE [id]=@id", con);
try
{
sql.Parameters.AddWithValue("id", id);
var reader = sql.ExecuteReader();
if (reader.Read())
{
String uname3 = (String)reader["uname"];
Label2.Text = uname3;
if (uname2.CompareTo(uname3) == 0)
{
stergepoza.Visible = true;
}
}
}
catch
{
;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//asd.InnerText = "ASDASDASD";
//asd.InnerText = getKeyFromUsername("daniela_ong");
if (!Page.IsPostBack)
{
if (HttpContext.Current.User != null && HttpContext.Current.User.Identity.IsAuthenticated)
{
string userk = Membership.GetUser().ProviderUserKey.ToString();
SqlDataSource ds2 = (SqlDataSource)LoginView2.FindControl("SqlDataSourceNeCitite");
SqlDataSource ds4 = (SqlDataSource)LoginView2.FindControl("SqlDataSourceCitite");
//ds2.SelectCommand = "SELECT aspnet_Users.UserName as UserN, COUNT(*) AS nrC FROM aspnet_Users INNER JOIN Conversatii ON aspnet_Users.UserId = Conversatii.cod_receiver and Conversatii.cod_sender = '" + Membership.GetUser().ProviderUserKey.ToString() + "' GROUP BY aspnet_Users.UserName;";
//ds2.SelectCommand = "SELECT aspnet_Users.UserName as UserN, count(*) AS nrC, Min(Conversatii.citit) as citit FROM aspnet_Users INNER JOIN Conversatii ON (aspnet_Users.UserId = Conversatii.cod_receiver OR aspnet_Users.UserId = Conversatii.cod_sender) and (Conversatii.cod_sender <> Conversatii.cod_receiver) and (Conversatii.cod_sender = '" + Membership.GetUser().ProviderUserKey.ToString() + "' OR Conversatii.cod_receiver = '" + Membership.GetUser().ProviderUserKey.ToString() + "') GROUP BY aspnet_Users.UserName HAVING Min(Conversatii.citit) = 0";
ds2.SelectCommand = "select (select UserName from aspnet_Users where UserId = (case cod_sender when '" + userk + "' then cod_receiver else cod_sender end) ) as userN, count(case citit when 0 then 1 else null end) as nrC, count(*) as nrC2 from Conversatii where (cod_sender = '" + userk + "' and cod_receiver <> cod_sender) or (cod_receiver = '" + userk + "' and cod_sender <> cod_receiver) group by (case cod_sender when '" + userk + "' then cod_receiver else cod_sender end) having min(citit) = 0";
//ds2.SelectParameters["" + userk + ""].DefaultValue = userk;
//ds4.SelectCommand = "SELECT aspnet_Users.UserName as UserN, count(*) AS nrC, Min(Conversatii.citit) as citit FROM aspnet_Users INNER JOIN Conversatii ON (aspnet_Users.UserId = Conversatii.cod_receiver OR aspnet_Users.UserId = Conversatii.cod_sender) and (Conversatii.cod_sender <> Conversatii.cod_receiver) and (Conversatii.cod_sender = '" + Membership.GetUser().ProviderUserKey.ToString() + "' OR Conversatii.cod_receiver = '" + Membership.GetUser().ProviderUserKey.ToString() + "') GROUP BY aspnet_Users.UserName HAVING Min(Conversatii.citit) = 1";
ds4.SelectCommand = "select (select UserName from aspnet_Users where UserId = (case cod_sender when '" + userk + "' then cod_receiver else cod_sender end) ) as userN, count(case citit when 1 then 1 else null end) as nrC, count(*) as nrC2 from Conversatii where (cod_sender = '" + userk + "' and cod_receiver <> cod_sender) or (cod_receiver = '" + userk + "' and cod_sender <> cod_receiver) group by (case cod_sender when '" + userk + "' then cod_receiver else cod_sender end) having min(citit) = 1";
//ds4.SelectParameters["@userkey"].DefaultValue = Membership.GetUser().ProviderUserKey.ToString();
}
}
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
CachedImageRenderer.Init();
Forms.Forms.Init(this, savedInstanceState);
SetContentView(Resource.Layout.Third);
var formsView = new LoginView2();
var vm = new LoginViewModel(new ProfileService(), new NavigationService());
vm.InitializeAsync(null);
formsView.BindingContext = vm;
var fragment = formsView.CreateFragment(this);
var transaction = FragmentManager.BeginTransaction();
transaction.Replace(Resource.Id.frameLayout1, fragment);
transaction.Commit();
}
protected void addSubject(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
string command = "insert into Subiecte values(@sub, @iddom)";
int id_dom = int.Parse(Global.ImportantData);
TextBox t = (TextBox)(LoginView2.FindControl("testA"));
string text = t.Text;
t.Text = "";
con.Open();
using (SqlCommand cmd = new SqlCommand(command, con))
{
cmd.Parameters.AddWithValue("@sub", text);
cmd.Parameters.AddWithValue("@iddom", id_dom);
cmd.ExecuteNonQuery();
}
con.Close();
Response.Redirect("Subiecte.aspx");
}
protected Boolean CanDelete(String uname)
{
var Label2 = (Label)LoginView2.FindControl("Label2");
Label2.Text = uname;
var id = Request.Params["id"];
String uname2 = User.Identity.Name;
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand("SELECT [uname] as uname FROM [poza] WHERE [id]=@id", con);
try
{
sql.Parameters.AddWithValue("id", id);
var reader = sql.ExecuteReader();
if (reader.Read())
{
String uname3 = (String)reader["uname"];
Label2.Text = uname3;
if (uname.CompareTo(uname2) == 0 || uname2.CompareTo(uname3) == 0)
{
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
return(uname.CompareTo(uname2) == 0);
}
protected void deletePhoto(object sender, EventArgs e)
{
var Label1 = (Label)LoginView2.FindControl("Label1");
String idphoto = Request.Params["id"];
String uname2 = User.Identity.Name;
String query = "DELETE FROM poza WHERE id=@idphoto ";
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.MDF;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("idphoto", idphoto);
sql.ExecuteNonQuery();
con.Close();
Page.Response.Redirect("http://localhost:50922/WebSite1/index.aspx", true);
}
catch
{
Label1.Text = "Eroare";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
var Label2 = (Label)LoginView2.FindControl("Label2");
var FileUpload1 = (FileUpload)LoginView2.FindControl("FileUpload1");
if (!FileUpload1.HasFile)
{
Label2.Text = "Please Select Image File"; //checking if file uploader has no file selected
}
else
{
byte[] pic = FileUpload1.FileBytes;//aici e ok? da da eroare?
String uname = User.Identity.Name;
String album = Request.Params["numealbum"];
String query = "INSERT INTO poza (album, poza, uname) VALUES (@numealbum, @poza,@uname) "; //stai ah dap
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand sql = new SqlCommand(query, con);
try
{
sql.Parameters.AddWithValue("poza", pic);
sql.Parameters.AddWithValue("numealbum", album);
sql.Parameters.AddWithValue("uname", uname);
sql.ExecuteNonQuery();
Label2.Text = "Succes";
con.Close();
}//pot eu sa iti fac image.aspx daca vrei sau pot sa te las pe tine sa cauti... ce vrei.arata-mi ca ex
//nu prea e "exemplu" ca o sa folosesti dupa sta ceva de genu
//image.aspx?id=1 ca image source pt <img>..arata-mi oricum ca eu probabil o sa gasesc greu k
catch
{
Label2.Text = "Eroare";
}
}
}
/// <summary>
/// Custom display at top of site
/// (1)Set logonName display FirstName
/// (2)Set Premium Since MMM, yyyy
/// </summary>
private void SetMessageAfterLogin()
{
try
{
//if (Context.User.Identity.IsAuthenticated)
//{
// string test = HttpUtility.HtmlEncode(@"<newuser2>?:!@#%^&*()_+""'.,/\[]|\!@#$%^&*()_+");
// //test = "<newuser2>?:{}|\\!@#$%^&*()_+";
// LoginName loginName1 = (LoginName)LoginView2.FindControl("loginName");
// loginName1.FormatString = test;
//}
if (Context.User.Identity.IsAuthenticated && Roles.IsUserInRole(Utility.RoleName.Members.ToString()))
{
string sesloginName = "loginName" + Context.User.Identity.Name;
string sesPreSince = "aPreSince" + Context.User.Identity.Name;
LoginName loginName = (LoginName)LoginView2.FindControl("loginName");
if (Session[sesloginName] != null)
{
loginName.FormatString = Session[sesloginName].ToString();
}
HtmlAnchor aPreSince = (HtmlAnchor)LoginView2.FindControl("aPreSince");
if (Session[sesPreSince] != null)
{
aPreSince.InnerText = Session[sesPreSince].ToString();
}
else
{
Guid userID = (Guid)System.Web.Security.Membership.GetUser(Context.User.Identity.Name).ProviderUserKey;
PollinatorEntities mydb = new PollinatorEntities();
UserDetail userDetail = new UserDetail();
var selectedUserDetail = (from user in mydb.UserDetails
where user.UserId == userID
select user).FirstOrDefault();
if (selectedUserDetail != null)
{
//set loginName
Session[sesloginName] = selectedUserDetail.FirstName;
loginName.FormatString = HttpUtility.HtmlEncode(Session[sesloginName].ToString());
if (selectedUserDetail.MembershipLevel == 0)
{
aPreSince.Visible = false;
}
else if (selectedUserDetail.MembershipLevel > 0)
{
var pollinatorInfomation = (from poll in mydb.PolinatorInformations
where poll.UserId == userID
select poll).FirstOrDefault();
DateTime paidDate = pollinatorInfomation.PaidDate == null ? DateTime.MinValue : (DateTime)pollinatorInfomation.PaidDate;
if (paidDate > DateTime.MinValue)
{
aPreSince.Visible = true;
Session[sesPreSince] = string.Format("Premium since {0}", String.Format("{0:MMM, yyyy}", paidDate));
aPreSince.InnerText = Session[sesPreSince].ToString();
}
}
}
}
}
else if (Context.User.Identity.IsAuthenticated)
{
string sesloginName = "loginName" + Context.User.Identity.Name;
string sesPreSince = "aPreSince" + Context.User.Identity.Name;
HtmlAnchor aPreSince = (HtmlAnchor)LoginView2.FindControl("aPreSince");
aPreSince.Visible = false;
LoginName loginName = (LoginName)LoginView2.FindControl("loginName");
if (Session[sesloginName] != null)
{
loginName.FormatString = Session[sesloginName].ToString();
}
else
{
Guid userID = (Guid)System.Web.Security.Membership.GetUser(Context.User.Identity.Name).ProviderUserKey;
PollinatorEntities mydb = new PollinatorEntities();
UserDetail userDetail = new UserDetail();
var selectedUserDetail = (from user in mydb.UserDetails
where user.UserId == userID
select user).FirstOrDefault();
if (selectedUserDetail != null)
{
//set loginName
Session[sesloginName] = selectedUserDetail.FirstName;
loginName.FormatString = Session[sesloginName].ToString();
}
}
}
}
catch (Exception ex)
{
//write log
Pollinator.Common.Logger.Error("Occured in function: " + typeof(SiteMap).Name + ".SetMessageAfterLogin()", ex);
}
}
