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"));
}
}
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"));
}
}
/*
* ü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"));
}
}
public String GetUrunModelFromSeri(String SeriNo)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Controller.cnnVal("DB1")))
{
return(SQL_Commands.StrOneStrParamOneRet("Urun_Model", "Urun_Seri_No", SeriNo));
}
}
public int GetUrunAdet(String seriNo)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Controller.cnnVal("DB1")))
{
return(SQL_Commands.IntOneParamOneRet("Urun_Adet", "Urun_Seri_No", seriNo));
}
}
public void DeletePersonelUrun(int ID_Urun, int ID_Personel, int ID_Proje)
{
SQL_Commands.DeleteRow2Conint("Personel_Takip", "ID_Urun", "ID_Personel", "ID_Proje", ID_Urun, ID_Personel, ID_Proje);
}