Minimize on close, but only from X

Question

Hi, I want to prevent my main Form from closing when the X in the upper right is pressed. I am handling the Closing event, and can change the CancelEventArgs.Cancel to true. The problem is I don't want to prevent the user from closing the Form using the Exit option in the menu. The Exit menu just calls this.Close() at the moment. Should the Exit menu call something else? Or is there a way to differenciate who initiated the call? During either operation, the "sender" to the Closing event is the Form. I guess I could just set a bool value on the Form that tells me not to exit the application, then set the value to say exit the application during the menu Exit, just before calling this.Close(). Is there a cleaner way of doing this?

Answer 1

Hi Anoop,

 

Please try this SQL and let me know if it works for you

 

declare @storeid bigint
set @storeid=19
select  I.NameOfStores, I.ReferenceNo, SUM(Inwards.InwardQty) InwardQty,  SUM(ISNULL(Issued.IssuedQty,0)) IssuedQty, SUM((ISNULL(Inwards.InwardQty,0)-ISNULL(Issued.IssuedQty,0)))as Balance
from InventoryInwards as I
LEFT JOIN
        (select ReferenceNo,  nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as InwardQty
        from InventoryInwards where StoreID=@storeid
        group By NameOfStores, ReferenceNo, Unit) as Inwards ON I.NameOfStores = Inwards.NameOfStores
        and i.ReferenceNo=Inwards.ReferenceNo

left JOIN
        (select   nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as IssuedQty
        from InventoryIssued where StoreID=@storeid
        group By NameOfStores, ReferenceNo, unit) as Issued on I.NameOfStores= Issued.NameOfStores



where i.StoreID = @storeid
group by I.NameOfStores, I.ReferenceNo, I.Unit

Answer 2

Thanks Ankit... that was I missing out.