public static string XoaKhachHang(int id)
{
try
{
Guid currentUserID = Guid.NewGuid();
string currentUser = "";
#region Get current User
MembershipUser membershipUser = Membership.GetUser(HttpContext.Current.User.Identity.Name);
if (membershipUser != null)
{
currentUser = membershipUser.UserName;
currentUserID = (Guid)membershipUser.ProviderUserKey;
}
#endregion get current User
//Initial data context variable, this class is declared in .dbml file in xRPDAL namespace
Qldh_KhachHangReposity khachhangReposity = new Qldh_KhachHangReposity();
khachhangReposity.XoaKhachHang(id, currentUserID, Util.GetIP(), Util.GetPCName());
}
catch (Exception)
{
return("ERROR");
}
return("SUCCESS");
}
public void Binddata(string keyword)
{
Qldh_KhachHangReposity khachhangReposity = new Qldh_KhachHangReposity();
if (string.IsNullOrEmpty(keyword))
{
var lstKhachHang = khachhangReposity.GetDanhSachKhachHang(0, 0, 0, null, keyword);
colPage.MaxPages = 10000;
colPage.PageSize = 10; // số items hiển thị trên một trang.
colPage.DataSource = lstKhachHang;
colPage.BindToControl = rptDanhMucHeSoTongGiao;
rptDanhMucHeSoTongGiao.DataSource = colPage.DataSourcePaged;
rptDanhMucHeSoTongGiao.DataBind();
}
else
{
var lstKhachHang = khachhangReposity.GetDanhSachKhachHang(-1, 0, 0, null, keyword);
colPage.MaxPages = 10000;
colPage.PageSize = 10; // số items hiển thị trên một trang.
colPage.DataSource = lstKhachHang;
colPage.BindToControl = rptDanhMucHeSoTongGiao;
rptDanhMucHeSoTongGiao.DataSource = colPage.DataSourcePaged;
rptDanhMucHeSoTongGiao.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
loadDrop();
string URL = Attributes["param"];
ID_NhomKH = Util.GetParam(URL, "id");
trang = Util.GetParam(URL, "trang");
if (Util.GetParam(URL, "type") != null)
{
type = Util.GetParam(URL, "type");
}
else
{
type = "1";
}
if (ID_NhomKH != "" && ID_NhomKH != "-1")
{
Qldh_KhachHangReposity khachhangReposity = new Qldh_KhachHangReposity();
var lstKhachHang = khachhangReposity.GetDanhSachKhachHang(0, 0, 0, null, "");
int id = int.Parse(ID_NhomKH);
Sp_Qldh_KhachHang_SelectResult qlkh = (from c in lstKhachHang
where c.ID == id
select new Sp_Qldh_KhachHang_SelectResult
{
ID = c.ID,
MaHieuKhachHang = c.MaHieuKhachHang,
TenKhachHang = c.TenKhachHang,
DiaChi = c.DiaChi,
DienThoaiLienHe = c.DienThoaiLienHe,
SoFax = c.SoFax,
Email = c.Email,
ThongTinLienHe = c.ThongTinLienHe,
GhiChu = c.GhiChu,
IDNhomKhachHang = c.IDNhomKhachHang,
KichHoat = c.KichHoat
}).FirstOrDefault();
txtMaKhachHang.Text = qlkh.MaHieuKhachHang;
txtTenKhachHang.Text = qlkh.TenKhachHang;
txtDiaChiKhachHang.Text = qlkh.DiaChi;
txtSoDienThoaiLienHe.Text = qlkh.DienThoaiLienHe;
txtSoMayFax.Text = qlkh.SoFax;
txtEmail.Text = qlkh.Email;
txtNguoiLienLac.Text = qlkh.ThongTinLienHe;
txtGhiChu.Text = qlkh.GhiChu;
dropNhomKH.SelectedValue = qlkh.IDNhomKhachHang.Value.ToString();
if (qlkh.KichHoat.Value == true)
{
chkKichHoat.Checked = true;
}
if (qlkh.KichHoat.Value == false)
{
chkKichHoat.Checked = false;
}
}
}
public static string ThemKhachHang(string id, string maKhachHang, string tenKhachHang, string idNhomKhachHang,
string diaChi, string dienthoaiLienHe, string fax, string email, string thongtinLienHe,
string kichHoat, string ghiChu)
{
Guid currentUserID = Guid.NewGuid();
string currentUser = "";
#region Get current User
MembershipUser membershipUser = Membership.GetUser(HttpContext.Current.User.Identity.Name);
if (membershipUser != null)
{
currentUser = membershipUser.UserName;
currentUserID = (Guid)membershipUser.ProviderUserKey;
}
#endregion get current User
try
{
int? idd = int.Parse(id) == 0 || int.Parse(id) == -1 ? (int?)null : int.Parse(id);
bool KichHoat = false;
if (kichHoat == "1")
{
KichHoat = true;
}
if (kichHoat == "0")
{
KichHoat = false;
}
Qldh_KhachHangReposity khachhangReposity = new Qldh_KhachHangReposity();
string return_message = "";
if (int.Parse(id) == -1)
{
return_message = khachhangReposity.ThemHoacSuaKhachHang("ADD", int.Parse(id), maKhachHang, tenKhachHang, int.Parse(idNhomKhachHang), diaChi, dienthoaiLienHe, fax, email, thongtinLienHe, KichHoat, ghiChu, currentUserID, idd, Util.GetIP(), Util.GetPCName());
}
if (int.Parse(id) > 0)
{
return_message = khachhangReposity.ThemHoacSuaKhachHang("EDIT", int.Parse(id), maKhachHang, tenKhachHang, int.Parse(idNhomKhachHang), diaChi, dienthoaiLienHe, fax, email, thongtinLienHe, KichHoat, ghiChu, currentUserID, idd, Util.GetIP(), Util.GetPCName());
}
if (!string.IsNullOrEmpty(return_message))
{
return(return_message);
}
}
catch (Exception ex)
{
return("ERROR: " + ex.Message + ex.StackTrace);
}
return("SUCCESS");
}
