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 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 = "";
}
protected void Button_Click(object sender, EventArgs e)
{
if (!txtUserName.Text.ToString().Equals("") && !txtPassword.Text.ToString().Equals(""))
{
DataTable tbl = new DataTable();
// select the query from the user and password and after check the user name or password
String qry = "select * from Login where UserId='" + txtUserName.Text.ToString() + "' and Password='******'";
Sqlcmd obj = new Sqlcmd();
tbl = obj.dataSrch(qry);
data.InnerHtml = "<script> alert('count---" + tbl.Rows.Count + "');</script>";
//if the record is matched then the dashboard will open otherwise the error message will display
if (tbl.Rows.Count > 0)
{
Response.Redirect("dashboard.aspx");
}
else
{
// data.InnerHtml = "<script> alert('check User Name or Password ');</script>";
txtUserName.Text = "";
txtPassword.Text = "";
}
}
else
{
data.InnerHtml = "<script> alert('Fill user Name or Password');</script>";
}
}
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 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();
}
}
protected void Button_Click(object sender, EventArgs e)
{
///this button is used to pass the query of insert message to the database table
///
if (!txtName.Text.ToString().Equals("") && !txtSubject.Text.ToString().Equals("") && !txtEmail.Text.ToString().Equals("") && !txtMsg.Text.ToString().Equals(""))
{
String qry = "insert into Message(Name,Email,Subject,Msg) values('" + txtName.Text + "','" + txtEmail.Text + "','" + txtSubject.Text + "','" + txtMsg.Text + "')";
Sqlcmd obj = new Sqlcmd();
obj.cmdquery(qry);
data.InnerHtml = "<script>alert('Message has been sent ');</script>";
txtEmail.Text = "";
txtMsg.Text = "";
txtName.Text = "";
txtSubject.Text = "";
}
else
{
data.InnerHtml = "<script>alert('Check details once ');</script>";
}
}
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 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 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;
}
