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 override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
DataTable dtUsers = UserController.GetKetQuaDanhGia(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
DataTable dtUsersTemp = dtUsers.Clone();
dtUsersTemp.Columns.Add("MucDoHoanThanh", typeof(double));
dtUsersTemp.Columns.Add("XepLoai", typeof(string));
dtUsersTemp.Columns.Add("Rank", typeof(string));
double tbKetquaHTKHHD = 0;
double tbDiemPhoiHop = 0;
double tbDiemSangTao = 0;
double tbDiemKyLuat = 0;
double tbDiemMucDoHoanThanh = 0;
foreach (DataRow item in dtUsers.Rows)
{
double KetquaHTKHHD = ConvertUtility.ToDouble(item["KetquaHTKHHD"]);
double DiemPhoiHop = ConvertUtility.ToDouble(item["DiemPhoiHop"]);
double DiemSangTao = ConvertUtility.ToDouble(item["DiemSangTao"]);
double DiemKyLuat = ConvertUtility.ToDouble(item["DiemKyLuat"]);
if (DiemSangTao == 0)
{
DiemSangTao = 100;
}
if (DiemPhoiHop == 0)
{
DiemPhoiHop = 100;
}
tbKetquaHTKHHD += KetquaHTKHHD;
tbDiemPhoiHop += DiemPhoiHop;
tbDiemSangTao += DiemSangTao;
tbDiemKyLuat += DiemKyLuat;
double tong = KetquaHTKHHD * 75 / 100;
tong += DiemPhoiHop * 10 / 100;
tong += DiemSangTao * 5 / 100;
tong += DiemKyLuat * 10 / 100;
tong = Math.Round(tong, 1);
tbDiemMucDoHoanThanh += tong;
DataRow row = dtUsersTemp.NewRow();
row["ID"] = item["ID"];
row["Ten"] = item["Ten"];
row["KetquaHTKHHD"] = item["KetquaHTKHHD"];
row["DiemPhoiHop"] = DiemPhoiHop;
row["DiemSangTao"] = DiemSangTao;
row["DiemKyLuat"] = item["DiemKyLuat"];
row["MucDoHoanThanh"] = tong;//.ToString().Substring(0, tong.ToString().IndexOf(',')) + "," + tong.ToString().Substring(tong.ToString().IndexOf(',') + 1,1);
row["XepLoai"] = GetXepLoai(tong);
dtUsersTemp.Rows.Add(row);
}
DataTable dtBoPhan = RankDt(dtUsersTemp, "MucDoHoanThanh");
foreach (DataRow item in dtUsersTemp.Rows)
{
item["Rank"] = dtBoPhan.Select(" ID='" + item["ID"] + "'")[0]["RankTemp"];
item["DiemSangTao"] = dtBoPhan.Select(" ID='" + item["ID"] + "'")[0]["DiemSangTao"];
item["DiemPhoiHop"] = dtBoPhan.Select(" ID='" + item["ID"] + "'")[0]["DiemPhoiHop"];
}
dgrBoPhan.DataSource = dtUsersTemp;
dgrBoPhan.RowDataBound += new GridViewRowEventHandler(dgrBoPhan_RowDataBound);
dgrBoPhan.DataBind();
lblTotalTop.Text = lblTotalBottom.Text = dtUsers.Rows.Count.ToString();
int i = dtUsers.Rows.Count;
lblTBKetQuaKHHD.Text = Math.Round(tbKetquaHTKHHD / i, 1).ToString() + "%";
tblTBDiemPhoiHop.Text = Math.Round(tbDiemPhoiHop / i, 1).ToString() + "%";
lblTBDiemSangTao.Text = Math.Round(tbDiemSangTao / i, 1).ToString() + "%";
lblTBKyLuat.Text = Math.Round(tbDiemKyLuat / i, 1).ToString() + "%";
lblTBMucDoHoanThanh.Text = Math.Round(tbDiemMucDoHoanThanh / i, 1).ToString() + "%";
}
protected void cmdUpdate_Click(object sender, EventArgs e)
{
QuanLyCongViecBaoCaoNgayInfo info = QuanLyCongViecBaoCaoNgayController.GetInfo(ConvertUtility.ToInt32(txtID.Text));
if (info == null)
{
cmdEmpty_Click(null, null);
return;
}
if (info.ID == ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue))
{
lblStatusUpdate.Text = "Trung mục cha";
return;
}
string oldData = GetObjectInfo(info);
info.IDCongViecKPI = ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue);
info.Ten = txtName.Text;
info.KeHoach = txtKeHoach.Text;
info.ParentID = txtCongViecLon.Text;
info.TyTrong = 0;// ConvertUtility.ToDouble(txtTyTrong.Text);
info.KetQua = txtKetqua.Text;
info.TyLeHoanThanh = dropTyLeHoanThanh.SelectedValue;
info.IDTrungTam = CurrentUser.IDTrungTam;
info.IDPhongBan = CurrentUser.IDPhong;
info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
info.SoGio = ConvertUtility.ToDouble(txtSoGio.Text);
info.CreateBy = CurrentUser.UserID;
info.LyDo = txtLyDo.Text;
info.DeXuat = txtDeXuat.Text;
info.CreatedOn = new DateTime(ConvertUtility.ToInt32(dropYear.SelectedValue), ConvertUtility.ToInt32(dropMonth.SelectedValue), ConvertUtility.ToInt32(dropDay.SelectedValue));
try
{
QuanLyCongViecBaoCaoNgayController.Update(info);
lblStatusUpdate.Text = MiscUtility.MSG_UPDATE_SUCCESS;
#region Log Action
LogFileInfo logFileInfo = new LogFileInfo();
logFileInfo.Log_Action = "Update";
logFileInfo.Log_Type_Object = "QuanLyCongViecKPITheoNgay";
logFileInfo.Item_CatID = "Cong Viec Thuong Xuyen";
logFileInfo.Item_ID = info.ID.ToString();
logFileInfo.Item_Name = info.Ten;
logFileInfo.Description_Before = "Old Data: " + oldData;
logFileInfo.Description_After = "Update KPI with info: <br />" + GetObjectInfo(info);
logFileInfo.UserName = CurrentUser.Username;
logFileInfo.UserID = CurrentUser.UserID;
CreateLogFile.LogAction(logFileInfo);
#endregion
cmdEmpty_Click(null, null);
//Response.Redirect(AppEnv.AdminUrlParams("baocaongay"));
}
catch (Exception ex)
{
lblStatusUpdate.Text = ex.Message;
}
}
protected string GetThoiGian(object tytrong)
{
return Math.Round(ConvertUtility.ToDouble(tytrong) * 22 * 8 / 100, 3).ToString();
}
private static double GetExpire()
{
return(ConvertUtility.ToDouble(ConfigurationSettings.AppSettings.Get("news_expired")));
}
private static EbayOrderHeaderType AddOrderHeader(OrderType orderType)
{
EbayOrderHeaderType ebayOrderHeaderType = new EbayOrderHeaderType();
ebayOrderHeaderType.OrderID = orderType.OrderID;
ebayOrderHeaderType.AdjustmentAmount = orderType.AdjustmentAmount.Value;
ebayOrderHeaderType.AmountPaid = orderType.AmountPaid.Value;
ebayOrderHeaderType.AmountSaved = orderType.AmountSaved.Value;
ebayOrderHeaderType.BuyerCheckoutMessage = orderType.BuyerCheckoutMessage == null ? "" : orderType.BuyerCheckoutMessage.ToString().Replace("'", "''");
ebayOrderHeaderType.BuyerUserID = orderType.BuyerUserID.ToString().Replace("'", "''");
ebayOrderHeaderType.eBayPaymentStatus = orderType.CheckoutStatus.eBayPaymentStatus.ToString().Replace("'", "''");
ebayOrderHeaderType.PaymentMethod = orderType.CheckoutStatus.PaymentMethod.ToString().Replace("'", "''");
if (orderType.CreatedTime.ToLocalTime() <= ConvertUtility.ToDateTime("1901-01-01 00：00：00"))
{
ebayOrderHeaderType.CreatedTime = (DateTime)SqlDateTime.MinValue;
}
else
{
ebayOrderHeaderType.CreatedTime = orderType.CreatedTime.ToLocalTime();
}
ebayOrderHeaderType.ExtendedOrderID = orderType.ExtendedOrderID == null ? "" : orderType.ExtendedOrderID.ToString();
ebayOrderHeaderType.OrderStatus = orderType.OrderStatus.ToString();
if (orderType.PaidTime.ToLocalTime() <= ConvertUtility.ToDateTime("1901-01-01 00：00：00"))
{
ebayOrderHeaderType.PaidTime = (DateTime)SqlDateTime.MinValue;
}
else
{
ebayOrderHeaderType.PaidTime = orderType.PaidTime.ToLocalTime();
}
if (orderType.PaymentHoldDetails == null)
{
ebayOrderHeaderType.PaymentExpectedReleaseDate = (DateTime)SqlDateTime.MinValue;
ebayOrderHeaderType.PaymentHoldReason = "";
}
else
{
if (orderType.PaymentHoldDetails.ExpectedReleaseDate.ToLocalTime() <= ConvertUtility.ToDateTime("1901-01-01 00：00：00"))
{
ebayOrderHeaderType.PaymentExpectedReleaseDate = (DateTime)SqlDateTime.MinValue;
}
else
{
ebayOrderHeaderType.PaymentExpectedReleaseDate = orderType.PaymentHoldDetails.ExpectedReleaseDate.ToLocalTime();
}
ebayOrderHeaderType.PaymentHoldReason = orderType.PaymentHoldDetails.PaymentHoldReason.ToString();
}
ebayOrderHeaderType.PaymentHoldStatus = orderType.PaymentHoldStatus.ToString();
ebayOrderHeaderType.SellerEmail = orderType.SellerEmail.Replace("'", "''");
ebayOrderHeaderType.SellerUserID = orderType.SellerUserID.Replace("'", "''");
ebayOrderHeaderType.AddressID = orderType.ShippingAddress.AddressID;
ebayOrderHeaderType.CityName = orderType.ShippingAddress.CityName.Replace("'", "''");
ebayOrderHeaderType.Country = orderType.ShippingAddress.Country.ToString();
ebayOrderHeaderType.CountryName = orderType.ShippingAddress.CountryName.ToString().Replace("'", "''");
ebayOrderHeaderType.ExternalAddressID = orderType.ShippingAddress.ExternalAddressID == null ? "" : orderType.ShippingAddress.ExternalAddressID.ToString();
ebayOrderHeaderType.Name = orderType.ShippingAddress.Name == null ? "" : orderType.ShippingAddress.Name.ToString().Replace("'", "''");
ebayOrderHeaderType.Phone = orderType.ShippingAddress.Phone == null ? "" : orderType.ShippingAddress.Phone.ToString().Replace("'", "''"); ;
ebayOrderHeaderType.PostalCode = orderType.ShippingAddress.PostalCode == null ? "" : orderType.ShippingAddress.PostalCode.ToString().Replace("'", "''");
ebayOrderHeaderType.StateOrProvince = orderType.ShippingAddress.StateOrProvince == null ? "" : orderType.ShippingAddress.StateOrProvince.ToString().Replace("'", "''");
ebayOrderHeaderType.Street1 = orderType.ShippingAddress.Street1 == null ? "" : orderType.ShippingAddress.Street1.ToString().Replace("'", "''");
ebayOrderHeaderType.Street2 = orderType.ShippingAddress.Street2 == null ? "" : orderType.ShippingAddress.Street2.ToString().Replace("'", "''");
ebayOrderHeaderType.SalesTaxAmount = orderType.ShippingDetails.SalesTax.SalesTaxAmount == null ? 0 : orderType.ShippingDetails.SalesTax.SalesTaxAmount.Value;
ebayOrderHeaderType.SalesTaxPerecent = ConvertUtility.ToDouble(orderType.ShippingDetails.SalesTax.SalesTaxPercent.ToString());
ebayOrderHeaderType.SalesTaxState = orderType.ShippingDetails.SalesTax.SalesTaxState == null ? "" : orderType.ShippingDetails.SalesTax.SalesTaxState.ToString();
ebayOrderHeaderType.ShippingIncludedInTax = orderType.ShippingDetails.SalesTax.ShippingIncludedInTax == true ? 1 : 0;
ebayOrderHeaderType.SellingManagerSalesRecordNumber = orderType.ShippingDetails.SellingManagerSalesRecordNumber.ToString();
ebayOrderHeaderType.ExpeditedService = orderType.ShippingServiceSelected.ExpeditedService == true ? 1 : 0;
ebayOrderHeaderType.ShippingService = orderType.ShippingServiceSelected.ShippingService == null ? "" : orderType.ShippingServiceSelected.ShippingService.ToString();
ebayOrderHeaderType.ShippingServiceCost = orderType.ShippingServiceSelected.ShippingServiceCost == null ? 0 : orderType.ShippingServiceSelected.ShippingServiceCost.Value;
ebayOrderHeaderType.ShippingServiceAdditionalCost = orderType.ShippingServiceSelected.ShippingServiceAdditionalCost == null ? 0 : orderType.ShippingServiceSelected.ShippingServiceAdditionalCost.Value;
ebayOrderHeaderType.ShippingServicePriority = orderType.ShippingServiceSelected.ShippingServicePriority;
ebayOrderHeaderType.Subtotal = orderType.Subtotal == null ? 0 : orderType.Subtotal.Value;
ebayOrderHeaderType.Total = orderType.Total == null ? 0 : orderType.Total.Value;
ebayOrderHeaderType.TransferStatus = 0;
ebayOrderHeaderType.EnterDate = System.DateTime.Now;
ebayOrderHeaderType.UpdateDate = System.DateTime.Now;
return ebayOrderHeaderType;
}
//protected void dropTrungTam_SelectedIndexChanged(object sender, EventArgs e)
//{
// dropPhongBan.Items.Clear();
// dropPhongBan.DataSource = DotDanhGiaController.GetAllPhongBan(ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
// dropPhongBan.DataBind();
// dropPhongBan.Items.Insert(0, new ListItem("----------Lựa chọn----------", "0"));
//}
//protected void dropPhongBan_SelectedIndexChanged(object sender, EventArgs e)
//{
//}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
DataTable dt = new DataTable();
dt.Columns.Add("HoTen", typeof(String));
dt.Columns.Add("ChucVu", typeof(String));
dt.Columns.Add("TTCVThuongXuyen", typeof(String));
dt.Columns.Add("TTCVKeHoachThang", typeof(String));
dt.Columns.Add("TTCVPhatSinh", typeof(String));
dt.Columns.Add("TTConLai", typeof(String));
//dt.Columns.Add("TTSoVoiBoPhan", typeof(String));
DataTable dtNhanVien = DotDanhGiaController.GetAllNhanVien(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0);
if (dtNhanVien == null)
{
return;
}
foreach (DataRow itemNhanVien in dtNhanVien.Rows)
{
DataRow row = dt.NewRow();
#region Ty Trong Cong Viec
double totalCVTX = 0;
double totalCVKTX = 0;
double totalCVPS = 0;
double total = 0;
double totalCVTX_Gio = 0;
double totalCVKTX_Gio = 0;
double totalCVPS_Gio = 0;
double total_Gio = 0;
idNhanVien = ConvertUtility.ToInt32(itemNhanVien["UserID"]);
string HoTen = "";
string ChucVu = "";
DataTable dtUserInfo = DotDanhGiaController.GetUserInfo(idNhanVien);
if (dtUserInfo != null && dtUserInfo.Rows.Count > 0)
{
HoTen = dtUserInfo.Rows[0]["HoTen"].ToString();
ChucVu = dtUserInfo.Rows[0]["ChucVu"].ToString();
}
DataTable dtCongViecThuongXuyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(1, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), idNhanVien);
foreach (DataRow item in dtCongViecThuongXuyen.Rows)
{
totalCVTX += ConvertUtility.ToDouble(item["TyTrongCV"]);
totalCVTX_Gio += ConvertUtility.ToDouble(item["SoGio"]);
}
DataTable dtCongViecKhongThuonguyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(2, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), idNhanVien);
foreach (DataRow item in dtCongViecKhongThuonguyen.Rows)
{
totalCVKTX += ConvertUtility.ToDouble(item["TyTrongCV"]);
totalCVKTX_Gio += ConvertUtility.ToDouble(item["SoGio"]);
}
DataTable dtCongViecPhatSinh = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(3, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), idNhanVien);
foreach (DataRow item in dtCongViecPhatSinh.Rows)
{
totalCVPS += ConvertUtility.ToDouble(item["TyTrongCV"]);
totalCVPS_Gio += ConvertUtility.ToDouble(item["SoGio"]);
}
row["HoTen"] = HoTen;
row["ChucVu"] = ChucVu;
row["TTCVThuongXuyen"] = Math.Round(totalCVTX, 2) + "% (" + totalCVTX_Gio + "h)";
row["TTCVKeHoachThang"] = Math.Round(totalCVKTX, 2) + "% (" + totalCVKTX_Gio + "h)";
row["TTCVPhatSinh"] = Math.Round(totalCVPS, 2) + "% (" + totalCVPS_Gio + "h)";
total = totalCVTX + totalCVKTX + totalCVPS;
total_Gio = totalCVTX_Gio + totalCVKTX_Gio + totalCVPS_Gio;
double totalCVPhatSinh = Math.Round((100 - total), 2);
double totalCVPhatSinh_Gio = Math.Round((176 - total_Gio), 2);
if (totalCVPhatSinh > 0)
{
row["TTConLai"] = totalCVPhatSinh + "% (" + totalCVPhatSinh_Gio + "h)";
}
else
{
row["TTConLai"] = "0%";
}
dt.Rows.Add(row);
#endregion
}
dgrBaoCao.DataSource = dt;
dgrBaoCao.DataBind();
}
private static ImageInfo CreateEntityFromReader(IDataReader reader)
{
var item = new ImageInfo();
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_ID")))
{
item.Image_ID = ConvertUtility.ToInt32(reader["Image_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Name")))
{
item.Image_Name = ConvertUtility.ToString(reader["Image_Name"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Description")))
{
item.Image_Description = ConvertUtility.ToString(reader["Image_Description"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_File")))
{
item.Image_File = ConvertUtility.ToString(reader["Image_File"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_CreateDate")))
{
item.Image_CreateDate = ConvertUtility.ToDateTime(reader["Image_CreateDate"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_FileSize")))
{
item.Image_FileSize = ConvertUtility.ToDouble(reader["Image_FileSize"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Width")))
{
item.Image_Width = ConvertUtility.ToInt32(reader["Image_Width"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Height")))
{
item.Image_Height = ConvertUtility.ToInt32(reader["Image_Height"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_View")))
{
item.Image_View = ConvertUtility.ToInt32(reader["Image_View"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("User_ID")))
{
item.User_ID = ConvertUtility.ToInt32(reader["User_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Visible")))
{
item.Image_Visible = ConvertUtility.ToBoolean(reader["Image_Visible"]);
}
}
catch { }
return(item);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
foreach (GridViewRow gv in dtgUsers.Rows)
{
string strUserID = ((Label)gv.FindControl("lblKey")).Text.ToString();
int idDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
TextBox txtDiem = (TextBox)gv.FindControl("txtDiem");
TextBox txtNote = (TextBox)gv.FindControl("txtNote");
UserController.UpdateUserDiemSangTao(ConvertUtility.ToInt32(strUserID), idDotDanhGia, ConvertUtility.ToDouble(txtDiem.Text), txtNote.Text);
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
#region Check authenticate
UserInfo userInfo = UserController.GetUser(idNhanVien);
if (userInfo == null)
{
Response.Redirect(AppEnv.AdminUrlParams("accessdeny"));
}
if (!CurrentUser.IsAdmin && !CurrentUser.IsSuperAdmin)
{
if (CurrentUser.UserID != 8)
{
if (CurrentUser.RoleID == (int)Constants.Role.NhanVien || CurrentUser.RoleID == (int)Constants.Role.NhanVienKD)
{
if (CurrentUser.UserID != idNhanVien)
{
Response.Redirect(AppEnv.AdminUrlParams("accessdeny"));
}
}
}
}
#endregion
DataTable dt = DotDanhGiaController.checkDanhGiaThang(idDotDanhGia, idNhanVien);
if (dt != null && dt.Rows.Count > 0)
{
#region kiem tra trang thai cua Ban danh gia
if (idNhanVien == CurrentUser.UserID)
{
if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.ThongNhat)
{
btnSumit.Enabled = false;
btnSumit.Text = "Thống nhất";
}
else
{
btnSumit.Enabled = false;
btnSumit.Text = "Chờ CEO đánh giá";
}
}
else
{
btnSumit.Enabled = true;
btnSumit.Text = "Đánh giá và gửi lại kết quả cho TBP";
}
#endregion
tableContent.Visible = true;
tableAlert.Visible = false;
#region Tong diem cua ban danh gia
DataSet ds = DotDanhGiaController.DanhGiaThang_DGCBCNVDanhGia_TongDiemCongThucMoi(idDotDanhGia, idNhanVien);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
lblDiemDanhGiaDonVi.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[0].Rows[0]["TotalDiemDanhGiaDonVi"].ToString()), 2).ToString() + "%";
}
if (ds.Tables[1].Rows.Count > 0)
{
lblDiemHoanThanhLoiNhuanCongTy.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[1].Rows[0]["TotalDiemLNCgTy"]), 2).ToString() + "%";
}
if (ds.Tables[2].Rows.Count > 0)
{
lblDiemKhoiLuongCongViec.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[2].Rows[0]["TotalDiemKhoiLuongCongViec"]), 2).ToString() + "%";
}
if (ds.Tables[3].Rows.Count > 0)
{
lblDiemKyNangLamViec.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[3].Rows[0]["TotalDiemKyNangLamViec"]), 2).ToString() + "%";
}
if (ds.Tables[4].Rows.Count > 0)
{
lblDiemKyLuat.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[4].Rows[0]["TotalDiemKyLuat"]), 2).ToString() + "%";
}
if (ds.Tables[5].Rows.Count > 0)
{
lblMucDoHoanThanh.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[5].Rows[0]["TongDiem"]), 1, MidpointRounding.AwayFromZero).ToString() + "%";
}
if (ds.Tables[6].Rows.Count > 0)
{
lblXepLoai.Text = ds.Tables[6].Rows[0]["XepLoai"].ToString();
}
if (ds.Tables[7].Rows.Count > 0)
{
lblName.Text = ds.Tables[7].Rows[0]["HoTen"].ToString();
}
if (ds.Tables[8].Rows.Count > 0)
{
lblDiemThuong.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[8].Rows[0]["DiemThuong"]), 2).ToString() + "%";
}
lblHeSoLuongMem.Text = GetLuongMem(lblXepLoai.Text);
#region Ty Trong Cong Viec
double totalCVTX = 0;
double totalCVKTX = 0;
double totalCVPS = 0;
double total = 0;
DataTable dtCongViecThuongXuyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(1, idDotDanhGia, idNhanVien);
foreach (DataRow item in dtCongViecThuongXuyen.Rows)
{
totalCVTX += ConvertUtility.ToDouble(item["TyTrongCV"]);
}
DataTable dtCongViecKhongThuonguyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(2, idDotDanhGia, idNhanVien);
foreach (DataRow item in dtCongViecKhongThuonguyen.Rows)
{
totalCVKTX += ConvertUtility.ToDouble(item["TyTrongCV"]);
}
DataTable dtCongViecPhatSinh = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(3, idDotDanhGia, idNhanVien);
foreach (DataRow item in dtCongViecPhatSinh.Rows)
{
totalCVPS += ConvertUtility.ToDouble(item["TyTrongCV"]);
}
lblCVTX.Text = Math.Round(totalCVTX, 2) + "%";
lblCVKTX.Text = Math.Round(totalCVKTX, 2) + "%";
lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%";
total = totalCVTX + totalCVKTX + totalCVPS;
lblTotal.Text = Math.Round(total, 2).ToString() + "%";
lblTotal.Text = Math.Round(total, 2).ToString() + "%";
if (total > 100)
{
lblTotal.ForeColor = Color.Red;
}
double totalCVPhatSinh = Math.Round((100 - total), 2);
if (totalCVPhatSinh > 0)
{
lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%" + " còn lại " + Math.Round((100 - total), 2) + "%";
}
else
{
lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%";
}
#endregion
}
#endregion
}
else
{
tableContent.Visible = false;
tableAlert.Visible = true;
}
}
void ButtonOkClick(object sender, EventArgs e)
{
invoice.AmountPaid = ConvertUtility.ToDouble(textBoxAmountPaid.Text);
}
private static DownloadInfo CreateEntityFromReader(IDataReader reader)
{
var item = new DownloadInfo();
try { if (!reader.IsDBNull(reader.GetOrdinal("Download_ID")))
{
item.Download_ID = ConvertUtility.ToInt32(reader["Download_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Download_Name")))
{
item.Download_Name = ConvertUtility.ToString(reader["Download_Name"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Download_Description")))
{
item.Download_Description = ConvertUtility.ToString(reader["Download_Description"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Download_File")))
{
item.Download_File = ConvertUtility.ToString(reader["Download_File"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Download_Extension")))
{
item.Download_Extension = ConvertUtility.ToString(reader["Download_Extension"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Download_Visible")))
{
item.Download_Visible = ConvertUtility.ToBoolean(reader["Download_Visible"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Download_CreateDate")))
{
item.Download_CreateDate = ConvertUtility.ToDateTime(reader["Download_CreateDate"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Download_FileSize")))
{
item.Download_FileSize = ConvertUtility.ToDouble(reader["Download_FileSize"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Download_View")))
{
item.Download_View = ConvertUtility.ToInt32(reader["Download_View"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("User_ID")))
{
item.User_ID = ConvertUtility.ToInt32(reader["User_ID"]);
}
}
catch { }
return(item);
}
public OrderDetailForm(string orderNum, string channel)
{
InitializeComponent();
this._OrderNumTxt.ReadOnly = true;
this._OrderNumTxt.Text = orderNum;
this._ChannelTxt.Text = channel;
DataRow orderHeaderDr = Db.GetOrderHeaderDrByOrderNum(orderNum, channel);
if (orderHeaderDr["ShippedDate"].ToString() != "1753-01-01 00:00:00.000")
{
this._ReprintBtn.Enabled = true;
}
else
{
this._ReprintBtn.Enabled = false;
}
if (orderHeaderDr["TrackingNum"].ToString() == "")
{
this._AddTrackingNumBtn.Enabled = true;
this._TrackingLinkLab.Visible = false;
this._TrackingAddTxt.Visible = true;
this._ShippingCarrierTxt.ReadOnly = false;
}
else
{
this._AddTrackingNumBtn.Enabled = false;
}
DataTable orderLineDt = new DataTable();
if (orderHeaderDr == null || orderHeaderDr["OrderNum"] == null)
{
MessageBox.Show("Error!! No result!!! Please contact Administrator!!!");
}
else
{
try
{
orderLineDt = Db.GetOrderLineDtByOrderNum(orderNum, channel);
this._AccountNameTxt.Text = orderHeaderDr["AccountName"].ToString();
this._BuyerUserIDTxt.Text = orderHeaderDr["BuyerUserID"].ToString();
this._OrderDateTxt.Text = orderHeaderDr["OrderDate"].ToString();
this._ShipNameTxt.Text = orderHeaderDr["ShipName"].ToString();
this._ShipEmailTxt.Text = orderHeaderDr["ShipEmail"].ToString();
this._EnterDateTxt.Text = orderHeaderDr["EnterDate"].ToString();
this._TrackingLinkLab.Text = orderHeaderDr["TrackingNum"].ToString();
this._Address1Txt.Text = orderHeaderDr["ShipAddress1"].ToString();
this._Address2Txt.Text = orderHeaderDr["ShipAddress2"].ToString();
this._ShipCityTxt.Text = orderHeaderDr["ShipCity"].ToString();
this._ShipStateTxt.Text = orderHeaderDr["ShipState"].ToString();
this._ShipZipTxt.Text = orderHeaderDr["ShipZip"].ToString();
this._ShipCountry.Text = orderHeaderDr["ShipCountry"].ToString();
this._ShipPhoneTxt.Text = orderHeaderDr["ShipPhone"].ToString();
this._ShippedDateTxt.Text = orderHeaderDr["ShippedDate"].ToString();
this._ShippingCarrierTxt.Text = orderHeaderDr["ShippingCarrier"].ToString();
this._SubTotalTxt.Text = ConvertUtility.ToDouble(orderHeaderDr["SubTotal"]).ToString();
this._ShippingFeeTxt.Text = ConvertUtility.ToDouble(orderHeaderDr["ShippingServiceCost"]).ToString() + ConvertUtility.ToDouble(orderHeaderDr["ShippingServiceAdditionalCost"]).ToString();
this._TaxTxt.Text = ConvertUtility.ToDouble(orderHeaderDr["SalesTaxAmount"]).ToString();
this._OtherFeeTxt.Text = "";
this._NoteTxt.Text = orderHeaderDr["Note"].ToString();
this._TotalTxt.Text = ConvertUtility.ToDouble(orderHeaderDr["Total"]).ToString();
this._PaidAmountTxt.Text = ConvertUtility.ToDouble(orderHeaderDr["AmountPaid"]).ToString();
if (ConvertUtility.ToDouble(orderHeaderDr["AmountPaid"]) != ConvertUtility.ToDouble(orderHeaderDr["Total"]))
{
this._PaidAmountTxt.ForeColor = Color.Red;
this._TotalTxt.ForeColor = Color.Red;
}
this._OrderLineDgv.DataSource = orderLineDt.DefaultView;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " Error!! Please contact admin for OrderDetailForm ");
}
}
}
public PropertyIndex GetPropertySearch(int pageSize, int pageIndex)
{
DateTime start = DateTime.Now;
using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=dinhgianhadat.vn;Integrated Security=True;MultipleActiveResultSets=True;"))
{
conn.Open();
SqlCommand cmd = new SqlCommand("SP_F_Property_dgnd_Search", conn);
cmd.CommandType = CommandType.StoredProcedure;
//var priceFirst = GetListPropertyPriceStatic().FirstOrDefault(r => r.Id == options.PriceId && r.AdsType == options.AdsTypeId);
//options.MinPriceProposed = priceFirst != null ? priceFirst.FromValue : options.MinPriceProposed;
//options.MaxPriceProposed = priceFirst != null ? priceFirst.ToValue : options.MaxPriceProposed;
//var areaFirst = GetListPropertyAreaStatic().FirstOrDefault(r => r.Id == options.AreaId);
//options.MinAreaTotal = areaFirst != null ? areaFirst.FromValue : options.MinAreaTotal;
//options.MaxAreaTotal = areaFirst != null ? areaFirst.ToValue : options.MaxAreaTotal;
//options.WardId = options.WardId == 0 ? -1 : options.WardId;
cmd.Parameters.AddWithValue("@pageSize", pageSize);
cmd.Parameters.AddWithValue("@pageIndex", pageIndex);
//cmd.Parameters.AddWithValue("@domainGroupId", options.DomainGroupId);
//cmd.Parameters.AddWithValue("@adsTypeId", options.AdsTypeId);
//cmd.Parameters.AddWithValue("@provinceId", options.ProvinceId);
//cmd.Parameters.AddWithValue("@districtId", options.DistrictId);
//cmd.Parameters.AddWithValue("@wardId", options.WardId);
//cmd.Parameters.AddWithValue("@streetId", options.StreetId);
//cmd.Parameters.AddWithValue("@apartmentId", options.ApartmentId);
//cmd.Parameters.AddWithValue("@directionId", options.DirectionId);
//cmd.Parameters.AddWithValue("@locationId", options.LocationId);
//cmd.Parameters.AddWithValue("@MinAreaTotal", options.MinAreaTotal);
//cmd.Parameters.AddWithValue("@MaxAreaTotal", options.MaxAreaTotal);
//cmd.Parameters.AddWithValue("@MinPriceProposed", options.MinPriceProposed);
//cmd.Parameters.AddWithValue("@MaxPriceProposed", options.MaxPriceProposed);
//NOTE: @typeCssClassesLand has been hard code in DB
//added 27/03/2016
var reader = cmd.ExecuteReader();
var model = new PropertyIndex();
model.ListProperties = new List <PropertyItem>();
reader.Read();
int total = (int)reader["TotalCount"];
model.TotalCount = total;
// gets the second
reader.NextResult();
while (reader.Read())
{
var item = new PropertyItem
{
Id = int.Parse(reader["Id"].ToString()),
Content = reader["Content"].ToString(),
Title = reader["Title"].ToString(),
Note = reader["Note"].ToString(),
Floors = ConvertUtility.ToDouble(reader["Floors"].ToString()),
Bedrooms = ConvertUtility.ToInt32(reader["Bedrooms"].ToString()),
Bathrooms = ConvertUtility.ToInt32(reader["Bathrooms"].ToString()),
AddressNumber = reader["AddressNumber"].ToString(),
AddressCorner = reader["AddressCorner"].ToString(),
CreatedDate = ConvertUtility.ToDateTime(reader["CreatedDate"].ToString(), default(DateTime)),
LastUpdatedDate = ConvertUtility.ToDateTime(reader["LastUpdatedDate"].ToString(), default(DateTime)),
AdsExpirationDate = ConvertUtility.ToDateTime(reader["AdsExpirationDate"].ToString(), default(DateTime)),
AlleyWidth = !string.IsNullOrEmpty(reader["AlleyWidth"].ToString()) ? double.Parse(reader["AlleyWidth"].ToString()) : default(double),
PriceProposed = ConvertUtility.ToDouble(reader["PriceProposed"].ToString()),
PriceProposedInVND = ConvertUtility.ToDouble(reader["PriceProposedInVND"].ToString()), //--
PriceEstimatedInVND = ConvertUtility.ToDouble(reader["PriceEstimatedInVND"].ToString()), //--
AreaUsable = ConvertUtility.ToDouble(reader["AreaUsable"].ToString()),
AreaTotalWidth = ConvertUtility.ToDouble(reader["AreaTotalWidth"].ToString()),
AreaTotalLength = ConvertUtility.ToDouble(reader["AreaTotalLength"].ToString()),
AreaTotal = ConvertUtility.ToDouble(reader["AreaTotal"].ToString()),
ApartmentId = ConvertUtility.ToInt32(reader["ApartmentId"].ToString()),
AdsType = new PropertyBase
{
ShortName = reader["AdsTypeShortName"].ToString(),
CssClass = reader["AdsTypeCssClass"].ToString(),
Id = int.Parse(reader["AdsTypeId"].ToString())
},
Location = new PropertyBase
{
Id = ConvertUtility.ToInt32(reader["LocationId"].ToString()),
CssClass = reader["LocationCssClass"].ToString(),
Name = reader["LocationName"].ToString(),
ShortName = reader["LocationShortName"].ToString()
},
PaymentMethod = new PropertyBase
{
Id = ConvertUtility.ToInt32(reader["PaymentMethodId"].ToString()),
Name = reader["PaymentMethodName"].ToString(),
CssClass = reader["PaymentMethodCssClass"].ToString(),
ShortName = reader["PaymentMethodShortName"].ToString()
},
ImageDefaultAvatar = reader["ImageDefaultAvatar"].ToString()
};
model.ListProperties.Add(item);
}
reader.Close();
return(model);
}
}
protected void cmdUpdate_Click(object sender, EventArgs e)
{
QuanLyCongViecKTXVaPSInfo info = QuanLyCongViecKTXVaPSController.GetInfo(ConvertUtility.ToInt32(txtID.Text));
if (info == null)
{
cmdEmpty_Click(null, null);
return;
}
if (info.ID == ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue))
{
lblStatusUpdate.Text = "Trung mục cha";
return;
}
string oldData = GetObjectInfo(info);
info.Ten = txtName.Text;
info.ParentID = ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue);
info.TyTrong = ConvertUtility.ToDouble(txtTyTrong.Text);
info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue);
info.KeHoach = txtKeHoach.Text;
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.ToString());
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.Update(info);
lblStatusUpdate.Text = MiscUtility.MSG_UPDATE_SUCCESS;
#region Log Action
LogFileInfo logFileInfo = new LogFileInfo();
logFileInfo.Log_Action = "Update";
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: " + oldData;
logFileInfo.Description_After = "Update KPI with info: <br />" + GetObjectInfo(info);
logFileInfo.UserName = CurrentUser.Username;
logFileInfo.UserID = CurrentUser.UserID;
CreateLogFile.LogAction(logFileInfo);
#endregion
UpdateCapDoCongViec();
}
catch (Exception ex)
{
lblStatusUpdate.Text = ex.Message;
}
Session["Nav"] = "1";
}
public static void LoadForCurItem(ListItemCollection lstItems, ListItem curItem, int idTrungTam, int idPhongBan, DateTime dt, int idDotDanhGia, int UserID)
{
int curId = ConvertUtility.ToInt32(curItem.Value);
int level = ConvertUtility.ToInt32(curItem.Attributes["Level"]);
level++;
DataTable dtChildZones = GetAllByParentID(curId, idTrungTam, idPhongBan, dt, idDotDanhGia, UserID);
if (dtChildZones == null)
{
return;
}
foreach (DataRow row in dtChildZones.Rows)
{
ListItem item = new ListItem(MiscUtility.StringIndent(level) + "(" + Math.Round(ConvertUtility.ToDouble(row["TyTrong"].ToString()), 3) + "%) " + row["Ten"].ToString(), row["ID"].ToString());
item.Attributes.Add("Level", level.ToString());
lstItems.Add(item);
LoadForCurItem(lstItems, item, idTrungTam, idPhongBan, dt, idDotDanhGia, UserID);
}
}
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 override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
#region Check authenticate
UserInfo userInfo = UserController.GetUser(idNhanVien);
if (userInfo == null)
{
Response.Redirect(AppEnv.AdminUrlParams("accessdeny"));
}
if (!CurrentUser.IsAdmin && !CurrentUser.IsSuperAdmin)
{
if (CurrentUser.UserID != 8)
{
if (CurrentUser.RoleID == (int)Constants.Role.NhanVien || CurrentUser.RoleID == (int)Constants.Role.NhanVienKD)
{
if (CurrentUser.UserID != idNhanVien)
{
Response.Redirect(AppEnv.AdminUrlParams("accessdeny"));
}
}
}
}
#endregion
DataTable dt = DotDanhGiaController.checkDanhGiaThang(idDotDanhGia, idNhanVien);
if (dt != null && dt.Rows.Count > 0)
{
#region kiem tra trang thai cua Ban danh gia
if (idNhanVien == CurrentUser.UserID)
{
if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.DaGuiDanhGiaChoTruongPhong)
{
btnSumit.Enabled = false;
btnSumit.Text = "Chờ trưởng phòng đánh giá";
}
else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.DaGuiDanhGiaChoTruongBoPhan)
{
btnSumit.Enabled = false;
btnSumit.Text = "Chờ trưởng bộ phận đánh giá";
}
else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.TruongPhongGuiLaiDanhGiaChoNhanVien)
{
btnSumit.Enabled = true;
btnSumit.Text = "Đồng ý kết quả đánh giá";
}
else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.TruongBoPhanGuiLaiDanhGiaChoNhanVien)
{
btnSumit.Enabled = true;
btnSumit.Text = "Đồng ý kết quả đánh giá";
}
else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.NhanVienDongYVoiKetQuaDanhGia)
{
if (userInfo.IDPhong > 0)
{
btnSumit.Enabled = false;
btnSumit.Text = "Chờ trưởng phòng đánh giá";
}
else
{
btnSumit.Enabled = false;
btnSumit.Text = "Chờ trưởng bộ phận đánh giá";
}
}
else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.ThongNhat)
{
btnSumit.Enabled = false;
btnSumit.Text = "Đã thống nhất kết quả đánh giá";
}
else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) <= (int)Constants.TrangThaiDanhGiaNhanVien.DangDanhGia)
{
btnSumit.Enabled = true;
btnSumit.Text = "Gửi đánh giá";
}
else
{
btnSumit.Enabled = false;
btnSumit.Text = "xu ly thieu truong hop nay";
}
//tabDVKH_DT_DP.Visible = false;
}
else
{
if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.DaGuiDanhGiaChoTruongPhong)
{
btnSumit.Enabled = true;
btnSumit.Text = "Gửi lại kết quả đánh giá cho nhân viên";
}
else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.DaGuiDanhGiaChoTruongBoPhan)
{
btnSumit.Enabled = true;
btnSumit.Text = "Gửi lại kết quả đánh giá cho nhân viên";
}
else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.NhanVienDongYVoiKetQuaDanhGia)
{
btnSumit.Enabled = true;
if (CurrentUser.RoleID == (int)Constants.Role.TruongPhong)
{
btnSumit.Text = "Thống nhất và gửi trưởng bộ phận phê duyệt";
}
else
{
btnSumit.Text = "Thống nhất kết quả";
}
}
else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.TruongBoPhanGuiLaiDanhGiaChoNhanVien)
{
btnSumit.Enabled = false;
btnSumit.Text = "Chờ nhân viên đồng ý";
}
else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.TruongPhongGuiLaiDanhGiaChoNhanVien)
{
btnSumit.Enabled = false;
btnSumit.Text = "Chờ nhân viên đồng ý";
}
else if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.ThongNhat)
{
btnSumit.Enabled = false;
btnSumit.Text = "Đã hoàn thành các kết quả đánh giá";
}
else
{
btnSumit.Enabled = false;
btnSumit.Text = "Đánh giá chưa được gửi lên";
}
}
#endregion
tableContent.Visible = true;
tableAlert.Visible = false;
#region Tong diem cua ban danh gia
DataSet ds = DotDanhGiaController.DanhGiaThang_DGCBCNVDanhGia_TongDiemCongThucMoi(idDotDanhGia, idNhanVien);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
lblTyLeHoanThanh.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[0].Rows[0]["TyLeHoanThanh"].ToString()), 2).ToString() + "%";
}
if (ds.Tables[1].Rows.Count > 0)
{
lblDiemDanhGiaDonVi.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[1].Rows[0]["TotalDiemDanhGiaDonVi"].ToString()), 2).ToString() + "%";
}
if (ds.Tables[2].Rows.Count > 0)
{
lblDiemHoanThanhLoiNhuanCongTy.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[2].Rows[0]["TotalDiemLNCgTy"]), 2).ToString() + "%";
}
if (ds.Tables[3].Rows.Count > 0)
{
lblDiemPhoiHop.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[3].Rows[0]["TotalDiemPhoiHop"]), 2).ToString() + "%";
}
if (ds.Tables[4].Rows.Count > 0)
{
lblDiemKyLuat.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[4].Rows[0]["TotalDiemKyLuat"]), 2).ToString() + "%";
}
if (ds.Tables[5].Rows.Count > 0)
{
lblDiemHoanThanhLoiNhuanBoPhan.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[5].Rows[0]["TotalDiemLNBoPhan"]), 1, MidpointRounding.AwayFromZero).ToString() + "%";
}
if (ds.Tables[6].Rows.Count > 0)
{
lblMucDoHoanThanh.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[6].Rows[0]["TongDiem"]), 1, MidpointRounding.AwayFromZero).ToString() + "%";
}
if (ds.Tables[7].Rows.Count > 0)
{
lblXepLoai.Text = ds.Tables[7].Rows[0]["XepLoai"].ToString();
}
if (ds.Tables[8].Rows.Count > 0)
{
lblName.Text = ds.Tables[8].Rows[0]["HoTen"].ToString();
}
if (ds.Tables[9].Rows.Count > 0)
{
lblDiemThuong.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[9].Rows[0]["DiemThuong"]), 2).ToString() + "%";
}
if (ds.Tables[10].Rows.Count > 0)
{
lblDiemBLDDanhGia.Text = Math.Round(ConvertUtility.ToDouble(ds.Tables[10].Rows[0]["DiemBLD"]), 2).ToString() + "%";
}
lblHeSoLuongMem.Text = GetLuongMem(lblXepLoai.Text);
#region Ty Trong Cong Viec
double totalCVTX = 0;
double totalCVKTX = 0;
double totalCVPS = 0;
double total = 0;
DataTable dtCongViecThuongXuyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(1, idDotDanhGia, idNhanVien);
foreach (DataRow item in dtCongViecThuongXuyen.Rows)
{
totalCVTX += ConvertUtility.ToDouble(item["TyTrongCV"]);
}
DataTable dtCongViecKhongThuonguyen = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(2, idDotDanhGia, idNhanVien);
foreach (DataRow item in dtCongViecKhongThuonguyen.Rows)
{
totalCVKTX += ConvertUtility.ToDouble(item["TyTrongCV"]);
}
DataTable dtCongViecPhatSinh = DanhGiaThang_DGCBCNVDanhGiaTTCVController.GetAll(3, idDotDanhGia, idNhanVien);
foreach (DataRow item in dtCongViecPhatSinh.Rows)
{
totalCVPS += ConvertUtility.ToDouble(item["TyTrongCV"]);
}
lblCVTX.Text = Math.Round(totalCVTX, 2) + "%";
lblCVKTX.Text = Math.Round(totalCVKTX, 2) + "%";
lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%";
total = totalCVTX + totalCVKTX + totalCVPS;
lblTotal.Text = Math.Round(total, 2).ToString() + "%";
lblTotal.Text = Math.Round(total, 2).ToString() + "%";
if (total > 100)
{
lblTotal.ForeColor = Color.Red;
}
double totalCVPhatSinh = Math.Round((100 - total), 2);
if (totalCVPhatSinh > 0)
{
lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%" + " còn lại " + Math.Round((100 - total), 2) + "%";
}
else
{
lblCVPhatSinh.Text = Math.Round(totalCVPS, 2) + "%";
}
#endregion
}
#endregion
}
else
{
tableContent.Visible = false;
tableAlert.Visible = true;
}
if (ConvertUtility.ToInt32(Session["Nav"]) == 1)
{
litNav.Text = "";
litNav.Text += "<ul class=\"nav nav-tabs\">";
litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>";
litNav.Text += "</ul>";
litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane active\">";
litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane\">";
litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane\">";
litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane\">";
litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane\">";
}
else if (ConvertUtility.ToInt32(Session["Nav"]) == 2)
{
litNav.Text = "";
litNav.Text += "<ul class=\"nav nav-tabs\">";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>";
litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>";
litNav.Text += "</ul>";
litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane\">";
litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane active\">";
litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane\">";
litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane\">";
litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane\">";
}
else if (ConvertUtility.ToInt32(Session["Nav"]) == 3)
{
litNav.Text = "";
litNav.Text += "<ul class=\"nav nav-tabs\">";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>";
litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>";
litNav.Text += "</ul>";
litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane\">";
litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane\">";
litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane active\">";
litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane\">";
litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane\">";
}
else if (ConvertUtility.ToInt32(Session["Nav"]) == 4)
{
litNav.Text = "";
litNav.Text += "<ul class=\"nav nav-tabs\">";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>";
litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>";
litNav.Text += "</ul>";
litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane\">";
litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane\">";
litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane\">";
litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane active\">";
litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane\">";
}
else if (ConvertUtility.ToInt32(Session["Nav"]) == 5)
{
litNav.Text = "";
litNav.Text += "<ul class=\"nav nav-tabs\">";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>";
litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>";
litNav.Text += "</ul>";
litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane\">";
litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane\">";
litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane\">";
litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane\">";
litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane active\">";
}
else
{
litNav.Text = "";
litNav.Text += "<ul class=\"nav nav-tabs\">";
litNav.Text += "<li class=\"active\"><a data-toggle=\"tab\" href=\"#tab_0\"><b>CÔNG VIỆC THƯỜNG XUYÊN</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_1\"><b>CÔNG VIỆC KẾ HOẠCH THÁNG</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_2\"><b>CÔNG VIỆC PHÁT SINH</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_3\"><b>KỶ LUẬT VÀ PHỐI HỢP</b></a></li>";
litNav.Text += "<li class=\"\"><a data-toggle=\"tab\" href=\"#tab_4\"><b>BLĐ ĐÁNH GIÁ</b></a></li>";
litNav.Text += "</ul>";
litTab0.Text = "<div id=\"tab_0\" class=\"tab-pane active\">";
litTab1.Text = "<div id=\"tab_1\" class=\"tab-pane\">";
litTab2.Text = "<div id=\"tab_2\" class=\"tab-pane\">";
litTab3.Text = "<div id=\"tab_3\" class=\"tab-pane\">";
litTab4.Text = "<div id=\"tab_4\" class=\"tab-pane\">";
}
}
protected void btnLayCongViecThangTruoc_Click(object sender, EventArgs e)
{
QuanLyCongViecKTXVaPSController.ClearAllCongViecTheoBoPhanVaDotDanhGia(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 1);
#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, 1, 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"]);
if (ConvertUtility.ToInt32(item["ID"]) == 31279)
{
string a = "a";
}
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, 1, 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 = 1;
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"] = "1";
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
var dirAvatarOriginal = AppEnv.UploadImagesOriginalDir;
const string dirAvatarNormal = AppEnv.UploadImagesNormalDir;
const string dirAvatarThumb = AppEnv.UploadImagesThumbDir;
var imgWidth = 0;
var imgHeight = 0;
double filesize = 0;
string fileAvatarPath = "", newfileAvatarName = "";
var info = new ImageInfo();
var imageCount = ContentImageDB.GetQuantityImageOfContent(_contentId);
if (txtFile.PostedFile.FileName.Length > 0)
{
//string fileAvatarName = Path.GetFileNameWithoutExtension(txtFile.PostedFile.FileName).Replace(" ", "_").Replace("#", "_");
newfileAvatarName = "image_" + _contentId + "_" + imageCount + txtFile.PostedFile.FileName.Substring(txtFile.PostedFile.FileName.LastIndexOf('.'));
var file4 = new FileInfo(Server.MapPath(AppEnv.UploadImagesNormalDir) + newfileAvatarName);
if (file4.Exists)
{
newfileAvatarName = "image_" + _contentId + "_" + imageCount + "_" + DateTime.Now.ToString("mmss") + txtFile.PostedFile.FileName.Substring(txtFile.PostedFile.FileName.LastIndexOf('.'));
}
txtFile.PostedFile.SaveAs(Server.MapPath(dirAvatarOriginal) + newfileAvatarName);
double filesizeb = txtFile.PostedFile.ContentLength;
filesize = filesizeb / 1024;
//thumbnail creation starts
// try
// {
// dinh dang width height mac dinh de scale
int smallWidth = ConvertUtility.ToInt32(AppEnv.ThumbWidth);;
int smallHeight = ConvertUtility.ToInt32(AppEnv.ThumbHeight);
int normalWidth = ConvertUtility.ToInt32(AppEnv.NormalWidth);
int normalHeight = ConvertUtility.ToInt32(AppEnv.NormalHeight);
double scalesmall = 0;
double scalenormal = 0;
string imageUrl = Server.MapPath(dirAvatarOriginal + newfileAvatarName); // xac dinh anh chuan bi thumbnail
Bitmap InputBitmap = new Bitmap(imageUrl); // tao anh bitmap
// xac dinh % de resize
imgWidth = InputBitmap.Width;
imgHeight = InputBitmap.Height;
if (smallHeight == 0)//InputBitmap.Height < InputBitmap.Width)
{
scalesmall = ((double)smallWidth) / InputBitmap.Width;
scalenormal = ((double)normalWidth) / InputBitmap.Width;
}
int newSmallWidth = 0;
int newSmallHeight = 0;
int newNormalWidth = 0;
int newNormalHeight = 0;
if (smallHeight == 0)
{
newSmallWidth = (int)(scalesmall * InputBitmap.Width);
newSmallHeight = (int)(scalesmall * InputBitmap.Height);
if (normalWidth < imgWidth)
{
newNormalWidth = (int)(scalenormal * InputBitmap.Width);
newNormalHeight = (int)(scalenormal * InputBitmap.Height);
}
else
{
newNormalWidth = imgWidth;
newNormalHeight = imgHeight;
}
}
else
{
newSmallWidth = smallWidth;
newSmallHeight = smallHeight;
newNormalWidth = normalWidth;
newNormalHeight = normalHeight;
}
Bitmap OutputBitmapSmall = new Bitmap(InputBitmap, newSmallWidth, newSmallHeight); // tao anh bitmap voi size small moi
Bitmap OutputBitmapNormal = new Bitmap(InputBitmap, newNormalWidth, newNormalHeight); // tao anh bitmap voi size normal moi
// xac dinh mime type
//Response.Clear();
//Response.ContentType="image/Jpeg";
//moi
ImageCodecInfo[] Info = ImageCodecInfo.GetImageEncoders();
EncoderParameters Params = new EncoderParameters(1);
Params.Param[0] = new EncoderParameter(Encoder.Quality, 100L);
//Response.ContentType = Info[1].MimeType;
//thumbnail.Save(Response.OutputStream,Info[1],Params);
InputBitmap.Dispose();
OutputBitmapSmall.Save(Server.MapPath(dirAvatarThumb) + newfileAvatarName, Info[1], Params);
OutputBitmapNormal.Save(Server.MapPath(dirAvatarNormal) + newfileAvatarName, Info[1], Params);
// thuc hien
OutputBitmapSmall.Dispose();
OutputBitmapNormal.Dispose();
// }
// catch(Exception ex)
// {
// Response.Write("An error occurred - " + ex.ToString());
// }
//MultimediaUtility.SetThumbnail(Server.MapPath(dirLarge + newfileoutsidename), Server.MapPath(dirThumb), ConvertUtility.ToInt32(Constants.ThumbWidth), ConvertUtility.ToInt32(Constants.ThumbHeight));
//ImageDB.CreateThumbnail(dirThumb, dirLarge + newfileoutsidename);
fileAvatarPath = dirAvatarThumb + newfileAvatarName;
//fileAvatarPath = dirAvatarOriginal + newfileAvatarName;
//MultimediaUtility.SetAvatarThumbnail(Server.MapPath(fileAvatarPath), 250, 0);
}
else
{
fileAvatarPath = "";
}
if (fileAvatarPath.Length > 0)
{
if (txtName.Text.Length > 0)
{
info.Image_Name = ConvertUtility.ToString(txtName.Text);
}
else
{
info.Image_Name = newfileAvatarName;
}
info.Image_Description = txtTeaser.Text;
info.Image_File = fileAvatarPath;
info.Image_CreateDate = DateTime.Now;
info.Image_FileSize = ConvertUtility.ToDouble(filesize.ToString("#0.00"));
info.Image_Width = imgWidth;
info.Image_Height = imgHeight;
info.Image_View = 0;
info.User_ID = ConvertUtility.ToInt32(ckid);
info.Image_Visible = chkVisible.Checked;
try
{
var imgId = ImageDB.Insert(info);
var contentImgInfo = new ContentImageInfo();
contentImgInfo.Content_ID = _contentId;
contentImgInfo.Image_ID = imgId;
if (imageCount == 0)
{
contentImgInfo.IsCover = true;
}
else
{
contentImgInfo.IsCover = false;
}
contentImgInfo.Priority = imageCount;
ContentImageDB.Insert(contentImgInfo);
Response.Redirect(Request.RawUrl + "#idTab2");
lblStatusUpdate.Text = lblStatusUpdate2.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblStatusUpdate.Text = lblStatusUpdate2.Text = MiscUtility.UPDATE_ERROR;
}
}
}
protected void btnThemMoi3_Click(object sender, EventArgs e)
{
Session["Nav"] = "3";
DanhGiaThang_DGCBCNVDanhGiaTTCVInfo info = new DanhGiaThang_DGCBCNVDanhGiaTTCVInfo();
info.IDDotDanhGia = idDotDanhGia;
info.IDNhanVien = idNhanVien;
info.TenCongViec = txtTenCongViec3.Text.Trim();
info.SoLieuCamKet = ConvertUtility.ToString(txtSoLieuCamKet3.Text);
info.SoLieuThucHienThucTeTrongThang = txtSoLieuThucHienThucTeTrongThang3.Text;
info.NhanVienDanhGiaTyLeHoanThanh = ConvertUtility.ToDouble(dropTyLeHoanThanh.SelectedValue);
if (info.NhanVienDanhGiaTyLeHoanThanh > 100)
{
info.NhanVienDanhGiaTyLeHoanThanh = 100;
}
if (info.NhanVienDanhGiaTyLeHoanThanh < 0)
{
info.NhanVienDanhGiaTyLeHoanThanh = 0;
}
info.TBPDanhGia = info.NhanVienDanhGiaTyLeHoanThanh;
if (info.TBPDanhGia > 100)
{
info.TBPDanhGia = 100;
}
if (info.TBPDanhGia < 0)
{
info.TBPDanhGia = 0;
}
info.YeuCauHoTro = ConvertUtility.ToString(txtYeuCauCanHoTro3.Text);
info.YKienCuaNhanVien = ConvertUtility.ToString(txtYKienCuaNhanVien3.Text);
info.YKienCuaTBP = "";
info.Loai = 3;
info.SoGio = ConvertUtility.ToDouble(txtSoGio.Text);
info.TyTrongCV = ConvertUtility.ToDouble(info.SoGio * 100 / 176);
int idCongViec = DanhGiaThang_DGCBCNVDanhGiaTTCVController.Insert(info);
//foreach (ListItem item in dropBoPhanHoTro.Items)
//{
// if (item.Selected)
// {
// DanhGiaThang_DGCBCNVDanhGiaTTCVController.UpdateKeHoachThangBoPhanHoTro(idDotDanhGia, idCongViec, ConvertUtility.ToInt32(item.Value));
// }
// else
// {
// DanhGiaThang_DGCBCNVDanhGiaTTCVController.DeleteKeHoachThangBoPhanHoTro(idDotDanhGia, idCongViec, ConvertUtility.ToInt32(item.Value));
// }
//}
if (dt == null)
{
dt = DotDanhGiaController.checkDanhGiaThang(idDotDanhGia, idNhanVien);
}
if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) <= (int)Constants.TrangThaiDanhGiaNhanVien.DangDanhGia)
{
if (CurrentUser.RoleID != (int)Constants.Role.NhanVien && CurrentUser.RoleID != (int)Constants.Role.NhanVienKD)
{
UserInfo infoUser = UserController.GetUser(idNhanVien);
if (infoUser != null)
{
bool value = EmailUtility.DoSendMail(infoUser.EmailVNG, "", "Mail nhắc nhở nhân viên hoàn thành công việc phát sinh", "Yêu cầu bạn hoàn thành công việc phát sinh theo deadline. Mọi người vào phần đánh giá - Công việc phát sinh để xem công việc phải làm");
}
}
}
}
protected void cmdAdd_Click(object sender, EventArgs e)
{
QuanLyCongViecBaoCaoNgayInfo info = new QuanLyCongViecBaoCaoNgayInfo();
info.IDCongViecKPI = ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue);
info.Ten = txtName.Text;
info.KeHoach = txtKeHoach.Text;
info.ParentID = txtCongViecLon.Text;
info.TyTrong = 0;// ConvertUtility.ToDouble(txtTyTrong.Text);
info.KetQua = txtKetqua.Text;
info.TyLeHoanThanh = dropTyLeHoanThanh.SelectedValue;
info.IDTrungTam = CurrentUser.IDTrungTam;
info.IDPhongBan = CurrentUser.IDPhong;
info.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
info.SoGio = ConvertUtility.ToDouble(txtSoGio.Text);
info.CreateBy = CurrentUser.UserID;
info.LyDo = txtLyDo.Text;
info.DeXuat = txtDeXuat.Text;
info.CreatedOn = new DateTime(ConvertUtility.ToInt32(dropYear.SelectedValue), ConvertUtility.ToInt32(dropMonth.SelectedValue), ConvertUtility.ToInt32(dropDay.SelectedValue));
try
{
QuanLyCongViecBaoCaoNgayController.Insert(info);
#region Log Action
LogFileInfo logFileInfo = new LogFileInfo();
logFileInfo.Log_Action = "Add";
logFileInfo.Log_Type_Object = "QuanLyCongViecKPITheoNgay";
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;
if (ConvertUtility.ToInt32(dropCongViecKPI.SelectedValue) == 0)
{
//them vao cong viec phat sinh
DanhGiaThang_DGCBCNVDanhGiaTTCVInfo infoCVPhatSinh = new DanhGiaThang_DGCBCNVDanhGiaTTCVInfo();
infoCVPhatSinh.IDDotDanhGia = ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue);
infoCVPhatSinh.IDNhanVien = CurrentUser.UserID;
infoCVPhatSinh.TenCongViec = txtName.Text;
infoCVPhatSinh.TyTrongCV = 0;// ConvertUtility.ToDouble(txtTyTrong.Text);
infoCVPhatSinh.SoLieuCamKet = txtKeHoach.Text;
infoCVPhatSinh.SoLieuThucHienThucTeTrongThang = txtKetqua.Text;
infoCVPhatSinh.NhanVienDanhGiaTyLeHoanThanh = ConvertUtility.ToDouble(dropTyLeHoanThanh.SelectedValue);
if (infoCVPhatSinh.NhanVienDanhGiaTyLeHoanThanh > 100)
{
infoCVPhatSinh.NhanVienDanhGiaTyLeHoanThanh = 100;
}
if (infoCVPhatSinh.NhanVienDanhGiaTyLeHoanThanh < 0)
{
infoCVPhatSinh.NhanVienDanhGiaTyLeHoanThanh = 0;
}
infoCVPhatSinh.YeuCauHoTro = "";
infoCVPhatSinh.YKienCuaNhanVien = "";
infoCVPhatSinh.YKienCuaTBP = "";
infoCVPhatSinh.Loai = 3;
infoCVPhatSinh.SoGio = ConvertUtility.ToDouble(txtSoGio.Text);
DanhGiaThang_DGCBCNVDanhGiaTTCVController.Insert(infoCVPhatSinh);
}
}
catch (Exception ex)
{
lblStatusUpdate.Text = ex.Message;
}
}
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 btnUpdateDiem2_Click(object sender, EventArgs e)
{
Session["Nav"] = "2";
foreach (GridViewRow row in dgrKhoiLuongCV2.Rows)
{
Label txtTenCongViec = (Label)row.FindControl("txtTenCongViec");
TextBox txtTyTrongCV = (TextBox)row.FindControl("txtTyTrongCV");
TextBox txtThoiGian = (TextBox)row.FindControl("txtThoiGian");
Label txtSoLieuCamKet = (Label)row.FindControl("txtSoLieuCamKet");
TextBox txtSoLieuThucHienThucTeTrongThang = (TextBox)row.FindControl("txtSoLieuThucHienThucTeTrongThang");
TextBox txtNhanVienDanhGiaTyLeHoanThanh = (TextBox)row.FindControl("txtNhanVienDanhGiaTyLeHoanThanh");
Label txtYeuCauHoTro = (Label)row.FindControl("txtYeuCauHoTro");
TextBox txtTBPDanhGia = (TextBox)row.FindControl("txtTBPDanhGia");
TextBox txtYKienCuaNhanVien = (TextBox)row.FindControl("txtYKienCuaNhanVien");
TextBox txtYKienCuaTBP = (TextBox)row.FindControl("txtYKienCuaTBP");
ListBox dropBoPhanHoTro = (ListBox)row.FindControl("dropBoPhanHoTro");
Label txtID = (Label)row.FindControl("txtID");
Label lblIDBoPhan = (Label)row.FindControl("lblIDBoPhan");
Label lblIDBoPhanHoTro = (Label)row.FindControl("lblIDBoPhanHoTro");
Label lblIDPhongBan = (Label)row.FindControl("lblIDPhongBan");
Label txtIdCongViec = (Label)row.FindControl("txtIdCongViec");
DanhGiaThang_DGCBCNVDanhGiaTTCVInfo info = new DanhGiaThang_DGCBCNVDanhGiaTTCVInfo();
info.ID = ConvertUtility.ToInt32(txtID.Text);
info.IDDotDanhGia = idDotDanhGia;
info.IDNhanVien = idNhanVien;
info.TenCongViec = txtTenCongViec.Text.Trim();
info.SoGio = ConvertUtility.ToDouble(txtThoiGian.Text);
info.TyTrongCV = ConvertUtility.ToDouble(info.SoGio * 100 / 176);
info.SoLieuCamKet = ConvertUtility.ToString(txtSoLieuCamKet.Text);
info.SoLieuThucHienThucTeTrongThang = txtSoLieuThucHienThucTeTrongThang.Text;
info.NhanVienDanhGiaTyLeHoanThanh = ConvertUtility.ToDouble(txtNhanVienDanhGiaTyLeHoanThanh.Text);
if (info.NhanVienDanhGiaTyLeHoanThanh < 0)
{
info.NhanVienDanhGiaTyLeHoanThanh = 0;
}
if (CurrentUser.RoleID != (int)Constants.Role.TruongBoPhanKhoiHoTro && CurrentUser.RoleID != (int)Constants.Role.TruongBoPhanKhoiKinhDoanh)
{
if (CurrentUser.UserID == idNhanVien)
{
info.TBPDanhGia = info.NhanVienDanhGiaTyLeHoanThanh;
}
else
{
info.TBPDanhGia = ConvertUtility.ToDouble(txtTBPDanhGia.Text);
}
}
else
{
info.TBPDanhGia = ConvertUtility.ToDouble(txtTBPDanhGia.Text);
}
if (info.TBPDanhGia < 0)
{
info.TBPDanhGia = 0;
}
info.YeuCauHoTro = ConvertUtility.ToString(txtYeuCauHoTro.Text);
info.YKienCuaNhanVien = ConvertUtility.ToString(txtYKienCuaNhanVien.Text);
info.YKienCuaTBP = ConvertUtility.ToString(txtYKienCuaTBP.Text);
info.Loai = 2;
info.IDCongViec = ConvertUtility.ToInt32(txtIdCongViec.Text);
info.IDBoPhan = ConvertUtility.ToInt32(lblIDBoPhan.Text);
info.IDBoPhanHoTro = ConvertUtility.ToInt32(dropBoPhanHoTro.SelectedValue);
info.IDPhongBan = ConvertUtility.ToInt32(lblIDPhongBan.Text);
DanhGiaThang_DGCBCNVDanhGiaTTCVController.Update(info);
foreach (ListItem item in dropBoPhanHoTro.Items)
{
if (item.Selected)
{
DanhGiaThang_DGCBCNVDanhGiaTTCVController.UpdateKeHoachThangBoPhanHoTro(idDotDanhGia, ConvertUtility.ToInt32(txtIdCongViec.Text), ConvertUtility.ToInt32(item.Value));
}
else
{
DanhGiaThang_DGCBCNVDanhGiaTTCVController.DeleteKeHoachThangBoPhanHoTro(idDotDanhGia, ConvertUtility.ToInt32(txtIdCongViec.Text), ConvertUtility.ToInt32(item.Value));
}
}
}
if (CurrentUser.RoleID != (int)Constants.Role.NhanVien && CurrentUser.RoleID != (int)Constants.Role.NhanVienKD)
{
DataTable dt = DotDanhGiaController.checkDanhGiaThang(idDotDanhGia, idNhanVien);
if (dt != null && dt.Rows.Count > 0)
{
if (ConvertUtility.ToInt32(dt.Rows[0]["TrangThai"]) == (int)Constants.TrangThaiDanhGiaNhanVien.ThongNhat)
{
UserInfo userInfo = UserController.GetUser(idNhanVien);
EmailUtility.DoSendMail(userInfo.EmailVNG, "", "Trưởng bộ phận/Trưởng Phòng đã thống nhất bảng đánh giá tháng", "TBP/TP (" + CurrentUser.EmailVNG + ") đã cập nhật điểm công việc kế hoạch tháng của bạn. Đề nghị bạn đăng nhập phần mềm để xem kết quả đánh giá.");
}
}
}
//if (dgrKhoiLuongCV2.Rows.Count > 0)
//{
// Response.Write("<script>javascript:alert('Bạn đã cập nhật thông tin thành công');</script>");
//}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
DataTable dtUsers;
if (CurrentUser.IsAdmin || CurrentUser.IsSuperAdmin)
{
dtUsers = CommonController.BaoCaoXepLoaiDanhGiaCaNhanThang(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue), ConvertUtility.ToInt32(dropPhongBan.SelectedValue), ConvertUtility.ToInt32(dropChucVu.SelectedValue), ConvertUtility.ToInt32(dropTrangThai.SelectedValue));
}
else
{
dtUsers = CommonController.BaoCaoXepLoaiDanhGiaCaNhanThang(ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue), ConvertUtility.ToInt32(dropPhongBan.SelectedValue), ConvertUtility.ToInt32(dropChucVu.SelectedValue), ConvertUtility.ToInt32(dropTrangThai.SelectedValue), CurrentUser.UserID);
}
DataTable dtUsersTemp = new DataTable();
dtUsersTemp.Columns.Add("UserID", typeof(string));
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);
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);
TongDiemDGCV = Math.Round(TongDiemDGCV, 2, MidpointRounding.AwayFromZero);
TongDiemDGCV1 = (((DiemDGCV * 5) + (DiemCLCV) + (DiemTDCV))) / 7;
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["UserID"] = item["UserID"];
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);
row["Điểm kỷ luật và văn hóa doanh nghiệp"] = Math.Round(diemKyLuat1, 2, MidpointRounding.AwayFromZero);
row["Điểm đồng nghiệp đánh giá"] = Math.Round(DiemDongNghiepDanhGia1, 2, MidpointRounding.AwayFromZero);
row["Tổng điểm"] = Math.Round(TongDiem, 2, MidpointRounding.AwayFromZero);
row["Xếp loại"] = xepLoai;
dtUsersTemp.Rows.Add(row);
}
}
//-------sort----------
DataView dv = new DataView(dtUsersTemp);
if (ViewState["sortExpression"] != null && ViewState["sortExpression"].ToString() != string.Empty)
{
dv.Sort = ViewState["sortExpression"].ToString();
}
if (ViewState["sortDirection"] != null && ViewState["sortDirection"].ToString() == "Desc")
{
dv.Sort = ViewState["sortExpression"].ToString() + " " + ViewState["sortDirection"].ToString();
}
//--------sort-------------
dtgUsers.DataSource = dv;
dtgUsers.RowDataBound += new GridViewRowEventHandler(dtgUsers_RowDataBound);
dtgUsers.DataBind();
if (dtUsers != null)
{
lblTotalTop.Text = lblTotalBottom.Text = dtUsers.Rows.Count.ToString();
}
}
private XmlDocument BuildXmlDocument(DataTable dtDataOfNhanVien, XmlDocument xmlDoc, XmlElement tableNode, int stt, string ten)
{
#region Table Node
DataRow[] Thang1 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '1'");
DataRow[] Thang2 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '2'");
DataRow[] Thang3 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '3'");
DataRow[] Thang4 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '4'");
DataRow[] Thang5 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '5'");
DataRow[] Thang6 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '6'");
DataRow[] Thang7 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '7'");
DataRow[] Thang8 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '8'");
DataRow[] Thang9 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '9'");
DataRow[] Thang10 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '10'");
DataRow[] Thang11 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '11'");
DataRow[] Thang12 = dtDataOfNhanVien.Select("Nam = '" + dropNam.SelectedValue + "' and Thang = '12'");
XmlElement Table = xmlDoc.CreateElement("Table");
XmlElement STTNode = xmlDoc.CreateElement("STT");
XmlText STTNodeText = xmlDoc.CreateTextNode(stt.ToString());
STTNode.AppendChild(STTNodeText);
XmlElement HoTenNode = xmlDoc.CreateElement("HoTen");
XmlText HoTenNodeText = xmlDoc.CreateTextNode(ten);
HoTenNode.AppendChild(HoTenNodeText);
XmlElement Thang1DiemNode = xmlDoc.CreateElement("Thang1Diem");
XmlText Thang1DiemNodeText = xmlDoc.CreateTextNode(Thang1.Length > 0 ? (ConvertUtility.ToDouble(Thang1[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang1DiemNode.AppendChild(Thang1DiemNodeText);
XmlElement Thang1XepLoaiNode = xmlDoc.CreateElement("Thang1XepLoai");
XmlText Thang1XepLoaiNodeText = xmlDoc.CreateTextNode(Thang1.Length > 0 ? Thang1[0]["XepLoai"].ToString() : "");
Thang1XepLoaiNode.AppendChild(Thang1XepLoaiNodeText);
XmlElement Thang2DiemNode = xmlDoc.CreateElement("Thang2Diem");
XmlText Thang2DiemNodeText = xmlDoc.CreateTextNode(Thang2.Length > 0 ? (ConvertUtility.ToDouble(Thang2[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang2DiemNode.AppendChild(Thang2DiemNodeText);
XmlElement Thang2XepLoaiNode = xmlDoc.CreateElement("Thang2XepLoai");
XmlText Thang2XepLoaiNodeText = xmlDoc.CreateTextNode(Thang2.Length > 0 ? Thang2[0]["XepLoai"].ToString() : "");
Thang2XepLoaiNode.AppendChild(Thang2XepLoaiNodeText);
XmlElement Thang3DiemNode = xmlDoc.CreateElement("Thang3Diem");
XmlText Thang3DiemNodeText = xmlDoc.CreateTextNode(Thang3.Length > 0 ? (ConvertUtility.ToDouble(Thang3[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang3DiemNode.AppendChild(Thang3DiemNodeText);
XmlElement Thang3XepLoaiNode = xmlDoc.CreateElement("Thang3XepLoai");
XmlText Thang3XepLoaiNodeText = xmlDoc.CreateTextNode(Thang3.Length > 0 ? Thang3[0]["XepLoai"].ToString() : "");
Thang3XepLoaiNode.AppendChild(Thang3XepLoaiNodeText);
XmlElement Thang4DiemNode = xmlDoc.CreateElement("Thang4Diem");
XmlText Thang4DiemNodeText = xmlDoc.CreateTextNode(Thang4.Length > 0 ? (ConvertUtility.ToDouble(Thang4[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang4DiemNode.AppendChild(Thang4DiemNodeText);
XmlElement Thang4XepLoaiNode = xmlDoc.CreateElement("Thang4XepLoai");
XmlText Thang4XepLoaiNodeText = xmlDoc.CreateTextNode(Thang4.Length > 0 ? Thang4[0]["XepLoai"].ToString() : "");
Thang4XepLoaiNode.AppendChild(Thang4XepLoaiNodeText);
XmlElement Thang5DiemNode = xmlDoc.CreateElement("Thang5Diem");
XmlText Thang5DiemNodeText = xmlDoc.CreateTextNode(Thang5.Length > 0 ? (ConvertUtility.ToDouble(Thang5[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang5DiemNode.AppendChild(Thang5DiemNodeText);
XmlElement Thang5XepLoaiNode = xmlDoc.CreateElement("Thang5XepLoai");
XmlText Thang5XepLoaiNodeText = xmlDoc.CreateTextNode(Thang5.Length > 0 ? Thang5[0]["XepLoai"].ToString() : "");
Thang5XepLoaiNode.AppendChild(Thang5XepLoaiNodeText);
XmlElement Thang6DiemNode = xmlDoc.CreateElement("Thang6Diem");
XmlText Thang6DiemNodeText = xmlDoc.CreateTextNode(Thang6.Length > 0 ? (ConvertUtility.ToDouble(Thang6[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang6DiemNode.AppendChild(Thang6DiemNodeText);
XmlElement Thang6XepLoaiNode = xmlDoc.CreateElement("Thang6XepLoai");
XmlText Thang6XepLoaiNodeText = xmlDoc.CreateTextNode(Thang6.Length > 0 ? Thang6[0]["XepLoai"].ToString() : "");
Thang6XepLoaiNode.AppendChild(Thang6XepLoaiNodeText);
XmlElement Thang7DiemNode = xmlDoc.CreateElement("Thang7Diem");
XmlText Thang7DiemNodeText = xmlDoc.CreateTextNode(Thang7.Length > 0 ? (ConvertUtility.ToDouble(Thang7[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang7DiemNode.AppendChild(Thang7DiemNodeText);
XmlElement Thang7XepLoaiNode = xmlDoc.CreateElement("Thang7XepLoai");
XmlText Thang7XepLoaiNodeText = xmlDoc.CreateTextNode(Thang7.Length > 0 ? Thang7[0]["XepLoai"].ToString() : "");
Thang7XepLoaiNode.AppendChild(Thang7XepLoaiNodeText);
XmlElement Thang8DiemNode = xmlDoc.CreateElement("Thang8Diem");
XmlText Thang8DiemNodeText = xmlDoc.CreateTextNode(Thang8.Length > 0 ? (ConvertUtility.ToDouble(Thang8[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang8DiemNode.AppendChild(Thang8DiemNodeText);
XmlElement Thang8XepLoaiNode = xmlDoc.CreateElement("Thang8XepLoai");
XmlText Thang8XepLoaiNodeText = xmlDoc.CreateTextNode(Thang8.Length > 0 ? Thang8[0]["XepLoai"].ToString() : "");
Thang8XepLoaiNode.AppendChild(Thang8XepLoaiNodeText);
XmlElement Thang9DiemNode = xmlDoc.CreateElement("Thang9Diem");
XmlText Thang9DiemNodeText = xmlDoc.CreateTextNode(Thang9.Length > 0 ? (ConvertUtility.ToDouble(Thang9[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang9DiemNode.AppendChild(Thang9DiemNodeText);
XmlElement Thang9XepLoaiNode = xmlDoc.CreateElement("Thang9XepLoai");
XmlText Thang9XepLoaiNodeText = xmlDoc.CreateTextNode(Thang9.Length > 0 ? Thang9[0]["XepLoai"].ToString() : "");
Thang9XepLoaiNode.AppendChild(Thang9XepLoaiNodeText);
XmlElement Thang10DiemNode = xmlDoc.CreateElement("Thang10Diem");
XmlText Thang10DiemNodeText = xmlDoc.CreateTextNode(Thang10.Length > 0 ? (ConvertUtility.ToDouble(Thang10[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang10DiemNode.AppendChild(Thang10DiemNodeText);
XmlElement Thang10XepLoaiNode = xmlDoc.CreateElement("Thang10XepLoai");
XmlText Thang10XepLoaiNodeText = xmlDoc.CreateTextNode(Thang10.Length > 0 ? Thang10[0]["XepLoai"].ToString() : "");
Thang10XepLoaiNode.AppendChild(Thang10XepLoaiNodeText);
XmlElement Thang11DiemNode = xmlDoc.CreateElement("Thang11Diem");
XmlText Thang11DiemNodeText = xmlDoc.CreateTextNode(Thang11.Length > 0 ? (ConvertUtility.ToDouble(Thang11[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang11DiemNode.AppendChild(Thang11DiemNodeText);
XmlElement Thang11XepLoaiNode = xmlDoc.CreateElement("Thang11XepLoai");
XmlText Thang11XepLoaiNodeText = xmlDoc.CreateTextNode(Thang11.Length > 0 ? Thang11[0]["XepLoai"].ToString() : "");
Thang11XepLoaiNode.AppendChild(Thang11XepLoaiNodeText);
XmlElement Thang12DiemNode = xmlDoc.CreateElement("Thang12Diem");
XmlText Thang12DiemNodeText = xmlDoc.CreateTextNode(Thang12.Length > 0 ? (ConvertUtility.ToDouble(Thang12[0]["MucDoHoanThanh"].ToString()) / 100).ToString().Replace(",", ".") : "0");
Thang12DiemNode.AppendChild(Thang12DiemNodeText);
XmlElement Thang12XepLoaiNode = xmlDoc.CreateElement("Thang12XepLoai");
XmlText Thang12XepLoaiNodeText = xmlDoc.CreateTextNode(Thang12.Length > 0 ? Thang12[0]["XepLoai"].ToString(): "");
Thang12XepLoaiNode.AppendChild(Thang12XepLoaiNodeText);
Table.AppendChild(STTNode);
Table.AppendChild(HoTenNode);
Table.AppendChild(Thang1DiemNode);
Table.AppendChild(Thang1XepLoaiNode);
Table.AppendChild(Thang2DiemNode);
Table.AppendChild(Thang2XepLoaiNode);
Table.AppendChild(Thang3DiemNode);
Table.AppendChild(Thang3XepLoaiNode);
Table.AppendChild(Thang4DiemNode);
Table.AppendChild(Thang4XepLoaiNode);
Table.AppendChild(Thang5DiemNode);
Table.AppendChild(Thang5XepLoaiNode);
Table.AppendChild(Thang6DiemNode);
Table.AppendChild(Thang6XepLoaiNode);
Table.AppendChild(Thang7DiemNode);
Table.AppendChild(Thang7XepLoaiNode);
Table.AppendChild(Thang8DiemNode);
Table.AppendChild(Thang8XepLoaiNode);
Table.AppendChild(Thang9DiemNode);
Table.AppendChild(Thang9XepLoaiNode);
Table.AppendChild(Thang10DiemNode);
Table.AppendChild(Thang10XepLoaiNode);
Table.AppendChild(Thang11DiemNode);
Table.AppendChild(Thang11XepLoaiNode);
Table.AppendChild(Thang12DiemNode);
Table.AppendChild(Thang12XepLoaiNode);
#endregion
tableNode.AppendChild(Table);
return(xmlDoc);
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
dropDotDanhGia.DataSource = DotDanhGiaController.GetAll(1);
dropDotDanhGia.DataBind();
if (Session["IDDotDanhGia"] != null)
{
dropDotDanhGia.SelectedValue = Session["IDDotDanhGia"].ToString();
}
else
{
int idDotDanhActive = ConvertUtility.ToInt32(DotDanhGiaController.GetDaultDotDanhGia().Rows[0]["ID"]);
dropDotDanhGia.SelectedValue = idDotDanhActive.ToString();
}
dropTrungTam.DataSource = BoPhanController.GetAll();
dropTrungTam.DataBind();
if (Session["IDTrungTam"] != null)
{
dropTrungTam.SelectedValue = Session["IDTrungTam"].ToString();
}
else
{
dropTrungTam.SelectedValue = CurrentUser.IDTrungTam.ToString();
}
DataTable dtPhong;
if (!CurrentUser.IsAdmin && !CurrentUser.IsSuperAdmin)
{
dropTrungTam.Enabled = false;
if (CurrentUser.RoleID != (int)Constants.Role.TruongBoPhanKhoiHoTro && CurrentUser.RoleID != (int)Constants.Role.TruongBoPhanKhoiKinhDoanh)
{
dtPhong = DotDanhGiaController.GetAllPhongBan(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), CurrentUser.UserID);
}
else
{
dtPhong = DotDanhGiaController.GetAllPhongBan(ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
}
}
else
{
dtPhong = DotDanhGiaController.GetAllPhongBan(ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
}
lstNhanVien.Items.Clear();
DataTable dtNhanVien = null;
if (!CurrentUser.IsAdmin && !CurrentUser.IsSuperAdmin)
{
dtNhanVien = DotDanhGiaController.QuanLyNhanVienTheoNDG_ByNhanVienQuanLy(CurrentUser.UserID, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue), ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
}
else
{
dtNhanVien = DotDanhGiaController.GetAllNhanVien(ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
}
if (dtNhanVien != null && dtNhanVien.Rows.Count > 0)
{
DataTable dtNew = dtNhanVien.Clone();
foreach (DataRow item in dtNhanVien.Rows)
{
DataRow rowNew = dtNew.NewRow();
rowNew["UserID"] = item["UserID"];
DataTable dtCongViec = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS_6_11_2014(ConvertUtility.ToInt32(item["UserID"]), 2, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
double tyTrongCVDuocGiao = 0;
foreach (DataRow row in dtCongViec.Rows)
{
tyTrongCVDuocGiao += Math.Round(ConvertUtility.ToDouble(row["TyTrong"]), 3);
}
rowNew["UserName"] = "******" + tyTrongCVDuocGiao + "%) " + item["UserName"].ToString();
dtNew.Rows.Add(rowNew);
}
lstNhanVien.DataSource = dtNew;
lstNhanVien.DataBind();
int idNhanVien = 0;
if (Session["IDNhanVien"] != null)
{
idNhanVien = ConvertUtility.ToInt32(Session["IDNhanVien"]);
try
{
lstNhanVien.SelectedValue = idNhanVien.ToString();
}
catch
{
}
}
lstCongViecDuocGiao.Items.Clear();
QuanLyCongViecKTXVaPSController.LoadCongViec(lstCongViecDuocGiao.Items, ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0, 2, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
lstCongViec.Items.Clear();
QuanLyCongViecKTXVaPSController.LoadCongViecChuaDuocGiao(lstCongViec.Items, ConvertUtility.ToInt32(dropTrungTam.SelectedValue), 0, 2, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
if (idNhanVien > 0)
{
DataTable dtCongViecTX = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS_6_11_2014(idNhanVien, 2, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
DataTable dtCongViecTXNew = dtCongViecTX.Clone();
try
{
lstNhanVien.SelectedValue = idNhanVien.ToString();
}
catch (Exception)
{
lstNhanVien.SelectedIndex = -1;
}
#region Cong Viec Thuong Xuyen
foreach (ListItem item in lstCongViecDuocGiao.Items)
{
if (dtCongViecTX.Select("IDCongViecKPI = " + item.Value).Length > 0)
{
item.Attributes.Add("style", "color:blue");
}
}
foreach (DataRow item in dtCongViecTX.Rows)
{
DataRow row = dtCongViecTXNew.NewRow();
row["ID"] = ConvertUtility.ToString(item["ID"]);
row["TenCVCha"] = ConvertUtility.ToString(item["TenCVCha"]);
row["Ten"] = item["Ten"];
row["NgayBatDau"] = ConvertUtility.ToDateTime(item["NgayBatDau"]); //.ToString("dd/MM/yyyy");
row["NgayKetThuc"] = ConvertUtility.ToDateTime(item["NgayKetThuc"]); //.ToString("dd/MM/yyyy");
row["KeHoach"] = item["KeHoach"].ToString().Replace("\n", "<br /><br />").Replace("\r", "<br /><br />");
row["TyTrong"] = Math.Round(ConvertUtility.ToDouble(item["TyTrong"]), 2).ToString();
row["SoGio"] = Math.Round(ConvertUtility.ToDouble(item["SoGio"]), 2).ToString();
dtCongViecTXNew.Rows.Add(row);
}
dgrNhanVienCVKHT.DataSource = dtCongViecTXNew;
#endregion
#region ty trong cong viec da giao
DataTable dtCongViecThuongXuyen = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS(idNhanVien, 1, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
double tyTrongCVThuongXuyen = 0;
double SoGioCVThuongXuyen = 0;
foreach (DataRow item in dtCongViecThuongXuyen.Rows)
{
tyTrongCVThuongXuyen += ConvertUtility.ToDouble(item["TyTrong"]);
SoGioCVThuongXuyen += ConvertUtility.ToDouble(item["SoGio"]);
}
DataTable dtCongViecKTH = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS(idNhanVien, 2, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
double tyTrongCVKeHoachThang = 0;
double SoGioCVKeHoachThang = 0;
foreach (DataRow item in dtCongViecKTH.Rows)
{
tyTrongCVKeHoachThang += ConvertUtility.ToDouble(item["TyTrong"]);
SoGioCVKeHoachThang += ConvertUtility.ToDouble(item["SoGio"]);
}
DataTable dtCongViecPhatSinh = DotDanhGiaController.GetAllCongViecGiaoChoNhanVienKTXVaPS(idNhanVien, 3, ConvertUtility.ToInt32(dropDotDanhGia.SelectedValue));
double tyTrongCVPhatSinh = 0;
double SoGioCVPhatSinh = 0;
foreach (DataRow item in dtCongViecPhatSinh.Rows)
{
tyTrongCVPhatSinh += ConvertUtility.ToDouble(item["TyTrong"]);
SoGioCVPhatSinh += ConvertUtility.ToDouble(item["SoGio"]);
}
lblTyTrongCVThuongXuyen.Text = Math.Round(tyTrongCVThuongXuyen, 2).ToString() + "% <br/>" + Math.Round(SoGioCVThuongXuyen, 2).ToString() + "h";
lblTyTrongCVKeHoachThang.Text = Math.Round(tyTrongCVKeHoachThang, 2).ToString() + "% <br/>" + Math.Round(SoGioCVKeHoachThang, 2).ToString() + "h";
lblTyTrongCVPhatSinh.Text = Math.Round(tyTrongCVPhatSinh, 2).ToString() + "% <br/>" + Math.Round(SoGioCVPhatSinh, 2).ToString() + "h";
lblTongTyTrong.Text = Math.Round((tyTrongCVThuongXuyen + tyTrongCVKeHoachThang + tyTrongCVPhatSinh), 2) + "% <br />" + Math.Round((SoGioCVThuongXuyen + SoGioCVKeHoachThang + SoGioCVPhatSinh), 2) + "h";
#endregion
}
}
dgrNhanVienCVKHT.DataBind();
}
void ButtonOkClick(object sender, EventArgs e)
{
item.Discount = ConvertUtility.ToDouble(textBoxDiscount.Text);
DialogResult = DialogResult.OK;
Close();
}
protected void butSubmit_Click(object sender, EventArgs e)
{
if (chkAgree.Checked)
{
var fullname = HTMLUtility.SecureHTML(txtFullName.Text.Trim());
var tel = HTMLUtility.SecureHTML(txtTel.Text.Trim());
var address = HTMLUtility.SecureHTML(txtAddress.Text.Trim());
var district = HTMLUtility.SecureHTML(txtDistrict.Text.Trim());
var city = HTMLUtility.SecureHTML(txtCity.Text.Trim());
var note = HTMLUtility.SecureHTML(txtNote.Text.Trim());
var orderdate = DateTime.Now;
if (fullname.Length == 0 || tel.Length == 0 || address.Length == 0 || district.Length == 0 || city.Length == 0)
{
MessageBox.Show("Bạn phải điền đủ các trường (*)");
return;
}
var cart = (CommonLibrary.CartShopping.Cart)Session["cart"];
string email = CookieUtility.GetCookie("Member_Email");
var totalprice = cart.TotalPrice;
var memberInfo = MemberDB.GetInfoByEmail(email);
if (memberInfo.Member_Fullname.Length == 0)
{
memberInfo.Member_Fullname = fullname;
}
if (memberInfo.Member_Tel.Length == 0)
{
memberInfo.Member_Tel = tel;
}
if (memberInfo.Member_Address.Length == 0)
{
memberInfo.Member_Address = address;
}
if (memberInfo.Member_District.Length == 0)
{
memberInfo.Member_District = district;
}
if (memberInfo.Member_City.Length == 0)
{
memberInfo.Member_City = city;
}
MemberDB.Update(memberInfo);
var info = new OrderInfo();
info.Member_ID = MemberDB.GetIDByEmail(email);
info.Order_Fullname = fullname;
info.Order_Email = email;
info.Order_Tel = tel;
info.Order_Address = address;
info.Order_District = district;
info.Order_City = city;
info.Order_Note = note;
info.Order_CreateDate = orderdate;
info.Order_Status = 0;
info.Order_Price = ConvertUtility.ToDouble(totalprice);
info.Order_Quantity = ConvertUtility.ToInt32(cart.Items.Count);
var orderid = OrderDB.Insert(info);
var sbProducts = new StringBuilder();
sbProducts.Append("<tr>");
foreach (DataGridItem item in dtgProduct.Items)
{
var id = ConvertUtility.ToInt32(item.Cells[0].Text);
var quantity = ConvertUtility.ToInt32(item.Cells[1].Text);
var price = ConvertUtility.ToInt32(item.Cells[2].Text);
var sum = price * quantity;
var oinfo = new OrderProductInfo();
oinfo.Order_ID = orderid;
oinfo.Content_ID = id;
oinfo.Quantity = quantity;
oinfo.Price = price;
oinfo.PriceSum = sum;
OrderProductDB.Insert(oinfo);
sbProducts.Append("<td style=\"padding: 4px; border: 1px #b1d1e6 solid; text-align: center;\">" + item.ItemIndex + 1 + "</td>");
sbProducts.Append("<td style=\"padding: 4px; border: 1px #b1d1e6 solid;\">" + ContentDB.GetName(id) + "</td>");
sbProducts.Append("<td style=\"padding: 4px; border: 1px #b1d1e6 solid; text-align: center;\">" + quantity + "</td>");
sbProducts.Append("<td style=\"padding: 4px; border: 1px #b1d1e6 solid; text-align: center;\">" + string.Format("{0:0,0}", price) + "</td>");
sbProducts.Append("<td style=\"padding: 4px; border: 1px #b1d1e6 solid; text-align: center;\">" + string.Format("{0:0,0}", sum) + "</td>");
}
sbProducts.Append("</tr>");
string emailadd = AppEnv.ContactEmail;
var sb = new StringBuilder();
sb.Append("Ban co don dat hang #" + orderid + " tu My-Deal.vn:");
sb.Append("<br><br><b>Ten</b>: ");
sb.Append(fullname);
sb.Append("<br><b>Email</b>: ");
sb.Append(email);
sb.Append("<br><b>Dien thoai</b>: ");
sb.Append(tel);
sb.Append("<br><b>Dia chi</b>: ");
sb.Append(txtAddress.Text);
sb.Append("<br><b>Noi dung</b>:<br>");
sb.Append(txtNote.Text);
sb.Append("<br><br>-----------------------------<br>De biet thong tin chi tiet don hang, hay dang nhang vao website<br>");
// new email solution start
MailMessage emailmess = new MailMessage(email, emailadd);
emailmess.Subject = "Don dat hang cua khach hang tu website";
emailmess.IsBodyHtml = true;
emailmess.Body = sb.ToString();
SmtpClient smtp = new SmtpClient();
if (AppEnv.MailServer.Length == 0)
{
smtp.Host = "localhost";
}
else
{
smtp.Host = AppEnv.MailServer;
}
if (AppEnv.MailServerPort.Length == 0)
{
smtp.Port = 25;
}
else
{
smtp.Port = ConvertUtility.ToInt32(AppEnv.MailServerPort);
}
// if authentication
if (AppEnv.MailUsername.Length > 0 && AppEnv.MailPassword.Length > 0)
{
smtp.Credentials = new NetworkCredential(AppEnv.MailUsername, AppEnv.MailPassword);
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
}
// if authentication end
// gui cho khach hang thong tin deal
var emailForCusContent = "";
//try
//{
const string templateUrl = "/templates/deal_confirm.htm";
var htmlpage = GetHtmlPage(templateUrl);
if (htmlpage != "NULL")
{
emailForCusContent = htmlpage;
}
//}
//catch
//{
// ErrorReportDB.NewReport(Request.RawUrl, "Thong tin CK HOSE:" + DateTime.Now);
//}
emailForCusContent = emailForCusContent.Replace("[[order_id]]", orderid.ToString()).Replace("[[order_datetime]]", orderdate.ToString("dd/MM/yyyy HH:mm")).Replace("[[order_note]]", note).Replace("[[order_products]]", sbProducts.ToString()).Replace("[[order_pricesum]]", string.Format("{0:0,0}", totalprice) + " VNĐ").Replace("[[order_fullname]]", fullname).Replace("[[order_address]]", address).Replace("[[order_tel]]", tel);
// new email solution start
var emailmess2 = new MailMessage(emailadd, email);
emailmess2.Subject = "[My-deal.vn] Thong tin dat hang #" + orderid;
emailmess2.IsBodyHtml = true;
emailmess2.Body = emailForCusContent;
var smtp2 = new SmtpClient();
if (AppEnv.MailServer.Length == 0)
{
smtp2.Host = "localhost";
}
else
{
smtp2.Host = AppEnv.MailServer;
}
if (AppEnv.MailServerPort.Length == 0)
{
smtp2.Port = 25;
}
else
{
smtp2.Port = ConvertUtility.ToInt32(AppEnv.MailServerPort);
}
// if authentication
if (AppEnv.MailUsername.Length > 0 && AppEnv.MailPassword.Length > 0)
{
smtp2.Credentials = new NetworkCredential(AppEnv.MailUsername, AppEnv.MailPassword);
smtp2.DeliveryMethod = SmtpDeliveryMethod.Network;
}
// if authentication end
try
{
smtp.Send(emailmess);
smtp2.Send(emailmess2);
notice.InnerHtml = "<br><br><br><font color=black><b>Đơn đặt hàng của bạn đã được gửi tới " + emailadd + ".Chúng tôi sẽ liên hệ với bạn trong thời gian ngắn nhất<br /><br />Xin chân thành cảm ơn!</b></font>";
}
catch (Exception z)
{
notice.InnerHtml =
"<br><br><br><font color=black><b>Đơn đặt hàng của bạn đã được gửi đi..Chúng tôi sẽ liên hệ với bạn trong thời gian ngắn nhất<br /><br />Xin chân thành cảm ơn!</b></font><br>";
}
finally
{
pnPayment.Visible = false;
notice.Visible = true;
SessionUtility.Remove("cart");
}
}
else
{
MessageBox.Show("Bạn cần phải đồng ý với điều khoản của My-Deal.vn");
}
}
