private string GetObjectInfo(QuanLyCongViecKTXVaPSInfo info)
{
string returnValue = "";
#region Bind Old Info
returnValue += "ID: " + info.ID + " <br />";
returnValue += "Ten: " + info.Ten + " <br />";
returnValue += "TyTrong: " + info.TyTrong + " <br />";
returnValue += "SoGio: " + info.SoGio + " <br />";
returnValue += "ParentID: " + info.ParentID + " <br />";
returnValue += "Priority: " + info.Priority + " <br />";
returnValue += "KeHoach: " + info.KeHoach + " <br />";
returnValue += "DonViDo: " + info.DonViDo + " <br />";
returnValue += "IDTrungTam: " + info.IDTrungTam + " <br />";
returnValue += "IDPhongBan: " + info.IDPhongBan + " <br />";
returnValue += "DateTime: " + DateTime.Now + " <br />";
returnValue += "IsKPI:" + info.IsKPI;
returnValue += "NgayBatDau:" + info.NgayBatDau;
returnValue += "NgayKetThuc:" + info.NgayKetThuc;
#endregion
return returnValue;
}
private void InsertCongViecCon(DataTable source, DataRow curItem, int parentId, int idDotDanhGia)
{
DataRow[] rowChild = source.Select("ParentID='" + ConvertUtility.ToInt32(curItem["ID"]) + "'");
if (rowChild.Length > 0)
{
foreach (DataRow itemChild in rowChild)
{
QuanLyCongViecKTXVaPSInfo info = new QuanLyCongViecKTXVaPSInfo();
info.Ten = ConvertUtility.ToString(itemChild["Ten"]);
info.TyTrong = ConvertUtility.ToDouble(itemChild["TyTrong"]);
info.SoGio = ConvertUtility.ToDouble(itemChild["SoGio"]);
info.ParentID = parentId;
info.Priority = ConvertUtility.ToInt32(itemChild["Priority"]);
info.KeHoach = ConvertUtility.ToString(itemChild["KeHoach"]);
info.DonViDo = ConvertUtility.ToString(itemChild["DonViDo"]);
info.IDTrungTam = ConvertUtility.ToInt32(itemChild["IDTrungTam"]);
info.IDPhongBan = ConvertUtility.ToInt32(itemChild["IDPhongBan"]);
info.Loai = ConvertUtility.ToInt32(itemChild["Loai"]);
info.IDDotDanhGia = idDotDanhGia;
info.LevelDeep = ConvertUtility.ToInt32(itemChild["LevelDeep"]);
info.NgayBatDau = ConvertUtility.ToDateTime(itemChild["NgayBatDau"]).AddMonths(1);
info.NgayKetThuc = ConvertUtility.ToDateTime(itemChild["NgayKetThuc"]).AddMonths(1);
info.TrangThaiCV = ConvertUtility.ToInt32(itemChild["TrangThaiCV"]);
info.TuanLamViec = ConvertUtility.ToString(itemChild["TuanLamViec"]);
info.OldID = ConvertUtility.ToInt32(itemChild["ID"]);
int parentIDTemp = QuanLyCongViecKTXVaPSController.Insert_6_11_2014(info);
InsertCongViecCon(source, itemChild, parentIDTemp, idDotDanhGia);
}
}
}
protected void btnLayCongViecThangTruoc_Click(object sender, EventArgs e)
{
QuanLyCongViecKTXVaPSController.ClearAllCongViecTheoBoPhanVaDotDanhGia(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 2);
#region Copy cong viec thuong xuyen cua thang truoc
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(string));
dt.Columns.Add("Ten", typeof(string));
dt.Columns.Add("TyTrong", typeof(string));
dt.Columns.Add("SoGio", typeof(string));
dt.Columns.Add("ParentID", typeof(string));
dt.Columns.Add("Priority", typeof(string));
dt.Columns.Add("KeHoach", typeof(string));
dt.Columns.Add("DonViDo", typeof(string));
dt.Columns.Add("IDTrungTam", typeof(string));
dt.Columns.Add("IDPhongBan", typeof(string));
dt.Columns.Add("Loai", typeof(string));
dt.Columns.Add("IDDotDanhGia", typeof(string));
dt.Columns.Add("LevelDeep", typeof(string));
dt.Columns.Add("NgayBatDau", typeof(string));
dt.Columns.Add("NgayKetThuc", typeof(string));
dt.Columns.Add("TrangThaiCV", typeof(string));
dt.Columns.Add("TuanLamViec", typeof(string));
dt.Columns.Add("IDNhomCongViec", typeof(string));
DataTable source = QuanLyCongViecKTXVaPSController.LoadCongViecForCopyNew(dt, ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0, 2, ConvertUtility.ToInt32(dropDotDanhGiaCopy.SelectedValue));
DataRow[] row = source.Select("ParentID=0");
int parentId = 0;
foreach (DataRow item in row)
{
QuanLyCongViecKTXVaPSInfo info = new QuanLyCongViecKTXVaPSInfo();
info.Ten = ConvertUtility.ToString(item["Ten"]);
info.TyTrong = ConvertUtility.ToDouble(item["TyTrong"]);
info.SoGio = ConvertUtility.ToDouble(item["SoGio"]);
info.ParentID = 0;
info.Priority = ConvertUtility.ToInt32(item["Priority"]);
info.KeHoach = ConvertUtility.ToString(item["KeHoach"]);
info.DonViDo = ConvertUtility.ToString(item["DonViDo"]);
info.IDTrungTam = ConvertUtility.ToInt32(item["IDTrungTam"]);
info.IDPhongBan = ConvertUtility.ToInt32(item["IDPhongBan"]);
info.Loai = ConvertUtility.ToInt32(item["Loai"]);
info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
info.LevelDeep = ConvertUtility.ToInt32(item["LevelDeep"]);
info.NgayBatDau = ConvertUtility.ToDateTime(item["NgayBatDau"]).AddMonths(1);
info.NgayKetThuc = ConvertUtility.ToDateTime(item["NgayKetThuc"]).AddMonths(1);
info.TrangThaiCV = ConvertUtility.ToInt32(item["TrangThaiCV"]);
info.TuanLamViec = ConvertUtility.ToString(item["TuanLamViec"]);
info.IDNhomCongViec = ConvertUtility.ToInt32(item["IDNhomCongViec"]);
info.OldID = ConvertUtility.ToInt32(item["ID"]);
try
{
parentId = QuanLyCongViecKTXVaPSController.Insert_6_11_2014(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
InsertCongViecCon(source, item, parentId, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
lblStatusUpdate.Text = MiscUtility.MSG_UPDATE_SUCCESS;
}
catch (Exception ex)
{
lblStatusUpdate.Text = ex.Message;
}
}
UpdateCapDoCongViec(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
#endregion
#region Lay cac nhan vien va cac cong viec duoc giao thang truoc --> thuc hien giao viec
//lay tat ca nhan vien cua trung tam
DataTable dtNhanVien = DotDanhGiaController.GetAllNhanVienTemp(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0);
foreach (DataRow item in dtNhanVien.Rows)
{
try
{
string[] array = item["UserID"].ToString().Split('_');
int idNhanVien = ConvertUtility.ToInt32(array[0]);
int idBoPhan = ConvertUtility.ToInt32(array[2]);
DataSet ds = DotDanhGiaController.GetPTDG(idNhanVien, ConvertUtility.ToInt32(item["IDPhong"]));
DataTable dtNDG = ds.Tables[0];
int idNguoiDanhGia = 0;
if (dtNDG != null && dtNDG.Rows.Count > 0)
{
idNguoiDanhGia = ConvertUtility.ToInt32(dtNDG.Rows[0]["IDNguoiDG"]);
}
DotDanhGiaController.UpdateNhanVienVaoDotDanhGia(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), idNhanVien, ConvertUtility.ToInt32(array[2]), ConvertUtility.ToInt32(array[1]), idNguoiDanhGia, 0);
#region Update cong viec cho nhan vien theo thang
DataTable dtCongViec = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS_6_11_2014(idNhanVien, 2, ConvertUtility.ToInt32(dropDotDanhGiaCopy.SelectedValue));
if (dtCongViec != null && dtCongViec.Rows.Count > 0)
{
foreach (DataRow rowCV in dtCongViec.Rows)
{
DanhGiaThang_DGCBCNVDanhGiaTTCVInfo info = new DanhGiaThang_DGCBCNVDanhGiaTTCVInfo();
info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
info.IDNhanVien = idNhanVien;
info.TenCongViec = ConvertUtility.ToString(rowCV["Ten"]);
int idCongViecKPI = ConvertUtility.ToInt32(rowCV["IDCongViecKPI"]);
QuanLyCongViecKTXVaPSInfo infoCongViecKPI = QuanLyCongViecKTXVaPSController.GetInfoByOldID(idCongViecKPI);
if (infoCongViecKPI != null)
{
info.IDBoPhan = ConvertUtility.ToInt32(rowCV["IDBoPhan"]);
info.IDPhongBan = ConvertUtility.ToInt32(rowCV["IDPhongBan"]);
info.TyTrongCV = Math.Round(ConvertUtility.ToDouble(rowCV["TyTrong"]), 2);
info.SoGio = Math.Round(ConvertUtility.ToDouble(rowCV["SoGio"]), 2);
DotDanhGiaController.UpdateCongViecChoNhanVien(idNhanVien, infoCongViecKPI.ID, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), info.IDBoPhan, info.IDPhongBan, info.TyTrongCV, info.SoGio);
info.SoLieuCamKet = ConvertUtility.ToString(rowCV["KeHoach"]);
info.YeuCauHoTro = "";
info.Loai = 2;
info.IDCongViec = infoCongViecKPI.ID;
info.IDBoPhanHoTro = 0;
info.IDBoPhan = ConvertUtility.ToInt32(rowCV["IDBoPhan"]);
info.IDPhongBan = ConvertUtility.ToInt32(rowCV["IDPhongBan"]);
info.NgayBatDau = ConvertUtility.ToDateTime(rowCV["NgayBatDau"]).AddMonths(1);
info.NgayKetThuc = ConvertUtility.ToDateTime(rowCV["NgayKetThuc"]).AddMonths(1);
DanhGiaThang_DGCBCNVDanhGiaTTCVController.InsertKeHoachThang(info);
}
}
}
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
Session["Nav"] = "2";
}
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 = 2;
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"] = "2";
}
public static int Insert(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo)
{
return DataAccessProvider.Instance().InsertCongViecKTXVaPS(_QuanLyCongViecKPIInfo);
}
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 = 2;
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 = 2;
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"] = "2";
}
public override void UpdateCongViecKTXVaPS(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo)
{
SqlHelper.ExecuteNonQuery(this.ConnectionString, "QuanLyCongViecKTXVaPS_Update_5_6_2014", _QuanLyCongViecKPIInfo.ID, _QuanLyCongViecKPIInfo.Ten, _QuanLyCongViecKPIInfo.TyTrong, _QuanLyCongViecKPIInfo.ParentID, _QuanLyCongViecKPIInfo.KeHoach, _QuanLyCongViecKPIInfo.DonViDo, _QuanLyCongViecKPIInfo.IDTrungTam, _QuanLyCongViecKPIInfo.IDPhongBan, _QuanLyCongViecKPIInfo.Loai, _QuanLyCongViecKPIInfo.IDDotDanhGia, _QuanLyCongViecKPIInfo.SoGio, _QuanLyCongViecKPIInfo.IsKPI, _QuanLyCongViecKPIInfo.NgayBatDau, _QuanLyCongViecKPIInfo.NgayKetThuc, _QuanLyCongViecKPIInfo.IDNhomCongViec, _QuanLyCongViecKPIInfo.TrangThaiCV, _QuanLyCongViecKPIInfo.TuanLamViec);
}
public static void Update(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo)
{
DataAccessProvider.Instance().UpdateCongViecKTXVaPS(_QuanLyCongViecKPIInfo);
}
public override int InsertCongViecKTXVaPS_6_11_2014(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo)
{
return (int)SqlHelper.ExecuteScalar(this.ConnectionString, "QuanLyCongViecKTXVaPS_Insert_6_11_2014", _QuanLyCongViecKPIInfo.Ten, _QuanLyCongViecKPIInfo.TyTrong, _QuanLyCongViecKPIInfo.ParentID, _QuanLyCongViecKPIInfo.KeHoach, _QuanLyCongViecKPIInfo.DonViDo, _QuanLyCongViecKPIInfo.IDTrungTam, _QuanLyCongViecKPIInfo.IDPhongBan, _QuanLyCongViecKPIInfo.Loai, _QuanLyCongViecKPIInfo.IDDotDanhGia, _QuanLyCongViecKPIInfo.SoGio, _QuanLyCongViecKPIInfo.IsKPI, _QuanLyCongViecKPIInfo.NgayBatDau, _QuanLyCongViecKPIInfo.NgayKetThuc, _QuanLyCongViecKPIInfo.IDNhomCongViec, _QuanLyCongViecKPIInfo.TrangThaiCV, _QuanLyCongViecKPIInfo.TuanLamViec, _QuanLyCongViecKPIInfo.OldID);
}
public static void Update(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo)
{
DataAccessProvider.Instance().UpdateCongViecKTXVaPS(_QuanLyCongViecKPIInfo);
}
public static int Insert_6_11_2014(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo)
{
return(DataAccessProvider.Instance().InsertCongViecKTXVaPS_6_11_2014(_QuanLyCongViecKPIInfo));
}
public abstract void UpdateCongViecKTXVaPS(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo);
public abstract int InsertCongViecKTXVaPS_6_11_2014(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo);