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();
}
public MstPatientDetailForm(MstPatientForm mstPatientForm, Models.MstPatientModel mstPatientModel)
{
InitializeComponent();
patientForm = mstPatientForm;
patientModel = mstPatientModel;
GetTablesData();
SetPatientDetailData();
}
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();
}
}
}
}
