private void btnempreg_Click(object sender, EventArgs e)
{
if (txtclientName.Text == "" || txtcnic.Text == "" || txtcaddrees.Text == "" || txtcphone.Text == "" || rdoMale.Checked == false && rdoFemale.Checked == false || cmbcdrug.Text == "" || cmbccounciller.Text == "" || txtcjob.Text == "" || txtcguardian.Text == "" || rdopayment.Checked == false && rdonunpayment.Checked == false)
{
MessageBox.Show("Please check the form again");
if (txtclientName.Text == "")
{
pnlfullname.Show();
}
if (txtcnic.Text == "")
{
pnlcNic.Show();
}
if (txtcaddrees.Text == "")
{
pnlcaddress.Show();
}
if (txtcphone.Text == "")
{
pnlcPhone.Show();
}
if (rdoMale.Checked == false && rdoFemale.Checked == false)
{
pnlcGender.Show();
}
if (cmbcdrug.Text == "")
{
pnlcDrug.Show();
}
if (cmbccounciller.Text == "")
{
pnlccounciller.Show();
}
if (txtcjob.Text == "")
{
pnlcJob.Show();
}
if (txtcguardian.Text == "")
{
pnlcGuardian.Show();
}
if (rdopayment.Checked == false && rdonunpayment.Checked == false)
{
pnlrdopaymentorNon.Show();
}
}
else
{
if (rdopayment.Checked == true || rdonunpayment.Checked == true)
{
if (rdopayment.Checked == true)
{
clienttotal = "15000";
if (txtcpayment.Text == "")
{
MessageBox.Show("please check the form again");
pnlcPay.Show();
}
else
{
SqlDataAdapter adt = new SqlDataAdapter("select count(*) from ClientRegistation where NIC='" + txtcnic.Text + "'", con);
DataTable dt = new DataTable();
adt.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
MessageBox.Show("Already complete the Registation");
}
else
{
byte[] im = null;
FileStream streem = new FileStream(imagelocation3, FileMode.Open, FileAccess.Read);
BinaryReader brs = new BinaryReader(streem);
im = brs.ReadBytes((int)streem.Length);
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO ClientRegistation(ClientID,FullName,Address,NIC,PhoneNumber,Birthday,Gender,MainDrug,Counciller,Job,GuardianName,JoinDate,PaymentOrNot,Total,Payment,DischargeDate,ClientPhoto)VALUES('" + clientId + "','" + txtclientName.Text + "','" + txtcaddrees.Text + "','" + txtcnic.Text + "','" + txtcphone.Text + "','" + dtpcbirth.Text + "','" + Gender + "','" + cmbcdrug.Text + "','" + cmbccounciller.Text + "','" + txtcjob.Text + "','" + txtcguardian.Text + "','" + Jdate + "','" + paymentNot + "','" + clienttotal + "','" + txtcpayment.Text + "','" + discharge + "',@im)", con);
cmd.Parameters.Add(new SqlParameter("@im", im));
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Save completed");
selectClient();
this.Close();
Home r = new Home(para, para2, typerec);
r.ShowDialog();
}
}
}
if (rdonunpayment.Checked == true)
{
clienttotal = "0";
SqlDataAdapter adt2 = new SqlDataAdapter("select count(*) from ClientRegistation where NIC='" + txtcnic.Text + "'", con);
DataTable dt2 = new DataTable();
adt2.Fill(dt2);
if (dt2.Rows[0][0].ToString() == "1")
{
MessageBox.Show("Already complete the Registation");
}
else
{
byte[] img = null;
FileStream streem = new FileStream(imagelocation3, FileMode.Open, FileAccess.Read);
BinaryReader brs = new BinaryReader(streem);
img = brs.ReadBytes((int)streem.Length);
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO ClientRegistation(ClientID,FullName,Address,NIC,PhoneNumber,Birthday,Gender,MainDrug,Counciller,Job,GuardianName,JoinDate,PaymentOrNot,Total,Payment,DischargeDate,ClientPhoto)VALUES('" + clientId + "','" + txtclientName.Text + "','" + txtcaddrees.Text + "','" + txtcnic.Text + "','" + txtcphone.Text + "','" + dtpcbirth.Text + "','" + Gender + "','" + cmbcdrug.Text + "','" + cmbccounciller.Text + "','" + txtcjob.Text + "','" + txtcguardian.Text + "','" + Jdate + "','" + paymentNot + "','" + clienttotal + "','" + txtcpayment.Text + "','" + discharge + "',@img)", con);
cmd.Parameters.Add(new SqlParameter("@img", img));
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Save completed");
selectClient();
this.Close();
Home r = new Home(para, para2, typerec);
r.ShowDialog();
}
}
}
}
}