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; } } }