public int ProjeID(String projeAdi)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Controller.cnnVal("DB1")))
{
return(SQL_Commands.SelectID(projeAdi, "Proje_Adi", "ID_Proje", "Projeler"));
}
}
public int personelID(String personelAdi)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Controller.cnnVal("DB1")))
{
return(SQL_Commands.SelectID(personelAdi, "Isim", "ID_Personel", "Personel"));
}
}
/*
* ürün takip tableına erişim metodları
*/
public int UrunID(String SeriNo)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Controller.cnnVal("DB1")))
{
return(SQL_Commands.SelectID(SeriNo, "Urun_Seri_No", "ID_Urun", "Urun"));
}
}