public void InsertOnline()
{
try
{
int iD = 0;
PushDataDataContext DataBase = new PushDataDataContext();
string UserName = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
var count = (from rows in DataBase.Streaming_IPs
where rows.User == System.Security.Principal.WindowsIdentity.GetCurrent().Name&& rows.UserType == "Client"
select rows).Count();
if (count > 0)
{
var IPs = (from rows in DataBase.Streaming_IPs
where rows.User == System.Security.Principal.WindowsIdentity.GetCurrent().Name&& rows.UserType == "Client"
select rows).FirstOrDefault();
iD = IPs.ID;
DataBase.Streaming_IPs.DeleteOnSubmit(IPs);
DataBase.SubmitChanges();
}
var Count = (from rows in DataBase.Streaming_IPs
select rows).Count();
Streaming_IP IP_Submit = new Streaming_IP();
IP_Submit.AreOn = "true";
IP_Submit.ID = iD;
IP_Submit.IP = GetIpAdress();
IP_Submit.Port = 2016;
IP_Submit.User = UserName;
IP_Submit.UserType = "Client";
DataBase.Streaming_IPs.InsertOnSubmit(IP_Submit);
DataBase.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
MainPlatform2ndPart main = new MainPlatform2ndPart();
main.Show();
}
private void Form1_Load(object sender, EventArgs e)
{
try
{
CnC_DatabaseDataContext DataBase = new CnC_DatabaseDataContext();
int iD = 0;
string userName = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
var count = (from rows in DataBase.Streaming_IPs
where rows.UserType == "Server"
select rows).Count();
if (count > 0)
{
var IPs = (from rows in DataBase.Streaming_IPs
where rows.UserType == "Server"
select rows).FirstOrDefault();
iD = IPs.ID;
DataBase.Streaming_IPs.DeleteOnSubmit(IPs);
DataBase.SubmitChanges();
}
var Count = (from rows in DataBase.Streaming_IPs
select rows).Count();
Streaming_IP IP_Submit = new Streaming_IP();
IP_Submit.AreOn = "true";
IP_Submit.ID = iD;
IP_Submit.IP = GetIpAdress();
IP_Submit.Port = 2016;
IP_Submit.User = userName;
IP_Submit.UserType = "Server";
DataBase.Streaming_IPs.InsertOnSubmit(IP_Submit);
DataBase.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
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());
}
}
