private void Okbtn_Click(object sender, EventArgs e)
{
if (ORnumtxt.Text == "" || Syspasstxt.Text == "" || Recordtxt.Text == "")
{
MessageBox.Show("Please fill up the required fields.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ORnumtxt.Focus();
}
else if (Syspasstxt.Text.Trim() != password)
{
MessageBox.Show("Invalid password.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Syspasstxt.Text = "";
}
else
{
String id;
int a = 0, id2;
cmd = new SqlCommand("Select * from [Official Receipt]", conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
id = dr["OR ID"].ToString();
id2 = Convert.ToInt32(id);
if (a < id2)
{
a = id2;
}
}
dr.Close();
a++;
BalloonKingdomDataSetTableAdapters.Official_ReceiptTableAdapter addor = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Official_ReceiptTableAdapter();
addor.AddOfficialReceipt(a, DateTime.Now, ORnumtxt.Text.Trim(), Convert.ToInt32(COFNumLbl.Text), Convert.ToDecimal(VatPerLbl.Text), Convert.ToDecimal(VATAmtLbl.Text), Convert.ToDecimal(OrderAmtLbl.Text), Convert.ToDecimal(ServChLbl.Text), Convert.ToDecimal(TotLbl.Text), Recordtxt.Text.Trim());
MessageBox.Show("Successfully entered your OR number!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
private void ORnumtxt_TextChanged(object sender, EventArgs e)
{
Int64 i;
string str;
if (ORnumtxt.Text != " ")
{
str = ORnumtxt.Text;
bool bl = Int64.TryParse(str, out i);
if ((ORnumtxt.Text == " "))
{
toolTip1.Show("Enter a number!", ORnumtxt);
ORnumtxt.Clear();
}
else if (bl == false)
{
toolTip1.Show("Enter a number!", ORnumtxt);
ORnumtxt.Clear();
}
toolTip1.Hide(ORnumtxt);
}
}
