private void save_Click(object sender, EventArgs e)
{
try
{
Member member = new Member();
User u = new User();
String cncid = "D" + district_no.Text + "T" + thana_no.Text + "U" + union_no.Text + "C" + cncbox.Text + "";
String khanaid = "D" + district_no.Text + "T" + thana_no.Text + "U" + union_no.Text + "C" + cncbox.Text + "K" + khanabox.Text + "";
//MessageBox.Show(khanaid);
Khana k = new Khana();
k.Insert(
Convert.ToInt32(khanabox.Text),
cncid,
userid,
Convert.ToInt32(chalabox.Text),
Convert.ToInt32(wallbox.Text),
Convert.ToInt32(floorbox.Text),
Convert.ToInt32(watersourcebox.Text),
Convert.ToInt32(evaluationbox.Text),
Convert.ToInt32(housevaluebox.Text),
Convert.ToInt32(totallandbox.Text),
Convert.ToInt32(landvaluebox.Text),
Convert.ToInt32(cowbox.Text),
Convert.ToInt32(goatbox.Text),
Convert.ToInt32(henbox.Text),
Convert.ToInt32(treebox.Text),
Convert.ToInt32(vegitablebox.Text),
Convert.ToInt32(monthscoveredbox.Text),
Convert.ToInt32(bedbox.Text),
Convert.ToInt32(chairbox.Text),
Convert.ToInt32(radiobox.Text),
Convert.ToInt32(tvbox.Text),
Convert.ToInt32(tubewellbox.Text),
Convert.ToInt32(gavibox.Text),
Convert.ToInt32(sagolbox.Text),
Convert.ToInt32(daylabourerbox.Text),
Convert.ToInt32(dayslabourbox.Text),
Convert.ToInt32(latrinebox.Text),
Convert.ToString(datacollectorbox.Text),
Convert.ToString(cnocnpbox.Text),
Convert.ToString(datebox.Text),
khanaid);
u.increaseKhanaCount(userid);
khanacountbox.Text = u.getKhanaCount(userid).ToString();
for (int j = 0; j < i; j++)
{
String memberid = "D" + district_no.Text + "T" + thana_no.Text + "U" + union_no.Text + "C" + cncbox.Text + "K" + khanabox.Text + "M" + Convert.ToInt32(dataGridView1[0, j].Value) + "";
member.Insert(
memberid,
Convert.ToInt32(dataGridView1[0, j].Value),
Convert.ToInt32(dataGridView1[1, j].Value),
Convert.ToString(dataGridView1[2, j].Value),
Convert.ToInt32(dataGridView1[3, j].Value),
Convert.ToInt32(dataGridView1[4, j].Value),
Convert.ToString(dataGridView1[5, j].Value),
Convert.ToInt32(dataGridView1[6, j].Value),
Convert.ToInt32(dataGridView1[7, j].Value),
Convert.ToInt32(dataGridView1[8, j].Value),
Convert.ToInt32(dataGridView1[9, j].Value),
float.Parse(dataGridView1[11, j].Value.ToString()),
Convert.ToInt32(dataGridView1[12, j].Value),
Convert.ToInt32(dataGridView1[13, j].Value),
Convert.ToInt32(dataGridView1[10, j].Value),
khanaid);
u.increaseMemberCount(userid);
membercountbox.Text = u.getMemberCount(userid).ToString();
}
khanabox.Clear();
chalabox.Clear();
wallbox.Clear();
floorbox.Clear();
watersourcebox.Clear();
evaluationbox.Clear();
housevaluebox.Clear();
totallandbox.Clear();
landvaluebox.Clear();
cowbox.Clear();
goatbox.Clear();
henbox.Clear();
treebox.Clear();
vegitablebox.Clear();
monthscoveredbox.Clear();
bedbox.Clear();
chairbox.Clear();
radiobox.Clear();
tvbox.Clear();
tubewellbox.Clear();
gavibox.Clear();
sagolbox.Clear();
daylabourerbox.Clear();
dayslabourbox.Clear();
latrinebox.Clear();
datacollectorbox.Clear();
cnocnpbox.Clear();
datebox.Clear();
dataGridView1.Rows.Clear();
i = 0;
}
catch (Exception ex) { }
}
private void login_Click(object sender, EventArgs e)
{
User u = new User();
userid = userbox.Text;
//if (u.getPassword(userbox.Text.ToString()) == passwordbox.Text.ToString())
// {
userbox.Visible = false;
username.Visible = false;
passwordbox.Visible = false;
password.Visible = false;
login.Visible = false;
logout.Visible = true;
tabControl1.Visible = true;
membercountbox.Visible = true;
membercountlabel.Visible = true;
khanacounlabel.Visible = true;
khanacountbox.Visible = true;
khanacountbox.Text = u.getKhanaCount(userid).ToString();
membercountbox.Text = u.getMemberCount(userid).ToString();
district_no.Select();
// }
// else
//{
// MessageBox.Show("Invalid Username or Password");
// passwordbox.Clear();
// }
}
