protected void Page_Load(object sender, EventArgs e) { string URL = Attributes["param"]; ID_Song = Util.GetParam(URL, "id"); trang = Util.GetParam(URL, "trang"); if (ID_Song != "" && ID_Song != "-1") { int id = int.Parse(ID_Song); xRPDataContext datacontext = new xRPDataContext(); Qldh_DanhMucSong qlkh = (from c in datacontext.Qldh_DanhMucSongs where c.ID == id select c).FirstOrDefault(); txtTenSong.Text = qlkh.TenSong; txtGhiChu.Text = qlkh.GhiChu; txtHeSoTieuHao.Text = qlkh.HeSoTieuHao.ToString(); if (qlkh.KichHoat.Value == true) { chkKichHoat.Checked = true; } if (qlkh.KichHoat.Value == false) { chkKichHoat.Checked = false; } } }
public static string ThemSong(string id, string tenSong, string heSoTieuHao, string kichHoat, string ghiChu) { if (string.IsNullOrWhiteSpace(heSoTieuHao)) { heSoTieuHao = "1"; } 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 xRPDataContext dataContext = new xRPDataContext(); Qldh_DanhMucSong qlvt = new Qldh_DanhMucSong(); 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; } string result = null; if (int.Parse(id) == -1) { result = dataContext.Sp_Qldh_DanhMucSong_Add_Edit_Deli("ADD", int.Parse(id), tenSong, double.Parse(heSoTieuHao), ghiChu, KichHoat, currentUserID, currentUserID, ref idd, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1; } if (int.Parse(id) > 0) { result = dataContext.Sp_Qldh_DanhMucSong_Add_Edit_Deli("EDIT", int.Parse(id), tenSong, double.Parse(heSoTieuHao), ghiChu, KichHoat, currentUserID, currentUserID, ref idd, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1; } if (!string.IsNullOrEmpty(result)) { return(result); } } catch (Exception ex) { return("ERROR: " + ex.Message); } return("SUCCESS"); }