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