/// <summary>
/// Method enables adding employee to the database.
/// </summary>
public void AddEmployee(object sender, DoWorkEventArgs e)
{
try
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()))
{
var cmd = new SqlCommand(@"insert into tblEmployee values (@FirstName, @LastName, @JMBG, @DateOfBirth, @Gender, @RegNum, @PhoneNumber, @LocId, @SectorID, @ManagerID);", conn);
cmd.Parameters.AddWithValue("@FirstName", Employee.FirstName);
cmd.Parameters.AddWithValue("@LastName", Employee.LastName);
cmd.Parameters.AddWithValue("@JMBG", Employee.JMBG);
cmd.Parameters.AddWithValue("@DateOfBirth", Employee.DateOfBirth);
cmd.Parameters.AddWithValue("@Gender", Employee.Gender);
cmd.Parameters.AddWithValue("@RegNum", Employee.RegistrationNumber);
cmd.Parameters.AddWithValue("@PhoneNumber", Employee.PhoneNumber);
cmd.Parameters.AddWithValue("@LocId", Employee.Location.Id);
cmd.Parameters.AddWithValue("@SectorID", Employee.Sector.Id);
cmd.Parameters.AddWithValue("@ManagerID", 1);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Employee successfully created.", "Notification");
LogActions.LogAddEmployee(Employee);
}
catch (Exception)
{
}
}
/// <summary>
/// Method enables adding employee to the database.
/// </summary>
public void AddEmployee()
{
Thread.Sleep(2000);
using (var conn = new SqlConnection(ConnectionString))
{
var cmd = new SqlCommand(@"insert into tblEmployee values (@Name, @Surname, @JMBG, @DateOfBirth, @Gender, @RegNum, @PhoneNumber, @LocId, @SectorID, @ManagerID);", conn);
cmd.Parameters.AddWithValue("@Name", Employee.FirstName);
cmd.Parameters.AddWithValue("@Surname", Employee.LastName);
cmd.Parameters.AddWithValue("@JMBG", Employee.JMBG);
cmd.Parameters.AddWithValue("@DateOfBirth", Employee.DateOfBirth);
cmd.Parameters.AddWithValue("@Gender", Employee.Gender);
cmd.Parameters.AddWithValue("@RegNum", Employee.RegistrationNumber);
cmd.Parameters.AddWithValue("@PhoneNumber", Employee.PhoneNumber);
cmd.Parameters.AddWithValue("@LocId", Employee.Location.Id);
cmd.Parameters.AddWithValue("@SectorID", Employee.Sector.Id);
cmd.Parameters.AddWithValue("@ManagerID", Employee.Manager.Id);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Employee successfully created.", "Notification");
LogActions.LogAddEmployee(Employee);
}
/// <summary>
/// Method implements delete functionality.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void DeleteRow(object sender, DoWorkEventArgs e)
{
Thread.Sleep(2000);
if (row == null)
{
return;
}
foreach (var m in MainWindowViewModels)
{
if (m.Employee.Manager.Id == row.Employee.Id)
{
m.Employee.Manager = null;
}
}
var con = new SqlConnection(ConnectionString);
con.Open();
var cmd = new SqlCommand("delete from tblEmployee where EmployeeID = @EmployeeID;", con);
cmd.Parameters.AddWithValue("@EmployeeID", row.Employee.Id);
cmd.ExecuteNonQuery();
LogActions.LogDeleteEmployee(row.Employee);
//Object is removed from ongoing list.
App.Current.Dispatcher.Invoke((Action) delegate
{
MainWindowViewModels.Remove(row);
});
con.Close();
con.Dispose();
var messageBoxResult = System.Windows.MessageBox.Show("Delete Successfull", "Notification");
}
public void ReadFeatureClassFromSdeFileTest()
{
new ArcEngineLicense();
var fc = DataActions.GetFeatureClass(@"C:\OCNwork\东莞\dggisdata02.sde", DataSourceType.SdeFilePath, "GUIDAO_ZQ");
LogActions.LogFeatureClass(fc);
}
public void EditEmpoye(object sender, DoWorkEventArgs e)
{
try
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()))
{
var cmd = new SqlCommand(@"update tblEmployee set FirstName=@FirstName, LastName=@LastName, JMBG=@JMBG, DateOfBirth=@DateOfBirth, Gender=@Gender, RegistrationNumber=@RegistrationNumber, PhoneNumber=@PhoneNumber, LocationID=@LocationID, SectorID=@SectorID, ManagerID=@ManagerID where EmployeeID=@EmployeID", conn);
cmd.Parameters.AddWithValue("@EmployeID", employee.Id);
cmd.Parameters.AddWithValue("@FirstName", employee.FirstName);
cmd.Parameters.AddWithValue("@LastName", employee.LastName);
cmd.Parameters.AddWithValue("@JMBG", employee.JMBG);
cmd.Parameters.AddWithValue("@DateOfBirth", employee.DateOfBirth);
cmd.Parameters.AddWithValue("@Gender", employee.Gender);
cmd.Parameters.AddWithValue("@RegistrationNumber", employee.RegistrationNumber);
cmd.Parameters.AddWithValue("@PhoneNumber", employee.PhoneNumber);
cmd.Parameters.AddWithValue("@LocationID", employee.Location.Id);
cmd.Parameters.AddWithValue("@SectorID", employee.Sector.Id);
cmd.Parameters.AddWithValue("@ManagerID", employee.Manager.Id);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Employe successfully updated.", "Notification");
LogActions.LogEditEmployee(employee);
}
}
catch (Exception)
{
}
}
public int AddLogAction(ulong user, ulong moderator, Log.LogAction action, string reason = null, TimeSpan?length = null)
{
var id = LogActions.Any() ? LogActions.Max(x => x.CaseId) + 1 : 1;
var newAction = new Log(user, moderator, action, id, reason, length);
LogActions.Add(newAction);
return(id);
}
public Task Log(object message, SimpleLogLevel level)
{
if (this.ShouldLog(level))
{
var args = LogMessageArgs.Create(Category, message, level);
LogActions.Invoke(args);
}
return(Task.CompletedTask);
}
/// <summary>
/// Method responsible for removing existing product from the grid.
/// </summary>
public void DeleteProduct()
{
var con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());
con.Open();
var cmd = new SqlCommand("delete from tblProduct where ProductID = @ProductID;", con);
cmd.Parameters.AddWithValue("@ProductID", product.Id);
cmd.ExecuteNonQuery();
LogActions.LogDeleteProduct(product);
Products.Remove(product);
con.Close();
con.Dispose();
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Delete successfull.", "Notification");
}
/// <summary>
/// Method responsible for adding new product based on inserted values.
/// </summary>
public void AddProduct()
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()))
{
var cmd = new SqlCommand(@"insert into tblProduct values (@Name, @Code, @Amount, @Price, @Stored);", conn);
cmd.Parameters.AddWithValue("@Name", product.Name);
cmd.Parameters.AddWithValue("@Code", product.Code);
cmd.Parameters.AddWithValue("@Amount", product.Amount);
cmd.Parameters.AddWithValue("@Price", product.Price);
cmd.Parameters.AddWithValue("@Stored", false);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
LogActions.LogCreateProduct(product);
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Product Successfully created.", "Notification");
}
}
/// <summary>
/// Method executes query for editing selected product in the database.
/// </summary>
public void EditProduct()
{
var con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());
con.Open();
var cmd = new SqlCommand("update tblProduct set Name=@Name, Code=@Code, Amount=@Amount, Price=@Price, Stored=@Stored where ProductID=@ProductID;", con);
cmd.Parameters.AddWithValue("@ProductID", product.Id);
cmd.Parameters.AddWithValue("@Name", product.Name);
cmd.Parameters.AddWithValue("@Code", product.Code);
cmd.Parameters.AddWithValue("@Amount", product.Amount);
cmd.Parameters.AddWithValue("@Price", product.Price);
cmd.Parameters.AddWithValue("@Stored", EditProductWindow.Checked);
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
LogActions.LogEditProduct(product);
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Product successfully edited.", "Notification");
}
/// <summary>
/// 数据源图层名
/// </summary>
public void OnExecute()
{
switch (ActionArgument)
{
case ActionTypes.Adjust:
{
new ArcEngineLicense();
SpatialAdjust.Adjust();
break;
}
case ActionTypes.ImportData:
{
if (new string[] { Datasource, LayerName, OutDatasource, OutLayerName, ControlPoints }.Any(s => s == null))
{
Console.WriteLine("参数没有写全");
break;
//throw new Exception("参数没有写全");
}
new ArcEngineLicense();
SpatialAdjust sa = null;
try
{
sa = new SpatialAdjust(controlPointsFile: ControlPoints, controlPointsInputType: ControlPointsInputType, spatialAdjustMethodType: SpatialAdjustMethodType);
}
catch (Exception ex)
{
sa = null;
}
var inFc = DataActions.GetFeatureClass(Datasource, DataSourceType, LayerName);
ESRI.ArcGIS.Geodatabase.IFeatureClass outFc;
try
{
outFc = DataActions.GetFeatureClass(OutDatasource, OutDatasourceType, OutLayerName);
}
catch (Exception)
{
outFc = DataActions.CreateFeatureClass(DataActions.GetWorkspace(OutDatasource, OutDatasourceType), "", OutLayerName, inFc);
}
//Console.WriteLine($"将使用{ SpatialAdjust.transformMethodMap[sa.SpatialAdjustMethodType].Name} 偏移");
DataActions.CoverFeatureClassWithFeatureClass(inFc, outFc, sa);
break;
}
case ActionTypes.LogLayer:
{
new ArcEngineLicense();
LogActions.LogFeatureClass(Datasource, DataSourceType, LayerName);
}
break;
case ActionTypes.BatchImport:
{
new ArcEngineLicense();
var layerNames = LayerName.Split(',');
List <string> finalNameStringList = new List <string>();
var workspace = DataActions.GetWorkspace(Datasource, DataSourceType);
var featureWorkspace = (IFeatureWorkspace)workspace;
layerNames.ToList().ForEach((name) =>
{
try
{
featureWorkspace.OpenFeatureClass(name);
finalNameStringList.Add(name);
}
catch (Exception)
{
try
{
var dataset = featureWorkspace.OpenFeatureDataset(name);
var subs = dataset.FeatureDatasetsInFeatureDataset();
subs.ToList().ForEach(sub => finalNameStringList.Add(sub.Name));
}
catch (Exception)
{
}
}
});
finalNameStringList.ForEach((finalName) =>
{
new CommandLineController()
{
ActionArgument = ActionTypes.ImportData,
Datasource = Datasource,
DataSourceType = DataSourceType,
LayerName = finalName,
OutDatasource = OutDatasource,
OutDatasourceType = OutDatasourceType,
OutLayerName = $"{finalName.Split('.').Last()}_adjusted",
ControlPoints = ControlPoints,
ControlPointsInputType = ControlPointsInputType,
SpatialAdjustMethodType = SpatialAdjustMethodType
}.OnExecute();
});
}
break;
case ActionTypes.GenerateBatch:
{
new ArcEngineLicense();
var batchFileName = String.Empty;
//var dtn = DateTime.Now.ToFullTimeSecondString();
if (String.IsNullOrEmpty(BatchFileName))
{
var dtn = DateTime.Now;
var s = dtn.ToBinary();
batchFileName = $"bat{s}.bat";
}
else
{
batchFileName = BatchFileName;
}
var layerNames = LayerName.Split(',');
List <string> finalNameStringList = new List <string>();
var workspace = DataActions.GetWorkspace(Datasource, DataSourceType);
var featureWorkspace = (IFeatureWorkspace)workspace;
layerNames.ToList().ForEach((name) =>
{
try
{
featureWorkspace.OpenFeatureClass(name);
finalNameStringList.Add(name);
}
catch (Exception)
{
try
{
var dataset = featureWorkspace.OpenFeatureDataset(name);
var subs = dataset.FeatureDatasetsInFeatureDataset();
subs.ToList().ForEach(sub => finalNameStringList.Add(sub.Name));
}
catch (Exception)
{
}
}
});
using (StreamWriter sw = new StreamWriter(batchFileName, true, Encoding.Default))
//using (StreamWriter sw = File.AppendText(batchFileName))
{
var text = String.Empty;
finalNameStringList.ToList().ForEach((layerName) =>
{
//System.Reflection.Assembly.GetExecutingAssembly().FullName;
//sw.WriteLine( $"AoCli.exe " )
sw.WriteLine($@"AoCli.exe BatchImport -ln {layerName} -ds {Datasource} -dst {DataSourceType} -ods {OutDatasource} -odst {OutDatasourceType} -oln {OutLayerName} -cp {ControlPoints} -samt {SpatialAdjustMethodType}" + " \n");
//text += $@"AoCli.exe BatchImport -ln {layerName} -ds {Datasource} -dst {DataSourceType} -ods {OutDatasource} -oln {OutLayerName} -cp {ControlPoints} -samt {SpatialAdjustMethodType}";
//text += "\n";
});
sw.Write(text);
Console.WriteLine("Batch file generated");
}
}
break;
case ActionTypes.GPTest:
{
new Test.MyTestClass().ShapeInWhereTest3();
}
break;
default:
break;
}
}
public void AddLogAction(string action)
{
LogActions.Add(new LogAction {
ActionData = action
});
}
private Log(LogActions actions, string table)
{
_action = actions;
_table = table;
}
/// <summary>
/// Vytvoří Log bez podmínky, použíje se pro akce Insert, Update a Delete
/// </summary>
private Log(LogActions action, string table, int count)
{
_action = action;
_table = table;
_count = count;
}
