protected void btnUpdateContact_Click(object sender, EventArgs e)
{
//Update the Group
//s = urUserRegBLLObj.frnrelUserId;
string Id = tmp.Value;
urUserRegBLLObj.frnrelUserId = Convert.ToString(Session["User"]);
urUserRegBLLObj.frnrelFriendId = Convert.ToString(Id);
urUserRegBLLObj.FrnrelPrefix = Convert.ToString(ddlprefix.SelectedItem.Text);
if (ddlprefix.SelectedItem.Text == null)
{
urUserRegBLLObj.FrnrelPrefix = "Dear";
}
urUserRegBLLObj.Frnrelinfix = Convert.ToString(ddlinfix.SelectedItem.Text);
if (ddlinfix.SelectedItem.Text == null)
{
urUserRegBLLObj.Frnrelinfix = infix[0];
}
urUserRegBLLObj.Frnrelpostfix = Convert.ToString(ddlpostfix.SelectedItem.Text);
if (ddlpostfix.SelectedItem.Text == null)
{
urUserRegBLLObj.Frnrelpostfix = " ";
}
try
{
status = urUserRegBLLObj.BLLPrefixUpdate(urUserRegBLLObj);
if (status == 0)
{
//ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User already Exists')", true);
}
}
catch (Exception ex)
{
throw ex;
}
string Sql = "Delete from friendGroupRelation where RelId=" + Id + " ";
Sql = Sql + " Update FriendRelationMaster set Relation='" + txtRelation.Text.ToString() + "' " +
" where FriRelId=" + Id + " ";
//sql1=Sql+"update "
for (int i = 0; i < chkGroup.Items.Count - 1; i++)
{
if (chkGroup.Items[i].Selected == true)
{
Sql = Sql + " Insert into FriendGroupRelation (RelId, GroupId) Values " +
" (" + Id + "," + chkGroup.Items[i].Value.ToString() + " ) ";
}
}
CommonCode cc = new CommonCode();
int tmp1 = cc.ExecuteNonQuery(Sql);
urUserRegBLLObj.usrUserId = Convert.ToString(Session["User"]);
DataTable dtFriendRelList = urUserRegBLLObj.BLLFriendRelativeShowById(urUserRegBLLObj);
gvRemoveFriend.DataSource = dtFriendRelList;
gvRemoveFriend.DataBind();
urUserRegBLLObj.frnrelUserId = Convert.ToString(Session["User"]);
string query = "select * from FriendRelationMaster where UserId='" + urUserRegBLLObj.frnrelUserId.ToString() + "'";
DataSet ds = cc.ExecuteDataset(query);
foreach (DataRow dr in ds.Tables[0].Rows)
{
string userid = Convert.ToString(dr["UserId"]);
string frienduserid = Convert.ToString(dr["FriendId"]);
}
}