private void lostButton_Click(object sender, EventArgs e)
{
try
{
StockOutItem stcOutItmObj = new StockOutItem();
StockOutSellManager sellManager = new StockOutSellManager();
for (int i = 0; i < stockOutDataGridView.Rows.Count - 1; i++)
{
stcOutItmObj.Item = stockOutDataGridView.Rows[i].Cells[1].Value.ToString();
stcOutItmObj.Category = stockOutDataGridView.Rows[i].Cells[2].Value.ToString();
stcOutItmObj.Company = stockOutDataGridView.Rows[i].Cells[3].Value.ToString();
stcOutItmObj.StockOutQuantity = Convert.ToInt32(stockOutDataGridView.Rows[i].Cells[4].Value.ToString());
stcOutItmObj.Id = Convert.ToInt32(3);
stcOutItmObj.SellDate = DateTime.Today;
bool sellInfo = sellManager.SellItem(stcOutItmObj);
if (sellInfo == false)
{
MessageBox.Show("Save Failed");
return;
}
}
stockOutDataGridView.Rows.Clear();
stockOutDataGridView.Refresh();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}
public bool SellItem(StockOutItem stcOutItmObj)
{
bool sellInfo = false;
string connectionString =
@"Server=DESKTOP-063GM06\SQLEXPRESS;Database=STOCKMANAGEMENTSYSTEM;Integrated Security=true";
string query = @"UPDATE Items SET AvailableQuantity=(AvailableQuantity-" + stcOutItmObj.StockOutQuantity +
")WHERE Item='" + stcOutItmObj.Item + "' AND Company='" + stcOutItmObj.Company + "'";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand comd = new SqlCommand(query, conn);
conn.Open();
comd.ExecuteNonQuery();
conn.Close();
query = @"INSERT INTO Stockouts(Id,Item,Category,Company,Quantity,Date)VALUES(" + stcOutItmObj.Id + ",'" + stcOutItmObj.Item + "','" + stcOutItmObj.Category + "','" + stcOutItmObj.Company + "'," + stcOutItmObj.StockOutQuantity + ",'" + stcOutItmObj.SellDate + "')";
comd = new SqlCommand(query, conn);
conn.Open();
int rowAffected = comd.ExecuteNonQuery();
conn.Close();
if (rowAffected > 0)
{
sellInfo = true;
}
return(sellInfo);
}
internal int Saved(StockOutItem value)
{
string query = @"INSERT INTO tblSell (ItemId,CompanyId,QuantityTotal,SellType,SellDate) VALUES('" + value.ItemId + "','" + value.CompanyId + "','" + value.TotalQuantity + "','" + value.SellType + "','" + DateTime.Now + "')";
int rowCount = _dbStockOutRepository.Saved(query);
return(rowCount);
}
internal DataTable CheckDuplecateItem(StockOutItem item)
{
string query = @"SELECT * FROM tblItem WHERE Id='" + item.ItemId + "' AND ReorderLevel<='" + item.TotalQuantity + "'";
DataTable dt = _dbStockOutRepository.CheckAll(query);
return(dt);
}
public bool SellItem(StockOutItem stcOutItmObj)
{
StockOutSellRipository sellRipoObj = new StockOutSellRipository();
bool sellInfo = sellRipoObj.SellItem(stcOutItmObj);
return(sellInfo);
}
public void Saved(StockOutItem value)
{
int isSaved = stockOutManage.Saved(value);
if (isSaved > 0)
{
var takeTotalRemainingItem = itemList.Where(x => x.Id == value.ItemId).FirstOrDefault();
Item item = new Item()
{
Quantity = takeTotalRemainingItem.Quantity - value.TotalQuantity,
Id = value.ItemId
};
takeTotalRemainingItem.Quantity = takeTotalRemainingItem.Quantity - value.TotalQuantity;
ItemManage itemManage = new ItemManage();
itemManage.UpdateItemQuantity(item);
}
}
protected void lostButton_Click(object sender, EventArgs e)
{
if (ViewState["stockOutListVs"] != null)
{
List <StockOutItemViewModel> stockOutItemsViewList =
(List <StockOutItemViewModel>)ViewState["stockOutListVs"];
List <Item> allItems = new List <Item>();
List <StockOutItem> allStockOutItems = new List <StockOutItem>();
foreach (StockOutItemViewModel item in stockOutItemsViewList)
{
Item anitem = new Item();
StockOutItem anStockOutItem = new StockOutItem();
anitem.Id = item.ItemId;
anitem.AvailableQuantity = item.AvailableQuantity;
anStockOutItem.ItemId = item.ItemId;
anStockOutItem.Quantity = item.StockOutQuantity;
anStockOutItem.Date = DateTime.Now.ToString("yyyy-MM-dd");
anStockOutItem.StockOutType = "Lost";
allItems.Add(anitem);
allStockOutItems.Add(anStockOutItem);
}
gridOutputLabel.Text = stockOutManager.SellItems(allItems, allStockOutItems, "Lost");
stockOutGridView.DataSource = null;
stockOutGridView.DataBind();
ViewState["stockOutListVs"] = null;
}
else
{
gridOutputLabel.Text = "Please insert data first";
addOutputLabel.Text = "";
}
}
private DataTable CheckAvailableItem(StockOutItem value)
{
DataTable isSaved = stockOutManage.CheckDuplecateItem(value);
return(isSaved);
}
