public IActionResult DropInitialize()
{
RawSql rawSql = new RawSql(_db);
try
{
object[] pram = new object[] { };
List <string> sql_ls = new List <string>();
sql_ls.Add(@"DROP DATABASE hmsDb");
//sql_ls.Add(@"DELETE FROM US_USER_ROLE");
//sql_ls.Add(@"DELETE FROM US_ROLE_MENU");
//sql_ls.Add(@"DELETE FROM US_USER");
//sql_ls.Add(@"DELETE FROM US_TYPE");
//sql_ls.Add(@"DELETE FROM US_ROLE");
//sql_ls.Add(@"DELETE FROM US_RELIGION");
//sql_ls.Add(@"DELETE FROM US_MARITAIL_STATUS");
//sql_ls.Add(@"DELETE FROM US_GENDER");
//sql_ls.Add(@"DELETE FROM US_BLOOD_GROUP");
//sql_ls.Add(@"DELETE FROM US_CHILD_MENU");
//sql_ls.Add(@"DELETE FROM US_PARENT_MENU");
//sql_ls.Add(@"DELETE FROM US_MODULE");
//sql_ls.Add(@"DELETE FROM US_EMAIL_SERVER");
//sql_ls.Add(@"DELETE FROM US_EMAIL_BOX");
foreach (string sql in sql_ls)
{
rawSql.ExecuteSqlCommand(sql, pram);
}
return(Content("Data Config Drop Iniliazation Succeeded"));
}
catch (Exception ex) { return(Content(ex.Message)); }
}
public IActionResult ExecuteSqlCommand()
{
RawSql obj = new RawSql(db);
var p1 = new SqlParameter("@p1", "New Value");
obj.ExecuteSqlCommand(query: @"update US_UNIT SET UNIT_NAME=@p1 WHERE ID=2", parameters: new object[] { p1 });
return(View());
}