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));
}
