示例#1
0
        private void btnEdit_Click(object sender, EventArgs e)
        {
            int nIncidentId = 0;
            int nIllnessId  = 0;
            int result      = 0;

            for (int i = 0; i < gvIncidents.Rows.Count; i++)
            {
                //nIncidentId = int.Parse(gvIncidents["Incident_Id", i]?.Value?.ToString())
                if (int.TryParse(gvIncidents["Incident_Id", i]?.Value?.ToString(), NumberStyles.Number, new CultureInfo("en-US"), out result))
                {
                    nIncidentId = result;
                }
                if (int.TryParse(gvIncidents["Illness_Id", i]?.Value?.ToString(), NumberStyles.Number, new CultureInfo("en-US"), out result))
                {
                    nIllnessId = result;
                }
            }

            if (nIncidentId != 0 && nIllnessId != 0)
            {
                frmIncidentCreationPage frm = new frmIncidentCreationPage();

                frm.strIncidentId   = nIncidentId.ToString();
                frm.strCaseId       = CaseId;
                frm.strIndividualId = IndividualId;
                frm.nLoggedInId     = nLoggedInId;
                frm.mode            = frmIncidentCreationPage.IncidentMode.Edit;

                //frm.ShowDialog();


                DialogResult dlgEditIncident = frm.ShowDialog();

                //if (dlgEditIncident == DialogResult.OK)
                //{
                //    Close();
                //}
                //if (dlgEditIncident == DialogResult.OK)
                //{

                //}

                //String strSqlQueryForIncident = "select [dbo].[tbl_incident].[Case_id], [dbo].[tbl_incident].[Illness_Id], [dbo].[tbl_program].[ProgramName], [dbo].[tbl_program].[CreateDate], " +
                //                                "[dbo].[tbl_program].[ModifiDate], [dbo].[tbl_program].[IncidentNote] from [dbo].[tbl_program] " +
                //                                "inner join [dbo].[tbl_program] on [dbo].[tbl__incident].[Program_id] = [dbo].[tbl_program].[Program_Id] " +
                //                                "where [dbo].[tbl_incident].[Incident_id] = @IncidentId and [dbo].[tbl_incident].[Individual_id] = @IndividualId";

                //SqlCommand cmdQueryForIncident = new SqlCommand(strSqlQueryForIncident, connRNDB);
                //cmdQueryForIncident.CommandType = CommandType.Text;

                //cmdQueryForIncident.Parameters.AddWithValue("@IncidentId", nIncidentId);
                //cmdQueryForIncident.Parameters.AddWithValue("@IndividualId", IndividualId);

                //connRNDB.Open();
                //SqlDataReader rdrIncident = cmdQueryForIncident.ExecuteReader();
                //if (rdrIncident.HasRows)
                //{
                //    rdrIncident.Read();
                //    //if (!rdrIncident.IsDBNull(0))
                //}
            }
        }
示例#2
0
        private void btnAddNew_Click(object sender, EventArgs e)
        {
            frmIncidentCreationPage frmIncidentCreation = new frmIncidentCreationPage();

            frmIncidentCreation.strIndividualId = IndividualId;
            frmIncidentCreation.strCaseId       = CaseId;
            frmIncidentCreation.strIllnessId    = IllnessId;
            frmIncidentCreation.nLoggedInId     = nLoggedInId;

            frmIncidentCreation.mode = frmIncidentCreationPage.IncidentMode.AddNew;

            if (frmIncidentCreation.ShowDialog(this) == DialogResult.OK)
            {
                // Do when an incident is created successfully
                //String strSqlQueryForIncident = "select [dbo].[tbl_incident].[incident_id], [dbo].[tbl_incident].[individual_id], [dbo].[tbl_incident].[Case_id], [dbo].[tbl_incident].[Illness_id], " +
                //                                "[dbo].[tbl_incident].[CreateDate], [dbo].[tbl_incident].[Program_id], [dbo].[tbl_incident].[IncidentNote] " +
                //                                "from ([dbo].[tbl_incident] inner join [dbo].[tbl_illness] on [dbo].[tbl_incident].[Illness_id] = [dbo].[tbl_illness].[Illness_Id]) " +
                //                                "where [dbo].[tbl_incident].[individual_id] = @IndividualId and " +
                //                                "[dbo].[tbl_incident].[Case_id] = @CaseId and " +
                //                                "[dbo].[tbl_illness].[ICD_10_Id] = @ICD10Code";
                String strSqlQueryForIncident = "select [dbo].[tbl_incident].[incident_id], [dbo].[tbl_incident].[individual_id], [dbo].[tbl_incident].[Case_id], [dbo].[tbl_incident].[Illness_id], " +
                                                "[dbo].[tbl_incident].[CreateDate], [dbo].[tbl_program].[ProgramName], [dbo].[tbl_incident].[IncidentNote] " +
                                                "from ([dbo].[tbl_incident] inner join [dbo].[tbl_illness] on [dbo].[tbl_incident].[Illness_id] = [dbo].[tbl_illness].[Illness_Id]) " +
                                                "inner join [dbo].[tbl_program] on [dbo].[tbl_incident].[Program_id] = [dbo].[tbl_program].[Program_Id] " +
                                                "where [dbo].[tbl_incident].[individual_id] = @IndividualId and " +
                                                "[dbo].[tbl_incident].[Case_id] = @CaseId and " +
                                                "[dbo].[tbl_illness].[ICD_10_Id] = @ICD10Code and " +
                                                "[dbo].[tbl_incident].[IsDeleted] = 0 " +
                                                "order by [dbo].[tbl_incident].[incident_id]";

                SqlCommand cmdQueryForIncident = new SqlCommand(strSqlQueryForIncident, connRNDB);
                cmdQueryForIncident.CommandType = CommandType.Text;
                cmdQueryForIncident.CommandText = strSqlQueryForIncident;

                cmdQueryForIncident.Parameters.AddWithValue("@IndividualId", IndividualId);
                cmdQueryForIncident.Parameters.AddWithValue("@CaseId", CaseId);
                cmdQueryForIncident.Parameters.AddWithValue("@ICD10Code", ICD10Code);

                //SqlDependency dependencyIncident = new SqlDependency(cmdQueryForIncident);
                //dependencyIncident.OnChange += new OnChangeEventHandler(OnIncidentListChange);

                if (connRNDB.State == ConnectionState.Open)
                {
                    connRNDB.Close();
                    connRNDB.Open();
                }
                else if (connRNDB.State == ConnectionState.Closed)
                {
                    connRNDB.Open();
                }

                SqlDataReader rdrIncidents = cmdQueryForIncident.ExecuteReader();

                gvIncidents.Rows.Clear();
                if (rdrIncidents.HasRows)
                {
                    while (rdrIncidents.Read())
                    {
                        DataGridViewRow row = new DataGridViewRow();

                        row.Cells.Add(new DataGridViewCheckBoxCell {
                            Value = false
                        });
                        row.Cells.Add(new DataGridViewTextBoxCell {
                            Value = rdrIncidents.GetInt32(0)
                        });
                        row.Cells.Add(new DataGridViewTextBoxCell {
                            Value = rdrIncidents.GetInt32(3)
                        });
                        row.Cells.Add(new DataGridViewTextBoxCell {
                            Value = rdrIncidents.GetDateTime(4)
                        });
                        row.Cells.Add(new DataGridViewTextBoxCell {
                            Value = rdrIncidents.GetString(5)
                        });
                        row.Cells.Add(new DataGridViewTextBoxCell {
                            Value = rdrIncidents.GetString(6)
                        });

                        gvIncidents.Rows.Add(row);
                    }
                }

                if (connRNDB.State == ConnectionState.Open)
                {
                    connRNDB.Close();
                }
            }
        }