/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void InsertEvaluationByGroup(object sender, DirectEventArgs e)
{
try
{
if (!string.IsNullOrEmpty(hdfGroupFilter.Text))
{
var criterionModels = CriterionController.GetAll(null, Convert.ToInt32(hdfGroupFilter.Text), false,
KpiStatus.Active, null, null, null);
//create new all employee
var records = RecordController.GetAll(null, null, DepartmentIds, RecordType.Default, null, null);
foreach (var criterion in criterionModels)
{
foreach (var item in records)
{
var model = new EvaluationModel()
{
RecordId = item.Id,
CriterionId = criterion.Id,
Month = DateTime.Now.Month,
Year = DateTime.Now.Year,
Value = ""
};
//get value
GetValueCriterionWorkbook(model, criterion, Convert.ToInt32(hdfGroupFilter.Text));
//check exist
var evaluation = EvaluationController.CheckExist(model.RecordId, model.CriterionId, model.Month, model.Year);
if (evaluation != null)
{
model.Id = evaluation.Id;
//update
EvaluationController.Update(model);
}
else
{
//create
EvaluationController.Create(model);
}
}
}
//hide window
wdEvaluation.Hide();
// reload grid
gpEvaluation.Reload();
}
}
catch (Exception exception)
{
Dialog.ShowError(exception);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EvaluationClick(object sender, DirectEventArgs e)
{
try
{
if (!string.IsNullOrEmpty(hdfId.Text))
{
//create new all employee
var records = RecordController.GetAll(null, null, DepartmentIds, RecordType.Default, null, null);
var criterion = CriterionController.GetById(Convert.ToInt32(hdfId.Text));
foreach (var item in records)
{
var model = new EvaluationModel()
{
RecordId = item.Id,
CriterionId = Convert.ToInt32(hdfId.Text),
Month = DateTime.Now.Month,
Year = DateTime.Now.Year,
Value = ""
};
//get value
GetValueCriterionWorkbook(model, criterion, null);
//check exist
var evaluation = EvaluationController.CheckExist(model.RecordId, model.CriterionId, model.Month, model.Year);
if (evaluation != null)
{
model.Id = evaluation.Id;
//update
EvaluationController.Update(model);
}
else
{
//create
EvaluationController.Create(model);
}
}
}
}
catch (Exception exception)
{
Dialog.ShowError(exception);
}
}
/// <summary>
/// get list employee
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ListEmployee_OnRefreshData(object sender, StoreRefreshDataEventArgs e)
{
var salaryIds = "0";
foreach (var item in chkSelectionModel.SelectedRows)
{
salaryIds += "," + item.RecordID;
}
var salaries = sal_SalaryDecisionServices.GetAll("[Id] IN ({0})".FormatWith(salaryIds.TrimStart(',')));
var recordIds = string.Join(",", salaries.Select(d => d.RecordId));
hdfRecordIds.Text = recordIds;
var listEmployee =
RecordController.GetAll("[Id] IN ({0})".FormatWith(!string.IsNullOrEmpty(recordIds) ? recordIds : "0"));
gridListEmployee_Store.DataSource = listEmployee;
gridListEmployee_Store.DataBind();
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DownloadTemplate_Click(object sender, DirectEventArgs e)
{
// init table
var dataTable = new DataTable();
// adjust table
dataTable.Rows.Add();
dataTable.Columns.Add(new DataColumn(EmployeeCode));
dataTable.Columns.Add(new DataColumn(FullName));
//add argument
var argumentModels = ArgumentController.GetAll(null, false, KpiStatus.Active, null, null, null);
foreach (var argument in argumentModels)
{
dataTable.Columns.Add(new DataColumn(argument.Name));
}
// get record by department
var departmentIds = DepartmentIds;
if (!string.IsNullOrEmpty(hdfDepartmentId.Text))
{
departmentIds = hdfDepartmentId.Text;
}
var records = RecordController.GetAll(null, null, departmentIds, RecordType.Default, null, null);
// fill employee name and code
for (var i = 0; i < records.Count; i++)
{
dataTable.Rows.Add();
dataTable.Rows[i][EmployeeCode] = records[i].EmployeeCode;
dataTable.Rows[i][FullName] = records[i].FullName;
}
ExportToExcel(dataTable, "~/" + Constant.PathTemplate, ImportEmployeeArgumentExcelFile);
}
private void GenerateNhanSuTheoDonVi(int height)
{
try
{
hcFrutas.Title = new Title(@"Thống kê theo đơn vị");
hcFrutas.Height = height;
//Danh sách giới tinh theo đơn vị
var lstDepartment = CurrentUser.Departments.Where(d => d.IsLocked == false).ToList();
var lstRecord = RecordController.GetAll(string.Empty);
var lstLabel = new object[lstDepartment.Count];
var lstMale = new object[lstDepartment.Count];
var lstFemale = new object[lstDepartment.Count];
for (var i = 0; i < lstDepartment.Count; i++)
{
var countOfMale = lstRecord.Where(hr => hr.DepartmentId == lstDepartment[i].Id && hr.Sex == true).Count();
var countOfFemale = lstRecord.Where(hr => hr.DepartmentId == lstDepartment[i].Id && hr.Sex == false).Count();
lstLabel[i] = lstDepartment[i].Name;
lstMale[i] = countOfMale;
lstFemale[i] = countOfFemale;
}
//definições de eixos
hcFrutas.YAxis.Add(new YAxisItem {
title = new Title("Số lượng")
});
hcFrutas.XAxis.Add(new XAxisItem {
categories = lstLabel
});
//dados
var series = new Collection <Serie>
{
new Serie {
name = "Nam", data = lstMale
},
new Serie {
name = "Nữ", data = lstFemale
}
};
hcFrutas.PlotOptions = new PlotOptionsColumn()
{
borderColor = "#dedede",
borderRadius = 4,
dataLabels = new DataLabels()
{
enabled = true,
},
};
hcFrutas.Legend = new Legend()
{
layout = Highcharts.Core.Layout.horizontal,
align = Align.left,
verticalAlign = Highcharts.Core.VerticalAlign.top,
x = 70,
y = -5,
floating = true,
shadow = true,
backgroundColor = "#FFF",
};
hcFrutas.Exporting.enabled = true;
hcFrutas.DataSource = series;
hcFrutas.DataBind();
}
catch
{
throw;
}
}
protected void SendEmailHappyBirthday(object sender, DirectEventArgs e)
{
try
{
var selecteds = RowSelectionModel3.SelectedRows;
var mailto = string.Empty;
var error = "";
//var dt = DataController.DataHandler.GetInstance().ExecuteDataTable("sp_GetAllEmailHappyBirthDayMonth");
var condition = " [BirthDate] IS NOT NULL AND MONTH([BirthDate])='{0}'".FormatWith(DateTime.Now.Month) +
" AND [WorkStatusId] = (SELECT TOP 1 Id FROM cat_WorkStatus WHERE [Name] LIKE N'%Đang làm việc%')";
var dt = RecordController.GetAll(condition);
if (e.ExtraParams["All"] == "True")
{
foreach (var record in dt)
{
if (!string.IsNullOrEmpty(record.WorkEmail))
{
mailto += record.WorkEmail + ", ";
}
else if (!string.IsNullOrEmpty(record.PersonalEmail))
{
mailto += record.PersonalEmail + ", ";
}
else
{
error += record.FullName + " ";
}
}
}
else
{
foreach (var item in selecteds)
{
var maCb = item.RecordID;
foreach (var record in dt)
{
if (record.EmployeeCode != maCb)
{
continue;
}
if (!string.IsNullOrEmpty(record.WorkEmail))
{
mailto += record.WorkEmail + ", ";
}
else if (!string.IsNullOrEmpty(record.PersonalEmail))
{
mailto += record.PersonalEmail + ", ";
}
else
{
Dialog.ShowError("Không tìm thấy email");
return;
}
}
}
}
var mail = "";
for (var i = 0; i < mailto.Length - 2; i++)
{
mail += mailto[i];
}
//SystemController htController = new SystemController();
//SendMail1.SetEmailTo(htController.GetValueByName(SystemConfigParameter.EMAIL, Session["MaDonVi"].ToString()), htController.GetValueByName(SystemConfigParameter.PASSWORD_EMAIL, Session["MaDonVi"].ToString()), mail);
//SendMail1.Show();
if (!string.IsNullOrEmpty(error.Trim()))
{
Dialog.ShowError("Một số cán bộ không có email :" + error);
}
}
catch (Exception ex)
{
Dialog.ShowError("Lỗi xảy ra " + ex.Message);
}
}
