/// <summary> /// Validates the data object while executing DeleteFromStore. /// </summary> /// <returns> /// A collection of validation results. /// </returns> protected override IEnumerable <ValidationResult> ValidateForDelete() { // Validate Trajectory uid property if (string.IsNullOrWhiteSpace(DataObject.UidWell) || string.IsNullOrWhiteSpace(DataObject.UidWellbore) || string.IsNullOrWhiteSpace(DataObject.Uid)) { yield return(new ValidationResult(ErrorCodes.DataObjectUidMissing.ToString(), new[] { "Uid", "UidWell", "UidWellbore" })); } else { var uri = DataObject.GetUri(); var stations = DataObject.TrajectoryStation; if (stations != null) { foreach (var validationResult in ValidateTrajectoryStations(stations)) { yield return(validationResult); } } var current = DataAdapter.Get(uri); // Validate Trajectory does not exist if (current == null) { yield return(new ValidationResult(ErrorCodes.DataObjectNotExist.ToString(), new[] { "Uid", "UidWell", "UidWellbore" })); } } }
/// <summary> /// Bindet die CheckBox an eine Datenquelle /// </summary> /// <param name="Adapter">Datenquelle</param> /// <param name="BitPosition">Bit Position die verwendet werden soll</param> public void Bind(DataAdapter <byte> Adapter, int BitPosition) { this.Adapter = Adapter; this.BitPosition = BitPosition; Adapter.DataChanged += Adapter_DataChanged; Adapter_DataChanged(Adapter.Value, null); }
public virtual bool DeleteStudy(IStudyId study) { long studyKey = GetStudyKey(DataAdapter, study); return(DataAdapter.CreateDeleteStudyCommand(studyKey).Execute( )); }
public Order GetByName(string OrderNumber) { Order order = null; Con = CreateConnection(); Query = "SelectOrder"; Com.CommandText = Query; Com.Connection = Con; Com.CommandType = CommandType.StoredProcedure; Com.Parameters.Clear(); Com.Parameters.Add(new SqlParameter("@OrderNumber", OrderNumber)); DataAdapter.SelectCommand = Com; DataTable dataTable = new DataTable(); DataAdapter.Fill(dataTable); foreach (DataRow row in dataTable.Rows) { order = new Order.Builder() .setCustomerNumber(row["customerID"].ToString()) .setOrderNumber(row["ordernumber"].ToString()) .setDate(Convert.ToDateTime(row["datecreated"].ToString())) .Build(); GetItemsAsync(OrderNumber).Result.ForEach(i => order.Products.Add(i)); } return(order); }
public virtual bool DeleteSeries(ISeriesId series) { long seriesKey = GetSeriesKey(DataAdapter, series); return(DataAdapter.CreateDeleteSeriesCommand(seriesKey).Execute( )); }
public static DataSet Query(string commandText, IDictionary <string, object> parameters) { DbConnection connection = null; DbCommand command = DbProviderFactory.CreateCommand(); try { command.CommandText = commandText; parameters = parameters ?? new Dictionary <string, object>(); foreach (var item in parameters) { command.Parameters.Add(BuildDbParameter(item.Key, item.Value)); } connection = DbProviderFactory.CreateConnection(); connection.ConnectionString = ConnectionString; command.Connection = connection; connection.Open(); DataAdapter adapter = DbProviderFactory.CreateDataAdapter(); DataSet ds = new DataSet(); adapter.Fill(ds); return(ds); } catch (SqlException e) { throw e; } finally { connection.Close(); connection.Dispose(); } }
/// <summary> /// Validates the data object while executing UpdateInStore. /// </summary> /// <returns> /// A collection of validation results. /// </returns> protected override IEnumerable <ValidationResult> ValidateForUpdate() { // Validate MudLog uid property if (string.IsNullOrWhiteSpace(DataObject.UidWell) || string.IsNullOrWhiteSpace(DataObject.UidWellbore) || string.IsNullOrWhiteSpace(DataObject.Uid)) { yield return(new ValidationResult(ErrorCodes.DataObjectUidMissing.ToString(), new[] { "Uid", "UidWell", "UidWellbore" })); } else { var uri = DataObject.GetUri(); var geologyIntervals = DataObject.GeologyInterval; if (geologyIntervals != null) { foreach (var validationResult in ValidateMudlogGeologyIntervals(geologyIntervals)) { yield return(validationResult); } } var current = DataAdapter.Get(uri); // Validate MudLog does not exist if (current == null) { yield return(new ValidationResult(ErrorCodes.DataObjectNotExist.ToString(), new[] { "Uid", "UidWell", "UidWellbore" })); } } }
public RegisterFileMap() { Data = new DataAdapter<byte>[RegisterConstants.REGISTER_FILE_MAP_SIZE]; // Data[256] <= Working Register for (int X = 0; X < Data.Length; X++) { Data[X] = new DataAdapter<byte>(); } // I/O Ports as IOAdapter Data[RegisterConstants.PORTA_ADDRESS] = new IOAdapter(this, RegisterConstants.PORTA_ADDRESS); Data[RegisterConstants.PORTB_ADDRESS] = new IOAdapter(this, RegisterConstants.PORTB_ADDRESS); // link mirrored registers Data[RegisterConstants.INDF_BANK1_ADDRESS] = Data[RegisterConstants.INDF_ADDRESS]; Data[RegisterConstants.PCL_BANK1_ADDRESS] = Data[RegisterConstants.PCL_ADDRESS]; Data[RegisterConstants.STATUS_BANK1_ADDRESS] = Data[RegisterConstants.STATUS_ADDRESS]; Data[RegisterConstants.FSR_BANK1_ADDRESS] = Data[RegisterConstants.FSR_ADDRESS]; Data[RegisterConstants.PCLATH_BANK1_ADDRESS] = Data[RegisterConstants.PCLATH_ADDRESS]; Data[RegisterConstants.INTCON_BANK1_ADDRESS] = Data[RegisterConstants.INTCON_ADDRESS]; for (int X = 0; X < Data.Length; X++) { Data[X].Value = 0; } initializeValues(); }
private bool Insert(string area, string name, string color, string position, int quantity, string userName, string memo) { DataAdapter da = new DataAdapter(); var result = da.Insert(area, name, color, position, quantity, userName, memo); return(result == 1); }
/// <summary> /// Disable EWS Server functions that aren't needed in this solution and enable those that are. /// </summary> private void EnsureSupportedMethods() { CheckCancellationToken(); DataAdapter.ModifyServerSupportedMethods(new EwsServerMethods { AcknowledgeAlarmEvents = false, ForceValues = false, GetAlarmEventTypes = false, GetAlarmEvents = false, GetAlarmHistory = false, GetEnums = false, GetHierarchicalInformation = false, GetUpdatedAlarmEvents = false, UnforceValues = false, GetContainerItems = true, GetHistory = true, GetItems = true, GetNotification = true, GetValues = true, GetWebServiceInformation = true, Renew = true, SetValues = true, Subscribe = true, Unsubscribe = true }); }
public override void Run(object context) { DbController dbc = new DbController(Connection); try { Product product = dbc.GetRandomProduct(); DataTable table = new DataTable(); Command.CommandText = DbDefault.GetInnerJoinSelectStatement( Relation.PRODUCT_CATEGORY, new long[] { product.ProductId }); DataAdapter.Fill(table); if (table.Columns.Count != (DbDefault.GetTableStructure(TableName.PRODUCT).Columns.Count + DbDefault.GetTableStructure(TableName.CATEGORY).Columns.Count)) { Fail("Number of returned columns is incorrect"); } ParseDataTable(table); } catch (Exception e) { Fail(e); } finally { base.Run(context); } }
protected override IEnumerable <Prompt> Execute_Subclass() { // Make sure we can connect to an EWS Server if (!IsConnected) { return new List <Prompt> { CreateCannotConnectPrompt() } } ; // If the server isn't running, start it now. if (!DataAdapter.Server.IsRunning) { DataAdapter.StartServer(); } // Confirm that the server settings are how we want them be. EnsureServerParameters(); // Add the fields a client can use to "set" the location AddUserInputFields(); // Add the folders and data points where we'll write the current weather conditions (in UpdateProcessor) AddCurrentConditionPlaceHolders(); // Add the folders and data points where we'll write the forecast (in UpdateProcessor) AddForecastPlaceHolders(); // Return any issues return(new List <Prompt>()); }
private async Task DeleteById(MessageEvent mev, string[] messageSpilt) { int id; if (messageSpilt.Count() != 2) { await messagingClient.ReplyMessageAsync(mev.ReplyToken, new List <ISendMessage> { new TextMessage("更新指令錯誤!!\n - [編號]") }); return; } if (!int.TryParse(messageSpilt[1], out id)) { await messagingClient.ReplyMessageAsync(mev.ReplyToken, new List <ISendMessage> { new TextMessage("參數錯誤!\n輸入的編號不是數字!") }); return; } DataAdapter da = new DataAdapter(); var result = da.DelectByID(id); var replyMessage = "刪除失敗"; if (result == 1) { replyMessage = "刪除成功"; } await messagingClient.ReplyMessageAsync(mev.ReplyToken, new List <ISendMessage> { new TextMessage(replyMessage) }); }
public void Execute(string dbName, string sqlStr) { using (CJia.DataAdapter ada = new DataAdapter(dbName)) { ada.Execute(sqlStr); } }
public S_FileInfo(string ID, S_DOC_Space space) { this._initEntity(); if (space == null) { throw new Formula.Exceptions.BusinessException("档案配置对象未空,无法实例化编目节点对象"); } this.Space = space; this.InstanceDB = SQLHelper.CreateSqlHelper(this.Space.SpaceKey, this.Space.ConnectString); string sql = String.Format("select * from {0} where ID='{1}' ", TableName, ID); var dt = this.InstanceDB.ExecuteDataTable(sql); if (dt != null && dt.Rows.Count > 0) { var row = dt.Rows[0]; _validateColumns(row); DataAdapter.DataRowToHashTable(row, this.DataEntity); this.ConfigInfo = this.Space.S_DOC_File.FirstOrDefault(d => d.ID == this.DataEntity["ConfigID"].ToString()); if (this.ConfigInfo == null) { throw new Formula.Exceptions.BusinessException("未找到ID为【" + this.DataEntity["ConfigID"].ToString() + "】编目定义对象,无法实例化编目节点对象"); } } else { throw new Formula.Exceptions.BusinessException("未能找到ID为【" + ID + "】的编目节点"); } }
private void LoadDistressMapping() { string query = "SELECT * FROM PCI_DISTRESS"; if (pciDistressMapAdapter != null) { pciDistressMapAdapter.Dispose(); // Free up the resources } if (binding != null) { binding.Dispose(); } if (table != null) { table.Dispose(); } pciDistressMapAdapter = new DataAdapter(query); // Populate a new data table and bind it to the BindingSource. table = new DataTable(); table.Locale = System.Globalization.CultureInfo.InvariantCulture; pciDistressMapAdapter.Fill(table); binding = new BindingSource(); binding.DataSource = table; dgvDistressMapping.DataSource = binding; }
/// <summary> /// Execute the SQL Query and return in DataTable, then Close the connection automatically /// </summary> /// <param name="sql">SQL Query</param> /// <returns>Data Table</returns> public DataTable Read(string sql) { DataTable dt = null; try { dt = new DataTable(); _connection = new OleDbConnection(this.ConnectionString); _command = new OleDbCommand(sql); _command.CommandTimeout = this.m_time_out; _command.Connection = _connection; _connection.Open(); DataAdapter.SelectCommand = _command; DataAdapter.Fill(dt); } catch (Exception e) { throw new Exception("Err in Read():" + e.Message); } finally { this.Close(); } return(dt); }
public virtual bool DeleteInstance(IObjectId instance) { long instanceKey = GetInstanceKey(DataAdapter, instance); return(DataAdapter.CreateDeleteInstancCommand(instanceKey).Execute( )); }
public decimal CalculateCostIndex(DateTime date, DateTime toDate, uint supplierId, ulong regionId, Hashtable quantities) { decimal result = 0; var command = DataAdapter.SelectCommand; command.CommandText = @" select a.ProductId, a.ProducerId, a.Cost from Reports.AverageCosts a join Reports.AverageCosts a1 on a.SupplierId = a1.SupplierId and a.RegionId = a1.RegionId and a.ProductId = a1.ProductId and a.ProducerId = a1.ProducerId and a1.Date = ?toDate where a.SupplierId = ?supplierId and a.RegionId = ?regionId and a.Date = ?date "; command.Parameters.Clear(); command.Parameters.AddWithValue("supplierId", supplierId); command.Parameters.AddWithValue("regionId", regionId); command.Parameters.AddWithValue("date", date); command.Parameters.AddWithValue("toDate", toDate); var table = new DataTable(); DataAdapter.Fill(table); foreach (DataRow row in table.Rows) { var quantiry = quantities[row["ProductId"] + "|" + row["ProducerId"]]; if (quantiry == null) { continue; } result += Convert.ToDecimal(row["Cost"]) * Convert.ToDecimal(quantiry); } return(result); }
public DataTable ExecuteSelectQuery(string _query, SqlParameter[] parameters) { SqlCommand command = new SqlCommand(); DataTable dataTable = null; DataSet ds = new DataSet(); try { command.Connection = open(); command.CommandText = _query; command.Parameters.AddRange(parameters); command.ExecuteNonQuery(); DataAdapter.SelectCommand = command; DataAdapter.Fill(ds); dataTable = ds.Tables[0]; } catch (Exception ex) { writeError($"Requête : {_query} \nSqlException : {ex.StackTrace.ToString()}"); } finally { Connection.Close(); } return(dataTable); }
public static TransactionModel[] GetByMonth(int month, int year) { using (OleDbConnection conn = DatabaseManager.GetConnection()) { OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = string.Format( @"SELECT [transac.codeTransaction] AS codeTransaction, [transac.dateTransaction] AS dateTransaction, [transac.description] AS description, [transac.montant] AS montant, [transac.recetteON] AS recetteON, [transac.percuON] AS percuON, [transac.type] AS [type], [typeTransac.libType] AS typeTransaction_s FROM [{0}] transac, [{1}] typeTransac WHERE Month(dateTransaction) = {2} AND Year(dateTransaction) = {3} AND typeTransac.codeType = transac.type", TABLE_NAME, TypeTransactionRepository.TABLE_NAME, month, year ); conn.Open(); return(DataAdapter.OleDbDataReaderToStruct <TransactionRepository.TransactionModel>(cmd.ExecuteReader()).ToArray()); } }
private Hashtable GetQuantities() { var begin = date.AddMonths(-1); var end = date; //join Catalogs.Catalog c on c.Id = p.CatalogId вроде бы не нужен //но без него оптимизатор строит неправильный план command.CommandText = String.Format(@" select ol.ProductId, ol.CodeFirmCr as ProducerId, sum(ol.Quantity) as quantity from {0}.OrdersHead oh join {0}.OrdersList ol on oh.RowId = ol.OrderId join Catalogs.Products p on p.Id = ol.ProductId join Catalogs.Catalog c on c.Id = p.CatalogId join Catalogs.Assortment a on a.CatalogId = c.Id and a.ProducerId = ol.CodeFirmCr join usersettings.pricesdata pd on pd.PriceCode = oh.PriceCode where oh.WriteTime >= ?begin and oh.WriteTime <= ?end and pd.IsLocal = 0 group by a.Id", OrdersSchema); command.Parameters.Clear(); command.Parameters.AddWithValue("begin", begin); command.Parameters.AddWithValue("end", end); var quantityTable = new DataTable(); DataAdapter.Fill(quantityTable); var quantities = new Hashtable(); foreach (DataRow row in quantityTable.Rows) { quantities.Add(row["ProductId"] + "|" + row["ProducerId"], Convert.ToDecimal(row["quantity"])); } return(quantities); }
public void LoadLocation(int locationId) { LauncherErrorManager.Instance.Hide(); Contexts.sharedInstance.game.DestroyAllEntities(); _isConnecting = true; if (LoaderAnime != null) { LoaderAnime.StartLoaderAnimation(); } LogFeedback(LanguageManager.Instance.GetTextValue("SCENE_LOADING")); LoaderSystems loaderSystems = new LoaderSystems(Contexts.sharedInstance); loaderSystems.Initialize(); WorldDataListener.OnUpdate = () => loaderSystems.Execute(); DataAdapter.LoadObjects(); SceneLoaderSystem sceneLoader = new SceneLoaderSystem(Contexts.sharedInstance, null, locationId); sceneLoader.Initialize(); }
public int Insert() { DataAdapter da = new DataAdapter(); var result = da.Insert("A", "CVC", "color", "11區", 132, "U206d25c2ea6bd87c17655609a1c37cb8", "備註"); return(result); }
private IEnumerable <TextileStore> TextileStoreList(string area) { DataAdapter da = new DataAdapter(); var result = da.SearchArea(area); return(result); }
/// <summary> /// 通过Sql参数查询返回DataTable /// </summary> /// <param name="sql">Sql语句</param> /// <param name="parameters">查询参数</param> /// <returns></returns> public DataTable GetDataTableWithSql(string sql, List <DbParameter> parameters) { DbConnection conn = DbFactory.GetDbConnection(_dbType); conn.ConnectionString = db.Database.Connection.ConnectionString; if (conn.State != ConnectionState.Open) { conn.Open(); } DbCommand cmd = DbFactory.GetDbCommand(_dbType); cmd.Connection = conn; cmd.CommandText = sql; if (parameters != null && parameters.Count > 0) { foreach (var item in parameters) { cmd.Parameters.Add(item); } } DataAdapter adapter = DbFactory.GetDataAdapter(_dbType, cmd); DataSet table = new DataSet(); adapter.Fill(table); cmd.Parameters.Clear(); conn.Close();//连接需要关闭 conn.Dispose(); return(table.Tables[0]); }
public virtual void StoreInstance ( IObjectId objectId, IEnumerable <IDicomDataParameter> parameters, InstanceMetadata data = null ) { //TODO: use transation //dbAdapter.CreateTransation ( ) var cmd = DataAdapter.CreateInsertCommand(objectId, parameters, data); cmd.Connection.Open( ); try { int rowsInserted = cmd.ExecuteNonQuery( ); if (rowsInserted <= 0) { //return duplicate instance?!!! } if (null != data) { StoreInstanceMetadata(objectId, data); } } finally { cmd.Connection.Close( ); } }
private ITableDataSet GetTableDataSet() { var tableDataSet = DataAdapter?.GetTableDataSet(conf => { conf.LazyLoadingOptions = LazyLoadingOptions; conf.PageableOptions.PageSize = PageSize; conf.GridViewEvents = new GridViewEvents { SaveOperationFinished = this.SaveOperationFinished, DeleteOperationFinished = this.DeleteOperationFinished, NewItemCreated = this.NewItemCreated, OnItemClicked = this.OnItemClicked }; }); if (tableDataSet is null) { return(new TableDataSet <EmptyDataSetItem>(Enumerable.Empty <EmptyDataSetItem>().AsQueryable())); } tableDataSet = MasterDetailTableDataSetFactory.ConvertToMasterTableIfIsRequired(tableDataSet); return(tableDataSet); }
static void init() { if (string.IsNullOrEmpty(rootPath)) { return; } matchRules = MatchRules(); TempImpl tempImpl = new TempImpl(); tempImpl.SetRootPath(rootPath); tempImpl.IsShowCodeOfDataResourceDLL = dbInfo.IsShowCode; DataAdapter.SetConfig(dbInfo.ConnectionString, dbInfo.DatabaseType); assemblies = DJTools.GetAssemblyCollection(rootPath); AutoCall.AssemblyCollection = assemblies; AutoCall.SetDataProviderAssemble(dbInfo.SqlProviderRelativePathOfDll); AutoCall.RootPath = rootPath; AutoCall.GetDllAbsolutePathByRelativePath = GetDllAbsolutePathByRelativePath; DbList <Data.Common.DbParameter> .dataServerProvider = dataServerProvider; if (null != DbHelper) { DbHelper.connectString = dbInfo.ConnectionString; DbHelper.optByBatchMaxNumber = dbInfo.optByBatchMaxNumber; DbHelper.optByBatchWaitSecond = dbInfo.optByBatchWaitSecond; DbHelper.sqlMaxLengthForBatch = dbInfo.sqlMaxLengthForBatch; DbHelper.disposableAndClose = dbInfo.close; } }
protected void LogIn(object sender, EventArgs e) { if (IsValid) { // Validate the user password //var manager = new UserManager(); //ApplicationUser user = manager.Find(UserName.Text, Password.Text); //if (user != null) //{ // IdentityHelper.SignIn(manager, user, RememberMe.Checked); // IdentityHelper.RedirectToReturnUrl(Request.QueryString["ReturnUrl"], Response); //} if (UserName.Text != null) { DataAdapter da = new DataAdapter(); DataSet userSet=da.ExecuteSelectQuery("Select * from Users where UserArchived=0 and UserToken='"+UserName.Text.Replace("'","''")+"'"); if(userSet!=null && userSet.Tables.Count>0 && userSet.Tables[0].Rows.Count > 0) { da.ExecuteUpdateQuery("Update Users set UserLastLoggedIn=GETDATE() where UserToken='" + UserName.Text.Replace("'", "''") + "'"); DataTable userTable = userSet.Tables[0]; Session["UserToken"]=userTable.Rows[0]["UserId"]; IdentityHelper.RedirectToReturnUrl(Request.QueryString["ReturnUrl"], Response); } } else { FailureText.Text = "Invalid code"; ErrorMessage.Visible = true; } } }
private bool DeleteById(int id) { DataAdapter da = new DataAdapter(); var result = da.DelectByID(id); return(result == 1); }
private DataAdapter LoadAdapter(ref InstrumentDataRequest dataRequest, bool useCache = true) { InstrumentDataRequest cRequest = dataRequest; cRequest.Resolution = Resolution.GetBaseValue(dataRequest.Resolution); DataAdapter cAdapter = new DataAdapter(cRequest); InstrumentDataRequest cDataRequest = cAdapter.Series.DataRequest; dataRequest.Range.Count = cDataRequest.Range.Count; //將正確的請求歷史資料數量傳入至結構 if (useCache) { //使用快取(true=建立完 DataAdapter 之後,將其保存至快取內以方便後續請求時使用) if (!cDataRequest.Range.IsAlreadyRequestAllData) { cAdapter.onCompleted += DataAdapter_onCompleted; string sLSymbolId = dataRequest.Symbol.ToLower(); int iTotalSeconds = cDataRequest.Resolution.TotalSeconds; if (iTotalSeconds < Resolution.MAX_BASE_TOTALSECONDS) { lock (__cMinBases) { if (!__cMinBases.ContainsKey(sLSymbolId)) { __cMinBases.Add(sLSymbolId, cAdapter); } } } else { lock (__cDayBases) { if (!__cDayBases.ContainsKey(sLSymbolId)) { __cDayBases.Add(sLSymbolId, cAdapter); } } } } } return cAdapter; }
public EEPROMMemory() { eeprom = new DataAdapter<byte>[EEPROM_MEMORY_SIZE]; for (int i = 0; i < EEPROM_MEMORY_SIZE; i++) { eeprom[i] = new DataAdapter<byte>(); } }
async void LoadAccounts () { var results = await Client.QueryAsync ("SELECT Id, Name, AccountNumber, Phone, Website, Industry FROM Account"); var resultRecords = results.Select (s => s.As<AccountObject> ()).ToList (); System.Diagnostics.Debug.WriteLine ("records: {0}", resultRecords.Count); ListAdapter = new DataAdapter (this, resultRecords); }
private void GetArtifactList() { DataAdapter dataAdapter = new DataAdapter(); DataSet ds = new DataSet(); //ds=dataAdapter.ExecuteSelectQuery("Select * from Artifact where Datalength(ArtifactText) <> 0 and ArtifactText like '%Wikipedia%' order by ArtifactId desc "); ds = dataAdapter.ExecuteStoredProcedure("usp_getArtifactsWithTopReviews",new System.Data.SqlClient.SqlParameter[] { }); gv_SurveyMaster.DataSource = ds.Tables[0]; gv_SurveyMaster.DataBind(); }
private DataTable getReviews(long reviewRefId) { DataAdapter dataAdapter = new DataAdapter(); SqlParameter[] parameters = new SqlParameter[1]; parameters[0]=new SqlParameter("@reviewRefId", reviewRefId); DataSet ds = dataAdapter.ExecuteStoredProcedure("sp_GetReviewDetails", parameters); return ds.Tables[0]; }
protected void btnSave_Click(object sender, EventArgs e) { DataAdapter da = new DataAdapter(); long artifactId = 0; //todo this should be converted into a stored procedure. Check if review is already done by the user. if (Session["UserToken"] != null && Session["ReviewRefId"]!=null) { long surveyId = 0; DataSet ds = da.ExecuteSelectQuery("SELECT top 1 surveyId FROM SURVEYMASTER WHERE ReviewId=" + Session["ReviewRefId"] + "and UserId=" + Session["UserToken"]); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count>0) { surveyId = Convert.ToInt64(ds.Tables[0].Rows[0][0]); } if (surveyId == 0) { //new survey String query="insert into SurveyMaster values("+Session["ReviewRefId"]+","+Session["UserToken"]+",getdate())"; da.ExecuteInsertQuery(query); //read the latest input query. surveyId = Convert.ToInt64(da.ExecuteSelectQuery("SELECT top 1 surveyId FROM SURVEYMASTER WHERE ReviewId=" + Session["ReviewRefId"] + "and UserId=" + Session["UserToken"]).Tables[0].Rows[0][0]); DataTable datatable = getQuestions(); if (r_SurveyQuestions.Controls.Count > 0) { List<RepeaterItem> listItem = r_SurveyQuestions.Controls.OfType<RepeaterItem>().ToList(); for (int i = 0; i < listItem.Count(); i++) { RadioButtonList rbl = listItem[i].Controls.OfType<RadioButtonList>().ToList()[0]; //DropDownList ddl = listItem[i].Controls.OfType<DropDownList>().ToList()[0]; long answerId = Convert.ToInt64(rbl.SelectedValue); long questionId = Convert.ToInt64(datatable.Rows[i]["QuestionId"]); artifactId = Convert.ToInt64(datatable.Rows[i]["ArtifactId"]); DataTable dt = da.ExecuteSelectQuery("select * from SURVEYANSWER where questionId=" + questionId + " and surveyId= " + surveyId).Tables[0]; if (dt == null || dt.Rows.Count == 0) { da.ExecuteInsertQuery("INSERT INTO SURVEYANSWER VALUES(" + questionId + "," + surveyId + "," + answerId + ",'',getdate())"); } } } } else { //existing survey //to-do } Session["ReviewRefId"] = null; ClientScript.RegisterStartupScript(typeof(Page), "closePage", "window.close();", true); } //else //Response.Redirect("surveyMaster"); }
public OperationStack() { this.stack = new DataAdapter<short>[STACK_SIZE]; for (int i = 0; i< STACK_SIZE; i++) { this.stack[i] = new DataAdapter<short>(); } initializeValues(); }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate (savedInstanceState); var objectKey = Intent.GetStringExtra ("objectKey"); var target = GetKeyedObject (objectKey); var data = new ObjectInspectorData (target); ListAdapter = new DataAdapter (data, this); Title = data.Title; }
public ProgamMemory() { programMemory = new DataAdapter<short>[ProgamMemoryConstants.SIZE_OF_PROGRAM_MEMORY]; breakpoints = new bool[ProgamMemoryConstants.SIZE_OF_PROGRAM_MEMORY]; for (int x = 0; x < ProgamMemoryConstants.SIZE_OF_PROGRAM_MEMORY; x++) { programMemory[x] = new DataAdapter<short>(); programMemory[x].Value = 0; breakpoints[x] = false; } }
public IOForm(RegisterFileMap _registerFileMap) { this.registerFileMap = _registerFileMap; // Listener fuer GUI-Aktualisierung this.portAListener = new DataAdapter<byte>.OnDataChanged(onPortAChange); this.portBListener = new DataAdapter<byte>.OnDataChanged(onPortBChange); this.trisAListener = new DataAdapter<byte>.OnDataChanged(onTrisAChange); this.trisBListener = new DataAdapter<byte>.OnDataChanged(onTrisBChange); registerFileMap.registerDataListener(portAListener, RegisterConstants.PORTA_ADDRESS); registerFileMap.registerDataListener(portBListener, RegisterConstants.PORTB_ADDRESS); registerFileMap.registerDataListener(trisAListener, RegisterConstants.TRISA_BANK1_ADDRESS); registerFileMap.registerDataListener(trisBListener, RegisterConstants.TRISB_BANK1_ADDRESS); Disposed += delegate { registerFileMap.unregisterDataListener(portAListener, RegisterConstants.PORTA_ADDRESS); }; Disposed += delegate { registerFileMap.unregisterDataListener(portBListener, RegisterConstants.PORTB_ADDRESS); }; Disposed += delegate { registerFileMap.unregisterDataListener(trisAListener, RegisterConstants.TRISA_BANK1_ADDRESS); }; Disposed += delegate { registerFileMap.unregisterDataListener(trisBListener, RegisterConstants.TRISB_BANK1_ADDRESS); }; int i = 0; // PORT-Checkboxes dynamisch erstellen for (i = 0; i < 8; i++) { PortA[i] = new CheckBox(); PortA[i].Location = new Point(58 + i * 21, 50); PortA[i].MouseClick += new MouseEventHandler(CheckboxChanged); PortA[i].Name = "checkBoxBitA" + (7 - i).ToString(); PortA[i].Width = 15; PortA[i].Height = 15; PortB[i] = new CheckBox(); PortB[i].Location = new Point(58 + i * 21, 96); PortB[i].MouseClick += new MouseEventHandler(CheckboxChanged); PortB[i].Name = "checkBoxBitB" + (7 - i).ToString(); PortB[i].Width = 15; PortB[i].Height = 15; } HexBoxPortA = new RegisterItem(registerFileMap.getAdapter(RegisterConstants.PORTA_ADDRESS), 58 + i * 21, 50, this); HexBoxPortB = new RegisterItem(registerFileMap.getAdapter(RegisterConstants.PORTB_ADDRESS), 58 + i * 21, 96, this); this.Controls.AddRange(PortA); this.Controls.AddRange(PortB); this.Controls.Add(HexBoxPortA); InitializeComponent(); updateTrisA(registerFileMap.Get(RegisterConstants.TRISA_BANK1_ADDRESS)); updateTrisB(registerFileMap.Get(RegisterConstants.TRISB_BANK1_ADDRESS)); updatePortA(registerFileMap.Get(RegisterConstants.PORTA_ADDRESS)); updatePortB(registerFileMap.Get(RegisterConstants.PORTB_ADDRESS)); }
private DataTable getQuestions() { DataAdapter da = new DataAdapter(); try { SqlParameter[] sqlParameter = new SqlParameter[1]; sqlParameter[0] = new SqlParameter("@reviewId", Convert.ToInt64(Session["ReviewRefId"])); DataSet ds = da.ExecuteStoredProcedure("sp_GetSurveyQuestions", sqlParameter); if (ds.Tables.Count > 0) return ds.Tables[0]; } catch { } return new DataTable(); }
/// <summary> /// get all the reviews for artifact /// </summary> /// <param name="id"></param> private DataTable getReviewStatus(long id) { DataTable dt = new DataTable(); try { DataAdapter dataAdapter = new DataAdapter(); SqlParameter[] sqlParameter = new SqlParameter[1]; //sqlParameter[0] = new SqlParameter("@userId", Session["UserToken"]); sqlParameter[0] = new SqlParameter("@artifactId", id); DataSet ds = dataAdapter.ExecuteStoredProcedure("usp_getTopRatedReviews", sqlParameter); dt = ds.Tables[0]; } catch (Exception ex) { } return dt; }
public RegisterItem(DataAdapter<byte> _dataAdapter, int _positionX, int _positionY, System.Windows.Forms.Control _parent) { Parent = _parent; // this.BackColor = backColor; // this.ForeColor = foreColor; this.Text = _dataAdapter.Value.ToString("X2"); this.dataAdapter = _dataAdapter; this.value = dataAdapter.Value; // onChange listener dataAdapter.DataChanged += onValueChange; Disposed += delegate { dataAdapter.DataChanged -= onValueChange; }; // set default values this.SetBounds(_positionX, _positionY, WIDTH, HEIGHT); this.ReadOnly = true; this.MouseEnter += showTooltip; this.MouseLeave += hideTooltip; this.DoubleClick += createNewHexBox; this.Show(); this.updateTimer = new Helpers.UpdateTimer(ACTIVE_DURATION, new System.Timers.ElapsedEventHandler(onTimerExpiredHandler)); }
private DataTable readArtifact(long id) { DataAdapter dataAdapter = new DataAdapter(); DataSet ds = dataAdapter.ExecuteSelectQuery("SELECT ArtifactText, ArtifactHeader FROM ARTIFACT WHERE ARTIFACTID=" + id); return ds.Tables[0]; }
public void Mode_EditBroadcast(WebModuleParams wmp) { Int32 castid = Int32.Parse(wmp["editbroadcast"]); Controls.AddLiteral("<div class=\"toolbar\">"); Controls.AddLiteral("<a href=\"", this.ModuleRoot, "\" title=\"", Lang["navbar.root.title"], "\">", Lang["navbar.root"], "</a>"); Controls.AddLiteral(" | <a href=\"", this.ModuleRoot, "/cast/", castid, "\" title=\"", Lang["navbar.view.title"], "\">", Lang["navbar.view"], "</a>"); Controls.AddLiteral("</div>"); String name = new DataAdapter().Select("NAME").From("BROADCASTING").JoinExt("TEXT").Where("ID = @castid") .AddParametr("@castid", castid) .GetDataScalar() as String ?? "noname"; Controls.AddLiteral("<h1>", name, "</h1>"); Controls.AddLiteral("<div id=\"Sites_video_broadcasting_chanel_tabs\" style=\"display:none;\">"); Controls.AddLiteral("<ul>"); Controls.AddLiteral("<li><a href=\"#tab-1\">", Lang["tab.common"], "</a></li>"); Controls.AddLiteral("<li><a href=\"#tab-2\">", Lang["tab.streams"], "</a></li>"); Controls.AddLiteral("<li><a href=\"#tab-3\">", Lang["tab.conversation"], "</a></li>"); Controls.AddLiteral("</ul>"); Controls.AddLiteral("<div id=\"tab-1\">"); ExFormDataAdapter form = new ExFormDataAdapter(Lang["form.title"], "BROADCASTING", "media"); form.AddField("ExFieldLanguageString", "NAME", Lang["form.name"], DBUtils.ValueTrue, "TEXT") .AddField("ExFieldDateTime", "START_DATE", Lang["form.start"], DBUtils.ValueTrue) .AddField("ExFieldDateTime", "END_DATE", Lang["form.end"], DBUtils.ValueTrue) .AddField("ExFieldLanguageHtmlText", "DESCRIPTION", Lang["form.description"], DBUtils.ValueFalse, "TEXT"); form.RecordID = castid; form.Initialise(); form.DataForm.SubmitText = Lang["form.submit"]; Controls.Add(form); Controls.AddLiteral("</div>"); // потоки Controls.AddLiteral("<div id=\"tab-2\">"); Controls.AddLiteral("<table id=\"stream-list\"><tr><td/></tr></table>"); Controls.AddLiteral("<div id=\"stream-list-pager\"></div>"); Controls.AddLiteral("</div>"); // чат Controls.AddLiteral("<div id=\"tab-3\" class=\"ExForm\">"); Controls.AddLiteral("<fieldset>"); Controls.AddLiteral("<legend>", Lang["conversation.form.title"], "</legend>"); Controls.AddLiteral("<div><input type=\"checkbox\" name=\"stream-conversation-enable\" id=\"stream-conversation-enable\" /> <label for=\"stream-conversation-enable\">", Lang["conversation.form.contol"], "</label></div>"); Controls.AddLiteral("<div class=\"optional\">"); Controls.AddLiteral("<div><input type=\"checkbox\" name=\"stream-conversation-allow\" id=\"stream-conversation-allow\" /> <label for=\"stream-conversation-allow\">", Lang["conversation.form.enable"], "</label></div>"); Controls.AddLiteral("<table>"); Controls.AddLiteral("<tr>"); Controls.AddLiteral("<td>", Lang["conversation.form.header"], "</td>"); Controls.AddLiteral("<td class=\"Multilang\">"); Controls.AddLiteral("<label><span class=\"langname\">ru:</span><input type=\"text\" name=\"stream-conversation-h1-ru\" id=\"stream-conversation-h1-ru\" /></label>"); Controls.AddLiteral("<label><span class=\"langname\">en:</span><input type=\"text\" name=\"stream-conversation-h1-en\" id=\"stream-conversation-h1-en\" /></label>"); Controls.AddLiteral("</td>"); Controls.AddLiteral("</tr>"); Controls.AddLiteral("<tr>"); Controls.AddLiteral("<td>", Lang["conversation.form.description"], "</td>"); Controls.AddLiteral("<td class=\"Multilang\">"); Controls.AddLiteral("<label><span class=\"langname\">ru:</span><input type=\"text\" name=\"stream-conversation-h2-ru\" id=\"stream-conversation-h2-ru\" /></label>"); Controls.AddLiteral("<label><span class=\"langname\">en:</span><input type=\"text\" name=\"stream-conversation-h2-en\" id=\"stream-conversation-h2-en\" /></label>"); Controls.AddLiteral("</td>"); Controls.AddLiteral("</tr>"); Controls.AddLiteral("</table>"); Controls.AddLiteral("<div class=\"button-place\"><input type=\"button\" name=\"stream-conversation-save\" id=\"stream-conversation-save\" value=\"", Lang["form.submit"], "\" /></div>"); Controls.AddLiteral("</div>"); Controls.AddLiteral("</fieldset>"); Controls.AddLiteral("</div>"); Controls.AddLiteral("</div>"); scripts.Add("/tools/JavaScript/jquery.js"); scripts.Add("/tools/JavaScript/jquery-ui.js"); scripts.Add(String.Concat("/tools/JavaScript/jquery-jqGrid-i18n/grid.locale-", Lang["lang"], ".js")); scripts.Add("/tools/JavaScript/jquery.jqGrid.js"); scripts.Add("/tools/JavaScript/rpc.js"); scripts.Add("/sites/video.mineralogy.ru/broadcasing-editor.js"); ScriptControlDescriptor sd = new ScriptControlDescriptor("IWCtrls.BroadcasctingEditor", "Sites_video_broadcasting_chanel_tabs"); sd.AddProperty("BroadcastingId", castid); sd.AddProperty("xlang", Lang.SerialiseJson()); sdescriptions.Add(sd); }
public void Mode_Show() { using(DataTable items = new DataAdapter().Select("ID", "START_DATE", "END_DATE", "NAME", "DESCRIPTION") .From("BROADCASTING").JoinExt("TEXT") .OrderBy("START_DATE", true) .GetData()) { TemplateView template = new TemplateView("broadcasting_list"); template.Items.Add("datatable", items); template.Items.Add("moduleroot", this.ModuleRoot); template.Items.Add("isadmin", WebUser.Current.IsInRole(EditorRole)); template.Items.Add("lang", Lang); Controls.Add(template); } }
public void Mode_Cast(WebModuleParams wmp) { Int32 castid = Int32.Parse(wmp["cast"]); Controls.AddLiteral("<div class=\"toolbar\">"); Controls.AddLiteral("<a href=\"", this.ModuleRoot, "\" title=\"", Lang["navbar.root"], "\">", Lang["navbar.root"], "</a>"); if (WebUser.Current.IsInRole(this.EditorRole)) { Controls.AddLiteral(" | <a href=\"", this.ModuleRoot, "/editbroadcast/", castid, "\" title=\"", Lang["navbar_edit_title"], "\">",Lang["navbar_edit"],"</a>"); } Controls.AddLiteral("</div>"); using (DataTable itable = new DataAdapter().Select("NAME", "DESCRIPTION", "ALLOW_CHAT") .From("BROADCASTING").JoinExt("TEXT", true) .Where("ID = @castid") .AddParametr("@castid", castid) .GetData()) { if (itable.Rows.Count > 0) { Controls.AddLiteral("<h1>", itable.Rows[0]["NAME"], "</h1>"); Controls.AddLiteral("<div class=\"cast-description\">", itable.Rows[0]["DESCRIPTION"], "</div>"); if (itable.Rows[0]["ALLOW_CHAT"].Equals(DBUtils.ValueTrue)) { ChatRoom chr = new ChatRoom(); chr.ChatRoomKey = String.Concat("video_cast_", castid); chr.UserIsModerator = WebUser.Current.IsInRole(EditorRole); Controls.Add(chr); } } } Controls.AddLiteral("<div id=\"Sites_video_broadcasting\">"); using (DataTable table = new DataAdapter() .Select("NAME", "Description", "ID", "WIDTH", "HEIGHT") .From("BROADCASTING_STREAMS") .JoinExt("TEXT", true) .Where("BROADCASTING_ID = @castid") .AddParametr("@castid", castid) .GetData()) { foreach (DataRow item in table.Rows) { Controls.AddLiteral("<div class=\"stream\" style=\"width:", item["width"], "px;\" id=\"", item["ID"], "\" title=\"", item["NAME"], "\">"); Controls.AddLiteral("<div class=\"cast-head\"><span>", item["description"], "</span><h2>", item["name"], "</h2></div>"); Controls.AddLiteral("<div class=\"player-holder\" style=\"width:", item["width"], "px;height:", item["height"], "px;\" ><div class=\"player-holder\" id=\"castplayer_", item["ID"], "\"></div></div>"); Controls.AddLiteral("<div class=\"cast-tools\"></div>"); Controls.AddLiteral("</div>"); } } scripts.Add("/tools/JavaScript/jquery.js"); scripts.Add("/tools/JavaScript/jquery-ui.js"); scripts.Add("/tools/JavaScript/UmediaFlashPlayer/umsplayer.js"); scripts.Add("/sites/video.mineralogy.ru/broadcasing-viewer.js"); ScriptControlDescriptor sd = new ScriptControlDescriptor("IWCtrls.BroadcasctingViewer", "Sites_video_broadcasting"); sd.AddProperty("BroadcastingId", castid); sd.AddProperty("xlang", Lang.SerialiseJson()); sdescriptions.Add(sd); }
/// <summary> /// Unregister a listener with the DataAdapter of the corresponding address /// </summary> /// <param name="listener"></param> /// <param name="address"></param> public void unregisterDataListener(DataAdapter<byte>.OnDataChanged listener, short address) { Data[address].DataChanged -= listener; }