protected void txtQty_TextChanged(object sender, EventArgs e) { try { if (CategoriesDropDownList.SelectedIndex > 0) { if (ItemsDropDownList.SelectedIndex > 0) { AddSaleItems(); txtQty.Text = ""; txtSubTotal.Text = total.ToString(); CategoriesDropDownList.Focus(); DiscountCalculation(); } else { ItemsDropDownList.Focus(); lblItems.ForeColor = Color.Red; } } else { CategoriesDropDownList.Focus(); lblCategories.ForeColor = Color.Red; } } catch { } }
public void GetAllCategories() { CategoriesDropDownList.DataSource = _ProductSetupRepository.GetAllCategories(); CategoriesDropDownList.DataTextField = "Name"; CategoriesDropDownList.DataValueField = "Id"; CategoriesDropDownList.DataBind(); CategoriesDropDownList.Items.Insert(0, new ListItem("Select Category", "0")); }
public void GetALLCategories() { CategoriesDropDownList.DataSource = _ItemSalesRepository.GetAllCategories(); CategoriesDropDownList.DataTextField = "Name"; CategoriesDropDownList.DataValueField = "Id"; CategoriesDropDownList.DataBind(); CategoriesDropDownList.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select Categories", "0")); }
public void GetAllCategories() { CategoriesDropDownList.DataSource = _PurchaseRepository.GetAllCategories(); CategoriesDropDownList.DataTextField = "Name"; CategoriesDropDownList.DataValueField = "Id"; CategoriesDropDownList.DataBind(); CategoriesDropDownList.Items.Insert(0, new ListItem("Chose Category", "0")); }
public void Refresh() { txtCode.Text = ""; txtQty.Text = ""; txtCost.Text = ""; txtMrp.Text = ""; CategoriesDropDownList.ClearSelection(); SizeDropDownList.ClearSelection(); ItemsDropDownList.ClearSelection(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { // Read the connection string from Web.config string connectionString = ConfigurationManager.ConnectionStrings["RB_RecipeBook"].ConnectionString; using (SqlConnection conn = new SqlConnection(connectionString)) { try { // Get data about users from the database SqlDataAdapter adapterUsers = new SqlDataAdapter("SELECT idUser, UserName FROM RB_User", conn); DataTable storeTableUsers = new DataTable(); // table to store the sql command adapterUsers.Fill(storeTableUsers); // Populate dropdownlist SubmittedByDropDownList.DataSource = storeTableUsers; SubmittedByDropDownList.DataTextField = "UserName"; SubmittedByDropDownList.DataValueField = "idUser"; SubmittedByDropDownList.DataBind(); // Add extra item "All" SubmittedByDropDownList.Items.Insert(0, new ListItem("All Users")); // Get data about categories from the database SqlDataAdapter adapterCategories = new SqlDataAdapter("SELECT idCategory, CategoryName FROM RB_Category", conn); DataTable storeTableCategories = new DataTable(); // table to store the sql command adapterCategories.Fill(storeTableCategories); // Populate dropdownlist CategoriesDropDownList.DataSource = storeTableCategories; CategoriesDropDownList.DataTextField = "CategoryName"; CategoriesDropDownList.DataValueField = "idCategory"; CategoriesDropDownList.DataBind(); // Add extra item "All" CategoriesDropDownList.Items.Insert(0, new ListItem("All Categories")); // Get data about ingredients from the database SqlDataAdapter adapterIngredients = new SqlDataAdapter("SELECT idIngredient, IngredientName FROM RB_Ingredient", conn); DataTable storeTableIngredients = new DataTable(); // table to store the sql command adapterIngredients.Fill(storeTableIngredients); // Populate dropdownlist IngredientsDropDownList.DataSource = storeTableIngredients; IngredientsDropDownList.DataTextField = "IngredientName"; IngredientsDropDownList.DataValueField = "idIngredient"; IngredientsDropDownList.DataBind(); // Add extra item "All" IngredientsDropDownList.Items.Insert(0, new ListItem("All Ingredients")); } catch (Exception ex) { MessageLabel.Text = "ERROR: " + ex.Message; } } } }
protected void AddButton_Click(object sender, EventArgs e) { Items _Items = new Items(); _Items.Code = txtCode.Text; _Items.Name = txtName.Text; _Items.ReorderLevel = 5; _Items.Size = SizeDropDownList.SelectedItem.ToString(); _Items.CategoriesId = Convert.ToInt32(CategoriesDropDownList.SelectedValue); if (CategoriesDropDownList.SelectedIndex > 0) { if (SizeDropDownList.SelectedIndex > 0) { decimal AlreadyExistCaegory = _ItemRepository.AlreadyExistName(_Items); if (AlreadyExistCaegory >= 1) { ShowMessage("This Item Already Here!!!...", MessageType.Warning); } else { int Savesuccess = _ItemRepository.Add(_Items); if (Savesuccess > 0) { ShowMessage("Successfully Saved Item....", MessageType.Success); LoadItem(); AutoCodeGenerate(); GetAllCategories(); txtName.Text = ""; CategoriesDropDownList.ClearSelection(); SizeDropDownList.ClearSelection(); //Response.Redirect(Request.Url.AbsoluteUri); } else { ShowMessage("Failed Saving Item", MessageType.Warning); } } } else { ShowMessage("Select Size", MessageType.Warning); SizeDropDownList.Focus(); } } else { ShowMessage("At First Select Catgeory", MessageType.Warning); CategoriesDropDownList.Focus(); } }
public void Refresh() { GetALLCategories(); AutoCodeGenerate(); CategoriesDropDownList.ClearSelection(); ItemsDropDownList.ClearSelection(); txtCustomerName.Text = ""; txtCustomerName.Focus(); txtSubTotal.Text = ""; txtDiscount.Text = ""; txtDiscount.Text = "0"; txtTotalCost.Text = ""; txtPaidAmount.Text = ""; lblChanges.Text = ""; }
protected void AddButton_Click(object sender, EventArgs e) { try { if (CategoriesDropDownList.SelectedIndex > 0 && ShelfsDropDownList.SelectedIndex > 0) { if (RemainShelf >= 0) { Items _Items = new Items(); _Items.Code = txtCode.Text; _Items.Name = txtName.Text; _Items.GenericName = txtGenericName.Text; _Items.ReorderLevel = Convert.ToInt32(txtReorderLevel.Text); _Items.CategoriesId = Convert.ToInt32(CategoriesDropDownList.SelectedValue); _Items.ShelfsId = Convert.ToInt32(ShelfsDropDownList.SelectedValue); int saveSuccess = _ItemRepository.Add(_Items); if (saveSuccess > 0) { lblmsg.Text = "This Item Save Successefully!!...."; lblmsg.ForeColor = Color.Green; AutoCodeGenerate(); Response.Redirect(Request.Url.AbsoluteUri); } else { lblmsg.Text = "This Item Saving Failed!!...."; lblmsg.ForeColor = Color.Red; } } else { lblmsg.Text = "This Shelf Fully Done!!....Please Try Another Shelf"; lblmsg.ForeColor = Color.Red; } } else { CategoriesDropDownList.Focus(); } } catch (Exception ex) { lblmsg.Text = ex.Message; } }
protected void AddItemButton_Click(object sender, EventArgs e) { try { ItemsM _ItemsM = new ItemsM(); _ItemsM.Name = txtItemName.Text; _ItemsM.Price = Convert.ToDecimal(txtPrice.Text); _ItemsM.CategoriesId = Convert.ToInt32(CategoriesDropDownList.SelectedValue); decimal AlreadyExistItem = _ItemRepository.AlreadyExistItem(_ItemsM); if (AlreadyExistItem >= 1) { ShowMessage("This Item Already Here!!..This Category", MessageType.Warning); } else { int savesuccess = _ItemRepository.Add(_ItemsM); if (savesuccess > 0) { ShowMessage("Successfully Saved Item", MessageType.Success); LoadItem(); txtItemName.Text = ""; txtPrice.Text = ""; CategoriesDropDownList.ClearSelection(); } else { ShowMessage("Failed Saving Item", MessageType.Warning); } } } catch (Exception ex) { ShowMessage(ex.Message, MessageType.Warning); } }