protected void Page_Init(object sender, EventArgs e)
{
if (_webPart != null)
{
_sNoProfileImageFile = _webPart.NoProfileImageFile;
_bShowRefreshShowAll = _webPart.EnableRefreshShowAll;
_sConnectionString = _webPart.OTConnectionString;
_sConnectionStringPhoto = _webPart.PhotoConnectionString;
_dataListRow[(int)dataListRowNames.rowPhoto].Visible = _webPart.ShowColumnPhoto;
_dataListRow[(int)dataListRowNames.rowName].Visible = _webPart.ShowColumnName;
_dataListRow[(int)dataListRowNames.rowJobTitle].Visible = _webPart.ShowColumnJob;
_dataListRow[(int)dataListRowNames.rowDepartment].Visible = _webPart.ShowColumnDepartment;
_dataListRow[(int)dataListRowNames.rowBirthday].Visible = _webPart.ShowColumnDOB;
_dataListRow[(int)dataListRowNames.rowPhoneWork].Visible = _webPart.ShowColumnPhoneWork;
_dataListRow[(int)dataListRowNames.rowPhoneMobile].Visible = _webPart.ShowColumnPhoneMobile;
_dataListRow[(int)dataListRowNames.rowEmail].Visible = _webPart.ShowColumnEmail;
_dataListRow[(int)dataListRowNames.rowCity].Visible = _webPart.ShowColumnCity;
_bEnableDetails = _webPart.ShowDetailsPopup;
_bShowDetailsName = _webPart.ShowDetailsName;
_bShowDetailsJobTitle = _webPart.ShowDetailsJobTitle;
_bShowDetailsDepartment = _webPart.ShowDetailsDepartment;
_bShowDetailsDob = _webPart.ShowDetailsDOB;
_bShowDetailsWPhone = _webPart.ShowDetailsPhoneWork;
_bShowDetailsMhone = _webPart.ShowDetailsPhoneMobile;
_bShowDetailsEmail = _webPart.ShowDetailsEmail;
_bShowDetailsCity = _webPart.ShowColumnCity;
_recordNumber = _webPart.NumberOfRecords;
_columnNumber = _webPart.NumberOfColumns;
_recordSelectionType = _webPart.SelectionType;
_bGetNewEmployeesOnly = _webPart.ShowNewEmployeesOnly;
_nNewEmployeeDays = _webPart.NewEmployeesDays;
_bGetEmployeesWithBirthdayOnly = _webPart.ShowWhosBirthdayOnly;
if (_bGetEmployeesWithBirthdayOnly)
{
DateTime now = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
DayOfWeek day = now.DayOfWeek;
int days = day - DayOfWeek.Monday;
if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.Today)
{
_tableEmployees.FilterDOBMinDT = now;
_tableEmployees.FilterDOBMax = null;
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.Yesterday)
{
_tableEmployees.FilterDOBMinDT = now.AddDays(-1);
_tableEmployees.FilterDOBMax = null;
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.Tomorrow)
{
_tableEmployees.FilterDOBMinDT = now.AddDays(1);
_tableEmployees.FilterDOBMax = null;
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.ThisWeek)
{
_tableEmployees.FilterDOBMinDT = DateTime.Now.AddDays(-days);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddDays(6);
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.LastWeek)
{
_tableEmployees.FilterDOBMinDT = DateTime.Now.AddDays(-days - 7);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddDays(6);
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.NextWeek)
{
_tableEmployees.FilterDOBMinDT = DateTime.Now.AddDays(-days + 7);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddDays(6);
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.ThisMonth)
{
_tableEmployees.FilterDOBMinDT = new DateTime(now.Year, now.Month, 1);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddMonths(1).AddDays(-1);
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.LastMonth)
{
_tableEmployees.FilterDOBMinDT = new DateTime(now.Year, now.Month, 1).AddMonths(-1);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddMonths(1).AddDays(-1);
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.NextMonth)
{
_tableEmployees.FilterDOBMinDT = new DateTime(now.Year, now.Month, 1).AddMonths(1);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddMonths(1).AddDays(-1);
}
}
else if (_bGetNewEmployeesOnly)
{
DateTime now = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
_tableEmployees.FilterDOBMin = null;
_tableEmployees.FilterDOBMax = null;
_tableEmployees.FilterEmployedMaxDT = now;
_tableEmployees.FilterEmployedMinDT = now.AddDays(-_nNewEmployeeDays);
}
}
// Create connection to the DB
try
{
_connectionDb = new System.Data.SqlClient.SqlConnection(_sConnectionString);
_connectionDb.Open();
}
catch (Exception ex)
{
ShowErrorMessage("The error was occured while open connection to the database:<br/>" +
ex.Message);
}
}
protected void Page_Init(object sender, EventArgs e)
{
if (_webPart != null)
{
_sNoProfileImageFile = _webPart.NoProfileImageFile;
_bShowRefreshShowAll = _webPart.EnableRefreshShowAll;
_sConnectionString = _webPart.OTConnectionString;
_sConnectionStringPhoto = _webPart.PhotoConnectionString;
_dataListRow[(int)dataListRowNames.rowPhoto].Visible = _webPart.ShowColumnPhoto;
_dataListRow[(int)dataListRowNames.rowName].Visible = _webPart.ShowColumnName;
_dataListRow[(int)dataListRowNames.rowJobTitle].Visible = _webPart.ShowColumnJob;
_dataListRow[(int)dataListRowNames.rowDepartment].Visible = _webPart.ShowColumnDepartment;
_dataListRow[(int)dataListRowNames.rowBirthday].Visible = _webPart.ShowColumnDOB;
_dataListRow[(int)dataListRowNames.rowPhoneWork].Visible = _webPart.ShowColumnPhoneWork;
_dataListRow[(int)dataListRowNames.rowPhoneMobile].Visible = _webPart.ShowColumnPhoneMobile;
_dataListRow[(int)dataListRowNames.rowEmail].Visible = _webPart.ShowColumnEmail;
_dataListRow[(int)dataListRowNames.rowCity].Visible = _webPart.ShowColumnCity;
_bEnableDetails = _webPart.ShowDetailsPopup;
_bShowDetailsName = _webPart.ShowDetailsName;
_bShowDetailsJobTitle = _webPart.ShowDetailsJobTitle;
_bShowDetailsDepartment = _webPart.ShowDetailsDepartment;
_bShowDetailsDob = _webPart.ShowDetailsDOB;
_bShowDetailsWPhone = _webPart.ShowDetailsPhoneWork;
_bShowDetailsMhone = _webPart.ShowDetailsPhoneMobile;
_bShowDetailsEmail = _webPart.ShowDetailsEmail;
_bShowDetailsCity = _webPart.ShowColumnCity;
_recordNumber = _webPart.NumberOfRecords;
_columnNumber = _webPart.NumberOfColumns;
_recordSelectionType = _webPart.SelectionType;
_bGetNewEmployeesOnly = _webPart.ShowNewEmployeesOnly;
_nNewEmployeeDays = _webPart.NewEmployeesDays;
_bGetEmployeesWithBirthdayOnly = _webPart.ShowWhosBirthdayOnly;
if (_bGetEmployeesWithBirthdayOnly)
{
DateTime now = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
DayOfWeek day = now.DayOfWeek;
int days = day - DayOfWeek.Monday;
if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.Today)
{
_tableEmployees.FilterDOBMinDT = now;
_tableEmployees.FilterDOBMax = null;
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.Yesterday)
{
_tableEmployees.FilterDOBMinDT = now.AddDays(-1);
_tableEmployees.FilterDOBMax = null;
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.Tomorrow)
{
_tableEmployees.FilterDOBMinDT = now.AddDays(1);
_tableEmployees.FilterDOBMax = null;
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.ThisWeek)
{
_tableEmployees.FilterDOBMinDT = DateTime.Now.AddDays(-days);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddDays(6);
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.LastWeek)
{
_tableEmployees.FilterDOBMinDT = DateTime.Now.AddDays(-days - 7);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddDays(6);
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.NextWeek)
{
_tableEmployees.FilterDOBMinDT = DateTime.Now.AddDays(-days + 7);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddDays(6);
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.ThisMonth)
{
_tableEmployees.FilterDOBMinDT = new DateTime(now.Year, now.Month, 1);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddMonths(1).AddDays(-1);
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.LastMonth)
{
_tableEmployees.FilterDOBMinDT = new DateTime(now.Year, now.Month, 1).AddMonths(-1);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddMonths(1).AddDays(-1);
}
else if (_webPart.BirthdayTimeframe == EmployeeList.Timeframe.NextMonth)
{
_tableEmployees.FilterDOBMinDT = new DateTime(now.Year, now.Month, 1).AddMonths(1);
_tableEmployees.FilterDOBMaxDT = _tableEmployees.FilterDOBMinDT.AddMonths(1).AddDays(-1);
}
}
else if (_bGetNewEmployeesOnly)
{
DateTime now = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
_tableEmployees.FilterDOBMin = null;
_tableEmployees.FilterDOBMax = null;
_tableEmployees.FilterEmployedMaxDT = now;
_tableEmployees.FilterEmployedMinDT = now.AddDays(-_nNewEmployeeDays);
}
}
// Create connection to the DB
try
{
_connectionDb = new System.Data.SqlClient.SqlConnection(_sConnectionString);
_connectionDb.Open();
}
catch (Exception ex)
{
ShowErrorMessage("The error was occured while open connection to the database:<br/>" +
ex.Message);
}
}
