private void saveAll(object sender, EventArgs e)
{
try
{
Member member = new Member();
User u = new User();
String unionid = "D" + district_no.Text + "T" + thana_no.Text + "U" + union_no.Text +"";
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();
Cnc c = new Cnc ();
bool cncexists = c.exist(cncid);
if (cncexists == false)
{
cncexists = c.insert(Convert.ToInt32(cncbox.Text),cncid,unionid);
}
if (cncexists)
{
bool inserted = 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);
if (inserted)
{
//u.increaseKhanaCount(userid);
//khanacountbox.Text = u.getKhanaCount(userid).ToString();
int i = dataGridView1.RowCount - 1;
// MessageBox.Show(i.ToString());
for (int j = 0; j < i; j++)
{
int mother = 0;
float age = 0;
int day = 0, month = 0, year = 0;
float weights = 0;
int heights = 0;
int paritys = 0;
int maritalyear=88;
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) + "";
if (dataGridView1[4, j].Value.ToString().Length > 0)
{
age = float.Parse(dataGridView1[4, j].Value.ToString());
}
String dob = Convert.ToString(dataGridView1[5, j].Value);
String[] dobs = dob.Split('/');
if (dobs[0].Length > 0)
{
day = Convert.ToInt32(dobs[0]);
}
if (dobs[1].Length > 0)
{
month = Convert.ToInt32(dobs[1]);
}
if (dobs[2].Length > 0)
{
year = Convert.ToInt32(dobs[2]);
}
if (dataGridView1[8, j].Value.ToString().Length > 0)
{
maritalyear= Convert.ToInt32(dataGridView1[8, j].Value);
}
if (dataGridView1[11, j].Value.ToString().Length > 0)
{
weights = float.Parse(dataGridView1[11, j].Value.ToString());
}
if (dataGridView1[12, j].Value.ToString().Length > 0)
{
heights = Convert.ToInt32(dataGridView1[12, j].Value);
}
if (dataGridView1[13, j].Value.ToString().Length > 0)
{
paritys = int.Parse( (dataGridView1[13, j].Value.ToString()));
}
if (dataGridView1[1, j].Value.ToString().Length > 0)
{
mother=Convert.ToInt32(dataGridView1[1, j].Value);
}
if (dobs[2].Length == 4)
{
if (Math.Abs(24121 - (year * 12 + month)) <= 24)
age = age / 12;
}
if (dobs[2].Length == 2)
{
if (Math.Abs(121 - (year * 12 + month)) <= 24)
age = age / 12;
}
if (dobs[2].Length == 1)
{
if (Math.Abs(121 - (year * 12 + month)) <= 24)
age = age / 12;
}
bool Memberinserted = member.Insert(
memberid,
Convert.ToInt32(dataGridView1[0, j].Value),
mother,
Convert.ToString(dataGridView1[2, j].Value),
Convert.ToInt32(dataGridView1[3, j].Value),
age,
Convert.ToString(dataGridView1[5, j].Value),
Convert.ToInt32(dataGridView1[6, j].Value),
Convert.ToInt32(dataGridView1[7, j].Value),
maritalyear,
Convert.ToInt32(dataGridView1[9, j].Value),
weights/10,
heights,
paritys,
Convert.ToInt32(dataGridView1[10, j].Value),
khanaid);
if (!Memberinserted)
{
//u.increaseMemberCount(userid);
}
}
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();
//membercountbox.Text = u.getMemberCount(userid).ToString();
dataGridView1.Rows.Clear();
khanabox.Select();
i = 0;
}
}
else
{
k.delete(khanaid);
member.delete(khanaid);
MessageBox.Show("Please check your inputs again");
}
}
catch (Exception ex) {
editbutton_Click(sender, e);
MessageBox.Show("Sorry all data you enter is not saved. \nThe data may not contain all required field . \nPlease re entry not saved information again and click DONE button.");
}
}
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) { }
}