protected void btnExport_Click(object sender, EventArgs e)
{
DataTable dtUsersTemp = new DataTable();
dtUsersTemp.Columns.Add("Bộ phận", typeof(string));
dtUsersTemp.Columns.Add("Họ tên", typeof(string));
dtUsersTemp.Columns.Add("Điểm đánh giá công việc", typeof(string));
dtUsersTemp.Columns.Add("Điểm kỷ luật và văn hóa doanh nghiệp", typeof(string));
dtUsersTemp.Columns.Add("Điểm đồng nghiệp đánh giá", typeof(string));
dtUsersTemp.Columns.Add("Tổng điểm", typeof(string));
//dtUsersTemp.Columns.Add("Xếp loại", typeof(string));
BoPhanInfo _BoPhanInfo = BoPhanController.GetInfo(ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
int loaiTrungTam = _BoPhanInfo.Loai;
string tenTrungTam = ConvertUtility.ToString(dropTrungTam.SelectedItem.Text);
DataTable dtUsers = DotDanhGiaController.GetAllNhanVienInDotDanhGiaExport(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
#region ket qua danh gia checkpoint
foreach (DataRow item in dtUsers.Rows)
{
DataSet ds = DotDanhGiaController.DanhGiaCheckPoint_DGCBCNVDanhGia_TongDiemCongThucMoi(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(item["UserID"]));
if (ds != null)
{
DataRow row = dtUsersTemp.NewRow();
double TongDiemDGCV = 0;
double TongDiemDGCV1 = 0;
double diemKyLuat = 0;
double diemKyLuat1 = 0;
double DiemDongNghiepDanhGia = 0;
double DiemDongNghiepDanhGia1 = 0;
double DiemCLCV = 100;
double DiemTDCV = 100;
if (ds.Tables[0].Rows.Count > 0)
{
DiemCLCV = ConvertUtility.ToDouble(ds.Tables[0].Rows[0]["DiemCLCV"].ToString());
DiemTDCV = ConvertUtility.ToDouble(ds.Tables[0].Rows[0]["DiemTDCV"].ToString());
}
double DiemDGCV = 0;
DataTable dtDotDanhGiaByCheckpoint = DotDanhGiaController.CheckPoint_GetAllDotDanhGiaByCheckpoint(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
int count = 0;
foreach (DataRow itemDotDanhGia in dtDotDanhGiaByCheckpoint.Rows)
{
DataTable dtDiemTB = DotDanhGiaController.CheckPoint_DanhGiaCongViec_GetDiemTB(ConvertUtility.ToInt32(itemDotDanhGia["IDDotDanhGia"]), ConvertUtility.ToInt32(item["UserID"]));
if (dtDiemTB != null && dtDiemTB.Rows.Count > 0)
{
DiemDGCV += ConvertUtility.ToDouble(dtDiemTB.Rows[0]["DiemTB"]);
count++;
}
}
DiemDGCV = DiemDGCV / count;
if (count == 0)
{
count = 1;
}
TongDiemDGCV = (DiemDGCV * 50 / 100) + (DiemCLCV * 10 / 100) + (DiemTDCV * 10 / 100);
TongDiemDGCV1 = (((DiemDGCV * 5) + (DiemCLCV) + (DiemTDCV))) / 7;
TongDiemDGCV = Math.Round(TongDiemDGCV, 2, MidpointRounding.AwayFromZero);
if (ds.Tables[1].Rows.Count > 0)
{
diemKyLuat = ConvertUtility.ToDouble(ds.Tables[1].Rows[0]["DiemKyLuat"].ToString());
diemKyLuat1 = diemKyLuat;
diemKyLuat = diemKyLuat * 20 / 100;
diemKyLuat = Math.Round(diemKyLuat, 2, MidpointRounding.AwayFromZero);
}
if (ds.Tables[2].Rows.Count > 0)
{
DiemDongNghiepDanhGia = ConvertUtility.ToDouble(ds.Tables[2].Rows[0]["DiemDongNghiepDanhGia"]);
if (DiemDongNghiepDanhGia == 0)
{
DiemDongNghiepDanhGia = 10;
DiemDongNghiepDanhGia1 = 100;
}
else
{
DiemDongNghiepDanhGia1 = DiemDongNghiepDanhGia;
DiemDongNghiepDanhGia = DiemDongNghiepDanhGia * 10 / 100;
}
DiemDongNghiepDanhGia = Math.Round(DiemDongNghiepDanhGia, 2);
}
string ten = "";
if (ds.Tables[3].Rows.Count > 0)
{
ten = ds.Tables[3].Rows[0]["HoTen"].ToString();
}
double TongDiem = Math.Round(TongDiemDGCV, 2, MidpointRounding.AwayFromZero);
TongDiem += Math.Round(diemKyLuat, 2, MidpointRounding.AwayFromZero);
TongDiem += Math.Round(DiemDongNghiepDanhGia, 2, MidpointRounding.AwayFromZero);
TongDiem = Math.Round(TongDiem, 2);
string xepLoai = GetXepLoai(TongDiem);
row["Bộ phận"] = tenTrungTam;
row["Họ tên"] = ten;
row["Điểm đánh giá công việc"] = (Math.Round(TongDiemDGCV1, 2, MidpointRounding.AwayFromZero) / 100).ToString();
row["Điểm kỷ luật và văn hóa doanh nghiệp"] = (Math.Round(diemKyLuat1, 2, MidpointRounding.AwayFromZero) / 100).ToString();
row["Điểm đồng nghiệp đánh giá"] = (Math.Round(DiemDongNghiepDanhGia1, 2, MidpointRounding.AwayFromZero) / 100).ToString();
row["Tổng điểm"] = Math.Round(TongDiem, 2, MidpointRounding.AwayFromZero) / 100;
//row["Xếp loại"] = xepLoai;
dtUsersTemp.Rows.Add(row);
}
}
#endregion
ImportExcelToDataTable.ExportToExcel(dtUsersTemp, "KQDanhGiaCaNhanCheckPoint_" + dropTrungTam.SelectedItem.Text + ".csv");
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (fileImport.HasFile)
{
if (!Directory.Exists(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/")))
{
Directory.CreateDirectory(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/"));
}
string date = DateTime.Now.ToString("yyyyMMddHHmmss");
string path = Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(".csv", "") + "_Temp_" + date + ".csv";
if (File.Exists(path))
{
File.Delete(path);
}
fileImport.PostedFile.SaveAs(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(".csv", "") + "_Temp_" + date + ".csv");
if (File.Exists(path))
{
DataTable returnTable = ImportExcelToDataTable.ConvertCSVtoDataTable(path);
if (returnTable != null && returnTable.Rows.Count > 0)
{
for (int i = 0; i < returnTable.Rows.Count; i++)
{
try
{
DataRow row = returnTable.Rows[i];
#region Import
TongHopDanhGiaCaNhanThangInfo info = new TongHopDanhGiaCaNhanThangInfo();
info.BoPhan = row[0].ToString();
info.HoTen = row[1].ToString();
info.KPI = ConvertUtility.ToDouble(row[2].ToString().Replace(".", ",")) * 100;
info.DiemDanhGiaDonVi = ConvertUtility.ToDouble(row[3].ToString().Replace(".", ",")) * 100;
info.LoiNhuanCongTy = ConvertUtility.ToDouble(row[4].ToString().Replace(".", ",")) * 100;
info.LoiNhuanBoPhan = ConvertUtility.ToDouble(row[5].ToString().Replace(".", ",")) * 100;
info.QuanLyCongViecVaPhoiHop = ConvertUtility.ToDouble(row[6].ToString().Replace(".", ",")) * 100;
info.KyLuatCaNhan = ConvertUtility.ToDouble(row[7].ToString().Replace(".", ",")) * 100;
info.DiemThuong = ConvertUtility.ToDouble(row[8].ToString().Replace(".", ","));
info.MucDoHoanThanh = ConvertUtility.ToDouble(row[9].ToString().Replace(".", ",")) * 100;
info.XepLoai = row[10].ToString();
info.HeSoLuongMem = ConvertUtility.ToDouble(row[11].ToString().Replace(".", ",")) * 100;
info.Nam = ConvertUtility.ToInt32(dropNam.SelectedValue);
info.Thang = ConvertUtility.ToInt32(dropThang.SelectedValue);
TongHopDanhGiaCaNhanThangController.Insert(info);
#endregion
}
catch
{
continue;
}
}
lblUpdateStatus.Text = "Bạn đã import thành công file \"" + fileImport.FileName + "\"";
}
else
{
lblUpdateStatus.Text = "File import sai định dạng";
}
}
else
{
lblUpdateStatus.Text = "File import sai định dạng";
}
}
else
{
lblUpdateStatus.Text = "File import sai định dạng";
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
if (fileImport.HasFile)
{
if (!Directory.Exists(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/")))
{
Directory.CreateDirectory(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/"));
}
string ext = ".xls";
if (fileImport.FileName.IndexOf(".xlsx") > 0)
{
ext = ".xlsx";
}
fileImport.PostedFile.SaveAs(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(ext, "") + "_Temp" + ext);
string path = Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + fileImport.FileName.Replace(ext, "") + "_Temp" + ext;
if (File.Exists(path))
{
DataTable returnTable = ImportExcelToDataTable.ImportExcel(path);
if (returnTable != null && returnTable.Rows.Count > 0)
{
if (chkDeleteAll.Checked)
{
QuanLyCongViecKTXVaPSController.DeleteAll(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 1, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
}
for (int i = 0; i < returnTable.Rows.Count; i++)
{
try
{
DataRow row = returnTable.Rows[i];
#region Import
QuanLyCongViecKTXVaPSInfo info = new QuanLyCongViecKTXVaPSInfo();
info.Ten = row[0].ToString();
info.ParentID = 0;
info.TyTrong = 0;
info.KeHoach = "";
info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue);
info.DonViDo = "";
info.IDPhongBan = 0;//ConvertUtility.ToInt32(dropPhong.SelectedValue);
info.Loai = 1;
info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
info.SoGio = 0;
info.IsKPI = 1;
info.NgayBatDau = DateTime.Now;
info.NgayKetThuc = DateTime.Now;
info.IDNhomCongViec = 1;
info.TrangThaiCV = 2;
info.TuanLamViec = "1,2,3,4,5";
QuanLyCongViecKTXVaPSController.Insert(info);
info = new QuanLyCongViecKTXVaPSInfo();
info.Ten = row[1].ToString();
int parentID = GetParentID(row[0].ToString(), ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
info.ParentID = parentID;
info.TyTrong = 0;
info.KeHoach = ConvertUtility.ToString(row[3].ToString());
info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue);
info.DonViDo = "";
info.IDPhongBan = 0;//ConvertUtility.ToInt32(dropPhong.SelectedValue);
info.Loai = 1;
info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
info.SoGio = ConvertUtility.ToDouble(row[2].ToString());
info.IsKPI = 1;
info.NgayBatDau = DateTime.Now;
info.NgayKetThuc = DateTime.Now;
info.IDNhomCongViec = 1;
info.TrangThaiCV = 2;
info.TuanLamViec = ConvertUtility.ToString(row[4].ToString());
QuanLyCongViecKTXVaPSController.Insert(info);
if (info.ParentID > 0)
{
UpdateCapDoCongViec();
}
#endregion
}
catch
{
continue;
}
}
}
}
else
{
lblStatusUpdate.Text = GetLocalResourceObject("lblUpdateStatusResource4.Text").ToString();
}
}
Session["Nav"] = "1";
}
