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