protected void DoEvents(object sender, GridViewCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
string name = e.CommandName.ToString();
switch (name)
{
case "EditIt":
{
lblTitle.Text = "Edit Selected Employee Record";
Employees emp = DataAccess2.FindEmployeeRecord(id);
txtFirstName.Text = emp.FirstName;
HiddenID.Value = emp.ID.ToString();
txtLastName.Text = emp.LastName;
txtEmail.Text = emp.Email;
DepartmentDropDownList.SelectedValue = emp.DeptID.ToString();
MultiView1.ActiveViewIndex = 1;
break;
}
case "DeleteIt":
{
List <Employees> emp = DataAccess2.Toggle_Employee_Active_Status(id);
BindEmployeeListGrid(emp);
break;
}
}
}
private static void Main(string[] args)
{
try
{
XmlConfigurator.Configure(LogManager.GetRepository(Assembly.GetEntryAssembly()), new FileInfo("log4net.config")); //Setup log4net logging
}
catch (Exception ex)
{
Console.WriteLine($"Failed to setup logging! {ex}");
}
Program.Config = JsonConvert.DeserializeObject <WebConfig>(File.ReadAllText("settings.json"));
DataAccess2.Init(Program.Config);
DatabaseConnection.Init(Program.Config);
RedisConnection.Init(Program.Config);
Task loadServersTask = Program.ServerManager.LoadServersAsync();
Task loadCampaignTimesTask = Program.CampaignManager.LoadCampaignTimesAsync();
Task loadCampaignPrizesTask = Program.CampaignManager.LoadPrizesAsync();
Program.SmtpClient = new SmtpClient(Program.Config.SmtpHost, Program.Config.SmtpPort)
{
DeliveryMethod = SmtpDeliveryMethod.Network,
EnableSsl = true,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(Program.Config.SmtpUser, Program.Config.SmtpPass)
};
Task.WaitAll(loadServersTask, loadCampaignTimesTask, loadCampaignPrizesTask);
WebHost.CreateDefaultBuilder(args).UseStartup <Startup>().Build().Run();
}
public static void Main(string[] args)
{
var d1 = new DataAccess1("Host=localhost;Username=test_dba;Password=test_dba;Database=db1;Port=45432");
var d2 = new DataAccess2("Host=localhost;Username=test_dba;Password=test_dba;Database=db2;Port=55432");
d1.DestroyAll();
d2.DestroyAll();
d1.Create(new da1.Models.Table1()
{
Custom = da1.Enums.CustomType1.BUZZ
});
d2.Create(new da2.Models.Table2()
{
Custom = da2.Enums.CustomType2.WER,
IdFromTable1 = 1
});
var d1_items = d1._GETALL().ToList();
var d2_items = d2._GETALL().ToList();
Console.WriteLine("D1");
Console.WriteLine(d1_items.First().Id);
Console.WriteLine(d1_items.First().Custom);
Console.WriteLine();
Console.WriteLine("D2");
Console.WriteLine(d2_items.First().Id);
Console.WriteLine(d2_items.First().IdFromTable1);
Console.WriteLine(d2_items.First().Custom);
Console.WriteLine();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
BindEmployeeListGrid(DataAccess2.GetEmployeesList());
DepartmentDropDownList.DataSource = DataAccess2.GetDepartments();
DepartmentDropDownList.DataBind();
}
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
Employees emp = new Employees();
emp.ID = Convert.ToInt32(HiddenID.Value);
emp.FirstName = txtFirstName.Text;
emp.LastName = txtLastName.Text;
emp.Email = txtEmail.Text;
emp.DeptID = Convert.ToInt32(DepartmentDropDownList.SelectedValue);
BindEmployeeListGrid(DataAccess2.GetEmployeesList());
MultiView1.ActiveViewIndex = 0;
}
private static void CalcHashAndAdd(byte[] bytes)
{
try
{
int crc = DataAccess2.GetCrc32(bytes.AsSpan(3));
string s = DataAccess2.GetHash(crc);
byte[] bytes2 = Encoding.UTF8.GetBytes(s);
if (bytes2.Length == 16)
{
DataAccess2.KEYS["Android"].TryAdd(bytes2, 0);
DataAccess2.KEYS["Browser"].TryAdd(bytes2, 0);
DataAccess2.KEYS["Standalone"].TryAdd(bytes2, 0);
}
}
catch
{
}
}
private static async Task Main(string[] args)
{
Program.Config = await JsonSerializer.DeserializeAsync <WebConfig>(File.OpenRead("settings.json"));
DataAccess2.Init(Program.Config);
DatabaseConnection.Init(Program.Config);
RedisConnection.Init(Program.Config);
Program.SmtpClient = new SmtpClient(Program.Config.SmtpHost, Program.Config.SmtpPort)
{
DeliveryMethod = SmtpDeliveryMethod.Network,
EnableSsl = true,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(Program.Config.SmtpUser, Program.Config.SmtpPass)
};
await WebHost.CreateDefaultBuilder(args).UseStartup <Startup>().Build().RunAsync();
}
public static void Main(string[] args)
{
bool THROW_IT = true;
DataAccess1 d1 = new DataAccess1("Host=localhost;Username=test_dba;Password=test_dba;Database=db1;Port=45432");
DataAccess2 d2;
if (!THROW_IT)
{
d2 = new DataAccess2("Host=localhost;Username=test_dba;Password=test_dba;Database=db2;Port=55432");
}
Console.WriteLine("Testing DA1");
var d1_items = d1._GETALL().ToList();
Console.WriteLine("D1");
Console.WriteLine(d1_items.First().Id);
Console.WriteLine(d1_items.First().Custom);
Console.WriteLine();
Console.WriteLine("Testing DA2");
d2 = new DataAccess2("Host=localhost;Username=test_dba;Password=test_dba;Database=db2;Port=55432");
IEnumerable <da2.Models.Table2> d2_items;
try
{
d2_items = d2._GETALL().ToList();
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw ex;
}
Console.WriteLine("D2");
Console.WriteLine(d2_items.First().Id);
Console.WriteLine(d2_items.First().IdFromTable1);
Console.WriteLine(d2_items.First().Custom);
Console.WriteLine();
}
internal static void Init(WebConfig webConfig)
{
if (string.IsNullOrWhiteSpace(webConfig.GamePath))
{
return;
}
PhysicalFileProvider val = new(webConfig.GamePath, ExclusionFilters.Sensitive)
{
UsePollingFileWatcher = true,
UseActivePolling = true
};
RefreshSwfs();
RegisterWatch();
void RefreshSwfs()
{
Console.WriteLine("Refreshing SWFs");
Parallel.ForEach(new DirectoryInfo(webConfig.GamePath).GetFiles().OrderBy(f => f.LastWriteTime), async swf =>
{
byte[] bytes = await System.IO.File.ReadAllBytesAsync(swf.FullName);
DataAccess2.CalcHashAndAdd(bytes);
});
}
void RegisterWatch()
{
IChangeToken token = val.Watch("*.swf");
token.RegisterChangeCallback(state =>
{
RefreshSwfs();
RegisterWatch();
}, null);
}
}
