public houseBLL GetLastinsertedHouseId() { houseBLL h = new houseBLL(); SqlConnection conn = new SqlConnection(myconnstrng); DataTable dt = new DataTable(); try { string sql = "SELECT MAX(house_id) AS house_id FROM tbl_house"; SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); conn.Open(); adapter.Fill(dt); if (dt.Rows.Count > 0) { h.house_id = int.Parse(dt.Rows[0]["house_id"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(h); }
public houseBLL GetToleByHouseID(int house_id) { houseBLL h = new houseBLL(); SqlConnection conn = new SqlConnection(myconnstrng); DataTable dt = new DataTable(); try { string sql = "SELECT tole FROM tbl_house WHERE house_id=" + house_id; SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); conn.Open(); adapter.Fill(dt); if (dt.Rows.Count > 0) { h.tole = dt.Rows[0]["tole"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(h); }
private void dgvVictims_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { int rowindex = e.RowIndex; txtFullName.Text = dgvVictims.Rows[rowindex].Cells[0].Value.ToString(); txtHouseGrade.Text = dgvVictims.Rows[rowindex].Cells[1].Value.ToString(); //Get photo path First string photo = dgvVictims.Rows[rowindex].Cells[5].Value.ToString(); if (photo != "") { //Display Image pictureBoxProfilePhoto.Image = new Bitmap(photo); } txtVictimID.Text = dgvVictims.Rows[rowindex].Cells[7].Value.ToString(); //Now Shwing House Address Based on House ID int house_id = int.Parse(dgvVictims.Rows[rowindex].Cells[6].Value.ToString()); houseBLL hbd = hdal.GetDistrictByHouseID(house_id); string district = hbd.district; houseBLL hbv = hdal.GetVDCByHouseID(house_id); string vdc = hbv.vdc; houseBLL hbw = hdal.GetWardNoByHouseID(house_id); string ward = hbw.ward_no; houseBLL hbt = hdal.GetToleByHouseID(house_id); string tole = hbt.tole; txtAddress.Text = district + ", " + vdc + " - " + ward + ", " + tole; }
public bool Insert(houseBLL h) { //DAtabase Connection First SqlConnection conn = new SqlConnection(myconnstrng); //Define Bool value and set its default value to false bool isSuccess = false; try { //SQL Query to Insert DAta string sql = "INSERT INTO tbl_house (district, vdc, ward_no, tole, latitude, longitude, altitude, added_date) VALUES (@district, @vdc, @ward_no, @tole, @latitude, @longitude, @altitude, @added_date)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@district", h.district); cmd.Parameters.AddWithValue("@vdc", h.vdc); cmd.Parameters.AddWithValue("@ward_no", h.ward_no); cmd.Parameters.AddWithValue("@tole", h.tole); cmd.Parameters.AddWithValue("@latitude", h.latitude); cmd.Parameters.AddWithValue("@longitude", h.longitude); cmd.Parameters.AddWithValue("@altitude", h.altitude); cmd.Parameters.AddWithValue("@added_date", h.added_date); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { //Data Inserted Successfully isSuccess = true; } else { //Failed to Insert DAta isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { //Database Connection Close conn.Close(); } return(isSuccess); }
private void dgvVictims_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { int RowIndex = e.RowIndex; txtFullName.Text = dgvVictims.Rows[RowIndex].Cells[0].Value.ToString(); txtFirstPayment.Text = dgvVictims.Rows[RowIndex].Cells[1].Value.ToString(); txtSecondPayment.Text = dgvVictims.Rows[RowIndex].Cells[2].Value.ToString(); txtThirdPayment.Text = dgvVictims.Rows[RowIndex].Cells[3].Value.ToString(); //For Displaying Profile Picture string photo = dgvVictims.Rows[RowIndex].Cells[4].Value.ToString(); if (photo != "") { //Display Image pictureBoxProfilePhoto.Image = new Bitmap(photo); } //For Displaying House Grade and house Address int house_id = int.Parse(dgvVictims.Rows[RowIndex].Cells[5].Value.ToString()); houseConditionBLL hcb = hcdal.GetHouseGradeByHouseId(house_id); txtHouseGrade.Text = hcb.damage_grade; //Dislaying House Address Based on house_id houseBLL hbd = hdal.GetDistrictByHouseID(house_id); string district = hbd.district; houseBLL hbv = hdal.GetVDCByHouseID(house_id); string vdc = hbv.vdc; houseBLL hbw = hdal.GetWardNoByHouseID(house_id); string ward = hbw.ward_no; houseBLL hbt = hdal.GetToleByHouseID(house_id); string tole = hbt.tole; txtAddress.Text = district + ", " + vdc + " - " + ward + ", " + tole; }
private void btnNext_Click(object sender, EventArgs e) { //Get all the Data from UI h.district = txtDisctrict.Text; h.vdc = txtVDC.Text; h.ward_no = txtWardNo.Text; h.tole = txtTole.Text; h.latitude = txtLatitude.Text; h.longitude = txtLongitude.Text; h.altitude = txtAltitude.Text; h.added_date = DateTime.Now; bool success = hdal.Insert(h); if (success == true) { //House Registered Successfully MessageBox.Show("House Registerd Successfully. Proceed to Next Step."); //Get the Latest House ID and set it to house_id houseBLL hb = hdal.GetLastinsertedHouseId(); house_id = hb.house_id; //Close this form if House Registration Success this.Hide(); //Open House Condition Form if Success frmHouseCondition houseCondition = new frmHouseCondition(); houseCondition.Show(); } else { //FAiled to Register House MessageBox.Show("Failed to Register House. Try Again."); } }