Commit: Changes by Vivek

I have commited whatever i have changed in project. check it. and i changed a procedure "getAllVendor" as

CREATE DEFINER=`root`@`localhost` PROCEDURE `getAllVendors`()
    NO SQL
SELECT v.VendorName,v.UserName,v.Status, c.CityName, a.AreaName, v.MobileNo, v.EmailID, v.Lane, v.OwnerName, v.LandlineNo 
FROM vendor v, city c, area a
WHERE v.areaID=a.areaID 
AND a.CityID=c.CityID