public int GetAvailableQty(string itemno,string newcon="P",bool usenewcon=false)
{
var ta = new DsInventoryTableAdapters.STOCKMASTERTableAdapter { Connection = { ConnectionString = usenewcon ?newcon: _constr } };
return Convert.ToInt32(ta.GetAvailableQty(itemno));
}