protected void AddCategory(object sender, EventArgs e) { Literal AddCategoryResponse = (Literal)AddCategoryLoginView.FindControl("AddCategoryResponse"); TextBox NameTB = (TextBox)AddCategoryLoginView.FindControl("NameTB"); FileUpload PozaCat = (FileUpload)AddCategoryLoginView.FindControl("PozaCat"); string check = CheckCategory(NameTB.Text.ToString()); if (check != string.Empty) { AddCategoryResponse.Text = check; return; } try { SqlConnection connection = new SqlConnection(); connection.ConnectionString = CategorySqlDataSource.ConnectionString; connection.Open(); String cmd = "INSERT INTO [Category] ([Name] , [Poza]) VALUES (@Name, @Poza)"; SqlCommand command = new SqlCommand(cmd, connection); command.Parameters.AddWithValue("Name", NameTB.Text); command.Parameters.AddWithValue("Poza", "UplCat/" + PozaCat.FileName); try { command.ExecuteNonQuery(); Response.Redirect("~/Gallery.aspx?"); } catch (SqlException sqex) { AddCategoryResponse.Text = sqex.Message; } connection.Close(); } catch (Exception ex) { AddCategoryResponse.Text = ex.Message; } }
protected void EditCategory(object source, EventArgs e) { HiddenField h = (HiddenField)AddCategoryLoginView.FindControl("EditCategoryID"); TextBox t = (TextBox)AddCategoryLoginView.FindControl("EditCategoryTB"); Literal EditCategoryResponse = (Literal)AddCategoryLoginView.FindControl("EditCategoryResponse"); if (t == null) { return; } string cat_id = Guid.Parse(h.Value.ToString()).ToString(); string name = t.Text; try { SqlConnection connection = new SqlConnection(); connection.ConnectionString = CategorySqlDataSource.ConnectionString; connection.Open(); String cmd = "UPDATE [Category] SET [Name] = @Name WHERE [Id] = @Id"; SqlCommand command = new SqlCommand(cmd, connection); command.Parameters.AddWithValue("Name", name); command.Parameters.AddWithValue("Id", cat_id); try { command.ExecuteNonQuery(); Response.Redirect("~/Gallery.aspx?"); } catch (SqlException sqex) { EditCategoryResponse.Text = sqex.Message; } connection.Close(); } catch (Exception ex) { EditCategoryResponse.Text = ex.Message; } }
protected void SetLoginViewActions(LoginView CategoryLoginView) { Button EditCategoryButton = (Button)CategoryLoginView.FindControl("EditCategoryButton"); Button DeleteCategoryButton = (Button)CategoryLoginView.FindControl("DeleteCategoryButton"); HiddenField ItemIdHF = (HiddenField)CategoryLoginView.Parent.FindControl("ItemId"); HiddenField ItemContentHF = (HiddenField)CategoryLoginView.Parent.FindControl("ItemContent"); string ItemId = Guid.Parse((ItemIdHF.Value).ToString()).ToString(); string ItemContent = ItemContentHF.Value.ToString(); if (EditCategoryButton != null) { string EditDiv = AddCategoryLoginView.FindControl("EditCategoryDiv").ClientID.ToString(); string EditTB = AddCategoryLoginView.FindControl("EditCategoryTB").ClientID.ToString(); string EditID = AddCategoryLoginView.FindControl("EditCategoryID").ClientID.ToString(); string AddID = AddCategoryLoginView.FindControl("AddCategoryDiv").ClientID.ToString(); EditCategoryButton.OnClientClick = "return ShowEdit('" + EditDiv + "','" + EditID + "','" + ItemId + "','" + EditTB + "','" + ItemContent + "','" + AddID + "')"; } if (DeleteCategoryButton != null) { DeleteCategoryButton.CommandArgument = ItemId; } }
protected void InitJs() { Button AddCategoryButton = (Button)AddCategoryLoginView.FindControl("AddCategoryButton"); Button EditCategoryButton = (Button)AddCategoryLoginView.FindControl("EditCategoryButton"); Button CancelEditButton = (Button)AddCategoryLoginView.FindControl("CancelEdit"); try { string AddCategoryDivID = AddCategoryLoginView.FindControl("AddCategoryDiv").ClientID.ToString(); string EditCategoryDivID = AddCategoryLoginView.FindControl("EditCategoryDiv").ClientID.ToString(); if (EditCategoryButton != null) { EditCategoryButton.OnClientClick = "return CheckNotNull(" + AddCategoryLoginView.FindControl("EditCategoryTB").ClientID.ToString() + ")"; } if (CancelEditButton != null) { CancelEditButton.OnClientClick = "return CancelEdit('" + EditCategoryDivID + "','" + AddCategoryDivID + "')"; } } catch (Exception ex) { } //if (AddCategoryButton != null) // AddCategoryButton.OnClientClick = "Encode(" + AddCategoryLoginView.FindControl("NameTB").ClientID.ToString() + ")"; }