public void checkForStream()
{
string userName = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
PushDataDataContext dataBase = new PushDataDataContext();
var Count = (from rows in dataBase.Streaming_Commands
where rows.User == userName && rows.Done == "false"
select rows).Count();
if (Count > 0 && IsServerAvailable())
{
Process.Start(GetRealPath() + "//Streaming_Client.exe");
var pickedData = (from rows in dataBase.Streaming_Commands
where rows.User == userName && rows.Done == "false"
select rows).FirstOrDefault();
string date = pickedData.Date;
int id = pickedData.ID;
dataBase.Streaming_Commands.DeleteOnSubmit(pickedData);
Streaming_Command stream = new Streaming_Command();
stream.Date = date;
stream.Done = "true";
stream.ID = id;
stream.Port = 2016;
stream.User = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
dataBase.Streaming_Commands.InsertOnSubmit(stream);
dataBase.SubmitChanges();
}
}
private void Connect_Click(object sender, EventArgs e)
{
try
{
//IP Configuration
string UserName = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
CnC_DatabaseDataContext DataBase = new CnC_DatabaseDataContext();
var IsOn = (from rows in DataBase.Streaming_IPs
where rows.User == UserIP.Text
select rows).FirstOrDefault();
if (IsOn.AreOn == "true")
{
var Count = (from rows in DataBase.Streaming_IPs
select rows).Count();
if (Count != 0)
{
var IPs = (from rows in DataBase.Streaming_IPs
where rows.UserType == "Server" && rows.User == UserName
select rows).FirstOrDefault();
DataBase.Streaming_IPs.DeleteOnSubmit(IPs);
DataBase.SubmitChanges();
Streaming_IP IP_Submit = new Streaming_IP();
IP_Submit.AreOn = "true";
IP_Submit.ID = Count + 1;
IP_Submit.IP = GetIpAdress();
IP_Submit.Port = 2016;
IP_Submit.User = UserName;
IP_Submit.UserType = "Server";
DataBase.Streaming_IPs.InsertOnSubmit(IP_Submit);
DataBase.SubmitChanges();
}
if (Count == 0)
{
Streaming_IP IPs = new Streaming_IP();
IPs.AreOn = "true";
IPs.ID = Count + 1;
IPs.IP = GetIpAdress();
IPs.Port = 2016;
IPs.User = UserName;
IPs.UserType = "Server";
DataBase.Streaming_IPs.InsertOnSubmit(IPs);
DataBase.SubmitChanges();
}
//Command
var Count_ = (from rows in DataBase.Streaming_Commands
select rows).Count();
Streaming_Command Command_Sumbit = new Streaming_Command();
Command_Sumbit.Date = dateTimePicker1.Value.ToString();
Command_Sumbit.Done = "false";
Command_Sumbit.ID = Count_ + 1;
Command_Sumbit.Port = 2016;
Command_Sumbit.User = UserIP.Text;
DataBase.Streaming_Commands.InsertOnSubmit(Command_Sumbit);
DataBase.SubmitChanges();
//Load
Streaming_Show Show = new Streaming_Show();
Show.Show();
}
else
{
MessageBox.Show("They Aren't online");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
