public int GetManafacturerIDByManafacturerName(string ManafacturerName)
{
string Query = "SELECT Manafacturer_ID FROM Manafacturers WHERE ManafacturerName = '" + ManafacturerName + "'";
return(DatabaseControlService.GetElementID(Query, 0));
}
public int GetWorkplaceIDByWorkplaceName(string WorkplaceName)
{
string Query = "SELECT Workplace_ID FROM Workplaces WHERE WorkplaceName = '" + WorkplaceName + "'";
return(DatabaseControlService.GetElementID(Query, 0));
}
public int GetGearIDByGearName(string GearName)
{
string Query = "SELECT Gear_ID FROM GearTypes WHERE GearName = '" + GearName + "'";
return(DatabaseControlService.GetElementID(Query, 0));
}
public int GetLanguageIDByLanguageName(string LanguageName)
{
string Query = "SELECT Language_ID FROM Languages WHERE LanguageName = '" + LanguageName + "'";
return(DatabaseControlService.GetElementID(Query, 0));
}
public int GetClassIDByClassName(string ClassName)
{
string Query = "SELECT Class_ID FROM Classes WHERE ClassName = '" + ClassName + "'";
return(DatabaseControlService.GetElementID(Query, 0));
}
public int GetCountryIDByCountryName(string CountryName)
{
string Query = "SELECT Country_ID FROM Countries WHERE CountryName = '" + CountryName + "'";
return(DatabaseControlService.GetElementID(Query, 0));
}
public int GetBodyIDByBodyName(string BodyName)
{
string Query = "SELECT Body_ID FROM BodyTypes WHERE BodyName = '" + BodyName + "'";
return(DatabaseControlService.GetElementID(Query, 0));
}
public int GetOfficeIDByOfficeName(string OfficeName)
{
string Query = "SELECT Office_ID FROM Offices WHERE Office_Name = '" + OfficeName + "'";
return(DatabaseControlService.GetElementID(Query, 0));
}
public int GetClientIDByTelephone(string Telephone)
{
string Query = "SELECT Client_ID FROM Clients WHERE Telephone = '" + Telephone + "'";
return(DatabaseControlService.GetElementID(Query, 0));
}
public int GetSellIDByNoPTC(string NoPTC)
{
string Query = "SELECT Sell_ID FROM Sells WHERE No_PTC = '" + NoPTC + "'";
return(DatabaseControlService.GetElementID(Query, 0));
}
public int GetAutoIDByModel(string Model)
{
string Query = "SELECT Auto_ID FROM AutomobilesData WHERE Model = '" + Model + "'";
return(DatabaseControlService.GetElementID(Query, 0));
}