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 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 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 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 = ""; }
private static async Task Xupdateproduct() { int curstock = 0; int totqty; await Conopen(); Strsql = "Select * from tbl_Products where prod_number='" + prdid + "'"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); if (Sqlreader.Read()) { curstock = Convert.ToInt32(Sqlreader.GetValue(3).ToString()); } Strsql = ""; totqty = curstock - prdqty; Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Update tbl_Products set Prod_Stock=@Prod_Stock Where Prod_Number=@Prod_Number"; Sqlcmd.Parameters.AddWithValue("@Prod_Stock", Convert.ToInt32(totqty)); Sqlcmd.Parameters.AddWithValue("@Prod_Number", prdid); Sqlcmd.Connection = Cnn; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); Sqlcmd.Dispose(); Strsql = ""; //prdqty = 0; //prdid = ""; }
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 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 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(); } }
private async Task XTransaction() { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_Transaction where Inv_Num like '" + inv_num + "'"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; DataTable sqlDt = new DataTable(); sqlDt.Reset(); Sqladapter.Fill(sqlDt); Sqlreader = Sqlcmd.ExecuteReader(); //************************************************** if (!Sqlreader.Read()) { await XSaveTransaction(); await XSaveTransactionDetails(); } else { await XSaveTransactionDetails(); } var a = new T_Message(); var frmok = new Frm_OK(); a.Show(this); frmok.titletxt.Text = @"Success"; frmok.msgtxt.Text = @"Item successfully added to cart!"; frmok.OkDescription = "Success"; frmok.ShowDialog(this); a.Hide(); //popup.TitleText = @"Success"; //popup.Image = Properties.Resources.check; //popup.ContentText = @"The product "+ lblprodname.Text + " has been successfully added to cart!"; //popup.Popup(); Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); TranNum = inv_num; FillCart = true; Hide(); }
private async Task XFilldesignation() { await Conopen(); Sqlcmd.Parameters.Clear(); Strsql = "Select * from tbl_Designation"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); cmbodesig.Items.Clear(); while (Sqlreader.Read()) { cmbodesig.Items.Add(Sqlreader.GetValue(1)); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; }
private async Task XLoadNotification() { await Conopen(); Sqlcmd.Parameters.Clear(); Strsql = "Select * from tbl_notification ORDER BY not_num DESC"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); flowLayoutPanel1.Controls.Clear(); var dt = new DataTable(); dt.Load(Sqlreader); for (var i = 0; i < dt.Rows.Count; i++) { act_time = dt.Rows[i]["not_date"].ToString(); XLog1(); var a = new ListNotification { label1 = { Text = not_date }, lblnottitle = { Text = dt.Rows[i]["not_title"].ToString() }, lblnotdesc = { Text = dt.Rows[i]["not_desc"].ToString() } }; switch (a.lblnottitle.Text) { case @"Voided Transaction": a.bunifuImageButton2.Image = Properties.Resources.error; break; case @"Report printed": a.bunifuImageButton2.Image = Properties.Resources.print_50px; break; } flowLayoutPanel1.Controls.Add(a); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; Focus(); lblnotcount.Text = flowLayoutPanel1.Controls.Count + @" total"; }
private async void FrmSetLineDiscount_Load(object sender, EventArgs e) { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_Transaction_Detail where Inv_Num='" + inv_num + "' AND Prod_Number = '" + proid + "'"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); //metroComboBox1.Items.Clear(); if (Sqlreader.Read()) { var a = (decimal)Sqlreader.GetValue(4); qty = (int)Sqlreader.GetValue(2); lblprice.Text = a.ToString("F"); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; }
private async Task XFillUnit() { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_prod_category"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); category.Items.Clear(); while (Sqlreader.Read()) { category.Items.Add(Sqlreader.GetValue(1)); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; //***************************************************** Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_Unit"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); cmbounit.Items.Clear(); while (Sqlreader.Read()) { cmbounit.Items.Add(Sqlreader.GetValue(1)); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; }
private async Task XLoadUser() { UseWaitCursor = true; textBox4.Text = username; await Conopen(); Sqlcmd.Parameters.Clear(); Strsql = "Select * from tbl_Users where u_name='" + username + "'"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); if (Sqlreader.Read()) { txtfname.Text = Sqlreader.GetValue(1).ToString(); //userfullname = lblfullname.Text; textBox1.Text = Sqlreader.GetValue(2).ToString(); textBox2.Text = Sqlreader.GetValue(3).ToString(); label4.Text = Sqlreader.GetValue(6).ToString(); label8.Text = Sqlreader.GetValue(8).ToString(); label10.Text = Sqlreader.GetValue(10).ToString(); textBox3.Text = Sqlreader.GetValue(11).ToString(); linkLabel1.Text = Sqlreader.GetValue(12).ToString(); label12.Text = Sqlreader.GetValue(13).ToString(); var img = (byte[])(Sqlreader.GetValue(9)); if (img.Length != 0) { bunifuPictureBox1.Image = Image.FromStream(new MemoryStream(img)); } var stat = Sqlreader.GetValue(7).ToString(); label5.Text = stat == "1" ? @"Approved" : @"Pending"; } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; UseWaitCursor = false; }
private async Task XLoadMailinfo() { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Select * from tbl_email_settings"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); //metroComboBox1.Items.Clear(); if (Sqlreader.Read()) { _mymail = Sqlreader.GetValue(0).ToString(); _mypassword = Sqlreader.GetValue(1).ToString(); _subject = Sqlreader.GetValue(2).ToString(); _mailmsg = Sqlreader.GetValue(3).ToString(); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; }
private static async Task XretriveProduct() { await Conopen(); Strsql = "Select * from tbl_Transaction_Detail where Inv_Num='" + TranNum + "'"; Sqlcmd.CommandText = Strsql; Sqlcmd.Connection = Cnn; Sqladapter.SelectCommand = Sqlcmd; Sqlreader = Sqlcmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(Sqlreader); for (int i = 0; i < dt.Rows.Count; i++) { prdid = dt.Rows[i]["Prod_Number"].ToString(); prdqty = Convert.ToInt32(dt.Rows[i]["qty"].ToString()); await Xupdateproduct(); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; }
private async Task XLoadLogs() { await Conopen(); Strsql = "Select * from tbl_logs where u_name='" + username + "'"; 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()); lvi.SubItems.Add(Sqlreader.GetValue(4).ToString()); lvi.SubItems.Add(Sqlreader.GetValue(5).ToString()); } Sqlcmd.Dispose(); Sqlreader.Close(); Cnn.Close(); Strsql = ""; bunifuDatepicker1.Value = Today; }