public static WeekDays GetWeekDay(int CourseID, int SemesterID, string Session, int FillBy)
{
WeekDays WC = new WeekDays();
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
objDB.CreateParameters(4);
objDB.AddParameters(0, "CourseID", CourseID, DbType.Int32);
objDB.AddParameters(1, "Session", Session, DbType.String);
objDB.AddParameters(2, "SemesterID", SemesterID, DbType.Int32);
objDB.AddParameters(3, "FillBy", FillBy, DbType.Int32);
SqlDataReader dr = (SqlDataReader)objDB.ExecuteReader(CommandType.StoredProcedure, "FillWeek");
while (dr.Read())
{
TimeTableDM.WeekDayFill week = new TimeTableDM.WeekDayFill();
week.Date = Education.DataHelper.GetDateTime(dr, "Date");
WC.Add(week);
}
objDB.DataReader.Close();
objDB.Connection.Close();
return(WC);
}
/// <summary>
/// <paramref name="dayOfWeeks"/>를 WorkingDay에 추가합니다.
/// </summary>
/// <param name="dayOfWeeks"></param>
protected virtual void AddWeekDays(params DayOfWeek[] dayOfWeeks)
{
if (dayOfWeeks != null)
{
dayOfWeeks.RunEach(dow => WeekDays.Add(dow));
}
}
} // Calendar
// ----------------------------------------------------------------------
public void AddWorkingWeekDays()
{
WeekDays.Add(DayOfWeek.Monday);
WeekDays.Add(DayOfWeek.Tuesday);
WeekDays.Add(DayOfWeek.Wednesday);
WeekDays.Add(DayOfWeek.Thursday);
WeekDays.Add(DayOfWeek.Friday);
} // AddWorkingWeekDays
private void SelectedWeekDays_CollectionChanged(object sender, NotifyCollectionChangedEventArgs e)
{
WeekDays?.Clear();
foreach (var x in SelectedWeekItems)
{
var y = (KeyValuePair <string, string>)x;
WeekDays.Add(y.Key, y.Value);
}
}
private void LoadWeeks()
{
WeekDays.Clear();
var startDate = _initWeekStart.AddDays(Index * 7);
var endDate = _schoolYearSettings.YearEnd;
var dateToAdd = startDate;
while (dateToAdd <= endDate)
{
var day = new Day()
{
Date = dateToAdd, OrderProductType = ProductType, OrderChild = Child
};
day = CheckIfHoliday(day);
day = MarkOrderHistory(day);
WeekDays.Add(day);
dateToAdd = dateToAdd.AddDays(1);
}
}
private void PopulateDays(DateTime date)
{
SetCurrentWeekAndYearNumber(date);
DateTime dt = date.StartOfWeek(DayOfWeek.Monday);
FirstDayDate = dt.ToShortDateString();
var columnHour = new DayScheduleViewModel(this, dt)
{
DayHeaderViewModel = new DayHeaderViewModel()
{
Day = "Ora",
},
ContentBackground = BackgroundColors.gray,
};
foreach (var appointmentViewModel in columnHour.AppointmetList.List)
{
appointmentViewModel.DayVisibility = Visibility.Collapsed;
appointmentViewModel.PatientName = appointmentViewModel.HourId.Hour;
}
WeekDays.Add(columnHour);
for (int i = 0; i < 7; i++)
{
WeekDays.Add(new DayScheduleViewModel(this, dt)
{
DayOfWeek = dt.DayOfWeek.ToString(),
DayHeaderViewModel = new DayHeaderViewModel()
{
Date = dt.Date.ToShortDateString(),
Day = dt.DayOfWeek.ToString(),
}
});
dt = dt.AddDays(1);
}
LastDayDate = dt.AddDays(-1).ToShortDateString();
}
} // AddWorkingWeekDays
// ----------------------------------------------------------------------
public void AddWeekendWeekDays()
{
WeekDays.Add(DayOfWeek.Saturday);
WeekDays.Add(DayOfWeek.Sunday);
} // AddWeekendWeekDays
