public ActionResult PublishEvent(int id) { Event.Event ev; ev = new Event.Event(id); SQLQueries.PublishEvent(id); return(View(ev)); }
public ActionResult AddNewProperty(string ida, string NewProperty) { int id = Convert.ToInt32(ida); int a = SQLQueries.CreateNewProperty(id, NewProperty); return(Redirect("Properties/" + ida)); }
public async Task <T> Get <T> (SQLQueries query, params string[] parameters) where T : class { List <T> results = await DataStore.GetListAsync <T>(connectionString, config.Value, query.ToString(), parameters.Cast <string>().ToList()); if (results.Count == 0) { return(default);
/// <summary> /// Método que consulta as ordens de produção de acordo com o click /// na treview, onde contém os centros de trabalhos e materiais. /// </summary> private void ConsultaOrdensFromArvoreClick(String ItemSelecionado, Boolean IsWorkCenter) { Cursor = Cursors.WaitCursor; if (IsWorkCenter) { udgv.DataSource = SQLQueries.Consulta_OrdensProducao("", "", "", "", 0, ItemSelecionado); } else { udgv.DataSource = SQLQueries.Consulta_OrdensProducao("", "", "", "", 0, "", ItemSelecionado); } //Habilita os botões de editar e excluir. if (udgv.Rows.Count > 0) { DesbloqueiaAcoesDireitoMouse(); udgv.ActiveRow = udgv.ActiveRowScrollRegion.FirstRow; } else { BloqueiaAcoesDireitoMouse(); } Cursor = Cursors.Arrow; }
public async Task <IActionResult> SQLQueries9(string text1) { SQLQueries a = new SQLQueries(); a.text1 = text1; return(RedirectToAction("Index", "Films", new { text1 })); }
public ActionResult EditCalendarSettings(FormCollection form) { var FilterEnabled = Convert.ToString(form["Filterbar"]); var MonthEnabled = Convert.ToString(form["MonthE"]); var PosterEnabled = Convert.ToString(form["PosterboardE"]); var ListEnabled = Convert.ToString(form["ListE"]); var Default = Convert.ToString(form["Default"]); var GlobalHeader = Convert.ToString(form["headercode"]); SQLQueries.UpdateCalendarSettings(FilterEnabled, MonthEnabled, PosterEnabled, ListEnabled, Default, GlobalHeader); List <PropertyType> liPropertyType = SQLQueries.getAllPropertyTypes(true); List <int> liSelectedProps = new List <int>(); foreach (PropertyType pt in liPropertyType) { string sName = pt.Name; var props = Convert.ToString(form[sName]); if (props != null) { string[] sProps = props.Split(','); foreach (string s in sProps) { liSelectedProps.Add(int.Parse(s)); } } } SQLQueries.UpdatePreselectedFilters(liSelectedProps); return(RedirectToAction("CalendarSettings")); }
public async Task <IActionResult> SQLQueries3(int year1) { SQLQueries a = new SQLQueries(); a.year1 = year1; return(RedirectToAction("Index", "Artists", new { year1 })); }
public async Task <IActionResult> SQLQueries1(int year1, int year2) { SQLQueries a = new SQLQueries(); a.year1 = year1; a.year2 = year2; return(RedirectToAction("Index", "Countries", new { year1, year2 })); }
public async Task <IActionResult> SQLQueries2(string char1, string text1) { SQLQueries a = new SQLQueries(); a.char1 = char1; a.text1 = text1; return(RedirectToAction("Index", "Artists", new { char1, text1 })); }
public ActionResult ConfirmRemoveUser(int id) { //s = s.Replace('$', '@'); List <String> users = SQLQueries.GetUserList(); ViewBag.Username = users[id]; ViewBag.UserId = id; return(View()); }
public ActionResult RemoveUser(int id) { //SQLQueries.RemoveUser(s); List <String> users = SQLQueries.GetUserList(); ViewBag.Username = users[id]; SQLQueries.RemoveUser(users[id]); return(View()); }
public ActionResult AddNewPropertyType(string NewPropertyType) { int a; if (NewPropertyType != null && NewPropertyType != "") { a = SQLQueries.CreateNewPropertyType(NewPropertyType); } return(Redirect("Properties")); }
void load_db() { q = new SQLQueries(); for (int i = 0; i < 100; i++) { Dispatcher.Invoke(() => pbStatus.Value++); Thread.Sleep(100); } Dispatcher.Invoke(() => DBGrid.ItemsSource = q.GetData()); }
private void ConsultaDadosAuxilirares(Boolean PesquisarPorCodigo = false) { if (!PesquisarPorCodigo) { udgv.DataSource = SQLQueries.Consulta_DadosAuxiliares("", "", SQLQueries.e_SkaTipoConsultaDados.ConsultarParaSelecionar, true); } else { udgv.DataSource = SQLQueries.Consulta_DadosAuxiliares("", txtDescricao.Text, SQLQueries.e_SkaTipoConsultaDados.ConsultarParaSelecionar, true); } }
private void ConsultaMarkups(Boolean PesquisarPorCodigo = false) { if (!PesquisarPorCodigo) { udgv.DataSource = SQLQueries.Consulta_Markup("", true); } else { udgv.DataSource = SQLQueries.Consulta_Markup(txtDescricao.Text, true); } }
private void Button_Click(object sender, RoutedEventArgs e) { string inputText = inputTextBox.Text; string result = ""; ((Storyboard)Resources["ButtonAnimation"]).Begin(); if (ConverterComboBox.SelectedItem != null) { if (((IConvert)ConverterComboBox.SelectedItem).Name == "Konwerter Zegara") { result = ((IConvert)ConverterComboBox.SelectedItem).Convert( UnitFromComboBox.SelectedItem.ToString(), UnitToComboBox.SelectedItem.ToString(), inputText); string minutes; string hours; minutes = result[3].ToString() + result[4].ToString(); hours = result[0].ToString() + result[1].ToString(); angleH = float.Parse(hours) / 12 * 360; angleM = float.Parse(minutes) / 60 * 360; AngleM.Angle = angleM; AngleH.Angle = angleH; date = DateTime.Now; q = new SQLQueries(); q.save_to_DB(((IConvert)ConverterComboBox.SelectedItem).Name, UnitFromComboBox.SelectedItem.ToString(), UnitToComboBox.SelectedItem.ToString(), inputText, result, date); DBGrid.ItemsSource = q.GetData(); } else { decimal inputValue = decimal.Parse(inputText); result = ((IConvert)ConverterComboBox.SelectedItem).Convert( UnitFromComboBox.SelectedItem.ToString(), UnitToComboBox.SelectedItem.ToString(), inputValue).ToString(); date = DateTime.Now; q = new SQLQueries(); q.save_to_DB(((IConvert)ConverterComboBox.SelectedItem).Name, UnitFromComboBox.SelectedItem.ToString(), UnitToComboBox.SelectedItem.ToString(), inputText, result, date); DBGrid.ItemsSource = q.GetData(); } } outputTextBlock.Text = result; }
/// <summary> /// Consulta as máquinas previamente cadastradas pelo sistema. /// </summary> private void ConsultaMaquinas() { udgv.DataSource = SQLQueries.Consulta_Maquinas(txtNomeMqn.Text, cbxAmbiente.SelectedIndex - 1, cbxVisivel.SelectedIndex - 1); if (udgv.Rows.Count > 0) { //Habilita os controles btnEditar.Enabled = true; btnDeletar.Enabled = true; btnMagazine.Enabled = true; } }
private void ConsultaArquivosAuxiliares(Boolean PesquisarPorCodigo = false) { if (!PesquisarPorCodigo) { udgv.DataSource = SQLQueries.Consulta_ArquivosAuxiliares("", "", SQLQueries.e_SkaTipoConsultaDados.ConsultarParaSelecionar, true); udgv.DisplayLayout.Bands[0].Columns["Arquivo"].PerformAutoResize(); } else { udgv.DataSource = SQLQueries.Consulta_ArquivosAuxiliares("", txtDescricao.Text, SQLQueries.e_SkaTipoConsultaDados.ConsultarParaSelecionar, true); udgv.DisplayLayout.Bands[0].Columns["Arquivo"].PerformAutoResize(); } }
/// <summary> /// Método que consulta os trabalhos. /// </summary> private void ConsultaTrabalhos() { udgv.DataSource = SQLQueries.Consulta_Trabalhos("", txtTrabalho.Text, txtCliente.Text, icbxEstado.SelectedIndex - 1, cbMaquinas.SelectedItem.ToString(), txtProgramador.Text, txtMaterial.Text, true); if (udgv.Rows.Count > 0) { btnExportar.Enabled = true; } else { btnExportar.Enabled = false; } }
public static void Main(string[] args) { SQLQueries.CreateQueries(); if (doTablesExist()) { Debug.WriteLine("Tables Already Exist"); } else { createTables(); } CreateHostBuilder(args).Build().Run(); }
public ActionResult Index() { try { List <PropertyType> liPropertyType = new List <PropertyType>(); liPropertyType = SQLQueries.getAllPropertyTypes(true); List <MultiSelectList> liMultiSelect = new List <MultiSelectList>(); DataTable dtSelectedProps = SQLQueries.GetPreselectedFilters(); List <int> liSelectedProps = new List <int>(); foreach (DataRow row in dtSelectedProps.Rows) { liSelectedProps.Add(int.Parse(row[0].ToString())); } foreach (PropertyType pt in liPropertyType) { List <int> sel = new List <int>(); foreach (Property.Property p in pt.PropertyList) { if (liSelectedProps.Contains(p.PropertyId)) { sel.Add(p.PropertyId); } } List <Property.Property> tempProp = new List <Property.Property>(); { MultiSelectList msli = new MultiSelectList(pt.PropertyList, "propertyId", "name"); liMultiSelect.Add(new MultiSelectList(pt.PropertyList, "propertyId", "name", sel.ToArray())); } } DataTable dtSettings = SQLQueries.GetCalendarSettings(); ViewBag.HeaderHTML = dtSettings.Rows[0]["sGlobalHeader"].ToString(); ViewBag.FilterEnabled = dtSettings.Rows[0]["bFilterEnabled"].ToString(); ViewBag.PosterEnabled = dtSettings.Rows[0]["bPosterEnabled"].ToString(); ViewBag.ListEnabled = dtSettings.Rows[0]["bListEnabled"].ToString(); ViewBag.DefaultView = dtSettings.Rows[0]["sDefault"].ToString(); ViewBag.PropertyTypes = liPropertyType; ViewBag.PropertyLists = liMultiSelect; ViewBag.PropertyEventList = Event.EventManager.PropertiesToJSONRepresentation(); Event.EventManager.updateEventManager(); ViewBag.PublishedEvents = Event.EventManager.ToJSONRepresentation(true); } catch (Exception e) { } return(View()); }
public ActionResult DeleteEvent(int id) { Event.Event ev; ev = new Event.Event(id); SQLQueries.DeactivateEvent(id); if (ev.IsPublished) { EventManager.PublishedEvents.Remove(id); } else { EventManager.SubmittedEvents.Remove(id); } return(View(ev)); }
public MainWindow() { InitializeComponent(); Zegar.Visibility = Visibility.Hidden; ConverterComboBox.ItemsSource = new List <IConvert> { new ConverterLogic.LengthConverter(), new TempratureConverter(), new MassConverter(), new ClockConverter(), new EnergyConverter() }; q = new SQLQueries(); DBGrid.ItemsSource = q.GetData(); }
/// <summary> /// Список для выбора транспортных узлов /// </summary> /// <param name="search">Строка поиска</param> /// <param name="type">Код Вида Транспорта</param> /// <param name="maxItemsInQuery">Количество возвращаемых записей в запросе (top n)</param> /// <returns>Список транспортных узлов</returns> public List <TransportNode> GetTransportNodes(string search, string type, int maxItemsInQuery) { var dt = DBManager.GetData(SQLQueries.SELECT_ТранспортныеУзлыВыбор(search, type, maxItemsInQuery), Config.DS_document); var result = dt.AsEnumerable().Select(dr => new TransportNode { Id = dr.Field <int>("КодТранспортногоУзла").ToString(), Name = dr.Field <string>("Название"), TypeTransport = dr.Field <string>("Транспорт"), CodeRailway = dr.Field <int?>("КодЖелезнойДороги"), TransportTypeCode = dr.Field <int>("КодВидаТранспорта") }).ToList(); return(result); }
private void PesquisaFerramentas_Aditivas() { Objects.LimpaOrdenacaoColunasGrid(udgv_Additive); udgv_Additive.DataSource = SQLQueries.ConsultaFerramentas_Aditive(txtAdditive_Desc.Text, icbxAdditive_Tipo.SelectedIndex - 1, txtAdditive_Diam.Text, cbxAdditive_Unidade.SelectedIndex - 1); if (udgv_Additive.Rows.Count > 0) { lblAdditive_Qtde.Text = String.Format("Quantidade de ferramentas encontradas: {0}", udgv_Additive.Rows.Count.ToString()); lblAdditive_Qtde.Visible = true; } else { lblAdditive_Qtde.Visible = false; } }
private void PesquisaFerramentas_Torneamento() { Objects.LimpaOrdenacaoColunasGrid(udgv_Turn); udgv_Turn.DataSource = SQLQueries.ConsultaFerramentas_Turn(txtTurn_Desc.Text, icbxTurn_Tipo.SelectedIndex - 1, cbxTurn_Symbol.SelectedIndex - 1, cbxTurn_Unidade.SelectedIndex - 1, cbxTurn_Tecnologia.SelectedIndex, icbxTurn_Lado.SelectedIndex - 1); if (udgv_Turn.Rows.Count > 0) { lblTurn_Qtde.Text = String.Format("Quantidade de ferramentas encontradas: {0}", udgv_Turn.Rows.Count.ToString()); lblTurn_Qtde.Visible = true; } else { lblTurn_Qtde.Visible = false; } }
public MainWindow() { InitializeComponent(); Zegar.Visibility = Visibility.Hidden; ConverterComboBox.ItemsSource = new List <IConvert> { new ConverterLogic.LengthConverter(), new ConverterLogic.TempratureConverter(), new ConverterLogic.MassConverter(), new ConverterLogic.ClockConverter(), new ConverterLogic.EnergyConverter() }; q = new SQLQueries(); RateControl.RateValue = q.load_rating(); }
public ActionResult EditEvent(Event.Event ev) { SQLQueries.UpdateEvent(ev); var file = Request.Files["file"]; if (file != null) { //MySqlComm byte[] fileBytes = new byte[file.ContentLength]; file.InputStream.Read(fileBytes, 0, file.ContentLength); ev.Image = fileBytes; SQLData.SQLQueries.UpdateEventImage(ev); } return(RedirectToAction("EventDetails", new { id = ev.EventId })); }
/// <summary> /// Método responsável por consultar /// </summary> /// <param name="PesquisarPorCodigo">True para utilizar o valor do campo txtDescricao</param> private void ConsultaRotasProducao(Boolean PesquisarPorCodigo = false) { DataTable dt; if (!PesquisarPorCodigo) { dt = SQLQueries.Consulta_RotasProducao(true); } else { dt = SQLQueries.Consulta_RotasProducao(true, txtDescricao.Text); } if (dt.Rows.Count > 0) { //Aqui contém o nome das rotas de produção (pais) DataTable lstNomesRotas = dt.AsDataView().ToTable(true, "NomeRota"); for (int y = 0; y < lstNomesRotas.Rows.Count; y++) { //Recebe os nós do UltraTreeView para a partir dele, ir adicionados os próximos 'nodos' (filhos). UltraTreeNode n = utv.Nodes.Add(); n.Cells[(int)e_SkaColunas.Selecionar].Value = "Selecionar"; n.Cells[(int)e_SkaColunas.NomeRota].Value = lstNomesRotas.Rows[y]["NomeRota"].ToString(); DataTable lstFilhos = dt.Select(String.Format("NomeRota = '{0}'", lstNomesRotas.Rows[y]["NomeRota"].ToString())).CopyToDataTable(); for (int z = 0; z < lstFilhos.Rows.Count; z++) { //Recebe os nós já adicionados no pai. UltraTreeNode noFilho = n.Nodes.Add(); noFilho.Cells[(int)e_SkaColunas.Operacao].Value = lstFilhos.Rows[z]["Operacao"].ToString(); noFilho.Cells[(int)e_SkaColunas.OrdemExecucao].Value = lstFilhos.Rows[z]["OrdemExecucao"].ToString(); noFilho.Cells[(int)e_SkaColunas.TempoEstimado].Value = lstFilhos.Rows[z]["TempoEstimado"].ToString(); noFilho.Cells[(int)e_SkaColunas.Custo].Value = lstFilhos.Rows[z]["Custo"].ToString(); n.Nodes.Add(noFilho); } utv.Nodes.Add(n); } utv.ExpandAll(); } }
public PartialViewResult EventSubmit() { List <PropertyType> liPropertyType = new List <PropertyType>(); liPropertyType = SQLQueries.getAllPropertyTypes(true); List <MultiSelectList> liMultiSelect = new List <MultiSelectList>(); foreach (PropertyType pt in liPropertyType) { List <Property.Property> tempProp = new List <Property.Property>(); { liMultiSelect.Add(new MultiSelectList(pt.PropertyList, "propertyId", "name")); } } ViewBag.PropertyTypes = liPropertyType; ViewBag.PropertyLists = liMultiSelect; return(PartialView("~/Views/Calendar/SubmitEvent.cshtml")); }
public SQL(string ConnectionString) { // CONSTRUCTOR LOGIC Data = new SqlConnection(ConnectionString); SQLQuery = new SQLQueries(); }