public void UpdateAppointmentDetails(BO_AppointmentDetails DataObjectAppointmentDetails) { string query = "update patient_history set patient_id=@patient_id,appointment_id=@appointment_id,doctor_id=@doctor_id,procedure_id=@procedure_id,date_modified=@date_modified,modified_by=@modified_by,paid=@paid where patient_history_id=@patient_history_id"; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Add("@patient_history_id", SqlDbType.Int, 10, "patient_history_id"); cmd.Parameters["@patient_history_id"].Value = DataObjectAppointmentDetails.Patienthistoryid; cmd.Parameters.Add("@patient_id", SqlDbType.Int, 10, "patient_id"); cmd.Parameters["@patient_id"].Value = DataObjectAppointmentDetails.Patientid; cmd.Parameters.Add("@appointment_id", SqlDbType.Int, 10, "appointment_id"); cmd.Parameters["@appointment_id"].Value = DataObjectAppointmentDetails.Appointmentid; cmd.Parameters.Add("@doctor_id", SqlDbType.Int, 10, "doctor_id"); cmd.Parameters["@doctor_id"].Value = DataObjectAppointmentDetails.Doctorid; cmd.Parameters.Add("@procedure_id", SqlDbType.Int, 10, "procedure_id"); cmd.Parameters["@procedure_id"].Value = DataObjectAppointmentDetails.Procedureid; cmd.Parameters.Add("@date_modified", SqlDbType.DateTime, 12, "date_modified"); cmd.Parameters["@date_modified"].Value = DataObjectAppointmentDetails.Datemodified; cmd.Parameters.Add("@modified_by", SqlDbType.Int, 10, "modified_by"); cmd.Parameters["@modified_by"].Value = DataObjectAppointmentDetails.Modifiedby; cmd.Parameters.Add("@paid", SqlDbType.VarChar, 1, "paid"); cmd.Parameters["@paid"].Value = DataObjectAppointmentDetails.Paid; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
public int InsertAppointmentDetails(BO_AppointmentDetails DataObjectAppointmentDetails) { int insertedAppointmentDetailsId = -1; string query = "insert into patient_history(patient_id,appointment_id,doctor_id,procedure_id,date_created,created_by,paid) output INSERTED.PATIENT_HISTORY_ID values (@patient_id,@appointment_id,@doctor_id,@procedure_id,@date_created,@created_by,@paid)"; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Add("@patient_id", SqlDbType.Int, 10, "patient_id"); cmd.Parameters["@patient_id"].Value = DataObjectAppointmentDetails.Patientid; cmd.Parameters.Add("@appointment_id", SqlDbType.Int, 10, "appointment_id"); cmd.Parameters["@appointment_id"].Value = DataObjectAppointmentDetails.Appointmentid; cmd.Parameters.Add("@doctor_id", SqlDbType.Int, 10, "doctor_id"); cmd.Parameters["@doctor_id"].Value = DataObjectAppointmentDetails.Doctorid; cmd.Parameters.Add("@procedure_id", SqlDbType.Int, 10, "procedure_id"); cmd.Parameters["@procedure_id"].Value = DataObjectAppointmentDetails.Procedureid; cmd.Parameters.Add("@date_created", SqlDbType.DateTime, 12, "date_created"); cmd.Parameters["@date_created"].Value = DataObjectAppointmentDetails.Datecreated; cmd.Parameters.Add("@created_by", SqlDbType.Int, 10, "created_by"); cmd.Parameters["@created_by"].Value = DataObjectAppointmentDetails.Createdby; cmd.Parameters.Add("@paid", SqlDbType.VarChar, 1, "paid"); cmd.Parameters["@paid"].Value = DataObjectAppointmentDetails.Paid; insertedAppointmentDetailsId = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Dispose(); con.Close(); return(insertedAppointmentDetailsId); }
public void DeleteAppointmentDetails(BO_AppointmentDetails DataObjectAppointmentDetails) { string query = "delete from patient_history where appointment_id=@appointment_id"; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Add("@appointment_id", SqlDbType.Int, 10, "appointment_id"); cmd.Parameters["@appointment_id"].Value = DataObjectAppointmentDetails.Appointmentid; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
public void DeleteAppointment(BO_Appointment DataObjectAppointment) { #region APPOINTMENT_DETAILS boAppointmentDetails = new BO_AppointmentDetails(); boAppointmentDetails.Appointmentid = DataObjectAppointment.Appointmentid; daAppointmentDetails.DeleteAppointmentDetails(boAppointmentDetails); #endregion string query = "delete from appointment where appointment_id=@appointment_id"; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Add("@appointment_id", SqlDbType.Int, 20, "appointment_id"); cmd.Parameters["@appointment_id"].Value = DataObjectAppointment.Appointmentid; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
public int InsertAppointment(BO_Appointment[] DataObjectAppointment) { int insertedAppointmentId = -1; string query = "insert into appointment(patient_id,doctor_id,appointment_date,appointment_time,date_created,created_by) output INSERTED.APPOINTMENT_ID values (@patient_id,@doctor_id,@appointment_date,@appointment_time,@date_created,@created_by)"; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Add("@patient_id", SqlDbType.Int, 10, "patient_id"); cmd.Parameters["@patient_id"].Value = DataObjectAppointment[0].Patientid; cmd.Parameters.Add("@doctor_id", SqlDbType.Int, 10, "doctor_id"); cmd.Parameters["@doctor_id"].Value = DataObjectAppointment[0].Doctorid; cmd.Parameters.Add("@appointment_date", SqlDbType.DateTime, 12, "appointment_date"); cmd.Parameters["@appointment_date"].Value = DataObjectAppointment[0].Appointmentdate; cmd.Parameters.Add("@appointment_time", SqlDbType.VarChar, 12, "appointment_time"); cmd.Parameters["@appointment_time"].Value = DataObjectAppointment[0].Appointmenttime; cmd.Parameters.Add("@date_created", SqlDbType.DateTime, 12, "date_created"); cmd.Parameters["@date_created"].Value = DataObjectAppointment[0].Datecreated; cmd.Parameters.Add("@created_by", SqlDbType.Int, 10, "created_by"); cmd.Parameters["@created_by"].Value = DataObjectAppointment[0].Createdby; insertedAppointmentId = Convert.ToInt32(cmd.ExecuteScalar()); if (insertedAppointmentId > 0) { for (int i = 0; i < DataObjectAppointment.Length; i++) { boAppointmentDetails = new BO_AppointmentDetails(); boAppointmentDetails.Patientid = DataObjectAppointment[i].Patientid; boAppointmentDetails.Appointmentid = insertedAppointmentId; boAppointmentDetails.Doctorid = DataObjectAppointment[i].Doctorid; boAppointmentDetails.Procedureid = DataObjectAppointment[i].Procedureid; boAppointmentDetails.Createdby = DataObjectAppointment[i].Createdby; boAppointmentDetails.Datecreated = System.DateTime.Now; boAppointmentDetails.Paid = DataObjectAppointment[i].Paid; int insertedAppointmentDeatils = daAppointmentDetails.InsertAppointmentDetails(boAppointmentDetails); } } cmd.Dispose(); con.Close(); return(insertedAppointmentId); }
public int UpdateAppointment(BO_Appointment[] DataObjectAppointment) { int updatedAppointmentId = -1; string query = "update appointment set patient_id=@patient_id,doctor_id=@doctor_id,appointment_date=@appointment_date,appointment_time=@appointment_time,date_modified=@date_modified,modified_by=@modified_by where appointment_id=@appointment_id"; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Add("@appointment_id", SqlDbType.Int, 10, "appointment_id"); cmd.Parameters["@appointment_id"].Value = DataObjectAppointment[0].Appointmentid; cmd.Parameters.Add("@patient_id", SqlDbType.Int, 10, "patient_id"); cmd.Parameters["@patient_id"].Value = DataObjectAppointment[0].Patientid; cmd.Parameters.Add("@doctor_id", SqlDbType.Int, 10, "doctor_id"); cmd.Parameters["@doctor_id"].Value = DataObjectAppointment[0].Doctorid; cmd.Parameters.Add("@appointment_date", SqlDbType.DateTime, 12, "appointment_date"); cmd.Parameters["@appointment_date"].Value = DataObjectAppointment[0].Appointmentdate; cmd.Parameters.Add("@appointment_time", SqlDbType.VarChar, 12, "appointment_time"); cmd.Parameters["@appointment_time"].Value = DataObjectAppointment[0].Appointmenttime; cmd.Parameters.Add("@date_modified", SqlDbType.DateTime, 12, "date_modified"); cmd.Parameters["@date_modified"].Value = DataObjectAppointment[0].Datemodified; cmd.Parameters.Add("@modified_by", SqlDbType.Int, 10, "modified_by"); cmd.Parameters["@modified_by"].Value = DataObjectAppointment[0].Modifiedby; cmd.ExecuteNonQuery(); updatedAppointmentId = Convert.ToInt32(DataObjectAppointment[0].Appointmentid); if (updatedAppointmentId > 0) { DataTable dtAppointmentDetails = daAppointmentDetails.GetAppointmentDetails(updatedAppointmentId); dtAppointmentDetails.Columns.Add("ACTION", typeof(System.String)); foreach (DataRow row in dtAppointmentDetails.Rows) { row["ACTION"] = "DELETE"; } for (int i = 0; i < DataObjectAppointment.Length; i++) { string expression = "PROCEDURE_ID=" + DataObjectAppointment[i].Procedureid; DataRow[] foundRows; foundRows = dtAppointmentDetails.Select(expression); if (foundRows.Length > 0) { foundRows[0]["PATIENT_HISTORY_ID"] = foundRows[0]["PATIENT_HISTORY_ID"]; foundRows[0]["PATIENT_ID"] = DataObjectAppointment[i].Patientid; foundRows[0]["APPOINTMENT_ID"] = DataObjectAppointment[i].Appointmentid; foundRows[0]["DOCTOR_ID"] = DataObjectAppointment[i].Doctorid; foundRows[0]["PROCEDURE_ID"] = DataObjectAppointment[i].Procedureid; foundRows[0]["DATE_CREATED"] = foundRows[0]["DATE_CREATED"]; foundRows[0]["CREATED_BY"] = foundRows[0]["CREATED_BY"]; foundRows[0]["DATE_MODIFIED"] = DataObjectAppointment[i].Datemodified; foundRows[0]["MODIFIED_BY"] = DataObjectAppointment[i].Modifiedby; foundRows[0]["PAID"] = DataObjectAppointment[i].Paid; foundRows[0]["ACTION"] = "UPDATE"; } else { DataRow dr = dtAppointmentDetails.NewRow(); dr["PATIENT_HISTORY_ID"] = 0; dr["PATIENT_ID"] = DataObjectAppointment[i].Patientid; dr["APPOINTMENT_ID"] = DataObjectAppointment[i].Appointmentid; dr["DOCTOR_ID"] = DataObjectAppointment[i].Doctorid; dr["PROCEDURE_ID"] = DataObjectAppointment[i].Procedureid; dr["DATE_CREATED"] = System.DateTime.Now; dr["CREATED_BY"] = DataObjectAppointment[i].Modifiedby; dr["DATE_MODIFIED"] = System.DateTime.Now; dr["MODIFIED_BY"] = DataObjectAppointment[i].Modifiedby; dr["PAID"] = DataObjectAppointment[i].Paid; dr["ACTION"] = "INSERT"; dtAppointmentDetails.Rows.Add(dr); dtAppointmentDetails.AcceptChanges(); } } for (int j = 0; j < dtAppointmentDetails.Rows.Count; j++) { if (dtAppointmentDetails.Rows[j]["ACTION"].ToString().ToUpper() == "UPDATE") { boAppointmentDetails = new BO_AppointmentDetails(); boAppointmentDetails.Patienthistoryid = Convert.ToInt64(dtAppointmentDetails.Rows[j]["PATIENT_HISTORY_ID"]); boAppointmentDetails.Patientid = Convert.ToInt64(dtAppointmentDetails.Rows[j]["PATIENT_ID"]); boAppointmentDetails.Appointmentid = Convert.ToInt64(dtAppointmentDetails.Rows[j]["APPOINTMENT_ID"]); boAppointmentDetails.Doctorid = Convert.ToInt64(dtAppointmentDetails.Rows[j]["DOCTOR_ID"]); boAppointmentDetails.Procedureid = Convert.ToInt64(dtAppointmentDetails.Rows[j]["PROCEDURE_ID"]); boAppointmentDetails.Modifiedby = Convert.ToInt64(dtAppointmentDetails.Rows[j]["MODIFIED_BY"]); boAppointmentDetails.Datemodified = System.DateTime.Now; boAppointmentDetails.Paid = dtAppointmentDetails.Rows[j]["PAID"].ToString(); daAppointmentDetails.UpdateAppointmentDetails(boAppointmentDetails); } else if (dtAppointmentDetails.Rows[j]["ACTION"].ToString().ToUpper() == "INSERT") { boAppointmentDetails = new BO_AppointmentDetails(); boAppointmentDetails.Patientid = Convert.ToInt64(dtAppointmentDetails.Rows[j]["PATIENT_ID"]); boAppointmentDetails.Appointmentid = Convert.ToInt64(dtAppointmentDetails.Rows[j]["APPOINTMENT_ID"]); boAppointmentDetails.Doctorid = Convert.ToInt64(dtAppointmentDetails.Rows[j]["DOCTOR_ID"]); boAppointmentDetails.Procedureid = Convert.ToInt64(dtAppointmentDetails.Rows[j]["PROCEDURE_ID"]); boAppointmentDetails.Createdby = Convert.ToInt64(dtAppointmentDetails.Rows[j]["CREATED_BY"]); boAppointmentDetails.Datecreated = System.DateTime.Now; boAppointmentDetails.Paid = dtAppointmentDetails.Rows[j]["PAID"].ToString(); int insertedAppointmentDeatils = daAppointmentDetails.InsertAppointmentDetails(boAppointmentDetails); } else { boAppointmentDetails = new BO_AppointmentDetails(); boAppointmentDetails.Patienthistoryid = Convert.ToInt64(dtAppointmentDetails.Rows[j]["PATIENT_HISTORY_ID"]); daAppointmentDetails.DeleteAppointmentDetails(boAppointmentDetails); } } } cmd.Dispose(); con.Close(); return(updatedAppointmentId); }