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)); }