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 btnExport_Click(object sender, EventArgs e)
{
XmlDocument xmlDoc = new XmlDocument();
// Write down the XML declaration
XmlDeclaration xmlDeclaration = xmlDoc.CreateXmlDeclaration("1.0", "utf-8", null);
// Create the root element
XmlElement rootNode = xmlDoc.CreateElement("ReportDataSet");
xmlDoc.InsertBefore(xmlDeclaration, xmlDoc.DocumentElement);
xmlDoc.AppendChild(rootNode);
DataTable dt = BoPhanController.BoPhan_GetAllActive();
foreach (DataRow item in dt.Rows)
{
string desc = item["MoTa"].ToString();
string ten = item["Ten"].ToString();
XmlElement Node = xmlDoc.CreateElement("Table" + desc);
rootNode.AppendChild(Node);
DataTable dtNhanVien = TongHopDanhGiaCaNhanThangController.GetAllNhanVien(ten, ConvertUtility.ToInt32(dropNam.SelectedValue));
int stt = 1;
foreach (DataRow itemNhanVien in dtNhanVien.Rows)
{
DataTable dtDataOfNhanVien = TongHopDanhGiaCaNhanThangController.GetAll(ten, ConvertUtility.ToInt32(dropNam.SelectedValue), itemNhanVien["HoTen"].ToString());
xmlDoc = BuildXmlDocument(dtDataOfNhanVien, xmlDoc, Node, stt, itemNhanVien["HoTen"].ToString());
stt++;
}
}
if (!Directory.Exists(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/")))
{
Directory.CreateDirectory(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/"));
}
//ds.Dispose();
string datetime = DateTime.Now.ToString("yyyyMMddHHmmss");
FileStream downloadFile =
File.Create(Server.MapPath("/UpLoad/Temp/" + CurrentUser.UserID + "/") + "TongHopBaoCaoXepLoaiNhanVien_" + datetime +
".xls");
// transform
XslTransform xsl = new XslTransform();
xsl.Load(Server.MapPath("/Template/" + "ReportTongHopXepLoaiNhanVien.xsl"));
xsl.Transform(xmlDoc, null, downloadFile, null);
downloadFile.Flush();
downloadFile.Close();
if (AppEnv.GetLanguage() == "vi-VN")
{
hplDownload.Text = "Hãy click vào liên kết này để Tải file về";
}
else
{
hplDownload.Text = "Please, click here to download file";
}
hplDownload.NavigateUrl = "/UpLoad/Temp/" + CurrentUser.UserID + "/TongHopBaoCaoXepLoaiNhanVien_" + datetime + ".xls";
}
