static private SqlCommand CreateSqlCommand(AppointmentImportance appointmentImportance, string commandText) { SqlCommand command = new SqlCommand(commandText); command.Parameters.AddWithValue("@importanceId", appointmentImportance.importanceId); command.Parameters.AddWithValue("@importanceName", appointmentImportance.importanceName); return(command); }
public static AppointmentImportance ToObject(DataRow reader) { AppointmentImportance appointmentImportance = new AppointmentImportance(); appointmentImportance.importanceId = int.Parse(reader[0].ToString()); appointmentImportance.importanceName = reader[1].ToString(); Debug.WriteLine("appointmentImportance: " + appointmentImportance.ToString()); return(appointmentImportance); }
public AppointmentImportance UpdateAppointmentImportance(AppointmentImportance tmpAppointmentImportance) { DataTable dt = new DataTable(); AppointmentImportance appointmentImportance = new AppointmentImportance(); using (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(AppointmentImportanceStrings.UpdateAppointmentImportance(tmpAppointmentImportance)); } foreach (DataRow ms in dt.Rows) { appointmentImportance = AppointmentImportance.ToObject(ms); } return(appointmentImportance); }
public List <AppointmentImportance> GetAllAppointmentImportances() { DataTable dt = new DataTable(); List <AppointmentImportance> arrAppointmentImportances = new List <AppointmentImportance>(); using (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(AppointmentImportanceStrings.GetAllAppointmentImportances()); } foreach (DataRow ms in dt.Rows) { arrAppointmentImportances.Add(AppointmentImportance.ToObject(ms)); } return(arrAppointmentImportances); }
public AppointmentImportance GetOneAppointmentImportance(int appointmentImportanceId) { if (appointmentImportanceId < 0) { throw new ArgumentOutOfRangeException(); } DataTable dt = new DataTable(); AppointmentImportance appointmentImportance = new AppointmentImportance(); using (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(AppointmentImportanceStrings.GetOneAppointmentImportance(appointmentImportanceId)); } foreach (DataRow ms in dt.Rows) { appointmentImportance = AppointmentImportance.ToObject(ms); } return(appointmentImportance); }
static public SqlCommand UpdateAppointmentImportance(AppointmentImportance appointmentImportance) { return(CreateSqlCommand(appointmentImportance, queryAppointmentImportanceUpdate)); }
static public SqlCommand AddAppointmentImportance(AppointmentImportance appointmentImportance) { return(CreateSqlCommand(appointmentImportance, queryAppointmentImportancePost)); }