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); }