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