protected void DataGrid1_ItemCommand(object source, DataGridCommandEventArgs e)
{
Id = e.CommandArgument.ToString();
switch (e.CommandName)
{
case "Edit":
insert = false;
ViewInput(true);
lblAction.Text = "Update Role";
tbRoleInfo roleInfo = new tbRoleInfo();
roleInfo.Id = int.Parse(Id);
DataTable dt = RoleController.GetById(roleInfo);
txtRoleName.Text = dt.Rows[0]["RoleName"].ToString();
break;
case "Delete":
tbRoleInfo obj = new tbRoleInfo();
obj.Id = int.Parse(Id);
RoleController.Delete(obj);
pnUpdate.Visible = false;
pnView.Visible = true;
_LoadRole();
break;
}
}
//Sua
public static void Update(tbRoleInfo obj)
{
string q = "UPDATE [tbRole] SET RoleName=@RoleName";
q = q + " WHERE [Id] = @Id";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = q;
cmd.Connection = GetConnection();
cmd.Parameters.Add(new SqlParameter("@Id", obj.Id));
cmd.Parameters.Add(new SqlParameter("@RoleName", obj.RoleName));
ExecuteNonQuery(cmd);
}
//Them
public static void Insert(tbRoleInfo obj)
{
string str = "Insert into tbRole(RoleName)";
str = str + "Values(@RoleName)";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = str;
cmd.Connection = GetConnection();
cmd.Parameters.Add(new SqlParameter("@RoleName", obj.RoleName));
ExecuteNonQuery(cmd);
}
protected void Update_Click(object sender, EventArgs e)
{
tbRoleInfo ro = new tbRoleInfo();
ro.RoleName = txtRoleName.Text;
if (insert)
{
RoleController.Insert(ro);
_LoadRole();
ViewInput(false);
}
else //Update
{
ro.Id = int.Parse(Id);
RoleController.Update(ro);
_LoadRole();
ViewInput(false);
}
}
//Xoa
public static void Delete(tbRoleInfo obj)
{
string q = "Delete from tbRole where Id=" + obj.Id;
ExecuteNonQuery(q);
}
//Get by Id
public static DataTable GetById(tbRoleInfo roleInfo)
{
string str = "Select * from tbRole where Id=" + roleInfo.Id;
return(GetData(str));
}
