public ProfessionalSchedule GetProfessionalSchedule(int professionalSchedulreId) { ProfessionalSchedule professionalSchedule = null; using (var conn = new SqlConnection(PrescienceRxConnectionString)) { conn.Open(); using (var cmd = new SqlCommand(UpdateProfessionalScheduleSp, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@ProfessionalScheduleId", SqlDbType.Int); cmd.Parameters["@ProfessionalScheduleId"].Value = professionalSchedulreId; using (var myReader = cmd.ExecuteReader()) { try { if (myReader.HasRows) { myReader.Read(); professionalSchedule = new ProfessionalSchedule(myReader); } } catch (Exception ex) { // TODO Logg Error here } } } } return(professionalSchedule); }
public bool UpdateProfessionalSchedule(ProfessionalSchedule professionalSchedule) { using (var conn = new SqlConnection(PrescienceRxConnectionString)) { conn.Open(); //TODO: Fix this method using (var cmd = new SqlCommand(UpdateProfessionalScheduleSp, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@ProfessionalScheduleId", SqlDbType.Int).Value = professionalSchedule.ProfessionalScheduleId; cmd.Parameters.Add("@ProfessionalId", SqlDbType.Int).Value = professionalSchedule.ProfessionalId; cmd.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = professionalSchedule.StartTime; cmd.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = professionalSchedule.EndTime; cmd.Parameters.Add("@TimeIntervalMinutes", SqlDbType.Int).Value = professionalSchedule.TimeIntervalMinutes; //TODO: Add this back, these parms missing from sp //cmd.Parameters.Add("@UpdatedBy", SqlDbType.VarChar).Value = professionalSchedule.UpdatedBy; //cmd.Parameters.Add("@DateUpdated", SqlDbType.DateTime).Value = DateTime.UtcNow; return(cmd.ExecuteNonQuery() > 0); } } }
public bool AddProfessionalSchedule(ProfessionalSchedule professionalSchedule) { using (var conn = new SqlConnection(PrescienceRxConnectionString)) { conn.Open(); using (var cmd = new SqlCommand(AddProfessionalScheduleSp, conn)) { //ToDo : Fix this method cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@ProfessionalId", SqlDbType.Int).Value = professionalSchedule.ProfessionalId; cmd.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = professionalSchedule.StartTime; cmd.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = professionalSchedule.EndTime; cmd.Parameters.Add("@TimeIntervalMinutes", SqlDbType.Int).Value = professionalSchedule.TimeIntervalMinutes; //TODO: Add this back, these parms missing from sp //cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = professionalSchedule.CreatedBy; //cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.UtcNow; return(Convert.ToBoolean(cmd.ExecuteScalar())); } } }
public List <KendoEntity> GetProfessionalMonthlyAppointments(int professionalId, int Month, int Year) { ProfessionalSchedule professionalSchedule = null; List <KendoEntity> lst = new List <KendoEntity>(); using (var conn = new SqlConnection(PrescienceRxConnectionString)) { conn.Open(); using (var cmd = new SqlCommand(GetProfessionalMonthlySchedule, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@ProfessionalId", SqlDbType.Int); cmd.Parameters["@ProfessionalId"].Value = professionalId; cmd.Parameters.Add("@Month", SqlDbType.Int); cmd.Parameters["@Month"].Value = Month; cmd.Parameters.Add("@Year", SqlDbType.Int); cmd.Parameters["@Year"].Value = Year; using (var myReader = cmd.ExecuteReader()) { try { if (myReader.HasRows) { while (myReader.Read()) { professionalSchedule = new ProfessionalSchedule(myReader, "Kendo"); lst.Add(professionalSchedule.kendo); } } } catch (Exception ex) { // TODO Logg Error here } } } } return(lst); }
//TODO:Get confirmation. //User the same method to soft delete dont need have another method to softdelete, this method does have IsActive param. public bool PutProfessionalSchedule([FromBody] ProfessionalSchedule proSchedule) { return(professionalRepository.UpdateProfessionalSchedule(proSchedule)); }
public bool PostProfessionalSchedule([FromBody] ProfessionalSchedule proSchedule) { return(professionalRepository.AddProfessionalSchedule(proSchedule)); }