public static void Ekle(EDatabase Geliyor)
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Veritabani\\Data.mdb;Jet OLEDB:Database Password=ayakkabi_gelisimsoft;");
OleDbCommand com = new OleDbCommand("insert into Databasem (Ad,Tarih,Timecik) values(@Ad,@Tarih,@Timecik)", con);
com.Parameters.AddWithValue("@Ad", Geliyor.Ad);
com.Parameters.AddWithValue("@Tarih", Geliyor.Tarih);
com.Parameters.AddWithValue("@Timecik", Geliyor.Timecik);
if (com.Connection.State == ConnectionState.Closed)
{
con.Open();
}
try
{
com.ExecuteNonQuery();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.ToString(), "Hata", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
con.Close();
}
}
private void button2_Click(object sender, EventArgs e)
{
string AnaDosyayol = Application.StartupPath + "\\Veritabani\\Data.mdb";
try
{
int saat, dakika;
DateTime date = DateTime.Now;
saat = date.Hour;
dakika = date.Minute;
EDatabase dt = new EDatabase();
dt.Ad = yol;
dt.Tarih = date.Date;
dt.Timecik = Convert.ToString(saat + ":" + dakika);
FDatabase.Ekle(dt);
System.IO.File.Copy(AnaDosyayol, yol + ".mdb");
MessageBox.Show("Yedek '" + yol + "' kaydedildi.", "Yedek Alma İşlemi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Yedekleme işlemi sırasında bir hata oluştu!" + ex.Message);
}
finally
{
con.Close();
this.Close();
}
}
public static AbstractConnector CreateConnector(EDatabase type, ICanConnectToDabase connection)
{
switch (type)
{
case EDatabase.SQLServer:
return(new SQLConnector(connection.IpDoBanco, connection.NomeDoBanco, connection.Usuario, connection.Senha));
default:
throw new ArgumentOutOfRangeException($"Tipo {type} não programado!");
}
}
public IConnectionFactory GetConnectionDatabase(EDatabase enuDatabase, string strConn)
{
switch (enuDatabase)
{
case EDatabase.Postgres:
return(null);
case EDatabase.SqlServer:
return(new SqlServerConnection(strConn));
default:
return(null);
}
}
public RegionPersistentObject(EDatabase database, string connectionString, TableMetadata mainTable) : base(database, connectionString, mainTable)
{
}
internal static string GetConnectionString(EDtxReaderType connType, string un, string pw, string server, EDatabase database)
{
string retv = string.Format(ConnStrBaseFormatter, server, un, pw, database.ToString());
switch(connType)
{
case EDtxReaderType.Adapter:
case EDtxReaderType.Reader:
case EDtxReaderType.ReaderSafe:
retv += OdbcDSN;
break;
default:
break;
}
return retv;
}
internal static IDbConnection GetConnection(EDtxReaderType connType, string un, string pw, string server, EDatabase db)
{
IDbConnection conn = null;
string connStr = GetConnectionString(connType, un, pw, server, db);
if (string.IsNullOrWhiteSpace(connStr) == false)
{
conn = GetConnectionObject(connType);
conn.ConnectionString = connStr;
}
return conn;
}
public ConnectionBuilder WithDatabase(EDatabase enuDatabase)
{
_enuDatabase = enuDatabase;
return(this);
}
public static SqlConnection Create(EDatabase database)
{
return(new SqlConnection(__cConnectionStrings[database]));
}
internal static string GetConnectionString(EDtxReaderType connType, string un, string pw, string server, EDatabase database)
{
string retv = string.Format(ConnStrBaseFormatter, server, un, pw, database.ToString());
switch (connType)
{
case EDtxReaderType.Adapter:
case EDtxReaderType.Reader:
case EDtxReaderType.ReaderSafe:
retv += OdbcDSN;
break;
default:
break;
}
return(retv);
}
internal static IDbConnection GetConnection(EDtxReaderType connType, string un, string pw, string server, EDatabase db)
{
IDbConnection conn = null;
string connStr = GetConnectionString(connType, un, pw, server, db);
if (string.IsNullOrWhiteSpace(connStr) == false)
{
conn = GetConnectionObject(connType);
conn.ConnectionString = connStr;
}
return(conn);
}
