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";
}
protected void cmdAdd_Click(object sender, EventArgs e)
{
QuanLyCongViecKTXVaPSInfo info = new QuanLyCongViecKTXVaPSInfo();
info.Ten = txtName.Text;
info.ParentID = ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue);
info.TyTrong = ConvertUtility.ToDouble(txtTyTrong.Text);
info.KeHoach = txtKeHoach.Text;
info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue);
info.DonViDo = txtDonViDo.Text;
info.IDPhongBan = 0;// ConvertUtility.ToInt32(dropPhong.SelectedValue);
info.Loai = 1;
info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
info.SoGio = ConvertUtility.ToDouble(txtSoGio.Text);
info.IsKPI = ConvertUtility.ToInt32(dropKPIBoPhan.SelectedValue);
info.NgayBatDau = ConvertUtility.ToDateTime(dtFrom.Text);
info.NgayKetThuc = ConvertUtility.ToDateTime(dtTo.Text);
info.IDNhomCongViec = ConvertUtility.ToInt32(dropMaNhom.SelectedValue);
info.TrangThaiCV = ConvertUtility.ToInt32(dropTrangThai.SelectedValue);
DateConverter objDate = new DateConverter();
int tuanBD = objDate.GetWeekOfMonth(info.NgayBatDau);
int tuanKT = objDate.GetWeekOfMonth(info.NgayKetThuc);
string tuanLV = "";
for (int i = tuanBD; i <= tuanKT; i++)
{
tuanLV += i + ",";
}
info.TuanLamViec = tuanLV.Substring(0, tuanLV.Length - 1);
try
{
QuanLyCongViecKTXVaPSController.Insert(info);
#region Log Action
LogFileInfo logFileInfo = new LogFileInfo();
logFileInfo.Log_Action = "Add";
logFileInfo.Log_Type_Object = "QuanLyCongViecKPI";
logFileInfo.Item_CatID = "Cong Viec Thuong Xuyen";
logFileInfo.Item_ID = info.ID.ToString();
logFileInfo.Item_Name = info.Ten;
logFileInfo.Description_Before = "Old Data: ";
logFileInfo.Description_After = "Add KPI with info: <br />" + GetObjectInfo(info);
logFileInfo.UserName = CurrentUser.Username;
logFileInfo.UserID = CurrentUser.UserID;
CreateLogFile.LogAction(logFileInfo);
#endregion
lblStatusUpdate.Text = MiscUtility.MSG_UPDATE_SUCCESS;
UpdateCapDoCongViec();
cmdEmpty_Click(null, null);
}
catch (Exception ex)
{
lblStatusUpdate.Text = ex.Message;
}
Session["Nav"] = "1";
}