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