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";
        }
Esempio n. 7
0
 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);
 }
Esempio n. 9
0
 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));
 }
Esempio n. 12
0
 public abstract void UpdateCongViecKTXVaPS(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo);
Esempio n. 13
0
 public abstract int InsertCongViecKTXVaPS_6_11_2014(QuanLyCongViecKTXVaPSInfo _QuanLyCongViecKPIInfo);