Example #1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     using (var con = DAL.con())
     {
         Upcoming.List = SuKienDal.SelectUpcoming(con, "50");
     }
 }
Example #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var    id   = Request["ID"];
        var    khId = Request["KH_ID"];
        SuKien Item;

        using (var con = DAL.con())
        {
            if (string.IsNullOrEmpty(id))
            {
                Item = new SuKien();
                if (!string.IsNullOrEmpty(khId))
                {
                    if (khId.Length > 36)
                    {
                        khId = khId.Substring(khId.LastIndexOf(',') + 1);
                    }
                    var kh = KhachHangDal.SelectById(new Guid(khId), con);
                    Item.KH_Ten = kh.Ten;
                    Item.KH_ID  = kh.ID;
                }
                ViewItem.Item = Item;
            }
            else
            {
                Item          = SuKienDal.SelectById(new Guid(id));
                Item.KH_Ten   = maHoa.DecryptString(Item.KH_Ten, Item.KH_ID.ToString());
                ViewItem.Item = Item;
            }
        }
    }
Example #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var id             = Request["ID"];
        var d              = DateTime.Now;
        var cuoiThangTruoc = new DateTime(d.Year, d.Month, 1).AddDays(-1);
        var dauThangSau    = d.AddMonths(6);

        using (var con = DAL.con())
        {
            if (string.IsNullOrEmpty(id))
            {
                View.Item = new HangHoa();;
            }
            else
            {
                Item      = HangHoaDal.SelectById(new Guid(id));
                View.Item = Item;
            }
            var list = SuKienDal.SelectPhieuDichVuForVay(con, cuoiThangTruoc, dauThangSau, id);
            View.List = list;
            var phieuBaoHongList = PhieuBaoHongDal.SelectTopByHhId(con, 10, id);

            var choThueVayList = ChoThueVayDal.SelectTopByHhId(con, 10, id);

            var phieuGiatVayList = PhieuGiatVayDal.SelectTopByHhId(con, 10, id);

            var phieuXuatNhapSanPhamList = PhieuXuatNhapSanPhamDal.SelectTopByHhId(con, 10, id);

            View.PhieuBaoHongList         = phieuBaoHongList;
            View.ChoThueVayList           = choThueVayList;
            View.PhieuGiatVayList         = phieuGiatVayList;
            View.PhieuXuatNhapSanPhamList = phieuXuatNhapSanPhamList;
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        var d = DateTime.Now;

        var dauThang   = new DateTime(d.Year, d.Month, 1);
        var cuoiThang  = new DateTime(d.Year, d.Month, 1).AddMonths(1).AddDays(-1);
        var tuNgayStr  = Request["TuNgay"];
        var denNgayStr = Request["DenNgay"];

        if (string.IsNullOrEmpty(tuNgayStr))
        {
            tuNgayStr = dauThang.ToString("dd/MM/yyyy");
        }
        if (string.IsNullOrEmpty(denNgayStr))
        {
            denNgayStr = cuoiThang.ToString("dd/MM/yyyy");
        }

        var tuNgay  = Convert.ToDateTime(tuNgayStr, new CultureInfo("Vi-vn"));
        var denNgay = Convert.ToDateTime(denNgayStr, new CultureInfo("Vi-vn"));

        using (var con = DAL.con())
        {
            var list    = SuKienDal.SelectPhieuDichVuBaoCao(con, tuNgay.ToString("yyyy-MM-dd"), denNgay.ToString("yyyy-MM-dd"), null);
            var members = (from p in list
                           group p by p.NhanVien_Id
                           into g
                           select g.Key).ToList();
            ChamCong.Members = MemberDal.SelectAll().Where(x => members.Contains(x.ID)).ToList();

            ChamCong.TuNgay  = tuNgay;
            ChamCong.DenNgay = denNgay;
            ChamCong.List    = list;
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        var d = DateTime.Now;
        var cuoiThangTruoc = new DateTime(d.Year, d.Month, 1).AddDays(-1);
        var dauThangSau    = d.AddMonths(6);
        var nhanVienId     = Request["NHANVIEN_ID"];

        using (var con = DAL.con())
        {
            EventsViewer.List = SuKienDal.SelectPhieuDichVuEventsViewer(con, d.AddDays(-1).ToString("yyyy-MM-dd"), dauThangSau.ToString("yyyy-MM-dd"), nhanVienId);
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        var d = DateTime.Now;
        var cuoiThangTruoc = new DateTime(d.Year, d.Month, 1).AddDays(-1);
        var dauThangSau    = d.AddMonths(6);
        var NHANVIEN_ID    = Request["NHANVIEN_ID"];

        using (var con = DAL.con())
        {
            var list = SuKienDal.SelectForCalendar(con, cuoiThangTruoc, dauThangSau, NHANVIEN_ID);
            LichThang.List = list;
        }
    }
Example #7
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var d = DateTime.Now;
        var cuoiThangTruoc = new DateTime(d.Year, d.Month, 1).AddDays(-1);
        var dauThangSau    = d.AddMonths(6);
        var muoiNgayToi    = cuoiThangTruoc.AddMonths(1);

        using (var con = DAL.con())
        {
            var list = SuKienDal.SelectPhieuDichVuForCalendarPts(con, cuoiThangTruoc, dauThangSau, Security.UserId.ToString());
            LichThang.List = list;

            EventsViewer.List = SuKienDal.SelectPhieuDichVuEventsViewer(con, d.AddDays(-1).ToString("yyyy-MM-dd"), muoiNgayToi.ToString("yyyy-MM-dd"), Security.UserId.ToString());
        }
    }
Example #8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var d = DateTime.Now;
        var cuoiThangTruoc = new DateTime(d.Year, d.Month, 1).AddDays(-1);
        var muoiNgayToi    = cuoiThangTruoc.AddMonths(1);
        var dauThangSau    = d.AddMonths(6);

        using (var con = DAL.con())
        {
            var list = SuKienDal.SelectPhieuDichVuForCalendar(con, cuoiThangTruoc, dauThangSau, null);
            LichThang.List = list;

            SinhNhat.List = KhachHangDal.pagerSinhNhat(null, false, null, null, 20, null, null).List;

            EventsViewer.List = SuKienDal.SelectPhieuDichVuEventsViewer(con, d.ToString("yyyy-MM-dd"), muoiNgayToi.ToString("yyyy-MM-dd"), null);
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        var q           = Request["q"];
        var dm_id       = Request["DM_ID"];
        var khId        = Request["KH_ID"];
        var NHANVIEN_ID = Request["NHANVIEN_ID"];
        var size        = Request["size"];
        var logged      = Security.IsAuthenticated();

        if (string.IsNullOrEmpty(size))
        {
            size = "10";
        }

        Ngay = Request["Ngay"];

        using (var con = DAL.con())
        {
            var tuNgay  = "";
            var denNgay = "";
            if (!string.IsNullOrEmpty(Ngay))
            {
                Ngay = Server.UrlDecode(Ngay);
                var d = Convert.ToDateTime(Ngay, new CultureInfo("Vi-vn"));
                tuNgay  = new DateTime(d.Year, d.Month, d.Day).ToString("yyyy-MM-dd");
                denNgay = new DateTime(d.Year, d.Month, d.Day).AddDays(1).ToString("yyyy-MM-dd");
            }
            if (logged)
            {
                var member = MemberDal.SelectByUser(con, Security.Username);
                NHANVIEN_ID = member.ID.ToString();
            }
            else
            {
                NHANVIEN_ID = "0";
            }
            var pg =
                SuKienDal.pagerNormal(
                    string.Format("?q={0}&size={1}&DM_ID={2}&KH_ID={3}&NHANVIEN_ID={4}&", q, size, dm_id, khId, NHANVIEN_ID) + "{1}={0}"
                    , false, "SK_NgayBatDau desc", q, Convert.ToInt32(size)
                    , dm_id, khId, NHANVIEN_ID, null, null, tuNgay, denNgay);
            paging = pg.Paging;
            ListByNhanVien.List = pg.List;
        }
    }
Example #10
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var d = DateTime.Now;
        var cuoiThangTruoc = new DateTime(d.Year, d.Month, 1).AddDays(-1);
        var dauThangSau    = d.AddMonths(6);
        var nhanVienId     = Request["NHANVIEN_ID"];

        using (var con = DAL.con())
        {
            var member = new Member();
            if (!string.IsNullOrEmpty(nhanVienId))
            {
                member = MemberDal.SelectById(Convert.ToInt32(nhanVienId));
            }

            var list = SuKienDal.SelectPhieuDichVuForCalendar(con, cuoiThangTruoc, dauThangSau, nhanVienId);
            LichThang.List     = list;
            LichThang.NhanVien = member;
        }
    }
Example #11
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var q           = Request["q"];
        var dm_id       = Request["DM_ID"];
        var khId        = Request["KH_ID"];
        var NHANVIEN_ID = Request["NHANVIEN_ID"];
        var size        = Request["size"];

        if (string.IsNullOrEmpty(size))
        {
            size = "10";
        }

        Ngay = Request["Ngay"];

        using (var con = DAL.con())
        {
            var ListLoai = DanhMucDal.SelectByLDMMa(con, "NHOM-SK");
            DM_ID.List = ListLoai;
            var tuNgay  = "";
            var denNgay = "";
            if (!string.IsNullOrEmpty(Ngay))
            {
                Ngay = Server.UrlDecode(Ngay);
                var d = Convert.ToDateTime(Ngay, new CultureInfo("Vi-vn"));
                tuNgay  = new DateTime(d.Year, d.Month, d.Day).ToString("yyyy-MM-dd");
                denNgay = new DateTime(d.Year, d.Month, d.Day).AddDays(1).ToString("yyyy-MM-dd");
            }

            var pg =
                SuKienDal.pagerNormal(
                    string.Format("?q={0}&size={1}&DM_ID={2}&KH_ID={3}&NHANVIEN_ID={4}&", q, size, dm_id, khId, NHANVIEN_ID) + "{1}={0}"
                    , false, "SK_NgayBatDau desc", q, Convert.ToInt32(size)
                    , dm_id, khId, NHANVIEN_ID, null, null, tuNgay, denNgay);
            paging         = pg.Paging;
            DanhSach1.List = pg.List;
        }
    }
Example #12
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var act             = Request["act"];
        var logged          = Security.IsAuthenticated();
        var Id              = Request["Id"];
        var IdNull          = string.IsNullOrEmpty(Id);
        var Ten             = Request["Ten"];
        var Ma              = Request["Ma"];
        var DanhGia         = Request["DanhGia"];
        var Mobile          = Request["Mobile"];
        var Ym              = Request["Ym"];
        var FacebookUid     = Request["FacebookUid"];
        var NguonGoc_ID     = Request["NguonGoc_ID"];
        var KhuVuc_ID       = Request["KhuVuc_ID"];
        var LinhVuc_ID      = Request["LinhVuc_ID"];
        var NgungTheoDoi    = Request["NgungTheoDoi"];
        var ThoiGianGoiDien = Request["ThoiGianGoiDien"];
        var DiaChi          = Request["DiaChi"];
        var Anh             = Request["Anh"];
        var NgaySinh        = Request["NgaySinh"];
        var TiemNang        = Request["TiemNang"];
        var KH_ID           = Request["KH_ID"];
        var TT_ID           = Request["TT_ID"];
        var LOAI_ID         = Request["LOAI_ID"];
        var NoiDung         = Request["NoiDung"];
        var NgayBatDau      = Request["NgayBatDau"];
        var DM_ID           = Request["DM_ID"];
        var NhanVien        = Request["NhanVien"];
        var MoTa            = Request["MoTa"];
        var BoQua           = Request["BoQua"];
        var ThanhCong       = Request["ThanhCong"];
        var refUrl          = Request["refUrl"];
        var DV_ID           = Request["DV_ID"];
        var Gia             = Request["Gia"];
        var CK              = Request["CK"];
        var ThanhToan       = Request["ThanhToan"];
        var ConNo           = Request["ConNo"];
        var BaoHanh_ID      = Request["BaoHanh_ID"];
        var NgayLap         = Request["NgayLap"];
        var NgayLam         = Request["NgayLam"];
        var TVDV_ID         = Request["TVDV_ID"];
        var ThuTu           = Request["ThuTu"];
        var SoLan           = Request["SoLan"];
        var GhiChu          = Request["GhiChu"];
        var NgayBatDau_Gio  = Request["NgayBatDau_Gio"];
        var NgayKetThuc_Gio = Request["NgayKetThuc_Gio"];

        if (!string.IsNullOrEmpty(refUrl))
        {
            refUrl = Server.UrlDecode(refUrl);
        }
        NgungTheoDoi = !string.IsNullOrEmpty(NgungTheoDoi) ? "true" : "false";
        BoQua        = !string.IsNullOrEmpty(BoQua) ? "true" : "false";
        ThanhCong    = !string.IsNullOrEmpty(ThanhCong) ? "true" : "false";
        switch (subAct)
        {
        case "save":
            #region Thêm lịch hẹn

            if (Security.IsAuthenticated())
            {
                SuKien item;
                if (IdNull)
                {
                    item = new SuKien {
                        ID = Guid.NewGuid(), NgayTao = DateTime.Now, NguoiTao = Security.Username, NguoiCapNhat = Security.Username, NgayCapNhat = DateTime.Now
                    };
                }
                else
                {
                    item = SuKienDal.SelectById(new Guid(Id));
                }
                item.Ten  = Ten;
                item.MoTa = MoTa;
                if (!string.IsNullOrEmpty(NgayBatDau) && !string.IsNullOrEmpty(NgayBatDau_Gio))
                {
                    item.NgayBatDau = Convert.ToDateTime(string.Format("{0} {1}", NgayBatDau, NgayBatDau_Gio), new CultureInfo("vi-vn"));
                }
                if (!string.IsNullOrEmpty(NgayBatDau) && !string.IsNullOrEmpty(NgayKetThuc_Gio))
                {
                    item.NgayKetThuc = Convert.ToDateTime(string.Format("{0} {1}", NgayBatDau, NgayKetThuc_Gio), new CultureInfo("vi-vn"));
                }
                if (!string.IsNullOrEmpty(KH_ID))
                {
                    item.KH_ID = new Guid(KH_ID);
                }
                if (!string.IsNullOrEmpty(DM_ID))
                {
                    item.DM_ID = new Guid(DM_ID);
                }
                item.BoQua     = Convert.ToBoolean(BoQua);
                item.ThanhCong = Convert.ToBoolean(ThanhCong);
                item.NhanVien  = NhanVien;
                if (IdNull)
                {
                    item = SuKienDal.Insert(item);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{1} thêm mới lịch hẹn: {0}", item.Ten,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ten
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 1
                        ,
                        Ten = "Thêm"
                    });
                    #endregion
                }
                else
                {
                    item = SuKienDal.Update(item);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{1} sửa lịch hẹn: {0}", item.Ten,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ten
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 2
                        ,
                        Ten = "Sửa"
                    });
                    #endregion
                }
                //SearchManager.Add(Ten, item.IndexNoiDung, item.IndexContent, Ten, item.ID.ToString(), item.Url, typeof(SuKien).Name);
                TimKiemDal.Add(item, item.ID);
                rendertext(item.ID.ToString());
            }
            break;

            #endregion
        case "LichHen-Xoa":
            #region Xóa lịch hẹn

            if (Security.IsAuthenticated())
            {
                var item = SuKienDal.SelectById(new Guid(Id));
                if (item.NguoiTao == Security.Username)
                {
                    SuKienDal.DeleteById(new Guid(Id));
                    //SearchManager.Remove(Id);
                    TimKiemDal.DeleteByPRowId(DAL.con(), item.ID);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{1} xóa lịch hẹn: {0}", item.Ten,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ten
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 3
                        ,
                        Ten = "Xóa"
                    });
                    #endregion
                    rendertext("1");
                }
                else
                {
                    rendertext("0");
                }
            }
            break;

            #endregion
        default: break;
        }
    }
Example #13
0
    protected void Page_Load(object sender, EventArgs e)
    {
        var act             = Request["act"];
        var logged          = Security.IsAuthenticated();
        var Id              = Request["Id"];
        var IdNull          = string.IsNullOrEmpty(Id);
        var Ten             = Request["Ten"];
        var Ma              = Request["Ma"];
        var DanhGia         = Request["DanhGia"];
        var Mobile          = Request["Mobile"];
        var Ym              = Request["Ym"];
        var FacebookUid     = Request["FacebookUid"];
        var NguonGoc_ID     = Request["NguonGoc_ID"];
        var KhuVuc_ID       = Request["KhuVuc_ID"];
        var LinhVuc_ID      = Request["LinhVuc_ID"];
        var NgungTheoDoi    = Request["NgungTheoDoi"];
        var ThoiGianGoiDien = Request["ThoiGianGoiDien"];
        var DiaChi          = Request["DiaChi"];
        var Anh             = Request["Anh"];
        var NgaySinh        = Request["NgaySinh"];
        var TiemNang        = Request["TiemNang"];
        var KH_ID           = Request["KH_ID"];
        var TT_ID           = Request["TT_ID"];
        var LOAI_ID         = Request["LOAI_ID"];
        var NoiDung         = Request["NoiDung"];
        var NgayBatDau      = Request["NgayBatDau"];
        var DM_ID           = Request["DM_ID"];
        var NhanVien        = Request["NhanVien"];
        var MoTa            = Request["MoTa"];
        var BoQua           = Request["BoQua"];
        var ThanhCong       = Request["ThanhCong"];
        var refUrl          = Request["refUrl"];
        var DV_ID           = Request["DV_ID"];
        var Gia             = Request["Gia"];
        var CK              = Request["CK"];
        var ThanhToan       = Request["ThanhToan"];
        var ConNo           = Request["ConNo"];
        var BaoHanh_ID      = Request["BaoHanh_ID"];
        var NgayLap         = Request["NgayLap"];
        var NgayLam         = Request["NgayLam"];
        var TVDV_ID         = Request["TVDV_ID"];
        var ThuTu           = Request["ThuTu"];
        var SoLan           = Request["SoLan"];
        var GhiChu          = Request["GhiChu"];

        if (!string.IsNullOrEmpty(refUrl))
        {
            refUrl = Server.UrlDecode(refUrl);
        }
        NgungTheoDoi = !string.IsNullOrEmpty(NgungTheoDoi) ? "true" : "false";
        BoQua        = !string.IsNullOrEmpty(BoQua) ? "true" : "false";
        ThanhCong    = !string.IsNullOrEmpty(ThanhCong) ? "true" : "false";
        switch (act)
        {
        case "KhachHang-Add":
            #region Thêm khách hàng
            if (logged)
            {
                var item = IdNull ? new KhachHang() : KhachHangDal.SelectById(new Guid(Id));
                item.Ten             = Ten;
                item.Ma              = Ma;
                item.Anh             = Anh;
                item.ThoiGianGoiDien = ThoiGianGoiDien;
                item.Mobile          = Mobile;
                item.FacebookUid     = FacebookUid;
                item.NgungTheoDoi    = Convert.ToBoolean(NgungTheoDoi);
                item.NguoiCapNhat    = Security.Username;
                item.NgayCapNhat     = DateTime.Now;
                item.DiaChi          = DiaChi;
                item.Ym              = Ym;
                item.TiemNang        = Convert.ToBoolean(TiemNang);
                if (!string.IsNullOrEmpty(NgaySinh))
                {
                    item.NgaySinh = Convert.ToDateTime(NgaySinh, new CultureInfo("vi-vn"));
                }
                if (!string.IsNullOrEmpty(NguonGoc_ID))
                {
                    item.NguonGoc_ID = new Guid(NguonGoc_ID);
                }
                if (!string.IsNullOrEmpty(KhuVuc_ID))
                {
                    item.KhuVuc_ID = new Guid(KhuVuc_ID);
                }
                if (!string.IsNullOrEmpty(LinhVuc_ID))
                {
                    item.LinhVuc_ID = new Guid(LinhVuc_ID);
                }
                item.DanhGia = Convert.ToInt16(DanhGia);
                if (IdNull)
                {
                    item.NgayTao  = DateTime.Now;
                    item.NguoiTao = Security.Username;
                    item.ID       = Guid.NewGuid();
                    item          = KhachHangDal.Insert(item);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{2} thêm mới khách hàng {1}-{0}", item.Ten, item.Ma,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ten
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 1
                        ,
                        Ten = "Thêm"
                    });
                    #endregion
                }
                else
                {
                    item = KhachHangDal.Update(item);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{2} sửa khách hàng {1}-{0}", item.Ten, item.Ma,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ten
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 2
                        ,
                        Ten = "Sửa"
                    });
                    #endregion
                }
                TimKiemDal.Add(item, item.ID);
                rendertext(item.ID.ToString());
            }
            break;

            #endregion
        case "KhachHang-Xoa":
            #region Xóa khách hàng
            if (logged && !IdNull)
            {
                var item = KhachHangDal.SelectById(new Guid(Id));
                if (item.NguoiTao == Security.Username)
                {
                    KhachHangDal.DeleteById(new Guid(Id));
                    TimKiemDal.DeleteByPRowId(DAL.con(), item.ID);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{2} xóa khách hàng {1}-{0}", item.Ten, item.Ma,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ten
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 3
                        ,
                        Ten = "Xóa"
                    });
                    #endregion
                    rendertext("1");
                }
                else
                {
                    rendertext("0");
                }
            }
            break;

            #endregion
        case "KhachHang-UpgradeFromTiemNang":
            #region Nâng cấp tiềm năng thành khách hàng
            if (logged && !IdNull)
            {
                var item = KhachHangDal.SelectById(new Guid(Id));
                item.TiemNang    = false;
                item.NgayCapNhat = DateTime.Now;
                KhachHangDal.Update(item);

                #region log
                LogDal.log(item, new Log()
                {
                    Checked = false
                    ,
                    Info =
                        string.Format("{2} chuyển đổi tiềm năng thành khách hàng {1}-{0}", item.Ten, item.Ma,
                                      Security.Username)
                    ,
                    NgayTao = DateTime.Now
                    ,
                    Username = Security.Username
                    ,
                    PRowId = item.ID
                    ,
                    PTen = item.Ten
                    ,
                    RequestIp = Request.UserHostAddress
                    ,
                    RawUrl = refUrl
                    ,
                    LLOG_ID = 4
                    ,
                    Ten = "Chuyển đổi"
                });
                #endregion
                rendertext(Id);
            }
            break;

            #endregion
        case "ChamSoc-Add":
            #region Thêm chăm sóc

            if (Security.IsAuthenticated())
            {
                ChamSoc item;
                if (IdNull)
                {
                    item = new ChamSoc {
                        ID = Guid.NewGuid(), NgayTao = DateTime.Now, NguoiTao = Security.Username
                    };
                    item.NgayTao = DateTime.Now;
                }
                else
                {
                    item = ChamSocDal.SelectById(new Guid(Id));
                }
                item.Ma = Ma;

                if (!string.IsNullOrEmpty(KH_ID))
                {
                    item.KH_ID = new Guid(KH_ID);
                }
                if (!string.IsNullOrEmpty(TT_ID))
                {
                    item.TT_ID = new Guid(TT_ID);
                }
                if (!string.IsNullOrEmpty(LOAI_ID))
                {
                    item.LOAI_ID = new Guid(LOAI_ID);
                }
                item.NoiDung = NoiDung;
                if (IdNull)
                {
                    item = ChamSocDal.Insert(item);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{1} thêm mới chăm sóc {0}", item.Ma,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ma
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 1
                        ,
                        Ten = "Thêm"
                    });
                    #endregion
                }
                else
                {
                    item = ChamSocDal.Update(item);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{1} sửa chăm sóc {0}", item.Ma,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ma
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 2
                        ,
                        Ten = "Sửa"
                    });
                    #endregion
                }
                TimKiemDal.Add(item, item.ID);
                rendertext(item.ID.ToString());
            }
            break;

            #endregion
        case "ChamSoc-Xoa":
            #region Xóa chăm sóc

            if (Security.IsAuthenticated())
            {
                var item = ChamSocDal.SelectById(new Guid(Id));
                if (item.NguoiTao == Security.Username)
                {
                    ChamSocDal.DeleteById(new Guid(Id));
                    TimKiemDal.DeleteByPRowId(DAL.con(), item.ID);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{1} xóa chăm sóc {0}", item.Ma,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ma
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 3
                        ,
                        Ten = "Xóa"
                    });
                    #endregion
                    rendertext("1");
                }
                else
                {
                    rendertext("0");
                }
            }
            break;

            #endregion
        case "LichHen-Add":
            #region Thêm lịch hẹn

            if (Security.IsAuthenticated())
            {
                SuKien item;
                if (IdNull)
                {
                    item = new SuKien {
                        ID = Guid.NewGuid(), NgayTao = DateTime.Now, NguoiTao = Security.Username, NguoiCapNhat = Security.Username, NgayCapNhat = DateTime.Now
                    };
                }
                else
                {
                    item = SuKienDal.SelectById(new Guid(Id));
                }
                item.Ten  = Ten;
                item.MoTa = MoTa;
                if (!string.IsNullOrEmpty(NgayBatDau))
                {
                    item.NgayBatDau = Convert.ToDateTime(NgayBatDau, new CultureInfo("vi-vn"));
                }
                if (!string.IsNullOrEmpty(KH_ID))
                {
                    item.KH_ID = new Guid(KH_ID);
                }
                if (!string.IsNullOrEmpty(DM_ID))
                {
                    item.DM_ID = new Guid(DM_ID);
                }
                item.BoQua     = Convert.ToBoolean(BoQua);
                item.ThanhCong = Convert.ToBoolean(ThanhCong);
                item.NhanVien  = NhanVien;
                if (IdNull)
                {
                    item = SuKienDal.Insert(item);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{1} thêm mới lịch hẹn: {0}", item.Ten,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ten
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 1
                        ,
                        Ten = "Thêm"
                    });
                    #endregion
                }
                else
                {
                    item = SuKienDal.Update(item);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{1} sửa lịch hẹn: {0}", item.Ten,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ten
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 2
                        ,
                        Ten = "Sửa"
                    });
                    #endregion
                }
                TimKiemDal.Add(item, item.ID);
                rendertext(item.ID.ToString());
            }
            break;

            #endregion
        case "LichHen-Xoa":
            #region Xóa lịch hẹn

            if (Security.IsAuthenticated())
            {
                var item = SuKienDal.SelectById(new Guid(Id));
                if (item.NguoiTao == Security.Username)
                {
                    ChamSocDal.DeleteById(new Guid(Id));
                    TimKiemDal.DeleteByPRowId(DAL.con(), item.ID);
                    #region log
                    LogDal.log(item, new Log()
                    {
                        Checked = false
                        ,
                        Info =
                            string.Format("{1} xóa lịch hẹn: {0}", item.Ten,
                                          Security.Username)
                        ,
                        NgayTao = DateTime.Now
                        ,
                        Username = Security.Username
                        ,
                        PRowId = item.ID
                        ,
                        PTen = item.Ten
                        ,
                        RequestIp = Request.UserHostAddress
                        ,
                        RawUrl = refUrl
                        ,
                        LLOG_ID = 3
                        ,
                        Ten = "Xóa"
                    });
                    #endregion
                    rendertext("1");
                }
                else
                {
                    rendertext("0");
                }
            }
            break;

            #endregion
        case "Logout":
            #region logout this system
            Security.LogOut();
            break;

            #endregion
        default: break;
        }
    }