protected void btnMoveStockMovement_Click(object sender, EventArgs e) { string strBatchID = ProductRMDownList.SelectedValue; string strWarehouseID = FromWarehouseDropDownList.SelectedValue; string strLocationID = FromLocationDropDownList.SelectedValue; string strIsProduct = rbStockMovement.SelectedValue; SqlData.SelectCommand = "SELECT StockPile.Quantity, StockPile.Created_Date FROM StockPile INNER JOIN FinishedProduct ON FinishedProduct.Batch_ID = StockPile.Batch_ID AND StockPile.Batch_ID ='" + strBatchID + "' AND StockPile.Warehouse_ID ='" + strWarehouseID + "' AND StockPile.Location_ID ='" + strLocationID + "' INNER JOIN Product ON FinishedProduct.Product_ID = Product.Product_ID INNER JOIN Location ON StockPile.Location_ID = Location.Location_ID"; DataSourceSelectArguments dsArguments = new DataSourceSelectArguments(); DataView dvView = new DataView(); SqlStockPile.InsertParameters["Batch_ID"].DefaultValue = ProductRMDownList.SelectedValue; SqlStockPile.InsertParameters["Warehouse_ID"].DefaultValue = TowarehouseDropDownList.SelectedValue; SqlStockPile.InsertParameters["Location_ID"].DefaultValue = ToLocationDropDownList.SelectedValue; SqlStockPile.InsertParameters["Quantity"].DefaultValue = ToQuantityTextBox.Text.Trim(); SqlStockPile.InsertParameters["Created_Date"].DefaultValue = System.DateTime.Now.ToShortDateString(); SqlStockPile.InsertParameters["Is_Product"].DefaultValue = rbStockMovement.SelectedValue; SqlStockPile.Insert(); dvView = (DataView)SqlData.Select(dsArguments); string strQty = dvView[0].Row["Quantity"].ToString(); string strCreatedDate = dvView[0].Row["Created_Date"].ToString(); int intQty = Convert.ToInt32(strQty); int intToQty = Convert.ToInt32(ToQuantityTextBox.Text); if (intToQty != intQty) { dsArguments = new DataSourceSelectArguments(); dvView = new DataView(); SqlData.SelectCommand = "SELECT Entry_ID from StockPile where Batch_ID ='" + strBatchID + "' AND Warehouse_ID ='" + strWarehouseID + "' AND Location_ID ='" + strLocationID + "' AND Quantity ='" + strQty + "' and Is_Product ='" + strIsProduct + "'"; dvView = (DataView)SqlData.Select(dsArguments); string EntryID = dvView[0].Row["Entry_ID"].ToString(); SqlStockPile.UpdateParameters["Batch_ID"].DefaultValue = ProductRMDownList.SelectedValue; SqlStockPile.UpdateParameters["Warehouse_ID"].DefaultValue = FromWarehouseDropDownList.SelectedValue; SqlStockPile.UpdateParameters["Location_ID"].DefaultValue = FromLocationDropDownList.SelectedValue; SqlStockPile.UpdateParameters["Quantity"].DefaultValue = Convert.ToString(intQty - intToQty); SqlStockPile.UpdateParameters["Created_Date"].DefaultValue = strCreatedDate; SqlStockPile.UpdateParameters["Is_Product"].DefaultValue = rbStockMovement.SelectedValue; SqlStockPile.UpdateParameters["Entry_ID"].DefaultValue = EntryID; SqlStockPile.Update(); } else { SqlData.SelectCommand = "SELECT Entry_ID from StockPile where Batch_ID ='" + strBatchID + "' AND Warehouse_ID ='" + strWarehouseID + "' AND Location_ID ='" + strLocationID + "' AND Quantity ='" + strQty + "' and Is_Product ='" + strIsProduct + "'"; dvView = (DataView)SqlData.Select(dsArguments); string EntryID = dvView[0].Row["Quantity"].ToString(); SqlStockPile.SelectCommand = "DELETE FROM [StockPile] WHERE [Entry_ID] ='" + EntryID; SqlStockPile.Delete(); } gvStockMovement.DataBind(); PaneladdStockMovement.Visible = false; Panel1.Visible = false; PanelgvStockMovement.Visible = true; TowarehouseDropDownList.SelectedIndex = -1; ToQuantityTextBox.Text = String.Empty; ToLocationDropDownList.SelectedIndex = -1; }
protected void btnSave_Click(object sender, EventArgs e) { string strBatch = BatchIDDropDownList.SelectedValue; string strWarehouse = WarehouseIDDropDownList.SelectedValue; string strLocation = LocationIDDropDownList.SelectedValue; SqlData.SelectCommand = "SELECT SUM(StockPile.Quantity) AS Quantity FROM StockPile INNER JOIN FinishedProduct ON FinishedProduct.Batch_ID = StockPile.Batch_ID AND StockPile.Batch_ID ='" + strBatch + "' AND StockPile.Warehouse_ID ='" + strWarehouse + "' AND StockPile.Location_ID ='" + strLocation + "' INNER JOIN Product ON FinishedProduct.Product_ID = Product.Product_ID INNER JOIN Location ON StockPile.Location_ID = Location.Location_ID"; DataSourceSelectArguments dsArguments = new DataSourceSelectArguments(); DataView dvView = new DataView(); int count = dvView.Count; dvView = (DataView)SqlData.Select(dsArguments); string strQty = dvView[0].Row["Quantity"].ToString(); SqlStockPile.InsertParameters["Batch_ID"].DefaultValue = BatchIDDropDownList.SelectedValue; SqlStockPile.InsertParameters["Warehouse_ID"].DefaultValue = WarehouseIDDropDownList.SelectedValue; SqlStockPile.InsertParameters["Location_ID"].DefaultValue = LocationIDDropDownList.SelectedValue; SqlStockPile.InsertParameters["Quantity"].DefaultValue = Convert.ToString(-Convert.ToInt32(QuantityTextBox1.Text)); SqlStockPile.InsertParameters["Created_Date"].DefaultValue = System.DateTime.Today.ToShortDateString(); SqlStockPile.InsertParameters["Is_Product"].DefaultValue = "True"; SqlStockPile.InsertParameters["Quotation_Number"].DefaultValue = (string)Session["Quotation_number"]; SqlStockPile.Insert(); SqlData.SelectCommand = "SELECT Quotes_ID FROM Quotes where Quotes.product_id ='" + dropProductId.SelectedValue + "' and Quotes.Quotation_Number ='" + (string)Session["Quotation_number"] + "'"; dsArguments = new DataSourceSelectArguments(); dvView = new DataView(); count = dvView.Count; dvView = (DataView)SqlData.Select(dsArguments); string strQuotesid = dvView[0].Row["Quotes_ID"].ToString(); if (Convert.ToInt32(QuantityTextBox1.Text) <= Convert.ToInt32(strQty)) { SqlContainsIsInventoryUpdated.UpdateParameters["Is_InventoryUpd"].DefaultValue = "True"; SqlContainsIsInventoryUpdated.UpdateParameters["Shipped_Quantity"].DefaultValue = QuantityTextBox1.Text; SqlContainsIsInventoryUpdated.UpdateParameters["Quotes_ID"].DefaultValue = strQuotesid; SqlContainsIsInventoryUpdated.Update(); } else { SqlContainsUpdate.UpdateParameters["Shipped_Quantity"].DefaultValue = QuantityTextBox1.Text; SqlContainsIsInventoryUpdated.UpdateParameters["Quotes_ID"].DefaultValue = strQuotesid; SqlContainsUpdate.Update(); } GridViewQuotation.DataBind(); QuantityTextBox1.Text = string.Empty; QuantityTextBox.Text = string.Empty; BatchIDDropDownList.SelectedIndex = -1; WarehouseIDDropDownList.SelectedIndex = -1; LocationIDDropDownList.SelectedIndex = -1; }
protected void btnSaveStockPile_Click(object sender, EventArgs e) { if (rbStockPile.SelectedValue == "true") { SqlData.SelectCommand = "SELECT Available_Quantity FROM FinishedProduct WHERE Batch_ID =" + BatchIDDropDownList.SelectedValue; } else { SqlData.SelectCommand = "SELECT Available_Quantity FROM ProcuredRawMaterial WHERE Batch_ID =" + BatchIDDropDownList.SelectedValue; } DataSourceSelectArguments dsArguments = new DataSourceSelectArguments(); DataView dvView = new DataView(); string str = dvView.Count.ToString(); dvView = (DataView)SqlData.Select(dsArguments); string strAvailableQty = dvView[0].Row["Available_Quantity"].ToString(); AvailableQuantityTextBox.Text = strAvailableQty; SqlStockPile.InsertParameters["Batch_ID"].DefaultValue = BatchIDDropDownList.SelectedValue; SqlStockPile.InsertParameters["Warehouse_ID"].DefaultValue = WarehouseIDDropDownList.SelectedValue; SqlStockPile.InsertParameters["Location_ID"].DefaultValue = LocationIDDropDownList.SelectedValue; SqlStockPile.InsertParameters["Quantity"].DefaultValue = QuantityTextBox.Text.ToUpper().Trim(); SqlStockPile.InsertParameters["Created_Date"].DefaultValue = CreatedDateTextBox.Text.ToUpper().Trim(); SqlStockPile.InsertParameters["Is_Product"].DefaultValue = rbStockPile.SelectedValue; SqlStockPile.Insert(); gvStockPile.DataBind(); if (rbStockPile.SelectedValue == "false") { SqlUpdateAvailableRMQty.UpdateParameters["Available_Quantity"].DefaultValue = Convert.ToString(Convert.ToInt32(AvailableQuantityTextBox.Text) - Convert.ToInt32(QuantityTextBox.Text)); SqlUpdateAvailableRMQty.UpdateParameters["Batch_ID"].DefaultValue = BatchIDDropDownList.SelectedValue;; if (Convert.ToInt32(AvailableQuantityTextBox.Text) - Convert.ToInt32(QuantityTextBox.Text) == 0) { SqlUpdateAvailableRMQty.UpdateParameters["Is_Stock_Piled"].DefaultValue = "TRUE"; } else { SqlUpdateAvailableRMQty.UpdateParameters["Is_Stock_Piled"].DefaultValue = "FALSE"; } SqlUpdateAvailableRMQty.Update(); } else if (rbStockPile.SelectedValue == "true") { SqlUpdateAvailableQty.UpdateParameters["Available_Quantity"].DefaultValue = Convert.ToString(Convert.ToInt32(AvailableQuantityTextBox.Text) - Convert.ToInt32(QuantityTextBox.Text)); SqlUpdateAvailableQty.UpdateParameters["Batch_ID"].DefaultValue = BatchIDDropDownList.SelectedValue;; if (Convert.ToInt32(AvailableQuantityTextBox.Text) - Convert.ToInt32(QuantityTextBox.Text) == 0) { SqlUpdateAvailableQty.UpdateParameters["Is_Stock_Piled"].DefaultValue = "TRUE"; } else { SqlUpdateAvailableQty.UpdateParameters["Is_Stock_Piled"].DefaultValue = "FALSE"; } SqlUpdateAvailableQty.Update(); } PaneladdStockPile.Visible = false; PanelgvStockPile.Visible = true; BatchIDDropDownList.SelectedIndex = -1; WarehouseIDDropDownList.SelectedIndex = -1; LocationIDDropDownList.SelectedIndex = -1; QuantityTextBox.Text = String.Empty; CreatedDateTextBox.Text = String.Empty; }