private void Button3_Click(object sender, System.EventArgs e)
{
cnnt sc = new cnnt();
sc.insqry = ("UPDATE `pricetbl` SET `Price_Of_One`= \'" + (txtupd.Text + ("\' WHERE `Item_Id`= \'" + (txtitm.Text + "\'"))));
sc.cnntotbl();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
cnnt sc = new cnnt();
sc.insqry = ("UPDATE `insert` SET " + (quantity.Text + ("= \'" + (unitPrice.Text + ("\' WHERE `productID`= \'" + (productID.Text + "\'"))))));
sc.cnntotbl();
}
private void Button5_Click(object sender, System.EventArgs e)
{
try
{
string ty;
if (rb0.Checked)
{
ty = "1";
}
if (rbadmin.Checked)
{
ty = "0";
}
cnnt sc = new cnnt();
sc.insqry = ("INSERT INTO `logtbl`(`Id`, `Paswrd`, `type`) VALUES (\'" + (txtitm.Text + ("\',\'" + (txtupd.Text + "\',\'1\')"))));
sc.cnntotbl();
MessageBox.Show("New user created successfully");
try
{
System.IO.FileStream file;
System.IO.File.Copy(path, (txtitm.Text + ".jpg"));
//file.Close();
}
catch (Exception ex)
{
}
}
catch (Exception ex)
{
MessageBox.Show(("ErrorToString creating user " + ex.Message));
}
}
private void Button2_Click(object sender, System.EventArgs e)
{
cnnt sc = new cnnt();
sc.insqry = ("UPDATE `customertbl` SET " + (txtupid.Text + ("= \'" + (txtd.Text + ("\' WHERE `Customer_Id`= \'" + (txtui.Text + "\'"))))));
sc.cnntotbl();
}
public void inscupy()
{
cnnt sc = new cnnt();
try
{
sc.cnntotbl();
sc.insqry = ("insert into `customertbl`(`Customer_Id`, `Customer_Fname`, `Customer_Lname`, `Birth_Day`, `Gender`, `Id_Type`, `tpnum`, `Email`) values (\'"
+ (TxtInum.Text + ("\',\'"
+ (TxtFname.Text + ("\',\'"
+ (TxtLname.Text + ("\',\'"
+ (DtpBday.Text + ("\',\'"
+ (CmbGender.SelectedItem + ("\',\'"
+ (CmbItp.SelectedItem + ("\',\'"
+ (TxtTpn.Text + ("\',\'"
+ (TxtEml.Text + "\')"))))))))))))))));
sc.cnntotbl();
sc.insqry = ("insert into `paymenttbl`(`Bill_Id`, `Amount`, `Paid`, `Balance`, `Emp_Id`, `Time`, `Date_P`, `Customer_Id`) values (\'"
+ (TxtBnum.Text + ("\',\'"
+ (TxtTtl.Text + ("\',\'"
+ (TxtPd.Text + ("\',\'"
+ (TxtBlnc.Text + ("\',\'"
+ (Txt_stfId.Text + ("\',\'"
+ (DtpTime.Text + ("\',\'"
+ (DtpDate.Text + ("\',\'"
+ (TxtInum.Text + "\')"))))))))))))))));
sc.cnntotbl();
sc.insqry = ("insert into `payment_tbl`(`Bill_Id`, `Customer_Id`, `Item_Id`, `Date_B`) values (\'"
+ (TxtBnum.Text + ("\',\'"
+ (TxtInum.Text + ("\',\'"
+ (TxtIeamId.Text + ("\',\'"
+ (DtpDate.Text + "\')"))))))));
}
catch (Exception e)
{
MessageBox.Show("" + e);
}
}
private void BtnRoom_Click(object sender, EventArgs e)
{
cnnt sc = new cnnt();
inscupy();
sc.insqry = ("INSERT INTO `roomtbl`(`Room_Id`, `Room_Type`, `Room_category`, `Number_Of_Rooms`, `Adult`, `Child`, `Check_In`, `Check_Out`, `Availability`, `Bill_Id`) VALUES (\'"
+ (TxtRmid.Text + ("\',\'"
+ (CmbRmtyp.Text + ("\',\'"
+ (CmbRcat.Text + ("\',\'"
+ (TxtNrm.Text + ("\',\'"
+ (TxtAdult.Value + ("\',\'"
+ (TxtChild.Value + ("\',\'"
+ (DtpIn.Text + ("\',\'"
+ (DtpOut.Text + ("\',\'0\',\'"
+ (TxtBnum.Text + "\' )"))))))))))))))))));
sc.cnntotbl();
sc.insqry = ("INSERT INTO `avltbl`(`RoomId`, `SDate`, `numofdays`) VALUES (\'"
+ (TxtRmid.Text + ("\',\'"
+ (DtpIn.Text + ("\',\'"
+ (txtdys.Text + "\' )"))))));
sc.cnntotbl();
MessageBox.Show("Done! one record added succesfully!");
}
void Button4_Click(object sender, System.EventArgs e)
{
try
{
cnnt sc = new cnnt();
sc.insqry = ("update logtbl set Paswrd= \'" + (txtupd.Text + ("\' where Id= \'" + (txtitm.Text + "\'"))));
sc.cnntotbl();
MessageBox.Show("Password changed successfully");
}
catch (Exception ex)
{
MessageBox.Show("error updating password" + ex.Message);
}
}
private void btnshw_Click(object sender, System.EventArgs e)
{
try
{
cnnt sc = new cnnt();
sc.cnntotbl();
sc.insqry = ("SELECT * FROM `paymenttbl` WHERE `Customer_Id` = \'" + (txtcusid.Text + "\' and `Balance` > \'0\'"));
sc.schfn();
Dgb.DataSource = sc.stv;
}
catch (Exception ex)
{
MessageBox.Show(("Please check entered values " + ex.Message));
}
}
private void Button3_Click(object sender, System.EventArgs e)
{
DialogResult qu = MessageBox.Show("Are you sure?", "Delete", MessageBoxButtons.YesNo);
if ((qu == DialogResult.Yes))
{
cnnt sc = new cnnt();
sc.insqry = ("delete from " + (cmbdel.Text + (" where Room_Id=\'" + (Txtdel.Text + ("\' and Bill_Id=\'" + (txtdel2.Text + "\' "))))));
MessageBox.Show("Record deleted succusfully!");
sc.cnntotbl();
}
else
{
MessageBox.Show("Cancel");
}
}
private void Button2_Click(object sender, System.EventArgs e)
{
try
{
cnnt sc = new cnnt();
sc.insqry = ("UPDATE `paymenttbl` SET `Balance`\'" + (txtpbnc.Text + ("\', `Paid` = \'" + (txtttp.Text + ("\' where `Bill_Id` = \'" + (TxtBnum.Text + "\'"))))));
sc.cnntotbl();
sc.insqry = ("SELECT * FROM `paymenttbl` WHERE `Customer_Id` = \'" + (txtcusid.Text + "\' and `Balance` > \'0\'"));
sc.schfn();
Dgb.DataSource = sc.stv;
}
catch (Exception ex)
{
MessageBox.Show(("Please check entered values " + ex.Message));
}
}
