private void ORVibtn_Click(object sender, EventArgs e)
{
if (ORvirbtn.Checked == true)
{
ORnumtxt.Text = "";
ORnumtxt.Enabled = false;
BalloonKingdomDataSetTableAdapters.Official_ReceiptTableAdapter orview = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Official_ReceiptTableAdapter();
DataTable datatable = orview.ViewAll();
Official_Receipt_Masterlist rpt = new Official_Receipt_Masterlist();
OfficialReceipt orpt = new OfficialReceipt();
orpt.SetDataSource(datatable);
rpt.AssignORReport(orpt);
rpt.Show();
}
else
{
if ((ORnumtxt.Text != "" && ORUptxt.Text == "") || (ORnumtxt.Text == "" && ORUptxt.Text != "") || (ORnumtxt.Text == "" && ORUptxt.Text == ""))
{
MessageBox.Show("Please enter an OR ID", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
int a = Convert.ToInt32(ORnumtxt.Text);
int b = Convert.ToInt32(ORUptxt.Text);
BalloonKingdomDataSetTableAdapters.Official_ReceiptTableAdapter ornum = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Official_ReceiptTableAdapter();
DataTable datatable = ornum.orselect(a, b);
Official_Receipt_Masterlist rpt = new Official_Receipt_Masterlist();
OfficialReceipt orpt = new OfficialReceipt();
orpt.SetDataSource(datatable);
rpt.AssignORReport(orpt);
rpt.Show();
}
}
}
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();
}
}