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); }