/// <summary>
/// Check if the specified row is the active row (focused), return false if it is not the active row. Then call the BeginEdit on the associated DataRowView. Add a row to the DataView if required. Returns true if the method sucesfully call the BeginEdit and set the EditingRow property.
/// </summary>
/// <param name="gridRow"></param>
/// <returns></returns>
public bool BeginEditRow(int gridRow)
{
// if (Selection.ActivePosition.IsEmpty() || Selection.ActivePosition.Row != gridRow)
// return false;
if (gridRow != EditingRow)
{
EndEditingRow(false); //Terminate the old edit if present
System.Data.DataRowView newEditingRow = null;
if (DataSource != null)
{
int dataIndex = Rows.IndexToDataSourceIndex(gridRow);
if (dataIndex == DataSource.Count && DataSource.AllowNew) //Last Row
{
DataSource.AddNew();
newEditingRow = DataSource[dataIndex];
}
else if (dataIndex < DataSource.Count)
{
newEditingRow = DataSource[dataIndex];
}
}
if (newEditingRow != null)
{
mEditingInfo = new EditingInfo(newEditingRow, gridRow);
EditingDataRow.BeginEdit();
}
}
return(true);
}
public static bool Display(EditingInfo editingInfo)
{
var window = new StoredProcedureEditorWindow(editingInfo);
window.Owner = Application.Current.MainWindow;
return(window.ShowDialog() ?? false);
}
public void MassMinus(EditingInfo img)
{
int t = Mas.IndexOf(img);
Mas.RemoveAt(t);
ZapolnenieFaila(NameWordlist);
}
private async void SaveFileExecute(object obj)
{
LoaderManager.Instance.ShowLoader();
bool res = await Task.Run(() =>
{
try
{
bool isSaved = FileManager.Instance.SaveFile(FileContent);
DateTime now = DateTime.Now;
ServiceReference1.Service1Client client = new ServiceReference1.Service1Client();
EditingInfo info = client.CreateEditingInfo(UserManager.Instance.CurrentUser, FileManager.Instance.CurrentFileName, isSaved, now);
string result = info.User.Login + " " + info.EditingDate.ToString() + System.Environment.NewLine;
EditingInfo += result;
MessageBox.Show(Resources.SaveFile_Success);
}
catch (Exception ex)
{
MessageBox.Show(String.Format(Resources.OpenFile_FailedToSave, Environment.NewLine,
ex.Message));
return(false);
}
return(true);
});
LoaderManager.Instance.HideLoader();
}
public StoredProcedureViewModel(EditingInfo editingInfo, ConnectionViewModel connectionViewModel)
{
EditingInfo = editingInfo;
storedProcedure = editingInfo.StoredProcedure;
this.connectionViewModel = connectionViewModel;
connectionViewModel.ConnectionType = editingInfo.ConnectionType;
connectionViewModel.ConnectionString = editingInfo.ConnectionString;
connectionViewModel.ConnectionChanged += connectionViewModel_ConnectionChanged;
Task.Factory.StartNew(() => { var list = StoredProcedures; });
}
public TableChooserViewModel(EditingInfo editingInfo, ConnectionViewModel connectionViewModel)
{
EditingInfo = editingInfo;
tableName = editingInfo.TableName;
this.connectionViewModel = connectionViewModel;
connectionViewModel.AllowedConnectionTypes = editingInfo.AllowedConnectionTypes;
connectionViewModel.ConnectionType = editingInfo.ConnectionType;
connectionViewModel.ConnectionString = editingInfo.ConnectionString;
connectionViewModel.ConnectionChanged += connectionViewModel_ConnectionChanged;
Task.Factory.StartNew(() => { var list = Tables; });
}
/// <summary>
/// Calls the CancelEdit or the EndEdit on the editing Row and set to null the editing row.
/// </summary>
/// <param name="cancel"></param>
public void EndEditingRow(bool cancel)
{
if (EditingDataRow != null)
{
if (cancel)
{
EditingDataRow.CancelEdit();
}
//These lines can throw an error if the row is not valid
EditingDataRow.EndEdit();
mEditingInfo = new EditingInfo(null, -1);
}
}
public void MassPlus(EditingInfo i)
{
int m = 0;
for (int n = 0; n < Mas.Count; n++)
{
if (Mas [n] != i)
{
m++;
}
}
if (m == Mas.Count)
{
Mas.Add(i);
}
ZapolnenieFaila(NameWordlist); /////////
}
public void EditValue(Property property, object designer)
{
var executeStoredProcedureDesigner = (ExecuteStoredProcedureDesigner)designer;
EditingInfo editingInfo = new EditingInfo(executeStoredProcedureDesigner)
{
ShouldUpdateConnectionString = false,
ShouldUpdateStoredProcedure = false,
ShouldUpdateProcedureParameters = false,
ShouldUpdateResultSets = true
};
if (StoredProcedureEditorItem.EditStoredProcedure(editingInfo))
{
executeStoredProcedureDesigner.Context.TransactionManager.StartTransaction("Refresh result sets from database");
editingInfo.UpdateDesigner(executeStoredProcedureDesigner);
executeStoredProcedureDesigner.Context.TransactionManager.StopTransaction();
}
}
public void EditValue(Property storedProcedureProperty, object designer)
{
ExecuteStoredProcedureDesigner executeStoredProcedureDesigner = designer as ExecuteStoredProcedureDesigner;
EditingInfo editingInfo = new EditingInfo(executeStoredProcedureDesigner)
{
ShouldUpdateConnectionString = false,
ShouldUpdateStoredProcedure = true,
ShouldUpdateProcedureParameters = true,
ShouldUpdateResultSets = true
};
if (EditStoredProcedure(editingInfo))
{
executeStoredProcedureDesigner.Context.TransactionManager.StartTransaction("Change stored procedure");
editingInfo.UpdateDesigner(executeStoredProcedureDesigner);
executeStoredProcedureDesigner.Context.TransactionManager.StopTransaction();
}
}
public void EditValue(Property property, object designer)
{
ExecuteStoredProcedureDesigner executeStoredProcedureDesigner = designer as ExecuteStoredProcedureDesigner;
EditingInfo editingInfo = new EditingInfo(executeStoredProcedureDesigner)
{
ShouldUpdateConnectionString = false,
ShouldUpdateStoredProcedure = false,
ShouldUpdateProcedureParameters = true,
ShouldUpdateResultSets = false
};
if (ProcedureParametersEditorWindow.Display(new ProcedureParametersViewModel(editingInfo)))
{
executeStoredProcedureDesigner.Context.TransactionManager.StartTransaction("Change procedure parameters");
editingInfo.UpdateDesigner(executeStoredProcedureDesigner);
executeStoredProcedureDesigner.Context.TransactionManager.StopTransaction();
}
}
public EditingInfo CreateEditingInfo(User user, string filePath, bool isFileChanged, DateTime editingDate)
{
EditingInfo info = null;
using (TextEditorDbContext db = new TextEditorDbContext())
{
User dbUser = db.Users.FirstOrDefault(u => u.Id == user.Id);
info = new EditingInfo(filePath, isFileChanged, editingDate);
if (dbUser.EditingInfos == null)
{
dbUser.EditingInfos = new List <EditingInfo>();
}
dbUser.EditingInfos.Add(info);
info.User = dbUser;
db.EditingInfos.Add(info);
db.SaveChanges();
}
return(info);
}
public void copImage(EditingInfo m, GameObject m1) //инициализация имаджа
{
Image = m;
Imag = m1;
}
private StoredProcedureEditorWindow(EditingInfo editingInfo)
{
InitializeComponent();
DataContext = new StoredProcedureViewModel(editingInfo, (ConnectionViewModel)ConnectionControl.DataContext);
}
public static bool EditStoredProcedure(EditingInfo editingInfo)
{
return(StoredProcedureEditorWindow.Display(editingInfo));
}
public void copImage(EditingInfo m) //инициализация имаджа
{
Image = m;
}
public EditingInfo CreateEditingInfo(User user, string filePath, bool isFileChanged, DateTime editingDate)
{
EditingInfo editingInfo = DbManager.Instance.CreateEditingInfo(user, filePath, isFileChanged, editingDate);
return(editingInfo);
}
public ProcedureParametersViewModel(EditingInfo editingInfo)
{
EditingInfo = editingInfo;
Parameters = new ObservableCollection <ProcedureParameterModel>(editingInfo.ProcedureParameters.Select(p => new ProcedureParameterModel(this, p)));
}
