public void ExecuteSqlCommand(string name, List<KeyValuePair<string, string>> data)
{
StringBuilder strkeys = new StringBuilder();
StringBuilder strvalues = new StringBuilder();
strkeys.Append("(");
strvalues.Append("(");
for (int i=0; i<data.Count; i++)
{
KeyValuePair<string, string> keyvalue = data[i];
strkeys.Append(string.Format("`{0}`", keyvalue.Key));
strvalues.Append(string.Format("'{0}'", keyvalue.Value));
if (i<(data.Count -1))
{
strkeys.Append(",");
strvalues.Append(",");
}
}
strkeys.Append(")");
strvalues.Append(")");
string k = strkeys.ToString();
string v = strvalues.ToString();
string query = string.Format("INSERT INTO `{0}`.`{1}` {2} VALUES {3}", Program.dbname, name, k, v);
try
{
context.Database.ExecuteSqlCommand(query);
MessageBox.Show("Data Saved...");
}
catch (Exception e)
{
MessageBox.Show(e.Message);
context.Dispose();
context = Program.CreateConnection();
}
}
public static DatabaseContext CreateConnection()
{
//pass = "******";
DbProviderFactory factory = DbProviderFactories.GetFactory("MySql.Data.MySqlClient");
string connectionString = string.Format("Server=localhost; port=3306; Database={0}; Uid=root; Pwd={1}", dbname, pass);
DbConnection conn = factory.CreateConnection();
conn.ConnectionString = connectionString;
//conn.Open();
DatabaseContext _context = null;
try
{
_context = new DatabaseContext(conn);
_context.Database.CreateIfNotExists();
return _context;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
Console.WriteLine("Enter MySQL Password...");
pass = Console.ReadLine();
try
{
return CreateConnection();
}
catch (Exception)
{
throw;
}
}
}
public UnitOfWork()
{
context = Program.CreateConnection();
//context = new DatabaseContext();
}
