private async void FrmAddToCart_Load(object sender, EventArgs e) { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_Products where Prod_Number = '" + lblprodID.Text + "'"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); //metroComboBox1.Items.Clear(); if (Sqlreader.Read()) { lblprodname.Text = (Sqlreader.GetValue(2).ToString()); stock = Convert.ToDouble((Sqlreader.GetValue(3).ToString())); label4.Text = stock.ToString(CultureInfo.InvariantCulture); _sellprice = Convert.ToSingle(Sqlreader.GetValue(6).ToString()); label9.Text = _sellprice.ToString(CultureInfo.InvariantCulture); } numericUpDown1.Maximum = Convert.ToInt16(label4.Text); Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; }
public void CreatePgActaTrepTable(string tableName = "acta_trep", string schema = "raw_reports") { Cnn.Execute( $@"CREATE TABLE {schema}.{tableName} ( id serial NOT NULL, pais text, numero_departamento integer, departamento text, provincia text, numero_municipio integer, municipio text, circunscripcion text, localidad text, recinto text, numero_mesa integer, codigo_mesa bigint, eleccion text, inscritos integer, cc integer, fpv integer, mts integer, ucs integer, mas_ipsp integer, _21f integer, pdc integer, mnr integer, pan_bol integer, votos_validos integer, blancos integer, nulos integer, CONSTRAINT {tableName}_key PRIMARY KEY (id) )" ); }
private void ExcluirBanco() { try { if (lstBancos.Items.Count == 1) { Msg.Warning("É necessário que exista pelo menos um banco de dados!"); return; } if (lstBancos.SelectedIndex != -1) { string DbName = lstBancos.Items[lstBancos.SelectedIndex].ToString(); if (DbName.ToUpper() == Cnn.Info.Database.ToUpper()) { Msg.Warning("Não é permitido excluir o banco de dados em que o sistema está conectado!"); return; } if (Msg.Question( string.Format( "Tem certeza que deseja apagar o banco de dados:\n" + " {0}.\n(Obs.:Esta operação é irreversível)", DbName))) { Cnn.Exec("drop database " + DbName); ListaBancos(); } } } catch (Exception ex) { FormError.ShowError(ex); } }
private async Task XGenInvoice() { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_Transaction"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; DataTable sqlDt = new DataTable(); sqlDt.Reset(); Sqladapter.Fill(sqlDt); Sqlreader = Sqlcmd.ExecuteReader(); if (Sqlreader.Read()) { var count = Convert.ToDouble(sqlDt.Rows.Count.ToString()); var xRi = Convert.ToDouble(1 + count); inv_num = $"{Now.Year}{xRi}"; } else { inv_num = $"{Now.Year}{1}"; } Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); }
private async Task XLoadXfilterLogsLogs() { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_logs where u_name='" + username + "' and log_date='" + bunifuDatepicker1.Value + "'"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); listView1.Items.Clear(); while (Sqlreader.Read()) { var lvi = listView1.Items.Add(Sqlreader.GetValue(0).ToString()); lvi.SubItems.Add(Sqlreader.GetValue(2).ToString()); lvi.SubItems.Add(Sqlreader.GetValue(3).ToString()); var a = (DateTime)(Sqlreader.GetValue(4)); lvi.SubItems.Add(a.ToShortDateString()); lvi.SubItems.Add(Sqlreader.GetValue(5).ToString()); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; }
private async Task XupdateInfo() { UseWaitCursor = true; Sqlcmd.Parameters.Clear(); await Conopen(); Image temp = new Bitmap(bunifuPictureBox1.Image); var strm = new MemoryStream(); temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg); var imagebytearray = strm.ToArray(); Strsql = "Update tbl_Users set u_Fname=@u_Fname, u_address=@u_address, u_c_num=@u_c_num, u_img=@u_img Where u_name=@u_name"; Sqlcmd.Parameters.AddWithValue("@u_Fname", txtfname.Text); Sqlcmd.Parameters.AddWithValue("@u_address", textBox1.Text); Sqlcmd.Parameters.AddWithValue("@u_c_num", textBox2.Text); Sqlcmd.Parameters.AddWithValue("@u_img", imagebytearray); Sqlcmd.Parameters.AddWithValue("@u_name", username); Sqlcmd.Connection = Cnn; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); _xinfoupdated = true; await XSaveTransactionLog(); popup.Delay = 5000; popup.TitleText = @"Info updated"; popup.ContentText = @"Your personal information has been successfully updated! You might need to restart the application to see the modified changes"; popup.Popup(); UseWaitCursor = false; }
private async Task XDisplayEdit() { byte[] img; //bunifuTextBox1.Text = Form1.XID; Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_Students where stud_id = '" + SelectedStudId + "'"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); //metroComboBox1.Items.Clear(); if (Sqlreader.Read()) { studid.Text = Sqlreader.GetValue(1).ToString(); fname.Text = Sqlreader.GetValue(2).ToString(); lname.Text = Sqlreader.GetValue(3).ToString(); minitial.Text = Sqlreader.GetValue(4).ToString(); course.Text = Sqlreader.GetValue(5).ToString(); yrlevel.Text = Sqlreader.GetValue(6).ToString(); vtCategory.Text = Sqlreader.GetValue(7).ToString(); img = (byte[])Sqlreader.GetValue(8); if (img.Length != 0) { //studimg.ImageSource = (ImageBrush)Image.FromStream(new MemoryStream(img)); studimg.ImageSource = LoadImage(img); } } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; }
private void Form4_2_Load(object sender, EventArgs e) { cnn = new Cnn(); #region LeNet-5 结构 /* * cnn.AddCnnConvolutionLayer(6, 32, 32, 5, 5, 1, 1, CnnNode.ActivationFunctionTypes.Tanh, * 2, 2, CnnPooling.PoolingTypes.MaxPooling, false); * cnn.AddCnnConvolutionLayer(16, 5, 5, 1, 1, CnnNode.ActivationFunctionTypes.Tanh, * 2, 2, CnnPooling.PoolingTypes.MeanPooling, false, false); * cnn.AddCnnConvolutionLayer(120, 5, 5, 1, 1, CnnNode.ActivationFunctionTypes.Tanh, * 0, 0, CnnPooling.PoolingTypes.None, false, false); * cnn.AddCnnFullLayer(84, CnnNode.ActivationFunctionTypes.Tanh, false); * cnn.AddCnnFullLayer(10, CnnNode.ActivationFunctionTypes.Tanh, false); * //*/ #endregion cnn.AddCnnConvolutionLayer(6, 254 * 2, 252, 5, 5, 1, 1, CnnNode.ActivationFunctionTypes.Tanh, 2, 2, CnnPooling.PoolingTypes.MaxPooling, false); cnn.AddCnnConvolutionLayer(16, 5, 5, 1, 1, CnnNode.ActivationFunctionTypes.Tanh, 2, 2, CnnPooling.PoolingTypes.MeanPooling, false, false); cnn.AddCnnConvolutionLayer(20, 5, 5, 1, 1, CnnNode.ActivationFunctionTypes.Tanh, 2, 2, CnnPooling.PoolingTypes.MeanPooling, false, false); cnn.AddCnnFullLayer(84, CnnNode.ActivationFunctionTypes.Tanh, false); cnn.AddCnnFullLayer(1, CnnNode.ActivationFunctionTypes.Tanh, false); }
private void ClearPageTrace() { if (IsDbConnected) { Cnn.ExecuteSql("delete from page_trace where page_id = " + PageId); } }
private int OnSaveChanges2() { ChangeTracker.DetectChanges(); var manager = CurrentObjectContext.ObjectStateManager; var modified = manager.GetObjectStateEntries(EntityState.Modified); var added = manager.GetObjectStateEntries(EntityState.Added); var deleted = manager.GetObjectStateEntries(EntityState.Deleted); if (Database.Connection.State == System.Data.ConnectionState.Closed) { Database.Connection.Open(); } using (var transaction = Database.Connection.BeginTransaction()) { Cnn.ExternalTransaction = transaction; UpdateObjectStateEntries(modified, (content, item) => item.GetModifiedProperties().ToArray(), true); UpdateObjectStateEntries(added, (content, item) => GetProperties(content), false); foreach (var deletedItem in deleted) { var article = (IQPArticle)deletedItem.Entity; Cnn.DeleteContentItem(article.Id); } transaction.Commit(); Cnn.ExternalTransaction = null; } Database.Connection.Close(); return(0); }
/// <summary> /// Close connection /// </summary> protected void Close() { if (Cnn.State != ConnectionState.Closed) { Cnn.Close(); } }
public DapperPlusActionSet <PgActaTrep> InsertActasTrep(IEnumerable <PgActaTrep> actas, string tableName, string schema = "raw_reports") { DapperPlusManager.Entity <PgActaTrep>().Table($"{schema}.{tableName}"); var result = Cnn.BulkInsert(actas); return(result); }
private async Task XfillComboboxes() { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_course"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = await Sqlcmd.ExecuteReaderAsync(); course.Items.Clear(); while (Sqlreader.Read()) { course.Items.Add(Sqlreader.GetValue(1)); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; //retrieve year level Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_yearLevel"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = await Sqlcmd.ExecuteReaderAsync(); yrlevel.Items.Clear(); while (Sqlreader.Read()) { yrlevel.Items.Add(Sqlreader.GetValue(0)); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; //retrieve voter's category Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_Vtrs_Category"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = await Sqlcmd.ExecuteReaderAsync(); vtCategory.Items.Clear(); while (Sqlreader.Read()) { vtCategory.Items.Add(Sqlreader.GetValue(1)); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; }
private async Task xFindTask() { switch (XTask) { case "Login": UseWaitCursor = true; await Conopen(); Sqlcmd.Parameters.Clear(); Strsql = "Select * from tbl_Users where u_name='" + ScannedNumber + "' and approval_stat = 1"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); if (Sqlreader.Read()) { userpassword = Sqlreader.GetValue(5).ToString(); username = Sqlreader.GetValue(4).ToString(); await XUpdatelogindate(); await XSaveLog(); popup.TitleText = @"Access granted"; popup.Image = Properties.Resources.check; popup.ContentText = @"Welcome " + username + "!"; popup.Popup(); Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; loggedin = true; UseWaitCursor = false; timer1.Stop(); if (captureDevice.IsRunning) { captureDevice.Stop(); } Close(); Form1 a = new Form1(); a.Show(); } else { UseWaitCursor = false; popup.TitleText = @"Access denied"; popup.Image = Properties.Resources.error; popup.ContentText = @"Account not found or the account you are trying to access is pending for approval by the admin. Please try again later or contact your admin!"; popup.Popup(); captureDevice.Start(); timer1.Start(); Focus(); } UseWaitCursor = false; Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; break; } }
private void CriaBanco() { string NovoNome = GetNewDbName(); Cnn.Exec("create database " + NovoNome); UsarBanco(NovoNome); Msg.Information(string.Format("Banco de dados {0} criado com sucesso!", NovoNome)); }
public void CloseCnn() { if (Cnn != null && CnnIsOpen) { Cnn.Close(); CnnIsOpen = false; } }
private async void bunifuFlatButton2_Click(object sender, EventArgs e) { if (TranNum != null) { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_Transaction_Detail where Inv_Num='" + TranNum + "' AND Prod_Number = '" + label2.Text + "'"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); //metroComboBox1.Items.Clear(); if (Sqlreader.Read()) { Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; var ms = new T_Message(); var ok = new Frm_OK(); ms.Show(this); ok.OkDescription = "Warn"; ok.titletxt.Text = @"Warning"; ok.msgtxt.Text = @"This product is already in the cart. Are you trying to modify it's quantity? If so, please select set quantity option in the cart panel."; ok.ShowDialog(); ms.Close(); Focus(); } else { Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; var b = new T_Transaction(); var a = new FrmAddToCart(); a.lblprodID.Text = label2.Text; b.Show(this); a.ShowDialog(); b.Dispose(); a.Dispose(); Focus(); } } else { var b = new T_Transaction(); var a = new FrmAddToCart(); a.lblprodID.Text = label2.Text; b.Show(this); a.ShowDialog(); //c.lblinvoice.Text = a.inv_num; b.Dispose(); a.Dispose(); Focus(); } }
private async Task Xaddmode() { Sqlcmd.Parameters.Clear(); Image temp = new Bitmap(bunifuPictureBox1.Image); var strm = new MemoryStream(); temp.Save(strm, ImageFormat.Jpeg); _imagebytearray = strm.ToArray(); await Conopen(); Strsql = "Insert into tbl_Products(Prod_Barcode, Prod_Name, Prod_Stock, Unit_Desc, Prod_Price,Prod_Img,production_Strt_date,cost_sale,cat_desc,prod_description,prod_FS,prod_exp_date) " + "Values(@Prod_Barcode, @Prod_Name, @Prod_Stock, @Unit_Desc, @Prod_Price, @Prod_Img,@production_Strt_date,@cost_sale,@cat_desc,@prod_description,@prod_FS,@prod_exp_date)"; Sqlcmd.Parameters.AddWithValue("@Prod_Barcode", bunifuTextBox2.Text); Sqlcmd.Parameters.AddWithValue("@Prod_Name", bunifuTextBox1.Text); Sqlcmd.Parameters.AddWithValue("@Prod_Stock", bunifuTextBox3.Text); Sqlcmd.Parameters.AddWithValue("@Unit_Desc", cmbounit.Text); Sqlcmd.Parameters.AddWithValue("@Prod_Price", bunifuTextBox4.Value); Sqlcmd.Parameters.AddWithValue("@Prod_Img", _imagebytearray); Sqlcmd.Parameters.AddWithValue("@production_Strt_date", psdstartdate.Value); Sqlcmd.Parameters.AddWithValue("@cost_sale", cost.Value); Sqlcmd.Parameters.AddWithValue("@cat_desc", category.Text); Sqlcmd.Parameters.AddWithValue("@prod_description", txtdesciption.Text); Sqlcmd.Parameters.AddWithValue("@prod_FS", prodFS); Sqlcmd.Parameters.AddWithValue("@prod_exp_date", dateTimePicker1.Value); Sqlcmd.Connection = Cnn; //sqlcmd.CommandType = CommandType.Text; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); var a = new T_Message(); var frmok = new Frm_OK(); a.Show(this); frmok.titletxt.Text = @"Success"; frmok.msgtxt.Text = @"Record has been successfully Added! Please refresh the products data to see modified changes."; frmok.OkDescription = "Success"; frmok.ShowDialog(this); a.Hide(); Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); Close(); }
public void OpenCnn() { if (Cnn == null) { GetDbConnection(); Cnn.Open(); CnnIsOpen = true; } }
private async Task XSignUp() { try { Sqlcmd.Parameters.Clear(); Image temp = new Bitmap(bunifuPictureBox2.Image); MemoryStream strm = new MemoryStream(); temp.Save(strm, ImageFormat.Jpeg); byte[] imagebytearray = strm.ToArray(); await Conopen(); Strsql = "Insert into tbl_Users(u_Fname, u_address, u_c_num, u_name, u_pass, Desig_Desc, u_img) " + "Values(@u_Fname, @u_address, @u_c_num, @u_name, @u_pass,@Desig_Desc, @u_img)"; Sqlcmd.Parameters.AddWithValue("@u_Fname", bunifuTextBox5.Text); Sqlcmd.Parameters.AddWithValue("@u_address", bunifuTextBox6.Text); Sqlcmd.Parameters.AddWithValue("@u_c_num", bunifuTextBox7.Text); Sqlcmd.Parameters.AddWithValue("@u_name", bunifuTextBox4.Text); Sqlcmd.Parameters.AddWithValue("@u_pass", bunifuTextBox3.Text); Sqlcmd.Parameters.AddWithValue("@Desig_Desc", cmbodesig.Text); Sqlcmd.Parameters.AddWithValue("@u_img", imagebytearray); Sqlcmd.Connection = Cnn; //sqlcmd.CommandType = CommandType.Text; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); popup.TitleText = @"Success"; popup.Image = Properties.Resources.check; popup.ContentText = @"You've successfully signed up, Your system application is pending for approval by the administrator."; popup.Popup(); Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); //Close(); bunifuTextBox5.Text = ""; bunifuTextBox6.Text = ""; bunifuTextBox7.Text = ""; bunifuTextBox4.Text = ""; bunifuTextBox3.Text = ""; cmbodesig.Items.Clear(); bunifuPictureBox2.Image = null; label6.Text = @"Not registered yet?"; bunifuFlatButton4.Text = @"Sign Up"; panel3.Visible = false; bunifuTransition1.ShowSync(panel1); Focus(); } catch { popup.TitleText = @"Warning"; popup.Image = Properties.Resources.warning; popup.ContentText = @"The user name is already taken, please enter another one and try signing up again!"; popup.Popup(); Focus(); bunifuTextBox5.Focus(); } }
private void UsarBanco(string DbName) { Cnn.Info.Database = DbName; FormConnection f = new FormConnection(ConfigFolder); f.Reconfigure(Cnn.dbType, Cnn.Info); f.Dispose(); f = null; Cnn.Connect(Cnn.dbType, Cnn.Info); }
private int OnSaveChanges2() { ChangeTracker.DetectChanges(); var modified = ChangeTracker.Entries() .Where(x => x.State == EntityState.Modified && x.Entity != null) .ToList(); var added = ChangeTracker.Entries() .Where(x => x.State == EntityState.Added && x.Entity != null) .ToList(); var deleted = ChangeTracker.Entries() .Where(x => x.State == EntityState.Deleted && x.Entity != null) .ToList(); var connection = Database.GetDbConnection(); if (connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } if (Cnn.ExternalTransaction != null) { UpdateObjectStateEntries(modified, (content, item) => item.Properties.Where(x => x.IsModified).Select(x => x.Metadata.Name).ToArray(), true); UpdateObjectStateEntries(added, (content, item) => GetProperties(content), false); foreach (var deletedItem in deleted) { var article = (IQPArticle)deletedItem.Entity; Cnn.DeleteContentItem(article.Id); } } else { using (var transaction = Database.BeginTransaction()) { Cnn.ExternalTransaction = transaction.GetDbTransaction(); UpdateObjectStateEntries(modified, (content, item) => item.Properties.Where(x => x.IsModified).Select(x => x.Metadata.Name).ToArray(), true); UpdateObjectStateEntries(added, (content, item) => GetProperties(content), false); foreach (var deletedItem in deleted) { var article = (IQPArticle)deletedItem.Entity; Cnn.DeleteContentItem(article.Id); } transaction.Commit(); Cnn.ExternalTransaction = null; } } //connection.Close(); ChangeTracker.AcceptAllChanges(); return(0); }
private async Task XAddCustomer() { Sqlcmd.Parameters.Clear(); Image temp = new Bitmap(bunifuPictureBox1.Image); var strm = new MemoryStream(); temp.Save(strm, ImageFormat.Jpeg); _imagebytearray = strm.ToArray(); await Conopen(); Strsql = "Insert into tbl_customer(cus_ID, cus_fname, cus_lname, cus_prefix, cus_address, cus_home_phone, cus_mobile,cus_email,cus_dob,cus_notes,cus_img) " + "Values(@cus_ID, @cus_fname, @cus_lname, @cus_prefix, @cus_address, @cus_home_phone, @cus_mobile, @cus_email,@cus_dob,@cus_notes,@cus_img)"; Sqlcmd.Parameters.AddWithValue("@cus_ID", _idNum); Sqlcmd.Parameters.AddWithValue("@cus_fname", txtfname.Text); Sqlcmd.Parameters.AddWithValue("@cus_lname", txtlname.Text); Sqlcmd.Parameters.AddWithValue("@cus_prefix", cmbprefix.Text); Sqlcmd.Parameters.AddWithValue("@cus_address", txtaddress.Text); Sqlcmd.Parameters.AddWithValue("@cus_home_phone", txthomephone.Text); Sqlcmd.Parameters.AddWithValue("@cus_mobile", txtmobilephone.Text); Sqlcmd.Parameters.AddWithValue("@cus_email", txtemail.Text); Sqlcmd.Parameters.AddWithValue("@cus_dob", dateTimePicker1.Value); Sqlcmd.Parameters.AddWithValue("@cus_notes", txtnotes.Text); Sqlcmd.Parameters.AddWithValue("@cus_img", _imagebytearray); Sqlcmd.Connection = Cnn; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); var a = new T_Message(); var frmok = new Frm_OK(); a.Show(this); frmok.titletxt.Text = @"Success"; frmok.msgtxt.Text = @"Record has been successfully Added! Please refresh the customer data to see modified changes."; frmok.OkDescription = "Success"; frmok.ShowDialog(this); a.Hide(); Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); XCustomerLoaded = false; Close(); }
private void btnLoad_Click(object sender, EventArgs e) { OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = "*.cnn|*.cnn"; if (ofd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { cnn = CnnHelper.LoadCnn(ofd.FileName); //cnn = CnnHelper.LoadCnnGroup(ofd.FileName); } }
private async void bunifuFlatButton1_Click(object sender, EventArgs e) { if (txtusername.Text != "" && txtpassword.Text != "") { await Conopen(); Sqlcmd.Parameters.Clear(); Strsql = "Select * from tbl_Users where u_name='" + txtusername.Text + "' and u_pass ='******' and approval_stat = 1"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); if (Sqlreader.Read()) { userpassword = txtpassword.Text; username = txtusername.Text; await XUpdatelogindate(); await XSaveLog(); popup.TitleText = @"Access granted"; popup.Image = Properties.Resources.check; popup.ContentText = @"Welcome " + txtusername.Text + "!"; popup.Popup(); Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; Hide(); Form1 a = new Form1(); a.Show(); } else { popup.TitleText = @"Access denied"; popup.Image = Properties.Resources.error; popup.ContentText = @"Account not found or the account you are trying to access is pending for approval by the admin. Please try again later or contact your admin!"; popup.Popup(); Focus(); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; } else { popup.TitleText = @"Access denied"; popup.Image = Properties.Resources.error; popup.ContentText = @"Please enter your credentials to gain access to the system!"; popup.Popup(); Focus(); } }
public int CopyCsvTrepToPg(string csvPath, string tableName, string schema = "raw_reports") { int ret = Cnn.Execute($@"COPY {schema}.{tableName} (pais,numero_departamento,departamento,provincia, numero_municipio,municipio,circunscripcion,localidad,recinto, numero_mesa,codigo_mesa,eleccion,inscritos, cc,fpv,mts,ucs,mas_ipsp,_21f,pdc,mnr,pan_bol, votos_validos,blancos,nulos) FROM '{csvPath}' DELIMITER ',' CSV HEADER;"); return(ret); }
public void Close() { Cnn.Close(); try { Cnn.Close(); } catch (Exception e) { MessageBox.Show(e.Message); } }
/// <summary> /// Open connection /// </summary> /// <returns>True is open successfull else false</returns> protected bool Open() { try { if (Cnn.State == ConnectionState.Closed) { Cnn.Open(); } return(true); } catch { return(false); } }
private void button2_Click(object sender, EventArgs e) { //if (args.length < 5) //{ // System.out // .println("Usage: \n\t-train trainfile\n\t-test predictfile\n\t-sep separator, default:','\n\t-eta eta, default:0.5\n\t-iter iternum, default:5000\n\t-out outputfile"); // return; //} String trainfile = @".\data\train.txt"; String testfile = @".\data\test.txt"; String outputfile = "outputfile.txt"; float eta = 0.05f; int nIter = 1000; List <CnnDemo.BP.DataNode> trainList = GetDataList(trainfile); List <CnnDemo.BP.DataNode> testList = GetDataList(testfile); StreamWriter sw = new StreamWriter(outputfile); int typeCount = 3; Cnn tmpCnn = new Cnn(); tmpCnn.AddCnnFullLayer(4, 14, CnnNode.ActivationFunctionTypes.Tanh, false); tmpCnn.AddCnnFullLayer(20, CnnNode.ActivationFunctionTypes.Tanh, false); tmpCnn.AddCnnFullLayer(10, CnnNode.ActivationFunctionTypes.Tanh, false); tmpCnn.AddCnnFullLayer(10, CnnNode.ActivationFunctionTypes.Tanh, false); tmpCnn.AddCnnFullLayer(3, CnnNode.ActivationFunctionTypes.Tanh, false); for (int i = 0; i < nIter; i++) { foreach (var t in trainList) { tmpCnn.TrainFullLayer(t.getAttribList2().ToArray(), t.getTypes(), eta); } } for (int i = 0; i < testList.Count(); i++) { CnnDemo.BP.DataNode test = testList[i]; double[] type = tmpCnn.PredictFullLayer(test.getAttribList2().ToArray()); List <float> attribs = test.getAttribList(); for (int n = 0; n < attribs.Count(); n++) { sw.Write(attribs[n] + ","); } double maxtype = type[0], max = 0; for (int n = 0; n < 3; n++) { if (maxtype < type[n]) { max = n; maxtype = type[n]; } } sw.WriteLine(GetTypeName(max)); } sw.Close(); }
private void ListaBancos() { DataSource ds = new lib.Database.Drivers.DataSource(Cnn.GetDataTable("show databases")); lstBancos.Items.Clear(); for (int i = (ds.Count - 1); i >= 0; i--) { string DatabaseName = ds.GetField(i, "Database").ToString(); if (DatabaseName.ToUpper().IndexOf(Alias.ToUpper()) != -1) { lstBancos.Items.Add(DatabaseName); } } }