public void ShowDatabases()
{
BizDatabase bizDatabase = new BizDatabase();
var DatabaseList = bizDatabase.GetDatabases();
dtgItems.ItemsSource = DatabaseList;
}
public void ShowDBServers()
{
BizDatabase bizDBServer = new BizDatabase();
var DBServerList = bizDBServer.GetDBServers();
dtgItems.ItemsSource = DBServerList;
}
public static bool InsertFromQueryToTargetDB(int entityID, string targetTableName, string selectQuery)
{
BizDatabase bizDatabase = new BizDatabase();
var database = bizDatabase.GetDatabaseByEntityID(entityID);
if (database.DBType == enum_DBType.SQLServer)
{
return(InsertFromQueryToTargetSQLDB(database, targetTableName, selectQuery));
}
return(false);
}
private void SetDatabaseLookup()
{
BizDatabase bizDatabase = new BizDatabase();
lokDatabase.SelectedValueMember = "ID";
lokDatabase.DisplayMember = "Title";
lokDatabase.NewItemEnabled = false;
lokDatabase.EditItemEnabled = false;
// قابل دسترسی کاربر //
var databases = bizDatabase.GetDatabases();
lokDatabase.ItemsSource = databases;
}
private void SetServerLookup()
{
if (lokServer.SelectedValueMember == null)
{
lokServer.SelectedValueMember = "ID";
lokServer.DisplayMember = "Title";
lokServer.NewItemEnabled = true;
//lokServer.NewItemClicked += LokServer_NewItemClicked;
lokServer.EditItemEnabled = true;
lokServer.EditItemClicked += LokServer_EditItemClicked;
}
BizDatabase bizDatabase = new BizDatabase();
var servers = bizDatabase.GetDBServers();
lokServer.ItemsSource = servers;
}
private void btnImportKeyValues_Click(object sender, RoutedEventArgs e)
{
//if (optValueComesFromTitle.IsChecked == false && optValueComesFromValue.IsChecked == false)
//{
// MessageBox.Show("لطفا نوع جایگذاری مقادیر ستون در عنوان یا مقدار را مشخص نمایید");
// return;
//}
BizDatabase bizDatabase = new BizDatabase();
BizColumn bizColumn = new BizColumn();
var column = bizColumn.GetColumn(ColumnID, true);
var database = bizDatabase.GetDatabaseByTableID(column.TableID);
var dbHelper = MyModelGenerator.ModelGenerator.GetDatabaseImportHelper(database);
var result = dbHelper.GetColumnValueRange(ColumnID);
if (result != null)
{
Message.Details = result.Details;
dtgColumnKeyValue.ItemsSource = null;
dtgColumnKeyValue.ItemsSource = Message.Details;
}
}
private void btnImportFunctions_Click(object sender, RoutedEventArgs e)
{
BizDatabase bizDatabase = new BizDatabase();
var database = bizDatabase.GetDatabase(DatabaseID);
var ImportHelper = ModelGenerator.GetDatabaseImportHelper(database);
//ImportHelper.GenerateFunctions();
//if (MessageBox.Show("فرایند ورود اطلاعات خودکار توابع" + Environment.NewLine + Environment.NewLine + "آیا مطمئن هستید؟", "تائید", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
//{
// //try
// //{
// var result = ModelGenerator.GenerateFunctions();
// if (result)
// {
// BizDatabaseFunction bizDatabaseFunction = new BizDatabaseFunction();
// dtgFunctions.ItemsSource = bizDatabaseFunction.GetDatabaseFunctions(Enum_DatabaseFunctionType.None, DatabaseID);
// MessageBox.Show("Operation is completed.");
// }
// else
// MessageBox.Show("Operation is not done!");
//}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (txtName.Text == "")
{
MessageBox.Show("نام");
return;
}
if (lokFirstSideEntity.SelectedItem == null)
{
MessageBox.Show("موجودیت سمت اول انتخاب نشده است");
return;
}
if (lokSecondSideEntity.SelectedItem == null)
{
MessageBox.Show("موجودیت سمت دوم انتخاب نشده است");
return;
}
if (lokFirstDataMenu.SelectedItem != null)
{
Message.FirstSideDataMenuID = (int)lokFirstDataMenu.SelectedValue;
}
if (lokSecondDataMenu.SelectedItem != null)
{
Message.SecondSideDataMenuID = (int)lokSecondDataMenu.SelectedValue;
}
foreach (var item in Message.RelationshipsTails)
{
if (colRelationshipTail.ItemsSource != null && colRelationshipTail.ItemsSource is List <EntityRelationshipTailDTO> )
{
var tail = (colRelationshipTail.ItemsSource as List <EntityRelationshipTailDTO>).FirstOrDefault(x => x.ID == item.RelationshipTailID);
if (tail != null)
{
TableDrivedEntityDTO sEntity = lokSecondSideEntity.SelectedItem as TableDrivedEntityDTO;
if (tail.TargetEntityID != sEntity.ID)
{
MessageBox.Show("رشته رابطه" + " " + tail.EntityPath + " " + "با موجودیت" + " " + sEntity.Alias + " " + "در ارتباط نمی باشد");
return;
}
}
}
}
foreach (var item in Message.RelationshipsTails)
{
if (item.RelationshipTailID != 0)
{
var relationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), item.RelationshipTailID);
BizTableDrivedEntity bizTableDrivedEntity = new MyModelManager.BizTableDrivedEntity();
var entity = bizTableDrivedEntity.GetSimpleEntity(MyProjectManager.GetMyProjectManager.GetRequester(), relationshipTail.TargetEntityID);
var viewMessage = bizEntityRelationshipTail.CheckTailHasRelationshipWithView(relationshipTail);
if (viewMessage != "")
{
var message = "اشکال در تعریف لینک داده با موجودیت" + " " + string.IsNullOrEmpty(relationshipTail.TargetEntityAlias);
message += Environment.NewLine + "در رشته رابطه ارتباط با نمای" + " " + viewMessage + " " + "امکان پذیر نمی باشد";
MessageBox.Show(message);
return;
}
}
}
var firstEntity = lokFirstSideEntity.SelectedItem as TableDrivedEntityDTO;
var secondEntity = lokSecondSideEntity.SelectedItem as TableDrivedEntityDTO;
if (firstEntity.ServerID != secondEntity.ServerID)
{
BizDatabase bizDatabase = new BizDatabase();
if (!bizDatabase.LinkedServerExists(firstEntity.ServerID, secondEntity.ServerID))
{
MessageBox.Show("ارتباط لینک سرور بین موجودیت طرف اول و دوم وجود ندارد");
return;
}
}
foreach (var item in Message.RelationshipsTails)
{
if (item.RelationshipTailID != 0)
{
var relationshipTail = bizEntityRelationshipTail.GetEntityRelationshipTail(MyProjectManager.GetMyProjectManager.GetRequester(), item.RelationshipTailID);
var linkedServerMessage = bizEntityRelationshipTail.CheckRelationshipsLinkedServers(relationshipTail);
if (linkedServerMessage != "")
{
var message = "اشکال در رشته رابطه" + " " + string.IsNullOrEmpty(relationshipTail.EntityPath);
message += Environment.NewLine + linkedServerMessage;
MessageBox.Show(message);
return;
}
}
}
Message.NotJointEntities = chkNotJoint.IsChecked == true;
Message.ReportTitle = txtName.Text;
if (Message.ID == 0)
{
Message.TableDrivedEntityID = (int)lokFirstSideEntity.SelectedValue;
Message.SecondSideEntityID = (int)lokSecondSideEntity.SelectedValue;
}
Message.ID = bizDataLink.UpdateDataLink(Message);
MessageBox.Show("اطلاعات ثبت شد");
if (Updated != null)
{
Updated(this, new MyProject_WPF.UpdatedEventArg()
{
ID = Message.ID
});
}
}
//private void GetRelationship(int ID)
//{
//}
private void btnSaveAndSelect_Click(object sender, RoutedEventArgs e)
{
//در صورت ایجاد اولیه باید چک شود که طرف اول پرایمری کی باشد
if (txtName.Text == "")
{
MessageBox.Show("نام رابطه");
return;
}
if (cmbFirstEntity.SelectedItem == null)
{
MessageBox.Show("موجودیت سمت اول");
return;
}
if (cmbSecondEntity.SelectedItem == null)
{
MessageBox.Show("موجودیت سمت دوم");
return;
}
if (Message.RelationshipColumns.Count == 0)
{
MessageBox.Show("ستونها");
return;
}
string linkedServerMessage = "";
BizDatabase bizDatabase = new BizDatabase();
var firstEntity = bizTableDrivedEntity.GetTableDrivedEntity(MyProjectManager.GetMyProjectManager.GetRequester(), (int)cmbFirstEntity.SelectedValue, EntityColumnInfoType.WithSimpleColumns, EntityRelationshipInfoType.WithoutRelationships);
var secondEntity = bizTableDrivedEntity.GetTableDrivedEntity(MyProjectManager.GetMyProjectManager.GetRequester(), (int)cmbSecondEntity.SelectedValue, EntityColumnInfoType.WithSimpleColumns, EntityRelationshipInfoType.WithoutRelationships);
if (firstEntity.ServerID != secondEntity.ServerID)
{
if (!bizDatabase.LinkedServerExists(firstEntity.ServerID, secondEntity.ServerID))
{
linkedServerMessage += (linkedServerMessage == "" ? "" : Environment.NewLine) + "لینک سرور از طرف موجودیت" + " '" + firstEntity.Alias + "' " + "به موجودیت" + " '" + secondEntity.Alias + "' " + "تعریف نشده است";
}
if (!bizDatabase.LinkedServerExists(secondEntity.ServerID, firstEntity.ServerID))
{
linkedServerMessage += (linkedServerMessage == "" ? "" : Environment.NewLine) + "لینک سرور از طرف موجودیت" + " '" + secondEntity.Alias + "' " + "به موجودیت" + " '" + firstEntity.Alias + "' " + "تعریف نشده است";
}
}
if (!string.IsNullOrEmpty(linkedServerMessage))
{
var message = linkedServerMessage;
message += Environment.NewLine + "به منظور استفاده از این رابطه در نمایش و جستجوی داده ها و عدم بروز خطا لینک سرورها تعریف شوند";
MessageBox.Show(message);
// return;
}
if (!firstEntity.IsView && !secondEntity.IsView)
{
foreach (var relCol in Message.RelationshipColumns)
{
var firstSideColumn = firstEntity.Columns.First(x => x.ID == relCol.FirstSideColumnID);
if (!firstSideColumn.PrimaryKey)
{
MessageBox.Show("ستون" + " " + firstSideColumn.Name + " " + "کلید اصلی نمی باشد");
return;
}
}
}
Message.Name = txtName.Text;
Message.EntityID1 = (int)cmbFirstEntity.SelectedValue;
Message.EntityID2 = (int)cmbSecondEntity.SelectedValue;
Message.CreateType = (CreateRelationshipType)cmbRelationshipType.SelectedItem;
var id = bizRelationship.CreateUpdateRelationship(MyProjectManager.GetMyProjectManager.GetRequester(), Message, chkSecondSideDataEntry.IsChecked == true);
MessageBox.Show("اطلاعات ثبت شد");
GetRelationship(id);
}
