public static void CreateLed()
{
using var context = new ProgrammerContext();
//context.Database.EnsureCreated();
Led led1 = new Led();
led1.LedId = 1;
led1.Wavelength = Wavelength.W285;
Led led2 = new Led();
led2.LedId = 2;
led2.Wavelength = Wavelength.W285;
Led led3 = new Led();
led3.LedId = 3;
led3.Wavelength = Wavelength.W310;
context.Add(led1);
context.Add(led2);
context.Add(led3);
context.SaveChanges();
Console.WriteLine("Led Created");
}
public static void PrintLEDs()
{
using var context = new ProgrammerContext();
//context.Database.EnsureCreated();
foreach (var led in context.Leds)
{
Console.WriteLine("LED WL {0}", led.Wavelength);
}
Console.WriteLine("Should be done");
}
public static void PrintDensities()
{
using var context = new ProgrammerContext();
var connString = context.Database.GetConnectionString();
Console.WriteLine("Connection String: {0}", connString);
var led = context.Leds.Include(e => e.PowerDensities).FirstOrDefault(e => e.LedId == 1);
Console.WriteLine("LED: {0}", led.Wavelength);
foreach (var pd in led.PowerDensities.OrderBy(e => e.Current))
{
Console.WriteLine("LEDId: {0} Current: {1} PowerDensity: {2}", pd.LedId, pd.Current, pd.PowerDenisty);
}
}
public static void Create()
{
using var context = new ProgrammerContext();
//context.Database.EnsureCreated();
Random rand = new Random();
foreach (var led in context.Leds)
{
for (int i = 0; i < 20; i++)
{
PowerDensity pd = new PowerDensity();
pd.Led = led;
pd.Current = i * 1;
pd.PowerDenisty = i * rand.Next(1, 10);
context.Add(pd);
}
context.SaveChanges();
Console.WriteLine("Added");
//Console.WriteLine("LED WL {0}",led.Wavelength);
}
Console.WriteLine("Should be done");
//context.
}
public SkillsController(ProgrammerContext context)
{
_context = context;
}
public StaffsController(ProgrammerContext context)
{
this.context = context;
}
public ProgrammerRepository(ProgrammerContext context)
{
_context = context;
}
public static void ImportLookUp()
{
using var context = new ProgrammerContext();
context.Database.EnsureCreated();
Led led1 = new Led();
led1.LedId = 1;
led1.Wavelength = Wavelength.W285;
Led led2 = new Led();
led2.LedId = 2;
led2.Wavelength = Wavelength.W275;
Led led3 = new Led();
led3.LedId = 3;
led3.Wavelength = Wavelength.W310;
context.Add(led1);
context.Add(led2);
context.Add(led3);
context.SaveChanges();
Console.WriteLine("Led Created");
Console.WriteLine("");
var lines = File.ReadAllLines(@"E:\Software Development\Controller Programmer\LookUpTable.txt");
List <PowerDensityRow> data = new List <PowerDensityRow>();
foreach (var line in lines)
{
var rows = line.Split('\t');
if (rows.Count() == 4)
{
PowerDensity p285 = new PowerDensity();
PowerDensity p275 = new PowerDensity();
PowerDensity p310 = new PowerDensity();
p285.Led = led1;
p275.Led = led2;
p310.Led = led3;
int current = (int)(1000 * Convert.ToDouble(rows[0]));
p285.Current = current;
p275.Current = current;
p310.Current = current;
p285.PowerDenisty = ((int)(1000 * Convert.ToDouble(rows[1])));
p275.PowerDenisty = ((int)(1000 * Convert.ToDouble(rows[2])));
p310.PowerDenisty = ((int)(1000 * Convert.ToDouble(rows[3])));
context.Add(p285);
context.Add(p275);
context.Add(p310);
try {
var count = context.SaveChanges();
if (count > 0)
{
Console.WriteLine("Success");
}
else
{
Console.WriteLine("Failed to add(no except) {0}", line);
}
} catch {
Console.WriteLine("Failed to add {0}", line);
}
data.Add(new PowerDensityRow()
{
Current = Convert.ToDouble(rows[0]),
W285 = Convert.ToDouble(rows[1]),
W275 = Convert.ToDouble(rows[2]),
W310 = Convert.ToDouble(rows[3])
});
}
else
{
Console.WriteLine("Error: Too Many Rows. Rows: {0}", rows.Count());
}
}
Console.WriteLine("Current,W285,W275,W310");
foreach (var value in data)
{
Console.WriteLine("{0},{1},{2},{3}", value.Current, value.W285, value.W275, value.W310);
}
}
public ProgrammersController(ProgrammerContext context)
{
_context = context;
}
public static void Initialize(ProgrammerContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Programmer.Any())
{
return; // DB has been seeded
}
var availability = new Availability[] {
new Availability {
Op1 = true, Op2 = false, Op3 = false, Op4 = false, Op5 = false
},
new Availability {
Op1 = false, Op2 = true, Op3 = false, Op4 = false, Op5 = false
},
new Availability {
Op1 = false, Op2 = false, Op3 = true, Op4 = false, Op5 = false
}
};
var bankinfo = new BankInfo[] {
new BankInfo {
Name = "Teste 1",
Cpf = "987654321-1",
Bank = "TestBank1",
Agency = "123-1",
AccType = 0,
AccNumber = "321-1"
},
new BankInfo {
Name = "Teste 2",
Cpf = "987654321-2",
Bank = "TestBank2",
Agency = "123-2",
AccType = 0,
AccNumber = "321-2"
},
new BankInfo {
Name = "Teste 3",
Cpf = "987654321-3",
Bank = "TestBank3",
Agency = "123-3",
AccType = 1,
AccNumber = "321-3"
}
};
var besttime = new BestTime[] {
new BestTime {
Op1 = true, Op2 = false, Op3 = false, Op4 = false, Op5 = false
},
new BestTime {
Op1 = false, Op2 = true, Op3 = false, Op4 = false, Op5 = false
},
new BestTime {
Op1 = false, Op2 = false, Op3 = true, Op4 = false, Op5 = false
}
};
var knoledge = new Knoledge[] {
new Knoledge {
Ionic = "1",
Android = "1",
Ios = "1",
Html = "1",
Css = "1",
Bootstrap = "1",
Jquery = "1",
Angular = "1",
Java = "1",
Aspnet = "1",
C = "1",
Cpp = "1",
Cake = "1",
Django = "1",
Majento = "1",
Php = "1",
Wordpress = "1",
Python = "1",
Ruby = "1",
Sqls = "1",
Mysql = "1",
Salesforce = "1",
Photoshop = "1",
Illustrator = "1",
Seo = "1",
Other = "1"
},
new Knoledge {
Ionic = "2",
Android = "2",
Ios = "2",
Html = "2",
Css = "2",
Bootstrap = "2",
Jquery = "2",
Angular = "2",
Java = "2",
Aspnet = "2",
C = "2",
Cpp = "2",
Cake = "2",
Django = "2",
Majento = "2",
Php = "2",
Wordpress = "2",
Python = "2",
Ruby = "2",
Sqls = "2",
Mysql = "2",
Salesforce = "2",
Photoshop = "2",
Illustrator = "2",
Seo = "2",
Other = "2"
},
new Knoledge {
Ionic = "3",
Android = "3",
Ios = "3",
Html = "3",
Css = "3",
Bootstrap = "3",
Jquery = "3",
Angular = "3",
Java = "3",
Aspnet = "3",
C = "3",
Cpp = "3",
Cake = "3",
Django = "3",
Majento = "3",
Php = "3",
Wordpress = "3",
Python = "3",
Ruby = "3",
Sqls = "3",
Mysql = "3",
Salesforce = "3",
Photoshop = "3",
Illustrator = "3",
Seo = "3",
Other = "3"
}
};
var programmer = new Programmer[] {
new Programmer {
Email = "*****@*****.**",
Name = "Test 1",
Skype = "test1.skp",
Phone = "+123456",
Linkedin = "linkedin.com/test1",
City = "TestCity1",
State = "TestState1",
Portfolio = "test1.com",
Salary = 80,
Bank = "TestBank1",
Link = "test1crud.com",
BankInfo = bankinfo[0],
Knoledge = knoledge[0],
BestTime = besttime[0],
Availability = availability[0]
},
new Programmer {
Email = "*****@*****.**",
Name = "Test 2",
Skype = "test2.skp",
Phone = "+123456",
Linkedin = "linkedin.com/test2",
City = "TestCity2",
State = "TestState2",
Portfolio = "test2.com",
Salary = 90,
Bank = "TestBank2",
Link = "test2crud.com",
BankInfo = bankinfo[1],
Knoledge = knoledge[1],
BestTime = besttime[1],
Availability = availability[1]
},
new Programmer {
Email = "*****@*****.**",
Name = "Test 3",
Skype = "test3.skp",
Phone = "+123456",
Linkedin = "linkedin.com/test3",
City = "TestCity3",
State = "TestState3",
Portfolio = "test3.com",
Salary = 100,
Bank = "TestBank3",
Link = "test3crud.com",
BankInfo = bankinfo[2],
Knoledge = knoledge[2],
BestTime = besttime[2],
Availability = availability[2]
}
};
// foreach (Availability s in availability)
// {
// context.Availability.Add(s);
// }
// foreach (BankInfo s in bankinfo)
// {
// context.BankInfo.Add(s);
// }
// foreach (BestTime s in besttime)
// {
// context.BestTime.Add(s);
// }
// foreach (Knoledge s in knoledge)
// {
// context.Knoledge.Add(s);
// }
foreach (Programmer p in programmer)
{
context.Programmer.Add(p);
}
context.SaveChanges();
}
public ControllerDataManagment(ProgrammerContext context)
{
this._context = context;
}