예제 #1
0
        public int GetManafacturerIDByManafacturerName(string ManafacturerName)
        {
            string Query = "SELECT Manafacturer_ID FROM Manafacturers WHERE ManafacturerName = '" + ManafacturerName + "'";

            return(DatabaseControlService.GetElementID(Query, 0));
        }
예제 #2
0
        public int GetWorkplaceIDByWorkplaceName(string WorkplaceName)
        {
            string Query = "SELECT Workplace_ID FROM Workplaces WHERE WorkplaceName = '" + WorkplaceName + "'";

            return(DatabaseControlService.GetElementID(Query, 0));
        }
예제 #3
0
        public int GetGearIDByGearName(string GearName)
        {
            string Query = "SELECT Gear_ID FROM GearTypes WHERE GearName = '" + GearName + "'";

            return(DatabaseControlService.GetElementID(Query, 0));
        }
예제 #4
0
        public int GetLanguageIDByLanguageName(string LanguageName)
        {
            string Query = "SELECT Language_ID FROM Languages WHERE LanguageName = '" + LanguageName + "'";

            return(DatabaseControlService.GetElementID(Query, 0));
        }
예제 #5
0
        public int GetClassIDByClassName(string ClassName)
        {
            string Query = "SELECT Class_ID FROM Classes WHERE ClassName = '" + ClassName + "'";

            return(DatabaseControlService.GetElementID(Query, 0));
        }
예제 #6
0
        public int GetCountryIDByCountryName(string CountryName)
        {
            string Query = "SELECT Country_ID FROM Countries WHERE CountryName = '" + CountryName + "'";

            return(DatabaseControlService.GetElementID(Query, 0));
        }
예제 #7
0
        public int GetBodyIDByBodyName(string BodyName)
        {
            string Query = "SELECT Body_ID FROM BodyTypes WHERE BodyName = '" + BodyName + "'";

            return(DatabaseControlService.GetElementID(Query, 0));
        }
예제 #8
0
        public int GetOfficeIDByOfficeName(string OfficeName)
        {
            string Query = "SELECT Office_ID FROM Offices WHERE Office_Name = '" + OfficeName + "'";

            return(DatabaseControlService.GetElementID(Query, 0));
        }
예제 #9
0
        public int GetClientIDByTelephone(string Telephone)
        {
            string Query = "SELECT Client_ID FROM Clients WHERE Telephone = '" + Telephone + "'";

            return(DatabaseControlService.GetElementID(Query, 0));
        }
예제 #10
0
        public int GetSellIDByNoPTC(string NoPTC)
        {
            string Query = "SELECT Sell_ID FROM Sells WHERE No_PTC = '" + NoPTC + "'";

            return(DatabaseControlService.GetElementID(Query, 0));
        }
예제 #11
0
        public int GetAutoIDByModel(string Model)
        {
            string Query = "SELECT Auto_ID FROM AutomobilesData WHERE Model = '" + Model + "'";

            return(DatabaseControlService.GetElementID(Query, 0));
        }