private void buttonAdd_Click(object sender, EventArgs e) { Models.MstPatientModel mstPatientModel = new Models.MstPatientModel() { Id = 0, PatientCode = "", Patient = "", DateEncoded = DateTime.Today, DateOfArrival = DateTime.Today, DateOfQuarantine = DateTime.Today, Age = 0, Sex = "Male", Address = "", ContactNumber = "", BarangayId = 0, CityId = 453, ProvinceId = 25, CountryId = 139, Cluster = "North", PassportNumber = "", Remarks = "" }; MstPatientDetailForm mstPatientDetailForm = new MstPatientDetailForm(this, mstPatientModel); mstPatientDetailForm.ShowDialog(); }
private void dataGridViewPatients_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex > -1 && dataGridViewPatients.CurrentCell.ColumnIndex == dataGridViewPatients.Columns["ColumnEdit"].Index) { Models.MstPatientModel mstPatientModel = new Models.MstPatientModel() { Id = Convert.ToInt32(dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnId"].Index].Value), PatientCode = dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnPatientCode"].Index].Value.ToString(), Patient = dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnPatient"].Index].Value.ToString(), DateEncoded = Convert.ToDateTime(dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnDateEncoded"].Index].Value), DateOfArrival = Convert.ToDateTime(dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnDateOfArrival"].Index].Value), DateOfQuarantine = Convert.ToDateTime(dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnDateOfQuarantine"].Index].Value), Age = Convert.ToInt32(dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnAge"].Index].Value), Sex = dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnSex"].Index].Value.ToString(), Address = dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnAddress"].Index].Value.ToString(), ContactNumber = dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnContactNumber"].Index].Value.ToString(), BarangayId = Convert.ToInt32(dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnBarangayId"].Index].Value), CityId = Convert.ToInt32(dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnCityId"].Index].Value), ProvinceId = Convert.ToInt32(dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnProvinceId"].Index].Value), CountryId = Convert.ToInt32(dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnCountryId"].Index].Value), Cluster = dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnCluster"].Index].Value.ToString(), PassportNumber = dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnPassportNumber"].Index].Value.ToString(), Remarks = dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnRemarks"].Index].Value.ToString(), }; MstPatientDetailForm mstPatientDetailForm = new MstPatientDetailForm(this, mstPatientModel); mstPatientDetailForm.ShowDialog(); } if (e.RowIndex > -1 && dataGridViewPatients.CurrentCell.ColumnIndex == dataGridViewPatients.Columns["ColumnDelete"].Index) { DialogResult deleteDialogResult = MessageBox.Show("Delete Patient?", "Covid 2019", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (deleteDialogResult == DialogResult.Yes) { Int32 id = Convert.ToInt32(dataGridViewPatients.Rows[dataGridViewPatients.CurrentCell.RowIndex].Cells[dataGridViewPatients.Columns["ColumnId"].Index].Value); var currentPatient = from d in db.MstPatients where d.Id == id select d; if (currentPatient.Any()) { db.MstPatients.DeleteOnSubmit(currentPatient.FirstOrDefault()); db.SubmitChanges(); pageNumber = 1; UpdatePatientDataSource(); } } } }