private void Loadstockstatus() { Liquor liquor = new Liquor(); DgvStockStatus.DataSource = liquor.NotifyStockStatus().Tables["Liquor"]; }
private void FilterLiquorCategory() { liquor = new Liquor(); liquor.CategoryId = Convert.ToInt32(CboCategory.SelectedValue); DgvLiquor.DataSource = liquor.FilterLiquorCategory().Tables["Liquor"]; }
private void SearchLiquorCategory() { liquor = new Liquor(); DgvLiquor.DataSource = liquor.SearchLiquorCategory(TxtLiquor.Text, Convert.ToInt32(CboCategory.SelectedValue)).Tables["Liquor"]; }
private void SearchLiquor() { liquor = new Liquor(); DgvLiquor.DataSource = liquor.SearchLiquor(TxtLiquor.Text).Tables["Liquor"]; }
private void LoadLiquor() { liquor = new Liquor(); DgvLiquor.DataSource = liquor.ViewLiquor().Tables["Liquor"]; }
private void BtnSave_Click(object sender, EventArgs e) { try { bool liquorflag = false; if (!Global.ComboNull(CboLiquor)) { throw new Exception("Select liquor"); } if (!Global.InputHandle(TxtLiquor)) { liquorflag = true; } if (!Global.ComboNull(CboCategory)) { throw new Exception("Select liquor Category"); } if (!Global.InputHandle(TxtPrice)) { throw new Exception("Enter Liquor price"); } if (!Global.IsValidNumDec(TxtPrice)) { throw new Exception("Invalid Liquor price"); } if (!Global.InputHandle(TxtQuantity)) { throw new Exception("Enter Liquor quantity"); } if (!Global.IsValidNumInt(TxtQuantity)) { throw new Exception("Invalid Liquor quantity"); } if (!Global.InputHandle(TxtThreshold)) { throw new Exception("Enter Liquor quantity threshold"); } if (!Global.IsValidNumInt(TxtThreshold)) { throw new Exception("Invalid liquor quantity threshold"); } liquor = new Liquor(); if (liquorflag) { liquor.LiquorName = CboLiquor.Text; } else { liquor.LiquorName = TxtLiquor.Text; } liquor.LiquorId = Convert.ToInt32(CboLiquor.SelectedValue); liquor.CategoryId = Convert.ToInt32(CboCategory.SelectedValue); liquor.LiquorPrice = Decimal.Parse(TxtPrice.Text); liquor.LiquorQuantity = int.Parse(TxtQuantity.Text); liquor.ThresholdQuantity = int.Parse(TxtThreshold.Text); bool flag = liquor.UpdateLiquor(liquorflag); if (flag) { MessageBox.Show("Selected liquor is updated"); LoadLiquor(); LoadLiquorCbo(); } else { MessageBox.Show("Liquor name already exist"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }