/// <summary>
///
/// </summary>
private void DisplayTotalBirthInMonth()
{
var firstDayOfMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); // get start of month
var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); // last day of month
// count birth in month
var totalBirdInMonth = SQLHelper
.ExecuteTable(SQLManagementAdapter.GetStore_BirthdayOfEmployee(DepartmentIds, firstDayOfMonth, lastDayOfMonth, null, null)).Rows.Count;
pnlSinhNhatNhanVien.Title += @" <b id='pSinhNhatNhanVien' style='color:red;'>(" + totalBirdInMonth + @" cán bộ)</b>";
}
public void BindData()
{
try
{
var firstDayOfMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); // get start of month
var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); // last day of month
// from date
var fromDate = _filter.StartDate != null ? _filter.StartDate.Value : firstDayOfMonth;
// to date
var toDate = _filter.EndDate != null ? _filter.EndDate.Value : lastDayOfMonth;
// select form db
string departmentIds = string.Join(",", _filter.Departments.Split(
new[] { "," }, StringSplitOptions.RemoveEmptyEntries).Select(d => "'{0}'".FormatWith(d)));
var table = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_BirthdayOfEmployee(departmentIds, fromDate, toDate, null, null));
DataSource = table;
//binding data
xrCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode");
xrCellFullName.DataBindings.Add("Text", DataSource, "FullName");
xrCellPosition.DataBindings.Add("Text", DataSource, "PositionName");
xrCellPosition.DataBindings.Add("Text", DataSource, "PositionName");
xrCellDepartment.DataBindings.Add("Text", DataSource, "DepartmentName");
xrCellBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}");
xrCellAge.DataBindings.Add("Text", DataSource, "Age");
GroupHeader1.GroupFields.AddRange(new[] {
new GroupField("DepartmentId", XRColumnSortOrder.Ascending)
});
xrt_GroupDepartment.DataBindings.Add("Text", DataSource, "DepartmentName");
// other items
// label report title
if (!string.IsNullOrEmpty(_filter.ReportTitle))
{
lblReportTitle.Text = _filter.ReportTitle;
}
// lablel duration
if (_filter.StartDate != null && _filter.EndDate != null)
{
lblDuration.Text = lblDuration.Text.FormatWith(_filter.StartDate.Value.ToString("dd/MM/yyyy"),
_filter.EndDate.Value.ToString("dd/MM/yyyy"));
}
else
{
lblDuration.Text = string.Empty;
}
// label report date
lblReportDate.Text = lblReportDate.Text.FormatWith(_filter.ReportDate.Day, _filter.ReportDate.Month, _filter.ReportDate.Year);
// created by
if (!string.IsNullOrEmpty(_filter.CreatedByTitle))
{
lblCreatedByTitle.Text = _filter.CreatedByTitle;
}
if (!string.IsNullOrEmpty(_filter.CreatedByName))
{
lblCreatedByName.Text = _filter.CreatedByName;
}
// reviewed by
//if(!string.IsNullOrEmpty(_filter.ReviewedByTitle)) lblReviewedByTitle.Text = _filter.ReviewedByTitle;
//if(!string.IsNullOrEmpty(_filter.ReviewedByName)) lblReviewedByName.Text = _filter.ReviewedByName;
// signed by
if (!string.IsNullOrEmpty(_filter.SignedByTitle))
{
lblSignedByTitle.Text = _filter.SignedByTitle;
}
if (!string.IsNullOrEmpty(_filter.SignedByName))
{
lblSignedByName.Text = _filter.SignedByName;
}
}
catch (Exception ex)
{
Dialog.ShowError(ex);
}
}
public void DirectLogin()
{
try
{
// init return message
var message = string.Empty;
// init user model
var userModel = new UserModel
{
// authenticate
User = UserServices.Authenticate(txtUserName.Text.Trim(), txtPassword.Text, ref message)
};
// check user login
if (userModel.User == null)
{
// login fail
ExtNet.MessageBox.Alert("Login Fail", message).Show();
return;
}
// check departments
if (userModel.Departments.Count > 0)
{
// set current user
Session["CurrentUser"] = userModel;
//
if (userModel.User != null)
{
// check u
//lấy danh sách các bộ phận được truy cập tìm cán bộ sinh nhật trong tháng
var listDepartmentId = string.Join(",", userModel.Departments.Select(d => d.Id));
var objCountContract =
SQLHelper.ExecuteTable(
SQLManagementAdapter.GetStore_DanhSachNhanVienSapHetHopDong(null, null, 30, listDepartmentId)).Rows.Count;
// Danh sách sinh nhật trong tháng
var firstDayOfMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); // get start of month
var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); // last day of month
var tableBirthInMonth = SQLHelper
.ExecuteTable(SQLManagementAdapter.GetStore_BirthdayOfEmployee(listDepartmentId, firstDayOfMonth, lastDayOfMonth, null, null)).Rows.Count;
// Danh sách nhân viên đến kì nghỉ hưu
var tableRetirement = SQLHelper
.ExecuteTable(SQLManagementAdapter.GetStore_RetirementOfEmployee(null, null, listDepartmentId));
var countRetirement = 0;
var newEmployeeCode = string.Empty;
for (var i = 0; i < tableRetirement.Rows.Count; i++)
{
var currentEmployeeCode = (string)tableRetirement.Rows[i]["EmployeeCode"];
if (currentEmployeeCode != newEmployeeCode)
{
countRetirement++;
newEmployeeCode = currentEmployeeCode;
}
}
// Danh sách nhân viên được nâng lương
var tableListSalaryRaise =
SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ListSalaryRaise(listDepartmentId,
"1900-01-01", DateTime.Now.ToString("MM/dd/yyyy"), null, null, (int)SalaryDecisionType.Regular, null, null)).Rows.Count;
var tableOutFrameSalary =
SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ListSalaryRaise(listDepartmentId, null, null, null, null, (int)SalaryDecisionType.OverGrade, null, null)).Rows.Count;
Session["DataHomePage"] = tableBirthInMonth + ";" + objCountContract + ";" + countRetirement + ";" + tableListSalaryRaise + ";" + tableOutFrameSalary;
}
else
{
RM.RegisterClientScriptBlock("al", "Ext.Msg.alert('Lỗi đăng nhập', 'Có lỗi xảy ra trong quá trình đăng nhập');");
}
// redirect home page
Response.Redirect("~/Default.aspx");
}
else
{
// alert error message
ExtNet.MessageBox.Alert("No Department", "Người dùng chưa được cấp quyền với bất kỳ đơn vị nào.").Show();
// redirect login page
Response.Redirect("~/Login.aspx");
}
}
catch (Exception ex)
{
ExtNet.MessageBox.Alert("Exception", ex.Message).Show();
}
}