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 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;
//}
public List<KendoEntity> GetProfessionalMonthlyAppointments(int companyid, int professionalId, int Year, int customerId)
{
ProfessionalSchedule professionalSchedule = null;
List<KendoEntity> lst = new List<KendoEntity>();
using (var conn = new SqlConnection(PrescienceRxConnectionString))
{
conn.Open();
using (var cmd = new SqlCommand(GetProfessionalScheduleSp, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@ProfessionalId", SqlDbType.Int);
cmd.Parameters["@ProfessionalId"].Value = professionalId;
cmd.Parameters.Add("@CompanyId", SqlDbType.Int);
cmd.Parameters["@CompanyId"].Value = companyid;
cmd.Parameters.Add("@Year", SqlDbType.Int);
cmd.Parameters["@Year"].Value = Year;
cmd.Parameters.Add("@CustomerId", SqlDbType.Int);
cmd.Parameters["@CustomerId"].Value = customerId;
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;
}