protected void SaveCreate_Click(object sender, EventArgs e) { var name = (CategoryCreate.FindControl("CreateCategory") as TextBox).Text; if (string.IsNullOrEmpty(name)) { Error_Handler_Control.ErrorSuccessNotifier.AddErrorMessage("Title cannot be empty"); return; } else if (name.Length < 5 || name.Length > 50) { Error_Handler_Control.ErrorSuccessNotifier.AddErrorMessage("Title must be between 5 and 50 symbols"); return; } LibrarySystemDbContext context = new LibrarySystemDbContext(); context.Categories.Add(new Category { Name = name, }); context.SaveChanges(); CategoryCreate.DataSource = null; CategoryCreate.DataBind(); CategoriesGrid.DataBind(); }
protected void Save_btn_Click(object sender, EventArgs e) { using (SqlConnection Conn = new SqlConnection()) { Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath2"].ConnectionString; SqlCommand Comm = new SqlCommand(); Comm.Connection = Conn; Conn.Open(); Comm.CommandText = "INSERT INTO VADIMSERVICES(NAME,LONG) VALUES(@NAME,@LONG)"; Comm.Parameters.Add("@NAME", SqlDbType.NVarChar); Comm.Parameters["@NAME"].Value = name_edt.Text; Comm.Parameters.Add("@LONG", SqlDbType.NVarChar); Comm.Parameters["@LONG"].Value = long_edt.Text; try { Comm.ExecuteScalar(); Error_lb.Text = "Данные успешно добавлены"; } catch (SqlException E) { Error_lb.Text = E.Message; return; } CategoriesGrid.DataBind(); } }
private void AddToCart_Click(object sender, EventArgs e) { var ingredients = GetIngredients().ToList(); var row = FoodItemsGrid.CurrentRow; var item = new CartItem { Quantity = (int)ItemQuantity.Value, Ingredients = ingredients, FoodItemId = (int)row.Cells["ItemId"].Value, Name = row.Cells["ItemName"].Value.ToString(), ShopId = _id, Price = (double)row.Cells["Price"].Value }; _service.Cart.Add(item); ItemQuantity.Value = 1; AddToCart.Enabled = false; IngredientsGrid.DataSource = null; FoodItemsGrid.DataSource = null; CategoriesGrid.ClearSelection(); var currentPrice = double.Parse(Price.Text); var itemPrice = item.Quantity * (item.Price + item.Ingredients.Sum(y => y.Price)); var finalPrice = currentPrice + itemPrice; Price.Text = finalPrice.ToString(); }
protected void SaveEdit_Click(object sender, EventArgs e) { var newName = (CategoryDetails.FindControl("EditCategory") as TextBox).Text; if (string.IsNullOrEmpty(newName)) { Error_Handler_Control.ErrorSuccessNotifier.AddErrorMessage("Title cannot be empty"); return; } else if (newName.Length < 5 || newName.Length > 50) { Error_Handler_Control.ErrorSuccessNotifier.AddErrorMessage("Title must be between 5 and 50 symbols"); return; } var id = int.Parse(CategoryDetails.DataKey.Value.ToString()); LibrarySystemDbContext data = new LibrarySystemDbContext(); var category = data.Categories.FirstOrDefault(x => x.Id == id); category.Name = newName; data.SaveChanges(); CategoryDetails.DataSource = null; CategoryDetails.DataBind(); CategoriesGrid.DataBind(); }
protected void Update_Click(object sender, EventArgs e) { List <Object> dataKeys = CategoriesGrid.GetSelectedDataKeyValues(); foreach (Object dataKey in dataKeys) { int categoryId = AlwaysConvert.ToInt(dataKey); Category category = CategoryDataSource.Load(categoryId); category.Webpage = WebpageDataSource.Load(AlwaysConvert.ToInt(CategoryDisplayPages.SelectedValue)); category.Save(); } CategoriesGrid.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { _webpageId = AbleCommerce.Code.PageHelper.GetWebpageId(); if (!Page.IsPostBack) { CategoryPageList.DataBind(); ListItem item = CategoryPageList.Items.FindByValue(_webpageId.ToString()); if (item != null) { item.Selected = true; } CategoriesGrid.DataBind(); } }
protected void SaveDelete_Click(object sender, EventArgs e) { var id = int.Parse(CategoryDelete.DataKey.Value.ToString()); LibrarySystemDbContext data = new LibrarySystemDbContext(); var category = data.Categories.FirstOrDefault(x => x.Id == id); data.Books.RemoveRange(category.Books); data.Categories.Remove(category); data.SaveChanges(); CategoryDelete.DataSource = null; CategoryDelete.DataBind(); CategoriesGrid.DataBind(); }
protected void edit_btn_Click(object sender, EventArgs e) { using (SqlConnection Conn = new SqlConnection()) { Size s = new Size(400, 400); Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBPath2"].ConnectionString; Conn.Open(); SqlCommand Comm = new SqlCommand(); Comm.Connection = Conn; Comm.CommandText = @"UPDATE VADIMTYPES SET NAME=@NAME,LONG=@LONG,CODE=@CODE WHERE ID=@ID"; Comm.Parameters.Add("@NAME", SqlDbType.NVarChar); Comm.Parameters["@NAME"].Value = name_edt.Text; Comm.Parameters.Add("@LONG", SqlDbType.NVarChar); Comm.Parameters["@LONG"].Value = long_edt.Text; Comm.Parameters.AddWithValue("@ID", ID_lb.Text); Comm.Parameters.AddWithValue("@CODE", code_edt.Text); int ID = Convert.ToInt32(ID_lb.Text); try { Comm.ExecuteNonQuery(); Error_lb.ForeColor = System.Drawing.Color.Green; CategoriesGrid.DataBind(); Error_lb.Text = "Данные успешно добавлены"; } catch (SqlException E) { Error_lb.ForeColor = System.Drawing.Color.Red; Error_lb.Text = string.Format("При загрузке в Базу Данных произошла ошибка. Текст ошибки:{0}", E.Message); return; } Save_btn.Visible = false; edit_btn.Visible = true; Cancel_btn.Visible = true; } }
private void FormShown(object sender, EventArgs e) { CategoriesGrid.ClearSelection(); }
protected void Page_Load(object sender, EventArgs e) { CategoriesGrid.DataSource = ServerModel.DB.FullCached <TblCategory>(); CategoriesGrid.DataBind(); }
protected void CategoryPageList_SelectedIndexChanged(object sender, EventArgs e) { CategoriesGrid.DataBind(); }