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