/// <summary> /// this method is used to execute the copy command, by calling each of the appropriate methods to add not only the queries, but also the data to the second table /// </summary> /// <param name="database"> /// the name of the first database /// </param> /// <param name="database2"> /// the name of the second database /// </param> /// <param name="connNumber"> /// the connection number of the first database /// </param> /// <param name="connNumber2"> /// the connection number of the second database /// </param> /// <param name="queryStep"> /// the action we want to take every query action /// </param> /// <param name="justStructure"> /// a boolean dictating if the user just wants to copy the structure for now (incase they want to add any fields to the database before copying the data) /// </param> /// <returns> /// the asyncronous task, so it does not lock the UI /// </returns> public static void ExecuteCopy(string database, string database2, int connNumber, int connNumber2, Action <string> queryStep, Boolean justStructure) { //using the opened connection... using (DbConnection conn = SQLConnectionHandler.GetOpenedConnection(connNumber2)) { //using the opened transaction... using (DbTransaction sqlTran = conn.BeginTransaction()) { try { //run the queries before, after, and copy the data SQLQueryHandler.RunBeforeQueries(connNumber2, conn, sqlTran, queryStep); if (!justStructure) { SQLDataHandler.CopyData(database, database2, connNumber, connNumber2, conn, sqlTran, queryStep); } SQLQueryHandler.RunAfterQueries(connNumber2, conn, sqlTran, queryStep); //commit the changes sqlTran.Commit(); } catch (Exception) { // rollback the transaction on error sqlTran.Rollback(); throw; } } } }
// GET: TradePointsTypes public JsonResult Index() { return(Json( SQLConnectionHandler.GetInstance() .Execute(SQLCommand.SelectAllTradePointsTypes()).GetResult(), JsonRequestBehavior.AllowGet)); }
public bool Insert(Employee employee) { SQLConnectionHandler.GetInstance() .Execute(SQLCommand.InsertEmployee(employee), true); SQLConnectionHandler.GetInstance() .Execute(SQLCommand.InsertEmployeesList(employee), true); return(true); }
// GET: ObjectRelations public JsonResult Index() { return(Json( SQLConnectionHandler.GetInstance() .Execute(SQLCommand.SelectAllObjectsRelations()).GetResult(), JsonRequestBehavior.AllowGet )); }
public bool Update(TradePointProduct product) { if (product.Id < 0) { return(false); } SQLConnectionHandler.GetInstance() .Execute(SQLCommand.UpdateTradePointProduct(product), true); return(true); }
public bool Insert(TradePointPayment payment) { if (payment.Id < 0) { return(false); } SQLConnectionHandler.GetInstance() .Execute(SQLCommand.InsertTradePointPayment(payment), true); return(true); }
public bool Update(Supplier supplier) { if (supplier.Id < 0) { return(false); } SQLConnectionHandler.GetInstance() .Execute(SQLCommand.UpdateSupplier(supplier), true); return(true); }
public bool Delete(TradePoint point) { if (point.Id < 0) { return(false); } SQLConnectionHandler.GetInstance() .Execute(SQLCommand.DeleteTradePoint(point), true); return(true); }
public bool Delete(TradePointType type) { if (type.Id < 0) { return(false); } SQLConnectionHandler.GetInstance() .Execute(SQLCommand.DeleteTradePointType(type), true); return(true); }
public bool Update(TradePointCustomer customer) { if (customer.Id < 0) { return(false); } SQLConnectionHandler.GetInstance() .Execute(SQLCommand.UpdateTradePointsCustomer(customer), true); return(true); }
public bool Delete(ObjectRelation relation) { if (relation.Id < 0) { return(false); } SQLConnectionHandler.GetInstance() .Execute(SQLCommand.DeleteObjectsRelations(relation), true); return(true); }
public bool Update(TradePointSale sale) { if (sale.Id < 0) { return(false); } SQLConnectionHandler.GetInstance() .Execute(SQLCommand.UpdateTradePointSale(sale), true); return(true); }
public bool Update(Order order) { if (order.Id < 0) { return(false); } SQLConnectionHandler.GetInstance() .Execute(SQLCommand.UpdateOrder(order), true); return(true); }
public bool Update(TradePointRequest request) { if (request.Id < 0) { return(false); } SQLConnectionHandler.GetInstance() .Execute(SQLCommand.UpdateTradePointRequest(request), true); return(true); }
public bool Delete(Employee employee) { if (employee.Id < 0) { return(false); } SQLConnectionHandler.GetInstance() .Execute(SQLCommand.DeleteEmployee(employee), true); return(true); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); OracleConnection conn = DBUtils.GetDBConnection(); try { conn.Open(); } catch (Exception ex) { return; } SQLConnectionHandler.GetInstance().SetConnection(conn); }
/// <summary> /// this method is used to call the underlying method that will gather all Key values from the providers list /// </summary> /// <returns> /// the list of provider keys /// </returns> public static IEnumerable GetProviders() { return(SQLConnectionHandler.GetProviders()); }
public JsonResult Delete(int id) { return(Json(SQLConnectionHandler.GetInstance() .Execute(SQLCommand.DeleteTradePointRequest(id), true).GetResult(), JsonRequestBehavior.AllowGet)); }
public bool Insert(Order order) { SQLConnectionHandler.GetInstance() .Execute(SQLCommand.InsertOrder(order), true); return(true); }
// GET: Auth public JsonResult Index() { var result = SQLConnectionHandler.GetInstance().Execute(SQLCommand.SelectTest()).GetResult(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult Get(int id) { return(Json(SQLConnectionHandler.GetInstance() .Execute(SQLCommand.SelectTradePointRequests(id)).GetResult(), JsonRequestBehavior.AllowGet)); }
public bool Insert(TradePointCustomer customer) { SQLConnectionHandler.GetInstance() .Execute(SQLCommand.InsertTradePointsCustomer(customer), true); return(true); }
public bool Insert(ObjectRelation relation) { SQLConnectionHandler.GetInstance() .Execute(SQLCommand.InsertObjectsRelations(relation), true); return(true); }
public bool Insert(Supplier supplier) { SQLConnectionHandler.GetInstance() .Execute(SQLCommand.InsertSupplier(supplier), true); return(true); }
public JsonResult GetParents() { return(Json(SQLConnectionHandler.GetInstance() .Execute(SQLCommand.SelectAllParents()).GetResult(), JsonRequestBehavior.AllowGet)); }
public bool Insert(TradePoint point) { SQLConnectionHandler.GetInstance() .Execute(SQLCommand.InsertTradePoint(point), true); return(true); }
/// <summary> /// this method will set up any application related options that need to be set /// </summary> /// <param name="changes"> /// the action we want to use when adding a new change /// </param> public static void SetUp(Action <string> changes) { Change = changes; SQLConnectionHandler.AddProviders(); }
public bool Insert(Product product) { SQLConnectionHandler.GetInstance() .Execute(SQLCommand.InsertProduct(product), true); return(true); }
/// <summary> /// this method is used to call the method that will add a new connection /// </summary> /// <param name="serverType"> /// the type of server we are looking at (provider) /// </param> /// <param name="server"> /// the name of the server we are connecting to /// </param> /// <param name="integratedSecurity"> /// this is used if the provider is SQL server, and if is set, uses the Windows Login to login /// </param> /// <param name="username"> /// this is the username to use for this connection /// </param> /// <param name="password"> /// this is the password to use for this connection /// </param> /// <returns> /// the ID used to identify this connection throughout the application /// </returns> public static int AddNewConnection(string serverType, string server, bool integratedSecurity, string username, string password) { return(SQLConnectionHandler.AddNewConnection(serverType, server, integratedSecurity, username, password)); }
/// <summary> /// this method is used to reset the SQL objects defined, such as remove connections and clear queries /// </summary> public static void Reset() { SQLConnectionHandler.RemoveConnections(); SQLQueryHandler.ClearQueries(); }