public bool DeleteNavBarItem(int id, string conn) { using (MySqlConnection sConn = new MySqlConnection(conn)){ bool Result = false; SQLs.Clear(); SQLs.AppendLine("UPDATE CoreMVCBackend.NavBarItems "); SQLs.AppendLine("SET ItemStatus=3 "); SQLs.AppendLine("WHERE ID=@ID "); object param = new{ ID = id }; Result = sConn.Execute(SQLs.ToString(), param) == 0?false:true; return(Result); } }
public bool CreateNavBarItem(NavBarItemModel model, string conn) { using (MySqlConnection sConn = new MySqlConnection(conn)){ bool result = false; SQLs.Clear(); SQLs.AppendLine("INSERT INTO CoreMVCBackend.NavBarItems "); SQLs.AppendLine("(ItemName,ItemController,ItemAction,ItemStatus) "); SQLs.AppendLine("Values "); SQLs.AppendLine("(@ItemName,'NavBar',@ItemAction,@ItemStatus) "); object param = new{ ItemName = model.ItemName, ItemAction = model.ItemAction, ItemStatus = model.ItemStatus }; result = sConn.Execute(SQLs.ToString(), param) == 0?false:true; return(result); } }
public bool ModifyNavBarItem(NavBarItemModel model, string conn) { using (MySqlConnection sConn = new MySqlConnection(conn)){ bool result = false; SQLs.Clear(); SQLs.AppendLine("UPDATE CoreMVCBackend.NavBarItems "); SQLs.AppendLine("SET ItemName=@ItemName,ItemController=@ItemController, "); SQLs.AppendLine("ItemAction=@ItemAction,ItemStatus=@ItemStatus "); SQLs.AppendLine("WHERE "); SQLs.AppendLine("ID=@ID "); object param = new{ ID = model.ID, ItemName = model.ItemName, ItemController = model.ItemController, ItemAction = model.ItemAction, ItemStatus = model.ItemStatus }; result = sConn.Execute(SQLs.ToString(), param) == 0?false:true; return(result); } }