/// <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; }