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 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 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 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 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 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(); }
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 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 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 void bunifuImageButton9_Click(object sender, EventArgs e) { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Delete from tbl_notification"; Sqlcmd.Connection = Cnn; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); await XLoadNotification(); }
private async Task XEditMode() { //var a = LoadImage(studimg.ImageSource); //Image temp = new Bitmap(); //try //{ Sqlcmd.Parameters.Clear(); //var strm = new MemoryStream(); ////temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg); //_imagebytearray = strm.ToArray(); byte[] temp = ImageHelper.ImageSourceToBytes(new JpegBitmapEncoder(), studimg.ImageSource); //MemoryStream strm = new(); //temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg); //var a= _imagebytearray = temp.ToArray(); await Conopen(); Strsql = "Update tbl_Students set stud_id=@stud_id, Stud_FName=@Stud_FName, Stud_LName=@Stud_LName, Stud_MInit=@Stud_MInit," + "Crs_Description=@Crs_Description,Yr_Level=@Yr_Level,stud_img=@stud_img, vtc_desc=@vtc_desc Where stud_id=@_preID"; Sqlcmd.Parameters.AddWithValue("@stud_id", studid.Text); Sqlcmd.Parameters.AddWithValue("@Stud_LName", lname.Text); Sqlcmd.Parameters.AddWithValue("@Stud_FName", fname.Text); Sqlcmd.Parameters.AddWithValue("@Stud_MInit", minitial.Text); Sqlcmd.Parameters.AddWithValue("@Crs_Description", course.Text); Sqlcmd.Parameters.AddWithValue("@Yr_Level", yrlevel.Text); Sqlcmd.Parameters.AddWithValue("@stud_img", _imagebytearray); Sqlcmd.Parameters.AddWithValue("@vtc_desc", vtCategory.Text); Sqlcmd.Parameters.AddWithValue("@_preID", SelectedStudId); Sqlcmd.Connection = Cnn; //sqlcmd.CommandType = CommandType.Text; Sqlcmd.CommandText = Strsql; await Sqlcmd.ExecuteNonQueryAsync(); notifier.ShowInformation("Record has been successfully updated!"); Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); Close(); //} //catch //{ // notifier.ShowError("The ID # you've Entered is already in the record! Please verify this problem to the registrar!"); // studid.Text = ""; // studid.Focus(); //} }
private async void numericUpDown1_KeyDown(object sender, KeyEventArgs e) { if (e.KeyData == Keys.Enter) { var ok = new Frm_OK(); var a = new T_Message(); //try //{ Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Update tbl_Transaction_Detail set Tran_D_Subtotal=@Tran_D_Subtotal, Disc=@Disc Where Prod_Number=@Prod_Number And Inv_Num=@Inv_Num"; Sqlcmd.Parameters.AddWithValue("@Tran_D_Subtotal", Convert.ToSingle(lblnewamount.Text)); Sqlcmd.Parameters.AddWithValue("@Disc", Convert.ToDecimal(lbldiscount.Text)); Sqlcmd.Parameters.AddWithValue("@Inv_Num", inv_num); Sqlcmd.Parameters.AddWithValue("@Prod_Number", proid); Sqlcmd.Connection = Cnn; //sqlcmd.CommandType = CommandType.Text; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); ok.OkDescription = "Success"; ok.titletxt.Text = @"Success"; ok.msgtxt.Text = @"Discount has been successfully added!"; a.Show(this); ok.ShowDialog(); a.Hide(); Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); FillCart = true; Hide(); //} //catch (Exception ex) //{ // a.Show(this); // ok.titletxt.Text = @"Error"; // ok.msgtxt.Text = @"System has encountered an unexpected Error! Please contact the system developer relating to this problem."; // ok.OkDescription = "Error"; // ok.ShowDialog(this); // a.Hide(); // Focus(); // //call LogFile method and pass argument as Exception message, event name, control name, error line number, current form name // LogFile(ex.Message, e.ToString(), ((Control)sender).Name, ex.LineNumber(), FindForm()?.Name); //} } }
public static async Task XUpdatelogindate() { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Update tbl_Users set last_login=@last_login Where u_name=@u_name"; Sqlcmd.Parameters.AddWithValue("@last_login", Now); Sqlcmd.Parameters.AddWithValue("@u_name", username); Sqlcmd.Connection = Cnn; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); }
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 XupdateSecurity() { try { UseWaitCursor = true; Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Update tbl_Users set u_name=@u_name, u_pass=@u_pass Where u_name=@u_nam"; Sqlcmd.Parameters.AddWithValue("@u_name", textBox4.Text); Sqlcmd.Parameters.AddWithValue("@u_pass", textBox7.Text); Sqlcmd.Parameters.AddWithValue("@u_nam", username); Sqlcmd.Connection = Cnn; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); Sqlcmd.Dispose(); Strsql = ""; username = textBox4.Text; userpassword = textBox7.Text; Cnn.Close(); _xinfoupdated = false; await XSaveTransactionLog(); popup.TitleText = @"Security updated"; popup.ContentText = @"Your security information has been successfully updated!"; popup.Popup(); UseWaitCursor = false; Close(); } catch { UseWaitCursor = false; textBox5.Text = ""; textBox6.Text = ""; textBox7.Text = ""; popup.TitleText = @"User name"; popup.ContentText = @"The user name you entered is already taken, please enter another user name and try saving the data again!"; popup.Popup(); textBox4.Focus(); } }
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 temporaryBlockedToolStripMenuItem_Click(object sender, EventArgs e) { approvedToolStripMenuItem.Checked = false; blockedToolStripMenuItem.Checked = false; temporaryBlockedToolStripMenuItem.Checked = true; UseWaitCursor = true; Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Update tbl_Users set approval_stat=@approval_stat Where U_ID=@U_ID"; Sqlcmd.Parameters.AddWithValue("@approval_stat", "3"); Sqlcmd.Parameters.AddWithValue("@U_ID", lblid.Text); Sqlcmd.Connection = Cnn; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); UseWaitCursor = false; }
//Convert byte image to imagesource private async Task Xaddmode() { try { //This still needs to edit if the students had no picture, the system must still sav the file. Sqlcmd.Parameters.Clear(); Bitmap temp = new(_selectedFileName); MemoryStream strm = new(); temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg); _imagebytearray = strm.ToArray(); await Conopen(); Strsql = "Insert into tbl_Students(Stud_Id, Stud_FName, Stud_LName, Stud_MInit,Crs_Description,Yr_Level,stud_img, vtc_desc) " + "Values(@Stud_Id, @Stud_FName, @Stud_LName, @Stud_MInit, @Crs_Description, @Yr_Level,@stud_img, @vtc_desc)"; Sqlcmd.Parameters.AddWithValue("@Stud_Id", studid.Text); Sqlcmd.Parameters.AddWithValue("@Stud_FName", fname.Text); Sqlcmd.Parameters.AddWithValue("@Stud_LName", lname.Text); Sqlcmd.Parameters.AddWithValue("@Stud_MInit", minitial.Text); Sqlcmd.Parameters.AddWithValue("@Crs_Description", course.Text); Sqlcmd.Parameters.AddWithValue("@Yr_Level", yrlevel.Text); Sqlcmd.Parameters.AddWithValue("@stud_img", _imagebytearray); Sqlcmd.Parameters.AddWithValue("@vtc_desc", vtCategory.Text); Sqlcmd.Connection = Cnn; Sqlcmd.CommandText = Strsql; _ = await Sqlcmd.ExecuteNonQueryAsync(); Sqlcmd.Dispose(); Strsql = ""; Cnn.Close(); Close(); notifier.ShowSuccess("Data successfully saved!"); } catch { notifier.ShowError("The ID # you've Entered is already in the record! Please verify this problem to the registrar!"); studid.Text = ""; studid.Focus(); } }
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 XSaveTransactionDetails() { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Insert into tbl_Transaction_Detail(Inv_Num, Prod_Number, Qty, Sell_price, Tran_D_Subtotal) " + "Values(@Inv_Num, @Prod_Number, @Qty, @Sell_price, @Tran_D_Subtotal)"; Sqlcmd.Parameters.AddWithValue("@Inv_Num", inv_num); Sqlcmd.Parameters.AddWithValue("@Prod_Number", lblprodID.Text); Sqlcmd.Parameters.AddWithValue("@Qty", numericUpDown1.Value); Sqlcmd.Parameters.AddWithValue("@Sell_price", label9.Text); Sqlcmd.Parameters.AddWithValue("@Tran_D_Subtotal", label6.Text); Sqlcmd.Connection = Cnn; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); Sqlcmd.Dispose(); Cnn.Close(); Strsql = string.Empty; //*****************update products table for stock************************ //*****************There might be an error here in case the clients selects and save the same product at the same time********** //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.ToDouble(label4.Text)); //Sqlcmd.Parameters.AddWithValue("@Prod_Number", lblprodID.Text); //Sqlcmd.Connection = Cnn; //Sqlcmd.CommandText = Strsql; //Sqlcmd.ExecuteNonQuery(); //Sqlcmd.Dispose(); //Strsql = ""; //Cnn.Close(); }
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 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 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 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 async Task XSaveTransaction() { Sqlcmd.Parameters.Clear(); await Conopen(); Strsql = "Insert into tbl_Transaction(Inv_Num, Inv_date, Inv_time, u_name) " + "Values(@Inv_Num, @Inv_date, @Inv_time, @u_name)"; Sqlcmd.Parameters.AddWithValue("@Inv_Num", inv_num); Sqlcmd.Parameters.AddWithValue("@Inv_date", Today); Sqlcmd.Parameters.AddWithValue("@Inv_time", Now.ToString("h:mm:ss tt")); Sqlcmd.Parameters.AddWithValue("@u_name", username); Sqlcmd.Connection = Cnn; Sqlcmd.CommandText = Strsql; Sqlcmd.ExecuteNonQuery(); Sqlcmd.Dispose(); Cnn.Close(); Strsql = string.Empty; }