public int InsertDiagnosisDetails(PatientDiagnosisDetails patientDiagnosisObject) { int queryStatus = 0; databaseObject.CommandToExecute = new SqlCommand(); databaseObject.CommandToExecute.CommandText = @"uspInsertPatientDiagnosisDetails"; databaseObject.CommandToExecute.CommandType = CommandType.StoredProcedure; databaseObject.DBDataTable = new DataTable(); databaseObject.DBDataTable.Columns.Add("PatientId", typeof(int)); databaseObject.DBDataTable.Columns.Add("DiagnosisId", typeof(int)); databaseObject.DBDataTable.Columns.Add("Symptoms", typeof(string)); databaseObject.DBDataTable.Columns.Add("DiagnosisProvided", typeof(string)); databaseObject.DBDataTable.Columns.Add("Physician", typeof(string)); databaseObject.DBDataTable.Columns.Add("DateOfDiagnosis", typeof(DateTime)); databaseObject.DBDataTable.Columns.Add("FollowupRequired", typeof(string)); databaseObject.DBDataTable.Columns.Add("DateOfFollowup", typeof(DateTime)); databaseObject.DBDataTable.Columns.Add("BillId", typeof(int)); databaseObject.DBDataTable.Rows.Add(patientDiagnosisObject.PatientId, patientDiagnosisObject.DiagnosisId, patientDiagnosisObject.Symptoms, patientDiagnosisObject.DiagnosisProvided, patientDiagnosisObject.AdministeredBy, patientDiagnosisObject.DateOfDiagnosis, patientDiagnosisObject.FollowUpRequired, patientDiagnosisObject.FollowUpDate, patientDiagnosisObject.BillId); param1.ParameterName = "@userDiagnosisData"; param1.Value = databaseObject.DBDataTable; param1.SqlDbType = SqlDbType.Structured; try { databaseObject.CommandToExecute.Connection = databaseObject.DatabaseConnection; databaseObject.DatabaseConnection.Open(); databaseObject.CommandToExecute.Parameters.Add(param1); queryStatus = databaseObject.CommandToExecute.ExecuteNonQuery(); } catch (SqlException ex) { return ex.ErrorCode; } finally { databaseObject.DatabaseConnection.Close(); } return queryStatus; }
public int InsertDiagnosisDetails(PatientDiagnosisDetails patientDiagnosisObject) { return (diagnosisDetailsDALObject.InsertDiagnosisDetails(patientDiagnosisObject)); }