public void UpdateCEDB() { string strError = string.Empty; SQLDBCE.SetConnectString("Persist Security Info = False; Data Source = '..\\..\\Employee'; "); //SQLDBCE.SetConnectString("Persist Security Info = False; Data Source = ' D:\\DART\\Hackathon_Artifacts\\Hacathon_NOV\\SampleApp\\DataLoader\\Employee'; "); Statements stmt = new Statements(); //Prepare DBscript for Low salary data insert stmt.CreateCEDBStmts(); //Check for existance of records in the SQL CE DB DataTable dt = SQLDBCE.GetDataTable("SELECT * FROM Employee"); //Delete existing records if (dt != null && dt.Rows.Count > 0) { strError = SQLDBCE.ExecuteQuery("DELETE FROM Employee"); } if (string.IsNullOrEmpty(strError)) { Console.WriteLine("Existing data deleted sucessfully from SQLCE DB."); Console.WriteLine(); } else { Console.WriteLine("System Encountered Error.Press Enter to Terminate."); Console.ReadLine(); System.Environment.Exit(0); } //Insert low salary records into SQL CE DB foreach (var item in stmt.lstCEDBScript) { strError = SQLDBCE.ExecuteQuery(item); } if (string.IsNullOrEmpty(strError)) { Console.WriteLine("Data inserted sucessfully into SQLCE DB."); Console.WriteLine(); } else { Console.WriteLine("System Encountered Error.Press Enter to Terminate."); Console.ReadLine(); System.Environment.Exit(0); } }
public void GenerateExtDataFile() { string strDBScripts = string.Empty; Statements stmt = new Statements(); stmt.CreateExSysDBStmts(); strDBScripts = stmt.strExDBScript; Util.WriteToFile(strDBScripts); Console.WriteLine("Sucessfully written DDLs with data in the Flat file."); Console.WriteLine(); }