public OnlinePage()
{
cts = new ConnectToSQL();
cts.Connect(Config.ConnectionStringEDP, 1433, "f");
this.Loaded += OnlinePage_Loaded;
InitializeComponent();
}
public void Connect()
{
cts.Connect(Config.ConnectionStringEDP, 1433, "f");
cts.SetPlayerInVoiceChat(SocketStatus.Account);
DT.Start();
}
private void FormTaoHoaDon_Load(object sender, EventArgs e)
{
ConnectToSQL.Connect();
LoadDataGridView();
LoadInfoHoaDon();
txtMaHD.ReadOnly = true;
txtTenNV.ReadOnly = true;
txtTenKH.ReadOnly = true;
txtDiaChi.ReadOnly = true;
txtSdt.ReadOnly = true;
txtTenMH.ReadOnly = true;
txtDonGia.ReadOnly = true;
txtThanhTien.ReadOnly = true;
txtTongThanhTien.ReadOnly = true;
txtGiamGia.Text = "0";
if (txtTongThanhTien.Text == "")
{
txtTongThanhTien.Text = "0";
}
btnThemHoaDon.Enabled = true;
btnLuuHoaDon.Enabled = false;
btnHuyHoaDon.Enabled = false;
btnInHoaDon.Enabled = true;
}
private void FormQLSanPham_Load(object sender, EventArgs e)
{
ConnectToSQL.Connect();
dtgvSanPham.DataSource = menuList;
LoadData();
// Dùng Data Binding để hiện dữ liệu trên cái textbox
AddMenuBinding();
}
private void FormQLKhachHang_Load(object sender, EventArgs e)
{
ConnectToSQL.Connect();
LoadData();
// Không thể thực hiện lưu hoặc xóa khi mới load form
txtMaKH.Enabled = false;
btnLuu.Enabled = false;
btnHuy.Enabled = false;
}
private void SocketStatus_LoginComplect(object Parameter)
{
Dispatcher.Invoke(() =>
{
Logger.ConsoleLogger.Log("LoginComplect");
Task.Run(() => { SocketStatus.GlobalSynchronizeClient.Setup(); });
//LogOutButton.Visibility = Visibility.Visible;
Title = "EDP - " + (string)Parameter;
cts = new ConnectToSQL();
//SocketStatus.player_RPC.initialize();
Name = (string)Parameter;
//SocketStatus.player_RPC.UpdatePresence("edp", File.ReadAllText(@"C:\EDP\Build.json").Split('|')[1], "edp-smalllogo",(string)Parameter);
cts.Connect(Config.ConnectionStringEDP, 1433, "f");
//TODO:cts.Connect("192.168.1.103", 1433, "f");
cts.SetPlayerOnline(SocketStatus.Account);
SocketStatus.GlobalSynchronizeClient.Login(SocketStatus.Account);
SocketStatus.voice_Client.voicePage = new VoicePage();
});
}
public SqlNotificationDependency()
{
ConnectToSQL cts = new ConnectToSQL();
cts.Connect(Config.ConnectionStringEDP, 1433, "f");
string ConnectionString = $"Server={Config.ConnectionStringEDP},1433; initial catalog = chat_container; user id = SqlUser; password = SqlUserSt0rongP@assord";
SqlTableDependency <ChatsC> myDependencyTableDependency;
try
{
myDependencyTableDependency = new SqlTableDependency <ChatsC>(ConnectionString, cts.GetServerListChannelData(0).FirstOrDefault().Name);
myDependencyTableDependency.OnError += (o, args) => this.ErrorNotification(o, args);
myDependencyTableDependency.OnChanged += (o, args) => this.OutputNotification(args.ChangeType, args.Entity);
myDependencyTableDependency.Start();
}
catch
{ }
}
public static List <dboReport> GetServerData(string Host, int port, string userid, string userpas, int Dataid)
{
CTS.Connect(Host, port, userid, userpas);
return(CTS.GetServerData(Dataid));
}
