//public static bool TruncateTable() //{ // connectionString = GetAppPath(@"\Zoiperdb.sdf"); // string query = "DELETE from TblPhoneContact"; // string dropConstraint = @"ALTER TABLE [TblPhoneContact] DROP CONSTRAINT [PK__TblPhoneContact__0000000000000019]"; // string dropIdColumn = "ALTER TABLE[TblPhoneContact] DROP COLUMN[Id]"; // string addIdColumn = @"ALTER TABLE [TblPhoneContact] ADD [Id] int IDENTITY (1,1) NOT NULL"; // string addIdConstraint = "ALTER TABLE[TblPhoneContact] ADD CONSTRAINT[PK__TblPhoneContact__0000000000000019] PRIMARY KEY ([Id])"; // bool result = false; // try // { // dbContext = new ZoiperdbContext(connectionString); // if (dbContext.DatabaseExists()) // { // int idropConstraint = dbContext.ExecuteCommand(dropConstraint); // if (idropConstraint >= 0) // result = true; // int idropIdColumn = dbContext.ExecuteCommand(dropIdColumn); // if (idropIdColumn >= 0) // result = true; // int iQuery = dbContext.ExecuteCommand(query); // if (iQuery >= 0) // result = true; // int iaddIdColumn = dbContext.ExecuteCommand(addIdColumn); // int iaddIdConstraint = dbContext.ExecuteCommand(addIdConstraint); // } // } // catch (Exception ex) // { // LibraryLog.WriteErrorLog(ex); // } // return result; //} /// <summary> /// Get User account for calling /// </summary> /// <returns></returns> public static string GetSettings() { string account = string.Empty; try { //AuthenticateConnectionToDB(); dbContext = new ZoiperdbContext(AuthenticateConnectionToDB()); TblZoiperSetting tblSetting = dbContext.TblZoiperSetting.FirstOrDefault(); account = tblSetting.CallerId + "@" + tblSetting.Domain; } catch (Exception ex) { LibraryLog.WriteErrorLog(ex); } return(account); }
public static int GetServiceDuration() { connectionString = GetAppPath(@"\Zoiperdb.sdf"); //GetPath(@"..\..\SqlData\Zoiperdb.sdf"); dbContext = new ZoiperdbContext(connectionString); int duration = 0; try { TblZoiperSetting setting = dbContext.TblZoiperSetting.FirstOrDefault(); duration = setting.ServiceDuration; } catch (Exception ex) { logger.Error(ex, ex?.Message); LibraryLog.WriteErrorLog(ex); duration = Convert.ToInt32(false); } return(duration); }