private void ButtonMigrate_Click(object sender, EventArgs e)
{
try
{
GetOMS.OMSFolder();
//MessageBox.Show("Record/s transfer completed.");
Console.WriteLine("Record/s transfer completed.");
}
catch (Exception)
{
return;
}
}
static void Main(string[] args)
{
SqlConnection connection = new SqlConnection(SmartDB.ConnectionString());
if (connection.State == ConnectionState.Closed)
{
try
{
connection.Open();
Console.WriteLine("Open");
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
GetOMS.OMSFolder();
GetLatest();
ToBackup.MoveMD();
Console.ReadLine();
}
private void metroTileCopy_Click(object sender, EventArgs e)
{
GetOMS.OMSFolder();
}
public static void ExportHydrusData()
{
using (var context = new JizanOMSContext())
{
try
{
GetOMS.OMSFolder();
GetLatest();
ToBackup.MoveMD();
//string strPath = Environment.GetFolderPath(
// System.Environment.SpecialFolder.DesktopDirectory);
string strPath = @"C:\JizHydrusLatest\";
var extractMeter1 = context.Database
.SqlQuery <HydrusData>("SELECT * FROM viewLatestHydrusData WHERE ReadingDate IS NOT NULL");
var extractMeter2 = context.Database
.SqlQuery <HydrusData>("SELECT * FROM viewLatestHydrusData WHERE ReadingDate IS NULL");
var fileName = Timex.CurrentTime();
string path2 = strPath + "\\" + "HYDRUS_DATA_" + fileName + ".csv";
using (StreamWriter writer = new StreamWriter(path2, false))
{
string[] separator = { "," };
var filecontents = new StringBuilder();
filecontents.Append("#, Account No, Area No, Area Name, Serial No, RAW_TELEGRAM, READING_DATE\r\n");
string extract = null;
foreach (var em in extractMeter1)
{
extract += em.RowNum + ","; //#
extract += em.AccountNo + ","; //AccountNo
extract += em.AreaNo + ","; //AreaNo
extract += em.AreaName + ","; //AreaName
extract += em.MeterAddress + ","; //SerialNo
extract += em.RawTelegram + ","; //Packet
extract += em.ReadingDate
.ToString()
.DBtoCSVDateConvert(); //Date
extract += "\r\n";
}
foreach (var em in extractMeter2)
{
extract += em.RowNum + ","; //#
extract += em.AccountNo + ","; //AccountNo
extract += em.AreaNo + ","; //AreaNo
extract += em.AreaName + ","; //AreaName
extract += em.MeterAddress + ","; //SerialNo
extract += em.RawTelegram + ","; //Packet
extract += em.ReadingDate; //Date
extract += "\r\n";
}
filecontents.Append(extract);
writer.Write(filecontents.ToString());
writer.Flush();
writer.Close();
}
//Console.WriteLine("Extracted Hydrus Data");
Console.WriteLine("Extracted Hydrus Data in JizHydrusLatest Folder.");
}
catch (Exception e)
{
Console.WriteLine(e);
//return;
}
}
}
