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();
}
