public static PanelAyarlari GetPanelAyarlari()
{
object tLockObj = new object();
OleDbCommand command = new OleDbCommand();
OleDbDataReader reader;
string queryString = "";
lock (tLockObj)
{
using (var connection = new OleDbConnection(connectionAdress))
{
try
{
connection.Open();
queryString = "SELECT * FROM PanelAyarlari";
command.CommandText = queryString;
command.Connection = connection;
reader = command.ExecuteReader();
if (reader.Read())
{
var panelAyarlari = new PanelAyarlari
{
CihazID = reader["CihazID"] as int? ?? default(int),
ID = reader["ID"] as int? ?? default(int),
IPAdresi = reader["IPAdresi"].ToString(),
KontorDusumMiktari = reader["KontorDusumMiktari"] as int? ?? default(int),
KopukSuresi = reader["KopukSuresi"] as int? ?? default(int),
PortNumarasi = reader["PortNumarasi"] as int? ?? default(int),
YikamaSuresi = reader["YikamaSuresi"] as int? ?? default(int)
};
return(panelAyarlari);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
}
public static bool UpdatePanelAyarlari(PanelAyarlari panelAyarlari)
{
object tLockObj = new object();
OleDbCommand command = new OleDbCommand();
string queryString = "";
int rowsCount = 0;
lock (tLockObj)
{
using (var connection = new OleDbConnection(connectionAdress))
{
try
{
connection.Open();
queryString = "UPDATE PanelAyarlari SET(CihazID=@cihazID,ID=@id,IPAdresi=@ipAdresi,KontorDusumMiktari=@kontorDusumMiktari,KopukSuresi=@kopukSuresi,PortNumarasi=@portNumarasi,YikamaSuresi=@yikamaSuresi) WHERE ID=@id";
command.Connection = connection;
command.CommandText = queryString;
command.Parameters.AddWithValue("@cihazID", panelAyarlari.CihazID);
command.Parameters.AddWithValue("@id", panelAyarlari.ID);
command.Parameters.AddWithValue("@kontorDusumMiktari", panelAyarlari.KontorDusumMiktari);
command.Parameters.AddWithValue("@kopukSuresi", panelAyarlari.KopukSuresi);
command.Parameters.AddWithValue("@yikamaSuresi", panelAyarlari.YikamaSuresi);
command.Parameters.AddWithValue("@ipAdresi", panelAyarlari.IPAdresi);
command.Parameters.AddWithValue("@portNumarasi", panelAyarlari.PortNumarasi);
rowsCount = command.ExecuteNonQuery();
}
catch (Exception)
{
rowsCount = 0;
}
finally
{
connection.Close();
connection.Dispose();
}
if (rowsCount > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
