protected void gvRemoveFriend_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Remove")
{
urUserRegBLLObj.frnrelFriendId = Convert.ToString(e.CommandArgument);
urUserRegBLLObj.frnrelUserId = Convert.ToString(Session["User"]);
status = urUserRegBLLObj.BLLUserFriendRelativeRemove(urUserRegBLLObj);
if (status == 1)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Friend Removed')", true);
urUserRegBLLObj.usrUserId = Convert.ToString(Session["User"]);
DataSet dtFriendRelList = urUserRegBLLObj.BLLFriendRelativeShowById(urUserRegBLLObj);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Friend Not Removed')", true);
}
gvFriendShow1();
}
else if (e.CommandName == "Edit")
{
string Id = Convert.ToString(e.CommandArgument);
if (Convert.ToString(e.CommandName) == "Edit")
{
Response.Redirect("FriendRelativeupdate.aspx?Id=" + Id);
}
}
}
protected void gvRemoveFriend_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Remove")
{
urUserRegBLLObj.frnrelFriendId = Convert.ToString(e.CommandArgument);
urUserRegBLLObj.frnrelUserId = Convert.ToString(Session["User"]);
status = urUserRegBLLObj.BLLUserFriendRelativeRemove(urUserRegBLLObj);
if (status == 1)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Friend Removed')", true);
urUserRegBLLObj.usrUserId = Convert.ToString(Session["User"]);
DataSet dtFriendRelList = urUserRegBLLObj.BLLFriendRelativeShowById(urUserRegBLLObj);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Friend Not Removed')", true);
}
gvFriendShow1();
}
else if (e.CommandName == "Edit")
{
string Id = Convert.ToString(e.CommandArgument);
if (Convert.ToString(e.CommandName) == "Edit")
{
Response.Redirect("FriendRelativeupdate.aspx?Id=" + Id);
}
// DataSet ds = cc.ExecuteDataset(Sql);
// foreach (DataRow dr in ds.Tables[0].Rows)
// {
// lblName.Text = Convert.ToString(dr["Name"]);
// //string name1 = lblName.Text;
// txtRelation.Text = Convert.ToString(dr["Relation"]);
// string GroupId = Convert.ToString(dr["GroupId"]);
// for (int i = 0; i < chkGroup.Items.Count - 1; i++)
// {
// if (GroupId == Convert.ToString(chkGroup.Items[i].Value.ToString()))
// {
// chkGroup.Items[i].Selected = true;
// }
// }
// }
// try
// {
// tmp.Value = Id;
// con.Open();
// string sql = "Select FriRelName from FriendRelationMaster where FriRelId= '" + Id.ToString() + "'";
// SqlCommand cmd = new SqlCommand(sql, con);
// SqlDataReader dr = cmd.ExecuteReader();
// DataSet dset = cc.ExecuteDataset(sql);
// foreach (DataRow dr1 in dset.Tables[0].Rows)
// {
// fname = Convert.ToString(dr1["FriRelName"]);
// }
// string fullname = fname;
// infix = fullname.Split(' ');
// //ddlinfix.Items.Add(infix[0]);
// if (infix[1] == " " || infix[1] == null)
// {
// ddlinfix.Items.Add("");
// }
// else
// {
// ddlinfix.Items.Add(infix[1]);
// }
//{
// ddlinfix.DataTextField = dr["UserFirstNameN"].ToString();
// ddlinfix.DataValueField = dr["User"].ToString();
//}
// SqlDataAdapter da = new SqlDataAdapter(sql, con);
// DataSet dset = new DataSet();
// da.Fill(dset);
// ddlinfix.DataSource = dset;
// ddlinfix.DataTextField = "---Select--";
//Session["UserFirstNameN"] = ddlinfix.SelectedItem.Text.ToString();
// Session["UserLastNameN"] = ddlinfix.SelectedItem.Text.ToString();
//ddlinfix.DataValueField = "usrUserId";
//ddlinfix.DataTextField = "usrFirstName";
//ddlinfix.DataTextField = "usrLastName";
// ddlinfix.DataBind();
//}
//catch (Exception ex)
//{
// throw ex;
//}
}
//mdlEditGroup.Show();
}
protected void gvRemoveFriend_RowCommand(object sender, GridViewCommandEventArgs e)
{
//string name1 = "";
////string Id1="";
//string Id1 = Convert.ToString(e.CommandArgument);
//tmp.Value = Id1;
//string Sql1 = " SELECT DISTINCT UserMaster.usrFirstName +' '+ UserMaster.usrLastName as Name , " +
// " FriendRelationMaster.Relation, FriendGroupRelation.GroupId " +
// " FROM FriendGroupRelation INNER JOIN " +
// " FriendRelationMaster ON FriendGroupRelation.RelId = FriendRelationMaster.FriRelId INNER JOIN " +
// " UserMaster ON FriendRelationMaster.FriendId = UserMaster.usrUserId " +
// " where FriendRelationMaster.FriRelId=" + Id1 + "";
//CommonCode cc1 = new CommonCode();
//DataSet ds1 = cc1.ExecuteDataset(Sql1);
//foreach (DataRow dr in ds1.Tables[0].Rows)
//{
// name1 = Convert.ToString(dr["Name"]);
// string Relation = Convert.ToString(dr["Relation"]);
//}
if (e.CommandName == "Remove")
{
urUserRegBLLObj.frnrelFriendId = Convert.ToString(e.CommandArgument);
urUserRegBLLObj.frnrelUserId = Convert.ToString(Session["User"]);
status = urUserRegBLLObj.BLLUserFriendRelativeRemove(urUserRegBLLObj);
if (status == 1)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Friend Removed')", true);
urUserRegBLLObj.usrUserId = Convert.ToString(Session["User"]);
DataTable dtFriendRelList = urUserRegBLLObj.BLLFriendRelativeShowById(urUserRegBLLObj);
gvRemoveFriend.DataSource = dtFriendRelList;
gvRemoveFriend.DataBind();
//gvSearchFriend.DataSource = dtFriendRelList;
//gvSearchFriend.DataBind();
//TextfirstN.Text = "";
//TextlastN.Text = "";
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Friend Not Removed')", true);
}
}
else if (e.CommandName == "Edit")
{
s = Convert.ToString(e.CommandArgument);
urUserRegBLLObj.frnrelFriendId = Convert.ToString(e.CommandArgument);
urUserRegBLLObj.frnrelUserId = Convert.ToString(Session["User"]);
LoadFriendGroup();
string Id = Convert.ToString(e.CommandArgument);
tmp.Value = Id;
string Sql = " SELECT DISTINCT UserMaster.usrFirstName +' '+ UserMaster.usrLastName as Name , " +
" FriendRelationMaster.Relation, FriendGroupRelation.GroupId " +
" FROM FriendGroupRelation INNER JOIN " +
" FriendRelationMaster ON FriendGroupRelation.RelId = FriendRelationMaster.FriRelId INNER JOIN " +
" UserMaster ON FriendRelationMaster.FriendId = UserMaster.usrUserId " +
" where FriendRelationMaster.FriRelId=" + Id + "";
CommonCode cc = new CommonCode();
DataSet ds = cc.ExecuteDataset(Sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
lblName.Text = Convert.ToString(dr["Name"]);
//string name1 = lblName.Text;
txtRelation.Text = Convert.ToString(dr["Relation"]);
string GroupId = Convert.ToString(dr["GroupId"]);
for (int i = 0; i < chkGroup.Items.Count - 1; i++)
{
if (GroupId == Convert.ToString(chkGroup.Items[i].Value.ToString()))
{
chkGroup.Items[i].Selected = true;
}
}
}
try
{
tmp.Value = Id;
con.Open();
string sql = "Select FriRelName from FriendRelationMaster where FriRelId= '" + Id.ToString() + "'";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = cmd.ExecuteReader();
DataSet dset = cc.ExecuteDataset(sql);
foreach (DataRow dr1 in dset.Tables[0].Rows)
{
fname = Convert.ToString(dr1["FriRelName"]);
}
string fullname = fname;
infix = fullname.Split(' ');
ddlinfix.Items.Add(infix[0]);
if (infix[1] == " " || infix[1] == null)
{
ddlinfix.Items.Add("");
}
else
{
ddlinfix.Items.Add(infix[1]);
}
//{
// ddlinfix.DataTextField = dr["UserFirstNameN"].ToString();
// ddlinfix.DataValueField = dr["User"].ToString();
//}
// SqlDataAdapter da = new SqlDataAdapter(sql, con);
// DataSet dset = new DataSet();
// da.Fill(dset);
// ddlinfix.DataSource = dset;
// ddlinfix.DataTextField = "---Select--";
//Session["UserFirstNameN"] = ddlinfix.SelectedItem.Text.ToString();
// Session["UserLastNameN"] = ddlinfix.SelectedItem.Text.ToString();
//ddlinfix.DataValueField = "usrUserId";
//ddlinfix.DataTextField = "usrFirstName";
//ddlinfix.DataTextField = "usrLastName";
ddlinfix.DataBind();
}
catch (Exception ex)
{
throw ex;
}
mdlEditGroup.Show();
}
}