public static void ScriptExecution(ServerDetails LineDetails) { StringBuilder sbSQLScript = new StringBuilder(); sbSQLScript.AppendLine(@" IF OBJECT_ID(N'app@Tables', N'U') IS NULL BEGIN CREATE TABLE app@Tables ( rowIdentity timestamp NOT NULL, aTIdentity bigint NOT NULL PRIMARY KEY IDENTITY, [object_id] int NOT NULL, [name] sysname NOT NULL, [create_date] datetime NOT NULL, [modify_date] datetime NOT NULL, CreatedOn datetime NOT NULL DEFAULT(GETDATE()), IsActive bit NOT NULL DEFAULT(1), IsBlock bit NOT NULL DEFAULT(0) ) END"); sbSQLScript.AppendLine(@" IF OBJECT_ID(N'sp$app@Tables$ReadAll', N'P') IS NULL BEGIN CREATE PROCEDURE sp$app@Tables$ReadAll @IsBlock BIT = NOT NULL AS BEGIN SELECT rowIdentity, aTIdentity, [object_id], [name], [create_date],[modify_date] FROM app@Tables WHERE IsActive = 1 AND IsBlock = @IsBlock END END"); asiSSMSTrans.ScriptExecutor(ServerDetails.sConnection(LineDetails), sbSQLScript.ToString()); }
public static List <asiTablesListModel> ReadAll(ServerDetails LineDetails) { asiTablesStruct.ScriptExecution(LineDetails); return((from DataRow dr in (asiSSMSTrans.FillDataTable(ServerDetails.sConnection(LineDetails), "sp$app@Tables$ReadAll", new object[] { false })).Rows select new asiTablesListModel { objectID = asiDataDefault.getInt64(dr["object_id"]), tableName = asiDataDefault.getString(dr["name"]) }).ToList()); }
public ActionResult IsValidAuth(ServerDetails LineDetails) { try { if (asiSSMSTrans.IsConnect(ServerDetails.sConnection(LineDetails))) { HttpContext.Session["ServerDetails"] = LineDetails; return(RedirectToAction("Index", "asiTables", LineDetails)); } else { return(View()); } } catch (Exception) { return(View()); } }
public static SqlConnection getConnection(ServerDetails LineServer) { return(ServerDetails.sConnection(LineServer)); }