protected void lostButton_Click(object sender, EventArgs e)
{
StockOutSell stockOutSell = new StockOutSell();
if (ViewState["stockOutVS"] == null && ViewState["stockInVS"] == null)
{
outputLabelForSubtract.Text = "Please add in the grid first !";
}
else
{
List <StockOut> stockOutSellList = (List <StockOut>)ViewState["stockOutVS"];
List <StockIn> stockInSellList = (List <StockIn>)ViewState["stockInVS"];
foreach (var stockInlistVar in stockInSellList)
{
outputLabelForSubtract.Text = stockInManager.DeleteManager(stockInlistVar);
}
int companyid = Convert.ToInt32(companyDropDownList.SelectedValue);
int itemid = Convert.ToInt32(itemDropDownList.SelectedValue);
reorderLevelTextBox.Text = itemSetupManager.GetReorderLevelByDropDown(companyid);
availableQuantityTextBox.Text = stockInManager.GetQuantityByDropDown(companyid, itemid);
ViewState["stockOutVS"] = null;
ViewState["stockInVS"] = null;
stockOutGridView.DataSource = null;
stockOutGridView.DataBind();
}
stockOutQuantityTextBox.Text = "";
//availableQuantityTextBox.Text = "";
//reorderLevelTextBox.Text = "";
}
public int SaveSellGateway(StockOutSell stockOutSell)
{
//INSERT INTO StockOutSell VALUES(2,2,'2018-05-04 21:46:12')
string query = "INSERT INTO StockOutSell VALUES(" + stockOutSell.ItemId + "," + stockOutSell.Sell + ",'" + stockOutSell.Date + "')";
Command = new SqlCommand(query, Connection);
Connection.Open();
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
public string SaveSellManager(StockOutSell stockOutSell)
{
int row = stockOutSellGateway.SaveSellGateway(stockOutSell);
if (row > 0)
{
return("Save Sell item Successful !");
}
else
{
return("Saving Sell item Failed !");
}
}
protected void sellButton_Click(object sender, EventArgs e)
{
StockOutSell stockOutSell = new StockOutSell();
if (ViewState["stockOutVS"] == null && ViewState["stockInVS"] == null)
{
outputLabelForSubtract.Text = "Please add in the grid first !";
}
else
{
List <StockOut> stockOutSellList = (List <StockOut>)ViewState["stockOutVS"];
List <StockIn> stockInSellList = (List <StockIn>)ViewState["stockInVS"];
foreach (var stockInlistVar in stockInSellList)
{
stockOutSell.ItemId = stockInlistVar.ItemId;
stockOutSell.Sell = stockInlistVar.StockQuantity; // sell koto hocche ta rakhlam
DateTime time = DateTime.Now; // Use current time
string dateTime = time.ToString("yyyy-MM-dd HH':'mm':'ss"); // modify the format depending upon input required in the column in database
stockOutSell.Date = dateTime;
stockOutSellManager.SaveSellManager(stockOutSell);
outputLabelForSubtract.Text = stockInManager.DeleteManager(stockInlistVar);
}
int companyid = Convert.ToInt32(companyDropDownList.SelectedValue);
int itemid = Convert.ToInt32(itemDropDownList.SelectedValue);
reorderLevelTextBox.Text = itemSetupManager.GetReorderLevelByDropDown(companyid);
availableQuantityTextBox.Text = stockInManager.GetQuantityByDropDown(companyid, itemid);
ViewState["stockOutVS"] = null;
ViewState["stockInVS"] = null;
stockOutGridView.DataSource = null;
stockOutGridView.DataBind();
}
stockOutQuantityTextBox.Text = "";
}