private void Guardar(object sender, RoutedEventArgs e)
{
try
{
if (string.IsNullOrEmpty(this.Model.Configuration.Empresa))
{
CustomMessageBox.Show("Debe indicar un nombre para esta cadena.", "La conexión no es valida", CustomMessageBoxButton.OK, CustomMessageBoxImage.Warning);
return;
}
var SqlServer = new SQLServerConnection(this.Model.ConnectionString);
SqlServer.ConnectionString = new SqlConnectionStringBuilder(this.Model.ConnectionString);
if (SqlServer.TestConnection(this.Model.ConnectionString) is Exception ex)
{
if (CustomMessageBox.ShowYesNo(
"La conexión actual no es valida\n" + ex.Message + "\n¿Desea guardarla de todas formas?",
"La conexión no es valida", "Si", "No", CustomMessageBoxImage.Question) == CustomMessageBoxResult.No)
{
return;
}
}
SqlServer.ConnectionString = new SqlConnectionStringBuilder(this.Model.ConnectionString);
this.Model.SqlServer = SqlServer;
this.Model.Save();
this.Close();
}
catch (Exception ex)
{
Log.Logger.Error(ex, "Al guardar la cadena de conexión");
}
}
//关系数据库
private void bGalleryRelationalDatabase_ItemClick(object sender, ItemClickEventArgs e)
{
this.panelControl_Navigation.Controls.Clear();
this.panelControl_Navigation.Controls.Add(ucNaviRDB);
DataTable dt = SQLServerConnection.GetDatabaseSchema();
if (dt == null)
{
return;
}
if (dt.Rows.Count == 0)
{
return;
}
this.ucNaviRDB.TreeList.KeyFieldName = "id"; //主要显示内容
this.ucNaviRDB.TreeList.ParentFieldName = "TABLE_CATALOG"; //目录
this.ucNaviRDB.TreeList.DataSource = dt; //数据库
DevExpress.XtraTreeList.Columns.TreeListColumnCollection col = this.ucNaviRDB.TreeList.Columns;
this.ucNaviRDB.TreeList.Columns["TABLE_NAME"].SortOrder = SortOrder.Ascending; //排序
//显示内容
for (int i = 0; i < ucNaviRDB.TreeList.Columns.Count; i++)
{
if (ucNaviRDB.TreeList.Columns[i].FieldName != "TABLE_NAME")
{
ucNaviRDB.TreeList.Columns[i].Visible = false;
}
}
}
/// <summary>
/// Update specific resource
/// </summary>
/// <returns></returns>
public int update(Entidad.User.User user)
{
int retorno = 0;
try
{
#region login example using SP
SqlCommand cmd = new SqlCommand("sp_user_insert", SQLServerConnection.open());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", user.Id_);
cmd.Parameters.AddWithValue("@name", user.Name_);
cmd.Parameters.AddWithValue("@last_name", user.LastName_);
cmd.Parameters.AddWithValue("@email", user.Email_);
cmd.Parameters.AddWithValue("@password", user.Password_);
retorno = cmd.ExecuteNonQuery();
#endregion
return(retorno);
}
catch (Exception)
{
throw;
}
finally
{
SQLServerConnection.close();
}
}
private void CreateButton_Click(object sender, RoutedEventArgs e)
{
AnnouncementData.calculateErrors();
if (organiserCombobox.SelectedIndex <= -1)
{
MessageBox.Show("Please select the department which is passing this information.");
}
else if (AnnouncementData.noDepartmentSelected)
{
MessageBox.Show("Please select at least one department which this announcement/notification has to be shown to.");
}
else
{
SqlCommand cmd = SQLServerConnection.initializeSqlCommand("insert into Announcement (event_heading, event_desc, org_branch, elig_branch, date_created) values (@heading, @desc, @org, @elig, @date)");
cmd.Parameters.AddWithValue("@heading", AnnouncementData.announcementTitle);
cmd.Parameters.AddWithValue("@desc", AnnouncementData.announcementDetails);
cmd.Parameters.AddWithValue("@org", organiserCombobox.SelectedIndex);
cmd.Parameters.AddWithValue("@elig", AnnouncementData.eligibleBranches());
DateTime myDateTime = DateTime.Now;
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm:ss.fff");
cmd.Parameters.AddWithValue("@date", sqlFormattedDate);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
SQLServerConnection.closeConnection();
AnnouncementWindow aw = new AnnouncementWindow(true);
aw.Show();
this.Close();
}
}
public static List <ItemList> GetItemList(SqlConnection SQLconn)
{
List <ItemList> IL = new List <ItemList>();
using (SqlCommand command = new SqlCommand("dbo.GetFoodList", SQLconn))
{
command.CommandType = CommandType.StoredProcedure;
SQLconn.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ItemList tempSL = new ItemList();
tempSL.FoodID = reader.GetInt32(0);
tempSL.StallID = reader.GetInt32(1);
tempSL.FoodTypeID = reader.GetInt32(2);
tempSL.FoodName = reader.GetString(3);
tempSL.FoodDescription = reader.GetString(4);
tempSL.FoodPrice = reader.GetDecimal(5);
IL.Add(tempSL);
}
}
SQLServerConnection.CloseSQLConnection(SQLconn);
}
return(IL);
}
private void loadUserData()
{
string mySQL = string.Empty;
mySQL += "SELECT id,Department,HostName,Protecter FROM logindata";
mySQL += " where HostName = '" + hostname + "'";
DataTable userdata = SQLServerConnection.executeSQL(mySQL);
dataGridView1.DataSource = userdata;
dataGridView1.Columns[0].HeaderText = "Id";
dataGridView1.Columns[1].HeaderText = "Department";
dataGridView1.Columns[2].HeaderText = "HostName";
dataGridView1.Columns[3].HeaderText = "Protecter";
dataGridView1.Columns[0].Width = 100;
dataGridView1.Columns[1].Width = 100;
dataGridView1.Columns[2].Width = 100;
dataGridView1.Columns[3].Width = 100;
if (userdata.Rows.Count > 0)
{
MessageBox.Show("本機電腦已註冊過");
}
else
{
MessageBox.Show("本機電腦尚未註冊");
}
}
public bool EnsureDeviceIsRegistred(SQLServerConnection SQLH)
{
SyncDevicesInfo deviceInfo;
//SQL SERVER
if (!IsDeviceRegistered(SQLH))
{
deviceInfo = new SyncDevicesInfo()
{
DeviceId = DeviceId,
LastTimeSeen = DateTime.Now,
Name = IDeviceInfo.DeviceName
};
SQLH.Insert(deviceInfo);
}
else
{
deviceInfo = SQLH.Table <SyncDevicesInfo>().FirstOrDefault(x => x.DeviceId == DeviceId);
if (deviceInfo is null)
{
return(IsDeviceRegistered(SQLH));
}
deviceInfo.LastTimeSeen = DateTime.Now;
SQLH.Update(deviceInfo);
}
return(IsDeviceRegistered(SQLH));
}
//Announcement
public void updateAnnouncement()
{
SqlCommand cmd = SQLServerConnection.initializeSqlCommand("select event_desc from Announcement");
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
notificationDetails.Text = (reader["event_desc"].ToString());
}
cmd.Parameters.Clear(); reader.Close();
cmd = SQLServerConnection.initializeSqlCommand("select date_created from Announcement");
reader = cmd.ExecuteReader();
while (reader.Read())
{
dateLabel.Content = (reader["date_created"].ToString());
}
cmd.Parameters.Clear(); reader.Close();
cmd = SQLServerConnection.initializeSqlCommand("select event_heading from Announcement");
reader = cmd.ExecuteReader();
while (reader.Read())
{
notificationLabel.Content = (reader["event_heading"].ToString());
}
cmd.Parameters.Clear(); reader.Close();
SQLServerConnection.closeConnection();
}
private void ConnectionButton_Click(object sender, EventArgs e)
{
if (this.ConnectionDetails1.Text == "Server Name")
{
SQLServerConnection databaseConnection = new SQLServerConnection(this.ConnectionDetailsText1.Text,
this.ConnectionDetailsText2.Text, this.ConnectionDetailsText3.Text, this.ConnectionDetailsText4.Text);
String result = databaseConnection.createConnection();
MessageBox.Show(result);
SqlConnection dbConnection = databaseConnection.getDatabaseConnection();
if (result == "Connection Established. Press OK to continue.")
{
new SQLServerView(databaseConnection).Show();
this.Dispose();
}
}
else
{
OracleDBConnection databaseConnection = new OracleDBConnection(this.ConnectionDetailsText1.Text,
this.ConnectionDetailsText2.Text, this.ConnectionDetailsText4.Text);
String result = databaseConnection.createConnection();
MessageBox.Show(result);
if (result == "Connection Established. Press OK to continue.")
{
new OracleView(databaseConnection).Show();
this.Dispose();
}
}
}
private void StudentViewForm_Load(object sender, EventArgs e)
{
//Create SQL Source connection where your DB is locate
//String source = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\Andrew Nguyen\\Documents\\Projects\\Blackboard_Application\\BlackBoard_Application\\StudentInfo.mdf;Integrated Security=True";
var sqlClass = new SQLServerConnection(); // This calls the class for SQL
sqlClass.OpenConnection(); // Open SQL connection
//SQL query statement to select all information from studentinformation table where username is equal to the passing input from Login Form input
string mySql = "SELECT * FROM StudentInformation WHERE username ='******'";
//SqlClass.ExecuteQueries(mySql);
var reader = sqlClass.DataReader(mySql);
while (reader.Read()) //This if statement will pass ALL values into the textbox as a string to each one for the right username
{
school_IDTextBox.Text = (reader["School ID"].ToString());
first_NameTextBox.Text = (reader["first_Name"].ToString());
last_NameTextBox.Text = (reader["last_Name"].ToString());
course_TakenTextBox.Text = (reader["Course Taken"].ToString());
class_1_MidtermTextBox.Text = (reader["Class 1 Midterm"].ToString());
class_2_MidtermTextBox.Text = (reader["Class 2 Midterm"].ToString());
class_3_MidtermTextBox.Text = (reader["Class 3 Midterm"].ToString());
class_4_MidtermTextBox.Text = (reader["Class 4 Midterm"].ToString());
class_1_FinalsTextBox.Text = (reader["Class 1 Finals"].ToString());
class_2_FinalsTextBox.Text = (reader["Class 2 Finals"].ToString());
class_3_FinalsTextBox.Text = (reader["Class 3 Finals"].ToString());
class_4_FinalsTextBox.Text = (reader["Class 4 Finals"].ToString());
//statement create GPA calculation
gPATextBox.Text = (reader["GPA"].ToString());
}
sqlClass.CloseConnection(); // closes the connection
}
private void EnsureTableExists(SQLServerConnection SQLH)
{
if (!SQLH.TableExists <SyncDevicesInfo>())
{
SQLH.CreateTable <SyncDevicesInfo>();
}
}
public SQLServerSessionDetails(SQLServerConnection connection)
{
InitializeComponent();
this.dbConnection = connection;
SqlConnection databaseConnection = connection.getDatabaseConnection();
String query = "SELECT spid, hostname, db_name(dbid) as DatabaseName, loginame, cmd, status "
+ "FROM master.dbo.sysprocesses "
+ "WHERE program_name = 'ORACLE-SQL-SERVER-CLIENT'"
+ "AND db_name(dbid) = '"
+ this.dbConnection.getDatabaseConnection().Database + "'";
SqlCommand command = new SqlCommand(query, databaseConnection);
SqlDataReader reader;
command.CommandText = query;
command.CommandType = CommandType.Text;
reader = command.ExecuteReader();
while (reader.Read())
{
this.sessionListing.Rows.Add("SPID", reader["spid"]);
this.sessionListing.Rows.Add("HOST", reader["hostname"]);
this.sessionListing.Rows.Add("DATABASE", reader["DatabaseName"]);
this.sessionListing.Rows.Add("USER", reader["loginame"]);
this.sessionListing.Rows.Add("COMMAND", reader["cmd"]);
this.sessionListing.Rows.Add("STATUS", reader["status"]);
}
reader.Close();
}
private bool IsDeviceRegistered(SQLServerConnection SQLH)
{
EnsureTableExists(SQLH);
bool registered = SQLH.Table <SyncDevicesInfo>().Any(x => x.DeviceId == DeviceId);
this.RegisterStatus = registered ? DeviceRegisterStatus.Registered : DeviceRegisterStatus.NotRegistered;
return(registered);
}
// Count for Previous page index
public static int getCount()
{
SqlCommand cmd = SQLServerConnection.initializeSqlCommand("select count(*) from Announcement ");
AnnouncementData.count = (int)cmd.ExecuteScalar();
cmd.Parameters.Clear();
return(AnnouncementData.count);
}
public SQLServerDll(String tableName, SQLServerConnection connection, bool option)
{
InitializeComponent();
this.tableName = tableName;
this.dbConnection = connection;
this.Text = tableName + "@" + dbConnection.getDatabaseConnection().Database;
refreshInitialize();
}
public procedureViewerSQLServer(String procedureName, SQLServerConnection connection, bool option)
{
InitializeComponent();
this.procedureName = procedureName;
this.dbConnection = connection;
this.Text = procedureName + "@" + dbConnection.getDatabaseConnection().Database;
refreshInitialize();
}
private void loginButton_Click(object sender, RoutedEventArgs e)
{
loginButton.Background = (Brush)(new BrushConverter().ConvertFrom("#FF82B3C9"));
exceptionLabel.Content = "";
if (!(isTeacher || isStudent))
{
MessageBox.Show(" Please Select Student Or Teacher.", "Select User Type");
}
else
{ //SQL Command template.
//SqlCommand cmd = SQLServerConnection.initializeSqlCommand("");
//body
//SQLServerConnection.closeConnection();
SqlCommand cmd = SQLServerConnection.initializeSqlCommand("select count(*) from LoginTable where usn=@usn and pwd=@pwd and usertype=@usertype");
char usertype = ' ';
bool studentOrTeacher = false;
if (isTeacher)
{
usertype = 't';
studentOrTeacher = true;
}
if (isStudent)
{
usertype = 's';
studentOrTeacher = false;
}
cmd.Parameters.AddWithValue("@usn", userIdValue.Text);
cmd.Parameters.AddWithValue("@pwd", passwordValue.Password);
cmd.Parameters.AddWithValue("@usertype", usertype);
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
AnnouncementWindow announcement = new AnnouncementWindow(studentOrTeacher);
announcement.Show();
this.Close();
}
else
{
MessageBox.Show("Username or password is incorrect.");
userIdValue.Text = "";
passwordValue.Password = "";
}
cmd.Parameters.Clear();
SQLServerConnection.closeConnection();
}
/*if(isTeacher&&isStudent)
* exceptionLabel.Content = "**Student/Teacher Button NOT Selected**";*/
}
public SQLServerCommand(SQLServerConnection conn, string cmd, params SqlParameter[] parameters)
{
if (parameters is not null)
{
this.Parameters = new List <SqlParameter>(parameters);
}
CommandText = cmd;
_conn = conn;
}
public void Delete(SQLServerConnection con)
{
var products = con.Table <Product> ().ToList();
foreach (Product product in products)
{
con.Delete(product);
}
}
private void LoginButton_Click(object sender, EventArgs e)
{
//We set the username input you type and set it to passingUsername
passingUsername = loginInput.Text;
//If statement where String Input Cannot be null or empty
if (!string.IsNullOrEmpty(loginInput.Text) &&
!string.IsNullOrEmpty(passwordInput.Text))
{
var mySql = string.Empty;
mySql += "SELECT * FROM Users "; //To Select all attributes from the User Table
mySql += "WHERE username ='******' "; //Where username is the input
//mySQL += "WHERE username = '******' ";
mySql += "AND password = '******'"; //AND the password Input
//mySQL += "AND password = '******'";
//Using helps dispose of null connection
var userData = SQLServerConnection.ExecuteSql(mySql);
if (userData.Rows.Count > 0)
{
if (loginInput.Text == "admin") //Execute AdminViewPage.cs
{
loginInput.Clear();
passwordInput.Clear();
var addPage = new AdminViewForm(); // Initialize LoginForm to a value
this.Hide(); // First need to hide main page
addPage.ShowDialog(); //Enable you to go back to Login Page Form
this.loginInput.Select();
}
else
{
loginInput.Clear();
passwordInput.Clear();
var studentPage = new StudentViewForm(); // Initialize LoginForm to a value
this.Hide(); // First need to hide main page
studentPage.ShowDialog(); //Enable you to go back to Login Page Form
this.loginInput.Select();
}
}
else
{
MessageBox.Show("Wrong Username or Password", "Please Try Again",
MessageBoxButtons.OK, MessageBoxIcon.Stop);
loginInput.Focus();
loginInput.SelectAll();
}
}
else
{
MessageBox.Show("Please enter a username and password.", "Try Again",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
loginInput.Select();
}
}
public void Update(SQLServerConnection con)
{
var products = con.Table <Product> ().ToList();
foreach (Product product in products)
{
product.Name += " Updated";
con.Update(product);
}
}
public void UseDbConnection()
{
var sqlserver = new SQLServerConnection("database=bd;uid=root;pwd=pass");
sqlserver.Open();
sqlserver.Close();
var orcale = new OracleConnection("a random connection string for oracle");
orcale.Open();
orcale.Close();
}
public static void DeleteItem(SqlConnection SQLconn, int FoodID)
{
using (SqlCommand command = new SqlCommand("dbo.DeleteFood", SQLconn))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@IDStall", SqlDbType.Int).Value = FoodID;
SQLconn.Open();
command.ExecuteNonQuery();
}
SQLServerConnection.CloseSQLConnection(SQLconn);
}
private void Dispose(bool disposing)
{
var s = Statement;
Statement = NullStatement;
Connection = null;
if (s != NullStatement)
{
SQLite3.Finalize(s);
}
}
internal bool CheckTriggers(SQLServerConnection Connection)
{
foreach (TableMapping map in
this.Tables
.Select(d => d.Value.ForSqlServer())
.Where(x => x.SyncDirection == SyncDirection.Download || x.SyncDirection == SyncDirection.TwoWay))
{
Trigger.CheckTrigger(Connection, map, Daemon.Current.DaemonConfig.DbVersion);
InitTableAttribute.Find(map.MappedType)?.Execute(Connection);
}
return(true);
}
/// <summary>
/// Dapperのサンプルコード
/// </summary>
public void FirstDapper()
{
SQLServerConnection.Open();
var result = SQLServerConnection.Query <HouseholdAccount>(@"SELECT * FROM HOUSEHOLDACCOUNT");
result.ForEach(x =>
{
Console.WriteLine($"Id={x.Id} Item={x.Item} Date={x.Date}");
});
SQLServerConnection.Close();
}
public static void InitializeConnection(DataBaseType db)
{
if (db == DataBaseType.SQLServer)
{
SQLServerConnection SQLServer = new SQLServerConnection();
Connection = SQLServer;
}
else if (db == DataBaseType.MySQL)
{
MySQLConnection mySQL = new MySQLConnection();
Connection = mySQL;
}
}
//Update Previous
public void updatePrevious()
{
AnnouncementData.wasPreviousButtonClicked = true;
if (AnnouncementData.arrLength > 1)
{
--AnnouncementData.arrLength;
}
SqlDataReader reader;
SqlCommand cmd = SQLServerConnection.initializeSqlCommand("Select event_desc From Announcement where event_id=@id");
SqlParameter param = new SqlParameter();
param.ParameterName = "@id";
param.Value = AnnouncementData.arrLength;
cmd.Parameters.Add(param);
reader = cmd.ExecuteReader();
while (reader.Read())
{
notificationDetails.Text = (reader["event_desc"].ToString());
}
cmd.Parameters.Clear(); reader.Close();
cmd = SQLServerConnection.initializeSqlCommand("select date_created from Announcement where event_id=@id");
param = new SqlParameter();
param.ParameterName = "@id";
param.Value = AnnouncementData.arrLength;
cmd.Parameters.Add(param);
reader = cmd.ExecuteReader();
while (reader.Read())
{
dateLabel.Content = (reader["date_created"].ToString());
}
cmd.Parameters.Clear(); reader.Close();
cmd = SQLServerConnection.initializeSqlCommand("select event_heading from Announcement where event_id=@id");
param = new SqlParameter();
param.ParameterName = "@id";
param.Value = AnnouncementData.arrLength;
cmd.Parameters.Add(param);
reader = cmd.ExecuteReader();
while (reader.Read())
{
notificationLabel.Content = (reader["event_heading"].ToString());
}
cmd.Parameters.Clear(); reader.Close();
SQLServerConnection.closeConnection();
}
public PeopleController()
{
//people.Add(new Person { FirstName = "Tim", LastName = "Corey", Id = 1 });
//people.Add(new Person { FirstName = "Sue", LastName = "Storm", Id = 2 });
//people.Add(new Person { FirstName = "Audrey", LastName = "Jenkins", Id = 3 });
//people.Add(new Person { FirstName = "Billy", LastName = "Peterson", Id = 4 });
//people.Add(new Person { FirstName = "John", LastName = "Johnson", Id = 5 });
//people.Add(new Person { FirstName = "George", LastName = "Wisley", Id = 6 });
//people.Add(new Person { FirstName = "Alex", LastName = "Granger", Id = 7 });
//people.Add(new Person { FirstName = "Stan", LastName = "Potter", Id = 8 });
//people.Add(new Person { FirstName = "Stewy", LastName = "Baggings", Id = 9 });
people = SQLServerConnection.GetPeople();
}
//关系数据库导航栏双击事件
private void ucNaviRDB_TreeList_DoubleClick(object sender, EventArgs e)
{
try
{
TreeList tree = sender as TreeList;
TreeListHitInfo hi = tree.CalcHitInfo(tree.PointToClient(Control.MousePosition));
if (hi.Node != null)
{
string nodeName = (string)hi.Node["TABLE_NAME"];
//如果已经有这个tabPage
XtraTabPage ifTabPage = ComponentOperator.IfHasTabPage(nodeName, this.xtraTabControl_Main);
if (ifTabPage != null)
{
this.xtraTabControl_Main.SelectedTabPage = ifTabPage;
return;
}
//如果不包含该TabPage，则新建
DataTable dt = SQLServerConnection.GetDataByTableName(nodeName);
if (dt == null)
{
MessageBox.Show("获取数据失败。", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//表格控件
SpreadsheetControl ssc = new SpreadsheetControl();
IWorkbook workbook = ssc.Document;
workbook.BeginUpdate();
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Name = nodeName;
worksheet.Import(dt, true, 0, 0); //import方法需要添加DevExpress.Docs命名空间
workbook.EndUpdate();
//TabPage
XtraTabPage xtp = new XtraTabPage();
xtp.Text = nodeName;
xtp.Controls.Add(ssc);
ssc.Dock = DockStyle.Fill;
this.xtraTabControl_Main.TabPages.Add(xtp);
this.xtraTabControl_Main.SelectedTabPage = xtp;
ssc.Refresh();
xtp.Refresh();
this.xtraTabControl_Main.Refresh();
this.Refresh();
}
}
catch
{
}
}
static void Main(string[] args)
{
IDBConnection<SqlConnection> sqlServerConnection = new SQLServerConnection();
var sqlServerDatabase = sqlServerConnection.GetDatabase("");
var sqlServerMapper = new SQLServerMapper<Client, DataSet>();
var sqlClientBL = GenericBLFactory<Client, Guid, IList<FilterQuery>, DataSet, SqlConnection>.Create(sqlServerConnection, "", "", sqlServerMapper);
sqlClientBL.GetById(new Guid());
//var sqlServerRepo = new SQLServerRepository<Client>("", null);
//sqlServerRepo.GetById("5");
string databaseName = "test";
string clientDocument = "client";
string employeeDocument = "employee";
// IoC configuration
var containerBuilder = new ContainerBuilder();
IConfigIoC manager = new IoCManager(containerBuilder);
manager.Configure();
IContainer builder = containerBuilder.Build();
var dbConnection = builder.Resolve<IDBConnection<IMongoDatabase>>();
//Connection
dbConnection.OpenConnection();
IMongoDatabase mongoDatabase = dbConnection.GetDatabase(databaseName);
//ClientBL
var clientMongoMapper = new MongoMapper<Client, BsonDocument>();
var clientBL = GenericBLFactory<Client, string, IList<FilterQuery>, BsonDocument, IMongoDatabase>.Create(dbConnection, databaseName, clientDocument, clientMongoMapper);
var employeeMongoMapper = new MongoMapper<Employee, BsonDocument>();
var employeeBL = GenericBLFactory<Employee, string, IList<FilterQuery>, BsonDocument, IMongoDatabase>.Create(dbConnection, databaseName, employeeDocument, employeeMongoMapper);
//Creation
var client = new Client("55554", "Joan");
var employee = new Employee("12", "Joan", "Wolters Kluwers");
//Insert
clientBL.Create(client);
employeeBL.Create(employee);
//GetById
var obtainedClient = clientBL.GetById(client.Id);
Console.WriteLine("Cliente insertado correctamente. Id: {0}, Name: {1}", obtainedClient.Id, obtainedClient.Name);
var obtainedEmployee = employeeBL.GetById(employee.Id);
Console.WriteLine("Employee insertado correctamente. Id: {0}, Name: {1}, WorkStation: {2}", obtainedEmployee.Id, obtainedEmployee.Name, obtainedEmployee.WorkStation);
Console.ReadLine();
//GetFiltered
IList<FilterQuery> queryGetFiltered = new List<FilterQuery>();
queryGetFiltered.Add(new FilterQuery("_id", "55554", "$eq"));
queryGetFiltered.Add(new FilterQuery("name", "Joan", "$eq"));
var resultGetFiltered = clientBL.GetFiltered(queryGetFiltered);
Console.WriteLine("Clientes encontrados:");
foreach (var oneClient in resultGetFiltered)
{
Console.WriteLine("Cliente encontrado: Id: {0}, Name: {1}", oneClient.Id, oneClient.Name);
}
IList<FilterQuery> queryGetFiltered2 = new List<FilterQuery>();
queryGetFiltered2.Add(new FilterQuery("_id", "12", "$eq"));
queryGetFiltered2.Add(new FilterQuery("workstation", "Wolters Kluwers", "$eq"));
var resultGetFiltered2 = employeeBL.GetFiltered(queryGetFiltered2);
Console.WriteLine("Employees encontrados:");
foreach (var oneEmployee in resultGetFiltered2)
{
Console.WriteLine("Employee encontrado Id: {0}, Name: {1}, WorkStation: {2}", oneEmployee.Id, oneEmployee.Name, oneEmployee.WorkStation);
}
Console.ReadLine();
}
