public static void CreateTable(SQLiteConnection connection) { using (SQLiteCommand command = connection.CreateCommand()) { DBDwgFileCommands.CreateTable(command); command.ExecuteNonQuery(); } }
/// <summary> /// Check if the connection has path. /// </summary> /// <param name="connection"></param> /// <param name="path">relative path</param> /// <returns></returns> public static bool HasRowPath(SQLiteConnection connection, string path) { long count = 0; using (SQLiteCommand command = connection.CreateCommand()) { DBDwgFileCommands.SelectCount(command, path); count = Convert.ToInt64(command.ExecuteScalar()); } return(count == 1); }
public static DwgFileModel SelectRow(SQLiteConnection connection, string relPath) { DwgFileModel model = null; using (SQLiteCommand command = connection.CreateCommand()) { DBDwgFileCommands.SelectRow(command, relPath); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { model = GetFile(reader, connection); } reader.Close(); } return(model); }
public static long InsertRow(SQLiteConnection connection, ref DwgFileModel model) { using (SQLiteCommand command = connection.CreateCommand()) { DBDwgFileCommands.InsertRow(command, model); long check = command.ExecuteNonQuery(); if (check == 1) { return(connection.LastInsertRowId); } else if (check == 0) { throw new Exception("DBDwgFile -> insertRow -> No Row is inserted."); } throw new Exception("DBDwgFile -> insertRow -> Row insertion not successful."); } }
//This is to update the file row only. Other has to be done in Note. public static void UpdateRow(SQLiteConnection connection, DwgFileModel model) { using (SQLiteCommand command = connection.CreateCommand()) { DBDwgFileCommands.UpdateRow(command, model); long check = command.ExecuteNonQuery(); if (check == 1) { return; } else if (check == 0) { //throw new Exception("DBFixtureDetails -> UpdateRow -> No Row is Updated."); return; } throw new Exception("DBFixtureDetails -> UpdateRow -> Update Not Successful."); } }
public static DwgFileModel GetPNote(SQLiteConnection connection) { DwgFileModel model = null; using (SQLiteCommand command = connection.CreateCommand()) { DBDwgFileCommands.GetPNoteFile(command); using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read()) { model = GetFile(reader, connection); } reader.Close(); } } return(model); }
public static List <DwgFileModel> GetDwgFilesExceptPNote(SQLiteConnection connection) { List <DwgFileModel> dwgs = new List <DwgFileModel>(); using (SQLiteCommand command = connection.CreateCommand()) { DBDwgFileCommands.GetDwgFiles(command); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { DwgFileModel model = GetFile(reader, connection); dwgs.Add(model); } reader.Close(); } return(dwgs); }