Friday, June 17, 2011

Change Status Function-2


---------------------------------------------------
alter proc usp_Change_Status
(
@userid int,
@status varchar(50)
)
as
update tbl_user set IsActive=@status where userid=@userid

-----------------------------------------------------
public string getImageUrl(bool act)
{
string imageurl = "";
string path = "~/images/";
if (act == true)
{
imageurl = path + "available.png";
return imageurl;
}
else
{
imageurl = path + "notav.png";
return imageurl;
}
}
-------------------------------------------------------------------------------------------
<asp:TemplateField>
<ItemTemplate>
<asp:ImageButton ID="imgBtnStatus" CommandName="changestatus"
CommandArgument='<%#Eval("userid")%>'
ToolTip="Click to change status. !!!"

ImageUrl='<%#getImageUrl(Convert.ToBoolean((Eval("IsActive"))))%>'
runat="server" />

<asp:HiddenField ID="HiddenField1" Value='<%#Eval("IsActive")%>'
runat="server" />
/ItemTemplate>
</asp:TemplateField>

------------------------------------------------------------------------------------------------
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{

if (e.CommandName.ToString() == "changestatus")
{
GridViewRow grow = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer;
ImageButton img = e.CommandSource as ImageButton;
GridViewRow gvRow = img.Parent.Parent as GridViewRow;

int id = int.Parse(e.CommandArgument.ToString());

HiddenField hdnField = (HiddenField)GridView1.Rows[gvRow.RowIndex].FindControl("HiddenField1");

string status = "";
if (hdnField.Value == "True")
{
status = "False";
}
else if (hdnField.Value == "False")
{
status = "True";
}

Hashtable ht = new Hashtable();
ht.Add("@userid", id);
ht.Add("@status", status);

NSBuilder.DataAccess.ExecuteNonQuery("usp_Change_Status", ht);
BindGrid();
}

}
-----------------------------------------------------------------
***
  <ItemTemplate>
      <asp:Label ID="lblStatus" runat="server"
Text='<%# Convert.ToString(Eval("isActive")).ToLower()=="true"?"Activated":"DeActivated" %>'></asp:Label>
     </ItemTemplate>
------------------------------------------------------------------

0 comments:

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More