public void Extract(Int32 iChunk, string sZipFileName, string sNewFileName)
{
string sCompare = sZipFileName.ParseString(":", 1).ToUpper();
string sCypherChunk = ivFile["x" + iChunk.ToString()];
string sChunk = kpFileKey.NextKeyPair(iChunk).toDecryptAES(sCypherChunk);
MemoryStream zipMS = new MemoryStream(sChunk.toByteArray());
using (ZipFile z = ZipFile.Read(zipMS)) {
foreach (ZipEntry ze in z)
{
string sFileName = ze.FileName.ToUpper();
if (sFileName == sCompare)
{
string sWorkingPath = MMExt.UserLogLocation();
string sAddPathAndFile = ze.FileName.Replace('/', '\\');
ze.Extract(sWorkingPath, ExtractExistingFileAction.OverwriteSilently);
if (File.Exists(sWorkingPath + sAddPathAndFile))
{
File.Copy(sWorkingPath + sAddPathAndFile, sNewFileName);
}
if (File.Exists(sWorkingPath + sAddPathAndFile))
{
File.Delete(sWorkingPath + sAddPathAndFile);
}
}
}
}
}
public Form1()
{
InitializeComponent();
mCon = new MMConMgr();
sSettingsFileName = MMExt.SettingFileName("SqlChangeTrackerSettings");
settings = new FileVar(sSettingsFileName);
if (settings["WorkingFolder"] != null)
{
edWorkFolder.Text = settings["WorkingFolder"];
}
}
public void LoadContext(TrayAppContext ac)
{
appContext = ac;
sFileSettings = MMExt.MMConLocation() + "\\" + sFileSettingFileName;
RefreshTasks();
RefreshSchedule();
if (!tAppClock.Enabled)
{
tAppClock.Enabled = true;
}
}
// [TestMethod]
public void ViewColumns()
{
string sFileName = MMExt.MMConLocation() + "\\Damonsx2.ini";
CFileTable Damons = new CFileTable(sFileName);
//foreach (short x in Damons.Columns.Keys) {
// CColumn c = (CColumn)Damons.Columns[x];
// Console.WriteLine("Key:"+ c.Key.toString()+ ";Name:"+ c.Name +";Caption:"+c.Caption+";Type:"+c.ColType.ToString()+";");
// }
foreach (Int32 x in Damons.Rows.Keys)
{
CRow c = Damons.Rows[x];
Console.WriteLine("Key:" + x.toString() + ";Con:" + c["CI"].Value + ";Ma:" + c["MA"].Value + ";");
}
}
public void LoadContext(TrayAppContext ac)
{
appContext = ac;
sFileSettings = MMExt.MMConLocation() + "\\" + sFileSettingFileName;
IniFile ai = IniFile.FromFile(sFileSettings);
string sFile = ai["Settings"]["LocalFolder"];
if (sFile != "")
{
textBox1.Text = sFile;
}
sFile = ai["Settings"]["WorkingFolder"];
if (sFile != "")
{
textBox2.Text = sFile;
}
//edOut.Text += sFileSettings+Environment.NewLine;
}
private void button1_Click(object sender, EventArgs e)
{
string sFilePathName = EnsureDestFileUnique(MMExt.UserLogLocation() + "Excel01.xlsx");
MMExcel.MMExcel mm = new MMExcel.MMExcel(StartMode.smNew, sFilePathName);
MMWS ws0 = mm.Sheet[0];
ws0.Name = "ZeroSheet";
double dInchValue = 0.25;
ws0["A1", "AB120"].RowHeight = dInchValue.toPointsVertical();
ws0["A1", "AB120"].ColumnWidth = dInchValue.toPointsHorizontal(); // dColWidthPerPoint * dInchValue.toPointsHorizontal();
ws0["A1", "A1"].Rng.Font.Name = "Century Gothic";
Excel.Font fontA = ws0["A1", "A1"].Rng.Font;
mm.Close();
Process.Start(sFilePathName);
}
// [TestMethod]
public void ReCreateDamons()
{
string sFileName = MMExt.MMConLocation() + "\\Damonsx2.ini";
if (File.Exists(sFileName))
{
File.Delete(sFileName);
}
CFileTable Damons = new CFileTable(sFileName);
Damons.Columns.Add(new CColumn(Damons.Columns, "ConID", "CI", CColType.ctString));
Damons.Columns.Add(new CColumn(Damons.Columns, "Machine", "MA", CColType.ctString));
Damons.Columns.Add(new CColumn(Damons.Columns, "Signin", "SI", CColType.ctDateTime));
Damons.Columns.Add(new CColumn(Damons.Columns, "SignOut", "SO", CColType.ctDateTime));
CRow r = Damons.Rows.Add(new CRow(Damons.Rows));
r["CI"].Value = "Connection 1";
r["MA"].Value = "Machine B";
r["SI"].Value = DateTime.Now.toString();
Damons.SaveTable();
}
public dlgEditTask()
{
InitializeComponent();
sFileSettings = MMExt.MMConLocation() + "\\" + sFileSettingFileName;
ai = IniFile.FromFile(sFileSettings);
}
