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