protected void addButton_Click(object sender, EventArgs e)
{
int companyId = Convert.ToInt32(companyDropDownList.SelectedValue);
int itemId = Convert.ToInt32(itemDropDownList.SelectedValue);
string quantity = stockOutQuantityTextBox.Text;
Item item = new Item(itemId, companyId, quantity);
ItemCompanyWIseView items = new ItemCompanyWIseView();
StockManager stockManager = new StockManager();
if (stockManager.IsGeaterQuanity(item))
{
messageLabel.Text = "Available quantity is less than stock out quantity";
}
else
{
items = stockManager.GetStcokOutItem(item);
//dr = dt.NewRow();
//dr["Item"] = items.ItemName;
//dr["Company"] = items.Companyname;
//dr["Quantity"] = item.Quantity;
dt = (DataTable)ViewState["Records"];
dt.Rows.Add(items.ItemName, items.Companyname, items.Quantity);
stockOutGridView.DataSource = dt;
stockOutGridView.DataBind();
}
BindAllCompany();
BindAllItem(itemId);
}
public ItemCompanyWIseView GetStockOutItem(Item item)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM ItemCompanyWIseView WHERE ItemId =" + item.ItemId + " AND CompanyId =" + item.ComapnyId + "";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
ItemCompanyWIseView aItem = new ItemCompanyWIseView();
while (reader.Read())
{
aItem.ItemName = reader["ItemName"].ToString();
aItem.Companyname = reader["COmpanyName"].ToString();
}
aItem.Quantity = item.Quantity;
connection.Close();
return(aItem);
}
