private static ArrayList LoadVardesc( Database LinktoDB)
{
ArrayList Pulldown = new ArrayList();
ModeLabel.Text = "Loading Varible Descriptions.";
string Command = "twOrmPTXIpHyfSw0F2nU8MD+p/8hyw3sfcVCvlWG4Aa1X9bw+9Csi5QKVaNIIxsqKaFc+PhHqThWwpEHM1fevg==";
LinktoDB.CurrentCommand.SetCommand("GetVarDesc");
Pulldown = LinktoDB.RetrieveData(Command, ref RTB, ref ErrorLog);
return Pulldown;
}
private static string LC_SampleDateTimeLookup( Sample Item)
{
ModeLabel.Text = "Looking up LabCal sample times.";
Database myDB = new Database();
SimplerAES myAES = new SimplerAES();
string BaseCommand = "+CFENk6LKiNLKVKt+NZnQO1d4fqE6vLg1eHJuaCfBFjYxBPPH8K2Y4x6hwMOrzzN78bgkB0bfqdojXMvuzYoZA==";
Item.SampleNameBackup = Item.SampleNameBackup.TrimStart("\"".ToArray());
Item.SampleNameBackup = Item.SampleNameBackup.TrimEnd("\"".ToArray());
myDB.CurrentCommand.SetCommand("GetLC_SampleDateTime");
ArrayList Retrieved = myDB.RetrieveData(myAES.Decrypt(BaseCommand) + quoet + Item.SampleNameBackup + quoet, ref RTB, ref ErrorLog);
if (Retrieved.Count != 0){
DateTime Referance = (DateTime)Retrieved[0];
Item.DateTimeInSQL = BuildDateTimeStamps(Referance.ToString());
return Referance.ToString();
}
else return "";
}
private static ArrayList LoadLCSample( Database LinktoDB)
{
ArrayList Pulldown = new ArrayList();
ModeLabel.Text = "Loading LabCal Samples";
SimplerAES myAES = new SimplerAES();
string Command = "u+BNjH3jaVOculsEnqUwP+r90S6WjZnxTqEQvuCyWyJ1mbGvsv9gMGoj3pj9QlMq";
LinktoDB.CurrentCommand.SetCommand("GetLC_Samples");
Pulldown = LinktoDB.RetrieveData(Command, ref RTB, ref ErrorLog);
return Pulldown;
}