public int GetStockOutQuantityByItemId(int itemId)
{
SqlConnection connection = new SqlConnection(connectionString);
connection.ConnectionString = connectionString;
string query = "SELECT * FROM Total_StockOut WHERE ItemId='" + itemId + "'";
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
StockOutM aStockOutM = new StockOutM();
aStockOutM.SellQuantity = (int)reader["StockOutQuantity"];
//int quantity = (int) reader["StockOutQuantity"];
int quantity = aStockOutM.SellQuantity;
return(quantity);
}
else
{
return(0);
}
}
public StockOutM GetDummyAvailableItemQuantityById(int itemId)
{
SqlConnection connection = new SqlConnection(connectionString);
connection.ConnectionString = connectionString;
string query = "SELECT * FROM DummyAvailableQuantity WHERE ItemId='" + itemId + "'";
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
StockOutM aStockOutM = new StockOutM();
aStockOutM.DummyAvailableQuantity = (int)reader["AvailableQuantity"];
//int quantity = (int) reader["StockOutQuantity"];
//int quantity = aStockOutM.SellQuantity;
return(aStockOutM);
}
else
{
StockOutM aStockOutM = new StockOutM();
aStockOutM.DummyAvailableQuantity = 0;
return(aStockOutM);
}
}
protected void addButton_Click(object sender, EventArgs e)
{
int itemId = Convert.ToInt32(stockOutItemDropDownList.SelectedValue);
//Item aItem = aItemManager.GetItemById(itemId);
//int totalstockOutQuantity = aStockOutManager.GetStockOutQuantityByItemId(itemId);
//int availableQuentity = aItem.Quantity - totalstockOutQuantity;
int stockOutQuantity = Convert.ToInt32(stockOutQuantityTextBox.Text);
DateTime date = Convert.ToDateTime(DateTime.Now.ToString("M/d/yyyy"));
//DateTime date = Convert.ToDateTime(DateTime.Today.ToString("dd-MM-yyyy"));
// DataTable table=null;
// List<StockOutM> stockOuts = null;
StockOutM aStockOutM = new StockOutM();
aStockOutM = aStockOutManager.GetDummyAvailableItemQuantityById(itemId);
if (ViewState["dictionary"] == null)
{
dummyDictionary = new Dictionary <int, int>();
}
else
{
dummyDictionary = (Dictionary <int, int>)ViewState["dictionary"];
//dummyDictionary.Add(itemId, aStockOutM.DummyAvailableQuantity);
}
if (!dummyDictionary.ContainsKey(itemId))
{
//dummyDictionary.Add(itemId, aStockOutM.DummyAvailableQuantity - stockOutQuantity);
//ViewState["dictionary"] = dummyDictionary;
//if (dummyDictionary[itemId] >= 0)
if (aStockOutM.DummyAvailableQuantity - stockOutQuantity >= 0)
{
stockOutMsgLabel.Text = "";
dummyDictionary.Add(itemId, aStockOutM.DummyAvailableQuantity - stockOutQuantity);
ViewState["dictionary"] = dummyDictionary;
if (ViewState["list"] == null)
{
stockOuts = new List <StockOutM>();
//dt = (List<DataTable>) ViewState["dt"];
}
else
{
stockOuts = (List <StockOutM>)ViewState["list"];
//DataTable table = new DataTable();
}
StockOutM aStockOut = new StockOutM();
//aSell.Type = "sdff";
aStockOut.Date = date;
aStockOut.ItemId = itemId;
aStockOut.ItemName = stockOutItemDropDownList.SelectedItem.Text;
aStockOut.CompanyName = stockOutCompanyDropDownList.SelectedItem.Text;
aStockOut.SellQuantity = Convert.ToInt32(stockOutQuantityTextBox.Text);
stockOuts.Add(aStockOut);
ViewState["list"] = stockOuts;
stockOutGridView.DataSource = stockOuts;
stockOutGridView.DataBind();
}
else
{
stockOutMsgLabel.Text = "The item is not in Enough quantity";
}
}
else
{
foreach (KeyValuePair <int, int> aKeyValuePair in dummyDictionary)
{
if (aKeyValuePair.Key == itemId)
{
int value = aKeyValuePair.Value - stockOutQuantity;
// Update dictionary value
if (value >= 0)
{
dummyDictionary.Remove(aKeyValuePair.Key);
dummyDictionary.Add(aKeyValuePair.Key, value);
}
//dummyDictionary.Add(aKeyValuePair.Key, value);
ViewState["dictionary"] = dummyDictionary;
if (value >= 0)
{
stockOutMsgLabel.Text = "";
if (ViewState["list"] == null)
{
stockOuts = new List <StockOutM>();
//dt = (List<DataTable>) ViewState["dt"];
}
else
{
stockOuts = (List <StockOutM>)ViewState["list"];
//DataTable table = new DataTable();
}
StockOutM aStockOut = new StockOutM();
//aSell.Type = "sdff";
aStockOut.Date = date;
aStockOut.ItemId = itemId;
aStockOut.ItemName = stockOutItemDropDownList.SelectedItem.Text;
aStockOut.CompanyName = stockOutCompanyDropDownList.SelectedItem.Text;
aStockOut.SellQuantity = Convert.ToInt32(stockOutQuantityTextBox.Text);
stockOuts.Add(aStockOut);
ViewState["list"] = stockOuts;
stockOutGridView.DataSource = stockOuts;
stockOutGridView.DataBind();
}
else
{
stockOutMsgLabel.Text = "The item is not in Enough quantity";
}
break;
}
}
}
//Dictionary<int,int> dummyDictionary = new Dictionary<int, int>();
//dummyDictionary.Add(itemId, aStockOutM.DummyAvailableQuantity);
//if (aStockOutM.DummyAvailableQuantity - stockOutQuantity >= 0)
//{
// // aStockOutManager.SaveDummyUpdatedAvailableQuantity(itemId, aStockOutM.DummyAvailableQuantity - stockOutQuantity);
//}
//else
//{
// Response.Write("The Item is Stock Out.");
//}
stockOutQuantityTextBox.Text = "";
}
