public SelectTwoKitsFrm(int operation)
{
InitializeComponent();
selected_operation = operation;
string hide_ref = GGKSettings.getParameterValue("Admixture.ReferencePopulations.Hide");
switch (selected_operation)
{
case SELECT_ADMIXTURE:
if (hide_ref == "1")
{
select_sql = @"SELECT kit_no 'Kit#',name 'Name' FROM kit_master WHERE disabled=0 AND reference=0 order by name ASC";
}
else
{
select_sql = @"SELECT kit_no 'Kit#',name 'Name' FROM kit_master WHERE disabled=0 order by name ASC";
}
break;
default:
select_sql = @"SELECT kit_no 'Kit#',name 'Name' FROM kit_master WHERE disabled=0 order by name ASC";
break;
}
}
private void btnResetDefault_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure you want to reset the parameter value with default value?", "Reset Parameter Value", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
tbValue.Text = GGKSettings.getDefaultResetSettings()[tbKey.Text][0];
Save();
}
}
private void SettingsFrm_Load(object sender, EventArgs e)
{
GGKUtilLib.enableSave();
lbSettings.Items.Clear();
settings = GGKSettings.getSettings();
lbSettings.Items.AddRange(settings.Keys.ToArray());
if (lbSettings.Items.Count > 0)
{
lbSettings.SelectedIndex = 0;
populateForm(lbSettings.Text);
}
}
private void btnRefresh_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Genetic Genealogy Kit (GGK) will try to use the internet and connect to mtdnacommunity.org to fetch the latest Human mtDNA Phylogeny XML. Are you sure you want to do this?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
string url = GGKSettings.getParameterValue("Phylogeny.mtDNA.URL");
GGKUtilLib.setStatus("Fetching.. " + url);
backgroundWorker1.RunWorkerAsync(url);
}
catch (Exception ee)
{
MessageBox.Show("Technical Details: " + ee.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void timer1_Tick(object sender, EventArgs e)
{
timer1.Enabled = false;
disabled.Clear();
DataGridViewCellStyle gray = new DataGridViewCellStyle();
gray.ForeColor = Color.LightGray;
SQLiteConnection cnn = GGKUtilLib.getDBConnection();
dataGridViewOpenKit.Rows.Clear();
string hide = GGKSettings.getParameterValue("Admixture.ReferencePopulations.Hide");
SQLiteCommand query = new SQLiteCommand(select_sql, cnn);
SQLiteDataReader reader = query.ExecuteReader();
while (reader.Read())
{
int new_idx = dataGridViewOpenKit.Rows.Add();
DataGridViewRow row = dataGridViewOpenKit.Rows[new_idx];
row.Cells[0].Value = reader.GetString(0);
row.Cells[1].Value = reader.GetString(1);
row.Cells[2].Value = reader.GetString(3);
if (reader.GetInt16(2) == 1)
{
row.DefaultCellStyle = gray;
disabled.Add(reader.GetString(0));
}
}
query.Dispose();
cnn.Dispose();
if (dataGridViewOpenKit.Rows.Count > 0)
{
dataGridViewOpenKit.CurrentCell = dataGridViewOpenKit.Rows[0].Cells[0];
kitLbl.Text = dataGridViewOpenKit.SelectedRows[0].Cells[0].Value.ToString();
}
if (dataGridViewOpenKit.Rows.Count == 0)
{
MessageBox.Show("There are no kits available to open.", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.Close();
}
}
public void Save()
{
GGKSettings.saveParameterValue(tbKey.Text, tbValue.Text);
GGKUtilLib.setStatus("Value for parameter [" + tbKey.Text + "] saved.");
}
public SelectKitFrm(int operation)
{
InitializeComponent();
//
selected_operation = operation;
string hide_ref = GGKSettings.getParameterValue("Admixture.ReferencePopulations.Hide");
switch (selected_operation)
{
case OPEN_KIT:
btnOpen.Text = "Open";
if (hide_ref == "1")
{
select_sql = @"SELECT kit_no,name,disabled,last_modified FROM kit_master WHERE reference=0 order by last_modified DESC";
}
else
{
select_sql = @"SELECT kit_no,name,disabled,last_modified FROM kit_master order by last_modified DESC";
}
break;
case EXPORT_KIT:
btnOpen.Text = "Export";
if (hide_ref == "1")
{
select_sql = @"SELECT kit_no,name,disabled,last_modified FROM kit_master WHERE reference=0 order by last_modified DESC";
}
else
{
select_sql = @"SELECT kit_no,name,disabled,last_modified FROM kit_master order by last_modified DESC";
}
break;
case SELECT_ONE_TO_MANY:
//hide parameter has no effect.
btnOpen.Text = "Select";
select_sql = @"SELECT kit_no,name,disabled,last_modified FROM kit_master WHERE reference=0 order by last_modified DESC";
break;
case SELECT_ADMIXTURE:
//hide parameter has no effect.
btnOpen.Text = "Select";
select_sql = @"SELECT kit_no,name,disabled,last_modified FROM kit_master WHERE reference=0 order by last_modified DESC";
break;
case SELECT_ROH:
//hide parameter has no effect.
btnOpen.Text = "Select";
select_sql = @"SELECT kit_no,name,disabled,last_modified FROM kit_master WHERE reference=0 order by last_modified DESC";
break;
case SELECT_KIT:
btnOpen.Text = "Select";
if (hide_ref == "1")
{
select_sql = @"SELECT kit_no,name,disabled,last_modified FROM kit_master WHERE reference=0 order by last_modified DESC";
}
else
{
select_sql = @"SELECT kit_no,name,disabled,last_modified FROM kit_master order by last_modified DESC";
}
break;
case SELECT_MTPHYLOGENY:
btnOpen.Text = "Select";
if (hide_ref == "1")
{
select_sql = @"select kit_no,name,disabled,last_modified from kit_master where kit_no in (select distinct kit_no from kit_mtdna) and reference=0 order by last_modified DESC";
}
else
{
select_sql = @"select kit_no,name,disabled,last_modified from kit_master where kit_no in (select distinct kit_no from kit_mtdna) order by last_modified DESC";
}
break;
case SELECT_MITOMAP:
btnOpen.Text = "Select";
if (hide_ref == "1")
{
select_sql = @"select kit_no,name,disabled,last_modified from kit_master where kit_no in (select distinct kit_no from kit_mtdna) and reference=0 order by last_modified DESC";
}
else
{
select_sql = @"select kit_no,name,disabled,last_modified from kit_master where kit_no in (select distinct kit_no from kit_mtdna) order by last_modified DESC";
}
break;
case SELECT_ISOGGYTREE:
btnOpen.Text = "Select";
if (hide_ref == "1")
{
select_sql = @"select kit_no,name,disabled,last_modified from kit_master where kit_no in (select distinct kit_no from kit_ysnps) and reference=0 order by last_modified DESC";
}
else
{
select_sql = @"select kit_no,name,disabled,last_modified from kit_master where kit_no in (select distinct kit_no from kit_ysnps) order by last_modified DESC";
}
break;
default:
if (hide_ref == "1")
{
select_sql = @"SELECT kit_no,name,disabled,last_modified FROM kit_master WHERE reference=0 order by last_modified DESC";
}
else
{
select_sql = @"SELECT kit_no,name,disabled,last_modified FROM kit_master order by last_modified DESC";
}
break;
}
}
