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