/// <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); } }