public int InsertPatientDetails(PatientDetails1 patientDetailsObject) { int queryStatus = 0; databaseObject.CommandToExecute = new SqlCommand(); databaseObject.CommandToExecute.CommandText = @"uspInsertPatientInfo"; databaseObject.CommandToExecute.CommandType = CommandType.StoredProcedure; databaseObject.DBDataTable = new DataTable(); databaseObject.DBDataTable.Columns.Add("PatientId", typeof(int)); databaseObject.DBDataTable.Columns.Add("PatientFirstName", typeof(string)); databaseObject.DBDataTable.Columns.Add("PatientLastName", typeof(string)); databaseObject.DBDataTable.Columns.Add("PatientDateOfBirth", typeof(DateTime)); databaseObject.DBDataTable.Columns.Add("PatientEmailId", typeof(string)); databaseObject.DBDataTable.Columns.Add("PatientPhoneNumber", typeof(string)); databaseObject.DBDataTable.Columns.Add("PatientStateId", typeof(string)); databaseObject.DBDataTable.Columns.Add("PatientInsurancePlanId", typeof(string)); databaseObject.DBDataTable.Rows.Add(patientDetailsObject.PatientId, patientDetailsObject.PatientFirstName, patientDetailsObject.PatientLastName, patientDetailsObject.DateOfBirth, patientDetailsObject.EmailId, patientDetailsObject.PhoneNumber, patientDetailsObject.StateId, patientDetailsObject.InsurancePlan); param1 = new SqlParameter(); param1.ParameterName = "@PatientInput"; 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(); return(queryStatus); } catch (SqlException ex) { return(queryStatus); } finally { databaseObject.DatabaseConnection.Close(); } }
public int CheckNameOfPatientExists(PatientDetails1 patientDetailsObject) { int result = 0; databaseObject.CommandToExecute.CommandText = @"uspCheckAvailabilityOfPatientName"; databaseObject.CommandToExecute.CommandType = CommandType.StoredProcedure; SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@patientFirstName"; param1.Value = patientDetailsObject.PatientFirstName; SqlParameter param2 = new SqlParameter(); param2.ParameterName = "@patientLastName"; param2.Value = patientDetailsObject.PatientLastName; try { databaseObject.CommandToExecute.Connection = databaseObject.DatabaseConnection; databaseObject.DatabaseConnection.Open(); databaseObject.CommandToExecute.Parameters.Add(param1); databaseObject.CommandToExecute.Parameters.Add(param2); databaseObject.DBDataReader = databaseObject.CommandToExecute.ExecuteReader(); if (databaseObject.DBDataReader.HasRows == true) { while (databaseObject.DBDataReader.Read()) { result = Convert.ToInt32(databaseObject.DBDataReader[0].ToString()); } } } catch (SqlException ex) { } finally { databaseObject.DatabaseConnection.Close(); } return(result); }
public DataTable ViewPatientDetails(PatientDetails1 patientDetailsObject) { databaseObject.DatabaseDataAdapter = new SqlDataAdapter(); databaseObject.DBDataTable = new DataTable(); databaseObject.CommandToExecute = new SqlCommand(); databaseObject.CommandToExecute.CommandText = @"uspGetPatientDetails"; SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@patientFirstName"; param1.Value = patientDetailsObject.PatientFirstName; SqlParameter param2 = new SqlParameter(); param2.ParameterName = "@patientLastName"; param2.Value = patientDetailsObject.PatientLastName; databaseObject.CommandToExecute.Parameters.Add(param1); databaseObject.CommandToExecute.Parameters.Add(param2); databaseObject.CommandToExecute.CommandType = CommandType.StoredProcedure; databaseObject.CommandToExecute.Connection = databaseObject.DatabaseConnection; try { databaseObject.DatabaseDataAdapter.SelectCommand = databaseObject.CommandToExecute; databaseObject.DatabaseDataAdapter.Fill(databaseObject.DBDataTable); } catch (SqlException ex) { return(databaseObject.DBDataTable); } finally { databaseObject.DatabaseConnection.Close(); } return(databaseObject.DBDataTable); }
public int UpdatePatientDetails(PatientDetails1 patientDetailsObject) { int result = 0; databaseObject.CommandToExecute.CommandText = @"uspUpdatePatientDetails"; databaseObject.CommandToExecute.CommandType = CommandType.StoredProcedure; SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@patientFirstName"; param1.Value = patientDetailsObject.PatientFirstName; SqlParameter param2 = new SqlParameter(); param2.ParameterName = "@patientLastName"; param2.Value = patientDetailsObject.PatientLastName; SqlParameter param3 = new SqlParameter(); param3.ParameterName = "@dateOfBirth"; param3.Value = patientDetailsObject.DateOfBirth; SqlParameter param4 = new SqlParameter(); param4.ParameterName = "@emailId"; param4.Value = patientDetailsObject.EmailId; SqlParameter param5 = new SqlParameter(); param5.ParameterName = "@phoneNumber"; param5.Value = patientDetailsObject.PhoneNumber; SqlParameter param6 = new SqlParameter(); param6.ParameterName = "@patientStateId"; param6.Value = patientDetailsObject.StateId; try { databaseObject.CommandToExecute.Connection = databaseObject.DatabaseConnection; databaseObject.DatabaseConnection.Open(); databaseObject.CommandToExecute.Parameters.Add(param1); databaseObject.CommandToExecute.Parameters.Add(param2); databaseObject.CommandToExecute.Parameters.Add(param3); databaseObject.CommandToExecute.Parameters.Add(param4); databaseObject.CommandToExecute.Parameters.Add(param5); databaseObject.CommandToExecute.Parameters.Add(param6); result = databaseObject.CommandToExecute.ExecuteNonQuery(); } catch (SqlException ex) { } finally { databaseObject.DatabaseConnection.Close(); } return(result); }
public int UpdatePatientDetails(PatientDetails1 patientDetailsObject) { return(patientDetailsDALObject.UpdatePatientDetails(patientDetailsObject)); }
public DataTable ViewPatientDetails(PatientDetails1 patientDetailsObject) { return(patientDetailsDALObject.ViewPatientDetails(patientDetailsObject)); }
public int CheckNameOfPatientExists(PatientDetails1 patientDetailsObject) { return(patientDetailsDALObject.CheckNameOfPatientExists(patientDetailsObject)); }
public int InsertPatientDetails(PatientDetails1 patientDetailsObject) { return(patientDetailsDALObject.InsertPatientDetails(patientDetailsObject)); }