If total Items remaining are more than or equal to selected quantity in inventory out then insert otherwise show alert message that total item remaning are less than selected quantity

Question

0.00/5 (No votes)

See more:

SQL

ALTER PROCEDURE [dbo].[spInventoryOutQuantityCheck]
AS
BEGIN
 Declare @Total_items_remaining int
 Declare @Item_ID int
 Declare @Store_ID int
 Declare @Quentity int
 
 SELECT @Total_items_remaining=@Quentity 
 from Items_Store
 where Item_ID = Item_ID And Store_ID=@Store_ID
 if (@Quentity<@Total_items_remaining)
 begin 
 UPDATE dbo.Items_Store
    SET @Total_items_remaining = @Total_items_remaining - @Quentity
    WHERE Item_ID = @Item_ID And Store_ID=@Store_ID
 end    
end

jquey for calling sp

JavaScript

$('#MainHolder_txtQuantity').focusout(function () {
        var quantity=$(this).val();
        var item = $('#MainHolder_ddItems').val();
        var store = $('#MainHolder_ddStores').val();
        var data = SilkSchoolWebService.spInventoryOutQuantityCheck(Item_ID, Store_ID);

        if (quantity > data)
            alert("Items out of stock");
        else
        {

        }
    });

Posted 15-Feb-15 22:13pm

zaiby

Updated 15-Feb-15 22:50pm

Suvendu Shekhar Giri

v7

Add a Solution

Comments

Kornfeld Eliyahu Peter 16-Feb-15 4:52am

What is your question?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Answer 1 · 2015-02-15T22:56:00

Solution 2

You are missing the trick here

SQL

SELECT @Total_items_remaining=@Quentity
FROM Items_Store
WHERE Item_ID = Item_ID AND Store_ID=@Store_ID

This should be -

SQL

SELECT @Total_items_remaining=Quantity --Quanity/AvailableQuantity/Balance field of Items_Store table
FROM Items_Store
WHERE Item_ID = Item_ID AND Store_ID=@Store_ID

Hope, it helps :)

Posted 15-Feb-15 22:56pm

Suvendu Shekhar Giri

Updated 15-Feb-15 22:59pm

v2

Comments

[no name] 16-Feb-15 5:06am

not works for me but thanku for ur attention

Suvendu Shekhar Giri 16-Feb-15 5:10am

May be you need to sum out the "quantity out" values and then deduct that from the sum of "quantity in" values. If I can help anyway, please let me know :)

[no name] 16-Feb-15 5:12am

this is sp it checks if item remaining not exist then show alert message using jquery
AS
BEGIN
Declare @Total_items_remaining int
Declare @Item_ID int
Declare @Store_ID int
Declare @Quentity int
if EXISTS (select Total_items_remaining from Items_Store where Total_items_remaining=@Total_items_remaining)
Return 1
else
return 0
end

[no name] 16-Feb-15 5:12am

this is jquery code
$('#MainHolder_txtQuantity').focusout(function () {

var quantity = $('#MainHolder_txtQuantity').val();
var itemID = $('#MainHolder_ddItems').val();
var storeID = $('#MainHolder_ddStores').val();
//alert(itemID);

SilkSchoolWebService.spInventoryOutQuantityCheck(itemID, storeID);
//if (quantity > data)
// alert("Items out of stock");
//else
//{

//}