public static Configuration AddConfigurationTypeEntry(
EnlistmentDC dc,
bool submit,
short id,
User u,
Email e,
PhoneSKU p,
Command c,
BuildXml b,
Enlistment1 en,
BuildType bt)
{
Configuration o = new Configuration
{
ID = id,
User = u,
Email = e,
PhoneSKU = p,
Command = c,
BuildXml = b,
Enlistment1 = en,
BuildType = bt
};
dc.Configurations.InsertOnSubmit(o);
if (submit)
{
dc.SubmitChanges();
}
return(o);
}
public static Configuration AddConfigurationTypeEntry(
EnlistmentDC dc,
bool submit,
short id,
short userId,
short emailId,
short phoneSkuId,
short commandId,
short buildXmlId,
short enlistmentId,
short dailyBuild)
{
Configuration o = new Configuration {
ID = id, UserID = userId,
EmailID = emailId, PhoneSkuID = phoneSkuId, CommandID = commandId,
BuildXmlID = buildXmlId, EnlistmentID = enlistmentId, DailyBuild = dailyBuild
};
dc.Configurations.InsertOnSubmit(o);
if (submit)
{
dc.SubmitChanges();
}
return(o);
}
public static bool ModifySmallPopulationEntry(EnlistmentDC dc)
{
var cfg = from c in dc.Configurations
where c.PhoneSKU.Name == "CEPC"
select c;
foreach (var x in cfg)
{
x.PhoneSKU.Name = "CEPC1";
}
dc.SubmitChanges();
var mod = from c in dc.Configurations
where c.PhoneSKU.Name == "CEPC1"
select c;
if (mod != null && mod.Count() > 0)
{
return(true);
}
else
{
return(false);
}
}
private void resetDataContextButton_Click(object sender, RoutedEventArgs e)
{
Shared.ResetDataContext();
EnlistmentDC dc = this.viewModel.dc;
this.configDataGridMan.ItemsSource = this.viewModel.dc.Configurations;
}
public static void PopulateDbSmall(EnlistmentDC dc, bool submit)
{
BuildType bt = AddBuildTypeEntry(dc, submit, 1, "Full Build 1");
AddBuildTypeEntry(dc, submit, 2, "Full Build 2");
BuildXml bx = AddBuildXmlTypeEntry(dc, submit, 1, @"C:\FilePath1\Config.xml");
AddBuildXmlTypeEntry(dc, submit, 2, @"C:\FilePath1\Config.xml");
Command c = AddCommandTypeEntry(dc, submit, 1, "Rebuild", "Wm Rebuild");
AddCommandTypeEntry(dc, submit, 2, "Build", "Wm Build");
User u = AddUserTypeEntry(dc, submit, 1, "Dave", "Hoover");
AddUserTypeEntry(dc, submit, 2, "John", "Wang");
Email e = AddEmailTypeEntry(dc, submit, 1, 2, true, "*****@*****.**");
AddEmailTypeEntry(dc, submit, 2, u, true, "*****@*****.**");
Enlistment1 en = AddEnlistmentTypeEntry(dc, submit, 1, @"F:\Enlistment1");
AddEnlistmentTypeEntry(dc, submit, 2, @"F:\Enlistment2");
PhoneSKU p = AddPhoneSkuTypeEntry(dc, submit, 1, "CEPC");
AddPhoneSkuTypeEntry(dc, submit, 2, "XDE");
Configuration cfg = AddConfigurationTypeEntry(dc, submit, 1, 2, 2, 2, 2, 2, 2, 2);
AddConfigurationTypeEntry(dc, submit, 2, u, e, p, c, bx, en, bt);
}
private void ConfigureItemsSelection(string field, ComboBox b)
{
EnlistmentDC dc = this.viewModel.dc;
switch (field)
{
case BuildTypeField:
{
var items = from c in dc.BuildTypes select c.Name;
b.ItemsSource = items;
}
break;
case BuildXmlField:
{
var items = from c in dc.BuildXmls select c.FilePath;
b.ItemsSource = items;
}
break;
case BuildCommandField:
{
var items = from c in dc.Commands select c.Command1;
b.ItemsSource = items;
}
break;
case EmailField:
{
var items = from c in dc.Emails select c.EmailAccount;
b.ItemsSource = items;
}
break;
case EnlistmentField:
{
var items = from c in dc.Enlistments select c.Path;
b.ItemsSource = items;
}
break;
case PhoneSkuField:
{
var items = from c in dc.PhoneSKUs select c.Name;
b.ItemsSource = items;
}
break;
case UserField:
{
var items = from c in dc.Users select c.LastName;
b.ItemsSource = items;
}
break;
default:
throw new ArgumentOutOfRangeException();
}
}
private void deleteTestRowButton_Click(object sender, RoutedEventArgs e)
{
EnlistmentDC dc = this.viewModel.dc;
var query = from s in dc.Configurations
where s.PhoneSkuID == 3
select s;
dc.Configurations.DeleteAllOnSubmit(query);
dc.SubmitChanges();
queryButton_Click(sender, e);
}
public static BuildXml AddBuildXmlTypeEntry(EnlistmentDC dc, bool submit, short id, string filePath)
{
BuildXml o = new BuildXml {
FileID = id, FilePath = filePath
};
dc.BuildXmls.InsertOnSubmit(o);
if (submit)
{
dc.SubmitChanges();
}
return(o);
}
public static PhoneSKU AddPhoneSkuTypeEntry(EnlistmentDC dc, bool submit, short id, string name)
{
PhoneSKU o = new PhoneSKU {
ID = id, Name = name
};
dc.PhoneSKUs.InsertOnSubmit(o);
if (submit)
{
dc.SubmitChanges();
}
return(o);
}
public static User AddUserTypeEntry(EnlistmentDC dc, bool submit, short id, string firstName, string lastName)
{
User o = new User {
UserID = id, FirstName = firstName, LastName = lastName
};
dc.Users.InsertOnSubmit(o);
if (submit)
{
dc.SubmitChanges();
}
return(o);
}
public static Email AddEmailTypeEntry(EnlistmentDC dc, bool submit, short emailID, User u, bool primaryAccount, string emailAccount)
{
Email o = new Email {
EmailID = emailID, EmailAccount = emailAccount, Primary = primaryAccount, User = u
};
dc.Emails.InsertOnSubmit(o);
if (submit)
{
dc.SubmitChanges();
}
return(o);
}
public static Enlistment1 AddEnlistmentTypeEntry(EnlistmentDC dc, bool submit, short id, string path)
{
Enlistment1 o = new Enlistment1 {
Id = id, Path = path
};
dc.Enlistments.InsertOnSubmit(o);
if (submit)
{
dc.SubmitChanges();
}
return(o);
}
public static Command AddCommandTypeEntry(EnlistmentDC dc, bool submit, short id, string command, string commandLine)
{
Command o = new Command {
CommandID = id, Command1 = command, CommandLine = commandLine
};
dc.Commands.InsertOnSubmit(o);
if (submit)
{
dc.SubmitChanges();
}
return(o);
}
public static BuildType AddBuildTypeEntry(EnlistmentDC dc, bool submit, short id, string name)
{
BuildType o = new BuildType {
ID = id, Name = name
};
dc.BuildTypes.InsertOnSubmit(o);
if (submit)
{
dc.SubmitChanges();
}
return(o);
}
private void Initialize(MainWindow mainWindowReference)
{
InitializeComponent();
this.mainWindow = mainWindowReference;
this.DataContext = this.viewModel;
Configurations = CollectionViewSource.GetDefaultView(this.viewModel.dc.Configurations);
this.configDataGridMan.ItemsSource = Configurations;
EnlistmentDC dc = this.viewModel.dc;
this.ConfigurationFieldSelectComboxBox(this.query0FieldSelectComboBox);
this.ConfigurationFieldSelectComboxBox(this.query1FieldSelectComboBox);
this.ConfigurationFieldSelectComboxBox(this.query2FieldSelectComboBox);
this.ConfigurationFieldSelectComboxBox(this.query3FieldSelectComboBox);
}
private void modifyTestRowButton_Click(object sender, RoutedEventArgs e)
{
EnlistmentDC dc = this.viewModel.dc;
var query = (from s in dc.Configurations
where s.PhoneSkuID == 3
select s);
var command = (from s in dc.Commands
where s.CommandID == 4
select s).First();
foreach (Configuration c in query)
{
c.Command = command;
}
dc.SubmitChanges();
queryButton_Click(sender, e);
}
public static bool DeleteEntriesFromSmallPopulationEntry(EnlistmentDC dc)
{
var cfg = from c in dc.Configurations
where c.PhoneSKU.Name == "CEPC"
select c;
dc.Configurations.DeleteAllOnSubmit(cfg);
dc.SubmitChanges();
var mod = from c in dc.Configurations
where c.PhoneSKU.Name == "CEPC"
select c;
if (mod != null && mod.Count() > 0)
{
return(false);
}
else
{
return(true);
}
}
private void addTestRowButton_Click(object sender, RoutedEventArgs e)
{
EnlistmentDC dc = this.viewModel.dc;
short maxId = (short)(from s in dc.Configurations
select s.ID).Max <short>();
maxId += 1;
this.testConfigItem = new Configuration
{
ID = maxId,
UserID = 1,
EmailID = 1,
PhoneSkuID = 3,
CommandID = 1,
BuildXmlID = 1,
EnlistmentID = 1,
DailyBuild = 1
};
dc.Configurations.InsertOnSubmit(this.testConfigItem);
dc.SubmitChanges();
queryButton_Click(sender, e);
}
public static bool VerifySmallPopulation(EnlistmentDC dc)
{
int cfgCount = (from c in dc.Configurations select c).Count();
int btCount = (from c in dc.BuildTypes select c).Count();
int bxCount = (from c in dc.BuildXmls select c).Count();
int cmdCount = (from c in dc.Commands select c).Count();
int userCount = (from c in dc.Users select c).Count();
int emailCount = (from c in dc.Emails select c).Count();
int skuCount = (from c in dc.PhoneSKUs select c).Count();
int enlistCount = (from c in dc.Enlistments select c).Count();
int s = smallDbTableCount;
if (cfgCount != s || btCount != s || bxCount != s || cmdCount != s ||
userCount != s || emailCount != s || skuCount != s || enlistCount != s)
{
return(false);
}
else
{
return(true);
}
}
private IEnumerable <Configuration> ExecuteQuery(IEnumerable <Configuration> orig,
string field,
string item)
{
EnlistmentDC dc = this.viewModel.dc;
IEnumerable <Configuration> source;
if (orig.Count() == 0)
{
source = (from c in dc.Configurations select c).AsEnumerable <Configuration>();
}
else
{
source = orig;
}
IEnumerable <Configuration> cfg = null;
switch (field)
{
case BuildTypeField:
{
cfg = from c in source
where c.BuildType.Name == item
select c;
}
break;
case BuildXmlField:
{
cfg = from c in source
where c.BuildXml.FilePath == item
select c;
}
break;
case BuildCommandField:
{
cfg = from c in source
where c.Command.Command1 == item
select c;
}
break;
case EmailField:
{
cfg = from c in source
where c.Email.EmailAccount == item
select c;
}
break;
case EnlistmentField:
{
cfg = from c in source
where c.Enlistment1.Path == item
select c;
}
break;
case PhoneSkuField:
{
cfg = from c in source
where c.PhoneSKU.Name == item
select c;
}
break;
case UserField:
{
cfg = from c in source
where c.User.LastName == item
select c;
}
break;
default:
throw new ArgumentOutOfRangeException();
}
return(cfg);
}
static Shared()
{
EnlistmentDataContext = new EnlistmentDC(@"Data\Enlistment.sdf");
}
public static void ResetDataContext()
{
EnlistmentDataContext.Dispose();
EnlistmentDataContext = null;
EnlistmentDataContext = new EnlistmentDC(@"Data\Enlistment.sdf");
}
