private void SaveButton_Click(object sender, EventArgs e)
{
if (stockQuantityTextBox.Text == "")
{
msgLabel.Text = "Enter a stock unit";
msgLabel.ForeColor = Color.Red;
return;
}
StockOut stockOut = new StockOut();
StockOutVM stockOutVm = new StockOutVM();
//database
stockOut.Item = Convert.ToInt64(itemComboBox.SelectedValue);
stockOut.Company = Convert.ToInt64(companyComboBox.SelectedValue);
stockOut.Quantity = Convert.ToInt64(stockQuantityTextBox.Text);
stockOut.AvailableItems = Convert.ToInt64(availableQuantituLabel.Text);
_stockOuts.Add(stockOut);
//grid only
stockOutVm.Item = itemComboBox.Text;
stockOutVm.Company = companyComboBox.Text;
stockOutVm.StockIn = Convert.ToInt64(stockQuantityTextBox.Text);
_stockOutVms.Add(stockOutVm);
stockOutGridView.DataSource = null;
stockOutGridView.DataSource = _stockOutVms;
}
public List <StockOutVM> GetAllItemBetweenTwoDate(DateTime fromDateTime, DateTime toDateTime)
{
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
string querry = "select I.ItemName [Item Name],sum(S.StockOutQuantity) [Sales Quantity] from StockOut_tbl as S inner Join Item_tbl as I on S.ItemID=I.ItemID where S.StockOutDate between @FromDate and @Todate and Flag='sell' GROUP BY I.ItemName";
SqlCommand cmd = new SqlCommand(querry, connection);
cmd.Parameters.AddWithValue("FromDate", fromDateTime);
cmd.Parameters.AddWithValue("ToDate", toDateTime);
SqlDataReader reader = cmd.ExecuteReader();
List <StockOutVM> aStockOuts = new List <StockOutVM>();
while (reader.Read())
{
StockOutVM aStockOut = new StockOutVM();
aStockOut.ItemName = (string)reader["Item Name"];
aStockOut.StockOutQuantity = (int)reader["Sales Quantity"];
aStockOuts.Add(aStockOut);
}
reader.Close();
connection.Close();
return(aStockOuts);
}
private void AddButton_Click(object sender, EventArgs e)
{
StockOutVM stockOutVm = new StockOutVM();
string avQuantity = availableTextBox.Text;
stockOut.Company = companyComboBox.GetItemText(companyComboBox.SelectedItem);
stockOut.Category = categoryComboBox.GetItemText(companyComboBox.SelectedItem);
stockOut.Item = itemComboBox.GetItemText(itemComboBox.SelectedItem);
stockOut.SOQuantity = stockQuantityTextBox.Text;
stockOut.Reorder = reorderTextBox.Text;
stockOutVm.ItemId = Convert.ToInt32(itemComboBox.SelectedValue);
stockOutVm.CompanyName = companyComboBox.GetItemText(companyComboBox.SelectedItem);
stockOutVm.ItemName = itemComboBox.GetItemText(itemComboBox.SelectedItem);
stockOutVm.StockOutQuantity = stockQuantityTextBox.Text;
if (string.IsNullOrEmpty(stockOut.Item) || string.IsNullOrEmpty(avQuantity) || string.IsNullOrEmpty(stockOut.Reorder))
{
selectItemErrorLabel.Text = "*Please Select Item";
return;
}
selectItemErrorLabel.Text = "";
if (!string.IsNullOrEmpty(errorQuantityLabel.Text))
{
MessageBox.Show("Please Resolve Your Error First!!");
return;
}
if (string.IsNullOrEmpty(stockQuantityTextBox.Text))
{
//MessageBox.Show("stock out must not be empty");
errorQuantityLabel.Text = "*stock out must not be empty!!";
return;
}
if (Convert.ToInt32(avQuantity) < Convert.ToInt32(stockOut.SOQuantity))
{
errorQuantityLabel.Text = "*sorry unavailable Items!!";
return;
}
//Add List
stockoutsiList.Add(stockOut);
stockOutDisplayList.Add(stockOutVm);
//Add Gridview
stockOutDataGridView.DataSource = null;
stockOutDataGridView.DataSource = stockOutDisplayList;
stockOutDataGridView.Columns["ItemId"].Visible = false;
stockQuantityTextBox.Clear();
reorderTextBox.Clear();
availableTextBox.Clear();
itemComboBox.ResetText();
errorQuantityLabel.Text = "";
}
private void SaveButton_Click(object sender, EventArgs e)
{
int er = 0;
ep.Clear();
if (categoryComboBox.Text == "")
{
er++;
ep.SetError(categoryComboBox, "Required");
}
if (companyComboBox.Text == "")
{
er++;
ep.SetError(companyComboBox, "Required");
}
if (itemComboBox.Text == "")
{
er++;
ep.SetError(itemComboBox, "Required");
}
if (er > 0)
{
return;
}
_stockAdd = new StockOut();
StockOutVM stockOutVm = new StockOutVM();
if (stockOutQuantityTextBox.Text.Length < 1)
{
MessageBox.Show("Enter StockOut Quantity.");
return;
}
// For List Class
// For Add Class
_stockAdd.CompanyId = Convert.ToInt64(companyComboBox.SelectedValue);
_stockAdd.CategoryId = Convert.ToInt64(categoryComboBox.SelectedValue);
_stockAdd.ItemId = Convert.ToInt64(itemComboBox.SelectedValue);
_stockAdd.StockOutQuantity = Convert.ToInt32(stockOutQuantityTextBox.Text);
DateTime date = DateTime.Now; // Getting System Date
_stockAdd.StockOutDate = Convert.ToDateTime(date);
// End For Add Class
// ***************** List For display Class ***************
stockOutVm.ItemName = itemComboBox.Text;
stockOutVm.CompanyName = companyComboBox.Text;
stockOutVm.CategoryName = categoryComboBox.Text;
stockOutVm.StockOutQuantity = Convert.ToInt32(stockOutQuantityTextBox.Text);
// ***************** For display Class ***************
stockOutAddList.Add(_stockAdd); // Object for Insert in List
stockOutdisplayList.Add(stockOutVm); // Object for Display in List
itemStockOutDataGridView.DataSource = null;
itemStockOutDataGridView.DataSource = stockOutdisplayList;
// itemStockOutDataGridView.Columns["CampanyId"].Visible = false;
// itemStockOutDataGridView.Columns["CategoryId"].Visible = false;
stockOutQuantityTextBox.Clear();
// This is for show availabe item Qty will be deducted.
int avQty = Convert.ToInt32(availableQuantityLabel.Text);
int stQty = Convert.ToInt32(stockOutVm.StockOutQuantity);
availableQuantityLabel.Text = Convert.ToString(avQty - stQty);
// End This is for show availabe item Qty will be deducted.
}
protected void addButton_Click(object sender, EventArgs e)
{
if (Validation())
{
StockOutVM aStockOutVm = new StockOutVM();
aStockOutVm.CompanyId = Convert.ToInt32(companyDropDownList.SelectedItem.Value);
aStockOutVm.ItemId = Convert.ToInt32(itemDropDownList.SelectedItem.Value);
aStockOutVm.CompanyName = companyDropDownList.SelectedItem.Text;
aStockOutVm.ItemName = itemDropDownList.SelectedItem.Text;
aStockOutVm.StockOutQuantity = Convert.ToInt32(stockOutQuantityTextBox.Text.Trim());
Item aItem = new Item();
aItem = aItemManager.GetItemInfo(aStockOutVm.ItemId);
if (aItem.AvailableQuantity >= aStockOutVm.StockOutQuantity)
{
if (ViewState["StockOutItems"] != null)
{
stockOutsVms = (List <StockOutVM>)ViewState["StockOutItems"];
}
if (stockOutsVms != null)
{
foreach (var item in stockOutsVms)
{
if (item.ItemId == aStockOutVm.ItemId)
{
if (item.StockOutQuantity + aStockOutVm.StockOutQuantity > aItem.AvailableQuantity)
{
messageLabel.Text = "Stock Out Quantity is larger than Available Quantity";
}
else
{
item.StockOutQuantity += aStockOutVm.StockOutQuantity;
}
goto Next;
}
}
}
stockOutsVms.Add(aStockOutVm);
Next:
ViewState["StockOutItems"] = stockOutsVms;
stockOutGridView.DataSource = stockOutsVms;
stockOutGridView.DataBind();
companyDropDownList.SelectedIndex = 0;
itemDropDownList.SelectedIndex = 0;
itemDropDownList.Enabled = false;
stockOutQuantityTextBox.Text = String.Empty;
//sellButton.Enabled = true;
//damageButton.Enabled = true;
//lostButton.Enabled = true;
reorderLevelTextBox.Text = String.Empty;
availableQuantityTextBox.Text = String.Empty;
}
else
{
messageLabel.Text = "Stock Out Quantity is larger than Available Quantity";
//companyDropDownList.SelectedIndex = 0;
//itemDropDownList.SelectedIndex = 0;
//itemDropDownList.Enabled = false;
}
}
}
